图书管理程序(一)

本级程序所用的数据表结构: #
——————————————————– # #
数据表的结构 ‘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) );