--
-- Host: localhost    Database: kentuzenog
-- ------------------------------------------------------


--
-- Table structure for table `auth_group`
--

CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_group`
--


--
-- Table structure for table `auth_group_permissions`
--

CREATE TABLE `auth_group_permissions` (
  `id` int(11) NOT NULL auto_increment,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `group_id` (`group_id`,`permission_id`),
  KEY `auth_group_permissions_group_id` (`group_id`),
  KEY `auth_group_permissions_permission_id` (`permission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_group_permissions`
--


--
-- Table structure for table `auth_message`
--

CREATE TABLE `auth_message` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `message` longtext NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `auth_message_user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_message`
--


--
-- Table structure for table `auth_permission`
--

CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `content_type_id` (`content_type_id`,`codename`),
  KEY `auth_permission_content_type_id` (`content_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=76 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_permission`
--

INSERT INTO `auth_permission` VALUES (1,'Can add permission',1,'add_permission'),(2,'Can change permission',1,'change_permission'),(3,'Can delete permission',1,'delete_permission'),(4,'Can add group',2,'add_group'),(5,'Can change group',2,'change_group'),(6,'Can delete group',2,'delete_group'),(7,'Can add user',3,'add_user'),(8,'Can change user',3,'change_user'),(9,'Can delete user',3,'delete_user'),(10,'Can add message',4,'add_message'),(11,'Can change message',4,'change_message'),(12,'Can delete message',4,'delete_message'),(13,'Can add content type',5,'add_contenttype'),(14,'Can change content type',5,'change_contenttype'),(15,'Can delete content type',5,'delete_contenttype'),(16,'Can add session',6,'add_session'),(17,'Can change session',6,'change_session'),(18,'Can delete session',6,'delete_session'),(19,'Can add site',7,'add_site'),(20,'Can change site',7,'change_site'),(21,'Can delete site',7,'delete_site'),(22,'Can add log entry',8,'add_logentry'),(23,'Can change log entry',8,'change_logentry'),(24,'Can delete log entry',8,'delete_logentry'),(25,'Can add reference',9,'add_reference'),(26,'Can change reference',9,'change_reference'),(27,'Can delete reference',9,'delete_reference'),(28,'Can add patronym',10,'add_patronym'),(29,'Can change patronym',10,'change_patronym'),(30,'Can delete patronym',10,'delete_patronym'),(31,'Can add given name',11,'add_givenname'),(32,'Can change given name',11,'change_givenname'),(33,'Can delete given name',11,'delete_givenname'),(34,'Can add family name',12,'add_familyname'),(35,'Can change family name',12,'change_familyname'),(36,'Can delete family name',12,'delete_familyname'),(37,'Can add person occurrence',13,'add_personoccurrence'),(38,'Can change person occurrence',13,'change_personoccurrence'),(39,'Can delete person occurrence',13,'delete_personoccurrence'),(40,'Can add given name position',14,'add_givennameposition'),(41,'Can change given name position',14,'change_givennameposition'),(42,'Can delete given name position',14,'delete_givennameposition'),(43,'Can add publisher',15,'add_publisher'),(44,'Can change publisher',15,'change_publisher'),(45,'Can delete publisher',15,'delete_publisher'),(46,'Can add author',16,'add_author'),(47,'Can change author',16,'change_author'),(48,'Can delete author',16,'delete_author'),(49,'Can add book category',17,'add_bookcategory'),(50,'Can change book category',17,'change_bookcategory'),(51,'Can delete book category',17,'delete_bookcategory'),(52,'Can add book',18,'add_book'),(53,'Can change book',18,'change_book'),(54,'Can delete book',18,'delete_book'),(55,'Can add statoid level',19,'add_statoidlevel'),(56,'Can change statoid level',19,'change_statoidlevel'),(57,'Can delete statoid level',19,'delete_statoidlevel'),(58,'Can add statoid',20,'add_statoid'),(59,'Can change statoid',20,'change_statoid'),(60,'Can delete statoid',20,'delete_statoid'),(61,'Can add Country',21,'add_country'),(62,'Can change Country',21,'change_country'),(63,'Can delete Country',21,'delete_country'),(64,'Can add Region',22,'add_region'),(65,'Can change Region',22,'change_region'),(66,'Can delete Region',22,'delete_region'),(67,'Can add Province/State',23,'add_provinceorstate'),(68,'Can change Province/State',23,'change_provinceorstate'),(69,'Can delete Province/State',23,'delete_provinceorstate'),(70,'Can add Municipality',24,'add_municipality'),(71,'Can change Municipality',24,'change_municipality'),(72,'Can delete Municipality',24,'delete_municipality'),(73,'Can add Town',25,'add_town'),(74,'Can change Town',25,'change_town'),(75,'Can delete Town',25,'delete_town');

--
-- Table structure for table `auth_user_groups`
--

CREATE TABLE `auth_user_groups` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user_id` (`user_id`,`group_id`),
  KEY `auth_user_groups_user_id` (`user_id`),
  KEY `auth_user_groups_group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_user_groups`
