', '[qq]688888[/qq]', 'Show online status of specified QQ UIN and chat with him/her simply by clicking the icon', 1, 1);
INSERT INTO cdb_bbcodes (id, available, tag, replacement, example, explanation, params, nest) VALUES ('', 0, 'flash', '', 'Flash Movie', 'Insert flash movie to thread page', 1, 1);
ALTER TABLE cdb_access ADD allowpostattach tinyint(1) NOT NULL;
ALTER TABLE cdb_words CHANGE find find varchar(255) NOT NULL, CHANGE replacement replacement varchar(255) NOT NULL;
ALTER TABLE cdb_stats CHANGE type type char(10) NOT NULL default '', CHANGE var variable char(10) NOT NULL default '';
ALTER TABLE cdb_ranks CHANGE postshigher postshigher MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE cdb_admingroups ADD allowmodpost tinyint(1) NOT NULL default '' AFTER alloweditpoll, CHANGE admingid admingid SMALLINT(6) UNSIGNED DEFAULT '0' NOT NULL, ADD allowmoduser TINYINT(1) NOT NULL AFTER allowedituser, ADD allowstickthread tinyint(1) NOT NULL AFTER alloweditpoll, ADD allowrefund tinyint(1) NOT NULL AFTER allowmassprune;
ALTER TABLE cdb_attachtypes CHANGE extension extension char(12) NOT NULL;
UPDATE cdb_stats SET variable='Spiders' WHERE type='os' AND variable='BeOS';
UPDATE cdb_stats SET variable='0' WHERE type='week' AND variable='';
UPDATE cdb_admingroups SET allowmodpost=1;
UPDATE cdb_admingroups SET allowmoduser='1', allowstickthread=4-admingid WHERE admingid IN (1,2,3);
UPDATE cdb_admingroups SET allowrefund=1 WHERE admingid=1 OR admingid=2;
ALTER TABLE cdb_threads CHANGE views views INT(10) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE replies replies MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
ADD blog TINYINT(1) NOT NULL AFTER digest,
ADD moderated TINYINT(1) NOT NULL AFTER attachment,
ADD rate TINYINT(1) NOT NULL AFTER digest,
ADD INDEX blog (blog , authorid , dateline),
ADD readperm tinyint(3) UNSIGNED NOT NULL AFTER iconid,
ADD price smallint(6) NOT NULL AFTER readperm;
UPDATE cdb_threads SET readperm=100 WHERE creditsrequire>10;
ALTER TABLE cdb_threads DROP creditsrequire, ADD typeid smallint(6) UNSIGNED NOT NULL default '0' AFTER iconid, ADD INDEX typeid (fid, typeid, displayorder, lastpost);
ALTER TABLE cdb_sessions ADD lastolupdate INT(10) UNSIGNED NOT NULL AFTER lastactivity, ADD bloguid MEDIUMINT(8) UNSIGNED NOT NULL, ADD seccode SMALLINT(6) UNSIGNED NOT NULL AFTER lastolupdate, ADD pageviews smallint(6) UNSIGNED NOT NULL AFTER lastolupdate, ADD INDEX (uid), ADD INDEX (bloguid);
ALTER TABLE cdb_usergroups ADD maxsizeperday INT(10) UNSIGNED NOT NULL AFTER maxattachsize, CHANGE maxattachsize maxattachsize MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL, ADD radminid TINYINT(3) NOT NULL AFTER groupid, ADD allowhtml TINYINT(1) NOT NULL AFTER allowhidecode, ADD allowdirectpost tinyint(1) NOT NULL AFTER allowpostpoll, ADD reasonpm tinyint(1) NOT NULL AFTER allowviewstats, ADD allowuseblog TINYINT(1) NOT NULL AFTER allowkarma, ADD allowviewpro tinyint(1) NOT NULL AFTER allowsigimgcode, ADD minkarmarate smallint(6) NOT NULL default 0 AFTER reasonpm, CHANGE maxkarmarate maxkarmarate1 smallint(6) NOT NULL default 0, ADD maxkarmarate smallint(6) NOT NULL default 0 AFTER minkarmarate, ADD allowcusbbcode TINYINT(1) NOT NULL AFTER allowhtml, CHANGE allowsetviewperm allowsetreadperm tinyint(1) NOT NULL, ADD readaccess tinyint(3) UNSIGNED NOT NULL default '0' AFTER groupavatar, ADD allownickname tinyint(1) NOT NULL AFTER allowcusbbcode;
UPDATE cdb_usergroups SET allowdirectpost='1', allowuseblog='1', allowcusbbcode='1' WHERE groupid IN ('1', '2', '3');
UPDATE cdb_usergroups SET allowviewpro=1 WHERE groupid IN (1,2,3) OR groupid>8;
UPDATE cdb_usergroups SET maxkarmarate=maxkarmarate1;
UPDATE cdb_usergroups SET minkarmarate=-1*maxkarmarate;
UPDATE cdb_usergroups SET allownickname=1 WHERE groupid IN (1,2,3) OR creditshigher>500;
UPDATE cdb_usergroups SET readaccess=10 WHERE groupid NOT IN (4,5,6,7,8) AND allowview<>0;
UPDATE cdb_usergroups SET readaccess=100+3-groupid WHERE groupid IN (1,2,3);
ALTER TABLE cdb_usergroups DROP maxkarmarate1, DROP allowview;
UPDATE cdb_usergroups SET radminid=groupid WHERE groupid IN (1,2,3);
ALTER TABLE cdb_smilies CHANGE code code VARCHAR(30) NOT NULL, ADD displayorder tinyint(1) NOT NULL AFTER id;
ALTER TABLE cdb_favorites DROP INDEX tid, ADD INDEX uid (uid);
ALTER TABLE cdb_styles DROP INDEX themename;
DROP TABLE IF EXISTS cdb_threadtypes;
CREATE TABLE cdb_threadtypes (
typeid smallint(6) UNSIGNED NOT NULL auto_increment,
displayorder tinyint(3) NOT NULL,
name varchar(255) NOT NULL,
description varchar(255) NOT NULL default '',
PRIMARY KEY (typeid)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_medals;
CREATE TABLE cdb_medals (
medalid smallint(6) UNSIGNED NOT NULL auto_increment,
name varchar(50) NOT NULL,
available tinyint(1) NOT NULL,
image varchar(30) NOT NULL,
PRIMARY KEY (medalid)
) TYPE=MyISAM;
INSERT INTO cdb_medals VALUES (1, 'Medal No.1', 0, 'medal1.gif');
INSERT INTO cdb_medals VALUES (2, 'Medal No.2', 0, 'medal2.gif');
INSERT INTO cdb_medals VALUES (3, 'Medal No.3', 0, 'medal3.gif');
INSERT INTO cdb_medals VALUES (4, 'Medal No.4', 0, 'medal4.gif');
INSERT INTO cdb_medals VALUES (5, 'Medal No.5', 0, 'medal5.gif');
INSERT INTO cdb_medals VALUES (6, 'Medal No.6', 0, 'medal6.gif');
INSERT INTO cdb_medals VALUES (7, 'Medal No.7', 0, 'medal7.gif');
INSERT INTO cdb_medals VALUES (8, 'Medal No.8', 0, 'medal8.gif');
INSERT INTO cdb_medals VALUES (9, 'Medal No.9', 0, 'medal9.gif');
INSERT INTO cdb_medals VALUES (10, 'Medal No.10', 0, 'medal10.gif');
DROP TABLE IF EXISTS cdb_adminactions;
CREATE TABLE cdb_adminactions (
admingid SMALLINT(6) UNSIGNED NOT NULL,
disabledactions TEXT NOT NULL,
PRIMARY KEY (admingid)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_advertisements;
CREATE TABLE cdb_advertisements (
advid mediumint(8) unsigned NOT NULL auto_increment,
available tinyint(1) NOT NULL default '0',
`type` varchar(50) NOT NULL default '0',
displayorder tinyint(3) NOT NULL default '0',
title varchar(50) NOT NULL default '',
targets varchar(255) NOT NULL default '',
parameters text NOT NULL,
code text NOT NULL,
starttime int(10) unsigned NOT NULL default '0',
endtime int(10) unsigned NOT NULL default '0',
PRIMARY KEY (advid)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_orders;
CREATE TABLE cdb_orders (
orderid char(32) NOT NULL default '',
`status` char(3) NOT NULL default '',
buyer char(50) NOT NULL default '',
admin char(15) NOT NULL default '',
uid mediumint(8) unsigned NOT NULL default '0',
amount smallint(6) unsigned NOT NULL default '0',
price float(7,2) unsigned NOT NULL default '0.00',
submitdate int(10) unsigned NOT NULL default '0',
confirmdate int(10) unsigned NOT NULL default '0',
UNIQUE KEY orderid (orderid),
KEY submitdate (submitdate),
KEY uid (uid,submitdate)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_adminsessions;
CREATE TABLE cdb_adminsessions (
uid mediumint(8) UNSIGNED NOT NULL default '0',
ip char(15) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
errorcount tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_blogcaches;
CREATE TABLE cdb_blogcaches (
uid mediumint(8) unsigned NOT NULL default '0',
variable char(10) NOT NULL default '',
value text NOT NULL,
PRIMARY KEY (uid,variable)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_karmalog;
DROP TABLE IF EXISTS cdb_ratelog;
CREATE TABLE cdb_ratelog (
pid int(10) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0',
username char(15) NOT NULL default '',
extcredits tinyint(1) UNSIGNED NOT NULL,
dateline int(10) unsigned NOT NULL default '0',
score smallint(6) NOT NULL default '0',
reason char(20) NOT NULL,
INDEX (dateline),
INDEX (pid, dateline)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_moderators;
CREATE TABLE cdb_moderators (
uid mediumint(8) UNSIGNED NOT NULL,
fid smallint(6) UNSIGNED NOT NULL,
displayorder tinyint(3) NOT NULL default '0',
inherited tinyint(1) NOT NULL default '0',
PRIMARY KEY (uid, fid)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_regips;
CREATE TABLE cdb_regips (
ip char(15) NOT NULL,
dateline int(10) UNSIGNED NOT NULL default 0,
count smallint(6) NOT NULL default 0,
KEY (ip)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_statvars;
CREATE TABLE cdb_statvars (
type varchar(20) NOT NULL default '',
variable varchar(20) NOT NULL default '',
value mediumtext NOT NULL,
PRIMARY KEY (type, variable)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_threadsmod;
CREATE TABLE cdb_threadsmod (
tid mediumint(8) UNSIGNED NOT NULL,
uid mediumint(8) UNSIGNED NOT NULL,
username char(15) NOT NULL,
dateline int(10) UNSIGNED NOT NULL,
action char(3) NOT NULL,
PRIMARY KEY (tid)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_adminnotes;
CREATE TABLE cdb_adminnotes (
id mediumint(8) unsigned NOT NULL auto_increment,
admin varchar(15) NOT NULL default '',
access tinyint(3) NOT NULL default '0',
adminid tinyint(3) NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
expiration int(10) unsigned NOT NULL default '0',
message text NOT NULL,
PRIMARY KEY (id)
) Type=MyISAM;
DROP TABLE IF EXISTS cdb_onlinetime;
CREATE TABLE cdb_onlinetime (
uid mediumint(8) unsigned NOT NULL,
thismonth smallint(6) UNSIGNED NOT NULL default '0',
total mediumint(8) UNSIGNED NOT NULL default '0',
PRIMARY KEY (uid)
) Type=MyISAM;
DROP TABLE IF EXISTS cdb_forumfields;
CREATE TABLE cdb_forumfields (
fid smallint(6) UNSIGNED NOT NULL,
description text NOT NULL,
password varchar(12) NOT NULL,
icon varchar(255) NOT NULL,
postcredits varchar(255) NOT NULL,
replycredits varchar(255) NOT NULL,
redirect varchar(255) NOT NULL,
attachextensions varchar(255) NOT NULL,
moderators text NOT NULL,
rules text NOT NULL,
threadtypes text NOT NULL,
viewperm text NOT NULL,
postperm text NOT NULL,
replyperm text NOT NULL,
getattachperm text NOT NULL,
postattachperm text NOT NULL,
PRIMARY KEY (fid)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_validating;
CREATE TABLE cdb_validating (
uid mediumint(8) unsigned NOT NULL,
submitdate int(10) unsigned NOT NULL,
moddate int(10) unsigned NOT NULL,
admin varchar(15) NOT NULL,
submittimes tinyint(3) unsigned NOT NULL,
status tinyint(1) NOT NULL,
message text NOT NULL,
remark text NOT NULL,
PRIMARY KEY (uid),
KEY (status)
) Type=MyISAM;
DROP TABLE IF EXISTS cdb_paymentlog;
CREATE TABLE cdb_paymentlog (
uid mediumint(8) UNSIGNED NOT NULL,
tid mediumint(8) UNSIGNED NOT NULL,
authorid mediumint(8) UNSIGNED NOT NULL,
dateline int(10) UNSIGNED NOT NULL,
amount smallint(6) NOT NULL,
netamount smallint(6) NOT NULL,
PRIMARY KEY (tid, uid),
INDEX (uid),
INDEX (authorid)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_creditslog;
CREATE TABLE cdb_creditslog (
uid mediumint(8) UNSIGNED NOT NULL,
fromto char(15) NOT NULL,
sendcredits tinyint(1) NOT NULL,
receivecredits tinyint(1) NOT NULL,
send int(10) UNSIGNED NOT NULL,
receive int(10) UNSIGNED NOT NULL,
dateline int(10) UNSIGNED NOT NULL,
operation char(3) NOT NULL,
INDEX (uid, dateline)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_rsscaches;
CREATE TABLE cdb_rsscaches (
lastupdate int(10) UNSIGNED NOT NULL,
fid smallint(6) UNSIGNED NOT NULL,
tid mediumint(8) UNSIGNED NOT NULL,
dateline int(10) UNSIGNED NOT NULL,
forum char(50) NOT NULL,
author char(15) NOT NULL,
subject char(80) NOT NULL,
description char(255) NOT NULL,
INDEX (fid, dateline)
) TYPE=MyISAM;
EOT;
$upgrade2 = <<0;
ALTER TABLE cdb_attachments ADD INDEX (tid), CHANGE downloads downloads MEDIUMINT(8) DEFAULT '0' NOT NULL, CHANGE creditsrequire readperm tinyint(3) UNSIGNED NOT NULL, ADD description char(100) NOT NULL AFTER filename, ADD dateline int(10) UNSIGNED NOT NULL AFTER pid, ADD INDEX pid (pid, aid);
UPDATE cdb_attachments SET readperm=20 WHERE readperm>100;
EOT;
$upgrade6_3 = <<0;
EOT;
$upgrade6_4 = <<100;
EOT;
$upgrade7 = <<'member' OR (type='member' AND creditshigher>=500));
UPDATE cdb_usergroups SET raterange='' WHERE raterange LIKE '0\t0\t0\t%';
UPDATE cdb_usergroups SET allowtransfer=1, disableperiodctrl=1, maxprice=(4-groupid)*10 WHERE groupid IN (1,2,3);
ALTER TABLE cdb_usergroups DROP allowcstatus1, DROP allowavatar1, DROP allowkarma, DROP minkarmarate, DROP maxkarmarate, DROP maxrateperday, CHANGE attachextensions attachextensions CHAR(100) NOT NULL;
ALTER TABLE cdb_buddys ADD dateline int(10) UNSIGNED NOT NULL, ADD description CHAR(255) NOT NULL;
UPDATE cdb_buddys SET dateline=UNIX_TIMESTAMP();
ALTER TABLE cdb_profilefields ADD unchangeable TINYINT(1) NOT NULL AFTER required;
ALTER TABLE cdb_failedlogins ADD PRIMARY KEY (ip);
DELETE FROM cdb_settings WHERE variable IN ('maintspans');
ALTER TABLE cdb_settings ORDER BY variable;
ALTER TABLE cdb_onlinetime ADD lastupdate int(10) UNSIGNED NOT NULL;
ALTER TABLE cdb_usergroups ADD system char(8) NOT NULL default 'private' AFTER type;
UPDATE cdb_usergroups SET system='0\t0' WHERE public<>0;
ALTER TABLE cdb_usergroups DROP public;
ALTER TABLE cdb_memberfields ADD groupterms text NOT NULL AFTER ignorepm;
REPLACE INTO cdb_smilies (id, displayorder, type, code, url) VALUES ('25', '0', 'icon', '', 'icon7.gif');
UPDATE cdb_usergroups SET system='0\t0' WHERE system<>'private';
UPDATE cdb_forums SET threads=0, posts=0 WHERE type='group';
ALTER TABLE cdb_usergroups CHANGE raterange raterange CHAR(150) NOT NULL;
ALTER TABLE cdb_forums ADD alloweditrules TINYINT(1) NOT NULL AFTER allowblog, ADD allowtrade TINYINT(1) NOT NULL AFTER allowblog;
UPDATE cdb_forums SET allowtrade='3' WHERE type IN ('forum', 'sub');
DELETE FROM cdb_settings WHERE variable IN ('ec_allowposttrade', 'ec_allowpaytoauthor');
ALTER TABLE cdb_memberfields ADD alipay VARCHAR(50) NOT NULL AFTER site, ADD taobao varchar(40) NOT NULL AFTER msn;
REPLACE INTO cdb_settings (variable, value) VALUES ('modratelimit', '0');
ALTER TABLE cdb_forums ADD disablewatermark TINYINT(1) NOT NULL AFTER jammer;
EOT;
if(!$action) {
echo"本程序用于升级 Discuz! 3.1.2 到 Discuz! 4.0.0,请确认之前已经顺利安装 Discuz! 3.1.2