gistfile1.txt

alter table `project` modify `title` varchar(500) COLLATE utf8_unicode_ci NOT NULL;
alter table `user_profile` modify `description` varbinary(25600) NOT NULL DEFAULT '';
alter table `article_metadata` modify `references` mediumblob NOT NULL;
alter table `collection_version` modify   `title` varchar(500) COLLATE utf8_unicode_ci NOT NULL;
alter table `file_metadata` modify `title` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '';
alter table `blog` modify `tags` varbinary(1000) NOT NULL DEFAULT '[]';
alter table `group_metadata` modify `flags` varbinary(10000) NOT NULL DEFAULT '{}';
alter table `oauth_temporary_token` modify `oauth_token` char(255) COLLATE utf8_unicode_ci NOT NULL;
alter table `oauth_access_token` modify `oauth_token` varchar(255) COLLATE utf8_unicode_ci NOT NULL;
alter table `oauth_consumer` modify `zone_public` int(11) NOT NULL;
alter table `oauth_consumer` modify `zone_private` int(11) NOT NULL;
alter table `oauth_consumer` modify `account_id` bigint(20) unsigned NOT NULL;
alter table `oauth_consumer` modify `description` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '';
alter table `article` modify `title` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '';
alter table `user_account` modify `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP;
alter table `file_metadata` modify `description` blob NOT NULL DEFAULT '';
alter table `article_version` modify `title` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '';
alter table `collection` modify `title` varchar(500) COLLATE utf8_unicode_ci NOT NULL;
alter table `private_link` modify `expires_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP;
alter table `user_collaboration` modify `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP;
alter table `notification` modify `due_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP;
alter table `project_metadata` modify  `description` varbinary(25600) NOT NULL DEFAULT '';