PHP Classes

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

Recommend this page to a friend!
  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: 12 years ago
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