-- 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
|
Download
