sourcecode/server/data/src/main/resources/db/migration/V1__init_table.sql

CREATE TABLE manager (
  id int(11) unsigned NOT NULL AUTO_INCREMENT,
  username varchar(50) NOT NULL DEFAULT '' COMMENT '管理员名称',
  password varchar(64) NOT NULL DEFAULT '' COMMENT '管理员密码',
  role_id int(11) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
  create_time datetime DEFAULT NULL,
  update_time datetime DEFAULT NULL,
  delete_time datetime DEFAULT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY username (username,delete_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员账号';

INSERT INTO `exercise_struct` (`id`, `title_zh`, `title_en`, `parent_id`, `order`, `level`, `question_status`, `is_sentence`, `is_examination`, `description`, `extend`)
VALUES
	(1, '长难句', '', 0, 0, 1, 0, 1, 0, '', 'sentence'),
	(2, '语文', 'Verbial', 0, 0, 1, 0, 0, 1, '', 'verbial'),
	(3, '数学', 'Quant', 0, 0, 1, 0, 0, 1, '', 'quant'),
	(4, '综合推理', 'IR', 0, 0, 1, 0, 0, 1, '', 'ir'),
	(5, '作文', 'AWA', 0, 0, 1, 0, 0, 1, '', 'awa'),
	(6, '句改', 'SC', 2, 0, 2, 0, 0, 1, NULL, 'sc'),
	(7, '阅读', 'RC', 2, 0, 2, 0, 0, 1, NULL, 'rc'),
	(8, '逻辑', 'CR', 2, 0, 2, 0, 0, 1, NULL, 'cr'),
	(9, '充分性分析', 'DS', 3, 0, 2, 0, 0, 1, NULL, 'ds'),
	(10, '问题求解', 'PS', 3, 0, 2, 0, 0, 1, NULL, 'ps'),
	(11, '综合推理', 'IR', 4, 0, 2, 0, 0, 1, NULL, 'ir'),
	(12, '写作', 'AWA', 5, 0, 2, 0, 0, 1, NULL, 'awa');

INSERT INTO `examination_struct` (`id`, `title_zh`, `title_en`, `parent_id`, `order`, `level`, `is_adapt`, `extend`, `description`)
VALUES
	(1, 'CAT 难度适应性', '', 0, 0, 1, 1, 'base', NULL),
	(2, '非难度适应性', '', 0, 0, 1, 0, 'base', NULL),
	(3, '千行CAT', '', 1, 0, 2, 1, 'qx_cat', NULL),
	(4, '净化版PREP-CAT', '', 1, 0, 2, 1, NULL, NULL),
	(5, 'GWD-CAT', '', 1, 0, 2, 1, NULL, NULL);