📄 table.sql
字号:
# 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", "在馆", "全国性", "影响?, "11111", "1", "备注");
INSERT INTO kjc2_paper VALUES("1", "00001", "信息学院", "张三", "计算机专刊", "基于JSP的论文管理技术", "15", "在馆", "全国性", "5", "100", "1", "非常不错！");
INSERT INTO kjc2_paper VALUES("10", "admin", "admin", "admin", "admin", "admin", "15", "在馆", "世界性", "1", "1", "1", "1");
#
# Table structure for table 'kjc2_report'
#
CREATE TABLE kjc2_report (
id tinyint(3) unsigned NOT NULL,
bh varchar2(20) default NULL,
xy varchar2(50) default NULL,
bgr varchar2(100) default NULL,
zw varchar2(20) default NULL,
bgrdw varchar2(20) default NULL,
bgmc varchar2(20) default NULL,
tzdx varchar2(20) default NULL,
rs varchar2(10) default NULL,
bz varchar2(200) default NULL
);
#
# Dumping data for table 'kjc2_report'
#
INSERT INTO kjc2_report VALUES("1", "2005-04", "信息学院", "张三", "院长", "信息学院", "JSP最新技术报告会", "大三学生", "500", "反响好！");
INSERT INTO kjc2_report VALUES("7", "报告会编号", "学院", "报告人", "职务", "报告人单位", "报告名称", "听众对象", "22222222", "备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注备注");
#
# Table structure for table 'kjc_college'
#
CREATE TABLE kjc_college (
id int(11) NOT NULL,
name varchar2(50) NOT NULL default '',
tel varchar2(30) default NULL, man int(11) default NULL,
mark varchar2(4) default NULL
);
#
# Dumping data for table 'kjc_college'
#
INSERT INTO kjc_college VALUES("22", "管理学院", "01062332763", "2", "02");
INSERT INTO kjc_college VALUES("21", "外语学院", "62332260", "3", "01");
INSERT INTO kjc_college VALUES("31", "信息学院", "010-99999999", "1", "03");
INSERT INTO kjc_college VALUES("32", "文法学院", "010-99999999", "1", "04");
#
# Table structure for table 'kjc_department'
#
CREATE TABLE kjc_department (
id int(11) NOT NULL,
name varchar2(50) NOT NULL default '',
tel varchar2(15) default NULL,
man int(11) default NULL,
college int(11) NOT NULL default '0'
);
#
# Dumping data for table 'kjc_department'
#
INSERT INTO kjc_department VALUES("5", "工商管理系", "01062332272", "3", "22");
INSERT INTO kjc_department VALUES("6", "经济贸易系", "01062332447", "3", "22");
INSERT INTO kjc_department VALUES("7", "财务与会计系", "01062333581", "3", "22");
INSERT INTO kjc_department VALUES("8", "管理科学与工程系", "01062332269", "2", "22");
INSERT INTO kjc_department VALUES("41", "国际经济与贸易系 MBA中心", "", "55", "22");
INSERT INTO kjc_department VALUES("89", "大学英语", "", "55", "21");
INSERT INTO kjc_department VALUES("90", "英语语言文学", "", "55", "21");
INSERT INTO kjc_department VALUES("92", "日、俄、德、法", "", "55", "21");
INSERT INTO kjc_department VALUES("99", "法律系", "010-99999999", "1", "32");
INSERT INTO kjc_department VALUES("98", "研究生英语", "", "55", "21");
#
# Table structure for table 'kjc_people'
#
CREATE TABLE kjc_people (
id int(11) NOT NULL,
workid varchar2(20) NOT NULL default '',
name varchar2(20) default NULL,
password varchar2(20) NOT NULL default '',
sex tinyint(1) default NULL,
nation varchar2(50) default NULL,
politics int(11) default NULL,
fromschool varchar2(100) default NULL,
schooltime date default NULL,
addr varchar2(100) default NULL,
birth date default NULL,
speciality varchar2(200) default NULL,
education varchar2(200) default NULL,
certid varchar2(18) default NULL,
post varchar2(50) default NULL,
officetel varchar2(15) default NULL,
mobile varchar2(15) default NULL,
hometel varchar2(15) default NULL,
email varchar2(100) default NULL,
descs varchar2,
prize varchar2,
collegeid int(11) default NULL,
departmentid int(11) default NULL,
role int(11) NOT NULL default '0',
fanid varchar2(200) default NULL
);
#
# Dumping data for table 'kjc_people'
#
INSERT INTO kjc_people VALUES("1", "admin", "admin", "admin", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "21", "5", "1", NULL);
INSERT INTO kjc_people VALUES("1243", "test", "test", "test", "1", "M", "1", "", "0000-00-00", "", "0000-00-00", "", "", "", "", "", "", "", "", "", "", "22", "5", "1", "");
INSERT INTO kjc_people VALUES("1244", "zhang", "张三", "zhang", "1", "", "0", "", "0000-00-00", "", "0000-00-00", "", "", "", "", "", "", "", "", "", "", "32", "99", "1", "");
#
# Table structure for table 'kjc_right'
#
CREATE TABLE kjc_right (
id int(11) NOT NULL,
name varchar2(50) NOT NULL default ''
);
#
# Dumping data for table 'kjc_right'
#
INSERT INTO kjc_right VALUES("1", "学院配置");
INSERT INTO kjc_right VALUES("2", "系所配置");
INSERT INTO kjc_right VALUES("4", "人员配置");
INSERT INTO kjc_right VALUES("5", "角色权限配置");
INSERT INTO kjc_right VALUES("31", "发布论文");
INSERT INTO kjc_right VALUES("32", "发布科技专著");
INSERT INTO kjc_right VALUES("33", "发布学术报告会");
INSERT INTO kjc_right VALUES("37", "管理论文");
INSERT INTO kjc_right VALUES("38", "管理科技专著");
INSERT INTO kjc_right VALUES("39", "管理学术报告会");
#
# Table structure for table 'kjc_role'
#
CREATE TABLE kjc_role (
id int(11) NOT NULL,
name varchar2(50) NOT NULL default '',
rights varchar2(200) NOT NULL default ''
);
#
# Dumping data for table 'kjc_role'
#
INSERT INTO kjc_role VALUES("1", "系统维护管理员", "1,2,4,5,31,32,33,37,38,39");
INSERT INTO kjc_role VALUES("5", "论文管理角色", "37,38,39");
INSERT INTO kjc_role VALUES("4", "普通教师", "31,32,33,37,38,39");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -