Login   Register  
PHP Classes
elePHPant
Icontem

File: doc/create_tables-and-demo-data.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Pierre FAUQUE  >  Genealogy Classes  >  doc/create_tables-and-demo-data.sql  >  Download  
File: doc/create_tables-and-demo-data.sql
Role: Auxiliary data
Content type: text/plain
Description: Build a demo database
Class: Genealogy Classes
Manage genealogy trees for a family
Author: By
Last change: Change listing priority
Date: 2011-06-22 19:52
Size: 22,237 bytes
 

Contents

Class file image Download
-- Eventually :
-- CREATE DATABASE demo;
-- GRANT ALL PRIVILEGES on demo.* to user-x IDENTIFIED BY 'password';
-- USE demo;

--
-- Table structure for table `gen_Addresses`
--
DROP TABLE IF EXISTS `gen_Addresses`;
CREATE TABLE `gen_Addresses` (
  `idaddr` int(11) NOT NULL auto_increment COMMENT 'ID of an address',
  `addr` varchar(60) NOT NULL COMMENT 'Address libel',
  `acode` varchar(5) NOT NULL COMMENT 'Address zipcode',
  `aplac` varchar(30) NOT NULL COMMENT 'Address place (city)',
  `actry` char(2) NOT NULL COMMENT 'Address country',
  `aphon` varchar(15) NOT NULL COMMENT 'Phone at this address',
  `myobs` varchar(200) NOT NULL COMMENT 'My personnal comments',
  PRIMARY KEY  (`idaddr`)
) ENGINE=MyISAM COMMENT='Table of addresses';
--
-- Dumping data for table `gen_Addresses`
--
INSERT INTO `gen_Addresses` VALUES ('1','13 rue de la gare','56850','Caudan','fr','+33325329186','');



--
-- Table structure for table `gen_Marry`
--
DROP TABLE IF EXISTS `gen_Marry`;
CREATE TABLE `gen_Marry` (
  `idfam` int(11) NOT NULL auto_increment COMMENT 'ID of the family',
  `idh` int(11) NOT NULL default '0' COMMENT 'ID of the husband',
  `idw` int(11) NOT NULL default '0' COMMENT 'ID of the wife',
  `idunion` int(11) NOT NULL default '0' COMMENT 'ID of the union',
  `udate` varchar(10) NOT NULL COMMENT 'Date of the union',
  `uplac` varchar(30) NOT NULL COMMENT 'Place of the union (city)',
  `ucode` char(5) NOT NULL COMMENT 'Code of the city of the union',
  `uctry` char(2) NOT NULL COMMENT 'Country of the union',
  `usour` int(11) NOT NULL default '0' COMMENT 'Source of the union (document, act)',
  `idend` tinyint(4) NOT NULL default '0' COMMENT 'ID of the eventual end of union',
  `edate` varchar(10) NOT NULL COMMENT 'Date of this eventual end of union',
  `eplac` varchar(30) NOT NULL COMMENT 'Place of this eventual end of union (city)',
  `ecode` varchar(5) NOT NULL COMMENT 'Code of the city of this eventual end of union',
  `ectry` char(2) NOT NULL COMMENT 'Country of this eventual end of union',
  `uorder` int(11) NOT NULL default '0' COMMENT 'Order of this union (if several)',
  `nchi` tinyint(4) default NULL COMMENT 'Number of children (if known)',
  `myobs` varchar(200) NOT NULL COMMENT 'My personnal comments',
  PRIMARY KEY  (`idfam`,`idh`,`idw`)
) ENGINE=MyISAM COMMENT='Table of unions';
--
-- Dumping data for table `gen_Marry`
--
INSERT INTO `gen_Marry` VALUES ('1','1','2','2','20/05/1968','Brest','29019','fr','0','0','','','','','0','2','');
INSERT INTO `gen_Marry` VALUES ('2','5','6','2','12/02/1937','Lorient','56121','fr','0','0','','','','','0','3','');
INSERT INTO `gen_Marry` VALUES ('3','15','16','2','17/02/1903','Quimper','29232','fr','4','0','','','','','0',NULL,'');
INSERT INTO `gen_Marry` VALUES ('4','9','10','2','27/02/1902','Brest','29019','fr','0','0','','','','','0','5','');
INSERT INTO `gen_Marry` VALUES ('5','24','7','2','19/09/1962','Caen','14118','fr','0','0','','','','','0','4','');
INSERT INTO `gen_Marry` VALUES ('6','29','8','2','13/12/1970','Nantes','44109','fr','0','7','14/06/1981','Rennes','35238','fr','10','2','');
INSERT INTO `gen_Marry` VALUES ('7','33','32','2','12/08/1858','Goulven','29064','fr','3','0','','','','','0',NULL,'');
INSERT INTO `gen_Marry` VALUES ('8','36','8','2','27/11/1982','Cherbourg','50129','fr','0','0','','','','','20','1','');



--
-- Table structure for table `gen_Notes`
--
DROP TABLE IF EXISTS `gen_Notes`;
CREATE TABLE `gen_Notes` (
  `idnote` int(11) NOT NULL auto_increment COMMENT 'ID of the note',
  `idpers` int(11) NOT NULL COMMENT 'ID of the person',
  `nallow` tinyint(4) NOT NULL default '1' COMMENT 'Note allowed for display (0:no, 1:yes)',
  `note` varchar(250) NOT NULL COMMENT 'Note libel',
  `norder` int(11) NOT NULL COMMENT 'Order of this note for this person',
  PRIMARY KEY  (`idnote`),
  KEY `idpers` (`idpers`)
) ENGINE=MyISAM COMMENT='Table of event''s people';
--
-- Dumping data for table `gen_Notes`
--
INSERT INTO `gen_Notes` VALUES ('1','1','1','Fictitious informations (phones numbers, addresses, etc...)','0');



--
-- Table structure for table `gen_People`




--
DROP TABLE IF EXISTS `gen_People`;
CREATE TABLE `gen_People` (
  `idpers` int(11) NOT NULL auto_increment COMMENT 'ID of the person',
  `sex` enum('U','M','F') NOT NULL default 'U' COMMENT 'Sex of the person',
  `alias` varchar(30) NOT NULL COMMENT 'Alias of the person',
  `lname` varchar(30) NOT NULL COMMENT 'Last name',
  `fname` varchar(50) NOT NULL COMMENT 'First name',
  `bdate` varchar(10) NOT NULL COMMENT 'Date of birth',
  `bplac` varchar(30) NOT NULL COMMENT 'Place of birth',
  `bcode` char(5) NOT NULL COMMENT 'Code of the place of birth',
  `bctry` char(2) NOT NULL COMMENT 'Country of birth',
  `bsour` int(11) NOT NULL default '0' COMMENT 'Source of birth (document, act)',
  `ddate` varchar(10) NOT NULL COMMENT 'Date of death',
  `dplac` varchar(30) NOT NULL COMMENT 'Place of death',
  `dcode` char(5) NOT NULL COMMENT 'Code of the place of death',
  `dctry` char(2) NOT NULL COMMENT 'Country of death',
  `dsour` int(11) NOT NULL default '0' COMMENT 'Source of death (document, act)',
  `iplac` varchar(30) NOT NULL COMMENT 'Place of inhumation',
  `icode` char(5) NOT NULL COMMENT 'Code of place of inhumation',
  `ictry` char(2) NOT NULL COMMENT 'Country of inhumation',
  `idf` int(11) default '0' COMMENT 'ID of the Father',
  `idm` int(11) default '0' COMMENT 'ID of the Mother',
  `disp` int(11) NOT NULL default '1' COMMENT 'Display authorizations',
  `mail` varchar(50) NOT NULL COMMENT 'Mail of the person',
  `mphon` varchar(15) NOT NULL COMMENT 'Phone (mobile) of the person',
  `pic` varchar(25) NOT NULL COMMENT 'Picture filename',
  `pdate` varchar(10) NOT NULL COMMENT 'Year of the picture',
  `idaddr` int(11) NOT NULL default '0' COMMENT 'ID of his postal address',
  `porder` int(11) NOT NULL default '10' COMMENT 'Person order (in his family)',
  PRIMARY KEY  (`idpers`)
) ENGINE=MyISAM COMMENT='Table of people';
--
-- Dumping data for table `gen_People`
--
INSERT INTO `gen_People` VALUES ('1','M','','KERMAREC','Yann Marcel Denis','19/03/1945','Lorient','56121','fr','1','','','','','0','','','','5','6','119','yann.kermarec@my-isp.com','+33645881983','','2006','1','20');
INSERT INTO `gen_People` VALUES ('2','F','','LEBIHAN','Gwenn Soizic Eodez','21/05/1948','Brest','29019','fr','0','','','','','0','','','','0','0','97','','','','2007','0','10');
INSERT INTO `gen_People` VALUES ('3','F','','KERMAREC','Aziliz Kristell Youenn','05/06/1975','Brest','29019','fr','0','','','','','0','','','','1','2','97','','','','','0','20');
INSERT INTO `gen_People` VALUES ('4','M','','KERMAREC','Per Yann Erwan','03/02/1973','Brest','29019','fr','0','','','','','0','','','','1','2','97','','','','','0','10');
INSERT INTO `gen_People` VALUES ('5','M','Dad','KERMAREC','Paul Adrien Alan','21/06/1914','Lorient','56121','fr','0','18/08/1991','Vannes','56260','fr','0','','','','15','16','97','','','kermarec_paa.jpg','1988','0','60');
INSERT INTO `gen_People` VALUES ('6','F','Mum','LE GALL','Aourel Beatris Awen','23/01/1918','Caudan','56036','fr','2','','','','','0','','','','9','10','97','','','','2010','0','50');
INSERT INTO `gen_People` VALUES ('7','F','Nenog','KERMAREC','Nenog Fantig Gabig','29/03/1939','Hennebont','56083','fr','0','','','','','0','','','','5','6','97','','','','2010','0','10');
INSERT INTO `gen_People` VALUES ('8','F','Rozenn','KERMAREC','Rozenn Lucie Euriel','17/07/1950','Nantes','44109','fr','0','','','','','0','','','','5','6','97','','','kermarec_rle.jpg','2004','0','30');
INSERT INTO `gen_People` VALUES ('9','M','Grand-Pa François','LE GALL','François Per Malo','04/12/1879','Douarnenez','29046','fr','0','13/01/1941','Brest','29019','fr','0','','','','0','0','97','','','','1937','0','10');
INSERT INTO `gen_People` VALUES ('10','F','Grand-Ma Maiwen','MORVAN','Maiwenn Marivon Koupaia','02/06/1885','Rennes','35238','fr','0','02/11/1962','Morlaix','29151','fr','0','','','','0','0','97','','','','1953','0','10');
INSERT INTO `gen_People` VALUES ('11','M','Uncle René','LE GALL','René Pierrig Glaode','19/08/1905','Brest','29019','fr','0','25/09/1981','Paris 12°','75112','fr','0','','','','9','10','97','','','','','0','10');
INSERT INTO `gen_People` VALUES ('12','F','Aunt Soizic','LE GALL','Soizic Goulven','23/03/1908','Brest','29019','fr','0','28/08/1908','Brest','29019','fr','0','','','','9','10','97','','','','','0','20');
INSERT INTO `gen_People` VALUES ('13','F','Aunt Fernande','LE GALL','Fernande Kristell Elen','17/03/1909','Brest','29019','fr','0','28/12/1909','Brest','29019','fr','0','','','','9','10','97','','','','','0','30');
INSERT INTO `gen_People` VALUES ('14','F','Aunt Mary-Morgane','LE GALL','Mary-Morgane Denez Alar','24/02/1912','Caudan','56036','fr','0','18/09/1985','Lorient','56121','fr','0','','','','9','10','97','','','','','0','40');
INSERT INTO `gen_People` VALUES ('15','M','Grand-Pa Yann','KERMAREC','Yann Mazhe Loig','01/02/1873','Audierne','29003','fr','0','10/11/1952','Vannes','56260','fr','0','','','','33','32','97','','','kermarec_yml.jpg','1945','0','10');
INSERT INTO `gen_People` VALUES ('16','F','Grand-Ma Loeiz','TANGUY','Loeiz Mariannig Mael Katell','13/04/1885','Quimper','29232','fr','0','27/10/1947','Vannes','56260','fr','0','','','','0','0','97','','','','1938','0','10');
INSERT INTO `gen_People` VALUES ('17','F','Aunt Ael','KERMAREC','Ael Erell Denise','07/02/1905','Quimper','29232','fr','0','27/11/1985','Périgueux','24322','fr','0','','','','15','16','97','','','','','0','10');
INSERT INTO `gen_People` VALUES ('18','F','Aunt Arzela','KERMAREC','Arzela Jacqueline Awen','19/06/1906','Lorient','56121','fr','0','08/05/1998','Lorient','56121','fr','0','','','','15','16','97','','','','1996','0','20');
INSERT INTO `gen_People` VALUES ('19','F','Aunt Azou','KERMAREC','Azou Beatris Bellig','22/08/1907','Lorient','56121','fr','0','17/03/1977','Aurillac','15014','fr','0','','','','15','16','97','','','','','0','30');
INSERT INTO `gen_People` VALUES ('20','F','Aunt Urielle','KERMAREC','Urielle Eodez Elen','22/06/1909','Lorient','56121','fr','0','30/12/1910','Vannes','56260','fr','0','','','','15','16','97','','','','','0','40');
INSERT INTO `gen_People` VALUES ('21','M','Uncle Alan','KERMAREC','Alan Yves Erle Armel','02/07/1911','Vannes','56260','fr','0','14/06/1952','Rennes','35238','fr','0','','','','15','16','97','','','','1951','0','50');
INSERT INTO `gen_People` VALUES ('22','M','Uncle Ernoc\'h','KERMAREC','Ernoc\'h Atzul Pereg','10/04/1916','Lorient','56121','fr','0','27/09/1976','Lannion','22113','fr','0','','','','15','16','97','','','','','0','70');
INSERT INTO `gen_People` VALUES ('23','F','Aunt Soaz','KERMAREC','Soaz Aziliz Gwenvred','19/10/1917','Lorient','56121','fr','0','15/08/1999','Evreux','27229','fr','0','','','','15','16','97','','','','','0','80');
INSERT INTO `gen_People` VALUES ('24','M','','FOURRIER','Marc Georges André','03/03/1938','Deauville','14220','fr','0','','','','','0','','','','0','0','97','','','','','0','10');
INSERT INTO `gen_People` VALUES ('25','M','','FOURRIER','Denis Marc Henri','12/05/1963','Caen','14118','fr','0','','','','','0','','','','24','7','97','','','','','0','10');
INSERT INTO `gen_People` VALUES ('26','M','','FOURRIER','Jean-Paul Marc Auguste','29/08/1965','Caen','14118','fr','0','','','','','0','','','','24','7','97','','','','','0','20');
INSERT INTO `gen_People` VALUES ('27','M','','FOURRIER','Xavier Marc Gabriel Jean','16/09/1968','Caen','14118','fr','0','','','','','0','','','','24','7','97','','','','','0','30');
INSERT INTO `gen_People` VALUES ('28','M','','FOURRIER','Dominique Marc Jean-Luc','19/03/1972','Bayeux','14047','fr','0','','','','','0','','','','24','7','97','','','','','0','40');
INSERT INTO `gen_People` VALUES ('29','M','','GRENIER','Philippe Simon Robert','18/02/1949','Auch','32013','fr','0','','','','','0','','','','0','0','97','','','','','0','10');
INSERT INTO `gen_People` VALUES ('30','F','','GRENIER','Elisa Andrée Paule','15/05/1971','Carcassonne','11069','fr','0','','','','','0','','','','29','8','97','','','','2009','0','10');
INSERT INTO `gen_People` VALUES ('31','F','','GRENIER','Corinne Yseult Aliénor','16/03/1980','Carcassonne','11069','fr','0','','','','','0','','','','29','8','97','','','','2010','0','20');
INSERT INTO `gen_People` VALUES ('32','F','','LE GARREC','Eodez Aourell Benniged','28/03/1843','Botmeur','29013','fr','0','','','','fr','0','','','','0','0','97','','','','','0','10');
INSERT INTO `gen_People` VALUES ('33','M','','KERMAREC','Bleas Yvon Guido','18/04/1831','Douarnenez','29046','fr','0','','','','','0','','','','0','0','97','','','','','0','10');
INSERT INTO `gen_People` VALUES ('34','F','','KERMAREC','Corentin Linart Laouenan','20/10/1860','Goulven','29064','fr','0','','','','','0','','','','33','32','97','','','','','0','10');
INSERT INTO `gen_People` VALUES ('35','F','','KERMAREC','Katell Korydwenn Alar','19/04/1868','Goulven','29064','fr','0','','','','','0','','','','33','32','97','','','','','0','20');
INSERT INTO `gen_People` VALUES ('36','M','','MOREL','Jean-Marc Fernand Jules André','12/03/1947','Cherbourg','50129','fr','0','','','','','0','','','','0','0','97','jeanmarc.morel@wanadoo.fr','+33658417739','','','0','10');
INSERT INTO `gen_People` VALUES ('37','F','','MOREL','Isabelle Joëlle Emilie Blanche','13/05/1984','Bricquebec','50082','fr','0','','','','','0','','','','36','8','97','','','','2008','0','10');



