eforum_mysql4.sql

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

DROP TABLE IF EXISTS EF_ACTIVITIES_ITEMS;

DROP TABLE IF EXISTS EF_ACTIVITIES_LOGS;

DROP TABLE IF EXISTS EF_ACTIVITIES_USER;

DROP TABLE IF EXISTS EF_ADMIN_RATE_STAT;

DROP TABLE IF EXISTS EF_ADS;

DROP TABLE IF EXISTS EF_ADS_GROUP;

DROP TABLE IF EXISTS EF_ADS_GROUP_SET;

DROP TABLE IF EXISTS EF_ADS_POSITION;

DROP TABLE IF EXISTS EF_ADS_SET;

DROP TABLE IF EXISTS EF_ADS_SHOWTYPE;

DROP TABLE IF EXISTS EF_ADS_SHOWTYPE_FIELDS;

DROP TABLE IF EXISTS EF_ADS_TYPE;

DROP TABLE IF EXISTS EF_ADS_TYPE_FIELDS;

DROP TABLE IF EXISTS EF_ARGUE_DIG;

DROP TABLE IF EXISTS EF_ATTACH;

DROP TABLE IF EXISTS EF_ATTACH_ALLOW;

DROP TABLE IF EXISTS EF_CODES;

DROP TABLE IF EXISTS EF_CODE_CATEGORY;

DROP TABLE IF EXISTS EF_CONFIG;

DROP TABLE IF EXISTS EF_CREDIT_ADMIN_REWARDS;

DROP TABLE IF EXISTS EF_CREDIT_CONFIG;

DROP TABLE IF EXISTS EF_CREDIT_POLICY;

DROP TABLE IF EXISTS EF_DAY_STAT;

DROP TABLE IF EXISTS EF_FACE;

DROP TABLE IF EXISTS EF_FAILLOGINS;

DROP TABLE IF EXISTS EF_FORUMLINKS;

DROP TABLE IF EXISTS EF_FORUMS;

DROP TABLE IF EXISTS EF_FORUM_CREDIT_POLICY;

DROP TABLE IF EXISTS EF_FORUM_DAY;

DROP TABLE IF EXISTS EF_FORUM_FAVOR;

DROP TABLE IF EXISTS EF_FORUM_OTHER_CONFIG;

DROP TABLE IF EXISTS EF_FORUM_OWNER;

DROP TABLE IF EXISTS EF_FORUM_SMILES;

DROP TABLE IF EXISTS EF_FORUM_TAGS;

DROP TABLE IF EXISTS EF_FORUM_TOPIC_TAGS;

DROP TABLE IF EXISTS EF_FRIENDS;

DROP TABLE IF EXISTS EF_FRIEND_TAGS;

DROP TABLE IF EXISTS EF_FRIEND_TAGS_REL;

DROP TABLE IF EXISTS EF_GROUP_FORUM_AUTH;

DROP TABLE IF EXISTS EF_IP_BANNED;

DROP TABLE IF EXISTS EF_LEAVEWORD;

DROP TABLE IF EXISTS EF_MEDALS;

DROP TABLE IF EXISTS EF_MESSAGE_IMPEACH;

DROP TABLE IF EXISTS EF_MY_POSTS;

DROP TABLE IF EXISTS EF_MY_TOPICS;

DROP TABLE IF EXISTS EF_NOTIFY;

DROP TABLE IF EXISTS EF_ONLINEUSER;

DROP TABLE IF EXISTS EF_PAGE_ITEM;

DROP TABLE IF EXISTS EF_PLACARD;

DROP TABLE IF EXISTS EF_PORTAL_FORUMTOPIC;

DROP TABLE IF EXISTS EF_POSTS;

DROP TABLE IF EXISTS EF_POST_ACTIVITIES;

DROP TABLE IF EXISTS EF_POST_ARGUE;

DROP TABLE IF EXISTS EF_POST_ARGUE_INFO;

DROP TABLE IF EXISTS EF_POST_IMPEACH;

DROP TABLE IF EXISTS EF_POST_RATELOGS;

DROP TABLE IF EXISTS EF_POST_REWARD;

DROP TABLE IF EXISTS EF_POST_SCORE;

DROP TABLE IF EXISTS EF_POST_VOTE;

DROP TABLE IF EXISTS EF_RANKS;

DROP TABLE IF EXISTS EF_RECVMAIL;

DROP TABLE IF EXISTS EF_REGION;

DROP TABLE IF EXISTS EF_SCHEDULE_SET;

DROP TABLE IF EXISTS EF_SENDMAIL;

DROP TABLE IF EXISTS EF_SPAMWORDS;

DROP TABLE IF EXISTS EF_STATS;

DROP TABLE IF EXISTS EF_TAGS;

DROP TABLE IF EXISTS EF_TAGS_HOT;

DROP TABLE IF EXISTS EF_TEMPLATE_INFO;

DROP TABLE IF EXISTS EF_TOPICS;

