lybbs_mysql_upgrade_6.4to6.5.sql

来自「LyBBS基于Struts1.3/Ajax的架构」· SQL 代码 · 共 17 行

# Set names, if mysql version is 4.1.x

#SET NAMES gbk;

# Warnning: This script is only for LyBBS ver 6.4.MySQL to 6.5 upgrade.
ALTER TABLE lybbs_postdelete ADD content TEXT NOT NULL;
ALTER TABLE lybbs_posts CHANGE viewnumber viewnumber INT(10) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_posts CHANGE isdel showsignature TINYINT(1) DEFAULT 1 NOT NULL;
update lybbs_posts set showsignature=1;

#next is 6.5.beta1 to 6.5.stable

ALTER TABLE lybbs_author ADD lastposttime BIGINT(13) DEFAULT 0 NOT NULL;
ALTER TABLE lybbs_author ADD lastloginip VARCHAR(30) DEFAULT '' NOT NULL;
update lybbs_author set lastloginip=ipfrom;