#
# ݱĽṹ `book_lend`
#

CREATE TABLE book_lend (
  id int(10) NOT NULL auto_increment,
  book_name varchar(100) NOT NULL default '',
  card varchar(20) NOT NULL default '0',
  send_date date NOT NULL default '0000-00-00',
  daoshi_date date NOT NULL default '0000-00-00',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# ݿ `book_lend`
#


    # ݱĽṹ `book_list`
#

CREATE TABLE book_list (
  book_id int(10) NOT NULL auto_increment,
  book_name varchar(100) NOT NULL default '',
  author varchar(50) NOT NULL default '',
  pub_addr varchar(100) NOT NULL default '',
  pub_date date NOT NULL default '0000-00-00',
  price int(11) NOT NULL default '0',
  volumes int(11) NOT NULL default '0',
  sort_id varchar(10) NOT NULL default '0',
  status varchar(10) NOT NULL default '0',
  PRIMARY KEY  (book_id)
) TYPE=MyISAM;

#
# ݿ `book_list`
#

INSERT INTO book_list VALUES (1, 'ԭṹЭ', '', 'йѧԺƺѵ', '1984-04-00', 20, 3, 'TP11', 'ڼ');
INSERT INTO book_list VALUES (2, 'ݱͼо:?', 'һ', 'ѧ', '1991-11-00', 6, 3, 'TP309', 'ڼ');
INSERT INTO book_list VALUES (3, '缰ӿڷ', '', 'ѧ׳', '1990-10-00', 10, 1, 'TP393', 'ڼ');
INSERT INTO book_list VALUES (4, '߶ƪС˵ѡ', 'ףͽ', 'ຣ', '0000-00-00', 25, 3, 'I512.44', 'ڼ');
INSERT INTO book_list VALUES (5, '̼С˵뾭̹', '', 'йó', '0000-00-00', 8, 3, 'F715-51', 'ڼ');
INSERT INTO book_list VALUES (6, 'С˵дɶʮ', 'Ф', 'ʮճ', '0000-00-00', 2, 5, 'I054', 'ڼ');
INSERT INTO book_list VALUES (7, 'ƪС˵̸', 'Ϻʦѧϵ', 'Ϻ', '0000-00-00', 0, 1, 'I054', 'ڼ');
INSERT INTO book_list VALUES (8, 'С˵Ŀ', '', 'л', '0000-00-00', 0, 1, 'I242-63', 'ڼ');
INSERT INTO book_list VALUES (9, '߷ӵҹ:⾪С˵(1)', '', 'й', '0000-00-00', 96, 1, 'I14', 'ڼ');

    # ݱĽṹ `book_user`
#

CREATE TABLE book_user (
  user_id int(11) NOT NULL auto_increment,
  user_name varchar(100) NOT NULL default '',
  card varchar(20) NOT NULL default '',
  user_pass varchar(50) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  question varchar(100) NOT NULL default '',
  answer varchar(100) NOT NULL default '',
  PRIMARY KEY  (user_id)
) TYPE=MyISAM;

#
# ݿ `book_user`
#

INSERT INTO book_user VALUES (10, 'test', '01234567', 'test', 'test@163.com', 'test', 'test');
INSERT INTO book_user VALUES (12, 'guest', '42100013', '01234567', 'guest@163.com', 'guest', 'guest');


    