DROP TABLE IF EXISTS EF_TOPIC_BUYS;

DROP TABLE IF EXISTS EF_TOPIC_BUY_STAT;

DROP TABLE IF EXISTS EF_TOPIC_FAVOR;

DROP TABLE IF EXISTS EF_TOPIC_MANAGELOGS;

DROP TABLE IF EXISTS EF_TOPIC_SUBSCRIPTIONS;

DROP TABLE IF EXISTS EF_TOPIC_TAGS;

DROP TABLE IF EXISTS EF_TOPIC_TYPE;

DROP TABLE IF EXISTS EF_USERPAGE_ITEMS;

DROP TABLE IF EXISTS EF_USERS;

DROP TABLE IF EXISTS EF_USER_ARGUE;

DROP TABLE IF EXISTS EF_USER_ATTENTION;

DROP TABLE IF EXISTS EF_USER_AUDITS;

DROP TABLE IF EXISTS EF_USER_CONFIG;

DROP TABLE IF EXISTS EF_USER_CREDITLOGS;

DROP TABLE IF EXISTS EF_USER_CREDITREWARD_LOGS;

DROP TABLE IF EXISTS EF_USER_CREDIT_CHANGE;

DROP TABLE IF EXISTS EF_USER_DAY;

DROP TABLE IF EXISTS EF_USER_EXTENDGROUP_INFO;

DROP TABLE IF EXISTS EF_USER_EXTENDINFO;

DROP TABLE IF EXISTS EF_USER_FIELDS;

DROP TABLE IF EXISTS EF_USER_GROUP;

DROP TABLE IF EXISTS EF_USER_GROUP_CHANGE;

DROP TABLE IF EXISTS EF_USER_GROUP_CONFIG;

DROP TABLE IF EXISTS EF_USER_MEDAL_LOGS;

DROP TABLE IF EXISTS EF_USER_POST_TAGS;

DROP TABLE IF EXISTS EF_USER_RECOMMED;

DROP TABLE IF EXISTS EF_USER_TAGS;

DROP TABLE IF EXISTS EF_VISITORS;

DROP TABLE IF EXISTS EF_VOTE_LOGS;

DROP TABLE IF EXISTS EF_VOTE_OPTIONS;

DROP TABLE IF EXISTS OSC_USERS;

