lkl_tea

分支 (1)

管理

管理

lkl_tea

online_education
/
online_edu.sql

# Host: localhost  (Version: 5.5.53)
# Date: 2019-03-22 16:31:57
# Generator: MySQL-Front 5.3  (Build 4.234)

/*!40101 SET NAMES utf8 */;

#
# Structure for table "announcement"
#

DROP TABLE IF EXISTS `announcement`;
CREATE TABLE `announcement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0',
  `course_id` int(11) DEFAULT '0',
  `task_id` int(11) DEFAULT NULL,
  `start_time` varchar(255) DEFAULT NULL,
  `end_time` varchar(255) DEFAULT NULL,
  `content` mediumtext,
  `time` varchar(55) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "announcement"
#


#
# Structure for table "ask"
#

DROP TABLE IF EXISTS `ask`;
CREATE TABLE `ask` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0',
  `tea_id` int(11) DEFAULT NULL,
  `course_id` int(11) DEFAULT '0',
  `task_id` int(11) DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `looks` int(11) DEFAULT '0',
  `results` int(11) DEFAULT '0',
  `time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "ask"
#


#
# Structure for table "ask_result"
#

DROP TABLE IF EXISTS `ask_result`;
CREATE TABLE `ask_result` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `from_user_id` int(11) DEFAULT '0',
  `ask_id` int(11) DEFAULT '0',
  `to_user_id` int(11) DEFAULT '0',
  `content` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "ask_result"
#


#
# Structure for table "comment"
#

DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0',
  `course_id` int(11) DEFAULT '0',
  `star` int(11) DEFAULT '0',
  `content` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "comment"
#


#
# Structure for table "course"
#

DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0',
  `type` int(11) DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `pass` int(11) DEFAULT '0',
  `specialty_id` int(11) DEFAULT '0',
  `subject_id` int(11) DEFAULT '0',
  `subhead` varchar(255) DEFAULT NULL,
  `intro` varchar(255) DEFAULT NULL,
  `goal` varchar(255) DEFAULT NULL,
  `to_people` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf32 DEFAULT NULL,
  `views` bigint(20) DEFAULT '0',
  `students` bigint(20) DEFAULT '0',
  `price` float(15,2) DEFAULT '0.00',
  `comments` int(11) unsigned DEFAULT '0',
  `comment_val` float(15,2) DEFAULT '0.00',
  `task_num` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "course"
#


#
# Structure for table "course_collect"
#

DROP TABLE IF EXISTS `course_collect`;
CREATE TABLE `course_collect` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0',
  `course_id` int(11) DEFAULT '0',
  `time` varchar(255) DEFAULT NULL,
  `exist` int(11) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "course_collect"
#


#
# Structure for table "course_specialty"
#

DROP TABLE IF EXISTS `course_specialty`;
CREATE TABLE `course_specialty` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "course_specialty"
#


#
# Structure for table "course_subject"
#

DROP TABLE IF EXISTS `course_subject`;
CREATE TABLE `course_subject` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `specialty_id` int(11) DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "course_subject"
#


#
# Structure for table "image_info"
#

DROP TABLE IF EXISTS `image_info`;
CREATE TABLE `image_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0',
  `type` int(11) DEFAULT '0',
  `path` varchar(255) DEFAULT NULL,
  `use0` int(11) DEFAULT '0',
  `time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "image_info"
#


#
# Structure for table "join_test_paper"
#

