table.sql

来自「运用JSP+tomcat及各种数据库编辑的一些较常用的应用程序」· SQL 代码 · 共 109 行

# 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 int(10) unsigned 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 int(10) unsigned 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 tinyint(3) unsigned 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 int(10) unsigned default NULL,
  
	slqk_name varchar2(100) default NULL,
  
	yxl varchar2(10) default NULL,
  
	yxyz varchar2(5) default NULL,
  
	yycs int(5) unsigned default NULL,
  
	djzz int(5) unsigned default NULL,
  
	bz varchar2(200) default NULL
);



#
# Dumping data for table 'kjc2_paper'
#

INSERT INTO kjc2_paper VALUES("8", "论文编号", "学院", "作者", "刊物名称", "论文名称", "15", "在馆", "全国性", "影响