Слияние кода завершено, страница обновится автоматически
-- phpMyAdmin SQL Dump
-- version 4.1.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: 2017-06-16 10:48:18
-- 服务器版本： 5.5.20
-- PHP Version: 5.4.28
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `test`
--
-- --------------------------------------------------------
--
-- 表的结构 `ts_acticle`
--
CREATE TABLE IF NOT EXISTS `ts_acticle` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tittle` varchar(40) NOT NULL DEFAULT '',
`content` varchar(50) NOT NULL DEFAULT '',
`add_time` varchar(20) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- 转存表中的数据 `ts_acticle`
--
INSERT INTO `ts_acticle` (`id`, `tittle`, `content`, `add_time`) VALUES
(1, '考前提示', 'Upload/bulletin/20170519/2yeub407c.html', '1495195062'),
(2, '荣狗是傻逼', 'Upload/bulletin/20170611/f75p2kyoz.html', '1497150751');
-- --------------------------------------------------------
--
-- 表的结构 `ts_auth`
--
CREATE TABLE IF NOT EXISTS `ts_auth` (
`auth_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`auth_name` varchar(20) NOT NULL COMMENT '权限名称',
`auth_pid` smallint(6) unsigned NOT NULL COMMENT '父id',
`auth_c` varchar(32) NOT NULL DEFAULT '' COMMENT '控制器',
`auth_a` varchar(32) NOT NULL DEFAULT '' COMMENT '操作方法',
`auth_path` varchar(32) DEFAULT NULL COMMENT '全路径',
`auth_level` tinyint(4) NOT NULL DEFAULT '0' COMMENT '权限级别，从0开始计数',
`is_index` int(4) DEFAULT NULL,
PRIMARY KEY (`auth_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=132 ;
--
-- 转存表中的数据 `ts_auth`
--
INSERT INTO `ts_auth` (`auth_id`, `auth_name`, `auth_pid`, `auth_c`, `auth_a`, `auth_path`, `auth_level`, `is_index`) VALUES
(101, '试题管理', 0, '', '', '101', 0, 0),
(102, '考试管理', 0, '', '', '102', 0, 0),
(103, '公告管理', 0, '', '', '103', 0, 0),
(104, '权限管理', 0, '', '', '104', 0, 0),
(105, '试题录入', 101, 'Test', 'entering', '101-105', 1, 1),
(106, '试题查看', 101, 'Test', 'see', '101-106', 1, 1),
(107, '题目修改', 101, 'Test', 'type', '101-107', 1, 0),
(108, '试题列表', 101, 'Test', 'exam', '101-108', 1, 0),
(109, '试题修改', 101, 'Test', 'upd', '101-109', 1, 0),
(110, '考生管理', 102, 'Score', 'student', '102-110', 1, 1),
(111, '考生添加', 102, 'Score', 'addstudent', '102-111', 1, 0),
(112, '成绩分析', 102, 'Score', 'mark', '102-112', 1, 1),
(113, '公告列表', 103, 'Acticle', 'acticle', '103-113', 1, 1),
(114, '添加公告', 103, 'Acticle', 'add', '103-114', 1, 1),
(115, '管理员信息', 104, 'Manager', 'manager', '104-115', 1, 1),
(116, '角色列表', 104, 'Role', 'role', '104-116', 1, 1),
(117, '权限列表', 104, 'Auth', 'auth', '104-117', 1, 1),
(123, 'Test', 0, '', '', '123', 0, 0),
(124, 'test', 123, 'Test', 'test', '123-124', 1, 1),
(126, '教师阅卷', 102, 'Score', 'marking', '102-126', 1, 0),
(128, '修改公告', 103, 'Acticle', 'upd', '103-128', 1, 0),
(129, '删除公告', 103, 'Acticle', 'del', '103-129', 1, 0),
(130, '考生删除', 102, 'Score', 'del', '102-130', 1, 0),
(131, '删除试题', 101, 'Test', 'del', '101-131', 1, 0);
-- --------------------------------------------------------
--
-- 表的结构 `ts_manager`
--
CREATE TABLE IF NOT EXISTS `ts_manager` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(10) NOT NULL,
`number` varchar(11) NOT NULL,
`add_time` varchar(15) NOT NULL,
`last_time` varchar(15) NOT NULL,
`role` tinyint(4) DEFAULT NULL,
`password` varchar(50) NOT NULL,
`ip` varchar(20) NOT NULL DEFAULT '' COMMENT 'IP地址',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员表' AUTO_INCREMENT=9 ;
--
-- 转存表中的数据 `ts_manager`
--
INSERT INTO `ts_manager` (`id`, `name`, `number`, `add_time`, `last_time`, `role`, `password`, `ip`) VALUES
(1, 'admin', '18893461204', '1493019642', '1493019642', NULL, 'dbe517ad2d76f4df1aa22e95ac2dd5a7', '127.0.0.1'),
(2, '李岩', '13119314313', '1493020407', '1493020407', 51, '96e79218965eb72c92a549dd5a330112', '127.0.0.1'),
(3, '薛之谦', '18934615241', '1493909238', '1493909238', 51, '96e79218965eb72c92a549dd5a330112', '127.0.0.1'),
(4, 'Jay', '18194232648', '1493107489', '1493107489', 51, '96e79218965eb72c92a549dd5a330112', '127.0.0.1'),
(5, '俊杰', '15194232648', '1493108158', '1493108158', 50, '96e79218965eb72c92a549dd5a330112', '127.0.0.1'),
(6, '明哲', '18893453104', '1493112375', '1493112375', 50, 'dbe517ad2d76f4df1aa22e95ac2dd5a7', '127.0.0.1'),
(8, '九儿姑娘', '18934615241', '1493111211', '1493111211', 50, '96e79218965eb72c92a549dd5a330112', '127.0.0.1');
-- --------------------------------------------------------
--
-- 表的结构 `ts_mark`
--
CREATE TABLE IF NOT EXISTS `ts_mark` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`st_id` int(4) DEFAULT NULL,
`qu_id` varchar(50) DEFAULT NULL,
`answer` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- 转存表中的数据 `ts_mark`
--
INSERT INTO `ts_mark` (`id`, `st_id`, `qu_id`, `answer`) VALUES
(1, 2017010101, '68,67,70', 'Upload/sanswer/20170611/xiwh1fjca.html'),
(2, 2017010102, '69,64,17', 'Upload/sanswer/20170519/uevi3afcb.html'),
(3, 2017010112, '66,63,71', 'Upload/sanswer/20170519/iteshk35r.html');
-- --------------------------------------------------------
--
-- 表的结构 `ts_question`
--
CREATE TABLE IF NOT EXISTS `ts_question` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` varchar(50) NOT NULL,
`select_a` varchar(200) DEFAULT NULL,
`select_b` varchar(200) DEFAULT NULL,
`select_c` varchar(200) DEFAULT NULL,
`select_d` varchar(200) DEFAULT '',
`type` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'type.value',
`answer` varchar(50) NOT NULL DEFAULT '',
`add_time` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=79 ;
--
-- 转存表中的数据 `ts_question`
--
INSERT INTO `ts_question` (`id`, `content`, `select_a`, `select_b`, `select_c`, `select_d`, `type`, `answer`, `add_time`) VALUES
(1, 'Upload/question/20170418/4mh1z0a2s.html', '有零个或多个输入', '有零个或多个输出', '有穷性', '可行性', 1, 'Upload/answer/20170418/4q83h92nc.html', '1492482638'),
(2, 'Upload/question/20170519/fkev12306.html', '整型、实型、逻辑型', '整型、实型、字符型', '整型、字符型、逻辑型', '整型、实型、逻辑型、字符型', 1, 'Upload/answer/20170519/57qk6aj20.html', '1495194850'),
(3, 'Upload/question/20170417/iyq0l1vog.html', '6.500000 ', '6', '5.500000', '6.000000', 1, 'Upload/answer/20170417/6vln3zj0y.html', '1492408324'),
(4, 'Upload/question/20170417/x0aeifrwq.html', 'INPUT x、y、z', ' scanf("%d%d%d",&x,&y,&z)', 'scanf("%d%d%d",x,y,z)', ' read("%d%d%d",&x,&y,&z)', 1, 'Upload/answer/20170417/4ncpusr9l.html', '1492408396'),
(5, 'Upload/question/20170417/yhxmr8w6j.html', '0', '1', '2', '-1', 1, 'Upload/answer/20170417/c1tj69ydu.html', '1492408442'),
(8, 'Upload/question/20170417/0dy1x369f.html', '''abc''', '"12''12"', '"0"', '" "', 1, 'Upload/answer/20170417/8xqrfvk4z.html', '1492408609'),
(9, 'Upload/question/20170417/wur9vxzme.html', 'if(x>y) z=x', 'if(x= =y) z=0', 'if(x!=y) printf("%d",x) else printf("%d",y)', 'if(x<y) { x++;y--;}', 1, 'Upload/answer/20170417/93pcuesza.html', '1492408674'),
(10, 'Upload/question/20170417/yrihz6j8a.html', 'a[0][2*1]', 'a[1][3]', 'a[4-2][0]', 'a[0][4]', 1, 'Upload/answer/20170417/estgnh7b6.html', '1492408715'),
(11, 'Upload/question/20170417/zkyh8x40f.html', '''a''''b''', 'abc', 'ab c', 'ab', 1, 'Upload/answer/20170417/5ye41dgxt.html', '1492408814'),
(12, 'Upload/question/20170418/oxireaswd.html', 'scanf', 'short', '_3com_', 'int', 2, 'Upload/answer/20170418/x46egytdn.html', '1492482768'),
(13, 'Upload/question/20170417/pt0ehmfyq.html', '主函数只能有一个', '主函数可以有多个', '非主函数只能有一个', '主函数和非主函数都可以有多个', 1, 'Upload/answer/20170417/6ae9rhx5g.html', '1492431974'),
(14, 'Upload/question/20170418/e9471frd5.html', 'auto', 'static', 'register', 'void ', 2, 'Upload/answer/20170418/6gbna9lij.html', '1492476536'),
(15, 'Upload/question/20170418/ok1e9f6t8.html', '+=', '>', ',', '>>', 2, 'Upload/answer/20170418/8o4lx9v3d.html', '1492482842'),
(17, 'Upload/question/20170418/7ktga4i0w.html', '', '', '', '', 6, 'Upload/answer/20170418/e9jnr6yw8.html', '1492479696'),
(20, 'Upload/question/20170509/culqgmf07.html', '本程序的main函数开始,到main函数结束', '本程序文件的第一个函数开始,到本程序文件的最后一个函数结束', '本程序的main函数开始,到本程序文件的最后一个函数结束', '本程序文件的第一个函数开始,到本程序main函数结束', 1, 'Upload/answer/20170509/7tk9owzes.html', '1494319674'),
(21, 'Upload/question/20170509/6hjyuc03n.html', 'if (a>b)', 'if (strcmp(a,b))', 'if (strcmp(b,a)>0)', 'if (strcmp(a,b)>0)', 1, 'Upload/answer/20170509/6cbak1qwt.html', '1494320605'),
(22, 'Upload/question/20170509/si4czxnmy.html', '关系运算符<算术运算符<赋值运算符<逻辑与运算符', '逻辑与运算符<关系运算符<算术运算符<赋值运算符 ', '赋值运算符<逻辑与运算符<关系运算符<算术运算符', '算术运算符<关系运算符<赋值运算符<逻辑与运算符', 1, 'Upload/answer/20170509/d0q9khn5t.html', '1494321863'),
(23, 'Upload/question/20170509/8wljuqgkv.html', 'a=2.2,b=3', 'a=2.2 b=3', '2.2 3', '2.2,3', 1, 'Upload/answer/20170509/roy3am2up.html', '1494322568'),
(24, 'Upload/question/20170509/t2lvy6k7g.html', '(12<=x)&(x<=y)', '(12<=x)&&(x<=y)', '(12<=x)|(x<=y)', '(12<=x)||(x<=y)', 1, 'Upload/answer/20170509/myed2uo0l.html', '1494323977'),
(25, 'Upload/question/20170509/5p7exuboc.html', '4', '6', '5', '1', 1, 'Upload/answer/20170509/sfem8k6iy.html', '1494324050'),
(26, 'Upload/question/20170509/73ybmqdlv.html', '(*p).c2.a', '(*p).a', 'p->c2.a', 'p.c2.a', 1, 'Upload/answer/20170509/ozt8xlci6.html', '1494324885'),
(27, 'Upload/question/20170509/0uajecv39.html', '5', '1', '0', '不确定值', 1, 'Upload/answer/20170509/jv905mg8l.html', '1494324962'),
(28, 'Upload/question/20170509/ocf4merbx.html', '9', '12', '14', '15', 1, 'Upload/answer/20170509/pbae1hq9r.html', '1494325053'),
(29, 'Upload/question/20170509/gtnj2ukwd.html', '无限次', '有语法错，不能执行', '一次也不执行', '执行1次', 1, 'Upload/answer/20170509/uxbgmenoj.html', '1494325128'),
(30, 'Upload/question/20170509/ciw68f1ph.html', '函数定义可以嵌套，但函数调用不能嵌套', '函数定义不可以嵌套，但函数调用可以嵌套', '函数定义和调用均不能嵌套', '函数定义和调用均可以嵌套', 1, 'Upload/answer/20170509/tfy3h87oi.html', '1494325179'),
(31, 'Upload/question/20170509/srhow1iv0.html', 'do-while语句构成的循环不能用其它语句构成的循环代替。', 'do-while语句构成的循环只能用break语句退出。', '用do-while语句构成的循环，在while后的表达式为非零时结束循环。', '用do-while语句构成的循环，在while后的表达式为零时结束循环。', 1, 'Upload/answer/20170509/c61ly3vk8.html', '1494325241'),
(32, 'Upload/question/20170509/bdrsal4i0.html', 'char str[5]= " good!"； ', 'char str[ ]= " good!"；', 'char *str=" good!"；', 'char str[5]={ ''g''，''o''，''o''，''d''}；', 1, 'Upload/answer/20170509/lbwk8rma0.html', '1494325437'),
(33, 'Upload/question/20170515/nwi24rgyh.html', '程序行', '函数', '语句', '字符', 2, 'Upload/answer/20170515/m0l84dtpv.html', '1494857266'),
(34, 'Upload/question/20170515/ptb1q0a9f.html', ' C语言程序中的main()函数必须放在程序的开始部分', 'C 语言程序总是从第一个函数开始执行', '在C语言程序中,要调用的函数必须在main()函数中定义', 'C 语言程序总是从 main() 函数开始执行', 2, 'Upload/answer/20170515/cai9n514v.html', '1494858489'),
(35, 'Upload/question/20170515/1kbpnx20w.html', 'C++语言程序总是从第一个函数开始执行', 'C++语言程序总是从main()函数开始执行 ', 'C++语言程序中的main()函数必须放在程序的开始部分', '在 C++ 语言程序中 , 要调用的函数必须在 main() 函数中定义 ', 2, 'Upload/answer/20170515/0vu9loh8z.html', '1494858856'),
(36, 'Upload/question/20170515/e0urjt875.html', 'Case', 'swicth', 'cher', 'default', 2, 'Upload/answer/20170515/a4sugq0xk.html', '1494858934'),
(37, 'Upload/question/20170515/kjgeafwtz.html', 'a3_b3 _123 IF', 'For -abc Case', 'void define WORD ', '2a DO sizeof', 2, 'Upload/answer/20170515/1aic0h7dq.html', '1494859221'),
(38, 'Upload/question/20170515/iro2mkd31.html', 'short', 'Char ', 'Double', 'integer', 2, 'Upload/answer/20170515/x49wm15sh.html', '1494859332'),
(39, 'Upload/question/20170515/0t4ciax6q.html', '0x2A', '0x11Au', '0X0', '3A', 2, 'Upload/answer/20170515/m2v69d47c.html', '1494859422'),
(40, 'Upload/question/20170515/w3ef4g9mc.html', '派生类可显现基类的任何函数成员', '派生类可重载已有的函数成员', '派生类可以拥有自己的新成员', '派生类无法给基类的数据成员初始化', 2, 'Upload/answer/20170515/0bund2tas.html', '1494859502'),
(41, 'Upload/question/20170515/5zv8xkgh2.html', 'auto', 'define', '6a', 'c', 2, 'Upload/answer/20170515/dsptybovr.html', '1494859650'),
(42, 'Upload/question/20170516/dawukqy5h.html', '', '', '', '', 3, 'Upload/answer/20170516/x5y6rufso.html', '1494908760'),
(43, 'Upload/question/20170516/35dvtf7gj.html', '', '', '', '', 3, 'Upload/answer/20170516/zg49d6kbc.html', '1494908816'),
(44, 'Upload/question/20170516/1pt3vkaq9.html', '', '', '', '', 3, 'Upload/answer/20170516/i15vfpw9g.html', '1494908848'),
(45, 'Upload/question/20170516/fy6ko14p3.html', '', '', '', '', 3, 'Upload/answer/20170516/s5u7f2xi0.html', '1494909143'),
(46, 'Upload/question/20170516/sej2fnzcd.html', '', '', '', '', 3, 'Upload/answer/20170516/2jehzmafl.html', '1494908957'),
(47, 'Upload/question/20170516/8o3shqk0i.html', '', '', '', '', 3, 'Upload/answer/20170516/uwz7mq8b3.html', '1494909008'),
(48, 'Upload/question/20170516/myv27j1i0.html', '', '', '', '', 3, 'Upload/answer/20170516/v8u4dcjlo.html', '1494909041'),
(49, 'Upload/question/20170516/v9daxwrfg.html', '', '', '', '', 3, 'Upload/answer/20170516/2fg90icmv.html', '1494909159'),
(50, 'Upload/question/20170516/ntmh7cw90.html', '', '', '', '', 3, 'Upload/answer/20170516/xza5qwkt1.html', '1494909130'),
(51, 'Upload/question/20170516/a89v4ight.html', '', '', '', '', 3, 'Upload/answer/20170516/jqmxoskei.html', '1494909210'),
(52, 'Upload/question/20170516/ghi5r2k6j.html', '', '', '', '', 3, 'Upload/answer/20170516/n7s9r2y8i.html', '1494909240'),
(54, 'Upload/question/20170516/mfki0duyj.html', '', '', '', '', 3, 'Upload/answer/20170516/nf596hl0g.html', '1494909657'),
(55, 'Upload/question/20170516/cvpr0eiqt.html', '', '', '', '', 4, 'Upload/answer/20170516/ucrs1l0gn.html', '1494914642'),
(56, 'Upload/question/20170516/gt67sfrpi.html', '', '', '', '', 4, 'Upload/answer/20170516/t36o9r1mh.html', '1494914941'),
(57, 'Upload/question/20170516/vrk84tpdj.html', '', '', '', '', 4, 'Upload/answer/20170516/2fyg1nohe.html', '1494916232'),
(58, 'Upload/question/20170516/zbsh80fmc.html', '', '', '', '', 4, 'Upload/answer/20170516/qe8f7job3.html', '1494916294'),
(59, 'Upload/question/20170516/2dgrfxyvc.html', '', '', '', '', 4, 'Upload/answer/20170516/ys7c6kqu0.html', '1494916361'),
(60, 'Upload/question/20170516/hrpn5mouq.html', '', '', '', '', 4, 'Upload/answer/20170516/d7b9u46xg.html', '1494916457'),
(61, 'Upload/question/20170516/nzibf5ghp.html', '', '', '', '', 4, 'Upload/answer/20170516/u2jp9ebgo.html', '1494916529'),
(62, 'Upload/question/20170516/vhpa3rwq2.html', '', '', '', '', 4, 'Upload/answer/20170516/xtocg78j2.html', '1494916567'),
(63, 'Upload/question/20170516/51tkrg7lo.html', '', '', '', '', 5, 'Upload/answer/20170516/t7efwuq1h.html', '1494919583'),
(64, 'Upload/question/20170516/6cbu1yo3h.html', '', '', '', '', 5, 'Upload/answer/20170516/y3tfcg185.html', '1494919662'),
(65, 'Upload/question/20170516/fvaxo2zs4.html', '', '', '', '', 5, 'Upload/answer/20170516/lri5k1cjx.html', '1494919702'),
(66, 'Upload/question/20170516/z6ro8p5tv.html', '', '', '', '', 5, 'Upload/answer/20170516/786t94jgc.html', '1494919837'),
(67, 'Upload/question/20170516/au2d73brv.html', '', '', '', '', 5, 'Upload/answer/20170516/7rcwl8zb0.html', '1494921140'),
(68, 'Upload/question/20170516/dyi5khgs6.html', '', '', '', '', 5, 'Upload/answer/20170516/9iwjq45u1.html', '1494921183'),
(69, 'Upload/question/20170516/p35odsmfl.html', '', '', '', '', 5, 'Upload/answer/20170516/42jeh3ly5.html', '1494921207'),
(70, 'Upload/question/20170516/dqp9w6c5h.html', '', '', '', '', 6, 'Upload/answer/20170516/n2c4drsmv.html', '1494921594'),
(71, 'Upload/question/20170516/ngqm3udze.html', '', '', '', '', 6, 'Upload/answer/20170516/gx18aro0f.html', '1494922643'),
(72, 'Upload/question/20170519/3nrid7ubh.html', '', '', '', '', 0, '', '1495191301'),
(73, 'Upload/question/20170519/0h3sriucj.html', '', '', '', '', 0, '', '1495191314'),
(77, 'Upload/question/20170519/s9oegifm8.html', '我去恶趣味', 'C++语言程序总是从main()函数开始执行', '6a', 'C 语言程序总是从 main() 函数开始执行', 2, 'Upload/answer/20170519/wz0gq65ia.html', '1495194827'),
(78, 'Upload/question/20170610/41kyjr0fz.html', 'chian tianjin ', 'echo chian tianjin', 'echo ', 'echochian tianjin chinatianjin', 1, 'Upload/answer/20170610/ewatkh4o9.html', '1497082581');
-- --------------------------------------------------------
--
-- 表的结构 `ts_role`
--
CREATE TABLE IF NOT EXISTS `ts_role` (
`role_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`role_name` varchar(20) NOT NULL COMMENT '角色名称',
`role_auth_ids` varchar(128) DEFAULT '' COMMENT '权限ids,1,2,5',
`role_auth_ac` text COMMENT '控制器-操作,控制器-操作,控制器-操作',
PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=53 ;
--
-- 转存表中的数据 `ts_role`
--
INSERT INTO `ts_role` (`role_id`, `role_name`, `role_auth_ids`, `role_auth_ac`) VALUES
(50, '管理员', '101,105,106,107,108,109,131,102,110,111,112,126,130,103,113,114,128,129', 'Test-entering,Test-see,Test-type,Test-exam,Test-upd,Score-student,Score-addstudent,Score-mark,Acticle-acticle,Acticle-add,Score-marking,Acticle-upd,Acticle-del,Score-del,Test-del'),
(51, '教师', '101,105,106,107,108,109,102,110,111,112,126,104,127', 'Test-entering,Test-see,Test-type,Test-exam,Test-upd,Score-student,Score-addstudent,Score-mark,Score- marking'),
(52, '用户', '101,105,106,107,102,110,104,127', 'Test-entering,Test-see,Test-type,Score-student,Manager-addmanager');
-- --------------------------------------------------------
--
-- 表的结构 `ts_student`
--
CREATE TABLE IF NOT EXISTS `ts_student` (
`t_number` int(50) NOT NULL AUTO_INCREMENT COMMENT '学号',
`name` varchar(20) NOT NULL COMMENT '姓名',
`dept` varchar(40) NOT NULL COMMENT '系名',
`major` varchar(40) NOT NULL COMMENT '专业',
`sex` char(4) NOT NULL COMMENT '性别',
`class` varchar(20) NOT NULL COMMENT '班级',
`password` varchar(50) NOT NULL DEFAULT 'e10adc3949ba59abbe56e057f20f883e' COMMENT '密码',
`id_number` varchar(18) NOT NULL COMMENT '身份证号',
`teacher` int(11) NOT NULL COMMENT '教师',
`mark` int(4) NOT NULL DEFAULT '0' COMMENT '分数',
PRIMARY KEY (`t_number`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 AUTO_INCREMENT=2017010114 ;
--
-- 转存表中的数据 `ts_student`
--
INSERT INTO `ts_student` (`t_number`, `name`, `dept`, `major`, `sex`, `class`, `password`, `id_number`, `teacher`, `mark`) VALUES
(2017010101, '陈勇文', '计算机系', '电子商务', '男', '07电商', '96e79218965eb72c92a549dd5a330112', '622223199408115113', 2, 2),
(2017010102, '安东尼', '电气与信息工程系', '软件工程', '男', '12班', '96e79218965eb72c92a549dd5a330112', '622223199408115112', 4, 87),
(2017010103, '道明', '电气与信息工程系', '软件工程', '男', '2班', '96e79218965eb72c92a549dd5a330112', '622223199408115114', 2, 77),
(2017010104, '柳絮', '外国语系', '英语', '女', '03班', 'e10adc3949ba59abbe56e057f20f883e', '622223199408115156', 4, 90),
(2017010105, '周迅', '外国语系', '英语', '女', '1班', 'e10adc3949ba59abbe56e057f20f883e', '621700151234456712', 3, 40),
(2017010106, 'lazy', '电气与信息工程系', '电气工程', '男', '2班', '96e79218965eb72c92a549dd5a330112', '622223166656565620', 3, 50),
(2017010107, '闫思文', '土木工程系', '土木工程', '女', '12班', '96e79218965eb72c92a549dd5a330112', '621700151234456762', 3, 94),
(2017010108, '李海生', '化学工程系', '化学', '男', '3班', 'dbe517ad2d76f4df1aa22e95ac2dd5a7', '622223166656565610', 4, 60),
(2017010109, '李欣', '电气与信息工程系', '电气工程', '男', '2班', '96e79218965eb72c92a549dd5a330112', '621700151234456756', 2, 55),
(2017010111, '李俊仁', '电气与信息工程系', '软件工程', '男', '2班', '93279e3308bdbbeed946fc965017f67a', '621345656161313134', 2, 0),
(2017010113, '刘一帆', '材料工程系', '材料科学', '男', '1班', 'e10adc3949ba59abbe56e057f20f883e', '655554899431221557', 4, 0);
-- --------------------------------------------------------
--
-- 表的结构 `ts_type`
--
CREATE TABLE IF NOT EXISTS `ts_type` (
`type_id` int(11) NOT NULL AUTO_INCREMENT,
`type_name` varchar(20) NOT NULL,
`value` varchar(4) NOT NULL DEFAULT '',
`en_name` varchar(20) NOT NULL DEFAULT '',
`info` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- 转存表中的数据 `ts_type`
--
INSERT INTO `ts_type` (`type_id`, `type_name`, `value`, `en_name`, `info`) VALUES
(1, '选择题', '0', 'main', 'Upload/info/20170519/e0583l6pq.html'),
(2, '单选题', '1', 'radio', 'Upload/info/20170418/wfiqg4bst.html'),
(3, '多选题', '2', 'multiple', 'Upload/info/20170417/vwnpy29om.html'),
(4, '填空题', '0', 'display', 'Upload/info/20170417/l017fdkzr.html'),
(5, '概念填空题', '3', 'concept', 'Upload/info/20170519/zdtf9mnek.html'),
(6, '程序填空题', '4', 'p_fill', 'Upload/info/20170516/mk64gtwjl.html'),
(7, '程序题', '0', 'defined', 'Upload/info/20170417/xcubqwzgi.html'),
(8, '程序问答题', '5', 'modify', 'Upload/info/20170417/kq9mho7du.html'),
(9, '程序编写题', '6', 'write', 'Upload/info/20170417/745y1nitx.html');
-- --------------------------------------------------------
--
-- 表的结构 `ts_user`
--
CREATE TABLE IF NOT EXISTS `ts_user` (
`id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Вы можете оставить комментарий после Вход в систему
Неприемлемый контент может быть отображен здесь и не будет показан на странице. Вы можете проверить и изменить его с помощью соответствующей функции редактирования.
Если вы подтверждаете, что содержание не содержит непристойной лексики/перенаправления на рекламу/насилия/вульгарной порнографии/нарушений/пиратства/ложного/незначительного или незаконного контента, связанного с национальными законами и предписаниями, вы можете нажать «Отправить» для подачи апелляции, и мы обработаем ее как можно скорее.
Опубликовать ( 0 )