--
-- Table structure for table `gen_Sources`
--
DROP TABLE IF EXISTS `gen_Sources`;
CREATE TABLE `gen_Sources` (
  `idsrc` int(11) NOT NULL auto_increment COMMENT 'ID of the source',
  `sallow` smallint(6) NOT NULL default '1' COMMENT 'Source allowed for display (0:no, 1:yes)',
  `file` varchar(40) NOT NULL COMMENT 'filename of the source (scanned document)',
  `source` varchar(200) NOT NULL COMMENT 'Reference of this document',
  PRIMARY KEY  (`idsrc`)
) ENGINE=MyISAM COMMENT='Table of sources';
--
-- Dumping data for table `gen_Sources`
--
INSERT INTO `gen_Sources` VALUES ('1','1','B1.jpg','');
INSERT INTO `gen_Sources` VALUES ('2','1','B6.jpg','');
INSERT INTO `gen_Sources` VALUES ('3','1','U7.jpg','');
INSERT INTO `gen_Sources` VALUES ('4','1','U3.jpg','');



--
-- Table structure for table `gen_Unions`
--
DROP TABLE IF EXISTS `gen_Unions`;
CREATE TABLE `gen_Unions` (
  `idunion` tinyint(4) NOT NULL auto_increment COMMENT 'ID of the type of union or end of union',
  `union` varchar(30) NOT NULL COMMENT 'Union or end of union libel',
  PRIMARY KEY  (`idunion`)
) ENGINE=MyISAM COMMENT='Table of types of unions';
--
-- Dumping data for table `gen_Unions`
--
INSERT INTO `gen_Unions` VALUES (1,'');
INSERT INTO `gen_Unions` VALUES (2,'Marriage');
INSERT INTO `gen_Unions` VALUES (3,'Cohabitation');
INSERT INTO `gen_Unions` VALUES (4,'PACS');
INSERT INTO `gen_Unions` VALUES (5,'Free union');
INSERT INTO `gen_Unions` VALUES (6,'Extramarital relationship');
INSERT INTO `gen_Unions` VALUES (7,'Divorce');
INSERT INTO `gen_Unions` VALUES (8,'Separation');
INSERT INTO `gen_Unions` VALUES (9,'Break-up');
INSERT INTO `gen_Unions` VALUES (10,'Unknown');