DROP TABLE IF EXISTS `join_test_paper`;
CREATE TABLE `join_test_paper` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tea_id` int(11) DEFAULT '0',
  `user_id` int(11) DEFAULT '0',
  `test_paper_id` int(11) DEFAULT '0',
  `course_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `result` varchar(255) DEFAULT NULL,
  `score` float DEFAULT '0',
  `time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "join_test_paper"
#


#
# Structure for table "learn_course"
#

DROP TABLE IF EXISTS `learn_course`;
CREATE TABLE `learn_course` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0',
  `course_id` int(11) DEFAULT '0',
  `rate` int(11) DEFAULT '0',
  `time` varchar(55) DEFAULT NULL,
  `finish` int(11) DEFAULT '0',
  `total_task` int(11) DEFAULT NULL,
  `end_update` varchar(55) DEFAULT NULL,
  `exist` int(11) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "learn_course"
#


#
# Structure for table "learn_task"
#

DROP TABLE IF EXISTS `learn_task`;
CREATE TABLE `learn_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0',
  `task_id` int(11) DEFAULT '0',
  `learn_time` float DEFAULT '0',
  `rate` int(11) DEFAULT '0',
  `course_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "learn_task"
#


#
# Structure for table "material"
#

DROP TABLE IF EXISTS `material`;
CREATE TABLE `material` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(11) DEFAULT '0',
  `user_id` int(11) DEFAULT '0',
  `course_id` int(11) DEFAULT '0',
  `task_id` int(11) DEFAULT '0',
  `filename` varchar(255) DEFAULT NULL,
  `size` double(10,2) DEFAULT '0.00',
  `path` varchar(255) DEFAULT NULL,
  `downs` int(11) DEFAULT '0',
  `time` varchar(255) DEFAULT NULL,
  `share` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "material"
#


#
# Structure for table "note"
#

DROP TABLE IF EXISTS `note`;
CREATE TABLE `note` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0',
  `course_id` int(11) DEFAULT '0',
  `task_id` int(11) DEFAULT '0',
  `content` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `share` int(11) DEFAULT '0',
  `flag` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "note"
#


#
# Structure for table "practice"
#

DROP TABLE IF EXISTS `practice`;
CREATE TABLE `practice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) DEFAULT '0',
  `task_id` int(11) DEFAULT '0',
  `type` int(11) DEFAULT '0',
  `difficulty` int(11) DEFAULT '0',
  `stem` varchar(255) DEFAULT NULL,
  `analysis` varchar(255) DEFAULT NULL,
  `score` float DEFAULT '0',
  `option_` varchar(55) DEFAULT '0',
  `time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "practice"
#


#
# Structure for table "practice_option"
#

DROP TABLE IF EXISTS `practice_option`;
CREATE TABLE `practice_option` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `practice_id` int(11) DEFAULT '0',
  `option_` int(11) DEFAULT '0',
  `right_` int(11) DEFAULT '0',
  `result` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "practice_option"
#


#
# Structure for table "practice_response"
#

DROP TABLE IF EXISTS `practice_response`;
CREATE TABLE `practice_response` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0',
  `practice_id` int(11) DEFAULT '0',
  `option_` varchar(55) DEFAULT '0',
  `result` varchar(255) DEFAULT NULL,
  `right_` int(11) DEFAULT '0',
  `time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "practice_response"
#


#
# Structure for table "sys_record"
#

DROP TABLE IF EXISTS `sys_record`;
CREATE TABLE `sys_record` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `views` bigint(20) DEFAULT NULL COMMENT '今日访问量',
  `date` date DEFAULT NULL COMMENT '日期',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统记录';

#
# Data for table "sys_record"
#


#
# Structure for table "task"
#

DROP TABLE IF EXISTS `task`;
CREATE TABLE `task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) DEFAULT '0',
  `type` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `zhang_id` int(11) DEFAULT '0',
  `jie_id` int(11) DEFAULT '0',
  `material_id` int(11) DEFAULT '0',
  `duration` int(11) DEFAULT '0',
  `goal` int(11) DEFAULT '0',
  `min_time` int(11) DEFAULT '0',
  `electives` int(11) DEFAULT '0',
  `time` varchar(55) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "task"
#


#
# Structure for table "test_paper"
#

DROP TABLE IF EXISTS `test_paper`;
CREATE TABLE `test_paper` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0',
  `course_id` int(11) DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `end_time` varchar(255) DEFAULT NULL,
  `folder` varchar(55) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `result` varchar(255) DEFAULT NULL,
  `downs` int(11) DEFAULT '0',
  `submits` int(11) DEFAULT '0',
  `time` varchar(255) DEFAULT NULL,
  `end` int(11) DEFAULT '0',
  `intro` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `path` (`path`(55))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "test_paper"
#


#
# Structure for table "user"
#

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(55) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `reg_time` varchar(255) DEFAULT NULL,
  `login_time` varchar(255) DEFAULT NULL,
  `role` int(11) DEFAULT '0',
  `icon` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `sex` int(11) DEFAULT '0',
  `intro` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `sign` varchar(255) DEFAULT NULL,
  `zero` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `tel` varchar(255) DEFAULT NULL,
  `audit` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `usernmae` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

#
# Data for table "user"
#

INSERT INTO `user` VALUES (1,'admin','462d8c3a6742ed50dbc96a80aab7ff32','2018-10-09 12:53:45','2019-03-20 16:14:57',3,'','超级管理员',0,'没有自我介绍~',NULL,NULL,NULL,NULL,NULL,1);

#
# Structure for table "user_focus"
#

DROP TABLE IF EXISTS `user_focus`;
CREATE TABLE `user_focus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0',
  `to_user_id` int(11) DEFAULT '0',
  `time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "user_focus"
#


#
# Structure for table "user_token"
#

DROP TABLE IF EXISTS `user_token`;
CREATE TABLE `user_token` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `token` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT '0',
  `create_time` varchar(255) DEFAULT NULL,
  `end_time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "user_token"
#