Subversion Repositories Applications.papyrus

Rev

Rev 1355 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1355 Rev 1356
Line 152... Line 152...
152
CREATE TABLE `bazar_fiche_valeur_liste` (
152
CREATE TABLE `bazar_fiche_valeur_liste` (
153
  `bfvl_ce_fiche` int(10) unsigned NOT NULL default '0',
153
  `bfvl_ce_fiche` int(10) unsigned NOT NULL default '0',
154
  `bfvl_ce_liste` int(10) unsigned NOT NULL default '0',
154
  `bfvl_ce_liste` int(10) unsigned NOT NULL default '0',
155
  `bfvl_valeur` int(10) unsigned NOT NULL default '0',
155
  `bfvl_valeur` int(10) unsigned NOT NULL default '0',
156
  PRIMARY KEY  (`bfvl_ce_fiche`,`bfvl_ce_liste`,`bfvl_valeur`)
156
  PRIMARY KEY  (`bfvl_ce_fiche`,`bfvl_ce_liste`,`bfvl_valeur`)
157
)
157
);
Line 158... Line 158...
158
 
158
 
Line 159... Line 159...
159
 
159
 
Line 167... Line 167...
167
  `bfj_id_fichier` int(10) unsigned NOT NULL default '0',
167
  `bfj_id_fichier` int(10) unsigned NOT NULL default '0',
168
  `bfj_ce_fiche` int(10) unsigned NOT NULL default '0',
168
  `bfj_ce_fiche` int(10) unsigned NOT NULL default '0',
169
  `bfj_description` text,
169
  `bfj_description` text,
170
  `bfj_fichier` varchar(255) default NULL,
170
  `bfj_fichier` varchar(255) default NULL,
171
  PRIMARY KEY  (`bfj_id_fichier`)
171
  PRIMARY KEY  (`bfj_id_fichier`)
172
)
172
);
Line 173... Line 173...
173
 
173
 
Line 174... Line 174...
174
 
174
 
Line 181... Line 181...
181
CREATE TABLE `bazar_liste` (
181
CREATE TABLE `bazar_liste` (
182
  `bl_id_liste` int(11) NOT NULL default '0',
182
  `bl_id_liste` int(11) NOT NULL default '0',
183
  `bl_label_liste` varchar(255) NOT NULL default '',
183
  `bl_label_liste` varchar(255) NOT NULL default '',
184
  `bl_ce_i18n` varchar(5) NOT NULL default '',
184
  `bl_ce_i18n` varchar(5) NOT NULL default '',
185
  PRIMARY KEY  (`bl_id_liste`,`bl_ce_i18n`)
185
  PRIMARY KEY  (`bl_id_liste`,`bl_ce_i18n`)
186
)
186
);
Line 187... Line 187...
187
 
187
 
188
-- 
188
-- 
189
-- Contenu de la table `bazar_liste`
189
-- Contenu de la table `bazar_liste`
Line 228... Line 228...
228
  `blv_ce_liste` int(11) unsigned NOT NULL default '0',
228
  `blv_ce_liste` int(11) unsigned NOT NULL default '0',
229
  `blv_valeur` int(11) unsigned NOT NULL default '0',
229
  `blv_valeur` int(11) unsigned NOT NULL default '0',
230
  `blv_label` varchar(255) NOT NULL default '',
230
  `blv_label` varchar(255) NOT NULL default '',
231
  `blv_ce_i18n` varchar(5) NOT NULL default '',
231
  `blv_ce_i18n` varchar(5) NOT NULL default '',
232
  PRIMARY KEY  (`blv_ce_liste`,`blv_valeur`,`blv_ce_i18n`)
232
  PRIMARY KEY  (`blv_ce_liste`,`blv_valeur`,`blv_ce_i18n`)
233
) 
233
);
Line 234... Line 234...
234
 
234
 
235
-- 
235
-- 
236
-- Contenu de la table `bazar_liste_valeurs`
236
-- Contenu de la table `bazar_liste_valeurs`
Line 785... Line 785...
785
  `bn_couleur_calendrier` varchar(255) NOT NULL default '',
785
  `bn_couleur_calendrier` varchar(255) NOT NULL default '',
786
  `bn_picto_calendrier` varchar(255) NOT NULL default '',
786
  `bn_picto_calendrier` varchar(255) NOT NULL default '',
787
  `bn_label_class` varchar(255) NOT NULL,
787
  `bn_label_class` varchar(255) NOT NULL,
788
  `bn_ce_id_menu` int(11) NOT NULL default '0',
788
  `bn_ce_id_menu` int(11) NOT NULL default '0',
789
  PRIMARY KEY  (`bn_id_nature`,`bn_ce_i18n`)
789
  PRIMARY KEY  (`bn_id_nature`,`bn_ce_i18n`)
790
)
790
);
791
-- 
791
-- 
792
-- Contenu de la table `bazar_nature`
792
-- Contenu de la table `bazar_nature`
793
-- 
793
-- 
Line 794... Line 794...
794
 
794
 
Line 814... Line 814...
814
  `bt_id_i18n` varchar(5) NOT NULL default '',
814
  `bt_id_i18n` varchar(5) NOT NULL default '',
815
  `bt_template` text NOT NULL,
815
  `bt_template` text NOT NULL,
816
  `bt_documentation` text NOT NULL,
816
  `bt_documentation` text NOT NULL,
817
  `bt_categorie_nature` tinyint(3) unsigned NOT NULL default '0',
817
  `bt_categorie_nature` tinyint(3) unsigned NOT NULL default '0',
818
  PRIMARY KEY  (`bt_id_template`,`bt_id_i18n`,`bt_categorie_nature`)
818
  PRIMARY KEY  (`bt_id_template`,`bt_id_i18n`,`bt_categorie_nature`)
819
)
819
);
Line 820... Line 820...
820
 
820
 
821
-- 
821
-- 
822
-- Contenu de la table `bazar_template`
822
-- Contenu de la table `bazar_template`
Line 835... Line 835...
835
  `bu_id_url` int(10) unsigned NOT NULL auto_increment,
835
  `bu_id_url` int(10) unsigned NOT NULL auto_increment,
836
  `bu_ce_fiche` int(10) unsigned NOT NULL default '0',
836
  `bu_ce_fiche` int(10) unsigned NOT NULL default '0',
837
  `bu_url` varchar(255) default NULL,
837
  `bu_url` varchar(255) default NULL,
838
  `bu_descriptif_url` varchar(255) default NULL,
838
  `bu_descriptif_url` varchar(255) default NULL,
839
  PRIMARY KEY  (`bu_id_url`)
839
  PRIMARY KEY  (`bu_id_url`)
840
)
840
);
-
 
841
 
-
 
842
-- --------------------------------------------------------
-
 
843
 
-
 
844
INSERT INTO `gen_application` ( `gap_id_application` , `gap_nom` , `gap_description` , `gap_chemin` , `gap_bool_applette` )
-
 
845
VALUES (
-
 
846
'12', 'Bazar', 'Gestionnaire de fiches, moteur de recherche, flux RSS.', 'client/bazar/bazar.php', '0'
-
 
847
);
-
 
848
INSERT INTO `gen_application` ( `gap_id_application` , `gap_nom` , `gap_description` , `gap_chemin` , `gap_bool_applette` )
-
 
849
VALUES (
-
 
850
'13', 'Bazar Applette Calendrier', 'Calendrier associƩ aux fiches bazar', 'client/bazar/bazar.calendrier.applette.php', '1'
-
 
851
);