WebSVN – Applications.papyrus – Diff – /branches/livraison_menes/papyrus/installation/papyrus_v0.24.sql



  `ga_prenom` varchar(32) NOT NULL default '',
  `ga_mot_de_passe` varchar(32) NOT NULL default 'X X',
  `ga_mail` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`ga_id_administrateur`),
  KEY `gen_annuaire_FKIndex1` (`ga_ce_i18n`)
)

 
-- 
-- Contenu de la table `gen_annuaire`

  `gap_nom` varchar(100) NOT NULL default '',
  `gap_description` mediumtext NOT NULL,
  `gap_chemin` varchar(255) NOT NULL default '',
  `gap_bool_applette` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`gap_id_application`)
)

 
-- 
-- Contenu de la table `gen_application`

  `gi_jeu_de_caracteres` varchar(50) default NULL,
  `gi_nom` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`gi_id_i18n`),
  KEY `gen_i18n_FKIndex1` (`gi_ce_pays`),
  KEY `gen_i18n_FKIndex2` (`gi_ce_langue`)
)

 
-- 
-- Contenu de la table `gen_i18n`

CREATE TABLE `gen_i18n_langue` (
  `gil_id_langue` char(2) NOT NULL default '',
  `gil_nom` varchar(255) default NULL,
  `gil_direction` varchar(20) default NULL,
  PRIMARY KEY  (`gil_id_langue`)
)

 
-- 
-- Contenu de la table `gen_i18n_langue`

  `gm_ce_admin` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`gm_id_menu`),
  KEY `gen_menu_FKIndex2` (`gm_ce_admin`),
  KEY `gen_menu_FKIndex3` (`gm_ce_application`),
  KEY `gen_menu_FKIndex4` (`gm_ce_i18n`)
 
)

 
-- 
-- Contenu de la table `gen_menu`

  `gmcac_corps` longblob NOT NULL,
  `gmcac_date_heure` datetime NOT NULL default '0000-00-00 00:00:00',
  `gmcac_taille` int(11) NOT NULL default '0',
  `gmcac_gz_taille` int(11) NOT NULL default '0',
  PRIMARY KEY  (`gmcac_id_md5_url`)
 
)

 
-- 
-- Contenu de la table `gen_menu_cache`

 
CREATE TABLE `gen_menu_categorie` (
  `gmca_id_categorie` int(10) unsigned NOT NULL auto_increment,
  `gmca_intitule_categorie` varchar(255) default NULL,
 
  PRIMARY KEY  (`gmca_id_categorie`)

)
 
