1 |
INSERT INTO `gen_application` ( `gap_id_application` , `gap_nom` , `gap_description` , `gap_chemin` , `gap_bool_applette` )
|
1 |
INSERT INTO `gen_application` ( `gap_id_application` , `gap_nom` , `gap_description` , `gap_chemin` , `gap_bool_applette` )
|
2 |
VALUES (
|
2 |
VALUES (
|
3 |
'16', 'Integrateur Wikini', 'Permet d''insérer des pages d''un wikini.', 'client/integrateur_wikini/integrateur_wikini.php', '0'
|
3 |
'16', 'Integrateur Wikini', 'Permet d''insérer des pages d''un wikini.', 'client/integrateur_wikini/integrateur_wikini.php', '0'
|
4 |
);
|
4 |
);
|
5 |
INSERT INTO `gen_application` ( `gap_id_application` , `gap_nom` , `gap_description` , `gap_chemin` , `gap_bool_applette` )
|
5 |
INSERT INTO `gen_application` ( `gap_id_application` , `gap_nom` , `gap_description` , `gap_chemin` , `gap_bool_applette` )
|
6 |
VALUES (
|
- |
|
7 |
'17', 'Administration - Wikini', 'Administration Wikini', 'client/integrateur_wikini/admin_wikini.php', '0'
|
6 |
VALUES (17, 'Administrateur des Wikinis', 'Administrateur des Wikinis', 'client/integrateur_wikini/admin_wikini.php', 0);
|
8 |
) ;
|
- |
|
9 |
|
7 |
|
10 |
CREATE TABLE `gen_dummy_wikini_acls` (
|
8 |
CREATE TABLE `gen_dummy_wikini_acls` (
|
11 |
`page_tag` varchar(50) NOT NULL default '',
|
9 |
`page_tag` varchar(50) NOT NULL default '',
|
12 |
`privilege` varchar(20) NOT NULL default '',
|
10 |
`privilege` varchar(20) NOT NULL default '',
|
13 |
`list` text NOT NULL,
|
11 |
`list` text NOT NULL,
|
14 |
PRIMARY KEY (`page_tag`,`privilege`)
|
12 |
PRIMARY KEY (`page_tag`,`privilege`)
|
15 |
);
|
13 |
);
|
16 |
|
14 |
|
17 |
|
15 |
|
18 |
CREATE TABLE `gen_dummy_wikini_links` (
|
16 |
CREATE TABLE `gen_dummy_wikini_links` (
|
19 |
`from_tag` char(50) NOT NULL default '',
|
17 |
`from_tag` char(50) NOT NULL default '',
|
20 |
`to_tag` char(50) NOT NULL default '',
|
18 |
`to_tag` char(50) NOT NULL default '',
|
21 |
UNIQUE KEY `from_tag` (`from_tag`,`to_tag`),
|
19 |
UNIQUE KEY `from_tag` (`from_tag`,`to_tag`),
|
22 |
KEY `idx_from` (`from_tag`),
|
20 |
KEY `idx_from` (`from_tag`),
|
23 |
KEY `idx_to` (`to_tag`)
|
21 |
KEY `idx_to` (`to_tag`)
|
24 |
);
|
22 |
);
|
25 |
|
23 |
|
26 |
CREATE TABLE `gen_dummy_wikini_pages` (
|
24 |
CREATE TABLE `gen_dummy_wikini_pages` (
|
27 |
`id` int(10) unsigned NOT NULL auto_increment,
|
25 |
`id` int(10) unsigned NOT NULL auto_increment,
|
28 |
`tag` varchar(50) NOT NULL default '',
|
26 |
`tag` varchar(50) NOT NULL default '',
|
29 |
`time` datetime NOT NULL default '0000-00-00 00:00:00',
|
27 |
`time` datetime NOT NULL default '0000-00-00 00:00:00',
|
30 |
`body` text NOT NULL,
|
28 |
`body` text NOT NULL,
|
31 |
`body_r` text NOT NULL,
|
29 |
`body_r` text NOT NULL,
|
32 |
`owner` varchar(50) NOT NULL default '',
|
30 |
`owner` varchar(50) NOT NULL default '',
|
33 |
`user` varchar(50) NOT NULL default '',
|
31 |
`user` varchar(50) NOT NULL default '',
|
34 |
`latest` enum('Y','N') NOT NULL default 'N',
|
32 |
`latest` enum('Y','N') NOT NULL default 'N',
|
35 |
`handler` varchar(30) NOT NULL default 'page',
|
33 |
`handler` varchar(30) NOT NULL default 'page',
|
36 |
`comment_on` varchar(50) NOT NULL default '',
|
34 |
`comment_on` varchar(50) NOT NULL default '',
|
37 |
PRIMARY KEY (`id`),
|
35 |
PRIMARY KEY (`id`),
|
38 |
KEY `idx_tag` (`tag`),
|
36 |
KEY `idx_tag` (`tag`),
|
39 |
KEY `idx_time` (`time`),
|
37 |
KEY `idx_time` (`time`),
|
40 |
KEY `idx_latest` (`latest`),
|
38 |
KEY `idx_latest` (`latest`),
|
41 |
KEY `idx_comment_on` (`comment_on`),
|
39 |
KEY `idx_comment_on` (`comment_on`),
|
42 |
FULLTEXT KEY `tag` (`tag`,`body`)
|
40 |
FULLTEXT KEY `tag` (`tag`,`body`)
|
43 |
);
|
41 |
);
|
44 |
|
42 |
|
45 |
CREATE TABLE `gen_dummy_wikini_referrers` (
|
43 |
CREATE TABLE `gen_dummy_wikini_referrers` (
|
46 |
`page_tag` char(50) NOT NULL default '',
|
44 |
`page_tag` char(50) NOT NULL default '',
|
47 |
`referrer` char(150) NOT NULL default '',
|
45 |
`referrer` char(150) NOT NULL default '',
|
48 |
`time` datetime NOT NULL default '0000-00-00 00:00:00',
|
46 |
`time` datetime NOT NULL default '0000-00-00 00:00:00',
|
49 |
KEY `idx_page_tag` (`page_tag`),
|
47 |
KEY `idx_page_tag` (`page_tag`),
|
50 |
KEY `idx_time` (`time`)
|
48 |
KEY `idx_time` (`time`)
|
51 |
);
|
49 |
);
|
52 |
|
50 |
|
53 |
|
51 |
|
54 |
CREATE TABLE `gen_dummy_wikini_users` (
|
52 |
CREATE TABLE `gen_dummy_wikini_users` (
|
55 |
`name` varchar(80) NOT NULL default '',
|
53 |
`name` varchar(80) NOT NULL default '',
|
56 |
`password` varchar(32) NOT NULL default '',
|
54 |
`password` varchar(32) NOT NULL default '',
|
57 |
`email` varchar(50) NOT NULL default '',
|
55 |
`email` varchar(50) NOT NULL default '',
|
58 |
`motto` text NOT NULL,
|
56 |
`motto` text NOT NULL,
|
59 |
`revisioncount` int(10) unsigned NOT NULL default '20',
|
57 |
`revisioncount` int(10) unsigned NOT NULL default '20',
|
60 |
`changescount` int(10) unsigned NOT NULL default '50',
|
58 |
`changescount` int(10) unsigned NOT NULL default '50',
|
61 |
`doubleclickedit` enum('Y','N') NOT NULL default 'Y',
|
59 |
`doubleclickedit` enum('Y','N') NOT NULL default 'Y',
|
62 |
`signuptime` datetime NOT NULL default '0000-00-00 00:00:00',
|
60 |
`signuptime` datetime NOT NULL default '0000-00-00 00:00:00',
|
63 |
`show_comments` enum('Y','N') NOT NULL default 'N',
|
61 |
`show_comments` enum('Y','N') NOT NULL default 'N',
|
64 |
PRIMARY KEY (`name`),
|
62 |
PRIMARY KEY (`name`),
|
65 |
KEY `idx_name` (`name`),
|
63 |
KEY `idx_name` (`name`),
|
66 |
KEY `idx_signuptime` (`signuptime`)
|
64 |
KEY `idx_signuptime` (`signuptime`)
|
67 |
);
|
65 |
);
|
68 |
|
66 |
|
69 |
CREATE TABLE `gen_wikini` (
|
67 |
CREATE TABLE `gen_wikini` (
|
70 |
`gewi_id_wikini` int(11) NOT NULL default '0',
|
68 |
`gewi_id_wikini` int(11) NOT NULL default '0',
|
71 |
`gewi_code_alpha_wikini` VARCHAR( 255 ) NOT NULL,
|
69 |
`gewi_code_alpha_wikini` VARCHAR( 255 ) NOT NULL,
|
72 |
`gewi_bdd_hote` varchar(20) NOT NULL default '',
|
70 |
`gewi_bdd_hote` varchar(20) NOT NULL default '',
|
73 |
`gewi_bdd_nom` varchar(20) NOT NULL default '',
|
71 |
`gewi_bdd_nom` varchar(20) NOT NULL default '',
|
74 |
`gewi_bdd_utilisateur` varchar(20) NOT NULL default '',
|
72 |
`gewi_bdd_utilisateur` varchar(20) NOT NULL default '',
|
75 |
`gewi_bdd_mdp` varchar(20) NOT NULL default '',
|
73 |
`gewi_bdd_mdp` varchar(20) NOT NULL default '',
|
76 |
`gewi_table_prefix` varchar(255) NOT NULL default '',
|
74 |
`gewi_table_prefix` varchar(255) NOT NULL default '',
|
77 |
`gewi_page` varchar(20) NOT NULL default '',
|
75 |
`gewi_page` varchar(20) NOT NULL default '',
|
78 |
`gewi_chemin` varchar (100) NOT NULL,
|
76 |
`gewi_chemin` varchar (100) NOT NULL,
|
79 |
PRIMARY KEY (`gewi_id_wikini`)
|
77 |
PRIMARY KEY (`gewi_id_wikini`)
|
80 |
) ;
|
78 |
) ;
|