CREATE TABLE EF_ACTIVITIES_ITEMS
(
   ITEM_ID              bigint not null,
   POST_ID              bigint not null,
   ITEM_VALUE           varchar(200) not null,
   ITEM_SHOWORDER       int not null default 0,
   ITEM_ENTERNUM        int not null default 0,
   ITEM_BUYNUM          int not null default 0,
   primary key (ITEM_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_ACTIVEITEMS1 ON EF_ACTIVITIES_ITEMS
(
   POST_ID,
   ITEM_SHOWORDER
);

CREATE TABLE EF_ACTIVITIES_LOGS
(
   USER_ID              varchar(20) not null,
   ITEM_ID              bigint not null,
   LOG_BUYNUM           int not null default 1,
   primary key (USER_ID, ITEM_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_ACTIVITIES_USER
(
   POST_ID              bigint not null,
   USER_ID              varchar(20) not null,
   USER_STATUS          smallint not null,
   USER_ACTIVETIME      bigint not null,
   USER_RELATION        varchar(400) not null,
   USER_RELATIONOPEN    smallint not null default 0,
   USER_CONTENT         varchar(400),
   USER_PARSEURLFLAG    smallint,
   USER_ISHIDE          smallint,
   USER_HTMLFLAG        smallint,
   USER_UBBFLAG         smallint,
   USER_UNPASSREASON    varchar(400),
   USER_SIGNOUTREASON   varchar(400),
   USER_REQUIREMENT     varchar(400),
   USER_REQUIREMENTOPEN smallint default 0,
   USER_ACTIVE1         varchar(100),
   USER_ACTIVE2         varchar(100),
   USER_ACTIVE3         varchar(100),
   USER_ACTIVE4         varchar(100),
   USER_ACTIVE5         varchar(100),
   USER_ACTIVE6         varchar(100),
   primary key (POST_ID, USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_ADMIN_RATE_STAT
(
   RATE_DATE            date not null,
   RATE_FIELD           varchar(40) not null,
   USER_ID              varchar(20) not null,
   RATE_SUM             int not null,
   primary key (RATE_DATE, RATE_FIELD, USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_ADS
(
   ADS_ID               int not null,
   POSITION_KEY         varchar(40) not null,
   SHOWTYPE_ID          varchar(30) not null,
   ADSTYPE_ID           varchar(20) not null,
   ADS_STATUS           smallint not null,
   ADS_TITLE            varchar(200) not null,
   ADS_README           varchar(400) not null,
   ADS_ORDER            int not null,
   ADS_STARTTIME        bigint not null,
   ADS_ENDTIME          bigint,
   ADS_WEIGHT           int not null,
   ADS_TARGET           varchar(500),
   primary key (ADS_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_ADS1 ON EF_ADS
(
   POSITION_KEY,
   SHOWTYPE_ID,
   ADSTYPE_ID
);

CREATE TABLE EF_ADS_GROUP
(
   POSITION_KEY         varchar(40) not null,
   SHOWTYPE_ID          varchar(30) not null,
   ADSGROUP_README      varchar(200) not null,
   ADSGROUP_IAB         varchar(50),
   ADSGROUP_WIDTH       int,
   ADSGROUP_HEIGHT      int,
   ADSGROUP_USEDEFAULT  smallint not null default 1,
   ADSGROUP_STATUS      smallint not null,
   ADSGROUP_SHOWMODE    smallint not null,
   ADSGROUP_MODELTYPE   smallint not null,
   primary key (POSITION_KEY, SHOWTYPE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_ADS_GROUP_SET
(
   POSITION_KEY         varchar(40) not null,
   SHOWTYPE_ID          varchar(30) not null,
   FIELD_ID             varchar(20) not null,
   FIELD_VALUE          text,
   primary key (POSITION_KEY, SHOWTYPE_ID, FIELD_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_ADS_POSITION
(
   POSITION_KEY         varchar(40) not null,
   POSITION_README      varchar(400) not null,
   POSITION_SHOWTYPES   varchar(400) not null,
   primary key (POSITION_KEY)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_ADS_SET
(
   ADS_ID               int not null,
   FIELD_ID             varchar(20) not null,
   ADSTYPE_ID           varchar(20) not null,
   FIELD_VALUE          text,
   primary key (ADS_ID, FIELD_ID, ADSTYPE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_ADS_SHOWTYPE
(
   SHOWTYPE_ID          varchar(30) not null,
   SHOWTYPE_NAME        varchar(40) not null,
   SHOWTYPE_ADSTYPES    varchar(100) not null,
   SHOWTYPE_README      varchar(500) not null,
   primary key (SHOWTYPE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_ADS_SHOWTYPE_FIELDS
(
   FIELD_ID             varchar(20) not null,
   SHOWTYPE_ID          varchar(30) not null,
   FIELD_NAME           varchar(30) not null,
   FIELD_DESCR          varchar(200),
   FIELD_NULLABLE       smallint not null default 1,
   FIELD_SHOWTYPE       smallint not null,
   FIELD_DATASOURCE     varchar(500),
   FIELD_MAXSIZE        int,
   FIELD_DEFAULT        text not null,
   FIELD_ORDER          int not null,
   FIELD_STATUS         smallint not null default 0,
   primary key (FIELD_ID, SHOWTYPE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_ADS_TYPE
(
   ADSTYPE_ID           varchar(20) not null,
   ADSTYPE_NAME         varchar(50) not null,
   ADSTYPE_README       varchar(500),
   primary key (ADSTYPE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_ADS_TYPE_FIELDS
(
   FIELD_ID             varchar(20) not null,
   ADSTYPE_ID           varchar(20) not null,
   FIELD_NAME           varchar(100) not null,
   FIELD_DESCR          varchar(100),
   FIELD_NULLABLE       smallint not null default 1,
   FIELD_SHOWTYPE       smallint not null,
   FIELD_DATASOURCE     varchar(500),
   FIELD_MAXSIZE        int,
   FIELD_ORDER          int not null,
   FIELD_STATUS         smallint not null default 0,
   primary key (FIELD_ID, ADSTYPE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_ARGUE_DIG
(
   USER_ID              varchar(20) not null,
   POST_ID              bigint not null,
   DIG_TYPE             smallint not null,
   DIG_TIME             bigint not null,
   primary key (USER_ID, POST_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_ATTACH
(
   ATTACH_ID            bigint not null,
   USER_ID              varchar(20) not null,
   POST_ID              bigint not null,
   ATTACH_ROOTPOSTID    bigint not null,
   FORUM_ID             int not null,
   ATTACH_TITLE         varchar(200),
   ATTACH_FILENAME      varchar(400),
   ATTACH_FILENAME2     varchar(100),
   ATTACH_FILEEXT       varchar(20),
   ATTACH_CONTENTTYPE   varchar(40),
   ATTACH_FILESIZE      int,
   ATTACH_PATH          varchar(250),
   ATTACH_CREATETIME    bigint not null,
   ATTACH_TYPE          smallint not null,
   ATTACH_DOWNNUM       int not null,
   ATTACH_VIEWNUM       int not null,
   ATTACH_STATUS        smallint not null,
   ATTACH_NO            int not null,
   ATTACH_RANDOM        int not null,
   ATTACH_SCORE         int default 0,
   ATTACH_SCORENUM      int default 0,
   ATTACH_SCOREAVG      decimal(6,1) default 0,
   ATTACH_SCOREINFO     varchar(50),
   primary key (ATTACH_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_ATTACH1 ON EF_ATTACH
(
   POST_ID
);

CREATE INDEX IDX_ATTACH2 ON EF_ATTACH
(
   USER_ID
);