--


--
-- Table structure for table `auth_user_user_permissions`
--

CREATE TABLE `auth_user_user_permissions` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user_id` (`user_id`,`permission_id`),
  KEY `auth_user_user_permissions_user_id` (`user_id`),
  KEY `auth_user_user_permissions_permission_id` (`permission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_user_user_permissions`
--


--
-- Table structure for table `django_admin_log`
--

CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL auto_increment,
  `action_time` datetime NOT NULL,
  `user_id` int(11) NOT NULL,
  `content_type_id` int(11) default NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `django_admin_log_user_id` (`user_id`),
  KEY `django_admin_log_content_type_id` (`content_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `django_admin_log`
--

INSERT INTO `django_admin_log` VALUES (1,'2010-04-11 09:46:54',1,17,'1','Reeks: Kent u ze nog...',1,''),(2,'2010-04-11 09:47:05',1,17,'2','Reeks: In oude ansichten',1,''),(3,'2010-04-11 09:51:41',1,15,'1','Europese Bibliotheek',1,''),(4,'2010-04-11 09:52:16',1,16,'1','C.P. Pols',1,''),(5,'2010-04-11 10:14:44',1,18,'1','Kruiningen in oude ansichten',1,''),(6,'2010-04-11 10:15:00',1,18,'1','Kruiningen in oude ansichten',2,'Changed publication_place.'),(7,'2010-04-11 10:16:35',1,18,'1','Kruiningen in oude ansichten',2,'Changed isbn13.'),(8,'2010-04-11 20:33:52',1,15,'1','Europese Bibliotheek',2,'Changed location.'),(9,'2010-04-11 20:35:51',1,18,'1','Kruiningen in oude ansichten',2,'Changed authors.'),(10,'2010-04-11 21:05:22',1,15,'6','',3,''),(11,'2010-04-11 21:09:48',1,15,'1','Europese Bibliotheek',2,'Changed website, street_name, number, postcode and town.'),(12,'2010-04-11 21:11:03',1,15,'2','Deboektant',2,'Changed website, street_name, number, postcode and town.'),(13,'2010-04-11 21:12:24',1,15,'3','Van Geyt productions',2,'Changed street_name, number, postcode and town.'),(14,'2010-04-11 21:13:37',1,15,'4','Slingenberg Boekproducties',2,'Changed street_name, number, postcode and town.'),(15,'2010-04-11 21:15:17',1,15,'5','Steengracht',2,'Changed street_name, number, postcode and town.'),(16,'2010-04-11 21:15:28',1,15,'5','Uitgeverij Steengracht',2,'Changed name.'),(17,'2010-04-11 21:17:17',1,15,'7','Walburg Pers',2,'Changed website, street_name, number, postcode and town.'),(18,'2010-04-11 21:18:38',1,15,'8','Boekhandel Los',2,'Changed website, street_name, number, postcode and town.'),(19,'2010-04-11 21:20:48',1,15,'9','Drukkerij D E B O',2,'Changed town.'),(20,'2010-04-11 21:27:53',1,16,'1','C. van Winkelen',2,'Changed first_name and last_name.'),(21,'2010-04-11 21:28:01',1,16,'33','D.  Franzen',2,'Changed first_name and last_name.'),(22,'2010-04-11 21:28:07',1,16,'17','Jacky Nijsen',2,'Changed first_name and last_name.'),(23,'2010-04-11 21:28:21',1,16,'18','M.J. Geuze',2,'Changed first_name and last_name.'),(24,'2010-04-11 21:28:28',1,16,'32','Gerard G. de Fouw',2,'Changed first_name and last_name.');

