stmms-ms-server/sql/清空所有数据脚本.sql

delete from attachment;
delete from change_level;
delete from check_data;
delete from check_data_error;
delete from exam_question;
delete from exam_score_prop;
delete from inspect_range;
delete from inspect_student;
delete from inspect_task;
delete from `level`;
delete from mark_log;
delete from mark_subject;
delete from mark_task_job;
delete from mark_task_level;
delete from mark_task_rough_level;
delete from mark_task_score;
delete from mark_user;
delete from marker_group;
delete from marker_group_leader;
delete from marker_group_student;
delete from message_receive;
delete from message;
delete from paper;
delete from param_setting;
delete from student;
delete from task_publish_setting;
delete from `work`;




alter table attachment AUTO_INCREMENT 1;
alter table change_level AUTO_INCREMENT 1;
alter table check_data AUTO_INCREMENT 1;
alter table check_data_error AUTO_INCREMENT 1;
alter table exam_question AUTO_INCREMENT 1;
alter table exam_score_prop AUTO_INCREMENT 1;
alter table inspect_range AUTO_INCREMENT 1;
alter table inspect_student AUTO_INCREMENT 1;
alter table inspect_task AUTO_INCREMENT 1;
alter table `level` AUTO_INCREMENT 1;
alter table mark_log AUTO_INCREMENT 1;
-- alter table mark_subject AUTO_INCREMENT 1;
alter table mark_task_job AUTO_INCREMENT 1;
alter table mark_task_level AUTO_INCREMENT 1;
alter table mark_task_rough_level AUTO_INCREMENT 1;
alter table mark_task_score AUTO_INCREMENT 1;
alter table mark_user AUTO_INCREMENT 1;
alter table marker_group AUTO_INCREMENT 1;
alter table marker_group_leader AUTO_INCREMENT 1;
alter table marker_group_student AUTO_INCREMENT 1;
alter table message AUTO_INCREMENT 1;
alter table message_receive AUTO_INCREMENT 1;
alter table paper AUTO_INCREMENT 1;
alter table param_setting AUTO_INCREMENT 1;
alter table student AUTO_INCREMENT 1;
alter table task_publish_setting AUTO_INCREMENT 1;
alter table `work` AUTO_INCREMENT 1;