-- 

  `gmcv_id_valeur` int(11) unsigned NOT NULL auto_increment,
  `gmcv_id_categorie` int(10) unsigned NOT NULL default '0',
  `gmcv_intitule_valeur` varchar(255) default NULL,
  PRIMARY KEY  (`gmcv_id_valeur`),
  KEY `gen_menu_categorie_valeur_FKIndex1` (`gmcv_id_categorie`)
 
)

 
-- 
-- Contenu de la table `gen_menu_categorie_valeur`

  `gmc_date_modification` datetime default NULL,
  `gmc_bool_dernier` tinyint(1) unsigned default '1',
  PRIMARY KEY  (`gmc_id_contenu`),
  KEY `gen_menu_contenu_FKIndex2` (`gmc_ce_menu`),
  KEY `idx_fk_gp_ce_admin` (`gmc_ce_admin`)
 
)

 
-- 
-- Contenu de la table `gen_menu_contenu`

  `gmr_id_valeur` int(11) unsigned NOT NULL default '0',
  `gmr_ordre` int(11) unsigned default NULL,
  PRIMARY KEY  (`gmr_id_menu_01`,`gmr_id_menu_02`,`gmr_id_valeur`),
  KEY `gen_menu_relation_FKIndex2` (`gmr_id_menu_01`),
  KEY `gen_menu_relation_FKIndex3` (`gmr_id_valeur`)
 
)

 
-- 
-- Contenu de la table `gen_menu_relation`

  `gmua_id_url` int(11) unsigned NOT NULL default '0',
  `gmua_ce_menu` int(11) unsigned NOT NULL default '0',
  `gmua_url` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`gmua_id_url`),
  KEY `gen_menu_url_alternative_FKIndex1` (`gmua_ce_menu`)
 
)

 
-- 
-- Contenu de la table `gen_menu_url_alternative`

  `gs_auteur` varchar(255) default NULL,
  `gs_date_creation` datetime default NULL,
  `gs_url` varchar(255),
  `gs_fichier_squelette` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`gs_id_site`)
)

 
-- 
-- Contenu de la table `gen_site`

  `gsa_ce_auth_ldap` int(10) unsigned NOT NULL default '0',
  `gsa_ce_type_auth` int(11) unsigned default NULL,
  PRIMARY KEY  (`gsa_id_auth`),
  KEY `idx_fk_gsa_ce_auth_ldap` (`gsa_ce_auth_ldap`),
  KEY `idx_fk_gsa_ce_auth_bdd` (`gsa_ce_auth_bdd`)
)

 
-- 
-- Contenu de la table `gen_site_auth`
-- 

  `gsab_nom_champ_login` varchar(100) default NULL,
  `gsab_nom_champ_mdp` varchar(100) default NULL,
  `gsab_cryptage_mdp` varchar(100) default NULL,
  `gsab_parametres` varchar(255),
  PRIMARY KEY  (`gsab_id_auth_bdd`)
)

 
-- 
-- Contenu de la table `gen_site_auth_bdd`

  `gsal_serveur` varchar(100) default NULL,
  `gsal_port` int(11) unsigned default NULL,
  `gsal_base_dn` varchar(255) default NULL,
  `gsal_uid` varchar(100) default NULL,
  PRIMARY KEY  (`gsal_id_auth_ldap`)
)

 
-- 
-- Contenu de la table `gen_site_auth_ldap`

 
CREATE TABLE `gen_site_categorie` (
  `gsc_id_categorie` int(10) unsigned NOT NULL auto_increment,
  `gsc_intitule_categorie` varchar(255) default NULL,
  PRIMARY KEY  (`gsc_id_categorie`)

)
 
-- 

CREATE TABLE `gen_site_categorie_valeur` (
  `gscv_id_valeur` int(11) unsigned NOT NULL auto_increment,
  `gscv_id_categorie` int(10) unsigned NOT NULL default '0',
  `gscv_intitule_valeur` varchar(255) default NULL,
  PRIMARY KEY  (`gscv_id_valeur`)
)

 
-- 
-- Contenu de la table `gen_site_categorie_valeur`

  `gsr_id_site_01` int(11) unsigned NOT NULL default '0',
  `gsr_id_site_02` int(11) unsigned NOT NULL default '0',
  `gsr_id_valeur` int(11) unsigned NOT NULL default '0',
  `gsr_ordre` int(11) unsigned default NULL,
  PRIMARY KEY  (`gsr_id_site_01`,`gsr_id_site_02`,`gsr_id_valeur`)
)

 
-- 
-- Contenu de la table `gen_site_relation`

Subversion Repositories Applications.papyrus

(root)/branches/livraison_menes/papyrus/installation/papyrus_v0.24.sql – Rev 1087 → 1098

