gistfile1.txt

lojjik@doh:~/VANILLA_UPGRADE/vanilla/upgrade (master)$ ./upgrade
* Loading configuration
* Dropping tables from new database ...
	- Dropping GDN_Category
	- Dropping GDN_Comment
	- Dropping GDN_Discussion
	- Dropping GDN_User
	- Dropping GDN_UserAuthentication
* Getting a dump of old database vanilla ...
* Importing old tables into new database ...
* Running alter statements ...
	- ALTER TABLE GDN_Category ADD COLUMN `TreeLeft` int(11) DEFAULT NULL;
	- ALTER TABLE GDN_Category ADD COLUMN `TreeRight` int(11) DEFAULT NULL;
	- ALTER TABLE GDN_Category ADD COLUMN `Depth` int(11) DEFAULT NULL;
	- ALTER TABLE GDN_Category ADD COLUMN `CountComments` int(11) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Category ADD COLUMN `DateMarkedRead` datetime DEFAULT NULL;
	- ALTER TABLE GDN_Category ADD COLUMN `Archived` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Category MODIFY COLUMN `Name` varchar(255) COLLATE utf8_unicode_ci NOT NULL;
	- ALTER TABLE GDN_Category MODIFY COLUMN `UrlCode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_Category MODIFY COLUMN `Description` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_Category ADD COLUMN `CssClass` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_Category ADD COLUMN `Photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_Category ADD COLUMN `PermissionCategoryID` int(11) NOT NULL DEFAULT '-1';
	- ALTER TABLE GDN_Category ADD COLUMN `HideAllDiscussions` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Category ADD COLUMN `DisplayAs` enum('Categories','Discussions','Default') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Default';
	- ALTER TABLE GDN_Category ADD COLUMN `LastCommentID` int(11) DEFAULT NULL;
	- ALTER TABLE GDN_Category ADD COLUMN `LastDiscussionID` int(11) DEFAULT NULL;
	- ALTER TABLE GDN_Category ADD COLUMN `LastDateInserted` datetime DEFAULT NULL;
	- ALTER TABLE GDN_Comment ADD COLUMN `InsertIPAddress` varchar(39) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_Comment ADD COLUMN `UpdateIPAddress` varchar(39) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_Discussion ADD COLUMN `Type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_Discussion ADD COLUMN `ForeignID` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_Discussion MODIFY COLUMN `UpdateUserID` int(11) DEFAULT NULL;
	- ALTER TABLE GDN_Discussion ADD COLUMN `FirstCommentID` int(11) DEFAULT NULL;
	- ALTER TABLE GDN_Discussion MODIFY COLUMN `CountComments` int(11) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Discussion MODIFY COLUMN `DateInserted` datetime NOT NULL;
	- ALTER TABLE GDN_Discussion MODIFY COLUMN `DateUpdated` datetime DEFAULT NULL;
	- ALTER TABLE GDN_Discussion ADD COLUMN `InsertIPAddress` varchar(39) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_Discussion ADD COLUMN `UpdateIPAddress` varchar(39) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_Discussion ADD COLUMN `RegardingID` int(11) DEFAULT NULL;
	- ALTER TABLE GDN_Permission ADD COLUMN `Garden.Email.View` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Permission ADD COLUMN `Garden.Settings.View` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Permission ADD COLUMN `Garden.Activity.View` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Permission ADD COLUMN `Garden.Profiles.View` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Permission ADD COLUMN `Garden.Profiles.Edit` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Permission ADD COLUMN `Garden.Moderation.Manage` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Permission ADD COLUMN `Garden.Curation.Manage` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Permission ADD COLUMN `Garden.PersonalInfo.View` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Permission ADD COLUMN `Garden.AdvancedNotifications.Allow` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Permission ADD COLUMN `Conversations.Moderation.Manage` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Permission ADD COLUMN `Conversations.Conversations.Add` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Permission ADD COLUMN `Vanilla.Approval.Require` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Permission ADD COLUMN `Vanilla.Comments.Me` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Tag MODIFY COLUMN `Name` varchar(255) COLLATE utf8_unicode_ci NOT NULL;
	- ALTER TABLE GDN_Tag ADD COLUMN `Type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_Tag ADD COLUMN `CategoryID` int(11) NOT NULL DEFAULT '-1';
	- ALTER TABLE GDN_TagDiscussion ADD COLUMN `CategoryID` int(11) NOT NULL;
	- ALTER TABLE GDN_TagDiscussion ADD COLUMN `DateInserted` datetime DEFAULT NULL;
	- ALTER TABLE GDN_User MODIFY COLUMN `Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL;
	- ALTER TABLE GDN_User MODIFY COLUMN `Password` varbinary(100) NOT NULL;
	- ALTER TABLE GDN_User ADD COLUMN `Title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_User ADD COLUMN `Location` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_User MODIFY COLUMN `Gender` enum('u','m','f') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'u';
	- ALTER TABLE GDN_User ADD COLUMN `LastIPAddress` varchar(39) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_User ADD COLUMN `AllIPAddresses` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_User ADD COLUMN `InsertIPAddress` varchar(39) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_User ADD COLUMN `UpdateIPAddress` varchar(39) COLLATE utf8_unicode_ci DEFAULT NULL;
	- ALTER TABLE GDN_User ADD COLUMN `Verified` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_User ADD COLUMN `Banned` tinyint(4) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_User ADD COLUMN `Points` int(11) NOT NULL DEFAULT '0';
	- ALTER TABLE GDN_Activity ENGINE=BLACKHOLE;
* Fixing category structure ...
* Setting up jsconnect SSO for Vanilla <-> wikiHow integration
* Migration complete