Subversion Repositories Applications.bazar

Compare Revisions

No changes between revisions

Ignore whitespace Rev 1 → Rev 2

/trunk/documentation/creation_DB_bazar.sql
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 d’emploi ayant un rapport avec l\'EE. Les demandes d’emploi 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`
#
 
/trunk/documentation/bazar.xml
New file
0,0 → 1,1017
<?xml version="1.0" standalone="yes" ?>
<DBMODEL Version="4.0">
<SETTINGS>
<GLOBALSETTINGS ModelName="modele_ij" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="83.00" XPos="201" YPos="286" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="" DefQueryDBConn="" Printer="" HPageCount="4.0" PageAspectRatio="1.440892512336408" PageOrientation="1" PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="" UsePositionGrid="0" PositionGridX="20" PositionGridY="20" TableNameInRefs="1" DefaultTableType="0" ActivateRefDefForNewRelations="1" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="0" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="Nimbus Sans L" CanvasWidth="4096" CanvasHeight="2842" />
<DATATYPEGROUPS>
<DATATYPEGROUP Name="Numeric Types" Icon="1" />
<DATATYPEGROUP Name="Date and Time Types" Icon="2" />
<DATATYPEGROUP Name="String Types" Icon="3" />
<DATATYPEGROUP Name="Blob and Text Types" Icon="4" />
<DATATYPEGROUP Name="User defined Types" Icon="5" />
<DATATYPEGROUP Name="Geographic Types" Icon="6" />
</DATATYPEGROUPS>
<DATATYPES>
<DATATYPE ID="1" IDGroup="0" TypeName="TINYINT" Description="A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
</PARAMS>
<OPTIONS>
<OPTION Name="UNSIGNED" Default="1" />
<OPTION Name="ZEROFILL" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="2" IDGroup="0" TypeName="SMALLINT" Description="A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
</PARAMS>
<OPTIONS>
<OPTION Name="UNSIGNED" Default="1" />
<OPTION Name="ZEROFILL" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="3" IDGroup="0" TypeName="MEDIUMINT" Description="A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
</PARAMS>
<OPTIONS>
<OPTION Name="UNSIGNED" Default="1" />
<OPTION Name="ZEROFILL" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="4" IDGroup="0" TypeName="INT" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
</PARAMS>
<OPTIONS>
<OPTION Name="UNSIGNED" Default="0" />
<OPTION Name="ZEROFILL" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="5" IDGroup="0" TypeName="INTEGER" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
</PARAMS>
<OPTIONS>
<OPTION Name="UNSIGNED" Default="1" />
<OPTION Name="ZEROFILL" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="6" IDGroup="0" TypeName="BIGINT" Description="A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
</PARAMS>
<OPTIONS>
<OPTION Name="UNSIGNED" Default="0" />
<OPTION Name="ZEROFILL" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="7" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="precision" />
</PARAMS>
<OPTIONS>
<OPTION Name="ZEROFILL" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="8" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
<PARAM Name="decimals" />
</PARAMS>
<OPTIONS>
<OPTION Name="ZEROFILL" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="9" IDGroup="0" TypeName="DOUBLE" Description="A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
<PARAM Name="decimals" />
</PARAMS>
<OPTIONS>
<OPTION Name="ZEROFILL" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="10" IDGroup="0" TypeName="DOUBLE PRECISION" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
<PARAM Name="decimals" />
</PARAMS>
<OPTIONS>
<OPTION Name="ZEROFILL" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="11" IDGroup="0" TypeName="REAL" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
<PARAM Name="decimals" />
</PARAMS>
<OPTIONS>
<OPTION Name="ZEROFILL" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="12" IDGroup="0" TypeName="DECIMAL" Description="An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
<PARAM Name="decimals" />
</PARAMS>
<OPTIONS>
<OPTION Name="ZEROFILL" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="13" IDGroup="0" TypeName="NUMERIC" Description="This is a synonym for DECIMAL." ParamCount="2" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
<PARAM Name="decimals" />
</PARAMS>
<OPTIONS>
<OPTION Name="ZEROFILL" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="14" IDGroup="1" TypeName="DATE" Description="A date. The supported range is \a1000-01-01\a to \a9999-12-31\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="15" IDGroup="1" TypeName="DATETIME" Description="A date and time combination. The supported range is \a1000-01-01 00:00:00\a to \a9999-12-31 23:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="16" IDGroup="1" TypeName="TIMESTAMP" Description="A timestamp. The range is \a1970-01-01 00:00:00\a to sometime in the year 2037. The length can be 14 (or missing), 12, 10, 8, 6, 4, or 2 representing YYYYMMDDHHMMSS, ... , YYYYMMDD, ... , YY formats." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
</PARAMS>
</DATATYPE>
<DATATYPE ID="17" IDGroup="1" TypeName="TIME" Description="A time. The range is \a-838:59:59\a to \a838:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="18" IDGroup="1" TypeName="YEAR" Description="A year in 2- or 4-digit format (default is 4-digit)." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
</PARAMS>
</DATATYPE>
<DATATYPE ID="19" IDGroup="2" TypeName="CHAR" Description="A fixed-length string (1 to 255 characters) that is always right-padded with spaces to the specified length when stored. values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
</PARAMS>
<OPTIONS>
<OPTION Name="BINARY" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="20" IDGroup="2" TypeName="VARCHAR" Description="A variable-length string (1 to 255 characters). Values are sorted and compared in case-sensitive fashion unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="length" />
</PARAMS>
<OPTIONS>
<OPTION Name="BINARY" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="21" IDGroup="2" TypeName="BIT" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="22" IDGroup="2" TypeName="BOOL" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="23" IDGroup="3" TypeName="TINYBLOB" Description="A column maximum length of 255 (2^8 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="24" IDGroup="3" TypeName="BLOB" Description="A column maximum length of 65535 (2^16 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="25" IDGroup="3" TypeName="MEDIUMBLOB" Description="A column maximum length of 16777215 (2^24 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="26" IDGroup="3" TypeName="LONGBLOB" Description="A column maximum length of 4294967295 (2^32 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="27" IDGroup="3" TypeName="TINYTEXT" Description="A column maximum length of 255 (2^8 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="28" IDGroup="3" TypeName="TEXT" Description="A column maximum length of 65535 (2^16 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="29" IDGroup="3" TypeName="MEDIUMTEXT" Description="A column maximum length of 16777215 (2^24 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="30" IDGroup="3" TypeName="LONGTEXT" Description="A column maximum length of 4294967295 (2^32 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="31" IDGroup="3" TypeName="ENUM" Description="An enumeration. A string object that can have only one value, chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="values" />
</PARAMS>
</DATATYPE>
<DATATYPE ID="32" IDGroup="3" TypeName="SET" Description="A set. A string object that can have zero or more values, each of which must be chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<PARAMS>
<PARAM Name="values" />
</PARAMS>
</DATATYPE>
<DATATYPE ID="33" IDGroup="4" TypeName="Varchar(20)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<OPTIONS>
<OPTION Name="BINARY" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="34" IDGroup="4" TypeName="Varchar(45)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<OPTIONS>
<OPTION Name="BINARY" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="35" IDGroup="4" TypeName="Varchar(255)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
<OPTIONS>
<OPTION Name="BINARY" Default="0" />
</OPTIONS>
</DATATYPE>
<DATATYPE ID="36" IDGroup="5" TypeName="GEOMETRY" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="38" IDGroup="5" TypeName="LINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="39" IDGroup="5" TypeName="POLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="40" IDGroup="5" TypeName="MULTIPOINT" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="41" IDGroup="5" TypeName="MULTILINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="42" IDGroup="5" TypeName="MULTIPOLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
<DATATYPE ID="43" IDGroup="5" TypeName="GEOMETRYCOLLECTION" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
</DATATYPE>
</DATATYPES>
<COMMON_DATATYPES>
<COMMON_DATATYPE ID="5" />
<COMMON_DATATYPE ID="8" />
<COMMON_DATATYPE ID="20" />
<COMMON_DATATYPE ID="15" />
<COMMON_DATATYPE ID="22" />
<COMMON_DATATYPE ID="28" />
<COMMON_DATATYPE ID="26" />
<COMMON_DATATYPE ID="33" />
<COMMON_DATATYPE ID="34" />
<COMMON_DATATYPE ID="35" />
</COMMON_DATATYPES>
<TABLEPREFIXES>
<TABLEPREFIX Name="Default (no prefix)" />
</TABLEPREFIXES>
<REGIONCOLORS>
<REGIONCOLOR Color="Red=#FFEEEC" />
<REGIONCOLOR Color="Yellow=#FEFDED" />
<REGIONCOLOR Color="Green=#EAFFE5" />
<REGIONCOLOR Color="Cyan=#ECFDFF" />
<REGIONCOLOR Color="Blue=#F0F1FE" />
<REGIONCOLOR Color="Magenta=#FFEBFA" />
</REGIONCOLORS>
<POSITIONMARKERS>
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
</POSITIONMARKERS>
</SETTINGS>
<METADATA>
<REGIONS>
+
+</REGIONS>
+<TABLES>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+</TABLES>
+<RELATIONS>
+
+
+
+
+
+
+
+
+</RELATIONS>
+<NOTES>
+</NOTES>
+<IMAGES>
+
+</IMAGES>
+</METADATA>
+<PLUGINDATA>
+<PLUGINDATARECORDS>
+</PLUGINDATARECORDS>
+</PLUGINDATA>
+<QUERYDATA>
+<QUERYRECORDS>
+</QUERYRECORDS>
+</QUERYDATA>
+<LINKEDMODELS>
+</LINKEDMODELS>
+</DBMODEL>