您的位置：首页 → 网页设计 → PHP实例 → 图书管理程序（一）

图书管理程序（一）

时间：2004/11/7 3:26:00来源：本站整理作者：蓝点我要评论(0)

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

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

#

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

);

相关阅读 Windows错误代码大全 Windows错误代码查询激活windows有什么用Mac QQ和Windows QQ聊天记录怎么合并 Mac QQ和Windows QQ聊天记录Windows 10自动更新怎么关闭 如何关闭Windows 10自动更新windows 10 rs4快速预览版17017下载错误问题Win10秋季创意者更新16291更新了什么 win10 16291更新内容windows10秋季创意者更新时间 windows10秋季创意者更新内容kb3150513补丁更新了什么 Windows 10补丁kb3150513是什么

文章评论

查看所有0条评论>>

发表评论

我来说两句...

提交评论