题库管理系统sql

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50717 Source Host : localhost Source Database : qbms_manager Target Server Type : MySQL Target Server Version : 50717 File Encoding : utf-8 Date: 06/11/2017 17:21:04 PM */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for `make_paper` -- ---------------------------- DROP TABLE IF EXISTS `make_paper`; CREATE TABLE `make_paper` ( `id` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `paper_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `user_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `create_time` datetime DEFAULT NULL, `total_time` int(11) DEFAULT NULL COMMENT '单位:分钟', `start_time` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of `make_paper` -- ---------------------------- BEGIN; INSERT INTO `make_paper` VALUES ('011a7e4f-05c5-46b9-9d16-c329972b2897', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-21 21:13:56', '120', '2017-04-04 05:25:00'), ('239eff36-439a-4498-94d6-c674df36721e', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-24 16:17:39', '200', '2017-04-24 16:20:00'), ('2767c261-a4a5-46c6-bfc3-ac5fbaf96a95', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-23 16:56:05', '22', '2017-04-05 02:10:00'), ('2e2fa850-2fed-47bc-bf5e-054965cdff72', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-21 22:20:20', '13', '2017-04-05 06:25:00'), ('3625ed6c-6e86-44b1-887d-e0eec4c52c1f', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-21 14:56:57', '12', '2017-03-28 05:25:00'), ('39602247-4bba-4314-bfd2-64fe7db2bbbc', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-21 21:08:49', '120', '2017-04-04 05:25:00'), ('5220b0ee-dff8-45f8-abde-9d6adb831c91', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-21 21:52:36', '12', '2017-04-05 05:25:00'), ('558645f0-85f9-45ee-bd74-68e0deece1a9', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-23 16:15:55', '6', '2017-04-04 05:10:00'), ('5c6b88bd-f3e3-4413-87ba-78da2cbdd028', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-22 12:31:53', '12', '2017-03-29 05:25:00'), ('6413781b-b54c-4f61-8f97-6d764c238dd5', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-21 21:21:51', '120', '2017-04-04 01:25:00'), ('710baac5-ec18-448d-a12f-d3ca9540b5d4', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-23 17:03:06', '12', '2017-04-12 02:10:00'), ('7498421c-a124-4132-960f-3046405a2f3f', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-23 16:22:28', '22', '2017-04-05 02:10:00'), ('8e408c9d-f374-49c5-84a8-d0276c6423b1', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-21 22:29:22', '12', '2017-04-05 01:05:00'), ('985d63c1-e345-4035-bc6b-9ae738d29988', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-22 14:12:18', '120', '2017-04-04 00:05:00'), ('9959bf14-1c4e-408e-9c89-685c9727d6ed', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-21 22:27:35', '120', '2017-04-05 01:05:00'), ('a7c133c8-76da-4db5-b0d0-b92187277eee', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-23 16:19:12', '6', '2017-04-04 05:10:00'), ('bfcf3555-cad9-4269-ab91-91e21d0cac0c', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-23 16:51:34', '22', '2017-04-05 02:10:00'), ('cb50838a-bce8-4bf5-ad5c-b4895d2107eb', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-22 14:08:31', '333', '2017-04-04 01:05:00'), ('ce7f32f3-33dc-4147-9931-c7fb9f61ad15', 'cecc14e0-e4c6-4528-9b88-9f06dbf49081', '1', '2017-04-23 15:55:07', '12', '2017-04-05 05:05:00'), ('d98ae41c-3789-43b9-ac3d-4a407bc98bd6', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-23 15:54:10', '12', '2017-04-04 01:05:00'), ('e6494319-b74d-41c2-99a9-a3520f466e9a', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-23 16:51:17', '22', '2017-04-05 02:10:00'), ('e650f4dd-498a-4828-9b1c-679d7d798782', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-24 15:22:46', '120', '2017-04-24 15:25:00'), ('eb070229-93d6-4efb-87a2-edba15d4641b', 'cecc14e0-e4c6-4528-9b88-9f06dbf49081', '1', '2017-04-19 16:41:01', '12', '2017-04-04 09:25:00'), ('ee55af85-91f1-4b68-b0f7-4ccdcd8c7a4c', 'a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '2017-04-21 22:18:37', '120', '2017-03-28 05:05:00'), ('d7cc162d-532a-477d-a2de-96b7a44ea4f8', '36450c59-8d48-435f-aa59-c9bac38a65ae', '1', '2017-05-15 13:10:10', '120', '2017-05-16 10:30:00'), ('59b3545c-f46f-4d3a-946c-7eb6db218062', '0c0c90e5-b1d7-4c70-b35e-bfaec8b8bb88', '1', '2017-05-17 16:45:31', '120', '2017-05-18 10:00:00'); COMMIT; -- ---------------------------- -- Table structure for `manager_user_map` -- ---------------------------- DROP TABLE IF EXISTS `manager_user_map`; CREATE TABLE `manager_user_map` ( `id` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `manager_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `user_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of `manager_user_map` -- ---------------------------- BEGIN; INSERT INTO `manager_user_map` VALUES ('asdasd', '1', 'asdqw'); COMMIT; -- ---------------------------- -- Table structure for `paper` -- ---------------------------- DROP TABLE IF EXISTS `paper`; CREATE TABLE `paper` ( `paper_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `paper_category_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `paper_difficulty_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `content` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT '保存subject_id,小题用逗号隔开,大题用|隔开.', `create_time` datetime DEFAULT NULL, `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of `paper` -- ---------------------------- BEGIN; INSERT INTO `paper` VALUES ('0c0c90e5-b1d7-4c70-b35e-bfaec8b8bb88', '1', '7b973dda-dbff-4c15-adf2-228911173ee7', '52c860c0-c436-415c-80f2-e1b926140bec', 'null|12#50e29c95-95ba-4397-a645-da5a69fc414d,5d10da4e-f71e-4826-8f2b-4be16ae9ca57,60ee21de-16e5-4ddd-a022-64968c394d0c,81a476ff-ed93-4fdf-a5d4-b6d5e4ef13e5|5#40ef83af-c476-4fbd-82c1-5cec3d6f53d8,dac476db-2511-4fd7-b023-868222385b0e|5#30cb4d2d-7ea3-4609-9b98-ad8784876d0d,6f070a57-559b-480e-838f-b419be037d0b', '2017-04-28 15:46:30', '年级: 班级：姓名:', '高三期末考试离散下'), ('36450c59-8d48-435f-aa59-c9bac38a65ae', '1', '08f0d2fe-d5d0-4694-9076-4585c1e4523e', '52c860c0-c436-415c-80f2-e1b926140bec', '|15#ce2e1ca3-1ab2-457e-a0c1-2a3f0db78702', '2017-05-04 14:57:42', '年级: 班级：姓名:', '大二下java期末考试'), ('a6d043c8-6034-4cb2-b0e4-5749b43ff363', '1', '7b973dda-dbff-4c15-adf2-228911173ee7', 'eb2c28ad-c9ea-4899-a021-840e1d0959b1', 'null|3#5ae61710-1c31-4af5-9d16-33c4cd8f932d,5d10da4e-f71e-4826-8f2b-4be16ae9ca57,81a476ff-ed93-4fdf-a5d4-b6d5e4ef13e5|2#9af7037a-d975-49eb-bcbd-20f9f91c915b', '2017-04-05 15:43:31', '年级:133 班级：133 姓名:王如玉', 'as'), ('a9cc34aa-09a0-48b2-b512-7769054cf12e', '1', 'a04e0836-0332-4ed9-a728-3792b440672b', '52c860c0-c436-415c-80f2-e1b926140bec', 'null|22#1c1c996e-1136-425f-82b9-91a01dc5f13c,ce2e1ca3-1ab2-457e-a0c1-2a3f0db78702', '2017-05-04 14:59:40', '年级: 班级：姓名:', '大三java期末'), ('cecc14e0-e4c6-4528-9b88-9f06dbf49081', '1', '08f0d2fe-d5d0-4694-9076-4585c1e4523e', 'eb2c28ad-c9ea-4899-a021-840e1d0959b1', 'null|3#5ae61710-1c31-4af5-9d16-33c4cd8f932d,5d10da4e-f71e-4826-8f2b-4be16ae9ca57,81a476ff-ed93-4fdf-a5d4-b6d5e4ef13e5,e8b391a8-3e13-4c24-8e2f-81dac6f46ee3', '2017-04-05 15:35:55', '年级:133 班级：133 姓名:王如玉',