-
Notifications
You must be signed in to change notification settings - Fork 431
Upgrading from 3.1.6 to 3.2.0
lincanbin edited this page Nov 9, 2014
·
8 revisions
alter table `carbon_tags` add COLUMN `Followers` int(10) unsigned DEFAULT '0';
alter table `carbon_topics` add COLUMN `Favorites` int(10) unsigned DEFAULT '0';
alter table `carbon_users` add COLUMN `Followers` int(10) unsigned DEFAULT '0';
alter table `carbon_favorites` ADD UNIQUE `IsFavorite` (`UserID`,`Type`,`FavoriteID`);
INSERT INTO `carbon_config` (`ConfigName`, `ConfigValue`) VALUES ('CacheOauth', ''),('DaysUsers', '0'), ('DaysPosts', '0'), ('DaysTopics', '0'), ('DaysDate', '2014-11-01');
drop index `UserTopics` on `carbon_topics` ;
alter table `carbon_topics` ADD index `UserTopics` (`UserName`,`IsDel`,`LastTime`);
drop index `UserPosts` on `carbon_posts` ;
alter table `carbon_posts` ADD index `UserPosts` (`UserName`,`IsDel`,`PostTime`);
ALTER TABLE `carbon_blogsettings` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_favorites` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_link` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_log` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_messages` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_tags` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_pictures` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_postrating` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_posts` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_posttags` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_roles` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_statistics` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_blogs` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_topics` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_upload` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_users` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_blogs` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `carbon_vote` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Carbon Forum
A high performance open-source forum software written in PHP.