Rev 433 | Blame | Last modification | View Log | RSS feed
INSERT INTO `gen_application` ( `gap_id_application` , `gap_nom` , `gap_description` , `gap_chemin` , `gap_bool_applette` )
VALUES (
'30', 'Integrateur - wikini', 'Permet d''insérer des pages d''un wikini.', 'client/integrateur_wikini/integrateur_wikini.php', '0'
);
INSERT INTO `gen_application` ( `gap_id_application` , `gap_nom` , `gap_description` , `gap_chemin` , `gap_bool_applette` )
VALUES (
'31', 'Administration - Wikini', 'Administration Wikini', 'client/integrateur_wikini/admin_wikini.php', '0'
)
CREATE TABLE `gen_dummy_wikini_acls` (
`page_tag` varchar(50) NOT NULL default '',
`privilege` varchar(20) NOT NULL default '',
`list` text NOT NULL,
PRIMARY KEY (`page_tag`,`privilege`)
);
CREATE TABLE `gen_dummy_wikini_links` (
`from_tag` char(50) NOT NULL default '',
`to_tag` char(50) NOT NULL default '',
UNIQUE KEY `from_tag` (`from_tag`,`to_tag`),
KEY `idx_from` (`from_tag`),
KEY `idx_to` (`to_tag`)
);
CREATE TABLE `gen_dummy_wikini_pages` (
`id` int(10) unsigned NOT NULL auto_increment,
`tag` varchar(50) NOT NULL default '',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
`body` text NOT NULL,
`body_r` text NOT NULL,
`owner` varchar(50) NOT NULL default '',
`user` varchar(50) NOT NULL default '',
`latest` enum('Y','N') NOT NULL default 'N',
`handler` varchar(30) NOT NULL default 'page',
`comment_on` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `idx_tag` (`tag`),
KEY `idx_time` (`time`),
KEY `idx_latest` (`latest`),
KEY `idx_comment_on` (`comment_on`),
FULLTEXT KEY `tag` (`tag`,`body`)
);
CREATE TABLE `gen_dummy_wikini_referrers` (
`page_tag` char(50) NOT NULL default '',
`referrer` char(150) NOT NULL default '',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
KEY `idx_page_tag` (`page_tag`),
KEY `idx_time` (`time`)
);
CREATE TABLE `gen_dummy_wikini_users` (
`name` varchar(80) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`motto` text NOT NULL,
`revisioncount` int(10) unsigned NOT NULL default '20',
`changescount` int(10) unsigned NOT NULL default '50',
`doubleclickedit` enum('Y','N') NOT NULL default 'Y',
`signuptime` datetime NOT NULL default '0000-00-00 00:00:00',
`show_comments` enum('Y','N') NOT NULL default 'N',
PRIMARY KEY (`name`),
KEY `idx_name` (`name`),
KEY `idx_signuptime` (`signuptime`)
);
CREATE TABLE `gen_wikini` (
`gewi_id_wikini` int(11) NOT NULL default '0',
`gewi_code_alpha_wikini` varchar(20) NOT NULL default '',
`gewi_bdd_hote` varchar(20) NOT NULL default '',
`gewi_bdd_nom` varchar(20) NOT NULL default '',
`gewi_bdd_utilisateur` varchar(20) NOT NULL default '',
`gewi_bdd_mdp` varchar(20) NOT NULL default '',
`gewi_table_prefix` varchar(20) NOT NULL default '',
`gewi_page` varchar(20) NOT NULL default '',
`gewi_chemin` mediumtext NOT NULL,
PRIMARY KEY (`gewi_id_wikini`)
) ;