eforum_mysql5.sql

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

CREATE INDEX IDX_ATTACH3 ON EF_ATTACH
(
   ATTACH_ROOTPOSTID
);

CREATE INDEX IDX_ATTACH4 ON EF_ATTACH
(
   FORUM_ID
);

CREATE TABLE EF_ATTACH_ALLOW
(
   ATTACH_SUFFIX        varchar(50) not null,
   ATTACH_SIZE          int not null,
   ATTACH_TYPE          smallint not null,
   ATTACH_DEFAULT       varchar(200),
   primary key (ATTACH_SUFFIX)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_CODES
(
   CODE_KEY             varchar(40) not null,
   CATEGORY_KEY         varchar(40) not null,
   CODE_NAME            varchar(200) not null,
   CODE_STATUS          smallint not null,
   CODE_ORDER           int not null,
   primary key (CODE_KEY, CATEGORY_KEY)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_CODE_CATEGORY
(
   CATEGORY_KEY         varchar(40) not null,
   CATEGORY_NAME        varchar(200) not null,
   CATEGORY_LEVEL       smallint not null default 0,
   primary key (CATEGORY_KEY)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_CONFIG
(
   CONFIG_NAME          varchar(150) not null,
   CONFIG_CATEGORY      varchar(20) not null,
   CONFIG_VALUE         varchar(2000),
   primary key (CONFIG_NAME, CONFIG_CATEGORY)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_CREDIT_ADMIN_REWARDS
(
   CREDIT_KEY           varchar(25) not null,
   GROUP_ID             int not null,
   CREDIT_AMAX          int not null,
   CREDIT_AMIN          int not null,
   CREDIT_DMAX          int not null,
   CREDIT_STEP          int not null,
   primary key (CREDIT_KEY, GROUP_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_CREDIT_CONFIG
(
   CREDIT_KEY           varchar(25) not null,
   CREDIT_NAME          varchar(40) not null,
   CREDIT_SHOWORDER     int not null,
   CREDIT_UNIT          varchar(10),
   CREDIT_REGINIT       int not null,
   CREDIT_VISIBLE       smallint not null,
   CREDIT_RATE          decimal(18,2),
   CREDIT_POLICYLIMIT   int not null,
   CREDIT_STATUS        smallint not null,
   primary key (CREDIT_KEY)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_CREDIT_POLICY
(
   POLICY_KEY           varchar(40) not null,
   CREDIT_KEY           varchar(25) not null,
   POLICY_SCORE         int not null,
   POLICY_STATUS        smallint not null,
   primary key (POLICY_KEY, CREDIT_KEY)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_DAY_STAT
(
   STAT_DAY             date not null,
   STAT_TOPICS          int not null,
   STAT_POSTS           int not null,
   STAT_ATTACHES        int not null,
   STAT_REGUSERS        int not null,
   primary key (STAT_DAY)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_FACE
(
   FACE_ID              int not null,
   FACE_NAME            varchar(30) not null,
   FACE_FILE            varchar(200) not null,
   FACE_ORDER           int not null,
   FACE_STATUS          smallint not null,
   primary key (FACE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_FAILLOGINS
(
   IP_IP                varchar(30) not null,
   IP_COUNT             int,
   IP_LASTUPDATE        bigint not null,
   primary key (IP_IP)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_FORUMLINKS
(
   LINK_ID              int not null,
   LINK_NAME            varchar(50) not null,
   LINK_README          varchar(400),
   LINK_URL             varchar(250),
   LINK_LOGO            varchar(250),
   LINK_ISLOGO          smallint not null,
   LINK_ORDER           int not null,
   primary key (LINK_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_FORUMLINKS1 ON EF_FORUMLINKS
(
   LINK_ORDER
);

CREATE TABLE EF_FORUMS
(
   FORUM_ID             int not null,
   FORUM_NAME           varchar(50) not null,
   FORUM_TYPE           smallint not null,
   FORUM_PARENT         int not null,
   FORUM_ROOT           int not null,
   FORUM_SHOWORDER      int not null,
   FORUM_ISHIDE         smallint not null,
   FORUM_STYLEID        int not null,
   FORUM_TOPICS         int not null,
   FORUM_POSTS          int not null,
   FORUM_ATTACHES       int not null,
   FORUM_LASTPOSTTIME   bigint,
   FORUM_LASTPOSTINFO   varchar(400),
   FORUM_LASTTOPICTIME  bigint,
   FORUM_LASTTOPICINFO  varchar(400),
   FORUM_ICON           varchar(200),
   FORUM_STATUS         smallint not null,
   FORUM_CREATETIME     bigint,
   FORUM_CHILDNUM       int not null,
   FORUM_LEFT           int not null,
   FORUM_RIGHT          int not null,
   FORUM_LEVEL          int not null,
   primary key (FORUM_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_FORUMS1 ON EF_FORUMS
(
   FORUM_ROOT
);

CREATE INDEX IDX_FORUMS2 ON EF_FORUMS
(
   FORUM_TYPE
);

CREATE TABLE EF_FORUM_CREDIT_POLICY
(
   POLICY_KEY           varchar(40) not null,
   FORUM_ID             int not null,
   CREDIT_KEY           varchar(25) not null,
   POLICY_SCORE         int not null,
   POLICY_STATUS        smallint not null,
   primary key (POLICY_KEY, FORUM_ID, CREDIT_KEY)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_FORUM_DAY
(
   DAY_DATE             date not null,
   FORUM_ID             int not null,
   DAY_TOPICS           int not null,
   DAY_ATTACHES         int not null,
   DAY_POSTS            int not null,
   primary key (DAY_DATE, FORUM_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_FORUM_FAVOR
(
   USER_ID              varchar(20) not null,
   FORUM_ID             int not null,
   FAVOR_CREATETIME     bigint not null,
   primary key (USER_ID, FORUM_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_FORUM_OTHER_CONFIG
(
   OFORUM_KEY           varchar(50) not null,
   FORUM_ID             int not null,
   OFORUM_VALUE         varchar(3000),
   primary key (OFORUM_KEY, FORUM_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_FORUM_OWNER
(
   USER_ID              varchar(20) not null,
   FORUM_ID             int not null,
   OWNER_ORDER          int not null default 0,
   primary key (USER_ID, FORUM_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_FORUM_SMILES
(
   SMILE_ID             int not null,
   SMILE_NAME           varchar(50),
   SMILE_FILE           varchar(250) not null,
   SMILE_SYMBOL         varchar(50),
   SMILE_ORDER          int not null,
   primary key (SMILE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_FORUM_TAGS
(
   TAG_ID               bigint not null,
   FORUM_ID             int 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_FORUMTAGS1 ON EF_FORUM_TAGS
(
   FORUM_ID,
   TAG_NAME
);

CREATE TABLE EF_FORUM_TOPIC_TAGS
(
   POST_ID              bigint not null,
   TAG_ID               bigint not null,
   primary key (POST_ID, TAG_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_FRIENDS
(
   FRIEND_ID            bigint not null,
   USER_ID              varchar(20) not null,
   FRIEND_USER          varchar(20),
   FRIEND_TAGS          varchar(200),
   FRIEND_TYPE          smallint not null,
   FRIEND_MEMO          varchar(500),
   FRIEND_CREATETIME    bigint not null,
   primary key (FRIEND_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_FRIENDS1 ON EF_FRIENDS
(
   USER_ID,
   FRIEND_TYPE
);

CREATE TABLE EF_FRIEND_TAGS
(
   TAG_ID               bigint not null,
   USER_ID              varchar(20) not null,
   TAG_NAME             varchar(100) not null,
   TAG_NUMBER           int not null,
   primary key (TAG_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_FRIENDTAGS1 ON EF_FRIEND_TAGS
(
   USER_ID,
   TAG_NAME
);

CREATE INDEX IDX_FRIENDTAGS2 ON EF_FRIEND_TAGS
(
   USER_ID,
   TAG_NUMBER
);

CREATE TABLE EF_FRIEND_TAGS_REL
(
   TAG_ID               bigint not null,
   FRIEND_ID            bigint not null,
   primary key (TAG_ID, FRIEND_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_GROUP_FORUM_AUTH
(
   AUTH_KEY             varchar(40) not null,
   GROUP_ID             int not null,
   FORUM_ID             int not null,
   AUTH_VALUE           varchar(250) not null,
   primary key (AUTH_KEY, GROUP_ID, FORUM_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_IP_BANNED
(
   IP_ID                int not null,
   IP_BANNED            varchar(30) not null,
   IP_OPERATOR          varchar(40),
   IP_BANTIME           bigint not null,
   IP_EXPIRATION        bigint,
   IP_STOPTIME          bigint,
   IP_STATUS            smallint not null,
   primary key (IP_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_LEAVEWORD
(
   LEAVEWORD_ID         bigint not null,
   USER_ID              varchar(20) not null,
   FROM_USER            varchar(20) not null,
   LEAVEWORD_CONTENT    text not null,
   LEAVEWORD_ISPRIVATE  smallint not null,
   LEAVEWORD_CREATETIME bigint not null,
   primary key (LEAVEWORD_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_LEAVEWORD1 ON EF_LEAVEWORD
(
   USER_ID,
   LEAVEWORD_CREATETIME
);

CREATE TABLE EF_MEDALS
(
   MEDAL_ID             int not null,
   MEDAL_NAME           varchar(40) not null,
   MEDAL_ICON           varchar(200) not null,
   MEDAL_STATUS         smallint not null,
   primary key (MEDAL_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_MESSAGE_IMPEACH
(
   IMPE_ID              bigint not null,
   USER_ID              varchar(20),
   IMPE_USER            varchar(20) not null,
   IMPE_TITLE           varchar(400) not null,
   IMPE_CONTENT         text,
   IMPE_TIME            bigint not null,
   primary key (IMPE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_MESSAGEIMPEACH1 ON EF_MESSAGE_IMPEACH
(
   USER_ID,
   IMPE_TIME
);

CREATE INDEX IDX_MESSAGEIMPEACH2 ON EF_MESSAGE_IMPEACH
(
   IMPE_USER,
   IMPE_TIME
);

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

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

CREATE TABLE EF_NOTIFY
(
   NOTIFY_KEY           varchar(20) not null,
   NOTIFY_DESCR         varchar(400) not null,
   NOTIFY_TYPE          smallint not null,
   NOTIFY_TITLE         varchar(200) not null,
   NOTIFY_CONTENT       text not null,
   NOTIFY_HELPINFO      varchar(500) not null,
   primary key (NOTIFY_KEY)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_ONLINEUSER
(
   SESSION_ID           varchar(50) not null,
   USER_ID              varchar(20),
   SESSION_IP           varchar(20) not null,
   SESSION_SYSTEM       varchar(30),
   SESSION_BROWSER      varchar(30),
   SESSION_CUROPE       varchar(50),
   FORUM_ID             varchar(20),
   SESSION_POSTID       bigint,
   SESSION_ISHIDE       smallint not null,
   SESSION_LOGINTIME    bigint not null,
   SESSION_LASTACTIVITY bigint,
   primary key (SESSION_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_ONLINEUSER1 ON EF_ONLINEUSER
(
   USER_ID
);

CREATE INDEX IDX_ONLINEUSER2 ON EF_ONLINEUSER
(
   FORUM_ID
);

CREATE TABLE EF_PAGE_ITEM
(
   ITEM_KEY             varchar(40) not null,
   ITEM_TYPE            varchar(30) not null,
   ITEM_NAME            varchar(200) not null,
   ITEM_RSS             varchar(250),
   ITEM_STATUS          smallint not null,
   primary key (ITEM_KEY)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_PLACARD