--
-- Table structure for table `gen_Visitors`
--
DROP TABLE IF EXISTS `gen_Visitors`;
CREATE TABLE `gen_Visitors` (
  `horodate` datetime NOT NULL COMMENT 'Datetime of the visit',
  `page` varchar(20) NOT NULL COMMENT 'Viewed page',
  `ip` varchar(15) NOT NULL COMMENT 'From this IP',
  PRIMARY KEY  (`horodate`)
) ENGINE=MyISAM COMMENT='Table of visitors (some pages: PDF and GED)';
--
-- Dumping data for table `gen_Visitors`
--



--
-- Table structure for table `geo_Cities`
--
DROP TABLE IF EXISTS `geo_Cities`;
CREATE TABLE `geo_Cities` (
  `insee` varchar(5) NOT NULL COMMENT 'ID of the city (INSEE number)',
  `city` varchar(40) NOT NULL COMMENT 'Name of the city',
  `code` varchar(5) NOT NULL COMMENT 'Zipcode of the city',
  `mcity` tinyint(4) NOT NULL COMMENT 'Main city of the department (0:no, 1:yes)',
  `lat` decimal(11,6) NOT NULL COMMENT 'Latitude',
  `lon` decimal(11,6) NOT NULL COMMENT 'Longitude',
  `iddep` char(3) NOT NULL COMMENT 'ID of the department',
  PRIMARY KEY  (`insee`)
) ENGINE=MyISAM COMMENT='Table of French cities';
--
-- Dumping data for table `geo_Cities`
-- Incomplete. Just for sample
--
INSERT INTO geo_Cities VALUES ('11069','Carcassonne','11000','1','43.216667','2.350000','11');
INSERT INTO geo_Cities VALUES ('14047','Bayeux','14400','0','49.266667','-0.700000','14');
INSERT INTO geo_Cities VALUES ('14118','Caen','14000','1','49.183333','-0.350000','14');
INSERT INTO geo_Cities VALUES ('14220','Deauville','14800','0','49.360000','0.075277','14');
INSERT INTO geo_Cities VALUES ('15014','Aurillac','15000','1','44.916667','2.450000','15');
INSERT INTO geo_Cities VALUES ('22113','Lannion','22300','0','48.733333','-3.466667','22');
INSERT INTO geo_Cities VALUES ('24322','Périgueux','24000','1','45.183333','0.716667','24');
INSERT INTO geo_Cities VALUES ('27229','Évreux','27000','1','49.016667','1.150000','27');
INSERT INTO geo_Cities VALUES ('29003','Audierne','29770','0','48.016667','-4.533333','29');
INSERT INTO geo_Cities VALUES ('29013','Botmeur','29690','0','48.383333','-3.916667','29');
INSERT INTO geo_Cities VALUES ('29019','Brest','29200','0','48.400000','-4.483333','29');
INSERT INTO geo_Cities VALUES ('29046','Douarnenez','29100','0','48.100000','-4.333333','29');
INSERT INTO geo_Cities VALUES ('29064','Goulven','29890','0','48.633333','-4.300000','29');
INSERT INTO geo_Cities VALUES ('29151','Morlaix','29600','0','48.583333','-3.833333','29');
INSERT INTO geo_Cities VALUES ('29232','Quimper','29000','1','48.000000','-4.100000','29');
INSERT INTO geo_Cities VALUES ('32013','Auch','32810','1','43.650000','0.583333','32');
INSERT INTO geo_Cities VALUES ('35238','Rennes','35000','1','48.083333','-1.683333','35');
INSERT INTO geo_Cities VALUES ('44109','Nantes','44200','1','47.216667','-1.550000','44');
INSERT INTO geo_Cities VALUES ('50082','Bricquebec','50260','0','49.466667','-1.633333','50');
INSERT INTO geo_Cities VALUES ('50129','Cherbourg','50100','0','49.650000','-1.650000','50');
INSERT INTO geo_Cities VALUES ('56036','Caudan','56850','0','47.816667','-3.333333','56');
INSERT INTO geo_Cities VALUES ('56083','Hennebont','56700','0','47.800000','-3.283333','56');
INSERT INTO geo_Cities VALUES ('56121','Lorient','56100','0','47.750000','-3.366667','56');
INSERT INTO geo_Cities VALUES ('56260','Vannes','56000','1','47.666667','-2.750000','56');
INSERT INTO geo_Cities VALUES ('75112','Paris 12°','75012','1','48.866667','2.333333','75');



