本级程序所用的数据表结构：

# --------------------------------------------------------

#

# 数据表的结构 '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)

);