图书管理程序(一)
更新时间:2006年10月09日 00:00:00 作者:
本级程序所用的数据表结构:
# --------------------------------------------------------
#
# 数据表的结构 '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)
);
相关文章
PHP5中MVC结构学习...2006-10-10
信用卡效验程序...2006-10-10
多文件上传的例子...2006-10-10
关于文本留言本的分页代码...2006-10-10
模仿OSO的论坛(四)...2006-10-10
BBS(php & mysql)完整版(一)...2006-10-10
PHP脚本数据库功能详解(中)...2006-10-10
朋友问:今天我碰到个问题,我建个表,索引是REF,怎么才能写进一条信息,自动生成一个REF号码,记录到表中去呢?希望生成的REF号码是连续的,从00000开始。2008-06-06
从今天开始,我们进入了系统制作中最基础但也是最关键的php增删查找功能介绍阶段了。2008-06-06
PHP.MVC的模板标签系统(二)...2006-09-09
最新评论