set character_set_database=utf8;

set character_set_connection=utf8;

set character_set_client=gbk;

set character_set_results=gbk;

set character_set_server=utf8;

set character_set_system=utf8;

set character_set_filesystem=binary;

--建数据库

create database prjectdb;

use prjectdb;

--建课程表

create table prjects(

prjectid int(32) primary key AUTO_INCREMENT,

prjectname varchar(50),

prjecttype varchar(50),

prjectbook varchar(50),

prjectbookface varchar(50),

prjectauthor varchar(50),

prjectdatil varchar(50)

);

--建章节表

create table chapters(

chapterid int(32) primary key AUTO_INCREMENT,

prjectid int(32),

chapterNo int(32),

chaptertitle varchar(50),

chapterSummary varchar(50),

chapterdatil varchar(50)

);

--建知识点表

create table knowledgePoints(

knowledgePointsid int(32) primary key AUTO_INCREMENT,

chapterid int(32),

knowledgePointsNo int(32),

knowledgePointstitle varchar(50),

knowledgePointsSummary varchar(50),

knowledgePointsVideoURL varchar(50)

);

--建管理员表

create table managers(

managerid int(32) primary key AUTO_INCREMENT,

managername varchar(50),

managerpassword varchar(50)

);