--
-- Table structure for table `django_content_type`
--

CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `app_label` (`app_label`,`model`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `django_content_type`
--

INSERT INTO `django_content_type` VALUES (1,'permission','auth','permission'),(2,'group','auth','group'),(3,'user','auth','user'),(4,'message','auth','message'),(5,'content type','contenttypes','contenttype'),(6,'session','sessions','session'),(7,'site','sites','site'),(8,'log entry','admin','logentry'),(9,'reference','kentuzenog','reference'),(10,'patronym','kentuzenog','patronym'),(11,'given name','kentuzenog','givenname'),(12,'family name','kentuzenog','familyname'),(13,'person occurrence','kentuzenog','personoccurrence'),(14,'given name position','kentuzenog','givennameposition'),(15,'publisher','publishing','publisher'),(16,'author','publishing','author'),(17,'book category','publishing','bookcategory'),(18,'book','publishing','book'),(19,'statoid level','geo','statoidlevel'),(20,'statoid','geo','statoid'),(21,'Country','geo','country'),(22,'Region','geo','region'),(23,'Province/State','geo','provinceorstate'),(24,'Municipality','geo','municipality'),(25,'Town','geo','town'),(26,'statoid polygon','geo','statoidpolygon');

--
-- Table structure for table `django_site`
--

CREATE TABLE `django_site` (
  `id` int(11) NOT NULL auto_increment,
  `domain` varchar(100) NOT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `django_site`
--

INSERT INTO `django_site` VALUES (1,'example.com','example.com');

--
-- Table structure for table `geo_country`
--

CREATE TABLE `geo_country` (
  `statoid_ptr_id` int(11) NOT NULL,
  PRIMARY KEY  (`statoid_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `geo_country`
--


--
-- Table structure for table `geo_municipality`
--

CREATE TABLE `geo_municipality` (
  `statoid_ptr_id` int(11) NOT NULL,
  PRIMARY KEY  (`statoid_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `geo_municipality`
--


--
-- Table structure for table `geo_provinceorstate`
--

CREATE TABLE `geo_provinceorstate` (
  `statoid_ptr_id` int(11) NOT NULL,
  `country_id` int(11) NOT NULL,
  `region_id` int(11) default NULL,
  PRIMARY KEY  (`statoid_ptr_id`),
  KEY `geo_provinceorstate_country_id` (`country_id`),
  KEY `geo_provinceorstate_region_id` (`region_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `geo_provinceorstate`
--


--
-- Table structure for table `geo_region`
--

CREATE TABLE `geo_region` (
  `statoid_ptr_id` int(11) NOT NULL,
  `country_id` int(11) NOT NULL,
  PRIMARY KEY  (`statoid_ptr_id`),
  KEY `geo_region_country_id` (`country_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `geo_region`
--


--
-- Table structure for table `geo_statoid`
--

CREATE TABLE `geo_statoid` (
  `id` int(11) NOT NULL auto_increment,
  `location` varchar(50) NOT NULL,
  `type` varchar(20) NOT NULL,
  `name` varchar(120) NOT NULL,
  `uid` varchar(36) NOT NULL,
  `ucode` varchar(255) NOT NULL,
  `tcode` varchar(255) NOT NULL,
  `ccode` varchar(255) NOT NULL,
  `scode` varchar(50) NOT NULL,
  `mcode` varchar(50) NOT NULL,
  `name_search` varchar(255) NOT NULL,
  `lcode_name` varchar(2) NOT NULL,
  `level_id` int(11) NOT NULL,
  `level_subtype` int(11) NOT NULL,
  `sort_order` varchar(5) NOT NULL,
  `start_date` date default NULL,
  `end_date` date default NULL,
  PRIMARY KEY  (`id`),
  KEY `geo_statoid_level_id` (`level_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `geo_statoid`
--


--
-- Table structure for table `geo_statoidlevel`
--

CREATE TABLE `geo_statoidlevel` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `geo_statoidlevel`
--


--
-- Table structure for table `geo_town`
--

CREATE TABLE `geo_town` (
  `statoid_ptr_id` int(11) NOT NULL,
  PRIMARY KEY  (`statoid_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `geo_town`
--


--
-- Table structure for table `kentuzenog_familyname`
--

CREATE TABLE `kentuzenog_familyname` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(60) NOT NULL,
  `sort_name` varchar(60) NOT NULL,
  `normalized_name_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `kentuzenog_familyname_normalized_name_id` (`normalized_name_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kentuzenog_familyname`
--


--
-- Table structure for table `kentuzenog_givenname`
--

CREATE TABLE `kentuzenog_givenname` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(40) NOT NULL,
  `gender` varchar(1) NOT NULL,
  `normalized_name_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `kentuzenog_givenname_normalized_name_id` (`normalized_name_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kentuzenog_givenname`
--


--
-- Table structure for table `kentuzenog_givennameposition`
--

CREATE TABLE `kentuzenog_givennameposition` (
  `id` int(11) NOT NULL auto_increment,
  `given_name_id` int(11) NOT NULL,
  `person_occurrence_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `kentuzenog_givennameposition_given_name_id` (`given_name_id`),
  KEY `kentuzenog_givennameposition_person_occurrence_id` (`person_occurrence_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kentuzenog_givennameposition`
--


--
-- Table structure for table `kentuzenog_patronym`
--

CREATE TABLE `kentuzenog_patronym` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(40) NOT NULL,
  `gender` varchar(1) NOT NULL,
  `normalized_name_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `kentuzenog_patronym_normalized_name_id` (`normalized_name_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kentuzenog_patronym`
--


--
-- Table structure for table `kentuzenog_personoccurrence`
--

CREATE TABLE `kentuzenog_personoccurrence` (
  `id` int(11) NOT NULL auto_increment,
  `reference_id` int(11) NOT NULL,
  `birth_name_id` int(11) NOT NULL,
  `married_name_id` int(11) NOT NULL,
  `patronym_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `kentuzenog_personoccurrence_reference_id` (`reference_id`),
  KEY `kentuzenog_personoccurrence_birth_name_id` (`birth_name_id`),
  KEY `kentuzenog_personoccurrence_married_name_id` (`married_name_id`),
  KEY `kentuzenog_personoccurrence_patronym_id` (`patronym_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kentuzenog_personoccurrence`
--


--
-- Table structure for table `kentuzenog_reference`
--

CREATE TABLE `kentuzenog_reference` (
  `id` int(11) NOT NULL auto_increment,
  `location` varchar(50) NOT NULL,
  `type` varchar(20) NOT NULL,
  `name` varchar(120) NOT NULL,
  `street_name` varchar(50) NOT NULL,
  `number` int(11) default NULL,
  `number_suffix` varchar(20) NOT NULL,
  `town_id` int(11) default NULL,
  `postcode` varchar(10) NOT NULL,
  `book_id` int(11) NOT NULL,
  `page` int(11) NOT NULL,
  `page_location` varchar(10) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `kentuzenog_reference_town_id` (`town_id`),
  KEY `kentuzenog_reference_book_id` (`book_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kentuzenog_reference`
--


--
-- Table structure for table `publishing_author`
--

CREATE TABLE `publishing_author` (
  `id` int(11) NOT NULL auto_increment,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `tussenvoegsel` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `publishing_author`
--

INSERT INTO `publishing_author` VALUES (1,'C.','van Winkelen',''),(2,'R.A. van de Vrede & A. Goeman','',''),(3,'L.J. Abelmann & Kr. Goudzwaard','',''),(4,'G.J. Lepoeter Tzn.','',''),(5,'Cor Pols','',''),(6,'Allie Barth & Leen Moerland','',''),(7,'Y.Y. Keukelaar-Coppens & P.H. Keukelaar','',''),(8,'A.J. Barth & L.J. Moerland','',''),(9,'W.P. de Vrieze','',''),(10,'Piet Boot','',''),(11,'J.L. Braber & C.P. Pols','',''),(12,'C.P. Pols','',''),(13,'J.L. Braber','',''),(14,'Rachel v.d. Vrede en Albert Goeman','',''),(15,'J.L. Braber & W.P. de Vrieze','',''),(16,'A.J. Broekert','',''),(17,'Jacky','Nijsen',''),(18,'M.J.','Geuze',''),(19,'G.W. Kattenbeld','',''),(20,'J.J. Engelvaart','',''),(21,'H.P. Huisman','',''),(22,'K. Faase','',''),(23,'Peter Sijnke, Monique Vaal en Anneke van Waarden','',''),(24,'Rob van Ginkel','',''),(25,'Archiefdienst gem. Goes','',''),(26,'Mat Weststrate','',''),(27,'K.C. van Bijlevelt','',''),(28,'dr. A.C.J. de Vrankrijker','',''),(29,'Martin Heyne','',''),(30,'Cor Joziasse','',''),(31,'P. Bouwman en C. v.d. Bovenkamp','',''),(32,'Gerard G.','de Fouw',''),(33,'D. ','Franzen','');

--
-- Table structure for table `publishing_book`
--

CREATE TABLE `publishing_book` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `category_id` int(11) NOT NULL,
  `description` varchar(255) NOT NULL,
  `publisher_id` int(11) NOT NULL,
  `isbn10` bigint(20) unsigned default NULL,
  `isbn13` bigint(20) unsigned default NULL,
  `publication_year` int(11) NOT NULL,
  `publication_place_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `publishing_book_category_id` (`category_id`),
  KEY `publishing_book_publisher_id` (`publisher_id`),
  KEY `publishing_book_publication_place_id` (`publication_place_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `publishing_book`
--

INSERT INTO `publishing_book` VALUES (1,'Kruiningen in oude ansichten',2,'',1,NULL,9789028844070,1975,36732);

--
-- Table structure for table `publishing_book_authors`
--

CREATE TABLE `publishing_book_authors` (
  `id` int(11) NOT NULL auto_increment,
  `book_id` int(11) NOT NULL,
  `author_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `book_id` (`book_id`,`author_id`),
  KEY `author_id_refs_id_15d7bfe6` (`author_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `publishing_book_authors`
--

INSERT INTO `publishing_book_authors` VALUES (1,1,1);

--
-- Table structure for table `publishing_bookcategory`
--

CREATE TABLE `publishing_bookcategory` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `publishing_bookcategory`
--

INSERT INTO `publishing_bookcategory` VALUES (1,'Reeks: Kent u ze nog...'),(2,'Reeks: In oude ansichten'),(3,'Reeks: Ons dorp'),(4,'Reeks: In vroeger tijden'),(5,'Overige');

--
-- Table structure for table `publishing_publisher`
--

CREATE TABLE `publishing_publisher` (
  `id` int(11) NOT NULL auto_increment,
  `location` varchar(50) NOT NULL,
  `type` varchar(20) NOT NULL,
  `name` varchar(120) NOT NULL,
  `street_name` varchar(50) NOT NULL,
  `number` int(11) default NULL,
  `number_suffix` varchar(20) NOT NULL,
  `town_id` int(11) default NULL,
  `postcode` varchar(10) NOT NULL,
  `website` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `publishing_publisher_town_id` (`town_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `publishing_publisher`
--

INSERT INTO `publishing_publisher` VALUES (1,'500,500','PUBLISHER','Europese Bibliotheek','Boerenkamplaan',179,'',39597,'5712 AD','http://www.eurobib.nl'),(2,'500,500','PUBLISHER','Deboektant','Oud Cromstrijensedijk WZ',98,'',38235,'3286 BV','http://www.deboektant.nl/'),(3,'500,500','PUBLISHER','Van Geyt productions','Steenstraat',20,'',37747,'4561 AS',''),(4,'500,500','PUBLISHER','Slingenberg Boekproducties','Voor de Blanken',1,'',34619,'7963 RP',''),(5,'500,500','PUBLISHER','Uitgeverij Steengracht','Ring',15,'',38089,'4315 AE',''),(7,'500,500','PUBLISHER','Walburg Pers','Zaadmarkt',86,'',36652,'7201 DE','http://www.walburgpers.nl/'),(8,'500,500','PUBLISHER','Boekhandel Los','Nassaulaan',33,'',37032,'1404 CM','http://www.boekhandellos.nl/'),(9,'500,500','PUBLISHER','Drukkerij D E B O','',NULL,'',20116,'','');


