lybbs_mysql_upgrade_6.3to6.4.sql

常见的bbs源代码

# Set names, if mysql version is 4.1.x

#SET NAMES gbk;

# Warnning: This script is only for LyBBS ver 6.3.MySQL to 6.4 upgrade.
ALTER TABLE lybbs_posts DROP lastauthorid;
ALTER TABLE lybbs_posts CHANGE accessaryname accessaryname VARCHAR(80) NOT NULL;
ALTER TABLE lybbs_posts ADD replynum INT(8) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_posts ADD votenum INT(8) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_posts ADD lastauthorid INT(10) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_posts ADD lastauthor VARCHAR(30) DEFAULT '' NOT NULL;
ALTER TABLE lybbs_posts ADD lastpostat BIGINT(13) DEFAULT 0 NOT NULL; 
ALTER TABLE lybbs_posts ADD lastpostclue VARCHAR(80) DEFAULT '' NOT NULL; 
ALTER TABLE lybbs_postvalidate ADD accessaryname VARCHAR(80) DEFAULT '' NOT NULL AFTER accessary;
ALTER TABLE lybbs_postvalidate ADD replynum INT(8) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_postvalidate ADD votenum INT(8) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_postvalidate ADD lastauthorid INT(10) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_postvalidate ADD lastauthor VARCHAR(30) DEFAULT '' NOT NULL;
ALTER TABLE lybbs_postvalidate ADD lastpostat BIGINT(13) DEFAULT 0 NOT NULL; 
ALTER TABLE lybbs_postvalidate ADD lastpostclue VARCHAR(80) DEFAULT '' NOT NULL;
ALTER TABLE lybbs_postdelete ADD accessaryname VARCHAR(80) DEFAULT '' NOT NULL AFTER accessary;
ALTER TABLE lybbs_postdelete ADD replynum INT(8) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_postdelete ADD votenum INT(8) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_postdelete ADD lastauthorid INT(10) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_postdelete ADD lastauthor VARCHAR(30) DEFAULT '' NOT NULL;
ALTER TABLE lybbs_postdelete ADD lastpostat BIGINT(13) DEFAULT 0 NOT NULL; 
ALTER TABLE lybbs_postdelete ADD lastpostclue VARCHAR(80) DEFAULT '' NOT NULL;

ALTER TABLE lybbs_boardstatus ADD maxpostnumber INT(6) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_boardstatus ADD postrecordat datetime default '1970-01-01 00:00:00' NOT NULL;

ALTER TABLE lybbs_posts DROP groupid;
ALTER TABLE lybbs_posts DROP orderby;
ALTER TABLE lybbs_posts DROP viewtype;
ALTER TABLE lybbs_posts CHANGE istop istop TINYINT(1) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_posts ADD topid SMALLINT(4) DEFAULT 0 NOT NULL AFTER istop;
UPDATE lybbs_posts set istop=0;

ALTER TABLE lybbs_posts ADD INDEX ix_posts_db (db);
ALTER TABLE lybbs_posts DROP INDEX ix_posts_1;
ALTER TABLE lybbs_posts DROP INDEX ix_posts_forumType;