USE shixun;
-- 先删除外键约束(如果表存在)
DROP TABLE IF EXISTS reviews;
DROP TABLE IF EXISTS courses;
-- 然后创建表
CREATE TABLE courses (
id BIGINT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
cover_path VARCHAR(255),
intro TEXT,
sort INT,
video_path VARCHAR(255),
author VARCHAR(100),
status ENUM('DRAFT', 'SUBMITTED', 'APPROVED', 'REJECTED', 'PUBLISHED'),
create_time DATETIME,
update_time DATETIME
);
DROP TABLE IF EXISTS reviews;
CREATE TABLE reviews (
id BIGINT AUTO_INCREMENT PRIMARY KEY,
course_id BIGINT NOT NULL,
reviewer_name VARCHAR(100) NOT NULL,
review_content TEXT,
rating INT CHECK (rating BETWEEN 1 AND 5),
status ENUM('PENDING', 'APPROVED', 'REJECTED') DEFAULT 'PENDING',
review_time DATETIME,
FOREIGN KEY (course_id) REFERENCES courses(id)
);
INSERT INTO courses (name, cover_path, intro, sort, video_path, author, status, create_time, update_time)
VALUES
('Java编程基础', '/uploads/covers/java-basic.jpg', '从零开始学习Java编程语言', 1, '/uploads/videos/java-basic.mp4', '张老师', 'PUBLISHED', '2025-01-01 00:00:00', '2025-01-01 00:00:00'),
('Spring Boot实战', '/uploads/covers/jspring-boot.jpg', '快速构建企业级Spring应用', 2, '/uploads/videos/spring-boot.mp4', '李老师', 'PUBLISHED', '2025-01-02 00:00:00', '2025-01-02 00:00:00'),
('Vue.js前端开发', '/uploads/covers/jvuejs.jpg', '现代前端框架Vue.js入门到精通', 3, '/uploads/videos/vuejs.mp4', '王老师', 'PUBLISHED', '2025-01-03 00:00:00', '2025-01-03 00:00:00'),
('数据库设计与优化', '/uploads/covers/jdatabase.jpg', '关系型数据库设计与性能优化', 4, '/uploads/videos/database.mp4', '赵老师', 'PUBLISHED', '2025-01-04 00:00:00', '2025-01-04 00:00:00'),
('微服务架构', '/uploads/covers/jmicroservice.jpg', '基于Spring Cloud的微服务架构', 5, '/uploads/videos/microservice.mp4', '陈老师', 'PUBLISHED', '2025-01-05 00:00:00', '2025-01-05 00:00:00'),
('Python数据分析', '/uploads/covers/jpython.jpg', '使用Python进行数据分析和可视化', 6, '/uploads/videos/python.mp4', '钱老师', 'APPROVED', '2025-01-06 00:00:00', '2025-01-06 00:00:00'),
('Docker容器技术', '/uploads/covers/jdocker.jpg', '容器化应用部署与管理', 7, '/uploads/videos/docker.mp4', '孙老师', 'SUBMITTED', '2025-01-07 00:00:00', '2025-01-07 00:00:00'),
('React高级开发', '/uploads/covers/jreact.jpg', 'React高级模式与最佳实践', 8, '/uploads/videos/react.mp4', '周老师', 'DRAFT', '2025-01-08 00:00:00', '2025-01-08 00:00:00'),
('Kubernetes实战', '/uploads/covers/jk8s.jpg', '云原生应用编排与管理', 9, '/uploads/videos/k8s.mp4', '吴老师', 'REJECTED', '2025-01-09 00:00:00', '2025-01-09 00:00:00'),
('人工智能基础', '/uploads/covers/jai.jpg', '机器学习与深度学习入门', 10, '/uploads/videos/ai.mp4', '郑老师', 'PUBLISHED', '2025-01-10 00:00:00', '2025-01-10 00:00:00'),
('DevOps实践', '/uploads/covers/jdevops.jpg', '持续集成与持续交付', 11, '/uploads/videos/devops.mp4', '王老师', 'PUBLISHED', '2025-01-11 00:00:00', '2025-01-11 00:00:00'),
('区块链技术', '/uploads/covers/jblockchain.jpg', '区块链原理与应用开发', 12, '/uploads/videos/blockchain.mp4', '林老师', 'DRAFT', '2025-01-12 00:00:00', '2025-01-12 00:00:00'),
('大数据处理', '/uploads/covers/jbigdata.jpg', 'Hadoop与Spark实战', 13, '/uploads/videos/bigdata.mp4', '黄老师', 'SUBMITTED', '2025-01-13 00:00:00', '2025-01-13 00:00:00'),
('网络安全', '/uploads/covers/jsecurity.jpg', 'Web安全与渗透测试', 14, '/uploads/videos/security.mp4', '徐老师', 'APPROVED', '2025-01-14 00:00:00', '2025-01-14 00:00:00'),
('移动应用开发', '/uploads/covers/jmobile.jpg', 'Flutter跨平台开发', 15, '/uploads/videos/mobile.mp4', '马老师', 'PUBLISHED', '2025-01-15 00:00:00', '2025-01-15 00:00:00');
INSERT INTO reviews (course_id, reviewer_name, review_content, rating, status, review_time)
VALUES
(1, '张老师', '课程内容全面,适合初学者入门', 5, 'APPROVED', '2025-01-16 10:00:00'),
(1, '李老师', '讲解清晰,但部分示例代码可以优化', 4, 'APPROVED', '2025-01-16 11:30:00'),
(2, '王老师', '实战性强,建议增加更多案例', 4, 'APPROVED', '2025-01-17 09:15:00'),
(3, '赵老师', '前端框架讲解深入浅出', 5, 'APPROVED', '2025-01-17 14:20:00'),
(4, '陈老师', '数据库设计部分需要更新', 3, 'REJECTED', '2025-01-18 16:45:00'),
(5, '钱老师', '微服务架构讲解非常专业', 5, 'APPROVED', '2025-01-19 10:30:00'),
(6, '孙老师', 'Python数据分析内容实用', 4, 'PENDING', '2025-01-20 13:15:00'),
(7, '周老师', 'Docker内容需要补充新特性', 3, 'PENDING', '2025-01-21 15:00:00');
我现在的数据库是mysql,叫eshop,应该怎么修改