# MySQL-Front Dump 2.5
#
# Host: localhost   Database: kjc
# --------------------------------------------------------
# Server version 4.0.5-beta-max-nt


#
# Table structure for table 'kjc2_bookstatistic'
#

CREATE TABLE kjc2_bookstatistic (  
	id number(10) NOT NULL,  
	bh varchar2(20) default NULL,  
	xy varchar2(50) default NULL, 
	zz varchar2(100) default NULL,  
	cbs varchar2(50) default NULL,  
	zs varchar2(5) default NULL,  
	bz varchar2(200) default NULL
);



#
# Dumping data for table 'kjc2_bookstatistic'
#

INSERT INTO kjc2_bookstatistic VALUES('1', 'JSP技術', 'new', 'Tom', 'CCW', '20000', 'OK');
INSERT INTO kjc2_bookstatistic VALUES('2', '00001', '信息學院', '張三', '計算機', '50000', '');
INSERT INTO kjc2_bookstatistic VALUES('4', '專著編號', '學院', '作者', '出版社', '22222', '備注');


#
# Table structure for table 'kjc2_code'
#

CREATE TABLE kjc2_code (  
	id number(10) NOT NULL,  
	codeid varchar2(20) default NULL,  
	code_type varchar2(20) default NULL,  
	code_name varchar2(20) default NULL,  
	code_value varchar2(100) default NULL
);



#
# Dumping data for table 'kjc2_code'
#

INSERT INTO kjc2_code VALUES('15', 'LW_SLQK', '論文', '收錄情況', '在館');
INSERT INTO kjc2_code VALUES('16', 'LW_SLQK', '論文', '收錄情況', '軍博');
INSERT INTO kjc2_code VALUES('17', 'LW_SLQK', '論文', '收錄情況', '不在館');


#
# Table structure for table 'kjc2_paper'
#

CREATE TABLE kjc2_paper (  
	id number(3) NOT NULL,  
	bh varchar2(20) default NULL,  
	xy varchar2(50) default NULL,  
	zz varchar2(100) default NULL,  
	kwmc varchar2(50) default NULL,  
	lwmc varchar2(100) default NULL,  
	slqk number(10) default NULL,  
	slqk_name varchar2(100) default NULL,  
	yxl varchar2(10) default NULL,  
	yxyz varchar2(5) default NULL,  
	yycs number(5) default NULL,  
	djzz number(5) default NULL,  
	bz varchar2(200) default NULL
);



#
# Dumping data for table 'kjc2_paper'
#

INSERT INTO kjc2_paper VALUES('8', '論文編號', '學院', '作者', '刊物名稱', '論文名稱', '15', '在館', '全國性', '影響