===2.0.1 SP1->2.0.2 Alpha 1
CREATE TABLE `boblog_plugins` (
`plid` TINYINT( 3 ) NOT NULL ,
`plname` TINYTEXT NOT NULL ,
`plauthor` TINYTEXT,
`plintro` TINYTEXT,
`plversion` TINYTEXT,
`plauthorurl` TINYTEXT,
`plblogversion` TINYTEXT NOT NULL,
`active` TINYINT( 1 ),
`pladmin` TINYINT( 1 ),
`plregister` TINYTEXT
) TYPE = MYISAM CHARACTER SET utf8;


====2.0.0.9.1222.0->2.0.1 RC1
ALTER TABLE `boblog_blogs` CHANGE `title` `title` TEXT NULL ,
CHANGE `tags` `tags` TEXT NULL ,
CHANGE `content` `content` MEDIUMTEXT NULL ,
CHANGE `weather` `weather` TINYTEXT NULL ,
CHANGE `pinged` `pinged` TEXT NULL ,
CHANGE `permitgp` `permitgp` TEXT NULL ,
CHANGE `empty2` `empty2` TEXT NULL ,
CHANGE `empty3` `empty3` TEXT NULL ,
CHANGE `empty4` `empty4` TEXT NULL ,
CHANGE `empty5` `empty5` TEXT NULL ,
CHANGE `empty6` `empty6` TEXT NULL ,
CHANGE `empty7` `empty7` TEXT NULL ,
CHANGE `empty8` `empty8` TEXT NULL ,
CHANGE `empty9` `empty9` TEXT NULL ,
CHANGE `empty10` `empty10` TEXT NULL 

ALTER TABLE `boblog_calendar` CHANGE `cyearmonth` `cyearmonth` TINYTEXT NULL ,
CHANGE `cevent` `cevent` TEXT NULL 

ALTER TABLE `boblog_categories` CHANGE `catename` `catename` TEXT NULL ,
CHANGE `catedesc` `catedesc` TEXT NULL ,
CHANGE `cateicon` `cateicon` TINYTEXT NULL ,
CHANGE `cateurl` `cateurl` TEXT NULL ,
CHANGE `empty1` `empty1` TEXT NULL ,
CHANGE `empty2` `empty2` TEXT NULL ,
CHANGE `empty3` `empty3` TEXT NULL

ALTER TABLE `boblog_linkgroup` CHANGE `linkgpname` `linkgpname` TEXT NULL ,
CHANGE `empty1` `empty1` TEXT NULL ,
CHANGE `empty2` `empty2` TEXT NULL

ALTER TABLE `boblog_links` CHANGE `linkname` `linkname` TEXT NULL ,
CHANGE `linkurl` `linkurl` TEXT NULL ,
CHANGE `linklogo` `linklogo` TEXT NULL ,
CHANGE `linkdesc` `linkdesc` TEXT NULL ,
CHANGE `empty1` `empty1` TEXT NULL ,
CHANGE `empty2` `empty2` TEXT NULL 

ALTER TABLE `boblog_messages` CHANGE `replier` `replier` TEXT NULL ,
CHANGE `repemail` `repemail` TEXT NULL ,
CHANGE `repurl` `repurl` TEXT NULL ,
CHANGE `repip` `repip` TEXT NULL ,
CHANGE `repcontent` `repcontent` TEXT NULL ,
CHANGE `adminreplier` `adminreplier` TEXT NULL ,
CHANGE `adminrepcontent` `adminrepcontent` TEXT NULL ,
CHANGE `adminrepeditor` `adminrepeditor` TEXT NULL ,
CHANGE `empty1` `empty1` TEXT NULL ,
CHANGE `empty2` `empty2` TEXT NULL ,
CHANGE `empty3` `empty3` TEXT NULL ,
CHANGE `empty4` `empty4` TEXT NULL ,
CHANGE `empty5` `empty5` TEXT NULL ,
CHANGE `empty6` `empty6` TEXT NULL ,
CHANGE `empty7` `empty7` TEXT NULL ,
CHANGE `empty8` `empty8` TEXT NULL 

