eforum_mysql4.sql

学生选课系统 赶快来下载啊啊好东西 呵呵啊啊 啊啊啊啊啊

   CHANGE_AFTERGROUPID  int,
   CHANGE_STATUS        smallint not null,
   primary key (CHANGE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_USERGROUPCHANGE1 ON EF_USER_GROUP_CHANGE
(
   USER_ID
);

CREATE INDEX IDX_USERGROUPCHANGE2 ON EF_USER_GROUP_CHANGE
(
   CHANGE_DATETIME,
   CHANGE_STATUS
);

CREATE TABLE EF_USER_GROUP_CONFIG
(
   CONFIG_NAME          varchar(200) not null,
   GROUP_ID             int not null,
   CONFIG_CATEGORY      varchar(20) not null,
   CONFIG_VALUE         varchar(3500),
   primary key (CONFIG_NAME, GROUP_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_USER_MEDAL_LOGS
(
   LOG_ID               bigint not null,
   USER_ID              varchar(20) not null,
   MEDAL_ID             int not null,
   LOG_CONFERUSER       varchar(20) not null,
   LOG_CONFERTIME       bigint not null,
   LOG_CONFERREASON     varchar(400),
   LOG_RECALLUSER       varchar(20),
   LOG_RECALTIME        bigint,
   LOG_RECALLREASON     varchar(400),
   LOG_STATUS           smallint not null,
   primary key (LOG_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_USERMEDALLOGS1 ON EF_USER_MEDAL_LOGS
(
   USER_ID
);

CREATE TABLE EF_USER_POST_TAGS
(
   TAG_ID               bigint not null,
   POST_ID              bigint not null,
   USER_ID              varchar(20) not null,
   primary key (TAG_ID, POST_ID, USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_USER_RECOMMED
(
   USER_ID              varchar(20) not null,
   RECOMM_USERID        varchar(20) not null,
   RECOMM_TIME          bigint not null,
   RECOMM_ORDER         int not null default 0,
   primary key (USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_USER_TAGS
(
   TAG_ID               bigint not null,
   USER_ID              varchar(20) not null,
   TAG_NAME             varchar(100) not null,
   TAG_VIEWNUM          int not null,
   TAG_TOPICS           int not null,
   TAG_CREATETIME       bigint not null,
   TAG_UPDATETIME       bigint not null,
   primary key (TAG_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_USERTAGS1 ON EF_USER_TAGS
(
   USER_ID,
   TAG_NAME
);

CREATE TABLE EF_VISITORS
(
   VISITOR_USER         varchar(20) not null,
   USER_ID              varchar(20) not null,
   VISITOR_FIRSTTIME    bigint not null,
   VISITOR_LASTTIME     bigint not null,
   primary key (VISITOR_USER, USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_VOTE_LOGS
(
   USER_ID              varchar(20) not null,
   OPTION_ID            bigint not null,
   LOG_VOTETIME         bigint not null,
   primary key (USER_ID, OPTION_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_VOTE_OPTIONS
(
   OPTION_ID            bigint not null,
   POST_ID              bigint not null,
   OPTION_VALUE         varchar(200) not null,
   OPTION_SHOWORDER     int not null default 0,
   OPTION_VOTES         int not null default 0,
   primary key (OPTION_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_VOTEOPTIONS1 ON EF_VOTE_OPTIONS
(
   POST_ID,
   OPTION_SHOWORDER
);

CREATE TABLE OSC_USERS
(
   USER_ID              varchar(20) not null,
   USER_PASSWD          varchar(40) not null,
   USER_QUESTION        smallint not null,
   USER_ANSWER          varchar(50),
   USER_EMAIL           varchar(200),
   USER_STATUS          smallint not null,
   primary key (USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_OUSERS1 ON OSC_USERS
(
   USER_EMAIL
);


/*==============================================================*/
/* Table: EPOD TABLE DROPS                                      */
/*==============================================================*/
DROP TABLE IF EXISTS EPOD_ACTION;
DROP TABLE IF EXISTS EPOD_CHART;
DROP TABLE IF EXISTS EPOD_CHART_DETAIL;
DROP TABLE IF EXISTS EPOD_COMMON_ACTION;
DROP TABLE IF EXISTS EPOD_CONSTANT;
DROP TABLE IF EXISTS EPOD_DATA_AUTH;
DROP TABLE IF EXISTS EPOD_ELEMENT;
DROP TABLE IF EXISTS EPOD_FIELD;
DROP TABLE IF EXISTS EPOD_FILE_UPLOAD;
DROP TABLE IF EXISTS EPOD_INDEX;
DROP TABLE IF EXISTS EPOD_LIST;
DROP TABLE IF EXISTS EPOD_LIST_DETAIL;
DROP TABLE IF EXISTS EPOD_LOG;
DROP TABLE IF EXISTS EPOD_MAXID;
DROP TABLE IF EXISTS EPOD_MENU;
DROP TABLE IF EXISTS EPOD_MODULE;
DROP TABLE IF EXISTS EPOD_ORGANIZATION;
DROP TABLE IF EXISTS EPOD_RESOURCE;
DROP TABLE IF EXISTS EPOD_ROLE;
DROP TABLE IF EXISTS EPOD_ROLE_DATA_AUTH;
DROP TABLE IF EXISTS EPOD_ROLE_RESOURCE_AUTH;
DROP TABLE IF EXISTS EPOD_SQL;
DROP TABLE IF EXISTS EPOD_TABLE;
DROP TABLE IF EXISTS EPOD_UNIT;
DROP TABLE IF EXISTS EPOD_UPLOAD_CONFIG;
DROP TABLE IF EXISTS EPOD_USER;
DROP TABLE IF EXISTS EPOD_USER_ROLE;
DROP TABLE IF EXISTS EPOD_VIEW;
DROP TABLE IF EXISTS EPOD_VIEW_DETAIL;
/*==============================================================*/
/* Table: EPOD_ACTION                                           */
/*==============================================================*/
CREATE TABLE EPOD_ACTION
(
   EACTIONID            varchar(50) not null,
   EUNITID              varchar(50) not null,
   ENAME                varchar(50) default NULL,
   EACTION              varchar(500),
   EPROXY               varchar(200) default NULL,
   EPROCESSOR           varchar(200) default NULL,
   ESUCCESS             varchar(500),
   EFAILURE             varchar(500),
   EONCLICK             varchar(20) default NULL,
   ESHORTCUT            varchar(20) default NULL,
   ETITLE               varchar(50) default NULL,
   ECSS                 varchar(50) default NULL,
   EATTRIBUTE           varchar(500),
   ETABINDEX            int default NULL,
   ESHOWMODE            varchar(300),
   EORDER               int default NULL,
   ESTATUS              int default NULL,
   EREMARK              varchar(200) default NULL,
   primary key (EACTIONID, EUNITID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*==============================================================*/
/* Table: EPOD_CHART                                            */
/*==============================================================*/
CREATE TABLE EPOD_CHART
(
   ECHARTID             varchar(60) not null,
   ETITLENAME           varchar(100) not null,
   ETYPE                int not null,
   EDATATYPE            int not null,
   EDATAVALUE           varchar(2500) not null,
   EDATAROWTYPE         int not null,
   EDATAROWVALUE        varchar(500) not null,
   EDATACOLTYPE         int not null,
   EDATACOLVALUE        varchar(500) not null,
   EDATASETTYPE         int not null,
   primary key (ECHARTID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*==============================================================*/
/* Table: EPOD_CHART_DETAIL                                     */
/*==============================================================*/
CREATE TABLE EPOD_CHART_DETAIL
(
   ECHARTID             varchar(60) not null,
   ELEGENDVISIBLE       int default NULL,
   ELEGENDBGCOLOR       varchar(60) default NULL,
   ELEGENDITEMFONT      varchar(40) default NULL,
   ELEGENDITEMCOLOR     varchar(60) default NULL,
   ELEGENDOUTLINECOLOR  varchar(60) default NULL,
   ELEGENDGRAPHICEDGE   int default NULL,
   ELEGENDGRAPHICPOS    int default NULL,
   ELEGENDPOSITION      int default NULL,
   ELEGENDHALIGN        int default NULL,
   ELEGENDVALIGN        int default NULL,
   ETITLEFONT           varchar(50) default NULL,
   ETITLEFGCOLOR        varchar(60) default NULL,
   ETITLEBGCOLOR        varchar(60) default NULL,
   ETITLEHORIZONTAL     int default NULL,
   ETITLEVERTICAL       int default NULL,
   ETITLEPOSITION       int default NULL,
   EBORDERVISIBLE       int default NULL,
   EBORDERBGCOLOR       varchar(60) default NULL,
   EANTIALIAS           int default NULL,
   EBGCOLOR             varchar(60) default NULL,
   ECATEGORYCOLORS      varchar(500),
   EPLOTBGCOLOR         varchar(60) default NULL,
   EOUTLINECOLOR        varchar(60) default NULL,
   ELABELBGCOLOR        varchar(60) default NULL,
   ELABELFONT           varchar(40) default NULL,
   ELABELOUTLINECOLOR   varchar(60) default NULL,
   ELABELCOLOR          varchar(60) default NULL,
   ELABELSHADOWCOLOR    varchar(60) default NULL,
   EDEPTH               decimal(18,2) default NULL,
   EPIECIRCULAR         int default NULL,
   EPIELINKMARGIN       decimal(18,2) default NULL,
   EPIELINKCOLOR        varchar(60) default NULL,
   EPIEOUTLINECOLOR     varchar(60) default NULL,
   EPIESHADOWCOLOR      varchar(60) default NULL,
   EPIESHADOWX          decimal(18,2) default NULL,
   EPIESHADOWY          decimal(18,2) default NULL,
   EPIEANGLE            decimal(18,2) default NULL,
   EPIEDIRECTION        int default NULL,
   EPIEEXPLODESECTION   int default NULL,
   EPLOTEXPLODEPERCENT  decimal(18,2) default NULL,
   ECATEGORYAXISNAME    varchar(60) default NULL,
   EVALUEAXISNAME       varchar(60) default NULL,
   EDOMAINVISIBLE       int default NULL,
   EDOMAINCOLOR         varchar(60) default NULL,
   EDOMAINPOSITION      int default NULL,
   EDOMAINAXISLOCATION  int default NULL,
   ERANGEVISIBLE        int default NULL,
   ERANGECOLOR          varchar(60) default NULL,
   ERANGEAXISLOCATION   int default NULL,
   EORIENTATION         int default NULL,
   EAXISOFFSET          decimal(18,2) default NULL,
   EAXISCOLOR           varchar(60) default NULL,
   EAXISARROWVISIBLE    int default NULL,
   EAXISLABELPOSITION   decimal(18,2) default NULL,
   EFOREGROUNDALPHA     decimal(18,2) default NULL,
   EBACKGROUNDALPHA     decimal(18,2) default NULL,
   primary key (ECHARTID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*==============================================================*/
/* Table: EPOD_COMMON_ACTION                                    */
/*==============================================================*/
CREATE TABLE EPOD_COMMON_ACTION
(
   EACTIONID            varchar(50) not null,
   ENAME                varchar(50) default NULL,
   EACTION              varchar(200) default NULL,
   EPROXY               varchar(200) default NULL,
   EPROCESSOR           varchar(200) default NULL,
   ESUCCESS             varchar(200) default NULL,
   EFAILURE             varchar(200) default NULL,
   EONCLICK             varchar(20) default NULL,
   ESHORTCUT            varchar(20) default NULL,
   ETITLE               varchar(50) default NULL,
   ECSS                 varchar(50) default NULL,
   EATTRIBUTE           varchar(500),
   ETABINDEX            int default NULL,
   ESHOWMODE            varchar(300),
   EORDER               int default NULL,
   ESTATUS              int default NULL,
   EREMARK              varchar(200) default NULL,
   primary key (EACTIONID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*==============================================================*/
/* Table: EPOD_CONSTANT                                         */
/*==============================================================*/
CREATE TABLE EPOD_CONSTANT
(
   ECONSTANTID          varchar(50) not null,
   ETYPE                int default NULL,
   ENAME                varchar(50) default NULL,
   EVALUE               varchar(1000),
   EREMARK              varchar(200) default NULL,
   ESYSTYPE             int default NULL,
   primary key (ECONSTANTID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*==============================================================*/
/* Table: EPOD_DATA_AUTH                                        */
/*==============================================================*/
CREATE TABLE EPOD_DATA_AUTH
(
   EDATAAUTHID          varchar(100) not null,
   EMENUID              varchar(50) default NULL,
   ENAME                varchar(100) default NULL,
   EDATAAUTH            varchar(500),
   EVIEWID              varchar(100) default NULL,
   EUNITID              varchar(100) default NULL,
   REMARK               varchar(100) default NULL,
   primary key (EDATAAUTHID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*==============================================================*/
/* Table: EPOD_ELEMENT                                          */
/*==============================================================*/
CREATE TABLE EPOD_ELEMENT
(
   EELEMENTID           varchar(50) not null,
   EUNITID              varchar(50) not null,
   ETYPE                int not null,
   ENAME                varchar(50) default NULL,
   ELINK                varchar(200) default NULL,
   ETITLE               varchar(100) default NULL,
   EDEFAULTVALUE        varchar(100) default NULL,
   EHEAD                varchar(300),
   ETAIL                varchar(300),
   EDATASOURCE          varchar(500),
   EATTRIBUTE           varchar(500),
   ETABINDEX            int default NULL,
   ECSS                 varchar(50) default NULL,
   EQUERYMODE           int default NULL,
   ESHOWMODE            varchar(300),
   ETOTALRULE           varchar(200) default NULL,
   EDATATYPE            int default NULL,
   EISNULL              int default NULL,
   ELENGTH              int default NULL,
   EWIDTH               int default NULL,
   EHEIGHT              int default NULL,
   EGROUP               varchar(50) default NULL,
   EROWSPAN             int default NULL,
   ECOLSPAN             int default NULL,
   EORDER               int default NULL,
   ESTATUS              int default NULL,
   EALIGN               int default NULL,
   ETDWIDTH             int default NULL,
   ETDWIDTHMODE         int default NULL,
   ETDHEIGHT            int default NULL,
   ETDHEIGHTMODE        int default NULL,
   ETDCSS               varchar(50) default NULL,
   ETDATTRIBUTE         varchar(100) default NULL,
   EDATASOURCETYPE      int default NULL,
   EEXCEL               int default NULL,
   ESYSTYPE             int default NULL,
   EUPLOADNUMBER        int default NULL,
   primary key (EELEMENTID, EUNITID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*==============================================================*/
/* Table: EPOD_FIELD                                            */
/*==============================================================*/
CREATE TABLE EPOD_FIELD
(
   EFIELDNAME           varchar(50) not null,
   ETABLENAME           varchar(50) not null,
   ENAME                varchar(50) default NULL,
   ETYPE                int default NULL,
   EISKEY               int default NULL,
   EISNULL              int default NULL,
   ESIZE                int default NULL,
   EORDER               int default NULL,
   primary key (EFIELDNAME, ETABLENAME)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*==============================================================*/
/* Table: EPOD_FILE_UPLOAD                                      */
/*==============================================================*/
CREATE TABLE EPOD_FILE_UPLOAD
(
   EID                  varchar(50) not null,
   ETABLENAME           varchar(50) not null,
   EFIELD               varchar(50) not null,
   EKEY                 varchar(200) default NULL,
   ECREATEDATE          timestamp not null,
   ECREATOR             varchar(50) default NULL,
   EFILENAME            varchar(200) not null,
   EFILEPATH            varchar(300) not null,
   EFILESIZE            int default NULL,
   primary key (EID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*==============================================================*/
/* Table: EPOD_INDEX                                            */
/*==============================================================*/
CREATE TABLE EPOD_INDEX
(
   EID                  int not null,
   ENAME                varchar(100) default NULL,
   EORDER               int default NULL,
   EDATASOURCE          varchar(2000),
   EITEM                varchar(200) default NULL,
   ELINK                varchar(200) default NULL,
   EHASAUTH             varchar(2) default NULL,
   EAUTHUNIT            varchar(150) default NULL,
   EDESCR               varchar(800),
   primary key (EID)
) ENGINE