eforum_mysql4.sql

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

(
   PLACARD_ID           int not null,
   USER_ID              varchar(20) not null,
   PLACARD_TITLE        varchar(200) not null,
   PLACARD_TYPE         smallint not null,
   PLACARD_CONTENT      text not null,
   PLACARD_SHOWORDER    int not null,
   PLACARD_CREATETIME   bigint not null,
   PLACARD_STARTTIME    bigint not null,
   PLACARD_ENDTIME      bigint,
   primary key (PLACARD_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_PORTAL_FORUMTOPIC
(
   FORUMTOPIC_ID        bigint not null,
   FORUM_ID             int,
   POST_ID              bigint,
   USER_ID              varchar(20),
   POST_TIME            bigint,
   POST_TITLE           varchar(200),
   POST_CONTENT         longtext,
   POST_HIGHLIGHT       varchar(100),
   POST_ORDER           int not null default 0,
   ISONLINE             smallint not null default 1,
   ISTOP                smallint not null default 1,
   URL                  varchar(100),
   IMAGE                varchar(200),
   POST_TYPE            smallint not null default 0,
   SUBJECT              varchar(100),
   primary key (FORUMTOPIC_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_POSTS
(
   POST_ID              bigint not null,
   TOPIC_ID             bigint not null,
   FORUM_ID             int not null,
   USER_ID              varchar(20) not null,
   POST_TIME            bigint not null,
   POST_IP              varchar(20),
   POST_TITLE           varchar(300),
   POST_CONTENT         longtext,
   POST_TYPE            smallint not null default 0,
   POST_UBBFLAG         smallint not null default 0,
   POST_HTMLFLAG        smallint not null default 1,
   POST_URLFLAG         smallint not null default 0,
   POST_ISHIDE          smallint not null default 1,
   POST_SIGNFLAG        smallint not null default 1,
   POST_ATTACHTYPE      smallint not null default 0,
   POST_LEFT            int,
   POST_RIGHT           int,
   POST_PARENT          bigint,
   POST_FLOOR           int,
   POST_AUDIT           smallint not null default 0,
   POST_BANNED          smallint not null default 1,
   POST_DELETED         smallint not null default 0,
   POST_RATEFLAG        smallint not null default 1,
   POST_IMPEACH         smallint not null default 0,
   primary key (POST_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_POSTS1 ON EF_POSTS
(
   TOPIC_ID,
   POST_FLOOR
);

CREATE INDEX IDX_POSTS2 ON EF_POSTS
(
   USER_ID
);

CREATE INDEX IDX_POSTS3 ON EF_POSTS
(
   FORUM_ID
);

CREATE TABLE EF_POST_ACTIVITIES
(
   POST_ID              bigint not null,
   ACITIVE_BEGINTIME    bigint not null,
   ACITIVE_ENDTIME      bigint not null,
   ACTIVE_CITY          varchar(200),
   ACTIVE_POSTION       varchar(400) not null,
   ACTIVE_EXPIRATION    bigint not null,
   ACTIVE_EXPIRATIONINFO varchar(20),
   ACTIVE_EXPIRATIONTYPE smallint not null,
   ACTIVE_COST          varchar(40),
   ACTIVE_MAXNUM        int,
   ACTIVE_MINATTEND     varchar(40),
   ACTIVE_GENDER        smallint,
   ACTIVE_NEEDEXTCREDIT varchar(200),
   ACTIVE_LINKDEFAULT   varchar(400),
   ACTIVE_BUYDEFAULT    varchar(400),
   ACTIVE_OPEN          smallint not null,
   ACTIVE_ISAUDIT       smallint not null,
   ACTIVE_AUDITNUM      int not null default 0,
   ACTIVE_ENTERNUM      int not null default 0,
   ACTIVE_INFO          varchar(400),
   primary key (POST_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_POST_ARGUE
(
   POST_ID              bigint not null,
   ARGUE_EXPIRATIONTYPE smallint not null,
   ARGUE_EXPIRATIONINFO varchar(20),
   ARGUE_EXPIRATION     bigint not null,
   ARGUE_SQUAREVIEWPOINT text not null,
   ARGUE_OPOSEVIEWPOINT text not null,
   ARGUE_THIRDVIEWPOINT text,
   ARGUE_ALLOWTHIRDPOINT smallint not null,
   ARGUE_SQUAREVOTE     int not null default 0,
   ARGUE_SQUAREENTER    int not null default 0,
   ARGUE_OPOSEVOTE      int not null default 0,
   ARGUE_OPOSEENTER     int not null default 0,
   ARGUE_THIRDVOTE      int not null default 0,
   ARGUE_THIRDENTER     int not null default 0,
   primary key (POST_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_POST_ARGUE_INFO
(
   POST_ID              bigint not null,
   TOPIC_ID             bigint not null,
   ARGUE_TYPE           smallint not null,
   ARGUE_DIGNUM         int not null default 0,
   ARGUE_COMMENTNUM     int not null default 0,
   ARGUE_ISPOINT        smallint not null default 0,
   primary key (POST_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_POSTARGUEINFO1 ON EF_POST_ARGUE_INFO
(
   TOPIC_ID,
   ARGUE_TYPE
);

CREATE TABLE EF_POST_IMPEACH
(
   POST_ID              bigint not null,
   USER_ID              varchar(20) not null,
   IMPEACH_REASON       varchar(400) not null,
   IMPEACH_TIME         bigint not null,
   primary key (POST_ID, USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_POST_RATELOGS
(
   RATE_ID              bigint not null,
   POST_ID              bigint not null,
   POST_USERID          varchar(20) not null,
   RATE_ADMINUSER       varchar(20) not null,
   RATE_FIELD           varchar(40) not null,
   RATE_SCORE           int not null,
   RATE_TIME            bigint not null,
   RATE_REMARK          varchar(400),
   primary key (RATE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_POSTRATELOGS1 ON EF_POST_RATELOGS
(
   POST_ID,
   RATE_TIME
);

CREATE TABLE EF_POST_REWARD
(
   POST_ID              bigint not null,
   REWARD_USER          varchar(20) not null,
   REWARD_POSTID        bigint,
   REWARD_EXPIRATIONTYPE smallint not null,
   REWARD_EXPIRATIONINFO varchar(20),
   REWARD_EXPIRATION    bigint,
   REWARD_HITUSER       varchar(20),
   REWARD_AMOUNT        int not null,
   REWARD_COST          int,
   REWARD_TIME          bigint,
   primary key (POST_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_POSTREWARD1 ON EF_POST_REWARD
(
   REWARD_USER
);

CREATE INDEX IDX_POSTREWARD2 ON EF_POST_REWARD
(
   REWARD_USER
);

CREATE TABLE EF_POST_SCORE
(
   POST_ID              bigint not null,
   USER_ID              varchar(20) not null,
   POST_SCORE           int not null,
   POST_SCORETIME       bigint,
   primary key (POST_ID, USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_POST_VOTE
(
   POST_ID              bigint not null,
   VOTE_EXPIRATIONTYPE  smallint not null default 0,
   VOTE_EXPIRATIONINFO  varchar(20) not null,
   VOTE_EXPIRATION      bigint not null,
   VOTE_MULTIPLE        smallint not null default 0,
   VOTE_MAXCHOICES      int not null default 0,
   VOTE_SHOWOPTION      smallint not null default 0,
   VOTE_NEEDEXTCREDIT   varchar(200),
   VOTE_VISIBLE         smallint not null default 0,
   VOTE_VOTES           int not null default 0,
   VOTE_POSTUSERS       int not null default 0,
   primary key (POST_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_RANKS
(
   RANK_ID              int not null,
   RANK_NAME            varchar(50) not null,
   RANK_STARS           int not null default 0,
   RANK_POSTS           int not null default 0,
   RANK_COLOR           varchar(10),
   primary key (RANK_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_RECVMAIL
(
   RECV_ID              bigint not null,
   USER_ID              varchar(20) not null,
   RECV_SENDER          varchar(20) not null,
   RECV_TITLE           varchar(400) not null,
   RECV_CONTENT         longtext not null,
   RECV_ISNEW           smallint not null,
   RECV_SENDTIME        bigint,
   RECV_ISREPLIED       smallint not null,
   RECV_ISCLASSIFIED    smallint not null,
   RECV_ISGARBAGE       smallint not null,
   RECV_TYPE            smallint,
   RECV_IMPEACHED       smallint default 1,
   primary key (RECV_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_RECVMAIL1 ON EF_RECVMAIL
(
   USER_ID,
   RECV_ISCLASSIFIED,
   RECV_ISGARBAGE,
   RECV_TYPE,
   RECV_SENDTIME
);

CREATE TABLE EF_REGION
(
   REGION_ID            int not null,
   PARENT_ID            int,
   REGION_NAME          varchar(200) not null,
   REGION_TYPE          smallint not null,
   REGION_ORDER         int,
   primary key (REGION_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_SCHEDULE_SET
(
   SCHEDULE_ID          int not null,
   SCHEDULE_NAME        varchar(60) not null,
   SCHEDULE_DESCR       varchar(500),
   SCHEDULE_CLASSNAME   varchar(150) not null,
   SCHEDULE_DAYSOFMONTH varchar(200),
   SCHEDULE_DAYSOFWEEK  varchar(20),
   SCHEDULE_HOURSOFDAY  varchar(100),
   SCHEDULE_MINSOFHOUR  smallint,
   SCHEDULE_STATUS      smallint not null default 0,
   SCHEDULE_TYPE        smallint not null default 2,
   SCHEDULE_LASTRUN     bigint,
   SCHEDULE_NEXTRUN     bigint,
   primary key (SCHEDULE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_SENDMAIL
(
   SEND_ID              bigint not null,
   USER_ID              varchar(20),
   SEND_RECEIVER        varchar(400) not null,
   SEND_TITLE           varchar(400) not null,
   SEND_CONTENT         longtext not null,
   SEND_TIME            bigint not null,
   primary key (SEND_ID)
);

CREATE INDEX IDX_SENDMAIL1 ON EF_SENDMAIL
(
   USER_ID,
   SEND_TIME
);

CREATE TABLE EF_SPAMWORDS
(
   SPAM_ID              int not null,
   SPAM_OPERATOR        varchar(20),
   SPAM_WORDS           varchar(60) not null,
   SPAM_REPLACEMENT     varchar(250) not null,
   primary key (SPAM_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_STATS
(
   STAT_TYPE            varchar(40) not null,
   STAT_KEY             varchar(50) not null,
   STAT_VALUE           bigint not null,
   primary key (STAT_TYPE, STAT_KEY)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_TAGS
(
   TAG_ID               bigint 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_TAGS1 ON EF_TAGS
(
   TAG_NAME
);

CREATE TABLE EF_TAGS_HOT
(
   TAG_ID               bigint not null,
   USER_ID              varchar(20) not null,
   HOT_SHOWORDER        int not null,
   HOT_CREATETIME       bigint not null,
   primary key (TAG_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_TAGSHOT1 ON EF_TAGS_HOT
(
   HOT_SHOWORDER
);

CREATE TABLE EF_TEMPLATE_INFO
(
   TEMPLATE_ID          varchar(40) not null,
   TEMPLATE_NAME        varchar(20),
   TEMPLATE_EXTENDFROM  varchar(40),
   TEMPLATE_COPYRIGHT   varchar(400),
   TEMPLATE_CREATETIME  bigint,
   TEMPLATE_ORDER       int,
   TEMPLATE_CREATEUSER  varchar(20),
   TEMPLATE_STATUS      smallint not null default 1,
   primary key (TEMPLATE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_TOPICS
(
   POST_ID              bigint not null,
   FORUM_ID             int,
   USER_ID              varchar(20),
   POST_TITLE           varchar(300) not null,
   POST_TYPE            smallint not null default 0,
   POST_TAGS            varchar(200),
   POST_CREATETIME      bigint not null,
   POST_ISHIDE          smallint not null default 1,
   POST_NEEDREPLY       smallint not null default 1,
   POST_FIRSTUSER       varchar(20),
   POST_FIRSTTIME       bigint,
   POST_FIRSTHIDE       smallint,
   POST_LASTUSER        varchar(20),
   POST_LASTTIME        bigint,
   POST_LASTHIDE        smallint,
   POST_VIEWNUM         int not null default 0,
   POST_REPLYNUM        int not null default 0,
   POST_ATTACHTYPE      smallint not null default 0,
   POST_FACE            varchar(200),
   POST_SUBJECT         varchar(40),
   POST_HIGHLIGHT       varchar(100),
   POST_ISBEST          smallint not null default 1,
   POST_ISTOP           smallint not null default 0,
   POST_SUBSCRIPTION    smallint not null default 1,
   POST_PRESTIGE        int not null default 0,
   POST_TRADETYPE       smallint not null default 0,
   POST_VIEWCONDITION   smallint not null default 0,
   POST_MONEY           int default 0,
   POST_FAVORS          int not null default 0,
   POST_TRADENUM        int not null default 0,
   POST_RECOMMS         int not null default 0,
   POST_SCORENUM        int not null default 0,
   POST_SCORE           int not null default 0,
   POST_SCOREINFO       varchar(100),
   POST_AUDIT           smallint not null default 0,
   POST_CLOSED          smallint not null default 1,
   POST_DELETED         smallint not null default 0,
   POST_DISPLAY         smallint default '0',
   primary key (POST_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_TOPICS1 ON EF_TOPICS
(
   FORUM_ID,
   POST_DISPLAY,
   POST_LASTTIME
);

CREATE INDEX IDX_TOPICS2 ON EF_TOPICS
(
   USER_ID
);

CREATE INDEX IDX_TOPICS3 ON EF_TOPICS
(
   POST_ISBEST
);

CREATE TABLE EF_TOPIC_BUYS
(
   POST_ID              bigint not null,
   USER_ID              varchar(20) not null,