ALTER TABLE `boblog_mods` CHANGE `position` `position` TEXT NULL ,
CHANGE `name` `name` TEXT NULL ,
CHANGE `desc` `desc` TEXT NULL ,
CHANGE `func` `func` TEXT NULL 

ALTER TABLE `boblog_replies` CHANGE `replier` `replier` TEXT NULL ,
CHANGE `repemail` `repemail` TEXT NULL ,
CHANGE `repurl` `repurl` TEXT NULL ,
CHANGE `repip` `repip` TEXT NULL ,
CHANGE `repcontent` `repcontent` TEXT NULL ,
CHANGE `adminreplier` `adminreplier` TEXT NULL ,
CHANGE `adminrepcontent` `adminrepcontent` TEXT NULL ,
CHANGE `adminrepeditor` `adminrepeditor` TEXT NULL ,
CHANGE `empty1` `empty1` TEXT NULL ,
CHANGE `empty2` `empty2` TEXT NULL ,
CHANGE `empty3` `empty3` TEXT NULL ,
CHANGE `empty4` `empty4` TEXT NULL ,
CHANGE `empty5` `empty5` TEXT NULL ,
CHANGE `empty6` `empty6` TEXT NULL ,
CHANGE `empty7` `empty7` TEXT NULL ,
CHANGE `empty8` `empty8` TEXT NULL 

ALTER TABLE `boblog_tags` CHANGE `tagname` `tagname` TEXT NULL ,
CHANGE `tagentry` `tagentry` TEXT NULL ,
CHANGE `tagrelate` `tagrelate` TEXT NULL 

ALTER TABLE `boblog_user` CHANGE `username` `username` TEXT NULL ,
CHANGE `userpsw` `userpsw` TEXT NULL ,
CHANGE `email` `email` TEXT NULL ,
CHANGE `homepage` `homepage` TEXT NULL ,
CHANGE `msn` `msn` TEXT NULL ,
CHANGE `intro` `intro` TEXT NULL ,
CHANGE `skype` `skype` TEXT NULL ,
CHANGE `from` `from` TEXT NULL ,
CHANGE `regip` `regip` TEXT NULL ,
CHANGE `avatar` `avatar` TEXT NULL ,
CHANGE `empty2` `empty2` TEXT NULL ,
CHANGE `empty3` `empty3` TEXT NULL ,
CHANGE `empty4` `empty4` TEXT NULL ,
CHANGE `empty5` `empty5` TEXT NULL ,
CHANGE `empty6` `empty6` TEXT NULL ,
CHANGE `empty7` `empty7` TEXT NULL ,
CHANGE `empty8` `empty8` TEXT NULL 

====2.0.0.9.1127.0->2.0.0.9.1204.0
SQL:


====2.0.0.9.1120.0->2.0.0.9.1127.0
SQL:
INSERT INTO `boblog_mods` VALUES ('sidebar', 'search', '', '1', '10', 'system')

ļ
ɾ data/cache_applylinks.php

====2.0.0.9.1113.0->2.0.0.9.1120.0
SQL:
INSERT INTO `boblog_forbidden` VALUES ('', '', '', '', '', '', '', '')
INSERT INTO `boblog_mods` VALUES ('sidebar', 'announcement', '߹', '1', '0', 'custom'), ('header', 'viewlinks', '鿴ӵ', '1', '7', 'system')


data/modules һ
$blogitem['announcement']=array('type'=>'block',	'name'=>'announcement', 'title'=>'', 'content'=>'һԹ', 'extend'=>1);

