【SQL开源代码栏目提醒】:本文主要为网学会员提供lib.sql,希望对需要lib.sql网友有所帮助,学习一下!
# MySQL-Front Dump 2.5
#
# Host: localhost Database: lib
# --------------------------------------------------------
# Server version 4.0.13-nt
#
# Table structure for table 'kjb2_kjxx_book'
#
CREATE TABLE kjb2_kjxx_book (
BOOKCLASSID int(11) NOT NULL default '0',
TITLE varchar(50) NOT NULL default '',
AUTHOR varchar(50) NOT NULL default '',
ISBN varchar(50) default NULL,
CBFXX varchar(50) default NULL,
ZTXX varchar(50) default NULL,
DTZRZ varchar(50) default NULL,
ZRZ varchar(50) default NULL,
ZGTSFLFLH varchar(50) default NULL,
KTTSFLFLH varchar(50) default NULL,
LTZT varchar(50) default NULL,
FZX varchar(50) default NULL,
CBSJ varchar(50) default NULL,
DJ varchar(50) default NULL,
PCJE varchar(50) default NULL
) TYPE=MyISAM;
#
# Dumping data for table 'kjb2_kjxx_book'
#
INSERT INTO kjb2_kjxx_book VALUES("1", "34234", "34", "34", "35324", "5345", "456456", "456456", "7456", "745", "674", "745", "6476", "45647", "");
INSERT INTO kjb2_kjxx_book VALUES("23", "三国演义", "罗贯中", "7-02-001499-2", "北京-人民文学出版社 1990.8", "608页 20cm ¥13.70", "罗贯中", "罗贯中", "I242.43", "44.565", "历史小说,章回小说,长篇小说", "无", "1990.8", "13.70", "13.70");
INSERT INTO kjb2_kjxx_book VALUES("2", "C++入门", "JXKJ", "", "", "", "JXKJ", "JXKJ", "", "", "", "", "", "", "");
#
# Table structure for table 'kjb2_kjxx_bookshelf'
#
CREATE TABLE kjb2_kjxx_bookshelf (
SHELFID int(11) NOT NULL default '0',
STOREID int(11) NOT NULL default '0',
MC varchar(50) NOT NULL default '',
WZ varchar(200) default NULL,
FZR varchar(50) default NULL,
SM varchar(50) default NULL
) TYPE=MyISAM;
#
# Dumping data for table 'kjb2_kjxx_bookshelf'
#
#
# Table structure for table 'kjb2_kjxx_cfb'
#
CREATE TABLE kjb2_kjxx_cfb (
CFID int(11) NOT NULL default '0',
READERID int(11) NOT NULL default '0',
BOOKID int(11) NOT NULL default '0',
CFYY varchar(200) default NULL,
CFJG varchar(200) default NULL,
FKJE double(20,2) default NULL,
ZT char(1) default NULL
) TYPE=MyISAM;
#
# Dumping data for table 'kjb2_kjxx_cfb'
#
#
# Table structure for table 'kjb2_kjxx_jyb'
#
CREATE TABLE kjb2_kjxx_jyb (
JYID int(11) NOT NULL default '0',
READERID int(11) NOT NULL default '0',
BOOKID int(11) NOT NULL default '0',
JYSJ varchar(20) NOT NULL default '',
DQSJ varchar(20) NOT NULL default '',
ZT varchar(50) NOT NULL default '0',
XJCS int(11) NOT NULL default '0',
GHRQ varchar(20) default NULL
) TYPE=MyISAM;
#
# Dumping data for table 'kjb2_kjxx_jyb'
#
#
# Table structure for table 'kjb2_kjxx_reader'
#
CREATE TABLE kjb2_kjxx_reader (
READERID int(11) NOT NULL default '0',
ZJH varchar(50) NOT NULL default '',
GH varchar(50) NOT NULL default '',
BZRQ varchar(20) NOT NULL default '',
SXRQ varchar(20) NOT NULL default '',
GQRQ varchar(20) NOT NULL default '',
YJ int(11) default '0',
SXF int(11) default '0',
LJJS int(11) default '0',
RULEID int(11) default NULL,
ZT varchar(50) NOT NULL default ''
) TYPE=MyISAM;
#
# Dumping data for table 'kjb2_kjxx_reader'
#
INSERT INTO kjb2_kjxx_reader VALUES("1", "1", "xin", "2004-12-14", "2004-12-14", "2006-12-27", "11", "1", "1", "1", "鑼");
#
# Table structure for table 'kjb2_kjxx_rule'
#
CREATE TABLE kjb2_kjxx_rule (
RULEID int(11) NOT NULL default '0',
GZMC varchar(50) NOT NULL default '',
KJYSJ int(20) NOT NULL default '0',
KJYGCDID varchar(50) NOT NULL default '0',
KXJSJ int(11) NOT NULL default '0',
KXJCS int(11) NOT NULL default '0',
KYYSJ int(11) NOT NULL default '0'
) TYPE=MyISAM;
#
# Dumping data for table 'kjb2_kjxx_rule'
#
INSERT INTO kjb2_kjxx_rule VALUES("1", "rule1", "10", "2", "10", "10", "1");
INSERT INTO kjb2_kjxx_rule VALUES("2", "b", "1", "2,3", "1", "1", "1");
#
# Table structure for table 'kjb2_kjxx_store'
#
CREATE TABLE kjb2_kjxx_store (
BOOKID int(11) NOT NULL default '0',
BOOKCLASSID int(11) NOT NULL default '0',
STOREID int(11) NOT NULL default '0',
SHELFID int(11) default NULL,
SQH varchar(50) default NULL,
TMH varchar(50) default NULL,
NJH varchar(50) default NULL,
ZT varchar(50) default NULL,
RGSJ varchar(50) default NULL
) TYPE=MyISAM;
#
# Dumping data for table 'kjb2_kjxx_store'
#
INSERT INTO kjb2_kjxx_store VALUES("1", "2", "2", NULL, "0001", "0001", "2004", "?", "Mon Dec 13 23:55:14 CST 2004");
INSERT INTO kjb2_kjxx_store VALUES("2", "23", "2", NULL, "001", "001", "1", "可借", "Mon Dec 20 01:25:37 CST 2004");
#
# Table structure for table 'kjb2_kjxx_storeplace'
#
CREATE TABLE kjb2_kjxx_storeplace (
STOREID int(11) NOT NULL default '0',
MC