New file |
0,0 → 1,804 |
# phpMyAdmin SQL Dump |
# version 2.5.6 |
# http://www.phpmyadmin.net |
# |
# Serveur: localhost |
# Généré le : Jeudi 25 Novembre 2004 à 17:59 |
# Version du serveur: 4.0.21 |
# Version de PHP: 4.3.9 |
# |
# Base de données: `test` |
# |
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `bazar_checklist_aides` |
# |
|
CREATE TABLE `bazar_checklist_aides` ( |
`bca_id_aides` int(10) unsigned NOT NULL auto_increment, |
`bca_ce_fiche` int(10) unsigned NOT NULL default '0', |
`bca_label` varchar(255) default NULL, |
PRIMARY KEY (`bca_id_aides`,`bca_ce_fiche`) |
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
|
# |
# Contenu de la table `bazar_checklist_aides` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `bazar_checklist_aptitudes` |
# |
|
CREATE TABLE `bazar_checklist_aptitudes` ( |
`bca_id_aptitudes` int(10) unsigned NOT NULL auto_increment, |
`bca_ce_fiche` int(10) unsigned NOT NULL default '0', |
`bca_label` varchar(255) default NULL, |
PRIMARY KEY (`bca_id_aptitudes`,`bca_ce_fiche`) |
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
|
# |
# Contenu de la table `bazar_checklist_aptitudes` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `bazar_checklist_hebergement` |
# |
|
CREATE TABLE `bazar_checklist_hebergement` ( |
`bch_id_type_hebergement` int(10) unsigned NOT NULL default '0', |
`bch_ce_fiche` int(10) unsigned NOT NULL default '0', |
`bch_label` varchar(255) default NULL, |
PRIMARY KEY (`bch_id_type_hebergement`,`bch_ce_fiche`) |
) TYPE=MyISAM; |
|
# |
# Contenu de la table `bazar_checklist_hebergement` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `bazar_checklist_qualifications_animateurs` |
# |
|
CREATE TABLE `bazar_checklist_qualifications_animateurs` ( |
`bcqa_id_qualification` int(10) unsigned NOT NULL auto_increment, |
`bcqa_ce_fiche` int(10) unsigned NOT NULL default '0', |
`bcqa_label` varchar(255) default NULL, |
PRIMARY KEY (`bcqa_id_qualification`,`bcqa_ce_fiche`) |
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
|
# |
# Contenu de la table `bazar_checklist_qualifications_animateurs` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `bazar_droits` |
# |
|
CREATE TABLE `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`) |
) TYPE=MyISAM; |
|
# |
# Contenu de la table `bazar_droits` |
# |
|
INSERT INTO `bazar_droits` VALUES (0, 1, 0); |
INSERT INTO `bazar_droits` VALUES (0, 2, 0); |
INSERT INTO `bazar_droits` VALUES (0, 3, 0); |
INSERT INTO `bazar_droits` VALUES (0, 4, 0); |
INSERT INTO `bazar_droits` VALUES (0, 5, 0); |
INSERT INTO `bazar_droits` VALUES (0, 6, 0); |
INSERT INTO `bazar_droits` VALUES (0, 7, 0); |
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `bazar_fiche` |
# |
|
CREATE TABLE `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_licence` 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_titre` varchar(255) default NULL, |
`bf_code` varchar(20) default NULL, |
`bf_description` text, |
`bf_url_image` varchar(255) default NULL, |
`bf_date_debut_validite_fiche` date default NULL, |
`bf_date_fin_validite_fiche` date default NULL, |
`bf_date_creation_fiche` datetime default NULL, |
`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` varchar(255) default NULL, |
PRIMARY KEY (`bf_id_fiche`) |
) TYPE=MyISAM; |
|
# |
# Contenu de la table `bazar_fiche` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `bazar_fichier_joint` |
# |
|
CREATE TABLE `bazar_fichier_joint` ( |
`bfj_id_fichier` int(10) unsigned NOT NULL default '0', |
`bfj_ce_fiche` int(10) unsigned NOT NULL default '0', |
`bfj_label_lien` varchar(255) default NULL, |
`bfj_description` text, |
`bfj_url_relative` varchar(255) default NULL, |
PRIMARY KEY (`bfj_id_fichier`) |
) TYPE=MyISAM; |
|
# |
# Contenu de la table `bazar_fichier_joint` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `bazar_licence` |
# |
|
CREATE TABLE `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`) |
) TYPE=MyISAM; |
|
# |
# Contenu de la table `bazar_licence` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `bazar_liste_tranches_ages` |
# |
|
CREATE TABLE `bazar_liste_tranches_ages` ( |
`blta_id_tranches_ages` int(10) unsigned NOT NULL auto_increment, |
`blta_label` varchar(255) NOT NULL default '', |
PRIMARY KEY (`blta_id_tranches_ages`) |
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
|
# |
# Contenu de la table `bazar_liste_tranches_ages` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `bazar_nature` |
# |
|
CREATE TABLE `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, |
PRIMARY KEY (`bn_id_nature`) |
) TYPE=MyISAM; |
|
# |
# Contenu de la table `bazar_nature` |
# |
|
INSERT INTO `bazar_nature` VALUES (1, 'Annonces', 'Communication brève pour mettre en avant une actualité touchant à l\'EE : émission radio, discours d\'un ministre, intervention télévisée, nouvelle d\'une structure...', NULL); |
INSERT INTO `bazar_nature` VALUES (2, 'Publications', 'Annonces de la sortie d\'un ouvrage ou d\'une publication touchant au domaine de l\'EE', NULL); |
INSERT INTO `bazar_nature` VALUES (3, 'Rencontres', 'Toute manifestation, rencontre, colloque, congrés ayant trait à l\'EE aux différentes échelles de territoire.', NULL); |
INSERT INTO `bazar_nature` VALUES (4, 'Formations-coformations', 'Tous les moments de partage de connaissances et les stages touchant à des thématiques liées à l\'EE et intégrant une dimension pédagogique clairement affirmée.', NULL); |
INSERT INTO `bazar_nature` VALUES (5, 'Sejours', 'Séjours de vacances, chantiers nature, classes d\'environnement dans le domaine de l\'EE.', 'Acceptez-vous les conditions de la charte Ecole et Nature sur le catalogue des séjours?'); |
INSERT INTO `bazar_nature` VALUES (6, 'Emplois', 'Offres demploi ayant un rapport avec l\'EE. Les demandes demploi ne sont pas prise en considération.', NULL); |
INSERT INTO `bazar_nature` VALUES (7, 'Covoiturage', 'Offres et demandes de covoiturage liés à un évènement d\'EE proposé par une structure adhérente du réseau.', NULL); |
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `bazar_url` |
# |
|
CREATE TABLE `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`) |
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
|
# |
# Contenu de la table `bazar_url` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `gen_adhesion` |
# |
|
CREATE TABLE `gen_adhesion` ( |
`gad_identifiant` int(10) unsigned NOT NULL auto_increment, |
`gad_membre` int(10) unsigned default NULL, |
`gad_date` date default NULL, |
`gad_montant` int(10) unsigned default NULL, |
`gad_reçu` int(10) unsigned default NULL, |
`gad_date_reçu` date default NULL, |
PRIMARY KEY (`gad_identifiant`) |
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
|
# |
# Contenu de la table `gen_adhesion` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `gen_annuaire` |
# |
|
CREATE TABLE `gen_annuaire` ( |
`ga_id_utilisateur` int(10) unsigned NOT NULL default '0', |
`ga_identifiant` varchar(255) NOT NULL default '0', |
`ga_ce_adhesion` int(10) unsigned NOT NULL default '0', |
`ga_motpasse` varchar(255) NOT NULL default '', |
`ga_ce_ville` int(10) unsigned NOT NULL default '0', |
`ga_ce_structure` int(11) unsigned NOT NULL default '0', |
`ga_ce_coor_prof` int(11) unsigned NOT NULL default '0', |
`ga_ce_region` int(10) unsigned NOT NULL default '0', |
`ga_ce_departement` int(10) unsigned NOT NULL default '0', |
`ga_ce_pays` char(2) NOT NULL default '', |
`ga_ce_statut` int(10) unsigned NOT NULL default '0', |
`ga_nom` varchar(32) NOT NULL default '', |
`ga_prenom` varchar(32) NOT NULL default '', |
`ga_adresse1` varchar(45) NOT NULL default '', |
`ga_adresse2` varchar(45) default NULL, |
`ga_telephone` varchar(32) default NULL, |
`ga_fax` varchar(32) default NULL, |
`ga_GSM` varchar(32) default NULL, |
`ga_mail` varchar(128) NOT NULL default '', |
`ga_icq_aim` varchar(20) default NULL, |
`ga_jabber` varchar(20) default NULL, |
`ga_msn` varchar(20) default NULL, |
`ga_site_web` varchar(45) default NULL, |
`ga_commentaire` text, |
PRIMARY KEY (`ga_identifiant`,`ga_id_utilisateur`), |
UNIQUE KEY `ga_identifiant` (`ga_identifiant`) |
) TYPE=MyISAM; |
|
# |
# Contenu de la table `gen_annuaire` |
# |
|
INSERT INTO `gen_annuaire` VALUES (0, 'florian', 0, 'd0b187a3a2804e5236302157db8b9d29', 1, 1, 1, 1, 34, 'FR', 0, 'Schmitt', 'Florian', '26 rue JJ Rousseau', NULL, '04.75.27.91.34', NULL, NULL, 'florian@ecole-et-nature.org', NULL, NULL, NULL, 'http://www.mrflos.net', NULL); |
INSERT INTO `gen_annuaire` VALUES (1, 'delphine', 0, '1a1dc91c907325c69271ddf0c944bc72', 0, 0, 0, 0, 0, '', 0, 'Delphine', 'Vinck', '', NULL, NULL, NULL, NULL, 'delphine.vinck@ecole-et-nature.org', NULL, NULL, NULL, NULL, NULL); |
INSERT INTO `gen_annuaire` VALUES (2, 'EricSamson', 0, '1a1dc91c907325c69271ddf0c944bc72', 0, 0, 0, 0, 0, 'FR', 0, 'Samson', 'Eric', '', NULL, NULL, NULL, NULL, 'eric.samson@grainecentre.org', NULL, NULL, NULL, NULL, NULL); |
INSERT INTO `gen_annuaire` VALUES (3, 'jean-marc', 0, '1a1dc91c907325c69271ddf0c944bc72', 0, 0, 0, 0, 0, '', 0, 'Jean-Marc', 'Roussel', '', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); |
INSERT INTO `gen_annuaire` VALUES (4, 'jessica', 0, '737f3339fd50499646a90922c865d402', 0, 0, 0, 0, 0, '', 1, 'Deschamps', 'Jessica', '', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL); |
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `gen_competence` |
# |
|
CREATE TABLE `gen_competence` ( |
`gc_id_competence` int(11) unsigned NOT NULL default '0', |
`gc_ce_type_competence` int(11) unsigned NOT NULL default '0', |
`gc_competence` varchar(45) default NULL, |
`gc_commentaire` text, |
PRIMARY KEY (`gc_id_competence`) |
) TYPE=MyISAM; |
|
# |
# Contenu de la table `gen_competence` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `gen_coordonnees_professionnelles` |
# |
|
CREATE TABLE `gen_coordonnees_professionnelles` ( |
`gcp_id_coord_prof` int(11) unsigned NOT NULL default '0', |
`gcp_telephone` varchar(32) default NULL, |
`gcp_fax` varchar(32) default NULL, |
`gcp_GSM` varchar(32) default NULL, |
`gcp_mail` varchar(128) NOT NULL default '', |
`gcp_icq_aim` varchar(20) default NULL, |
`gcp_jabber` varchar(20) default NULL, |
`gcp_msn` varchar(20) default NULL, |
`gcp_commentaire` text, |
PRIMARY KEY (`gcp_id_coord_prof`) |
) TYPE=MyISAM; |
|
# |
# Contenu de la table `gen_coordonnees_professionnelles` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `gen_departement` |
# |
|
CREATE TABLE `gen_departement` ( |
`gd_id_departement` int(11) NOT NULL default '0', |
`gd_nom` varchar(100) NOT NULL default '', |
PRIMARY KEY (`gd_id_departement`) |
) TYPE=MyISAM; |
|
# |
# Contenu de la table `gen_departement` |
# |
|
INSERT INTO `gen_departement` VALUES (1, 'Ain'); |
INSERT INTO `gen_departement` VALUES (2, 'Aisne'); |
INSERT INTO `gen_departement` VALUES (3, 'Allier'); |
INSERT INTO `gen_departement` VALUES (4, 'Alpes-de-Haute-Provence'); |
INSERT INTO `gen_departement` VALUES (5, 'Hautes-Alpes'); |
INSERT INTO `gen_departement` VALUES (6, 'Alpes-Maritimes'); |
INSERT INTO `gen_departement` VALUES (7, 'Ardèche'); |
INSERT INTO `gen_departement` VALUES (8, 'Ardennes'); |
INSERT INTO `gen_departement` VALUES (9, 'Ariège'); |
INSERT INTO `gen_departement` VALUES (10, 'Aube'); |
INSERT INTO `gen_departement` VALUES (11, 'Aude'); |
INSERT INTO `gen_departement` VALUES (12, 'Aveyron'); |
INSERT INTO `gen_departement` VALUES (13, 'Bouches-du-Rhône'); |
INSERT INTO `gen_departement` VALUES (14, 'Calvados'); |
INSERT INTO `gen_departement` VALUES (15, 'Cantal'); |
INSERT INTO `gen_departement` VALUES (16, 'Charente'); |
INSERT INTO `gen_departement` VALUES (17, 'Charente-Maritime'); |
INSERT INTO `gen_departement` VALUES (18, 'Cher'); |
INSERT INTO `gen_departement` VALUES (19, 'Corrèze'); |
INSERT INTO `gen_departement` VALUES (20, 'Corse'); |
INSERT INTO `gen_departement` VALUES (21, 'Côte-d\'Or'); |
INSERT INTO `gen_departement` VALUES (22, 'Côtes-d\'Armor'); |
INSERT INTO `gen_departement` VALUES (23, 'Creuse'); |
INSERT INTO `gen_departement` VALUES (24, 'Dordogne'); |
INSERT INTO `gen_departement` VALUES (25, 'Doubs'); |
INSERT INTO `gen_departement` VALUES (26, 'Drôme'); |
INSERT INTO `gen_departement` VALUES (27, 'Eure'); |
INSERT INTO `gen_departement` VALUES (28, 'Eure-et-Loir'); |
INSERT INTO `gen_departement` VALUES (29, 'Finistère'); |
INSERT INTO `gen_departement` VALUES (30, 'Gard'); |
INSERT INTO `gen_departement` VALUES (31, 'Haute-Garonne'); |
INSERT INTO `gen_departement` VALUES (32, 'Gers'); |
INSERT INTO `gen_departement` VALUES (33, 'Gironde'); |
INSERT INTO `gen_departement` VALUES (34, 'Hérault'); |
INSERT INTO `gen_departement` VALUES (35, 'Ille-et-Vilaine'); |
INSERT INTO `gen_departement` VALUES (36, 'Indre'); |
INSERT INTO `gen_departement` VALUES (37, 'Indre-et-Loire'); |
INSERT INTO `gen_departement` VALUES (38, 'Isère'); |
INSERT INTO `gen_departement` VALUES (39, 'Jura'); |
INSERT INTO `gen_departement` VALUES (40, 'Landes'); |
INSERT INTO `gen_departement` VALUES (41, 'Loir-et-Cher'); |
INSERT INTO `gen_departement` VALUES (42, 'Loire'); |
INSERT INTO `gen_departement` VALUES (43, 'Haute-Loire'); |
INSERT INTO `gen_departement` VALUES (44, 'Loire-Atlantique'); |
INSERT INTO `gen_departement` VALUES (45, 'Loiret'); |
INSERT INTO `gen_departement` VALUES (46, 'Lot'); |
INSERT INTO `gen_departement` VALUES (47, 'Lot-et-Garonne'); |
INSERT INTO `gen_departement` VALUES (48, 'Lozére'); |
INSERT INTO `gen_departement` VALUES (49, 'Maine-et-Loire'); |
INSERT INTO `gen_departement` VALUES (50, 'Manche'); |
INSERT INTO `gen_departement` VALUES (51, 'Marne'); |
INSERT INTO `gen_departement` VALUES (52, 'Haute-Marne'); |
INSERT INTO `gen_departement` VALUES (53, 'Mayenne'); |
INSERT INTO `gen_departement` VALUES (54, 'Meurthe-et-Moselle'); |
INSERT INTO `gen_departement` VALUES (55, 'Meuse'); |
INSERT INTO `gen_departement` VALUES (56, 'Morbihan'); |
INSERT INTO `gen_departement` VALUES (57, 'Moselle'); |
INSERT INTO `gen_departement` VALUES (58, 'Nièvre'); |
INSERT INTO `gen_departement` VALUES (59, 'Nord'); |
INSERT INTO `gen_departement` VALUES (60, 'Oise'); |
INSERT INTO `gen_departement` VALUES (61, 'Orne'); |
INSERT INTO `gen_departement` VALUES (62, 'Pas-de-Calais'); |
INSERT INTO `gen_departement` VALUES (63, 'Puy-de-Dôme'); |
INSERT INTO `gen_departement` VALUES (64, 'Pyrénées-Atlantiques'); |
INSERT INTO `gen_departement` VALUES (65, 'Hautes-Pyrénées'); |
INSERT INTO `gen_departement` VALUES (66, 'Pyrénées-Orientales'); |
INSERT INTO `gen_departement` VALUES (67, 'Bas-Rhin'); |
INSERT INTO `gen_departement` VALUES (68, 'Haut-Rhin'); |
INSERT INTO `gen_departement` VALUES (69, 'Rhône'); |
INSERT INTO `gen_departement` VALUES (70, 'Haute-Saône'); |
INSERT INTO `gen_departement` VALUES (71, 'Saône-et-Loire'); |
INSERT INTO `gen_departement` VALUES (72, 'Sarthe'); |
INSERT INTO `gen_departement` VALUES (73, 'Savoie'); |
INSERT INTO `gen_departement` VALUES (74, 'Haute-Savoie'); |
INSERT INTO `gen_departement` VALUES (75, 'Paris'); |
INSERT INTO `gen_departement` VALUES (76, 'Seine-Maritime'); |
INSERT INTO `gen_departement` VALUES (77, 'Seine-et-Marne'); |
INSERT INTO `gen_departement` VALUES (78, 'Yvelines'); |
INSERT INTO `gen_departement` VALUES (79, 'Deux-Sèvres'); |
INSERT INTO `gen_departement` VALUES (80, 'Somme'); |
INSERT INTO `gen_departement` VALUES (81, 'Tarn'); |
INSERT INTO `gen_departement` VALUES (82, 'Tarn-et-Garonne'); |
INSERT INTO `gen_departement` VALUES (83, 'Var'); |
INSERT INTO `gen_departement` VALUES (84, 'Vaucluse'); |
INSERT INTO `gen_departement` VALUES (85, 'Vendée'); |
INSERT INTO `gen_departement` VALUES (86, 'Vienne'); |
INSERT INTO `gen_departement` VALUES (87, 'Haute-Vienne'); |
INSERT INTO `gen_departement` VALUES (88, 'Vosges'); |
INSERT INTO `gen_departement` VALUES (89, 'Yonne'); |
INSERT INTO `gen_departement` VALUES (90, 'Territoire-de-Belfort'); |
INSERT INTO `gen_departement` VALUES (91, 'Essonne'); |
INSERT INTO `gen_departement` VALUES (92, 'Hauts-de-Seine'); |
INSERT INTO `gen_departement` VALUES (93, 'Seine-Saint-Denis'); |
INSERT INTO `gen_departement` VALUES (94, 'Val-de-Marne'); |
INSERT INTO `gen_departement` VALUES (95, 'Val-d\'Oise'); |
INSERT INTO `gen_departement` VALUES (99, 'Etranger'); |
INSERT INTO `gen_departement` VALUES (971, 'Guadeloupe'); |
INSERT INTO `gen_departement` VALUES (972, 'Martinique'); |
INSERT INTO `gen_departement` VALUES (973, 'Guyane'); |
INSERT INTO `gen_departement` VALUES (974, 'Réunion'); |
INSERT INTO `gen_departement` VALUES (975, 'St-Pierre-et-Miquelon'); |
INSERT INTO `gen_departement` VALUES (976, 'Mayotte'); |
INSERT INTO `gen_departement` VALUES (980, 'Monaco'); |
INSERT INTO `gen_departement` VALUES (986, 'Wallis-et-Futuna'); |
INSERT INTO `gen_departement` VALUES (987, 'Polynésie-Française'); |
INSERT INTO `gen_departement` VALUES (988, 'Nouvelle-Calédonie'); |
INSERT INTO `gen_departement` VALUES (900, ''); |
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `gen_pays` |
# |
|
CREATE TABLE `gen_pays` ( |
`gp_id_pays` char(2) NOT NULL default '', |
`gp_nom` varchar(255) default NULL, |
PRIMARY KEY (`gp_id_pays`) |
) TYPE=MyISAM; |
|
# |
# Contenu de la table `gen_pays` |
# |
|
INSERT INTO `gen_pays` VALUES ('AF', 'Afghanistan'); |
INSERT INTO `gen_pays` VALUES ('ZA', 'Afrique du Sud'); |
INSERT INTO `gen_pays` VALUES ('AL', 'Albanie'); |
INSERT INTO `gen_pays` VALUES ('DZ', 'Algérie'); |
INSERT INTO `gen_pays` VALUES ('DE', 'Allemagne'); |
INSERT INTO `gen_pays` VALUES ('AN', 'Andorre'); |
INSERT INTO `gen_pays` VALUES ('AO', 'Angola'); |
INSERT INTO `gen_pays` VALUES ('AG', 'Antigua et Barbuda'); |
INSERT INTO `gen_pays` VALUES ('SA', 'Arabie Saoudite'); |
INSERT INTO `gen_pays` VALUES ('AR', 'Argentine'); |
INSERT INTO `gen_pays` VALUES ('AM', 'Arménie'); |
INSERT INTO `gen_pays` VALUES ('AU', 'Australie'); |
INSERT INTO `gen_pays` VALUES ('AT', 'Autriche'); |
INSERT INTO `gen_pays` VALUES ('AZ', 'Azerbaïdjan'); |
INSERT INTO `gen_pays` VALUES ('BS', 'Bahamas'); |
INSERT INTO `gen_pays` VALUES ('BH', 'Bahreïn'); |
INSERT INTO `gen_pays` VALUES ('BD', 'Bangladesh'); |
INSERT INTO `gen_pays` VALUES ('BB', 'Barbade'); |
INSERT INTO `gen_pays` VALUES ('BE', 'Belgique'); |
INSERT INTO `gen_pays` VALUES ('BZ', 'Bélize'); |
INSERT INTO `gen_pays` VALUES ('BJ', 'Bénin'); |
INSERT INTO `gen_pays` VALUES ('BT', 'Bhoutan'); |
INSERT INTO `gen_pays` VALUES ('BY', 'Biélorussie'); |
INSERT INTO `gen_pays` VALUES ('BO', 'Bolivie'); |
INSERT INTO `gen_pays` VALUES ('BA', 'Bosnie-Herzégovine'); |
INSERT INTO `gen_pays` VALUES ('BW', 'Botswana'); |
INSERT INTO `gen_pays` VALUES ('BR', 'Brésil'); |
INSERT INTO `gen_pays` VALUES ('BN', 'Brunei Darusalam'); |
INSERT INTO `gen_pays` VALUES ('BG', 'Bulgarie'); |
INSERT INTO `gen_pays` VALUES ('BF', 'Burkina Faso'); |
INSERT INTO `gen_pays` VALUES ('BI', 'Burundi'); |
INSERT INTO `gen_pays` VALUES ('KH', 'Cambodge'); |
INSERT INTO `gen_pays` VALUES ('CM', 'Cameroun'); |
INSERT INTO `gen_pays` VALUES ('CA', 'Canada'); |
INSERT INTO `gen_pays` VALUES ('CV', 'Cap Vert'); |
INSERT INTO `gen_pays` VALUES ('CL', 'Chili'); |
INSERT INTO `gen_pays` VALUES ('CN', 'Chine'); |
INSERT INTO `gen_pays` VALUES ('CY', 'Chypre'); |
INSERT INTO `gen_pays` VALUES ('CO', 'Colombie'); |
INSERT INTO `gen_pays` VALUES ('KM', 'Comores'); |
INSERT INTO `gen_pays` VALUES ('CR', 'Costa Rica'); |
INSERT INTO `gen_pays` VALUES ('CI', 'Côte d\'Ivoire'); |
INSERT INTO `gen_pays` VALUES ('HR', 'Croatie'); |
INSERT INTO `gen_pays` VALUES ('CU', 'Cuba'); |
INSERT INTO `gen_pays` VALUES ('DK', 'Danemark'); |
INSERT INTO `gen_pays` VALUES ('DJ', 'Djibouti'); |
INSERT INTO `gen_pays` VALUES ('DM', 'Dominique'); |
INSERT INTO `gen_pays` VALUES ('EG', 'Egypte'); |
INSERT INTO `gen_pays` VALUES ('SV', 'Salvador'); |
INSERT INTO `gen_pays` VALUES ('AE', 'Emirats Arabes Unis'); |
INSERT INTO `gen_pays` VALUES ('EC', 'Equateur'); |
INSERT INTO `gen_pays` VALUES ('ER', 'Erythrée'); |
INSERT INTO `gen_pays` VALUES ('ES', 'Espagne'); |
INSERT INTO `gen_pays` VALUES ('EE', 'Estonie'); |
INSERT INTO `gen_pays` VALUES ('US', 'Etats-Unis'); |
INSERT INTO `gen_pays` VALUES ('ET', 'Ethiopie'); |
INSERT INTO `gen_pays` VALUES ('FJ', 'Fidji'); |
INSERT INTO `gen_pays` VALUES ('FI', 'Finlande'); |
INSERT INTO `gen_pays` VALUES ('FR', 'France'); |
INSERT INTO `gen_pays` VALUES ('GA', 'Gabon'); |
INSERT INTO `gen_pays` VALUES ('GM', 'Gambie'); |
INSERT INTO `gen_pays` VALUES ('GE', 'Géorgie'); |
INSERT INTO `gen_pays` VALUES ('GH', 'Ghana'); |
INSERT INTO `gen_pays` VALUES ('GR', 'Grèce'); |
INSERT INTO `gen_pays` VALUES ('GD', 'Grenade'); |
INSERT INTO `gen_pays` VALUES ('GL', 'Groenland'); |
INSERT INTO `gen_pays` VALUES ('GT', 'Guatémala'); |
INSERT INTO `gen_pays` VALUES ('GW', 'Guinée Bissau'); |
INSERT INTO `gen_pays` VALUES ('GQ', 'Guinée équatoriale'); |
INSERT INTO `gen_pays` VALUES ('GY', 'Guyana'); |
INSERT INTO `gen_pays` VALUES ('HT', 'Haïti'); |
INSERT INTO `gen_pays` VALUES ('HN', 'Honduras'); |
INSERT INTO `gen_pays` VALUES ('HU', 'Hongrie'); |
INSERT INTO `gen_pays` VALUES ('IN', 'Inde'); |
INSERT INTO `gen_pays` VALUES ('ID', 'Indonésie'); |
INSERT INTO `gen_pays` VALUES ('IQ', 'Irak'); |
INSERT INTO `gen_pays` VALUES ('IR', 'Iran'); |
INSERT INTO `gen_pays` VALUES ('IE', 'Irlande'); |
INSERT INTO `gen_pays` VALUES ('IS', 'Islande'); |
INSERT INTO `gen_pays` VALUES ('IL', 'Israël'); |
INSERT INTO `gen_pays` VALUES ('IT', 'Italie'); |
INSERT INTO `gen_pays` VALUES ('JM', 'Jamaïque'); |
INSERT INTO `gen_pays` VALUES ('JP', 'Japon'); |
INSERT INTO `gen_pays` VALUES ('JO', 'Jordanie'); |
INSERT INTO `gen_pays` VALUES ('KZ', 'Kazakhstan'); |
INSERT INTO `gen_pays` VALUES ('KE', 'Kenya'); |
INSERT INTO `gen_pays` VALUES ('KG', 'Kirghizstan'); |
INSERT INTO `gen_pays` VALUES ('KI', 'Kiribati'); |
INSERT INTO `gen_pays` VALUES ('KW', 'Koweït'); |
INSERT INTO `gen_pays` VALUES ('LS', 'Lesotho'); |
INSERT INTO `gen_pays` VALUES ('LV', 'Lettonie'); |
INSERT INTO `gen_pays` VALUES ('LB', 'Liban'); |
INSERT INTO `gen_pays` VALUES ('LR', 'Libéria'); |
INSERT INTO `gen_pays` VALUES ('LY', 'Libye'); |
INSERT INTO `gen_pays` VALUES ('LI', 'Liechtenstein'); |
INSERT INTO `gen_pays` VALUES ('LT', 'Lituanie'); |
INSERT INTO `gen_pays` VALUES ('LU', 'Luxembourg'); |
INSERT INTO `gen_pays` VALUES ('MK', 'Macédoine'); |
INSERT INTO `gen_pays` VALUES ('MG', 'Madagascar'); |
INSERT INTO `gen_pays` VALUES ('MY', 'Malaisie'); |
INSERT INTO `gen_pays` VALUES ('MW', 'Malawi'); |
INSERT INTO `gen_pays` VALUES ('MV', 'Maldives'); |
INSERT INTO `gen_pays` VALUES ('ML', 'Mali'); |
INSERT INTO `gen_pays` VALUES ('MT', 'Malte'); |
INSERT INTO `gen_pays` VALUES ('MA', 'Maroc'); |
INSERT INTO `gen_pays` VALUES ('MH', 'Marshall'); |
INSERT INTO `gen_pays` VALUES ('MU', 'Maurice'); |
INSERT INTO `gen_pays` VALUES ('MR', 'Mauritanie'); |
INSERT INTO `gen_pays` VALUES ('MX', 'Mexique'); |
INSERT INTO `gen_pays` VALUES ('FM', 'Micronésie'); |
INSERT INTO `gen_pays` VALUES ('MD', 'Moldavie'); |
INSERT INTO `gen_pays` VALUES ('MC', 'Monaco'); |
INSERT INTO `gen_pays` VALUES ('MN', 'Mongolie'); |
INSERT INTO `gen_pays` VALUES ('MZ', 'Mozambique'); |
INSERT INTO `gen_pays` VALUES ('NA', 'Namibie'); |
INSERT INTO `gen_pays` VALUES ('NR', 'Nauru'); |
INSERT INTO `gen_pays` VALUES ('NP', 'Népal'); |
INSERT INTO `gen_pays` VALUES ('NI', 'Nicaragua'); |
INSERT INTO `gen_pays` VALUES ('NE', 'Niger'); |
INSERT INTO `gen_pays` VALUES ('NG', 'Nigéria'); |
INSERT INTO `gen_pays` VALUES ('NO', 'Norvège'); |
INSERT INTO `gen_pays` VALUES ('NZ', 'Nouvelle-Zélande'); |
INSERT INTO `gen_pays` VALUES ('OM', 'Oman'); |
INSERT INTO `gen_pays` VALUES ('UG', 'Ouganda'); |
INSERT INTO `gen_pays` VALUES ('UZ', 'Ouzbekistan'); |
INSERT INTO `gen_pays` VALUES ('PK', 'Pakistan'); |
INSERT INTO `gen_pays` VALUES ('PW', 'Palau'); |
INSERT INTO `gen_pays` VALUES ('PS', 'Palestine'); |
INSERT INTO `gen_pays` VALUES ('PA', 'Panama'); |
INSERT INTO `gen_pays` VALUES ('PG', 'Papouasie - Nouvelle Guinée'); |
INSERT INTO `gen_pays` VALUES ('PY', 'Paraguay'); |
INSERT INTO `gen_pays` VALUES ('NL', 'Pays-Bas'); |
INSERT INTO `gen_pays` VALUES ('PE', 'Pérou'); |
INSERT INTO `gen_pays` VALUES ('PH', 'Philippines'); |
INSERT INTO `gen_pays` VALUES ('PL', 'Pologne'); |
INSERT INTO `gen_pays` VALUES ('PT', 'Portugal'); |
INSERT INTO `gen_pays` VALUES ('QA', 'Qatar'); |
INSERT INTO `gen_pays` VALUES ('CF', 'République Centrafricaine'); |
INSERT INTO `gen_pays` VALUES ('KR', 'République de Corée'); |
INSERT INTO `gen_pays` VALUES ('CD', 'République Démocratique du Congo'); |
INSERT INTO `gen_pays` VALUES ('KP', 'République Populaire Démocratique de Corée'); |
INSERT INTO `gen_pays` VALUES ('CZ', 'République Tchèque'); |
INSERT INTO `gen_pays` VALUES ('RO', 'Roumanie'); |
INSERT INTO `gen_pays` VALUES ('UK', 'Royaume-Uni'); |
INSERT INTO `gen_pays` VALUES ('RU', 'Russie (Europe)'); |
INSERT INTO `gen_pays` VALUES ('RW', 'Rwanda'); |
INSERT INTO `gen_pays` VALUES ('SM', 'San Marin'); |
INSERT INTO `gen_pays` VALUES ('VC', 'Saint Vincent et les Grenadines'); |
INSERT INTO `gen_pays` VALUES ('LC', 'Sainte Lucie'); |
INSERT INTO `gen_pays` VALUES ('SB', 'Salomon'); |
INSERT INTO `gen_pays` VALUES ('WS', 'Samoa'); |
INSERT INTO `gen_pays` VALUES ('ST', 'Sao Tomé et Principe'); |
INSERT INTO `gen_pays` VALUES ('SN', 'Sénégal'); |
INSERT INTO `gen_pays` VALUES ('SC', 'Seychelles'); |
INSERT INTO `gen_pays` VALUES ('SL', 'Sierra Leone'); |
INSERT INTO `gen_pays` VALUES ('SG', 'Singapour'); |
INSERT INTO `gen_pays` VALUES ('SK', 'Slovaquie'); |
INSERT INTO `gen_pays` VALUES ('SI', 'Slovénie'); |
INSERT INTO `gen_pays` VALUES ('SO', 'Somalie'); |
INSERT INTO `gen_pays` VALUES ('SD', 'Soudan'); |
INSERT INTO `gen_pays` VALUES ('LK', 'Sri Lanka'); |
INSERT INTO `gen_pays` VALUES ('SE', 'Suède'); |
INSERT INTO `gen_pays` VALUES ('CH', 'Suisse'); |
INSERT INTO `gen_pays` VALUES ('SR', 'Surinam'); |
INSERT INTO `gen_pays` VALUES ('SZ', 'Swaziland'); |
INSERT INTO `gen_pays` VALUES ('SY', 'Syrie'); |
INSERT INTO `gen_pays` VALUES ('TJ', 'Tadjikistan'); |
INSERT INTO `gen_pays` VALUES ('TZ', 'Tanzanie'); |
INSERT INTO `gen_pays` VALUES ('TD', 'Tchad'); |
INSERT INTO `gen_pays` VALUES ('TH', 'Thaïlande'); |
INSERT INTO `gen_pays` VALUES ('TG', 'Togo'); |
INSERT INTO `gen_pays` VALUES ('TO', 'Tonga'); |
INSERT INTO `gen_pays` VALUES ('TT', 'Trinité et Tobago'); |
INSERT INTO `gen_pays` VALUES ('TN', 'Tunisie'); |
INSERT INTO `gen_pays` VALUES ('TM', 'Turkmenistan'); |
INSERT INTO `gen_pays` VALUES ('TR', 'Turquie'); |
INSERT INTO `gen_pays` VALUES ('TV', 'Tuvalu'); |
INSERT INTO `gen_pays` VALUES ('UA', 'Ukraine'); |
INSERT INTO `gen_pays` VALUES ('UY', 'Uruguay'); |
INSERT INTO `gen_pays` VALUES ('VU', 'Vanuatu'); |
INSERT INTO `gen_pays` VALUES ('VE', 'Vénézuéla'); |
INSERT INTO `gen_pays` VALUES ('VN', 'Vietnam'); |
INSERT INTO `gen_pays` VALUES ('YE', 'Yémen'); |
INSERT INTO `gen_pays` VALUES ('YU', 'Yougoslavie'); |
INSERT INTO `gen_pays` VALUES ('ZM', 'Zambie'); |
INSERT INTO `gen_pays` VALUES ('ZW', 'Zimbabwe'); |
INSERT INTO `gen_pays` VALUES ('00', 'Pays non référencé'); |
INSERT INTO `gen_pays` VALUES ('CG', 'Congo'); |
INSERT INTO `gen_pays` VALUES ('GN', 'Guinée'); |
INSERT INTO `gen_pays` VALUES ('TW', 'Taïwan'); |
INSERT INTO `gen_pays` VALUES ('LA', 'Laos'); |
INSERT INTO `gen_pays` VALUES ('MM', 'Birmanie'); |
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `gen_region` |
# |
|
CREATE TABLE `gen_region` ( |
`gr_id_region` int(10) unsigned NOT NULL auto_increment, |
`gr_nom` int(10) unsigned default NULL, |
PRIMARY KEY (`gr_id_region`) |
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
|
# |
# Contenu de la table `gen_region` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `gen_statut` |
# |
|
CREATE TABLE `gen_statut` ( |
`gs_id_statut` int(10) unsigned NOT NULL default '0', |
`gs_label` varchar(64) default NULL, |
PRIMARY KEY (`gs_id_statut`) |
) TYPE=MyISAM; |
|
# |
# Contenu de la table `gen_statut` |
# |
|
INSERT INTO `gen_statut` VALUES (0, 'Administrateur'); |
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `gen_structure` |
# |
|
CREATE TABLE `gen_structure` ( |
`gst_id_structure` int(11) unsigned NOT NULL default '0', |
`gst_ce_structure_adhesion` int(10) unsigned NOT NULL default '0', |
`gst_nom` varchar(32) NOT NULL default '', |
`gst_description` varchar(255) default NULL, |
`gst_site_web` varchar(45) default NULL, |
`gst_adresse1` varchar(45) default NULL, |
`gst_adresse2` varchar(45) NOT NULL default '', |
`gst_fax` varchar(32) default NULL, |
`gst_telephone` varchar(32) default NULL, |
`gst_mail` varchar(128) NOT NULL default '', |
`gst_commentaire` text, |
PRIMARY KEY (`gst_id_structure`) |
) TYPE=MyISAM; |
|
# |
# Contenu de la table `gen_structure` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `gen_type_competence` |
# |
|
CREATE TABLE `gen_type_competence` ( |
`gtc_id_type_competence` int(11) unsigned NOT NULL default '0', |
`gtc_nom_type_competence` varchar(45) default NULL, |
`gtc_commentaire` text, |
PRIMARY KEY (`gtc_id_type_competence`) |
) TYPE=MyISAM; |
|
# |
# Contenu de la table `gen_type_competence` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `gen_type_structure` |
# |
|
CREATE TABLE `gen_type_structure` ( |
`gts_id_type_structure` int(10) unsigned NOT NULL auto_increment, |
`gts_ce_structure` int(11) unsigned NOT NULL default '0', |
`gts_nom` varchar(45) default NULL, |
`gts_description` varchar(255) default NULL, |
PRIMARY KEY (`gts_id_type_structure`) |
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
|
# |
# Contenu de la table `gen_type_structure` |
# |
|
|
# -------------------------------------------------------- |
|
# |
# Structure de la table `gen_ville` |
# |
|
CREATE TABLE `gen_ville` ( |
`gv_id_ville` int(10) unsigned NOT NULL auto_increment, |
`gv_nom` varchar(45) default NULL, |
`gv_codepostal` int(11) default NULL, |
PRIMARY KEY (`gv_id_ville`) |
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
|
# |
# Contenu de la table `gen_ville` |
# |
|