use scan_db;
CREATE UNIQUE INDEX `exam_student_subject` ON sc_student (`exam_id`, `student_code`, `subject_code`);

INSERT INTO `sc_user` (`school_id`, `role`, `create_time`, `update_time`, `enable`, `login_name`, `name`, `password`,
                       `creator_id`, `updater_id`)
VALUES (1, 'SCHOOL_ADMIN', unix_timestamp(now()) * 1000, unix_timestamp(now()) * 1000, 1, 'admin', '学校管理员', '123456', 1,
        1);

INSERT INTO `sc_system_config` (`id`, `create_time`, `update_time`, `creator_id`, `updater_id`, `scanner_enable_login`,
                                `scanner_password`, `system_mode`, `client_version`, `client_uri`, `client_md5`,
                                `client_update_time`)
VALUES (1, NULL, NULL, NULL, NULL, 1, NULL, 'STANDALONE', NULL, NULL, NULL, NULL);