Home Explore Help
Register Sign In
TuBinYan
/
course-learning-backend
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
course-learn...
/
sql
/
courselearning.sql

courselearning.sql 32 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350 
  1. create database if not exists `courselearning` default charset utf8mb4;
    2. 

  2. 

  3. use `courselearning`;
    4. 

  4. 

  5. SET FOREIGN_KEY_CHECKS=0;
    6. 

  6. 

  7. -- ----------------------------
    8. 

  8. -- Table structure for `course`
    9. 

  9. -- ----------------------------
    10. 

  10. DROP TABLE IF EXISTS `course`;
    11. 

  11. CREATE TABLE `course` (
    12. 

  12.   `id` int NOT NULL AUTO_INCREMENT,
    13. 

  13.   `name` varchar(255) NOT NULL,
    14. 

  14.   `type` varchar(255) DEFAULT NULL,
    15. 

  15.   `intro` varchar(255) DEFAULT NULL,
    16. 

  16.   `picture` varchar(255) DEFAULT NULL,
    17. 

  17.   `school` varchar(255) DEFAULT NULL,
    18. 

  18.   `create_time` datetime NOT NULL,
    19. 

  19.   `delete_time` datetime DEFAULT NULL,
    20. 

  20.   `cost` int NOT NULL,
    21. 

  21.   `teacher_id` int NOT NULL,
    22. 

  22.   `teacher_name` varchar(255) DEFAULT NULL,
    23. 

  23.   PRIMARY KEY (`id`),
    24. 

  24.   KEY `fk_user_course` (`teacher_id`),
    25. 

  25.   CONSTRAINT `fk_user_course` FOREIGN KEY (`teacher_id`) REFERENCES `user_info` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
    26. 

  26. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    27. 

  27. 

  28. -- ----------------------------
    29. 

  29. -- Records of course
    30. 

  30. -- ----------------------------
    31. 

  31. INSERT INTO `course` VALUES ('1', '软件工程与计算 I', '中级', '通过Scheme、Python和Java语言，让你分别体会函数式编程范式、结构化编程范式和面向对象编程范式', 'course1.png', '南京大学', '2020-12-20 10:00:00', null, '1', 100, '刘钦');
    32. 

  32. INSERT INTO `course` VALUES ('2', '软件工程与计算 II', '中级', '基于DevOps培养团队开发中小规模软件系统的能力', 'course2.png', '南京大学', '2020-12-20 10:00:00', null, '1', 200, '刘钦');
    33. 

  33. INSERT INTO `course` VALUES ('3', '程序猿与攻城狮', '初级', '我们将由5位老师从不同的角度来说说他们对软件工程的理解。我们并非试图去覆盖所有软件工程的知识点，我们只是希望去让对软件工程有兴趣的你们了解到“我要学什么”“我应如何学”“我今后能做什么”这样一些基本的问题的部分答案。\r\n\r\n   刘钦老师会介绍软件工程的历史和软件工程建模；丁二玉老师会谈谈软件工程师和软件工程团队；冯桂焕老师会通过案例让大家体验人机交互的魅力；陈振宇老师会从概率统计讲到软件测试；刘嘉老师会娓娓道来他对最热门的移动互联网发展的本质的理解。', 'course3.png', '南京大学', '2020-12-20 10:00:00', null, '1', 300, '刘钦');
    34. 

  34. INSERT INTO `course` VALUES ('4', '基于Java的面向对象编程范式', '初级', '本课程完成了编程思维、结构化编程范式、面向对象编程方式的介绍，并且着重强调了面向对象编程中封装、协作和可修改性三个重要概念。通过客观题和6道编程题的训练，进一步加深对面向对象编程范式的理解，初步领略面向对象编程范式的风采。', 'course4.png', '南京大学', '2020-12-20 10:00:00', null, '1', 400, '刘钦');
    35. 

  35. INSERT INTO `course` VALUES ('5', '移动互联网软件工程', '高级', '本课程结合软件工程方法学，从移动互联网需求出发，结合现有的互联网企业产品架构分析，探讨移动互联网软件开发的各种关注点、应用架构基础。', 'no.png', '南京大学', '2020-12-20 10:00:00', null, '1', 500, '刘钦');
    36. 

  36. 

  37. -- ----------------------------
    38. 

  38. -- Table structure for `course_order`
    39. 

  39. -- ----------------------------
    40. 

  40. DROP TABLE IF EXISTS `course_order`;
    41. 

  41. CREATE TABLE `course_order` (
    42. 

  42.   `id` int NOT NULL AUTO_INCREMENT,
    43. 

  43.   `origin` int NOT NULL,
    44. 

  44.   `cost` int NOT NULL,
    45. 

  45.   `course_id` int NOT NULL,
    46. 

  46.   `course_name` varchar(255) NOT NULL,
    47. 

  47.   `create_time` datetime NOT NULL,
    48. 

  48.   `user_id` int NOT NULL,
    49. 

  49.   `status` int NOT NULL,
    50. 

  50.   PRIMARY KEY (`id`),
    51. 

  51.   KEY `fk_course_order` (`course_id`),
    52. 

  52.   CONSTRAINT `fk_course_order` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE,
    53. 

  53.   KEY `fk_user_order` (`user_id`),
    54. 

  54.   CONSTRAINT `fk_user_order` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
    55. 

  55. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    56. 

  56. 

  57. -- ----------------------------
    58. 

  58. -- Table structure for `course_ware`
    59. 

  59. -- ----------------------------
    60. 

  60. DROP TABLE IF EXISTS `course_ware`;
    61. 

  61. CREATE TABLE `course_ware` (
    62. 

  62.   `id` int NOT NULL AUTO_INCREMENT,
    63. 

  63.   `course_id` int NOT NULL,
    64. 

  64.   `number` int NOT NULL,
    65. 

  65.   `title` varchar(255) NOT NULL,
    66. 

  66.   `file_name` varchar(255) DEFAULT NULL,
    67. 

  67.   `file_type` varchar(255) DEFAULT NULL,
    68. 

  68.   `file_size` varchar(255) DEFAULT NULL,
    69. 

  69.   `free_flag` tinyint(1) NOT NULL DEFAULT '0',
    70. 

  70.   `download_flag` tinyint(1) NOT NULL DEFAULT '1',
    71. 

  71.   `upload_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    72. 

  72.   PRIMARY KEY (`id`),
    73. 

  73.   KEY `fk_course_ware` (`course_id`),
    74. 

  74.   CONSTRAINT `fk_course_ware` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
    75. 

  75. ) ENGINE=InnoDB AUTO_INCREMENT=198 DEFAULT CHARSET=utf8mb4;
    76. 

  76. 

  77. -- ----------------------------
    78. 

  78. -- Records of course_ware
    79. 

  79. -- ----------------------------
    80. 

  80. INSERT INTO `course_ware` VALUES ('2', '1', '1', '00 - Overview', null, null, null, '0', '1', '2020-12-18 10:00:00');
    81. 

  81. INSERT INTO `course_ware` VALUES ('3', '1', '2', '01 - 编程语言概述', null, null, null, '0', '1', '2020-12-18 10:00:00');
    82. 

  82. INSERT INTO `course_ware` VALUES ('4', '1', '3', '02 - 编程基础 I-分解与抽象', null, null, null, '0', '1', '2020-12-18 10:00:00');
    83. 

  83. INSERT INTO `course_ware` VALUES ('5', '1', '4', '03 - 编程基础 II-可计算性', null, null, null, '0', '1', '2020-12-18 10:00:00');
    84. 

  84. INSERT INTO `course_ware` VALUES ('6', '1', '5', '04 - 编程基础 III-Lambda演算', null, null, null, '0', '1', '2020-12-18 10:00:00');
    85. 

  85. INSERT INTO `course_ware` VALUES ('7', '1', '6', '05 - 编程基础 IV-函数式编程范式', null, null, null, '0', '1', '2020-12-18 10:00:00');
    86. 

  86. INSERT INTO `course_ware` VALUES ('8', '1', '7', '06 - 编程基础 V-习题课', null, null, null, '0', '1', '2020-12-18 10:00:00');
    87. 

  87. INSERT INTO `course_ware` VALUES ('9', '1', '8', '07 - 结构化编程 I - 思想', null, null, null, '0', '1', '2020-12-18 10:00:00');
    88. 

  88. INSERT INTO `course_ware` VALUES ('10', '1', '9', '08 - 结构化编程 II - 变量', null, null, null, '0', '1', '2020-12-18 10:00:00');
    89. 

  89. INSERT INTO `course_ware` VALUES ('11', '1', '10', '09 - 结构化编程 III - 方法', null, null, null, '0', '1', '2020-12-18 10:00:00');
    90. 

  90. INSERT INTO `course_ware` VALUES ('12', '1', '11', '10 - 面向对象编程 I-思想', null, null, null, '0', '1', '2020-12-18 10:00:00');
    91. 

  91. INSERT INTO `course_ware` VALUES ('13', '1', '12', '11 - 面向对象编程 II-封装', null, null, null, '0', '1', '2020-12-18 10:00:00');
    92. 

  92. INSERT INTO `course_ware` VALUES ('14', '1', '13', '12 - 面向对象编程 III-协作', null, null, null, '0', '1', '2020-12-18 10:00:00');
    93. 

  93. INSERT INTO `course_ware` VALUES ('15', '1', '14', '13 - 软件工程建模', null, null, null, '0', '1', '2020-12-18 10:00:00');
    94. 

  94. INSERT INTO `course_ware` VALUES ('16', '1', '15', '14 - JVM和字节码基础', null, null, null, '0', '1', '2020-12-18 10:00:00');
    95. 

  95. INSERT INTO `course_ware` VALUES ('17', '1', '16', '15 - 面向对象编程III-继承与多态', null, null, null, '0', '1', '2020-12-18 10:00:00');
    96. 

  96. INSERT INTO `course_ware` VALUES ('18', '1', '17', '16 - 面向对象编程 IV-可修改性', null, null, null, '0', '1', '2020-12-18 10:00:00');
    97. 

  97. INSERT INTO `course_ware` VALUES ('19', '1', '18', '17 - 面向对象编程 V-接口', null, null, null, '0', '1', '2020-12-18 10:00:00');
    98. 

  98. INSERT INTO `course_ware` VALUES ('20', '1', '19', '18 - 异常', null, null, null, '0', '1', '2020-12-18 10:00:00');
    99. 

  99. INSERT INTO `course_ware` VALUES ('21', '1', '20', '19 - Network and Thread', null, null, null, '0', '1', '2020-12-18 10:00:00');
    100. 

  100. INSERT INTO `course_ware` VALUES ('22', '1', '21', '20 - Graphical User Interface', null, null, null, '0', '1', '2020-12-18 10:00:00');
    101. 

  101. INSERT INTO `course_ware` VALUES ('23', '1', '22', 'Git介绍', null, null, null, '0', '1', '2020-12-18 10:00:00');
    102. 

  102. INSERT INTO `course_ware` VALUES ('24', '1', '23', 'Java编程基础', null, null, null, '0', '1', '2020-12-18 10:00:00');
    103. 

  103. INSERT INTO `course_ware` VALUES ('25', '1', '24', 'Lab01-环境配置', null, null, null, '0', '1', '2020-12-18 10:00:00');
    104. 

  104. INSERT INTO `course_ware` VALUES ('26', '1', '25', 'Lab02-Seec系统', null, null, null, '0', '1', '2020-12-18 10:00:00');
    105. 

  105. INSERT INTO `course_ware` VALUES ('27', '1', '26', 'Lab03-简单分支和循环的训练', null, null, null, '0', '1', '2020-12-18 10:00:00');
    106. 

  106. INSERT INTO `course_ware` VALUES ('28', '1', '27', 'Lab04-Anagram', null, null, null, '0', '1', '2020-12-18 10:00:00');
    107. 

  107. INSERT INTO `course_ware` VALUES ('29', '1', '28', 'Lab05-arrival_of_general', null, null, null, '0', '1', '2020-12-18 10:00:00');
    108. 

  108. INSERT INTO `course_ware` VALUES ('30', '1', '29', 'Lab06-Taxi', null, null, null, '0', '1', '2020-12-18 10:00:00');
    109. 

  109. INSERT INTO `course_ware` VALUES ('31', '1', '30', 'Programming-01-Basics', null, null, null, '0', '1', '2020-12-18 10:00:00');
    110. 

  110. INSERT INTO `course_ware` VALUES ('32', '1', '31', 'Programming-02-Variable & Type', null, null, null, '0', '1', '2020-12-18 10:00:00');
    111. 

  111. INSERT INTO `course_ware` VALUES ('33', '1', '32', 'Programming-03-Control Flow', null, null, null, '0', '1', '2020-12-18 10:00:00');
    112. 

  112. INSERT INTO `course_ware` VALUES ('34', '1', '33', 'Programming-04-Method', null, null, null, '0', '1', '2020-12-18 10:00:00');
    113. 

  113. INSERT INTO `course_ware` VALUES ('35', '1', '34', 'Programming-05-Module', null, null, null, '0', '1', '2020-12-18 10:00:00');
    114. 

  114. INSERT INTO `course_ware` VALUES ('36', '1', '35', 'Programming-06-Composite Data', null, null, null, '0', '1', '2020-12-18 10:00:00');
    115. 

  115. INSERT INTO `course_ware` VALUES ('37', '1', '36', 'Programming-07-Input & Output', null, null, null, '0', '1', '2020-12-18 10:00:00');
    116. 

  116. INSERT INTO `course_ware` VALUES ('38', '1', '37', 'Programming-08-Lambda and Functional Programming', null, null, null, '0', '1', '2020-12-18 10:00:00');
    117. 

  117. INSERT INTO `course_ware` VALUES ('39', '1', '38', 'Programming-09-Simulation and Calculation', null, null, null, '0', '1', '2020-12-18 10:00:00');
    118. 

  118. INSERT INTO `course_ware` VALUES ('40', '1', '39', 'Python-01-HelloWorld和Variable', null, null, null, '0', '1', '2020-12-18 10:00:00');
    119. 

  119. INSERT INTO `course_ware` VALUES ('41', '1', '40', 'Python-02-控制流', null, null, null, '0', '1', '2020-12-18 10:00:00');
    120. 

  120. INSERT INTO `course_ware` VALUES ('42', '1', '41', 'Python-03-函数', null, null, null, '0', '1', '2020-12-18 10:00:00');
    121. 

  121. INSERT INTO `course_ware` VALUES ('43', '1', '42', 'Python-04-模块', null, null, null, '0', '1', '2020-12-18 10:00:00');
    122. 

  122. INSERT INTO `course_ware` VALUES ('44', '1', '43', 'Python-05-复合数据', null, null, null, '0', '1', '2020-12-18 10:00:00');
    123. 

  123. INSERT INTO `course_ware` VALUES ('45', '1', '44', 'Python-06-输入输出', null, null, null, '0', '1', '2020-12-18 10:00:00');
    124. 

  124. INSERT INTO `course_ware` VALUES ('46', '1', '45', 'Python-07-Lambda and Functional Programming', null, null, null, '0', '1', '2020-12-18 10:00:00');
    125. 

  125. INSERT INTO `course_ware` VALUES ('47', '1', '46', 'Reference-01-Byte-of-Python', null, null, null, '0', '1', '2020-12-18 10:00:00');
    126. 

  126. INSERT INTO `course_ware` VALUES ('48', '1', '47', 'Reference-02-Turing, His Machine and Computability', null, null, null, '0', '1', '2020-12-18 10:00:00');
    127. 

  127. INSERT INTO `course_ware` VALUES ('49', '1', '48', 'Reference-03-Register Machines are Turing Machines', null, null, null, '0', '1', '2020-12-18 10:00:00');
    128. 

  128. INSERT INTO `course_ware` VALUES ('50', '1', '49', 'Reference-04-Lambda', null, null, null, '0', '1', '2020-12-18 10:00:00');
    129. 

  129. INSERT INTO `course_ware` VALUES ('51', '1', '50', 'Z总结', null, null, null, '0', '1', '2020-12-18 10:00:00');
    130. 

  130. INSERT INTO `course_ware` VALUES ('52', '1', '51', '谷歌软件工程', null, null, null, '0', '1', '2020-12-18 10:00:00');
    131. 

  131. INSERT INTO `course_ware` VALUES ('53', '1', '52', '软件工程守破离', null, null, null, '0', '1', '2020-12-18 10:00:00');
    132. 

  132. INSERT INTO `course_ware` VALUES ('54', '2', '1', '00-Overview', null, null, null, '0', '1', '2020-12-18 10:00:00');
    133. 

  133. INSERT INTO `course_ware` VALUES ('55', '2', '2', '01-软件工程基础', null, null, null, '0', '1', '2020-12-18 10:00:00');
    134. 

  134. INSERT INTO `course_ware` VALUES ('56', '2', '3', '02-软件工程的发展', null, null, null, '0', '1', '2020-12-18 10:00:00');
    135. 

  135. INSERT INTO `course_ware` VALUES ('57', '2', '4', '04-项目启动', null, null, null, '0', '1', '2020-12-18 10:00:00');
    136. 

  136. INSERT INTO `course_ware` VALUES ('58', '2', '5', '05-需求基础', null, null, null, '0', '1', '2020-12-18 10:00:00');
    137. 

  137. INSERT INTO `course_ware` VALUES ('59', '2', '6', '06-需求分析方法', null, null, null, '0', '1', '2020-12-18 10:00:00');
    138. 

  138. INSERT INTO `course_ware` VALUES ('60', '2', '7', '07-需求文档化与验证', null, null, null, '0', '1', '2020-12-18 10:00:00');
    139. 

  139. INSERT INTO `course_ware` VALUES ('61', '2', '8', '08-软件设计基础', null, null, null, '0', '1', '2020-12-18 10:00:00');
    140. 

  140. INSERT INTO `course_ware` VALUES ('62', '2', '9', '09-软件体系结构基础', null, null, null, '0', '1', '2020-12-18 10:00:00');
    141. 

  141. INSERT INTO `course_ware` VALUES ('63', '2', '10', '10-软件体系结构设计与构建', null, null, null, '0', '1', '2020-12-18 10:00:00');
    142. 

  142. INSERT INTO `course_ware` VALUES ('64', '2', '11', '11-人机交互', null, null, null, '0', '1', '2020-12-18 10:00:00');
    143. 

  143. INSERT INTO `course_ware` VALUES ('65', '2', '12', '12-详细设计', null, null, null, '0', '1', '2020-12-18 10:00:00');
    144. 

  144. INSERT INTO `course_ware` VALUES ('66', '2', '13', '13-模块化与信息隐藏', null, null, null, '0', '1', '2020-12-18 10:00:00');
    145. 

  145. INSERT INTO `course_ware` VALUES ('67', '2', '14', '14-面向对象的模块化', null, null, null, '0', '1', '2020-12-18 10:00:00');
    146. 

  146. INSERT INTO `course_ware` VALUES ('68', '2', '15', '15-面向对象的信息隐藏', null, null, null, '0', '1', '2020-12-18 10:00:00');
    147. 

  147. INSERT INTO `course_ware` VALUES ('69', '2', '16', '16-设计模式', null, null, null, '0', '1', '2020-12-18 10:00:00');
    148. 

  148. INSERT INTO `course_ware` VALUES ('70', '2', '17', '16工厂设计模式', null, null, null, '0', '1', '2020-12-18 10:00:00');
    149. 

  149. INSERT INTO `course_ware` VALUES ('71', '2', '18', '16设计模式练习', null, null, null, '0', '1', '2020-12-18 10:00:00');
    150. 

  150. INSERT INTO `course_ware` VALUES ('72', '2', '19', '17-软件构造', null, null, null, '0', '1', '2020-12-18 10:00:00');
    151. 

  151. INSERT INTO `course_ware` VALUES ('73', '2', '20', '18-代码设计', null, null, null, '0', '1', '2020-12-18 10:00:00');
    152. 

  152. INSERT INTO `course_ware` VALUES ('74', '2', '21', '19-软件测试', null, null, null, '0', '1', '2020-12-18 10:00:00');
    153. 

  153. INSERT INTO `course_ware` VALUES ('75', '2', '22', '20-软件交付', null, null, null, '0', '1', '2020-12-18 10:00:00');
    154. 

  154. INSERT INTO `course_ware` VALUES ('76', '2', '23', '21-软件维护与演化', null, null, null, '0', '1', '2020-12-18 10:00:00');
    155. 

  155. INSERT INTO `course_ware` VALUES ('77', '2', '24', '22-软件开发过程模型', null, null, null, '0', '1', '2020-12-18 10:00:00');
    156. 

  156. INSERT INTO `course_ware` VALUES ('78', '2', '25', '23-软件工程职业基础', null, null, null, '0', '1', '2020-12-18 10:00:00');
    157. 

  157. INSERT INTO `course_ware` VALUES ('79', '2', '26', 'Homework01-软工二大作业迭代一功能需求简述', null, null, null, '0', '1', '2020-12-18 10:00:00');
    158. 

  158. INSERT INTO `course_ware` VALUES ('80', '2', '27', 'Ref-01-SEEC系统课程与小组说明', null, null, null, '0', '1', '2020-12-18 10:00:00');
    159. 

  159. INSERT INTO `course_ware` VALUES ('81', '2', '28', 'Ref-02-代码作业使用说明', null, null, null, '0', '1', '2020-12-18 10:00:00');
    160. 

  160. INSERT INTO `course_ware` VALUES ('82', '2', '29', 'Review01-用例文档点评', null, null, null, '0', '1', '2020-12-18 10:00:00');
    161. 

  161. INSERT INTO `course_ware` VALUES ('83', '2', '30', 'Review02-需求规格点评', null, null, null, '0', '1', '2020-12-18 10:00:00');
    162. 

  162. INSERT INTO `course_ware` VALUES ('84', '2', '31', 'Review03-体系结构', null, null, null, '0', '1', '2020-12-18 10:00:00');
    163. 

  163. INSERT INTO `course_ware` VALUES ('85', '2', '32', 'Web开发-01-浏览器的渲染原理', null, null, null, '0', '1', '2020-12-18 10:00:00');
    164. 

  164. INSERT INTO `course_ware` VALUES ('86', '2', '33', 'Web开发-02-HTTP协议原理', null, null, null, '0', '1', '2020-12-18 10:00:00');
    165. 

  165. INSERT INTO `course_ware` VALUES ('87', '2', '34', 'Web开发-03-Tomcat和Servlet原理', null, null, null, '0', '1', '2020-12-18 10:00:00');
    166. 

  166. INSERT INTO `course_ware` VALUES ('88', '2', '35', 'Web开发-04-REST和JSON', null, null, null, '0', '1', '2020-12-18 10:00:00');
    167. 

  167. INSERT INTO `course_ware` VALUES ('89', '2', '36', 'Web开发-05-Springboot入门', null, null, null, '0', '1', '2020-12-18 10:00:00');
    168. 

  168. INSERT INTO `course_ware` VALUES ('90', '2', '37', 'Web开发-06-GUI入门', null, null, null, '0', '1', '2020-12-18 10:00:00');
    169. 

  169. INSERT INTO `course_ware` VALUES ('91', '2', '38', 'Web开发-07-数据设计', null, null, null, '0', '1', '2020-12-18 10:00:00');
    170. 

  170. INSERT INTO `course_ware` VALUES ('92', '2', '39', 'Web开发-08-MVC-MVP-MVVM', null, null, null, '0', '1', '2020-12-18 10:00:00');
    171. 

  171. INSERT INTO `course_ware` VALUES ('93', '2', '40', 'Web开发-09-Vue实战--前端', null, null, null, '0', '1', '2020-12-18 10:00:00');
    172. 

  172. INSERT INTO `course_ware` VALUES ('94', '2', '41', 'Web开发-10-Springboot+Mybatis--后端', null, null, null, '0', '1', '2020-12-18 10:00:00');
    173. 

  173. INSERT INTO `course_ware` VALUES ('95', '2', '42', '复习提纲', null, null, null, '0', '1', '2020-12-18 10:00:00');
    174. 

  174. INSERT INTO `course_ware` VALUES ('96', '3', '1', '软件工程历史和软件工程建模', null, null, null, '0', '1', '2020-12-18 10:00:00');
    175. 

  175. INSERT INTO `course_ware` VALUES ('97', '3', '2', '软件工程历史', null, null, null, '0', '1', '2020-12-18 10:00:00');
    176. 

  176. INSERT INTO `course_ware` VALUES ('98', '3', '3', '数学和计算机建模', null, null, null, '0', '1', '2020-12-18 10:00:00');
    177. 

  177. INSERT INTO `course_ware` VALUES ('99', '3', '4', '软件工程建模', null, null, null, '0', '1', '2020-12-18 10:00:00');
    178. 

  178. INSERT INTO `course_ware` VALUES ('100', '3', '5', '编程思想', null, null, null, '0', '1', '2020-12-18 10:00:00');
    179. 

  179. INSERT INTO `course_ware` VALUES ('101', '3', '6', '测试一', null, null, null, '0', '1', '2020-12-18 10:00:00');
    180. 

  180. INSERT INTO `course_ware` VALUES ('102', '3', '7', '软件工程师和软件工程团队', null, null, null, '0', '1', '2020-12-18 10:00:00');
    181. 

  181. INSERT INTO `course_ware` VALUES ('103', '3', '8', '软件工程师是做什么的 上集', null, null, null, '0', '1', '2020-12-18 10:00:00');
    182. 

  182. INSERT INTO `course_ware` VALUES ('104', '3', '9', '软件工程师是做什么的 下集', null, null, null, '0', '1', '2020-12-18 10:00:00');
    183. 

  183. INSERT INTO `course_ware` VALUES ('105', '3', '10', '软件工程团队的三驾马车', null, null, null, '0', '1', '2020-12-18 10:00:00');
    184. 

  184. INSERT INTO `course_ware` VALUES ('106', '3', '11', '软件工程团队的其他重要角色', null, null, null, '0', '1', '2020-12-18 10:00:00');
    185. 

  185. INSERT INTO `course_ware` VALUES ('107', '3', '12', '测试二', null, null, null, '0', '1', '2020-12-18 10:00:00');
    186. 

  186. INSERT INTO `course_ware` VALUES ('108', '3', '13', '人机交互', null, null, null, '0', '1', '2020-12-18 10:00:00');
    187. 

  187. INSERT INTO `course_ware` VALUES ('109', '3', '14', '人机交互概述', null, null, null, '0', '1', '2020-12-18 10:00:00');
    188. 

  188. INSERT INTO `course_ware` VALUES ('110', '3', '15', '启发式设计原则', null, null, null, '0', '1', '2020-12-18 10:00:00');
    189. 

  189. INSERT INTO `course_ware` VALUES ('111', '3', '16', '人机交互的软件工程方法—— 启发式评估', null, null, null, '0', '1', '2020-12-18 10:00:00');
    190. 

  190. INSERT INTO `course_ware` VALUES ('112', '3', '17', '测试三', null, null, null, '0', '1', '2020-12-18 10:00:00');
    191. 

  191. INSERT INTO `course_ware` VALUES ('113', '3', '18', '概率统计到软件测试', null, null, null, '0', '1', '2020-12-18 10:00:00');
    192. 

  192. INSERT INTO `course_ware` VALUES ('114', '3', '19', '数字与计算', null, null, null, '0', '1', '2020-12-18 10:00:00');
    193. 

  193. INSERT INTO `course_ware` VALUES ('115', '3', '20', '计算与概率', null, null, null, '0', '1', '2020-12-18 10:00:00');
    194. 

  194. INSERT INTO `course_ware` VALUES ('116', '3', '21', '概率与测试', null, null, null, '0', '1', '2020-12-18 10:00:00');
    195. 

  195. INSERT INTO `course_ware` VALUES ('117', '3', '22', '测试与生活', null, null, null, '0', '1', '2020-12-18 10:00:00');
    196. 

  196. INSERT INTO `course_ware` VALUES ('118', '3', '23', '生活与数字', null, null, null, '0', '1', '2020-12-18 10:00:00');
    197. 

  197. INSERT INTO `course_ware` VALUES ('119', '3', '24', '测试四', null, null, null, '0', '1', '2020-12-18 10:00:00');
    198. 

  198. INSERT INTO `course_ware` VALUES ('120', '3', '25', '移动互联网本质', null, null, null, '0', '1', '2020-12-18 10:00:00');
    199. 

  199. INSERT INTO `course_ware` VALUES ('121', '3', '26', '连接', null, null, null, '0', '1', '2020-12-18 10:00:00');
    200. 

  200. INSERT INTO `course_ware` VALUES ('122', '3', '27', '时间', null, null, null, '0', '1', '2020-12-18 10:00:00');
    201. 

  201. INSERT INTO `course_ware` VALUES ('123', '3', '28', '未来', null, null, null, '0', '1', '2020-12-18 10:00:00');
    202. 

  202. INSERT INTO `course_ware` VALUES ('124', '3', '29', '本质', null, null, null, '0', '1', '2020-12-18 10:00:00');
    203. 

  203. INSERT INTO `course_ware` VALUES ('125', '4', '1', '1 - 编程之前', null, null, null, '0', '1', '2020-12-18 10:00:00');
    204. 

  204. INSERT INTO `course_ware` VALUES ('126', '4', '2', '1-01-科学思维vs工程思维', null, null, null, '0', '1', '2020-12-18 10:00:00');
    205. 

  205. INSERT INTO `course_ware` VALUES ('127', '4', '3', '1-02-数学建模', null, null, null, '0', '1', '2020-12-18 10:00:00');
    206. 

  206. INSERT INTO `course_ware` VALUES ('128', '4', '4', '1-03-计算机建模 1', null, null, null, '0', '1', '2020-12-18 10:00:00');
    207. 

  207. INSERT INTO `course_ware` VALUES ('129', '4', '5', '1-04-计算机建模 2', null, null, null, '0', '1', '2020-12-18 10:00:00');
    208. 

  208. INSERT INTO `course_ware` VALUES ('130', '4', '6', '1-05-软件工程建模', null, null, null, '0', '1', '2020-12-18 10:00:00');
    209. 

  209. INSERT INTO `course_ware` VALUES ('131', '4', '7', '1-06-软件开发生命周期模型', null, null, null, '0', '1', '2020-12-18 10:00:00');
    210. 

  210. INSERT INTO `course_ware` VALUES ('132', '4', '8', '1-07-分解与抽象', null, null, null, '0', '1', '2020-12-18 10:00:00');
    211. 

  211. INSERT INTO `course_ware` VALUES ('133', '4', '9', '1-08-层次性', null, null, null, '0', '1', '2020-12-18 10:00:00');
    212. 

  212. INSERT INTO `course_ware` VALUES ('134', '4', '10', '1-09-HelloWorld', null, null, null, '0', '1', '2020-12-18 10:00:00');
    213. 

  213. INSERT INTO `course_ware` VALUES ('135', '4', '11', '1-10-代码是用来读的', null, null, null, '0', '1', '2020-12-18 10:00:00');
    214. 

  214. INSERT INTO `course_ware` VALUES ('136', '4', '12', '1-11-有代码就得有测试', null, null, null, '0', '1', '2020-12-18 10:00:00');
    215. 

  215. INSERT INTO `course_ware` VALUES ('137', '4', '13', '1-12-用例来给需求建模', null, null, null, '0', '1', '2020-12-18 10:00:00');
    216. 

  216. INSERT INTO `course_ware` VALUES ('138', '4', '14', '第一单元 单元测试', null, null, null, '0', '1', '2020-12-18 10:00:00');
    217. 

  217. INSERT INTO `course_ware` VALUES ('139', '4', '15', '2 - 结构化编程范式', null, null, null, '0', '1', '2020-12-18 10:00:00');
    218. 

  218. INSERT INTO `course_ware` VALUES ('140', '4', '16', '2-01-结构化编程思想', null, null, null, '0', '1', '2020-12-18 10:00:00');
    219. 

  219. INSERT INTO `course_ware` VALUES ('141', '4', '17', '2-02-数据流图', null, null, null, '0', '1', '2020-12-18 10:00:00');
    220. 

  220. INSERT INTO `course_ware` VALUES ('142', '4', '18', '2-03-结构图', null, null, null, '0', '1', '2020-12-18 10:00:00');
    221. 

  221. INSERT INTO `course_ware` VALUES ('143', '4', '19', '2-04-数据流图向结构图的转变', null, null, null, '0', '1', '2020-12-18 10:00:00');
    222. 

  222. INSERT INTO `course_ware` VALUES ('144', '4', '20', '2-05-顺序、循环、分支', null, null, null, '0', '1', '2020-12-18 10:00:00');
    223. 

  223. INSERT INTO `course_ware` VALUES ('145', '4', '21', '2-06-MatrixCalculation', null, null, null, '0', '1', '2020-12-18 10:00:00');
    224. 

  224. INSERT INTO `course_ware` VALUES ('146', '4', '22', '2-07-避免重复', null, null, null, '0', '1', '2020-12-18 10:00:00');
    225. 

  225. INSERT INTO `course_ware` VALUES ('147', '4', '23', '2-08-测试分支和循环', null, null, null, '0', '1', '2020-12-18 10:00:00');
    226. 

  226. INSERT INTO `course_ware` VALUES ('148', '4', '24', '第二单元 单元测试', null, null, null, '0', '1', '2020-12-18 10:00:00');
    227. 

  227. INSERT INTO `course_ware` VALUES ('149', '4', '25', '3 - 面向对象编程范式', null, null, null, '0', '1', '2020-12-18 10:00:00');
    228. 

  228. INSERT INTO `course_ware` VALUES ('150', '4', '26', '3-01-变更时不可以避免的', null, null, null, '0', '1', '2020-12-18 10:00:00');
    229. 

  229. INSERT INTO `course_ware` VALUES ('151', '4', '27', '3-02-大范围的修改vs有限范围', null, null, null, '0', '1', '2020-12-18 10:00:00');
    230. 

  230. INSERT INTO `course_ware` VALUES ('152', '4', '28', '3-03-面向对象的世界观', null, null, null, '0', '1', '2020-12-18 10:00:00');
    231. 

  231. INSERT INTO `course_ware` VALUES ('153', '4', '29', '3-04-类和对象', null, null, null, '0', '1', '2020-12-18 10:00:00');
    232. 

  232. INSERT INTO `course_ware` VALUES ('154', '4', '30', '3-05-BadMatrix', null, null, null, '0', '1', '2020-12-18 10:00:00');
    233. 

  233. INSERT INTO `course_ware` VALUES ('155', '4', '31', '3-06-重用', null, null, null, '0', '1', '2020-12-18 10:00:00');
    234. 

  234. INSERT INTO `course_ware` VALUES ('156', '4', '32', '3-07-测试单个类', null, null, null, '0', '1', '2020-12-18 10:00:00');
    235. 

  235. INSERT INTO `course_ware` VALUES ('157', '4', '33', '第三单元 单元测试', null, null, null, '0', '1', '2020-12-18 10:00:00');
    236. 

  236. INSERT INTO `course_ware` VALUES ('158', '4', '34', '4 - 类的封装', null, null, null, '0', '1', '2020-12-18 10:00:00');
    237. 

  237. INSERT INTO `course_ware` VALUES ('159', '4', '35', '4-01-在一起', null, null, null, '0', '1', '2020-12-18 10:00:00');
    238. 

  238. INSERT INTO `course_ware` VALUES ('160', '4', '36', '4-02-封装', null, null, null, '0', '1', '2020-12-18 10:00:00');
    239. 

  239. INSERT INTO `course_ware` VALUES ('161', '4', '37', '4-03-MyMatrix', null, null, null, '0', '1', '2020-12-18 10:00:00');
    240. 

  240. INSERT INTO `course_ware` VALUES ('162', '4', '38', '4-04-寻找类和对象', null, null, null, '0', '1', '2020-12-18 10:00:00');
    241. 

  241. INSERT INTO `course_ware` VALUES ('163', '4', '39', '4-05-用类图表达类的职责', null, null, null, '0', '1', '2020-12-18 10:00:00');
    242. 

  242. INSERT INTO `course_ware` VALUES ('164', '4', '40', '4-06-防御式编程', null, null, null, '0', '1', '2020-12-18 10:00:00');
    243. 

  243. INSERT INTO `course_ware` VALUES ('165', '4', '41', '4-07-静态变量和静态方法', null, null, null, '0', '1', '2020-12-18 10:00:00');
    244. 

  244. INSERT INTO `course_ware` VALUES ('166', '4', '42', '4-08-简单类的初始化', null, null, null, '0', '1', '2020-12-18 10:00:00');
    245. 

  245. INSERT INTO `course_ware` VALUES ('167', '4', '43', '第四单元 单元测试', null, null, null, '0', '1', '2020-12-18 10:00:00');
    246. 

  246. INSERT INTO `course_ware` VALUES ('168', '4', '44', '5 - 类的协作', null, null, null, '0', '1', '2020-12-18 10:00:00');
    247. 

  247. INSERT INTO `course_ware` VALUES ('169', '4', '45', '5-01-职责', null, null, null, '0', '1', '2020-12-18 10:00:00');
    248. 

  248. INSERT INTO `course_ware` VALUES ('170', '4', '46', '5-02-协作', null, null, null, '0', '1', '2020-12-18 10:00:00');
    249. 

  249. INSERT INTO `course_ware` VALUES ('171', '4', '47', '5-03-类之间的关系', null, null, null, '0', '1', '2020-12-18 10:00:00');
    250. 

  250. INSERT INTO `course_ware` VALUES ('172', '4', '48', '5-04-TicTacToe', null, null, null, '0', '1', '2020-12-18 10:00:00');
    251. 

  251. INSERT INTO `course_ware` VALUES ('173', '4', '49', '5-05-用顺序图表达类的协作', null, null, null, '0', '1', '2020-12-18 10:00:00');
    252. 

  252. INSERT INTO `course_ware` VALUES ('174', '4', '50', '5-06-用Mock Object来辅助测试协作', null, null, null, '0', '1', '2020-12-18 10:00:00');
    253. 

  253. INSERT INTO `course_ware` VALUES ('175', '4', '51', '第五单元 单元测验', null, null, null, '0', '1', '2020-12-18 10:00:00');
    254. 

  254. INSERT INTO `course_ware` VALUES ('176', '4', '52', '6-类的可重用和可修改', null, null, null, '0', '1', '2020-12-18 10:00:00');
    255. 

  255. INSERT INTO `course_ware` VALUES ('177', '4', '53', '6-01-可修改性', null, null, null, '0', '1', '2020-12-18 10:00:00');
    256. 

  256. INSERT INTO `course_ware` VALUES ('178', '4', '54', '6-02-继承', null, null, null, '0', '1', '2020-12-18 10:00:00');
    257. 

  257. INSERT INTO `course_ware` VALUES ('179', '4', '55', '6-03-多态', null, null, null, '0', '1', '2020-12-18 10:00:00');
    258. 

  258. INSERT INTO `course_ware` VALUES ('180', '4', '56', '6-04-抽象类和抽象方法', null, null, null, '0', '1', '2020-12-18 10:00:00');
    259. 

  259. INSERT INTO `course_ware` VALUES ('181', '4', '57', '6-05-接口', null, null, null, '0', '1', '2020-12-18 10:00:00');
    260. 

  260. INSERT INTO `course_ware` VALUES ('182', '4', '58', '6-06-NewTicTacToe', null, null, null, '0', '1', '2020-12-18 10:00:00');
    261. 

  261. INSERT INTO `course_ware` VALUES ('183', '4', '59', '6-07-继承和组合', null, null, null, '0', '1', '2020-12-18 10:00:00');
    262. 

  262. INSERT INTO `course_ware` VALUES ('184', '4', '60', '6-08-按接口编程', null, null, null, '0', '1', '2020-12-18 10:00:00');
    263. 

  263. INSERT INTO `course_ware` VALUES ('185', '4', '61', '6-09-实现可修改性', null, null, null, '0', '1', '2020-12-18 10:00:00');
    264. 

  264. INSERT INTO `course_ware` VALUES ('186', '4', '62', '6-10-复杂类的初始化', null, null, null, '0', '1', '2020-12-18 10:00:00');
    265. 

  265. INSERT INTO `course_ware` VALUES ('187', '5', '1', '00 - 关于课程', null, null, null, '0', '1', '2020-12-18 10:00:00');
    266. 

  266. INSERT INTO `course_ware` VALUES ('188', '5', '2', '01 - 软件工程方法学', null, null, null, '0', '1', '2020-12-18 10:00:00');
    267. 

  267. INSERT INTO `course_ware` VALUES ('189', '5', '3', '02 - 移动互联网需求分析', null, null, null, '0', '1', '2020-12-18 10:00:00');
    268. 

  268. INSERT INTO `course_ware` VALUES ('190', '5', '4', '03 - 移动互联网公司架构分析I - 架构视角', null, null, null, '0', '1', '2020-12-18 10:00:00');
    269. 

  269. INSERT INTO `course_ware` VALUES ('191', '5', '5', '04 - 移动互联网架构分析II - 关注点', null, null, null, '0', '1', '2020-12-18 10:00:00');
    270. 

  270. INSERT INTO `course_ware` VALUES ('192', '5', '6', '05 - 移动互联网应用App体系结构设计', null, null, null, '0', '1', '2020-12-18 10:00:00');
    271. 

  271. INSERT INTO `course_ware` VALUES ('193', '5', '7', '06 - 移动互联网商业视角', null, null, null, '0', '1', '2020-12-18 10:00:00');
    272. 

  272. INSERT INTO `course_ware` VALUES ('194', '5', '8', '07 - UI设计', null, null, null, '0', '1', '2020-12-18 10:00:00');
    273. 

  273. INSERT INTO `course_ware` VALUES ('195', '5', '9', '08 - 秒杀系统', null, null, null, '0', '1', '2020-12-18 10:00:00');
    274. 

  274. INSERT INTO `course_ware` VALUES ('196', '5', '10', '09 - 敏捷软件开发', null, null, null, '0', '1', '2020-12-18 10:00:00');
    275. 

  275. INSERT INTO `course_ware` VALUES ('197', '5', '11', '10 - 微服务', null, null, null, '0', '1', '2020-12-18 10:00:00');
    276. 

  276. 

  277. 

  278. -- ----------------------------
    279. 

  279. -- Table structure for `user_info`
    280. 

  280. -- ----------------------------
    281. 

  281. DROP TABLE IF EXISTS `user_info`;
    282. 

  282. CREATE TABLE `user_info` (
    283. 

  283.   `id` int NOT NULL AUTO_INCREMENT,
    284. 

  284.   `uname` varchar(255) NOT NULL,
    285. 

  285.   `phone` varchar(255) NOT NULL,
    286. 

  286.   `password` varchar(255) NOT NULL,
    287. 

  287.   `picture` varchar(255) DEFAULT NULL,
    288. 

  288.   `balance` int NOT NULL,
    289. 

  289.   `user_role` varchar(255) NOT NULL,
    290. 

  290.   `create_time` datetime NOT NULL,
    291. 

  291.   PRIMARY KEY (`id`)
    292. 

  292. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    293. 

  293. 

  294. -- ----------------------------
    295. 

  295. -- Records of course_ware
    296. 

  296. -- ----------------------------
    297. 

  297. INSERT INTO `user_info` VALUES ('1', '刘钦', '10112345678', '123456', null, 0, 'TEACHER', '2020-12-18 10:00:00');
    298. 

  298. INSERT INTO `user_info` VALUES ('2', '小明', '10212345678', '123456', null, 0, 'STUDENT', '2020-12-18 10:00:00');
    299. 

  299. 

  300. -- ----------------------------
    301. 

  301. -- Table structure for `recharge_order`
    302. 

  302. -- ----------------------------
    303. 

  303. 

  304. DROP TABLE IF EXISTS `recharge_order`;
    305. 

  305. CREATE TABLE `recharge_order` (
    306. 

  306.   `order_id` int NOT NULL AUTO_INCREMENT,
    307. 

  307.   `user_id` int NOT NULL,
    308. 

  308.   `value` int NOT NULL,
    309. 

  309.   `create_time` datetime NOT NULL,
    310. 

  310.   PRIMARY KEY (`order_id`),
    311. 

  311.   KEY `fk_user_recharge` (`user_id`),
    312. 

  312.   CONSTRAINT `fk_user_recharge` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE
    313. 

  313. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    314. 

  314. 

  315. 

  316. -- ----------------------------
    317. 

  317. -- Table structure for `coupon`
    318. 

  318. -- ----------------------------
    319. 

  319. 

  320. DROP TABLE IF EXISTS `coupon`;
    321. 

  321. CREATE TABLE `coupon` (
    322. 

  322.   `id` int NOT NULL AUTO_INCREMENT,
    323. 

  323.   `type` varchar(255) NOT NULL,
    324. 

  324.   `name` varchar(255) NOT NULL,
    325. 

  325.   `description` varchar(255) NOT NULL,
    326. 

  326.   `course_id` int DEFAULT '-1',
    327. 

  327.   `valid_user_id` int DEFAULT '-1',
    328. 

  328.   `threshold` int DEFAULT '0',
    329. 

  329.   `discount` double DEFAULT '1.0',
    330. 

  330.   `cut_down` int DEFAULT '0',
    331. 

  331.   `start_time` datetime DEFAULT NULL,
    332. 

  332.   `end_time` datetime DEFAULT NULL,
    333. 

  333.   `is_valid` tinyint(1) NOT NULL DEFAULT '1',
    334. 

  334.   `is_sharable` tinyint(1) NOT NULL DEFAULT '1',
    335. 

  335.   PRIMARY KEY (`id`)
    336. 

  336. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
    337. 

  337. 

  338. 

  339. -- ----------------------------
    340. 

  340. -- Table structure for `course_likes`
    341. 

  341. -- ----------------------------
    342. 

  342. 

  343. DROP TABLE IF EXISTS `course_likes`;
    344. 

  344. CREATE TABLE `course_likes` (
    345. 

  345.   `course_id` int NOT NULL,
    346. 

  346.   `user_id` int NOT NULL,
    347. 

  347.   PRIMARY KEY (`course_id`, `user_id`)
    348. 

  348. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    349. 

  349. 

  350. SET FOREIGN_KEY_CHECKS=1;
    351.