[Gambas-devel] gambas wiki db scheme

[Benoît Minisini]

Le 18/09/2012 22:36, Benoît Minisini a écrit :
>
> As for the database schema, I am currently downloading a database dump
> from the wiki and I will tell you. Not very complex...
>

CREATE TABLE `page` (
   `spath` varchar(255) NOT NULL default '', --> url path
   `slang` varchar(8) NOT NULL default '', --> language code
   `ddate` datetime default NULL, --> last modification date
   `stitle` varchar(128) default NULL, --> page title
   `sdesc` text, --> page contents
   `sdata` longblob, --> image for an image page
   `shtml` text, --> page contents translated to html
   `suser` varchar(16) default NULL, --> user that modified the page
   `brefresh` tinyint(1) NOT NULL default '0', --> invalidate 'shtml'
   PRIMARY KEY  (`spath`,`slang`),
   KEY `page_index1` (`slang`,`stitle`),
   KEY `page_index2` (`slang`,`ddate`)
) TYPE=InnoDB;

CREATE TABLE `archive` ( --> undo contents of `page`
   `spath` varchar(255) NOT NULL default '',
   `slang` varchar(8) NOT NULL default '',
   `ddate` datetime NOT NULL default '0000-00-00 00:00:00',
   `stitle` varchar(128) default NULL,
   `sdesc` text,
   `sdata` longblob,
   `suser` varchar(16) default NULL,
   PRIMARY KEY  (`spath`,`slang`,`ddate`)
) TYPE=InnoDB;

-- 
Benoît Minisini