WebSVN – Applications.papyrus – Diff – /trunk/client/integrateur_wikini/documentation/integrateur_wikini_v0.24.sql


INSERT INTO `gen_application` ( `gap_id_application` , `gap_nom` , `gap_description` , `gap_chemin` , `gap_bool_applette` )
VALUES (
'16', '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 (17, 'Administrateur des Wikinis', 'Administrateur des Wikinis', '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( 255 )  NOT NULL,
  `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(255) NOT NULL default '',
  `gewi_page` varchar(20) NOT NULL default '',
  `gewi_chemin` varchar (100) NOT NULL,
  PRIMARY KEY  (`gewi_id_wikini`)
) ;

Subversion Repositories Applications.papyrus

(root)/trunk/client/integrateur_wikini/documentation/integrateur_wikini_v0.24.sql – Rev 1013 → 1070

Rev 1013		Rev 1070
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	`) ;`