29 lines
898 B
SQL
29 lines
898 B
SQL
-- =============================================
|
|
-- EduNexus Pro - 清理脚本
|
|
-- 危险操作！仅用于开发环境
|
|
-- =============================================
|
|
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
DROP TABLE IF EXISTS `submission_details`;
|
|
DROP TABLE IF EXISTS `student_submissions`;
|
|
DROP TABLE IF EXISTS `assignments`;
|
|
DROP TABLE IF EXISTS `exam_nodes`;
|
|
DROP TABLE IF EXISTS `exams`;
|
|
DROP TABLE IF EXISTS `question_knowledge`;
|
|
DROP TABLE IF EXISTS `questions`;
|
|
DROP TABLE IF EXISTS `knowledge_points`;
|
|
DROP TABLE IF EXISTS `textbook_lessons`;
|
|
DROP TABLE IF EXISTS `textbook_units`;
|
|
DROP TABLE IF EXISTS `textbooks`;
|
|
DROP TABLE IF EXISTS `subjects`;
|
|
DROP TABLE IF EXISTS `class_members`;
|
|
DROP TABLE IF EXISTS `classes`;
|
|
DROP TABLE IF EXISTS `grades`;
|
|
DROP TABLE IF EXISTS `schools`;
|
|
DROP TABLE IF EXISTS `application_users`;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
|
|
|
SELECT '所有表已删除' AS Status;
|