Subversion Repositories Applications.papyrus

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

# 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`

#