Rev 626 | Blame | Last modification | View Log | RSS feed
-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mercredi 30 Novembre 2005 à 16:04
-- Version du serveur: 4.1.14
-- Version de PHP: 4.4.0
--
-- Base de données: `papyrus`
--
-- --------------------------------------------------------
--
-- Structure de la table `bazar_abonnement`
--
DROP TABLE IF EXISTS `bazar_abonnement`;
CREATE TABLE IF NOT EXISTS `bazar_abonnement` (
`ba_id_utilisateur` int(11) NOT NULL default '0',
`ba_id_rubrique` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_appropriation`
--
DROP TABLE IF EXISTS `bazar_appropriation`;
CREATE TABLE IF NOT EXISTS `bazar_appropriation` (
`ba_ce_id_fiche` int(11) NOT NULL default '0',
`ba_ce_id_structure` int(11) NOT NULL default '0',
PRIMARY KEY (`ba_ce_id_fiche`,`ba_ce_id_structure`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_commentaires`
--
DROP TABLE IF EXISTS `bazar_commentaires`;
CREATE TABLE IF NOT EXISTS `bazar_commentaires` (
`bc_id_commentaire` int(11) NOT NULL auto_increment,
`bc_ce_id_fiche` int(11) NOT NULL default '0',
`bc_nom` varchar(255) NOT NULL default '',
`bc_commentaire` text NOT NULL,
`bc_date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`bc_id_commentaire`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_droits`
--
DROP TABLE IF EXISTS `bazar_droits`;
CREATE TABLE IF NOT EXISTS `bazar_droits` (
`bd_id_utilisateur` int(11) unsigned NOT NULL default '0',
`bd_id_nature_offre` int(10) unsigned NOT NULL default '0',
`bd_niveau_droit` int(10) unsigned default NULL,
PRIMARY KEY (`bd_id_utilisateur`,`bd_id_nature_offre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_fiche`
--
DROP TABLE IF EXISTS `bazar_fiche`;
CREATE TABLE IF NOT EXISTS `bazar_fiche` (
`bf_id_fiche` int(10) unsigned NOT NULL default '0',
`bf_ce_tranches_ages` int(10) unsigned NOT NULL default '0',
`bf_ce_utilisateur` int(11) unsigned NOT NULL default '0',
`bf_ce_nature` int(10) unsigned NOT NULL default '0',
`bf_ce_type_parution` int(10) unsigned default NULL,
`bf_ce_departement` int(10) unsigned default NULL,
`bf_ce_region` int(10) unsigned default NULL,
`bf_ce_pays` char(2) default NULL,
`bf_ce_langue` int(11) NOT NULL default '0',
`bf_ce_periode` int(11) NOT NULL default '0',
`bf_ce_milieu` int(11) NOT NULL default '0',
`bf_ce_hebergement` int(11) NOT NULL default '0',
`bf_ce_qualif` varchar(255) NOT NULL default '0',
`bf_ce_agrement` int(11) NOT NULL default '0',
`bf_ce_aides` varchar(255) NOT NULL default '0',
`bf_titre` varchar(255) default NULL,
`bf_theme` varchar(255) NOT NULL default '',
`bf_code` varchar(20) default NULL,
`bf_description` text,
`bf_url_image` varchar(255) default NULL,
`bf_date_debut_validite_fiche` date NOT NULL default '0000-00-00',
`bf_date_fin_validite_fiche` date NOT NULL default '0000-00-00',
`bf_date_creation_fiche` datetime NOT NULL default '0000-00-00 00:00:00',
`bf_date_maj_fiche` datetime NOT NULL default '0000-00-00 00:00:00',
`bf_statut_fiche` int(10) unsigned default NULL,
`bf_date_debut_evenement` date default NULL,
`bf_date_fin_evenement` date default NULL,
`bf_lieu_evenement` varchar(255) default NULL,
`bf_capacite_accueil` int(10) unsigned default NULL,
`bf_nb_animateurs` int(10) unsigned default NULL,
`bf_tarif_individuel` varchar(255) default NULL,
`bf_numero_module` varchar(8) NOT NULL default '',
`bf_total_module` varchar(8) NOT NULL default '',
`bf_ce_type_formation` int(11) NOT NULL default '0',
`bf_ce_diplome` int(11) NOT NULL default '0',
`bf_ce_niveau` int(11) NOT NULL default '0',
`bf_qualif_preparee` varchar(60) NOT NULL default '',
`bf_contenu_formation` text NOT NULL,
`bf_conditions_acces` text NOT NULL,
`bf_date_fin_inscription` date NOT NULL default '0000-00-00',
`bf_cp_lieu_evenement` varchar(7) NOT NULL default '',
`bf_tarif_entreprise` varchar(255) NOT NULL default '',
`bf_tarif_opca` varchar(255) NOT NULL default '',
`bf_num_agrement` varchar(20) NOT NULL default '',
`bf_prenom_contact` varchar(60) NOT NULL default '',
`bf_nom_contact` varchar(60) NOT NULL default '',
`bf_mail` varchar(50) NOT NULL default '',
`bf_telephone` varchar(14) NOT NULL default '',
`bf_intervenants` text NOT NULL,
`bf_infos_complementaires` text NOT NULL,
`bf_public` varchar(255) NOT NULL default '',
`bf_nb_consultations` int(11) NOT NULL default '0',
`bf_auteur` varchar(255) NOT NULL default '',
`bf_auteur_coordonnee` varchar(255) NOT NULL default '',
`bf_editeur` varchar(255) NOT NULL default '',
`bf_editeur_coordonnee` varchar(255) NOT NULL default '',
`bf_annee_parution` varchar(255) NOT NULL default '',
PRIMARY KEY (`bf_id_fiche`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_fichier_joint`
--
DROP TABLE IF EXISTS `bazar_fichier_joint`;
CREATE TABLE IF NOT EXISTS `bazar_fichier_joint` (
`bfj_id_fichier` int(10) unsigned NOT NULL default '0',
`bfj_ce_fiche` int(10) unsigned NOT NULL default '0',
`bfj_description` text,
`bfj_fichier` varchar(255) default NULL,
PRIMARY KEY (`bfj_id_fichier`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_licence`
--
DROP TABLE IF EXISTS `bazar_licence`;
CREATE TABLE IF NOT EXISTS `bazar_licence` (
`bl_id_licence` int(10) unsigned NOT NULL default '0',
`bl_nom` varchar(255) default NULL,
`bl_contenu` text,
PRIMARY KEY (`bl_id_licence`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_agrement`
--
DROP TABLE IF EXISTS `bazar_liste_agrement`;
CREATE TABLE IF NOT EXISTS `bazar_liste_agrement` (
`bla_id_agrement` int(11) NOT NULL default '0',
`bla_label_agrement` varchar(255) NOT NULL default '',
PRIMARY KEY (`bla_id_agrement`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_aides`
--
DROP TABLE IF EXISTS `bazar_liste_aides`;
CREATE TABLE IF NOT EXISTS `bazar_liste_aides` (
`bla_id_aides` int(11) NOT NULL default '0',
`bla_label_aides` varchar(255) NOT NULL default '',
PRIMARY KEY (`bla_id_aides`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_diplome`
--
DROP TABLE IF EXISTS `bazar_liste_diplome`;
CREATE TABLE IF NOT EXISTS `bazar_liste_diplome` (
`bld_id_diplome` int(11) NOT NULL default '0',
`bld_label` varchar(255) NOT NULL default '',
PRIMARY KEY (`bld_id_diplome`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_echelle_geo`
--
DROP TABLE IF EXISTS `bazar_liste_echelle_geo`;
CREATE TABLE IF NOT EXISTS `bazar_liste_echelle_geo` (
`bleg_id_echelle` tinyint(3) unsigned NOT NULL default '0',
`bleg_label` varchar(255) NOT NULL default '',
PRIMARY KEY (`bleg_id_echelle`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_hebergement`
--
DROP TABLE IF EXISTS `bazar_liste_hebergement`;
CREATE TABLE IF NOT EXISTS `bazar_liste_hebergement` (
`blh_id_hebergement` int(11) NOT NULL default '0',
`blh_label_hebergement` varchar(255) NOT NULL default '',
PRIMARY KEY (`blh_id_hebergement`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_milieu_dominant`
--
DROP TABLE IF EXISTS `bazar_liste_milieu_dominant`;
CREATE TABLE IF NOT EXISTS `bazar_liste_milieu_dominant` (
`blmd_id_milieu` int(11) NOT NULL default '0',
`blmd_label_milieu` varchar(255) NOT NULL default '',
PRIMARY KEY (`blmd_id_milieu`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_nature_aide`
--
DROP TABLE IF EXISTS `bazar_liste_nature_aide`;
CREATE TABLE IF NOT EXISTS `bazar_liste_nature_aide` (
`blna_id_nature_aide` tinyint(3) unsigned NOT NULL default '0',
`blna_label` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_niveau`
--
DROP TABLE IF EXISTS `bazar_liste_niveau`;
CREATE TABLE IF NOT EXISTS `bazar_liste_niveau` (
`bln_id_niveau` int(11) NOT NULL default '0',
`bln_label` varchar(255) NOT NULL default '',
PRIMARY KEY (`bln_id_niveau`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_niveau_scolaire`
--
DROP TABLE IF EXISTS `bazar_liste_niveau_scolaire`;
CREATE TABLE IF NOT EXISTS `bazar_liste_niveau_scolaire` (
`blns_id_niveau` int(11) NOT NULL default '0',
`blns_label_niveau` varchar(255) NOT NULL default '',
PRIMARY KEY (`blns_id_niveau`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_oui_non`
--
DROP TABLE IF EXISTS `bazar_liste_oui_non`;
CREATE TABLE IF NOT EXISTS `bazar_liste_oui_non` (
`blon_id_oui_non` int(11) NOT NULL default '0',
`blon_label_oui_non` varchar(255) NOT NULL default '',
PRIMARY KEY (`blon_id_oui_non`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_periode`
--
DROP TABLE IF EXISTS `bazar_liste_periode`;
CREATE TABLE IF NOT EXISTS `bazar_liste_periode` (
`blp_id_periode` int(11) NOT NULL default '0',
`blp_label_periode` varchar(255) NOT NULL default '',
PRIMARY KEY (`blp_id_periode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_prix`
--
DROP TABLE IF EXISTS `bazar_liste_prix`;
CREATE TABLE IF NOT EXISTS `bazar_liste_prix` (
`blp_id_prix` int(11) NOT NULL default '0',
`blp_label_prix` varchar(255) NOT NULL default '',
PRIMARY KEY (`blp_id_prix`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_qualification`
--
DROP TABLE IF EXISTS `bazar_liste_qualification`;
CREATE TABLE IF NOT EXISTS `bazar_liste_qualification` (
`blq_id_qualif` int(11) NOT NULL default '0',
`blq_label_qualif` varchar(255) NOT NULL default '',
PRIMARY KEY (`blq_id_qualif`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_secteur`
--
DROP TABLE IF EXISTS `bazar_liste_secteur`;
CREATE TABLE IF NOT EXISTS `bazar_liste_secteur` (
`bls_id_secteur` tinyint(3) unsigned NOT NULL default '0',
`bls_label` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_theme`
--
DROP TABLE IF EXISTS `bazar_liste_theme`;
CREATE TABLE IF NOT EXISTS `bazar_liste_theme` (
`bt_id_theme` tinyint(4) NOT NULL default '0',
`bt_label_theme` varchar(255) NOT NULL default '',
PRIMARY KEY (`bt_id_theme`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_tranches_ages`
--
DROP TABLE IF EXISTS `bazar_liste_tranches_ages`;
CREATE TABLE IF NOT EXISTS `bazar_liste_tranches_ages` (
`blta_id_tranches_ages` int(10) unsigned NOT NULL auto_increment,
`blta_label` varchar(255) default NULL,
PRIMARY KEY (`blta_id_tranches_ages`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_type_formation`
--
DROP TABLE IF EXISTS `bazar_liste_type_formation`;
CREATE TABLE IF NOT EXISTS `bazar_liste_type_formation` (
`bltf_id_type_formation` int(10) NOT NULL default '0',
`bltf_label` varchar(255) NOT NULL default '',
PRIMARY KEY (`bltf_id_type_formation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_liste_type_sejour`
--
DROP TABLE IF EXISTS `bazar_liste_type_sejour`;
CREATE TABLE IF NOT EXISTS `bazar_liste_type_sejour` (
`blts_id_type_sejour` int(11) NOT NULL default '0',
`blts_label_type_sejour` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_nature`
--
DROP TABLE IF EXISTS `bazar_nature`;
CREATE TABLE IF NOT EXISTS `bazar_nature` (
`bn_id_nature` int(10) unsigned NOT NULL default '0',
`bn_label_nature` varchar(255) default NULL,
`bn_description` text,
`bn_condition` text,
`bn_commentaire` tinyint(4) NOT NULL default '0',
`bn_appropriation` tinyint(4) NOT NULL default '0',
`bn_image_titre` varchar(255) NOT NULL default '',
`bn_image_logo` varchar(255) NOT NULL default '',
`bn_couleur_calendrier` varchar(255) NOT NULL default '',
`bn_picto_calendrier` varchar(255) NOT NULL default '',
`bn_ce_id_menu` int(11) NOT NULL default '0',
PRIMARY KEY (`bn_id_nature`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_type_parution`
--
DROP TABLE IF EXISTS `bazar_type_parution`;
CREATE TABLE IF NOT EXISTS `bazar_type_parution` (
`btp_id` int(11) NOT NULL default '0',
`btp_label` varchar(255) NOT NULL default '',
PRIMARY KEY (`btp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bazar_url`
--
DROP TABLE IF EXISTS `bazar_url`;
CREATE TABLE IF NOT EXISTS `bazar_url` (
`bu_id_url` int(10) unsigned NOT NULL auto_increment,
`bu_ce_fiche` int(10) unsigned NOT NULL default '0',
`bu_url` varchar(255) default NULL,
`bu_descriptif_url` varchar(255) default NULL,
PRIMARY KEY (`bu_id_url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;