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 */;


DROP TABLE IF EXISTS titles;
CREATE TABLE titles (
  titleID int(11) NOT NULL auto_increment,
  title varchar(100) NOT NULL default '',
  publID int(11) default 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.',1),
(2,'Definitive Guide to Excel VBA',2),
(3,'Client/Server Survival Guide',1),
(4,'Web Application Development with PHP 4.0',3),
(7,'MySQL',3),
(9,'MySQL & mSQL',4),
(11,'A Guide to the SQL Standard',1),
(13,'Visual Basic',1),
(14,'Excel 2000 programmieren',1),
(20,'Jag saknar dig, jag saknar dig',NULL),
(21,'LaTeX',1),
(18,'Nennen wir ihn Anna',NULL),
(19,'Alltid den där Annette',NULL),
(17,'PHP - Grundlagen und Lösungen',5),
(22,'Mathematica',1),
(23,'Maple',1),
(24,'VBA-Programmierung mit Excel 7',NULL),
(25,'Linux für Internet und Intranet',NULL),
(27,'Practical UNIX & Internet security',4),
(30,'Visual Basic Datenbankprogrammierung',1),
(32,'Ute av verden',NULL),
(33,'MySQL',1),
(34,'MySQL',1),
(41,'PHP 4',NULL),
(42,'Kärleken',9),
(43,'Mit LaTeX ins Web',1),
(44,'MySQL',NULL),
(45,'deleteme',99);


UNLOCK TABLES;
/*!40000 ALTER TABLE titles ENABLE KEYS */;