-- MySQL dump 9.10
--
-- Host: localhost    Database: mylibrary
-- ------------------------------------------------------
-- Server version	4.0.18-Max

--
-- Table structure for table `authors`
--

DROP TABLE IF EXISTS authors;
CREATE TABLE authors (
  authID int(11) NOT NULL auto_increment,
  authName varchar(60) NOT NULL default '',
  PRIMARY KEY  (authID),
  KEY authName (authName)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Dumping data for table `authors`
--


/*!40000 ALTER TABLE authors DISABLE KEYS */;
LOCK TABLES authors WRITE;
INSERT INTO authors VALUES (1,'Kofler Michael'),(2,'Kramer David'),(3,'Orfali Robert'),(4,'Harkey Dan'),(5,'Edwards Jeri'),(6,'Ratschiller Tobias'),(7,'Gerken Till'),(14,'King Tim'),(13,'Reese Georg'),(12,'Yarger Randy Jay'),(15,'Date Chris'),(16,'Darween Hugh'),(17,'Krause Jörg'),(19,'Pohl Peter'),(20,'Kopka Helmut'),(21,'Komma Michael'),(22,'Bitsch Gerhard'),(23,'Holz Helmut'),(24,'Schmitt Bernd'),(25,'Tikart Andreas'),(26,'Garfinkel Simon'),(30,'DuBois Paul'),(37,'Theodor Kallifatides'),(38,'Michael Goosens'),(39,'Rahtz Sebastian');
UNLOCK TABLES;
/*!40000 ALTER TABLE authors ENABLE KEYS */;

--
-- Table structure for table `backup_categories_as_in_book`
--

DROP TABLE IF EXISTS backup_categories_as_in_book;
CREATE TABLE backup_categories_as_in_book (
  catID int(11) NOT NULL default '0',
  catName varchar(60) NOT NULL default '',
  parentCatID int(11) default NULL,
  hierNr int(11) NOT NULL default '0',
  hierIndent tinyint(4) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table `backup_categories_as_in_book`
--


/*!40000 ALTER TABLE backup_categories_as_in_book DISABLE KEYS */;
LOCK TABLES backup_categories_as_in_book WRITE;
INSERT INTO backup_categories_as_in_book VALUES (1,'Computer books',11,2,1),(2,'Databases',1,5,2),(3,'Programming',1,23,2),(4,'Relational Databases',2,11,3),(5,'Object-oriented databases',2,10,3),(6,'PHP',3,27,3),(7,'Perl',3,26,3),(8,'SQL',2,14,3),(9,'Children\'s books',11,1,1),(10,'Literature and fiction',11,45,1),(11,'All books',NULL,0,0),(34,'MySQL',2,9,3),(36,'LaTeX, TeX',1,22,2);
UNLOCK TABLES;
/*!40000 ALTER TABLE backup_categories_as_in_book ENABLE KEYS */;

--
-- Table structure for table `backup_rel_cat_parent_not_in_use`
--

DROP TABLE IF EXISTS backup_rel_cat_parent_not_in_use;
CREATE TABLE backup_rel_cat_parent_not_in_use (
  catID int(11) NOT NULL default '0',
  parentID int(11) NOT NULL default '0',
  PRIMARY KEY  (catID,parentID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Dumping data for table `backup_rel_cat_parent_not_in_use`
--


/*!40000 ALTER TABLE backup_rel_cat_parent_not_in_use DISABLE KEYS */;
LOCK TABLES backup_rel_cat_parent_not_in_use WRITE;
INSERT INTO backup_rel_cat_parent_not_in_use VALUES (1,11),(2,1),(2,11),(3,1),(3,11),(4,1),(4,2),(4,11),(5,1),(5,2),(5,11),(6,1),(6,3),(6,11),(7,1),(7,3),(7,11),(8,1),(8,2),(8,11),(9,11),(10,11);
UNLOCK TABLES;
/*!40000 ALTER TABLE backup_rel_cat_parent_not_in_use ENABLE KEYS */;

--
-- Table structure for table `backup_titles`
--

DROP TABLE IF EXISTS backup_titles;
CREATE TABLE backup_titles (
  titleID int(11) NOT NULL auto_increment,
  title varchar(100) NOT NULL default '',
  subtitle varchar(100) default NULL,
  edition tinyint(4) default NULL,
  publID int(11) default NULL,
  catID int(11) default NULL,
  langID int(11) default NULL,
  year int(11) default NULL,
  isbn varchar(20) default NULL,
  comment varchar(255) default NULL,
  authors varchar(255) default NULL,
  PRIMARY KEY  (titleID),
  KEY idxtitle (title)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Dumping data for table `backup_titles`
--


/*!40000 ALTER TABLE backup_titles DISABLE KEYS */;
LOCK TABLES backup_titles WRITE;
INSERT INTO backup_titles VALUES (1,'Linux, 5th ed.',NULL,NULL,1,1,NULL,2000,NULL,NULL,NULL),(2,'Definitive Guide to Excel VBA',NULL,NULL,2,3,NULL,2000,NULL,NULL,NULL),(3,'Client/Server Survival Guide',NULL,NULL,1,2,NULL,1997,NULL,NULL,NULL),(4,'Web Application Development with PHP 4.0',NULL,NULL,3,6,NULL,2000,NULL,NULL,NULL),(7,'MySQL','',0,8,34,0,2000,'','',NULL),(9,'MySQL & mSQL',NULL,NULL,4,34,NULL,1999,NULL,NULL,NULL),(11,'A Guide to the SQL Standard',NULL,NULL,1,8,NULL,1997,NULL,NULL,NULL),(13,'Visual Basic',NULL,NULL,1,3,2,NULL,NULL,NULL,NULL),(14,'Excel 2000 programmieren',NULL,4,1,3,2,NULL,NULL,NULL,NULL),(20,'Jag saknar dig, jag saknar dig',NULL,NULL,NULL,9,3,NULL,NULL,NULL,NULL),(21,'LaTeX',NULL,NULL,1,1,2,2000,NULL,NULL,NULL),(18,'Nennen wir ihn Anna',NULL,NULL,NULL,9,2,NULL,NULL,NULL,NULL),(19,'Alltid den där Annette',NULL,NULL,NULL,9,3,NULL,NULL,NULL,NULL),(17,'PHP - Grundlagen und Lösungen','Webserver-Programmierung unter Windows und Linux',NULL,5,NULL,2,NULL,NULL,NULL,NULL),(22,'Mathematica','Einführung, Anwendung, Referenz',4,1,1,2,1998,'3827312086','CAS',NULL),(23,'Maple',NULL,4,1,1,2,2001,NULL,'CAS',NULL),(24,'VBA-Programmierung mit Excel 7',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'Linux für Internet und Intranet',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'Practical UNIX & Internet security',NULL,2,4,1,1,1996,'1565921488',NULL,NULL),(30,'Visual Basic Datenbankprogrammierung','Client/Server-Systeme',1,1,2,2,1999,NULL,NULL,NULL),(32,'Ute av verden',NULL,NULL,NULL,10,4,1998,NULL,NULL,NULL),(33,'MySQL','Installation, Programmierung, Referenz',1,1,34,2,2001,'3827317622',NULL,NULL),(34,'MySQL',NULL,1,2,34,1,2001,NULL,'translation',NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE backup_titles ENABLE KEYS */;

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS categories;
CREATE TABLE categories (
  catID int(11) NOT NULL auto_increment,
  catName varchar(60) NOT NULL default '',
  parentCatID int(11) default NULL,
  hierNr int(11) NOT NULL default '0',
  hierIndent tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (catID),
  KEY hierNr (hierNr),
  KEY catName (catName)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Dumping data for table `categories`
--


/*!40000 ALTER TABLE categories DISABLE KEYS */;
LOCK TABLES categories WRITE;
INSERT INTO categories VALUES (1,'Computer books',11,2,1),(2,'Databases',1,5,2),(3,'Programming',1,23,2),(4,'Relational Databases',2,11,3),(5,'Object-oriented databases',2,10,3),(6,'PHP',3,27,3),(7,'Perl',3,26,3),(8,'SQL',2,14,3),(9,'Children\'s books',11,1,1),(10,'Literature and fiction',11,45,1),(11,'All books',NULL,0,0),(34,'MySQL',2,9,3),(36,'LaTeX, TeX',1,22,2);
UNLOCK TABLES;
/*!40000 ALTER TABLE categories ENABLE KEYS */;

--
-- Table structure for table `languages`
--

DROP TABLE IF EXISTS languages;
CREATE TABLE languages (
  langID int(11) NOT NULL auto_increment,
  langName varchar(40) NOT NULL default '',
  PRIMARY KEY  (langID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Dumping data for table `languages`
--


/*!40000 ALTER TABLE languages DISABLE KEYS */;
LOCK TABLES languages WRITE;
INSERT INTO languages VALUES (1,'english'),(2,'deutsch'),(3,'svensk'),(4,'norsk');
UNLOCK TABLES;
/*!40000 ALTER TABLE languages ENABLE KEYS */;

--
-- Table structure for table `publishers`
--

DROP TABLE IF EXISTS publishers;
CREATE TABLE publishers (
  publID int(11) NOT NULL auto_increment,
  publName varchar(60) NOT NULL default '',
  PRIMARY KEY  (publID),
  KEY publName (publName)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Dumping data for table `publishers`
--


/*!40000 ALTER TABLE publishers DISABLE KEYS */;
LOCK TABLES publishers WRITE;
INSERT INTO publishers VALUES (1,'Addison-Wesley'),(2,'apress'),(3,'New Riders'),(4,'O\'Reilly & Associates'),(5,'Hanser'),(9,'Bonnier Pocket');
UNLOCK TABLES;
/*!40000 ALTER TABLE publishers ENABLE KEYS */;

--
-- Table structure for table `rel_title_author`
--

DROP TABLE IF EXISTS rel_title_author;
CREATE TABLE rel_title_author (
  titleID int(11) NOT NULL default '0',
  authID int(11) NOT NULL default '0',
  authNr int(11) default NULL,
  PRIMARY KEY  (titleID,authID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Dumping data for table `rel_title_author`
--


/*!40000 ALTER TABLE rel_title_author DISABLE KEYS */;
LOCK TABLES rel_title_author WRITE;
INSERT INTO rel_title_author VALUES (1,1,NULL),(2,1,1),(2,2,2),(3,3,NULL),(3,4,NULL),(3,5,NULL),(4,6,NULL),(4,7,NULL),(9,12,NULL),(9,13,NULL),(9,14,NULL),(11,15,1),(11,16,2),(13,1,0),(14,1,0),(19,19,0),(18,19,0),(17,17,0),(20,19,0),(21,20,0),(22,1,0),(23,1,0),(23,21,1),(23,22,2),(24,1,0),(25,23,0),(25,24,1),(25,25,2),(7,30,0),(27,26,0),(30,1,0),(33,1,0),(34,1,0),(34,2,1),(41,17,0),(42,37,0),(43,38,0),(43,39,1),(1,9999,NULL),(9999,1,NULL),(9999,9999,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE rel_title_author ENABLE KEYS */;

--
-- Table structure for table `titles`
--

DROP TABLE IF EXISTS titles;
CREATE TABLE titles (
  titleID int(11) NOT NULL auto_increment,
  title varchar(100) NOT NULL default '',
  subtitle varchar(100) default NULL,
  edition tinyint(4) default NULL,
  publID int(11) default NULL,
  catID int(11) default NULL,
  langID int(11) default NULL,
  year int(11) default NULL,
  isbn varchar(20) default NULL,
  comment varchar(255) default NULL,
  timest timestamp(14) NOT NULL,
  PRIMARY KEY  (titleID),
  KEY idxtitle (title)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Dumping data for table `titles`
--


/*!40000 ALTER TABLE titles DISABLE KEYS */;
LOCK TABLES titles WRITE;
INSERT INTO titles VALUES (1,'Linux, 5th ed.',NULL,NULL,1,1,NULL,2000,NULL,NULL,20010121141121),(2,'Definitive Guide to Excel VBA',NULL,NULL,2,3,NULL,2000,NULL,NULL,20010121141121),(3,'Client/Server Survival Guide',NULL,NULL,1,2,NULL,1997,NULL,NULL,20010121141121),(4,'Web Application Development with PHP 4.0',NULL,NULL,3,6,NULL,2000,NULL,NULL,20010121141121),(7,'MySQL','',0,3,34,0,2000,'','',20010417103735),(9,'MySQL & mSQL',NULL,NULL,4,34,NULL,1999,NULL,NULL,20010121141121),(11,'A Guide to the SQL Standard',NULL,NULL,1,8,NULL,1997,NULL,NULL,20010121141121),(13,'Visual Basic',NULL,NULL,1,3,2,NULL,NULL,NULL,20010121141121),(14,'Excel 2000 programmieren',NULL,4,1,3,2,NULL,NULL,NULL,20010121141121),(20,'Jag saknar dig, jag saknar dig',NULL,NULL,NULL,9,3,NULL,NULL,NULL,20010121141121),(21,'LaTeX',NULL,NULL,1,1,2,2000,NULL,NULL,20010121141121),(18,'Nennen wir ihn Anna',NULL,NULL,NULL,9,2,NULL,NULL,NULL,20010121141121),(19,'Alltid den där Annette',NULL,NULL,NULL,9,3,NULL,NULL,NULL,20010121141121),(17,'PHP - Grundlagen und Lösungen','Webserver-Programmierung unter Windows und Linux',NULL,5,NULL,2,NULL,NULL,NULL,20010121141121),(22,'Mathematica','Einführung, Anwendung, Referenz',4,1,1,2,1998,'3827312086','CAS',20010121141121),(23,'Maple',NULL,4,1,1,2,2001,NULL,'CAS',20010121141121),(24,'VBA-Programmierung mit Excel 7',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,20010121141121),(25,'Linux für Internet und Intranet',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,20010121141121),(27,'Practical UNIX & Internet security',NULL,2,4,1,1,1996,'1565921488',NULL,20010121141121),(30,'Visual Basic Datenbankprogrammierung','Client/Server-Systeme',1,1,2,2,1999,NULL,NULL,20010121141121),(32,'Ute av verden',NULL,NULL,NULL,10,4,1998,NULL,NULL,20010119085139),(33,'MySQL','Installation, Programmierung, Referenz',1,1,34,2,2001,'3827317622',NULL,20010121141121),(34,'MySQL',NULL,1,2,34,1,2001,NULL,'translation',20010121141121),(41,'PHP 4',NULL,NULL,NULL,6,2,NULL,'3-446-21546-8',NULL,20010403135602),(42,'Kärleken',NULL,NULL,9,10,3,1978,NULL,NULL,20010407134740),(43,'Mit LaTeX ins Web','Elektronisches Publizieren mit TeX, HTML und XML',NULL,1,36,2,2000,NULL,NULL,20010407141450),(44,'MySQL',NULL,NULL,NULL,NULL,NULL,2001,NULL,NULL,20050223102809),(45,'deleteme',NULL,NULL,99,NULL,NULL,NULL,NULL,NULL,20050223144713);
UNLOCK TABLES;
/*!40000 ALTER TABLE titles ENABLE KEYS */;