--
-- Table structure for table `geo_Countries`
--
DROP TABLE IF EXISTS `geo_Countries`;
CREATE TABLE `geo_Countries` (
  `tld` varchar(3) NOT NULL COMMENT 'ID of the country (Top Level Domain)',
  `country` varchar(45) NOT NULL COMMENT 'Name of the country',
  PRIMARY KEY  (`tld`)
) ENGINE=MyISAM COMMENT='Table of countries';
--
-- Dumping data for table `geo_Countries`
-- Incomplete. Just for sample
--
INSERT INTO `geo_Countries` VALUES ('at','Autriche');
INSERT INTO `geo_Countries` VALUES ('be','Belgique');
INSERT INTO `geo_Countries` VALUES ('br','Brésil');
INSERT INTO `geo_Countries` VALUES ('ca','Canada');
INSERT INTO `geo_Countries` VALUES ('ch','Suisse');
INSERT INTO `geo_Countries` VALUES ('de','Allemagne');
INSERT INTO `geo_Countries` VALUES ('es','Espagne');
INSERT INTO `geo_Countries` VALUES ('fr','France');
INSERT INTO `geo_Countries` VALUES ('gr','Grèce');
INSERT INTO `geo_Countries` VALUES ('ie','Irelande');
INSERT INTO `geo_Countries` VALUES ('it','Italie');
INSERT INTO `geo_Countries` VALUES ('lu','Luxembourg');
INSERT INTO `geo_Countries` VALUES ('pt','Portugal');
INSERT INTO `geo_Countries` VALUES ('uk','Royaume Uni');