====2.0.0.9.1106.0->2.0.0.9.1113.0
SQL:
CREATE TABLE `boblog_calendar` (
`cyearmonth` TINYTEXT NOT NULL ,
`cday` INT( 2 ) DEFAULT '1' NOT NULL ,
`cid` INT( 8 ) DEFAULT '0' NOT NULL ,
`cevent` TEXT NOT NULL ,
) TYPE = MYISAM
ALTER TABLE `boblog_blogs` CHANGE `content` `content` MEDIUMTEXT NOT NULL 
ALTER TABLE `boblog_blogs` CHANGE `weather` `weather` TINYTEXT NOT NULL 
ALTER TABLE `boblog_categories` ADD `cateicon` TINYTEXT NOT NULL AFTER `catemode` , ADD `cateurl` TEXT NOT NULL AFTER `cateicon`
ALTER TABLE `boblog_blogs` CHANGE `empty1` `starred` INT( 5 ) NOT NULL DEFAULT '0'
INSERT INTO `boblog_mods` ( `position` , `name` , `desc` , `active` , `order` , `func` ) VALUES ('header', 'starred', '鿴ѼǱ־', '1', '20', 'system')

====2.0.0.9.1030.0->2.0.0.9.1106.0
SQL:
UPDATE `boblog_maxrec` SET `maxgpid` = '3' 
DROP TABLE `boblog_usergroups` 
CREATE TABLE `boblog_mods` (
`position` TEXT NOT NULL ,
`name` TEXT NOT NULL ,
`desc` TEXT NOT NULL ,
`active` INT( 1 ) DEFAULT '1' NOT NULL ,
`order` INT( 5 ) NOT NULL ,
`func` TEXT NOT NULL
) TYPE = MYISAM
INSERT INTO `boblog_mods` VALUES ('header', 'index', 'ҳ', '1', '1', 'system'), ('header', 'customrss', 'RSS', '1', '2', 'system'), ('header', 'login', '/ǳ', '1', '3', 'system'), ('header', 'modpro', '༭', '1', '4', 'system'), ('header', 'alltags', '鿴Tagsб', '1', '5', 'system'), ('header', 'guestbook', 'Ա', '1', '6', 'system'), ('header', 'togglesidebar', 'ز', '1', '7', 'system')
INSERT INTO `boblog_mods` VALUES ('sidebar', 'category', 'б', '1', '8', 'system'), ('sidebar', 'calendar', '', '1', '9', 'system'), ('sidebar', 'statistics', 'ͳ', '1', '10', 'system'), ('sidebar', 'entries', '־', '1', '11', 'system'), ('sidebar', 'replies', '', '1', '12', 'system'), ('sidebar', 'link', '', '1', '13', 'system'), ('sidebar', 'archive', '鵵', '1', '14', 'system'), ('sidebar', 'misc', 'Ϣ', '1', '15', 'system')
INSERT INTO `boblog_mods` VALUES ('footer', 'copyright', 'Ȩ', '1', '16', 'system'), ('footer', 'mii', 'Ϣҵվ', '1', '17', 'system')

data/
usergroup3.php
cache_categories.php
modules.php

====2.0.0.9.1023.0->2.0.0.9.1030.0
SQL:
ALTER TABLE `boblog_blogs` CHANGE `html` `htmlstat` INT( 1 ) NOT NULL DEFAULT '0',
CHANGE `ubb` `ubbstat` INT( 1 ) NOT NULL DEFAULT '1',
CHANGE `emot` `emotstat` INT( 1 ) NOT NULL DEFAULT '1'

====2.0.0.9.1016.0->2.0.0.9.1023.0
SQL:
ALTER TABLE `boblog_user` CHANGE `entry_num` `gender` INT( 1 ) NOT NULL DEFAULT '0'
ALTER TABLE `boblog_user` CHANGE `reply_num` `skype` TEXT NOT NULL
ALTER TABLE `boblog_user` CHANGE `empty1` `avatar` TEXT NOT NULL 
UPDATE `boblog_blogs` SET `tags`=''
TRUNCATE TABLE `boblog_tags`

FILE:
unlink ("data/cache_tags.php");
ϴ "data/cache_emot.php" CHMOD 777