# --------------------------------------------------------
#
# 数据表的结构 'author'
#
CREATE TABLE author (
;;;author_id int(6) DEFAULT '0' NOT NULL auto_increment,
;;;first_name varchar(20) binary NOT NULL,
;;;last_name varchar(20) NOT NULL,
;;;address varchar(100) binary NOT NULL,
;;;zipcode varchar(10) NOT NULL,
;;;telephone varchar(10) NOT NULL,
;;;email varchar(50) NOT NULL,
;;;comment varchar(255) NOT NULL,
;;;PRIMARY KEY (author_id),
;;;KEY first_name (first_name),
;;;KEY last_name (last_name),
;;;KEY address (address),
;;;KEY zipcode (zipcode),
;;;KEY email (email)
);
# --------------------------------------------------------
#
# 数据表的结构 'books'
#
CREATE TABLE books (
;;;books_id int(6) DEFAULT '0' NOT NULL auto_increment,
;;;books_name varchar(100) binary NOT NULL,
;;;publisher_id varchar(6) NOT NULL,
;;;date_pub datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
;;;type varchar(6) NOT NULL,
;;;pages varchar(4) NOT NULL,
;;;price float(6,2) DEFAULT '0.00' NOT NULL,
;;;comment varchar(255) binary NOT NULL,
;;;ISBN varchar(25) NOT NULL,
;;;PRIMARY KEY (books_id),
;;;KEY name (books_name),
;;;KEY publisher (publisher_id),
;;;KEY date_pub (date_pub),
;;;KEY price (price),
;;;KEY pages (pages),
;;;KEY type (type),
;;;KEY ISBN (ISBN)
);
# --------------------------------------------------------
#
# 数据表的结构 'books_author'
#
CREATE TABLE books_author (
;;;id int(6) DEFAULT '0' NOT NULL auto_increment,
;;;books_id varchar(6) NOT NULL,
;;;author_id varchar(6) NOT NULL,
;;;author_type varchar(6) NOT NULL,
;;;PRIMARY KEY (id)
);
# --------------------------------------------------------
#
# 数据表的结构 'publisher'
#
CREATE TABLE publisher (
;;;publisher_id int(6) DEFAULT '0' NOT NULL auto_increment,
;;;publisher_name varchar(100) binary NOT NULL,
;;;address varchar(100) NOT NULL,
;;;zipcode varchar(10) NOT NULL,
;;;telephone varchar(10) NOT NULL,
;;;telefax varchar(10) NOT NULL,
;;;email varchar(50) NOT NULL,
;;;PRIMARY KEY (publisher_id),
;;;KEY name (publisher_name),
;;;KEY address (address),
;;;KEY email (email)
);
标签：