--
-- Table structure for table `geo_Departments`
--
DROP TABLE IF EXISTS `geo_Departments`;
CREATE TABLE `geo_Departments` (
  `iddep` varchar(3) NOT NULL COMMENT 'ID of the department',
  `idreg` tinyint(4) NOT NULL COMMENT 'ID of the region',
  `department` varchar(35) NOT NULL COMMENT 'Name of the department',
  PRIMARY KEY  (`iddep`)
) ENGINE=MyISAM COMMENT='Table of French departments';
--
-- Dumping data for table `geo_Departments`
-- Incomplete. Just for sample
--
INSERT INTO `geo_Departments` VALUES ('11',13,'Aude');
INSERT INTO `geo_Departments` VALUES ('14',4,'Calvados');
INSERT INTO `geo_Departments` VALUES ('15',3,'Cantal');
INSERT INTO `geo_Departments` VALUES ('22',6,'Côtes d\'Armor');
INSERT INTO `geo_Departments` VALUES ('24',2,'Dordogne');
INSERT INTO `geo_Departments` VALUES ('27',11,'Eure');
INSERT INTO `geo_Departments` VALUES ('29',6,'Finistère');
INSERT INTO `geo_Departments` VALUES ('32',16,'Gers');
INSERT INTO `geo_Departments` VALUES ('35',6,'Ile et Vilaine');
INSERT INTO `geo_Departments` VALUES ('44',18,'Loire Atlantique');
INSERT INTO `geo_Departments` VALUES ('50',4,'Manche');
INSERT INTO `geo_Departments` VALUES ('56',6,'Morbihan');
INSERT INTO `geo_Departments` VALUES ('75',12,'Ville de Paris');



