121 lines
3.8 KiB
MySQL
121 lines
3.8 KiB
MySQL
|
|
|||
|
|
/*<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>û<EFBFBD>*/
|
|||
|
|
create Role settle
|
|||
|
|
login encrypted password '123456' /* 'spok$!)@EN' */
|
|||
|
|
valid until '2035-12-31 23:59:59' ;
|
|||
|
|
|
|||
|
|
/*<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>*/
|
|||
|
|
CREATE DATABASE settledb
|
|||
|
|
WITH OWNER = settle
|
|||
|
|
ENCODING = 'UTF8'
|
|||
|
|
TABLESPACE = pg_default
|
|||
|
|
CONNECTION LIMIT = -1;
|
|||
|
|
|
|||
|
|
|
|||
|
|
/*<EFBFBD><EFBFBD>ģ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɡ<EFBFBD>
|
|||
|
|
<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ģ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ж<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>sql<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD>ģ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>varchar<EFBFBD>ij<EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
Ҫ<EFBFBD><EFBFBD><EFBFBD>ݲ<EFBFBD>ͬ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ģ<EFBFBD><EFBFBD>*/
|
|||
|
|
|
|||
|
|
/* <20><> <20>༶ͳ<E0BCB6><CDB3> definition */
|
|||
|
|
|
|||
|
|
drop table if exists ClassesStat ;
|
|||
|
|
|
|||
|
|
create table ClassesStat (
|
|||
|
|
classesId BigInt ,
|
|||
|
|
statDay Timestamp ,
|
|||
|
|
areaId Integer default 0,
|
|||
|
|
onlineAccount Integer default 0 ,
|
|||
|
|
onlineHowmuch Integer default 0 ,
|
|||
|
|
onlineYear Integer default 0 ,
|
|||
|
|
onlineAmount Integer default 0 ,
|
|||
|
|
onlineFee Integer default 0 ,
|
|||
|
|
cashAccount Integer default 0 ,
|
|||
|
|
cashHowmuch Integer default 0 ,
|
|||
|
|
cashMonth Integer default 0 ,
|
|||
|
|
cashAmount Integer default 0 ,
|
|||
|
|
cashFee Integer default 0 ,
|
|||
|
|
memo varchar( 1000 ) default '' ,
|
|||
|
|
primary key ( classesId , statDay ) ) ;
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
comment on table ClassesStat is '<EFBFBD>༶ͳ<EFBFBD><EFBFBD>' ;
|
|||
|
|
comment on column ClassesStat.classesId is '<EFBFBD>༶ID ';
|
|||
|
|
comment on column ClassesStat.statDay is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column ClassesStat.areaId is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column ClassesStat.onlineAccount is 'ƽ̨֧<EFBFBD><EFBFBD><EFBFBD>˺<EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column ClassesStat.onlineHowmuch is 'ƽ̨֧<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column ClassesStat.onlineYear is 'ƽ̨֧<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column ClassesStat.onlineAmount is 'ƽ̨<EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column ClassesStat.onlineFee is 'ƽ̨<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column ClassesStat.cashAccount is '<EFBFBD>ֽ<EFBFBD>֧<EFBFBD><EFBFBD><EFBFBD>˺<EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column ClassesStat.cashHowmuch is '<EFBFBD>ֽ<EFBFBD>֧<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column ClassesStat.cashMonth is '<EFBFBD>ֽ<EFBFBD>֧<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column ClassesStat.cashAmount is '<EFBFBD>ֽ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column ClassesStat.cashFee is '<EFBFBD>ֽ<EFBFBD>֧<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column ClassesStat.memo is '<EFBFBD><EFBFBD>ע';
|
|||
|
|
|
|||
|
|
|
|||
|
|
/* <20><> ѧ<><D1A7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳ<EFBFBD><CDB3> definition */
|
|||
|
|
|
|||
|
|
drop table if exists StudentStat ;
|
|||
|
|
|
|||
|
|
create table StudentStat (
|
|||
|
|
studentId BigInt ,
|
|||
|
|
statDay Timestamp ,
|
|||
|
|
areaId Integer ,
|
|||
|
|
onlineTime Integer ,
|
|||
|
|
studyTotalScore Integer ,
|
|||
|
|
studyCount Integer ,
|
|||
|
|
assignCount Integer ,
|
|||
|
|
examCount Integer ,
|
|||
|
|
goldencount Integer ,
|
|||
|
|
ispayed Integer ,
|
|||
|
|
amount Integer ,
|
|||
|
|
fee Integer ,
|
|||
|
|
primary key () ) ;
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
comment on table StudentStat is 'ѧ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳ<EFBFBD><EFBFBD>' ;
|
|||
|
|
comment on column StudentStat.studentId is 'ѧ<EFBFBD><EFBFBD>ID ';
|
|||
|
|
comment on column StudentStat.statDay is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column StudentStat.areaId is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID ';
|
|||
|
|
comment on column StudentStat.onlineTime is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column StudentStat.studyTotalScore is 'ѧϰ<EFBFBD>ܷ<EFBFBD> ';
|
|||
|
|
comment on column StudentStat.studyCount is 'ѧϰ<EFBFBD>ܴ<EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column StudentStat.assignCount is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column StudentStat.examCount is '<EFBFBD><EFBFBD><EFBFBD>ɿ<EFBFBD><EFBFBD>Դ<EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column StudentStat.goldencount is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column StudentStat.ispayed is '<EFBFBD>Ƿ<EFBFBD>֧<EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column StudentStat.amount is '֧<EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column StudentStat.fee is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
|
|||
|
|
|
|||
|
|
/* <20><> <20><>ʦ<EFBFBD><CAA6><EFBFBD><EFBFBD>ͳ<EFBFBD><CDB3> definition */
|
|||
|
|
|
|||
|
|
drop table if exists TeacherStat ;
|
|||
|
|
|
|||
|
|
create table TeacherStat (
|
|||
|
|
teacherId BigInt ,
|
|||
|
|
statDay Timestamp ,
|
|||
|
|
areaId Integer ,
|
|||
|
|
assignCount Integer ,
|
|||
|
|
assignDegree Integer ,
|
|||
|
|
messageCount Integer ,
|
|||
|
|
examCount Integer ,
|
|||
|
|
primary key () ) ;
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
comment on table TeacherStat is '<EFBFBD><EFBFBD>ʦ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳ<EFBFBD><EFBFBD>' ;
|
|||
|
|
comment on column TeacherStat.teacherId is '<EFBFBD><EFBFBD>ʦID ';
|
|||
|
|
comment on column TeacherStat.statDay is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column TeacherStat.areaId is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID ';
|
|||
|
|
comment on column TeacherStat.assignCount is '<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD>ô<EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column TeacherStat.assignDegree is 'ƽ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD>ɶ<EFBFBD> ';
|
|||
|
|
comment on column TeacherStat.messageCount is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
comment on column TeacherStat.examCount is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Դ<EFBFBD><EFBFBD><EFBFBD> ';
|
|||
|
|
|
|||
|
|
|
|||
|
|
|