创建数据库
SQL 语句如下：
CREATE TABLE `categories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(250) NOT NULL default '',
`parent_id` int(11) NOT NULL default '0',
`created` DATETIME DEFAULT NULL,
`updated` DATETIME DEFAULT NULL,
PRIMARY KEY (`id`)
);
INSERT INTO `categories` (`id`, `name`, `parent_id`, `created`) VALUES (1, 'Business', 0, NOW());
INSERT INTO `categories` (`id`, `name`, `parent_id`, `created`) VALUES (2, 'Modern Cookbook', 0, NOW());
INSERT INTO `categories` (`id`, `name`, `parent_id`, `created`) VALUES (3, 'Popular Computing', 0, NOW());
INSERT INTO `categories` (`id`, `name`, `parent_id`, `created`) VALUES (4, 'Psychology', 0, NOW());
INSERT INTO `categories` (`id`, `name`, `parent_id`, `created`) VALUES (5, 'Undecided', 0, NOW());
CREATE TABLE `publishers` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(250) NOT NULL default '',
`created` DATETIME DEFAULT NULL,
`updated` DATETIME DEFAULT NULL,
PRIMARY KEY (`id`)
);
INSERT INTO `publishers` (`id`, `name`, `created`) VALUES (1, 'New Moon Books', NOW());
INSERT INTO `publishers` (`id`, `name`, `created`) VALUES (2, 'Binnet & Hardley', NOW());
INSERT INTO `publishers` (`id`, `name`, `created`) VALUES (3, 'Algodata Infosystems', NOW());
INSERT INTO `publishers` (`id`, `name`, `created`) VALUES (4, 'Five Lakes Publishing', NOW());
INSERT INTO `publishers` (`id`, `name`, `created`) VALUES (5, 'Ramona Publishers', NOW());
INSERT INTO `publishers` (`id`, `name`, `created`) VALUES (6, 'GGG&G', NOW());
INSERT INTO `publishers` (`id`, `name`, `created`) VALUES (7, 'Scootney Books', NOW());
INSERT INTO `publishers` (`id`, `name`, `created`) VALUES (8, 'Lucerne Publishing', NOW());
CREATE TABLE `titles` (
`id` varchar(250) NOT NULL default '',
`title` varchar(250) NOT NULL default '',
`category_id` int(11) NOT NULL default '0',
`price` decimal(19,8) NOT NULL default '0.00000000',
`publisher_id` int(11) NOT NULL default '0',
`created` DATETIME DEFAULT NULL,
`updated` DATETIME DEFAULT NULL,
PRIMARY KEY (`id`)
);
INSERT INTO `titles` (`id`, `title`, `category_id`, `price`, `publisher_id`, `created`) VALUES ('BU1032', 'The Busy Executives Database Guide', 1, 19.99000000, 3, NOW());
INSERT INTO `titles` (`id`, `title`, `category_id`, `price`, `publisher_id`, `created`) VALUES ('BU1111', 'Cooking with Computers', 1, 11.95000000, 3, NOW());
INSERT INTO `titles` (`id`, `title`, `category_id`, `price`, `publisher_id`, `created`) VALUES ('BU2075', 'You Can Combat Computer Stress', 1, 2.99000000, 1, NOW());
INSERT INTO `titles` (`id`, `title`, `category_id`, `price`, `publisher_id`, `created`) VALUES ('BU7832', 'Straight Talk About Computers', 2, 19.99000000, 3, NOW());
INSERT INTO `titles` (`id`, `title`, `category_id`, `price`, `publisher_id`, `created`) VALUES ('MC2222', 'Silicon Valley Gastronmic Treats', 2, 19.99000000, 2, NOW());
INSERT INTO `titles` (`id`, `title`, `category_id`, `price`, `publisher_id`, `created`) VALUES ('MC3021', 'The Gourmet Microwave', 2, 2.99000000, 2, NOW());