--
-- Table structure for table `geo_Regions`
--
DROP TABLE IF EXISTS `geo_Regions`;
CREATE TABLE `geo_Regions` (
  `idreg` int(11) NOT NULL auto_increment COMMENT 'ID of the region',
  `region` varchar(30) NOT NULL COMMENT 'Name of the region',
  PRIMARY KEY (`idreg`)
) ENGINE=MyISAM COMMENT='Table of regions';
--
-- Dumping data for table `geo_Regions`
-- Incomplete. Just for sample
--
INSERT INTO `geo_Regions` VALUES (2,'Aquitaine');
INSERT INTO `geo_Regions` VALUES (3,'Auvergne');
INSERT INTO `geo_Regions` VALUES (4,'Basse-Normandie');
INSERT INTO `geo_Regions` VALUES (6,'Bretagne');
INSERT INTO `geo_Regions` VALUES (11,'Haute-Normandie');
INSERT INTO `geo_Regions` VALUES (12,'Ile-de-France');
INSERT INTO `geo_Regions` VALUES (13,'Languedoc-Roussillon');
INSERT INTO `geo_Regions` VALUES (16,'Midi-Pyrénées');
INSERT INTO `geo_Regions` VALUES (18,'Pays-de-la-Loire');


-- Dump completed on 2011-04-21  0:53:22