eforum_mysql5.sql

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

   BUY_MONEY            int not null default 0,
   POST_USERID          varchar(20) not null,
   POST_USERINCOME      int not null default 0,
   BUY_TIME             bigint not null,
   primary key (POST_ID, USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_TOPIC_BUY_STAT
(
   POST_ID              bigint not null,
   USER_ID              varchar(20) not null,
   BUY_INCOME           int not null default 0,
   BUY_TIMES            int not null default 0,
   BUY_LASTTIME         bigint not null,
   primary key (POST_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_TOPICBUYSUM1 ON EF_TOPIC_BUY_STAT
(
   USER_ID
);

CREATE TABLE EF_TOPIC_FAVOR
(
   USER_ID              varchar(20) not null,
   POST_ID              bigint not null,
   FAVOR_TAGS           varchar(200),
   FAVOR_TYPE           smallint not null,
   FAVOR_CREATETIME     bigint not null,
   primary key (USER_ID, POST_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_TOPICFAVOR1 ON EF_TOPIC_FAVOR
(
   USER_ID,
   FAVOR_TYPE
);

CREATE TABLE EF_TOPIC_MANAGELOGS
(
   LOG_ID               bigint not null,
   POST_ID              bigint not null,
   LOG_USERNAME         varchar(20) not null,
   LOG_MANAGETIME       bigint,
   LOG_EXPIRATION       bigint,
   LOG_ACTION           smallint not null,
   LOG_STATUS           smallint not null,
   LOG_REASON           varchar(200),
   primary key (LOG_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_TOPICMANLOGS1 ON EF_TOPIC_MANAGELOGS
(
   POST_ID,
   LOG_MANAGETIME
);

CREATE INDEX IDX_TOPICMANLOGS2 ON EF_TOPIC_MANAGELOGS
(
   LOG_ACTION
);

CREATE TABLE EF_TOPIC_SUBSCRIPTIONS
(
   USER_ID              varchar(20) not null,
   POST_ID              bigint not null,
   SUB_METHOD           smallint not null,
   SUB_LASTPOST         bigint not null,
   SUB_LASTNOTIFY       bigint not null,
   primary key (USER_ID, POST_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE EF_TOPIC_TYPE
(
   TYPE_ID              int not null,
   TYPE_NAME            varchar(40) not null,
   TYPE_SHOWORDER       int not null,
   TYPE_README          varchar(250),
   TYPE_STATUS          smallint not null,
   primary key (TYPE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_USERPAGE_ITEMS
(
   CONFIG_ID            bigint not null,
   ITEM_KEY             varchar(40) not null,
   USER_ID              varchar(20),
   FORUM_ID             int,
   ITEM_NAME            varchar(40) not null,
   ITEM_RSS             varchar(250) not null,
   ITEM_POSITION        int not null,
   ITEM_PARAMETER       varchar(500),
   ITEM_LAYOUTID        varchar(40),
   primary key (CONFIG_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_USERPAGEITEMS1 ON EF_USERPAGE_ITEMS
(
   USER_ID,
   ITEM_POSITION
);

CREATE TABLE EF_USERS
(
   USER_ID              varchar(20) not null,
   GROUP_ID             int,
   USER_NICKNAME        varchar(100) not null,
   USER_SELFCALLED      varchar(200),
   USER_GENDER          smallint not null default 0,
   USER_REGTIME         bigint not null,
   USER_REGIP           varchar(30) not null,
   USER_LASTVISITTIME   bigint,
   USER_LASTVISITIP     varchar(30),
   USER_ONLINETIME      bigint not null default 0,
   USER_BIRTHDAY        date,
   USER_ALIPAYACCOUNT   varchar(200),
   USER_SIGNATURE       text,
   USER_PARSEDSIGNATURE text,
   USER_TOPICS          int not null default 0,
   USER_POSTS           int not null default 0,
   USER_ATTACHS         int not null default 0,
   USER_MESSAGES        int not null default 0,
   USER_SCORE           int not null default 0,
   USER_BESTPOSTS       int not null default 0,
   USER_VISITORS        int not null default 0,
   USER_CREDIT          int not null default 0,
   USER_EXTCREDIT1      int default 0,
   USER_EXTCREDIT2      int not null default 0,
   USER_EXTCREDIT3      int not null default 0,
   USER_EXTCREDIT4      int not null default 0,
   USER_EXTCREDIT5      int not null default 0,
   USER_EXTCREDIT6      int not null default 0,
   USER_RANK            int,
   USER_RANKNEEDUPDATE  smallint not null default 1,
   USER_MEDAL           varchar(100),
   USER_GROUPNEEDUPDATE smallint not null default 1,
   USER_LASTPOSTTIME    bigint,
   USER_LASTSENDTIME    bigint,
   USER_LASTSEARCHTIME  bigint,
   USER_UPLOADHEADPIC   smallint default 1,
   USER_ACTIVATIONCODE  bigint,
   primary key (USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_EUSERS1 ON EF_USERS
(
   GROUP_ID
);

CREATE INDEX IDX_EUSERS2 ON EF_USERS
(
   USER_NICKNAME
);

CREATE INDEX IDX_EUSERS3 ON EF_USERS
(
   USER_REGTIME
);

CREATE INDEX IDX_EUSERS4 ON EF_USERS
(
   USER_REGIP
);

CREATE TABLE EF_USER_ARGUE
(
   USER_ID              varchar(20) not null,
   POST_ID              bigint not null,
   ARGUE_TYPE           smallint not null,
   ARGUE_TIME           bigint not null,
   primary key (USER_ID, POST_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_USER_ATTENTION
(
   ATTENTION_USER       varchar(20) not null,
   USER_ID              varchar(20) not null,
   ATTENTION_CREATETIME bigint not null,
   primary key (ATTENTION_USER, USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_USER_AUDITS
(
   USER_ID              varchar(20) not null,
   AUDIT_NUMBER         int not null default 0,
   AUDIT_REGTIME        bigint not null,
   AUDIT_REASON         varchar(800),
   AUDIT_TIME           bigint,
   AUDIT_ADMIN          varchar(20),
   AUDIT_STATUS         smallint not null,
   AUDIT_REMARK         varchar(800),
   primary key (USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_USER_CONFIG
(
   CONFIG_KEY           varchar(40) not null,
   USER_ID              varchar(20) not null,
   CONFIG_VALUE         varchar(3500),
   CONFIG_TYPE          smallint not null,
   primary key (CONFIG_KEY, USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_USERCONFIG1 ON EF_USER_CONFIG
(
   USER_ID
);

CREATE TABLE EF_USER_CREDITLOGS
(
   CREDIT_ID            bigint not null,
   CREDIT_FROMUSER      varchar(20) not null,
   CREDIT_FROMFIELD     varchar(40) not null,
   CREDIT_FROMSCORE     int not null,
   CREDIT_FROMRATE      decimal(18,2) not null,
   CREDIT_TOUSER        varchar(20) not null,
   CREDIT_TOFIELD       varchar(40) not null,
   CREDIT_TOSCORE       int not null,
   CREDIT_TORATE        decimal(18,2) not null,
   CREDIT_TIME          bigint not null,
   CREDIT_TRADETAX      decimal(18,2) not null,
   CREDIT_TYPE          smallint not null,
   CREDIT_REMARK        varchar(400),
   primary key (CREDIT_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_USERCREDITLOGS1 ON EF_USER_CREDITLOGS
(
   CREDIT_FROMUSER,
   CREDIT_TYPE,
   CREDIT_TIME
);

CREATE INDEX IDX_USERCREDITLOGS2 ON EF_USER_CREDITLOGS
(
   CREDIT_TOUSER,
   CREDIT_TYPE,
   CREDIT_TIME
);

CREATE TABLE EF_USER_CREDITREWARD_LOGS
(
   CREDIT_ID            bigint not null,
   CREDIT_ADMINID       varchar(20) not null,
   CREDIT_SCORES        varchar(100) not null,
   CREDIT_UPDATEREMARK  varchar(200) not null,
   CREDIT_UPDATETIME    bigint not null,
   CREDIT_USERS         text not null,
   CREDIT_SQL           text not null,
   CREDIT_NOTIFYMETHOD  smallint not null default 3,
   primary key (CREDIT_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_USERCREDITREWARDLOGS1 ON EF_USER_CREDITREWARD_LOGS
(
   CREDIT_ADMINID
);

CREATE TABLE EF_USER_CREDIT_CHANGE
(
   LOG_ID               bigint not null,
   USER_ID              varchar(20) not null,
   LOG_ADMINUSER        varchar(20) not null,
   LOG_CONTENT          varchar(400) not null,
   LOG_REASON           varchar(250) not null,
   LOG_TIME             bigint not null,
   primary key (LOG_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_USERCREDITCHANGE1 ON EF_USER_CREDIT_CHANGE
(
   USER_ID,
   LOG_TIME
);

CREATE INDEX IDX_USERCREDITCHANGE2 ON EF_USER_CREDIT_CHANGE
(
   LOG_ADMINUSER,
   LOG_TIME
);

CREATE TABLE EF_USER_DAY
(
   DAY_DATETIME         date not null,
   USER_ID              varchar(20) not null,
   DAY_TOPICS           int not null default 0,
   DAY_POSTS            int not null default 0,
   DAY_REPLYS           int not null default 0,
   DAY_ATTACHES         int not null default 0,
   DAY_ATTACHSIZE       int not null default 0,
   DAY_VISITORS         int not null default 0,
   DAY_ONLINETIME       bigint not null default 0,
   DAY_SENDMESSAGES     int not null default 0,
   DAY_SEARCHES         int not null default 0,
   primary key (DAY_DATETIME, USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_USER_EXTENDGROUP_INFO
(
   EXTEND_ID            bigint not null,
   USER_ID              varchar(20) not null,
   EXTEND_GROUP         int not null,
   EXTEND_EXPIRATION    bigint,
   EXTEND_ADMIN         varchar(20),
   EXTEND_TIME          bigint,
   EXTEND_NOTES         varchar(400),
   EXTEND_STATUS        smallint not null,
   primary key (EXTEND_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_EXTENDGROUP2 ON EF_USER_EXTENDGROUP_INFO
(
   EXTEND_GROUP,
   EXTEND_STATUS
);

CREATE INDEX IDX_EXTENDGROUP1 ON EF_USER_EXTENDGROUP_INFO
(
   USER_ID,
   EXTEND_STATUS
);

CREATE TABLE EF_USER_EXTENDINFO
(
   USER_ID              varchar(20) not null,
   USER_LASTNAME        varchar(100),
   USER_FIRSTNAME       varchar(100),
   USER_COUNTRY         int,
   USER_PROVINCE        int,
   USER_CITY            int,
   USER_ADDRESS         varchar(200),
   USER_LIFEADDRESS     varchar(200),
   USER_POSTALCODE      varchar(10),
   USER_IDTYPE          smallint,
   USER_IDNUMBER        varchar(30),
   USER_HOMEPAGE        varchar(80),
   USER_FAMILYPHONE     varchar(20),
   USER_OFFICEPHONE     varchar(30),
   USER_MOBILEPHONE     varchar(30),
   USER_OFFICEFAX       varchar(20),
   USER_HOMEFAX         varchar(20),
   USER_VOCATION        varchar(50),
   USER_COMPANY         varchar(200),
   USER_POSITION        varchar(50),
   USER_INCOME          smallint,
   USER_DEGREE          smallint,
   USER_GRADUATE        varchar(100),
   USER_MARRIED         smallint,
   USER_CHILDREN        smallint,
   USER_TOTEM           smallint,
   USER_NATION          smallint,
   USER_HEIGHT          int,
   USER_WEIGHT          int,
   USER_CHARACTER       smallint,
   USER_STATURE         smallint,
   USER_LOOKS           smallint,
   USER_HOUSE           smallint,
   USER_CAR             smallint,
   USER_ASTRO           smallint,
   USER_BLOOGGROUP      smallint,
   USER_LUCKYNUMBER     varchar(50),
   USER_FAVSPORTS       varchar(200),
   USER_FAVMUSIC        varchar(200),
   USER_FAVMOVIE        varchar(200),
   USER_FAVFOOD         varchar(200),
   USER_FAVCOLOR        varchar(200),
   USER_BELIEF          smallint,
   USER_QQ              varchar(50),
   USER_MSN             varchar(100),
   USER_ICQ             varchar(50),
   USER_YAHOO           varchar(100),
   USER_SKYPE           varchar(100),
   USER_TBWW            varchar(100),
   USER_SELFINTRO       varchar(1000),
   primary key (USER_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE EF_USER_GROUP
(
   GROUP_ID             int not null,
   GROUP_NAME           varchar(50) not null,
   GROUP_TYPE           smallint not null,
   GROUP_DESCR          varchar(200),
   GROUP_ISADMIN        smallint not null,
   GROUP_STATUS         smallint not null,
   primary key (GROUP_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE EF_USER_GROUP_CHANGE
(
   CHANGE_ID            bigint not null,
   USER_ID              varchar(20) not null,
   CHANGE_ADMINID       varchar(20) not null,
   CHANGE_UPDATETIME    bigint not null,
   CHANGE_REASON        varchar(400),
   CHANGE_DATETIME      bigint,
   CHANGE_BEFOREGROUPID int,
   CHANGE_CURRENTGROUPID int not null,