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 
);