smart-factory/清空数据.sql

SET foreign_key_checks = 0;
truncate table benteler_plan;
truncate table benteler_plan_bak;
truncate table first_article_approval_task;
truncate table first_article_calendar;
truncate table first_article_item;
truncate table first_article_item_result;
truncate table first_article_task;
truncate table first_article_task_his_blob;
truncate table first_article_task_key;
truncate table first_article_title_blob;
truncate table first_article_workshop;
truncate table onsite_approval_plan;
truncate table onsite_approval_task;
truncate table onsite_calendar;
truncate table onsite_item;
truncate table onsite_item_result;
truncate table onsite_plan_his_blob;
truncate table onsite_task;
truncate table onsite_task_his_blob;
truncate table onsite_title_blob;
truncate table plan_bind;
truncate table onsite_workshop;
truncate table remind_approval_task;
truncate table us_user_wechat;
SET foreign_key_checks = 1;
delete from upload_file_blob where id > 1;
delete from us_user_role where user_id > 1;
delete from us_user where id > 1;