Rev 1087		Rev 1098
Line 9...		Line 9...
9	`ga_prenom` varchar(32) NOT NULL default '',	9	`ga_prenom` varchar(32) NOT NULL default '',
10	`ga_mot_de_passe` varchar(32) NOT NULL default 'X X',	10	`ga_mot_de_passe` varchar(32) NOT NULL default 'X X',
11	`ga_mail` varchar(128) NOT NULL default '',	11	`ga_mail` varchar(128) NOT NULL default '',
12	PRIMARY KEY (`ga_id_administrateur`),	12	PRIMARY KEY (`ga_id_administrateur`),
13	KEY `gen_annuaire_FKIndex1` (`ga_ce_i18n`)	13	KEY `gen_annuaire_FKIndex1` (`ga_ce_i18n`)
14	`) TYPE=MyISAM;`	14	`)`
Line 15...		Line 15...
15		15
16	`--`	16	`--`
17	-- Contenu de la table `gen_annuaire`	17	-- Contenu de la table `gen_annuaire`
Line 30...		Line 30...
30	`gap_nom` varchar(100) NOT NULL default '',	30	`gap_nom` varchar(100) NOT NULL default '',
31	`gap_description` mediumtext NOT NULL,	31	`gap_description` mediumtext NOT NULL,
32	`gap_chemin` varchar(255) NOT NULL default '',	32	`gap_chemin` varchar(255) NOT NULL default '',
33	`gap_bool_applette` tinyint(1) unsigned NOT NULL default '0',	33	`gap_bool_applette` tinyint(1) unsigned NOT NULL default '0',
34	PRIMARY KEY (`gap_id_application`)	34	PRIMARY KEY (`gap_id_application`)
35	`) TYPE=MyISAM;`	35	`)`
Line 36...		Line 36...
36		36
37	`--`	37	`--`
38	-- Contenu de la table `gen_application`	38	-- Contenu de la table `gen_application`
Line 65...		Line 65...
65	`gi_jeu_de_caracteres` varchar(50) default NULL,	65	`gi_jeu_de_caracteres` varchar(50) default NULL,
66	`gi_nom` varchar(255) NOT NULL default '',	66	`gi_nom` varchar(255) NOT NULL default '',
67	PRIMARY KEY (`gi_id_i18n`),	67	PRIMARY KEY (`gi_id_i18n`),
68	KEY `gen_i18n_FKIndex1` (`gi_ce_pays`),	68	KEY `gen_i18n_FKIndex1` (`gi_ce_pays`),
69	KEY `gen_i18n_FKIndex2` (`gi_ce_langue`)	69	KEY `gen_i18n_FKIndex2` (`gi_ce_langue`)
70	`) TYPE=MyISAM;`	70	`)`
Line 71...		Line 71...
71		71
72	`--`	72	`--`
73	-- Contenu de la table `gen_i18n`	73	-- Contenu de la table `gen_i18n`
Line 85...		Line 85...
85	CREATE TABLE `gen_i18n_langue` (	85	CREATE TABLE `gen_i18n_langue` (
86	`gil_id_langue` char(2) NOT NULL default '',	86	`gil_id_langue` char(2) NOT NULL default '',
87	`gil_nom` varchar(255) default NULL,	87	`gil_nom` varchar(255) default NULL,
88	`gil_direction` varchar(20) default NULL,	88	`gil_direction` varchar(20) default NULL,
89	PRIMARY KEY (`gil_id_langue`)	89	PRIMARY KEY (`gil_id_langue`)
90	`) TYPE=MyISAM;`	90	`)`
Line 91...		Line 91...
91		91
92	`--`	92	`--`
93	-- Contenu de la table `gen_i18n_langue`	93	-- Contenu de la table `gen_i18n_langue`
Line 137...		Line 137...
137	`gm_ce_admin` int(11) unsigned NOT NULL default '0',	137	`gm_ce_admin` int(11) unsigned NOT NULL default '0',
138	PRIMARY KEY (`gm_id_menu`),	138	PRIMARY KEY (`gm_id_menu`),
139	KEY `gen_menu_FKIndex2` (`gm_ce_admin`),	139	KEY `gen_menu_FKIndex2` (`gm_ce_admin`),
140	KEY `gen_menu_FKIndex3` (`gm_ce_application`),	140	KEY `gen_menu_FKIndex3` (`gm_ce_application`),
141	KEY `gen_menu_FKIndex4` (`gm_ce_i18n`)	141	KEY `gen_menu_FKIndex4` (`gm_ce_i18n`)
142	`) ENGINE=MyISAM DEFAULT CHARSET=latin1;`	-
-		142	`)`
Line 143...		Line 143...
143		143
144	`--`	144	`--`
145	-- Contenu de la table `gen_menu`	145	-- Contenu de la table `gen_menu`
Line 169...		Line 169...
169	`gmcac_corps` longblob NOT NULL,	169	`gmcac_corps` longblob NOT NULL,
170	`gmcac_date_heure` datetime NOT NULL default '0000-00-00 00:00:00',	170	`gmcac_date_heure` datetime NOT NULL default '0000-00-00 00:00:00',
171	`gmcac_taille` int(11) NOT NULL default '0',	171	`gmcac_taille` int(11) NOT NULL default '0',
172	`gmcac_gz_taille` int(11) NOT NULL default '0',	172	`gmcac_gz_taille` int(11) NOT NULL default '0',
173	PRIMARY KEY (`gmcac_id_md5_url`)	173	PRIMARY KEY (`gmcac_id_md5_url`)
174	`) ENGINE=MyISAM DEFAULT CHARSET=latin1;`	-
-		174	`)`
Line 175...		Line 175...
175		175
176	`--`	176	`--`
177	-- Contenu de la table `gen_menu_cache`	177	-- Contenu de la table `gen_menu_cache`
Line 186...		Line 186...
186		186
187	CREATE TABLE `gen_menu_categorie` (	187	CREATE TABLE `gen_menu_categorie` (
188	`gmca_id_categorie` int(10) unsigned NOT NULL auto_increment,	188	`gmca_id_categorie` int(10) unsigned NOT NULL auto_increment,
189	`gmca_intitule_categorie` varchar(255) default NULL,	189	`gmca_intitule_categorie` varchar(255) default NULL,
190	PRIMARY KEY (`gmca_id_categorie`)	-
-		190	PRIMARY KEY (`gmca_id_categorie`)
Line 191...		Line 191...
191	`) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;`	191	`)`
192		192
193	`--`	193	`--`
Line 208...		Line 208...
208	`gmcv_id_valeur` int(11) unsigned NOT NULL auto_increment,	208	`gmcv_id_valeur` int(11) unsigned NOT NULL auto_increment,
209	`gmcv_id_categorie` int(10) unsigned NOT NULL default '0',	209	`gmcv_id_categorie` int(10) unsigned NOT NULL default '0',
210	`gmcv_intitule_valeur` varchar(255) default NULL,	210	`gmcv_intitule_valeur` varchar(255) default NULL,
211	PRIMARY KEY (`gmcv_id_valeur`),	211	PRIMARY KEY (`gmcv_id_valeur`),
212	KEY `gen_menu_categorie_valeur_FKIndex1` (`gmcv_id_categorie`)	212	KEY `gen_menu_categorie_valeur_FKIndex1` (`gmcv_id_categorie`)
213	`) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=105 ;`	-
-		213	`)`
Line 214...		Line 214...
214		214
215	`--`	215	`--`
216	-- Contenu de la table `gen_menu_categorie_valeur`	216	-- Contenu de la table `gen_menu_categorie_valeur`
Line 244...		Line 244...
244	`gmc_date_modification` datetime default NULL,	244	`gmc_date_modification` datetime default NULL,
245	`gmc_bool_dernier` tinyint(1) unsigned default '1',	245	`gmc_bool_dernier` tinyint(1) unsigned default '1',
246	PRIMARY KEY (`gmc_id_contenu`),	246	PRIMARY KEY (`gmc_id_contenu`),
247	KEY `gen_menu_contenu_FKIndex2` (`gmc_ce_menu`),	247	KEY `gen_menu_contenu_FKIndex2` (`gmc_ce_menu`),
248	KEY `idx_fk_gp_ce_admin` (`gmc_ce_admin`)	248	KEY `idx_fk_gp_ce_admin` (`gmc_ce_admin`)
249	`) ENGINE=MyISAM DEFAULT CHARSET=latin1;`	-
-		249	`)`
Line 250...		Line 250...
250		250
251	`--`	251	`--`
252	-- Contenu de la table `gen_menu_contenu`	252	-- Contenu de la table `gen_menu_contenu`
Line 269...		Line 269...
269	`gmr_id_valeur` int(11) unsigned NOT NULL default '0',	269	`gmr_id_valeur` int(11) unsigned NOT NULL default '0',
270	`gmr_ordre` int(11) unsigned default NULL,	270	`gmr_ordre` int(11) unsigned default NULL,
271	PRIMARY KEY (`gmr_id_menu_01`,`gmr_id_menu_02`,`gmr_id_valeur`),	271	PRIMARY KEY (`gmr_id_menu_01`,`gmr_id_menu_02`,`gmr_id_valeur`),
272	KEY `gen_menu_relation_FKIndex2` (`gmr_id_menu_01`),	272	KEY `gen_menu_relation_FKIndex2` (`gmr_id_menu_01`),
273	KEY `gen_menu_relation_FKIndex3` (`gmr_id_valeur`)	273	KEY `gen_menu_relation_FKIndex3` (`gmr_id_valeur`)
274	`) ENGINE=MyISAM DEFAULT CHARSET=latin1;`	-
-		274	`)`
Line 275...		Line 275...
275		275
276	`--`	276	`--`
277	-- Contenu de la table `gen_menu_relation`	277	-- Contenu de la table `gen_menu_relation`
Line 310...		Line 310...
310	`gmua_id_url` int(11) unsigned NOT NULL default '0',	310	`gmua_id_url` int(11) unsigned NOT NULL default '0',
311	`gmua_ce_menu` int(11) unsigned NOT NULL default '0',	311	`gmua_ce_menu` int(11) unsigned NOT NULL default '0',
312	`gmua_url` varchar(255) NOT NULL default '',	312	`gmua_url` varchar(255) NOT NULL default '',
313	PRIMARY KEY (`gmua_id_url`),	313	PRIMARY KEY (`gmua_id_url`),
314	KEY `gen_menu_url_alternative_FKIndex1` (`gmua_ce_menu`)	314	KEY `gen_menu_url_alternative_FKIndex1` (`gmua_ce_menu`)
315	`) ENGINE=MyISAM DEFAULT CHARSET=latin1;`	-
-		315	`)`
Line 316...		Line 316...
316		316
317	`--`	317	`--`
318	-- Contenu de la table `gen_menu_url_alternative`	318	-- Contenu de la table `gen_menu_url_alternative`
Line 341...		Line 341...
341	`gs_auteur` varchar(255) default NULL,	341	`gs_auteur` varchar(255) default NULL,
342	`gs_date_creation` datetime default NULL,	342	`gs_date_creation` datetime default NULL,
343	`gs_url` varchar(255),	343	`gs_url` varchar(255),
344	`gs_fichier_squelette` varchar(255) NOT NULL default '',	344	`gs_fichier_squelette` varchar(255) NOT NULL default '',
345	PRIMARY KEY (`gs_id_site`)	345	PRIMARY KEY (`gs_id_site`)
346	`) TYPE=MyISAM;`	346	`)`
Line 347...		Line 347...
347		347
348	`--`	348	`--`
349	-- Contenu de la table `gen_site`	349	-- Contenu de la table `gen_site`
Line 365...		Line 365...
365	`gsa_ce_auth_ldap` int(10) unsigned NOT NULL default '0',	365	`gsa_ce_auth_ldap` int(10) unsigned NOT NULL default '0',
366	`gsa_ce_type_auth` int(11) unsigned default NULL,	366	`gsa_ce_type_auth` int(11) unsigned default NULL,
367	PRIMARY KEY (`gsa_id_auth`),	367	PRIMARY KEY (`gsa_id_auth`),
368	KEY `idx_fk_gsa_ce_auth_ldap` (`gsa_ce_auth_ldap`),	368	KEY `idx_fk_gsa_ce_auth_ldap` (`gsa_ce_auth_ldap`),
369	KEY `idx_fk_gsa_ce_auth_bdd` (`gsa_ce_auth_bdd`)	369	KEY `idx_fk_gsa_ce_auth_bdd` (`gsa_ce_auth_bdd`)
370	`) TYPE=MyISAM;`	370	`)`
Line 371...		Line 371...
371		371
372	`--`	372	`--`
373	-- Contenu de la table `gen_site_auth`	373	-- Contenu de la table `gen_site_auth`
374	`--`	374	`--`
Line 389...		Line 389...
389	`gsab_nom_champ_login` varchar(100) default NULL,	389	`gsab_nom_champ_login` varchar(100) default NULL,
390	`gsab_nom_champ_mdp` varchar(100) default NULL,	390	`gsab_nom_champ_mdp` varchar(100) default NULL,
391	`gsab_cryptage_mdp` varchar(100) default NULL,	391	`gsab_cryptage_mdp` varchar(100) default NULL,
392	`gsab_parametres` varchar(255),	392	`gsab_parametres` varchar(255),
393	PRIMARY KEY (`gsab_id_auth_bdd`)	393	PRIMARY KEY (`gsab_id_auth_bdd`)
394	`) TYPE=MyISAM;`	394	`)`
Line 395...		Line 395...
395		395
396	`--`	396	`--`
397	-- Contenu de la table `gen_site_auth_bdd`	397	-- Contenu de la table `gen_site_auth_bdd`
Line 410...		Line 410...
410	`gsal_serveur` varchar(100) default NULL,	410	`gsal_serveur` varchar(100) default NULL,
411	`gsal_port` int(11) unsigned default NULL,	411	`gsal_port` int(11) unsigned default NULL,
412	`gsal_base_dn` varchar(255) default NULL,	412	`gsal_base_dn` varchar(255) default NULL,
413	`gsal_uid` varchar(100) default NULL,	413	`gsal_uid` varchar(100) default NULL,
414	PRIMARY KEY (`gsal_id_auth_ldap`)	414	PRIMARY KEY (`gsal_id_auth_ldap`)
415	`) TYPE=MyISAM;`	415	`)`
Line 416...		Line 416...
416		416
417	`--`	417	`--`
418	-- Contenu de la table `gen_site_auth_ldap`	418	-- Contenu de la table `gen_site_auth_ldap`
Line 428...		Line 428...
428		428
429	CREATE TABLE `gen_site_categorie` (	429	CREATE TABLE `gen_site_categorie` (
430	`gsc_id_categorie` int(10) unsigned NOT NULL auto_increment,	430	`gsc_id_categorie` int(10) unsigned NOT NULL auto_increment,
431	`gsc_intitule_categorie` varchar(255) default NULL,	431	`gsc_intitule_categorie` varchar(255) default NULL,
432	PRIMARY KEY (`gsc_id_categorie`)	432	PRIMARY KEY (`gsc_id_categorie`)
Line 433...		Line 433...
433	`) TYPE=MyISAM ;`	433	`)`
434		434
435	`--`	435	`--`
Line 448...		Line 448...
448	CREATE TABLE `gen_site_categorie_valeur` (	448	CREATE TABLE `gen_site_categorie_valeur` (
449	`gscv_id_valeur` int(11) unsigned NOT NULL auto_increment,	449	`gscv_id_valeur` int(11) unsigned NOT NULL auto_increment,
450	`gscv_id_categorie` int(10) unsigned NOT NULL default '0',	450	`gscv_id_categorie` int(10) unsigned NOT NULL default '0',
451	`gscv_intitule_valeur` varchar(255) default NULL,	451	`gscv_intitule_valeur` varchar(255) default NULL,
452	PRIMARY KEY (`gscv_id_valeur`)	452	PRIMARY KEY (`gscv_id_valeur`)
453	`) TYPE=MyISAM ;`	453	`)`
Line 454...		Line 454...
454		454
455	`--`	455	`--`
456	-- Contenu de la table `gen_site_categorie_valeur`	456	-- Contenu de la table `gen_site_categorie_valeur`
Line 474...		Line 474...
474	`gsr_id_site_01` int(11) unsigned NOT NULL default '0',	474	`gsr_id_site_01` int(11) unsigned NOT NULL default '0',
475	`gsr_id_site_02` int(11) unsigned NOT NULL default '0',	475	`gsr_id_site_02` int(11) unsigned NOT NULL default '0',
476	`gsr_id_valeur` int(11) unsigned NOT NULL default '0',	476	`gsr_id_valeur` int(11) unsigned NOT NULL default '0',
477	`gsr_ordre` int(11) unsigned default NULL,	477	`gsr_ordre` int(11) unsigned default NULL,
478	PRIMARY KEY (`gsr_id_site_01`,`gsr_id_site_02`,`gsr_id_valeur`)	478	PRIMARY KEY (`gsr_id_site_01`,`gsr_id_site_02`,`gsr_id_valeur`)
479	`) TYPE=MyISAM;`	479	`)`
Line 480...		Line 480...
480		480
481	`--`	481	`--`
482	-- Contenu de la table `gen_site_relation`	482	-- Contenu de la table `gen_site_relation`