提交新文档 | 查看文档 | 管理
# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# 主机: localhost 数据库 : digital

# --------------------------------------------------------
#
# 数据表的结构 'book'
#

CREATE TABLE book (
  book_id tinyint(5) NOT NULL auto_increment,
  book_title varchar(50) NOT NULL,
  book_author varchar(50) NOT NULL,
  book_publishing varchar(100) NOT NULL,
  book_publishing_time date DEFAULT '0000-00-00' NOT NULL,
  book_in_number tinyint(4) DEFAULT '0' NOT NULL,
  book_stocks tinyint(4) DEFAULT '0' NOT NULL,
  book_memo text,
  book_number varchar(100) NOT NULL,
  PRIMARY KEY (book_id),
  KEY book_id (book_id, book_title, book_author, book_publishing, book_publishing_time)
);


# --------------------------------------------------------
#
# 数据表的结构 'lend'
#

CREATE TABLE lend (
  id int(6) NOT NULL auto_increment,
  book_id int(5) DEFAULT '0' NOT NULL,
  book_title char(100) NOT NULL,
  lent_time date DEFAULT '0000-00-00' NOT NULL,
  continue_time year(4) DEFAULT '0000' NOT NULL,
  user_id int(5) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY id (id, user_id, book_id, book_title, lent_time)
);


# --------------------------------------------------------
#
# 数据表的结构 'manage'
#

CREATE TABLE manage (
  id tinyint(4) NOT NULL auto_increment,
  name char(20) NOT NULL,
  password char(20) NOT NULL,
  PRIMARY KEY (id),
  KEY id (id, name)
);


# --------------------------------------------------------
#
# 数据表的结构 'user'
#

CREATE TABLE user (
  id int(5) NOT NULL auto_increment,
  ID_number char(50) NOT NULL,
  name char(50) NOT NULL,
  dress char(100),
  phone char(20) NOT NULL,
  lend_number tinyint(4) DEFAULT '0' NOT NULL,
  password char(15) NOT NULL,
  AUTO_number char(50) NOT NULL,
  email char(50) NOT NULL,
  PRIMARY KEY (id),
  KEY id (id, ID_number, name)
);