المشاركات 11,551 |
+التقييم 321 |
تاريخ التسجيل Jul 2015 |
الاقامة فى الدنيا |
نظام التشغيل windows 8 |
رقم العضوية 18 |
ALTER TABLE `access` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminhelp` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminhelp` CHANGE `script` `script` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `action` `action` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `optionname` `optionname` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `administrator` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `administrator` CHANGE `navprefs` `navprefs` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `cssprefs` `cssprefs` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `notes` `notes` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `dismissednews` `dismissednews` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `adminlog` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminlog` CHANGE `script` `script` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `action` `action` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `extrainfo` `extrainfo` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `ipaddress` `ipaddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `adminmessage` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminmessage` CHANGE `varname` `varname` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `script` `script` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `action` `action` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `execurl` `execurl` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `method` `method` ENUM('get','post') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'post', CHANGE `status` `status` ENUM('undone','done','dismissed') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'undone';
ALTER TABLE `adminutil` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `album` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `album` CHANGE `title` `title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `state` `state` ENUM('public','private','profile') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'public';
ALTER TABLE `albumpicture` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `albumupdate` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `announcement` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `announcement` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `announcementread` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachment` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachment` CHANGE `filename` `filename` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `filehash` `filehash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `posthash` `posthash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `attachmentpermission` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachmentpermission` CHANGE `extension` `extension` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
ALTER TABLE `attachmenttype` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachmenttype` CHANGE `extension` `extension` CHAR(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', CHANGE `mimetype` `mimetype` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `attachmentviews` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `avatar` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `avatar` CHANGE `title` `title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `avatarpath` `avatarpath` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `bbcode` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `bbcode` CHANGE `bbcodetag` `bbcodetag` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `bbcodereplacement` `bbcodereplacement` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `bbcodeexample` `bbcodeexample` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `bbcodeexplanation` `bbcodeexplanation` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `title` `title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `buttonimage` `buttonimage` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `bookmarksite` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `bookmarksite` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `iconpath` `iconpath` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `url` `url` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `calendar` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `calendar` CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `neweventemail` `neweventemail` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `calendarcustomfield` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `calendarcustomfield` CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `options` `options` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `calendarmoderator` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `calendarpermission` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `cpsession` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `cron` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `cron` CHANGE `minute` `minute` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `filename` `filename` CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `varname` `varname` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `cronlog` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `cronlog` CHANGE `varname` `varname` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `customavatar` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `customavatar` CHANGE `filename` `filename` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `customprofilepic` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `customprofilepic` CHANGE `filename` `filename` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `datastore` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `datastore` CHANGE `title` `title` CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `data` `data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `deletionlog` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `deletionlog` CHANGE `type` `type` ENUM('post','thread','visitormessage','groupmessage','picturecomment') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'post', CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `reason` `reason` VARCHAR(125) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `discussion` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `discussion` CHANGE `lastposter` `lastposter` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `discussionread` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `editlog` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `editlog` CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `reason` `reason` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `event` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `event` CHANGE `event` `event` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `recuroption` `recuroption` CHAR(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `customfields` `customfields` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `externalcache` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `externalcache` CHANGE `cachehash` `cachehash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `text` `text` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `headers` `headers` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `faq` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `faq` CHANGE `faqparent` `faqparent` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `forum` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `forum` CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `description_clean` `description_clean` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `newpostemail` `newpostemail` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `newthreademail` `newthreademail` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `childlist` `childlist` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `forumpermission` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `forumprefixset` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `forumprefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `forumread` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `groupmessage` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `groupmessage` CHANGE `postusername` `postusername` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `state` `state` ENUM('visible','moderation','deleted') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'visible', CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `groupmessage_hash` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `groupread` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `holiday` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `holiday` CHANGE `varname` `varname` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `recuroption` `recuroption` CHAR(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `humanverify` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `humanverify` CHANGE `hash` `hash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `answer` `answer` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `hvanswer` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `hvanswer` CHANGE `answer` `answer` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `hvquestion` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `hvquestion` CHANGE `regex` `regex` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `icon` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `icon` CHANGE `title` `title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `iconpath` `iconpath` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `imagecategory` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `imagecategory` CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `imagecategorypermission` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `infraction` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `infraction` CHANGE `note` `note` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `actionreason` `actionreason` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0';
ALTER TABLE `infractionban` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `infractionban` CHANGE `period` `period` CHAR(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `method` `method` ENUM('points','infractions') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'infractions';
ALTER TABLE `infractiongroup` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `infractionlevel` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `infractionlevel` CHANGE `period` `period` ENUM('H','D','M','N') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'H';
ALTER TABLE `ipaddress` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `ipaddress` CHANGE `contenttype` `contenttype` ENUM('groupmessage','visitormessage','picturecomment','other') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'other', CHANGE `ip` `ip` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0.0.0', CHANGE `altip` `altip` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0.0.0';
ALTER TABLE `language` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `language` CHANGE `title` `title` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `languagecode` `languagecode` VARCHAR(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `charset` `charset` VARCHAR(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `imagesoverride` `imagesoverride` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `dateoverride` `dateoverride` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `timeoverride` `timeoverride` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `registereddateoverride` `registereddateoverride` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `calformat1override` `calformat1override` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `calformat2override` `calformat2override` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `logdateoverride` `logdateoverride` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `locale` `locale` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `phrasegroup_global` `phrasegroup_global` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cpglobal` `phrasegroup_cpglobal` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cppermission` `phrasegroup_cppermission` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci NULL DEFAULT NULL, CHANGE `phrasegroup_forum` `phrasegroup_forum` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci NULL DEFAULT NULL, CHANGE `phrasegroup_calendar` `phrasegroup_calendar` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci NULL DEFAULT NULL;
ALTER TABLE `language` CHANGE `decimalsep` `decimalsep` CHAR(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '.', CHANGE `thousandsep` `thousandsep` CHAR(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ',', CHANGE `phrasegroup_global` `phrasegroup_global` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cpglobal` `phrasegroup_cpglobal` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cppermission` `phrasegroup_cppermission` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_forum` `phrasegroup_forum` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_calendar` `phrasegroup_calendar` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_attachment_image` `phrasegroup_attachment_image` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_style` `phrasegroup_style` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_logging` `phrasegroup_logging` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cphome` `phrasegroup_cphome` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `language` CHANGE `phrasegroup_promotion` `phrasegroup_promotion` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_user` `phrasegroup_user` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_help_faq` `phrasegroup_help_faq` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_sql` `phrasegroup_sql` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_subscription` `phrasegroup_subscription` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_language` `phrasegroup_language` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_bbcode` `phrasegroup_bbcode` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_stats` `phrasegroup_stats` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_diagnostic` `phrasegroup_diagnostic` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_maintenance` `phrasegroup_maintenance` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `language` CHANGE `phrasegroup_profilefield` `phrasegroup_profilefield` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_thread` `phrasegroup_thread` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_timezone` `phrasegroup_timezone` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_banning` `phrasegroup_banning` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_reputation` `phrasegroup_reputation` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_wol` `phrasegroup_wol` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_threadmanage` `phrasegroup_threadmanage` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_pm` `phrasegroup_pm` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cpuser` `phrasegroup_cpuser` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_accessmask` `phrasegroup_accessmask` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cron` `phrasegroup_cron` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_moderator` `phrasegroup_moderator` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cpoption` `phrasegroup_cpoption` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `language` CHANGE `phrasegroup_cprank` `phrasegroup_cprank` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cpusergroup` `phrasegroup_cpusergroup` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_holiday` `phrasegroup_holiday` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_posting` `phrasegroup_posting` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_poll` `phrasegroup_poll` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_fronthelp` `phrasegroup_fronthelp` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_register` `phrasegroup_register` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_search` `phrasegroup_search` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_showthread` `phrasegroup_showthread` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_postbit` `phrasegroup_postbit` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_forumdisplay` `phrasegroup_forumdisplay` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_messaging` `phrasegroup_messaging` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_inlinemod` `phrasegroup_inlinemod` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `language` CHANGE `phrasegroup_plugins` `phrasegroup_plugins` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cprofilefield` `phrasegroup_cprofilefield` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_reputationlevel` `phrasegroup_reputationlevel` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_infraction` `phrasegroup_infraction` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci NULL DEFAULT NULL, CHANGE `phrasegroup_infractionlevel` `phrasegroup_infractionlevel` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_prefix` `phrasegroup_prefix` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_socialgroups` `phrasegroup_socialgroups` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_prefixadmin` `phrasegroup_prefixadmin` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_notice` `phrasegroup_notice` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_album` `phrasegroup_album` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `mailqueue` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `mailqueue` CHANGE `toemail` `toemail` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `fromemail` `fromemail` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `subject` `subject` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `message` `message` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `header` `header` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `moderation` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `moderation` CHANGE `type` `type` ENUM('thread','reply','visitormessage','groupmessage','picturecomment') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'thread';
ALTER TABLE `moderator` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `moderatorlog` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `moderatorlog` CHANGE `action` `action` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `threadtitle` `threadtitle` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `ipaddress` `ipaddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `notice` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `notice` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `noticecriteria` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `noticecriteria` CHANGE `criteriaid` `criteriaid` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `condition1` `condition1` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `condition2` `condition2` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `condition3` `condition3` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `noticedismissed` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `passwordhistory` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `passwordhistory` CHANGE `password` `password` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `paymentapi` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `paymentapi` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `currency` `currency` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `classname` `classname` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `settings` `settings` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `paymentinfo` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `paymentinfo` CHANGE `hash` `hash` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `paymenttransaction` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `paymenttransaction` CHANGE `transactionid` `transactionid` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `currency` `currency` VARCHAR(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `request` `request` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `phrase` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `phrase` CHANGE `fieldname` `fieldname` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `text` `text` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `phrasetype` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `phrasetype` CHANGE `fieldname` `fieldname` CHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `title` `title` CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `picture` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `picture` CHANGE `caption` `caption` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `extension` `extension` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', CHANGE `idhash` `idhash` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `state` `state` ENUM('visible','moderation') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'visible';
ALTER TABLE `picturecomment` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `picturecomment` CHANGE `postusername` `postusername` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `state` `state` ENUM('visible','moderation','deleted') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'visible', CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `picturecomment_hash` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `picturecomment_hash` CHANGE `dupehash` `dupehash` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `plugin` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `plugin` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `hookname` `hookname` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `phpcode` `phpcode` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `pm` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `pmreceipt` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `pmreceipt` CHANGE `tousername` `tousername` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `pmtext` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `pmtext` CHANGE `fromusername` `fromusername` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `message` `message` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `touserarray` `touserarray` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `pmthrottle` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `podcast` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `podcast` CHANGE `author` `author` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `category` `category` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `image` `image` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `keywords` `keywords` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `owneremail` `owneremail` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `ownername` `ownername` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `subtitle` `subtitle` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `summary` `summary` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `podcastitem` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `podcastitem` CHANGE `url` `url` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `keywords` `keywords` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `subtitle` `subtitle` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `author` `author` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `poll` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `poll` CHANGE `question` `question` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `options` `options` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `votes` `votes` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `pollvote` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `post` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `post` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `ipaddress` `ipaddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `postedithistory` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `postedithistory` CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `reason` `reason` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `posthash` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `posthash` CHANGE `dupehash` `dupehash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `postindex` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `postlog` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `postlog` CHANGE `useragent` `useragent` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `ipaddress` `ipaddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `postparsed` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `postparsed` CHANGE `pagetext_html` `pagetext_html` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `prefix` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `prefixpermission` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `prefixpermission` CHANGE `prefixid` `prefixid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `prefixset` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `prefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `product` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `product` CHANGE `productid` `productid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `title` `title` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `version` `version` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `url` `url` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `productcode` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `productcode` CHANGE `productid` `productid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `version` `version` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `installcode` `installcode` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `uninstallcode` `uninstallcode` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `productdependency` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `productdependency` CHANGE `productid` `productid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `dependencytype` `dependencytype` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `parentproductid` `parentproductid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `minversion` `minversion` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `maxversion` `maxversion` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `profileblockprivacy` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `profileblockprivacy` CHANGE `blockid` `blockid` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `profilefield` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `profilefield` CHANGE `type` `type` ENUM('input','select','radio','textarea','checkbox','select_multiple') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'input', CHANGE `data` `data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `regex` `regex` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `profilefieldcategory` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `profilefieldcategory` CHANGE `location` `location` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `profilevisitor` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `ranks` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `ranks` CHANGE `rankimg` `rankimg` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `reminder` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `reminder` CHANGE `title` `title` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `text` `text` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `reputation` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `reputation` CHANGE `reason` `reason` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '';
ALTER TABLE `reputationlevel` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `rssfeed` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `rssfeed` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `url` `url` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `titletemplate` `titletemplate` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `bodytemplate` `bodytemplate` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `searchwords` `searchwords` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `itemtype` `itemtype` ENUM('thread','announcement') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'thread', CHANGE `prefixid` `prefixid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `rsslog` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `rsslog` CHANGE `itemtype` `itemtype` ENUM('thread','announcement') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'thread', CHANGE `uniquehash` `uniquehash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `contenthash` `contenthash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `search` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `search` CHANGE `ipaddress` `ipaddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `query` `query` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `searchuser` `searchuser` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `forumchoice` `forumchoice` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `sortby` `sortby` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `sortorder` `sortorder` VARCHAR(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `orderedids` `orderedids` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `announceids` `announceids` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `searchterms` `searchterms` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `displayterms` `displayterms` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `searchhash` `searchhash` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `prefixchoice` `prefixchoice` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `session` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `session` CHANGE `sessionhash` `sessionhash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `host` `host` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `idhash` `idhash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `location` `location` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `useragent` `useragent` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `setting` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `setting` CHANGE `varname` `varname` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `grouptitle` `grouptitle` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `value` `value` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `defaultvalue` `defaultvalue` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `optioncode` `optioncode` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `datatype` `datatype` ENUM('free','number','boolean','bitfield','username','integer','posint') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'free', CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `validationcode` `validationcode` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `settinggroup` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `settinggroup` CHANGE `grouptitle` `grouptitle` CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `sigparsed` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `sigparsed` CHANGE `signatureparsed` `signatureparsed` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `sigpic` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `sigpic` CHANGE `filename` `filename` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `smilie` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `smilie` CHANGE `title` `title` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `smilietext` `smilietext` CHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `smiliepath` `smiliepath` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `socialgroup` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroup` CHANGE `name` `name` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `lastposter` `lastposter` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `type` `type` ENUM('public','moderated','inviteonly') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'public', CHANGE `lastdiscussion` `lastdiscussion` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `socialgroupcategory` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroupcategory` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `socialgroupicon` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroupicon` CHANGE `extension` `extension` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `socialgroupmember` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroupmember` CHANGE `type` `type` ENUM('member','moderated','invited') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'member';
ALTER TABLE `socialgrouppicture` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `spamlog` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `stats` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `strikes` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `strikes` CHANGE `strikeip` `strikeip` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `style` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `style` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `parentlist` `parentlist` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `templatelist` `templatelist` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `csscolors` `csscolors` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `css` `css` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `stylevars` `stylevars` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `replacements` `replacements` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `editorstyles` `editorstyles` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `subscribediscussion` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribeevent` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribeforum` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribegroup` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribegroup` CHANGE `emailupdate` `emailupdate` ENUM('daily','weekly','none') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'none';
ALTER TABLE `subscribethread` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscription` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscription` CHANGE `varname` `varname` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `cost` `cost` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `forums` `forums` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `membergroupids` `membergroupids` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `subscriptionlog` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscriptionpermission` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachyforumcounter` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachyforumpost` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachyforumpost` CHANGE `lastposter` `lastposter` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `lastthread` `lastthread` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `lastprefixid` `lastprefixid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `tachythreadcounter` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachythreadpost` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachythreadpost` CHANGE `lastposter` `lastposter` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `tag` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `tag` CHANGE `tagtext` `tagtext` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `tagsearch` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `tagthread` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `template` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `template` CHANGE `title` `title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `template` `template` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `template_un` `template_un` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `templatetype` `templatetype` ENUM('template','stylevar','css','replacement') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'template', CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `version` `version` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `templatehistory` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `templatehistory` CHANGE `title` `title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `template` `template` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `version` `version` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `comment` `comment` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `thread` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `thread` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `postusername` `postusername` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `similar` `similar` VARCHAR(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `prefixid` `prefixid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `taglist` `taglist` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `threadrate` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `threadrate` CHANGE `ipaddress` `ipaddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `threadread` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `threadredirect` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `threadviews` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `upgradelog` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `upgradelog` CHANGE `script` `script` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `steptitle` `steptitle` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `user` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `user` CHANGE `membergroupids` `membergroupids` CHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `password` `password` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `email` `email` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `parentemail` `parentemail` CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `homepage` `homepage` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `icq` `icq` CHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `aim` `aim` CHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `yahoo` `yahoo` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `msn` `msn` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `skype` `skype` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `usertitle` `usertitle` CHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `timezoneoffset` `timezoneoffset` CHAR(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `birthday` `birthday` CHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `ipaddress` `ipaddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `salt` `salt` CHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `infractiongroupids` `infractiongroupids` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `useractivation` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `useractivation` CHANGE `activationid` `activationid` VARCHAR(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `userban` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `userban` CHANGE `usertitle` `usertitle` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `userchangelog` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `userchangelog` CHANGE `fieldname` `fieldname` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `newvalue` `newvalue` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `oldvalue` `oldvalue` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `usercss` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usercss` CHANGE `selector` `selector` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `property` `property` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `value` `value` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `usercsscache` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usercsscache` CHANGE `cachedcss` `cachedcss` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `userfield` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `userfield` CHANGE `temp` `temp` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `field7` `field7` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `usergroup` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usergroup` CHANGE `title` `title` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `usertitle` `usertitle` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `opentag` `opentag` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `closetag` `closetag` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `usergroupleader` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usergrouprequest` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usergrouprequest` CHANGE `reason` `reason` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `userlist` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `userlist` CHANGE `type` `type` ENUM('buddy','ignore') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'buddy', CHANGE `friend` `friend` ENUM('yes','no','pending','denied') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'no';
ALTER TABLE `usernote` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usernote` CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `message` `message` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `userpromotion` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usertextfield` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usertextfield` CHANGE `subfolders` `subfolders` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `pmfolders` `pmfolders` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `buddylist` `buddylist` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `ignorelist` `ignorelist` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `signature` `signature` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `searchprefs` `searchprefs` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `rank` `rank` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `usertitle` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usertitle` CHANGE `title` `title` CHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `visitormessage` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `visitormessage` CHANGE `postusername` `postusername` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `state` `state` ENUM('visible','moderation','deleted') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'visible', CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `visitormessage_hash` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `visitormessage_hash` CHANGE `dupehash` `dupehash` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `word` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `word` CHANGE `title` `title` CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `access` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminhelp` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminhelp` CHANGE `script` `script` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `action` `action` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `optionname` `optionname` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `administrator` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `administrator` CHANGE `navprefs` `navprefs` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `cssprefs` `cssprefs` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `notes` `notes` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `dismissednews` `dismissednews` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `adminlog` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminlog` CHANGE `script` `script` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `action` `action` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `extrainfo` `extrainfo` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `ipaddress` `ipaddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `adminmessage` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `adminmessage` CHANGE `varname` `varname` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `script` `script` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `action` `action` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `execurl` `execurl` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `method` `method` ENUM('get','post') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'post', CHANGE `status` `status` ENUM('undone','done','dismissed') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'undone';
ALTER TABLE `adminutil` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `album` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `album` CHANGE `title` `title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `state` `state` ENUM('public','private','profile') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'public';
ALTER TABLE `albumpicture` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `albumupdate` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `announcement` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `announcement` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `announcementread` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachment` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachment` CHANGE `filename` `filename` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `filehash` `filehash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `posthash` `posthash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `attachmentpermission` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachmentpermission` CHANGE `extension` `extension` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
ALTER TABLE `attachmenttype` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `attachmenttype` CHANGE `extension` `extension` CHAR(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', CHANGE `mimetype` `mimetype` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `attachmentviews` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `avatar` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `avatar` CHANGE `title` `title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `avatarpath` `avatarpath` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `bbcode` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `bbcode` CHANGE `bbcodetag` `bbcodetag` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `bbcodereplacement` `bbcodereplacement` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `bbcodeexample` `bbcodeexample` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `bbcodeexplanation` `bbcodeexplanation` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `title` `title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `buttonimage` `buttonimage` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `bookmarksite` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `bookmarksite` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `iconpath` `iconpath` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `url` `url` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `calendar` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `calendar` CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `neweventemail` `neweventemail` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `calendarcustomfield` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `calendarcustomfield` CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `options` `options` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `calendarmoderator` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `calendarpermission` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `cpsession` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `cron` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `cron` CHANGE `minute` `minute` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `filename` `filename` CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `varname` `varname` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `cronlog` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `cronlog` CHANGE `varname` `varname` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `customavatar` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `customavatar` CHANGE `filename` `filename` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `customprofilepic` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `customprofilepic` CHANGE `filename` `filename` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `datastore` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `datastore` CHANGE `title` `title` CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `data` `data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `deletionlog` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `deletionlog` CHANGE `type` `type` ENUM('post','thread','visitormessage','groupmessage','picturecomment') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'post', CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `reason` `reason` VARCHAR(125) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `discussion` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `discussion` CHANGE `lastposter` `lastposter` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `discussionread` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `editlog` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `editlog` CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `reason` `reason` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `event` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `event` CHANGE `event` `event` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `recuroption` `recuroption` CHAR(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `customfields` `customfields` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `externalcache` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `externalcache` CHANGE `cachehash` `cachehash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `text` `text` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `headers` `headers` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `faq` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `faq` CHANGE `faqparent` `faqparent` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `forum` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `forum` CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `description_clean` `description_clean` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `newpostemail` `newpostemail` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `newthreademail` `newthreademail` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `childlist` `childlist` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `forumpermission` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `forumprefixset` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `forumprefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `forumread` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `groupmessage` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `groupmessage` CHANGE `postusername` `postusername` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `state` `state` ENUM('visible','moderation','deleted') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'visible', CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `groupmessage_hash` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `groupread` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `holiday` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `holiday` CHANGE `varname` `varname` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `recuroption` `recuroption` CHAR(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `humanverify` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `humanverify` CHANGE `hash` `hash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `answer` `answer` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `hvanswer` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `hvanswer` CHANGE `answer` `answer` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `hvquestion` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `hvquestion` CHANGE `regex` `regex` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `icon` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `icon` CHANGE `title` `title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `iconpath` `iconpath` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `imagecategory` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `imagecategory` CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `imagecategorypermission` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `infraction` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `infraction` CHANGE `note` `note` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `actionreason` `actionreason` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0';
ALTER TABLE `infractionban` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `infractionban` CHANGE `period` `period` CHAR(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `method` `method` ENUM('points','infractions') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'infractions';
ALTER TABLE `infractiongroup` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `infractionlevel` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `infractionlevel` CHANGE `period` `period` ENUM('H','D','M','N') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'H';
ALTER TABLE `ipaddress` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `ipaddress` CHANGE `contenttype` `contenttype` ENUM('groupmessage','visitormessage','picturecomment','other') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'other', CHANGE `ip` `ip` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0.0.0', CHANGE `altip` `altip` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.0.0.0';
ALTER TABLE `language` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `language` CHANGE `title` `title` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `languagecode` `languagecode` VARCHAR(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `charset` `charset` VARCHAR(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `imagesoverride` `imagesoverride` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `dateoverride` `dateoverride` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `timeoverride` `timeoverride` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `registereddateoverride` `registereddateoverride` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `calformat1override` `calformat1override` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `calformat2override` `calformat2override` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `logdateoverride` `logdateoverride` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `locale` `locale` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `phrasegroup_global` `phrasegroup_global` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cpglobal` `phrasegroup_cpglobal` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cppermission` `phrasegroup_cppermission` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci NULL DEFAULT NULL, CHANGE `phrasegroup_forum` `phrasegroup_forum` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci NULL DEFAULT NULL, CHANGE `phrasegroup_calendar` `phrasegroup_calendar` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci NULL DEFAULT NULL;
ALTER TABLE `language` CHANGE `decimalsep` `decimalsep` CHAR(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '.', CHANGE `thousandsep` `thousandsep` CHAR(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ',', CHANGE `phrasegroup_global` `phrasegroup_global` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cpglobal` `phrasegroup_cpglobal` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cppermission` `phrasegroup_cppermission` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_forum` `phrasegroup_forum` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_calendar` `phrasegroup_calendar` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_attachment_image` `phrasegroup_attachment_image` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_style` `phrasegroup_style` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_logging` `phrasegroup_logging` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cphome` `phrasegroup_cphome` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `language` CHANGE `phrasegroup_promotion` `phrasegroup_promotion` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_user` `phrasegroup_user` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_help_faq` `phrasegroup_help_faq` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_sql` `phrasegroup_sql` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_subscription` `phrasegroup_subscription` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_language` `phrasegroup_language` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_bbcode` `phrasegroup_bbcode` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_stats` `phrasegroup_stats` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_diagnostic` `phrasegroup_diagnostic` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_maintenance` `phrasegroup_maintenance` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `language` CHANGE `phrasegroup_profilefield` `phrasegroup_profilefield` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_thread` `phrasegroup_thread` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_timezone` `phrasegroup_timezone` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_banning` `phrasegroup_banning` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_reputation` `phrasegroup_reputation` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_wol` `phrasegroup_wol` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_threadmanage` `phrasegroup_threadmanage` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_pm` `phrasegroup_pm` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cpuser` `phrasegroup_cpuser` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_accessmask` `phrasegroup_accessmask` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cron` `phrasegroup_cron` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_moderator` `phrasegroup_moderator` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cpoption` `phrasegroup_cpoption` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `language` CHANGE `phrasegroup_cprank` `phrasegroup_cprank` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cpusergroup` `phrasegroup_cpusergroup` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_holiday` `phrasegroup_holiday` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_posting` `phrasegroup_posting` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_poll` `phrasegroup_poll` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_fronthelp` `phrasegroup_fronthelp` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_register` `phrasegroup_register` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_search` `phrasegroup_search` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_showthread` `phrasegroup_showthread` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_postbit` `phrasegroup_postbit` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_forumdisplay` `phrasegroup_forumdisplay` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_messaging` `phrasegroup_messaging` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_inlinemod` `phrasegroup_inlinemod` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `language` CHANGE `phrasegroup_plugins` `phrasegroup_plugins` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cprofilefield` `phrasegroup_cprofilefield` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_reputationlevel` `phrasegroup_reputationlevel` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_infraction` `phrasegroup_infraction` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci NULL DEFAULT NULL, CHANGE `phrasegroup_infractionlevel` `phrasegroup_infractionlevel` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_prefix` `phrasegroup_prefix` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_socialgroups` `phrasegroup_socialgroups` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_prefixadmin` `phrasegroup_prefixadmin` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_notice` `phrasegroup_notice` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `phrasegroup_album` `phrasegroup_album` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `mailqueue` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `mailqueue` CHANGE `toemail` `toemail` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `fromemail` `fromemail` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `subject` `subject` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `message` `message` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `header` `header` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `moderation` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `moderation` CHANGE `type` `type` ENUM('thread','reply','visitormessage','groupmessage','picturecomment') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'thread';
ALTER TABLE `moderator` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `moderatorlog` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `moderatorlog` CHANGE `action` `action` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `threadtitle` `threadtitle` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `ipaddress` `ipaddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `notice` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `notice` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `noticecriteria` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `noticecriteria` CHANGE `criteriaid` `criteriaid` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `condition1` `condition1` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `condition2` `condition2` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `condition3` `condition3` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `noticedismissed` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `passwordhistory` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `passwordhistory` CHANGE `password` `password` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `paymentapi` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `paymentapi` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `currency` `currency` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `classname` `classname` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `settings` `settings` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `paymentinfo` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `paymentinfo` CHANGE `hash` `hash` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `paymenttransaction` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `paymenttransaction` CHANGE `transactionid` `transactionid` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `currency` `currency` VARCHAR(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `request` `request` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `phrase` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `phrase` CHANGE `fieldname` `fieldname` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `text` `text` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `phrasetype` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `phrasetype` CHANGE `fieldname` `fieldname` CHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `title` `title` CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `picture` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `picture` CHANGE `caption` `caption` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `extension` `extension` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', CHANGE `idhash` `idhash` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `state` `state` ENUM('visible','moderation') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'visible';
ALTER TABLE `picturecomment` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `picturecomment` CHANGE `postusername` `postusername` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `state` `state` ENUM('visible','moderation','deleted') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'visible', CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `picturecomment_hash` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `picturecomment_hash` CHANGE `dupehash` `dupehash` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `plugin` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `plugin` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `hookname` `hookname` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `phpcode` `phpcode` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `pm` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `pmreceipt` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `pmreceipt` CHANGE `tousername` `tousername` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `pmtext` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `pmtext` CHANGE `fromusername` `fromusername` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `message` `message` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `touserarray` `touserarray` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `pmthrottle` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `podcast` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `podcast` CHANGE `author` `author` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `category` `category` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `image` `image` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `keywords` `keywords` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `owneremail` `owneremail` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `ownername` `ownername` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `subtitle` `subtitle` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `summary` `summary` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `podcastitem` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `podcastitem` CHANGE `url` `url` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `keywords` `keywords` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `subtitle` `subtitle` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `author` `author` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `poll` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `poll` CHANGE `question` `question` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `options` `options` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `votes` `votes` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `pollvote` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `post` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `post` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `ipaddress` `ipaddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `postedithistory` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `postedithistory` CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `reason` `reason` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `posthash` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `posthash` CHANGE `dupehash` `dupehash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `postindex` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `postlog` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `postlog` CHANGE `useragent` `useragent` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `ipaddress` `ipaddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `postparsed` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `postparsed` CHANGE `pagetext_html` `pagetext_html` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `prefix` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `prefixpermission` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `prefixpermission` CHANGE `prefixid` `prefixid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `prefixset` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `prefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `product` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `product` CHANGE `productid` `productid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `title` `title` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `version` `version` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `url` `url` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `productcode` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `productcode` CHANGE `productid` `productid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `version` `version` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `installcode` `installcode` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `uninstallcode` `uninstallcode` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `productdependency` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `productdependency` CHANGE `productid` `productid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `dependencytype` `dependencytype` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `parentproductid` `parentproductid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `minversion` `minversion` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `maxversion` `maxversion` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `profileblockprivacy` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `profileblockprivacy` CHANGE `blockid` `blockid` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `profilefield` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `profilefield` CHANGE `type` `type` ENUM('input','select','radio','textarea','checkbox','select_multiple') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'input', CHANGE `data` `data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `regex` `regex` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `profilefieldcategory` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `profilefieldcategory` CHANGE `location` `location` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `profilevisitor` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `ranks` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `ranks` CHANGE `rankimg` `rankimg` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `reminder` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `reminder` CHANGE `title` `title` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `text` `text` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `reputation` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `reputation` CHANGE `reason` `reason` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '';
ALTER TABLE `reputationlevel` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `rssfeed` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `rssfeed` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `url` `url` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `titletemplate` `titletemplate` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `bodytemplate` `bodytemplate` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `searchwords` `searchwords` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `itemtype` `itemtype` ENUM('thread','announcement') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'thread', CHANGE `prefixid` `prefixid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `rsslog` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `rsslog` CHANGE `itemtype` `itemtype` ENUM('thread','announcement') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'thread', CHANGE `uniquehash` `uniquehash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `contenthash` `contenthash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `search` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `search` CHANGE `ipaddress` `ipaddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `query` `query` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `searchuser` `searchuser` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `forumchoice` `forumchoice` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `sortby` `sortby` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `sortorder` `sortorder` VARCHAR(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `orderedids` `orderedids` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `announceids` `announceids` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `searchterms` `searchterms` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `displayterms` `displayterms` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `searchhash` `searchhash` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `prefixchoice` `prefixchoice` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `session` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `session` CHANGE `sessionhash` `sessionhash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `host` `host` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `idhash` `idhash` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `location` `location` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `useragent` `useragent` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `setting` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `setting` CHANGE `varname` `varname` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `grouptitle` `grouptitle` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `value` `value` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `defaultvalue` `defaultvalue` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `optioncode` `optioncode` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `datatype` `datatype` ENUM('free','number','boolean','bitfield','username','integer','posint') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'free', CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `validationcode` `validationcode` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `settinggroup` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `settinggroup` CHANGE `grouptitle` `grouptitle` CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `sigparsed` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `sigparsed` CHANGE `signatureparsed` `signatureparsed` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `sigpic` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `sigpic` CHANGE `filename` `filename` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `smilie` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `smilie` CHANGE `title` `title` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `smilietext` `smilietext` CHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `smiliepath` `smiliepath` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `socialgroup` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroup` CHANGE `name` `name` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `lastposter` `lastposter` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `type` `type` ENUM('public','moderated','inviteonly') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'public', CHANGE `lastdiscussion` `lastdiscussion` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `socialgroupcategory` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroupcategory` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `socialgroupicon` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroupicon` CHANGE `extension` `extension` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `socialgroupmember` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `socialgroupmember` CHANGE `type` `type` ENUM('member','moderated','invited') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'member';
ALTER TABLE `socialgrouppicture` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `spamlog` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `stats` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `strikes` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `strikes` CHANGE `strikeip` `strikeip` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `style` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `style` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `parentlist` `parentlist` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `templatelist` `templatelist` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `csscolors` `csscolors` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `css` `css` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `stylevars` `stylevars` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `replacements` `replacements` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `editorstyles` `editorstyles` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `subscribediscussion` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribeevent` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribeforum` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribegroup` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscribegroup` CHANGE `emailupdate` `emailupdate` ENUM('daily','weekly','none') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'none';
ALTER TABLE `subscribethread` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscription` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscription` CHANGE `varname` `varname` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `cost` `cost` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `forums` `forums` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `membergroupids` `membergroupids` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `subscriptionlog` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `subscriptionpermission` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachyforumcounter` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachyforumpost` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachyforumpost` CHANGE `lastposter` `lastposter` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `lastthread` `lastthread` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `lastprefixid` `lastprefixid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `tachythreadcounter` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachythreadpost` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `tachythreadpost` CHANGE `lastposter` `lastposter` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `tag` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `tag` CHANGE `tagtext` `tagtext` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `tagsearch` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `tagthread` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `template` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `template` CHANGE `title` `title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `template` `template` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `template_un` `template_un` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `templatetype` `templatetype` ENUM('template','stylevar','css','replacement') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'template', CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `version` `version` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `product` `product` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `templatehistory` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `templatehistory` CHANGE `title` `title` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `template` `template` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `version` `version` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `comment` `comment` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `thread` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `thread` CHANGE `title` `title` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `postusername` `postusername` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `similar` `similar` VARCHAR(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `prefixid` `prefixid` VARCHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `taglist` `taglist` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `threadrate` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `threadrate` CHANGE `ipaddress` `ipaddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `threadread` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `threadredirect` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `threadviews` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `upgradelog` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `upgradelog` CHANGE `script` `script` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `steptitle` `steptitle` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `user` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `user` CHANGE `membergroupids` `membergroupids` CHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `password` `password` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `email` `email` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `parentemail` `parentemail` CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `homepage` `homepage` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `icq` `icq` CHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `aim` `aim` CHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `yahoo` `yahoo` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `msn` `msn` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `skype` `skype` CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `usertitle` `usertitle` CHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `timezoneoffset` `timezoneoffset` CHAR(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `birthday` `birthday` CHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `ipaddress` `ipaddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `salt` `salt` CHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `infractiongroupids` `infractiongroupids` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `useractivation` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `useractivation` CHANGE `activationid` `activationid` VARCHAR(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `userban` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `userban` CHANGE `usertitle` `usertitle` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `userchangelog` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `userchangelog` CHANGE `fieldname` `fieldname` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `newvalue` `newvalue` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `oldvalue` `oldvalue` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `usercss` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usercss` CHANGE `selector` `selector` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `property` `property` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `value` `value` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `usercsscache` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usercsscache` CHANGE `cachedcss` `cachedcss` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `userfield` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `userfield` CHANGE `temp` `temp` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `field7` `field7` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `usergroup` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usergroup` CHANGE `title` `title` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `usertitle` `usertitle` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `opentag` `opentag` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `closetag` `closetag` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `usergroupleader` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usergrouprequest` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usergrouprequest` CHANGE `reason` `reason` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `userlist` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `userlist` CHANGE `type` `type` ENUM('buddy','ignore') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'buddy', CHANGE `friend` `friend` ENUM('yes','no','pending','denied') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'no';
ALTER TABLE `usernote` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usernote` CHANGE `username` `username` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `message` `message` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `userpromotion` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usertextfield` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usertextfield` CHANGE `subfolders` `subfolders` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `pmfolders` `pmfolders` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `buddylist` `buddylist` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `ignorelist` `ignorelist` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `signature` `signature` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `searchprefs` `searchprefs` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `rank` `rank` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `usertitle` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `usertitle` CHANGE `title` `title` CHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `visitormessage` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `visitormessage` CHANGE `postusername` `postusername` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `state` `state` ENUM('visible','moderation','deleted') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'visible', CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `visitormessage_hash` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `visitormessage_hash` CHANGE `dupehash` `dupehash` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `word` ENGINE = INNODB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `word` CHANGE `title` `title` CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `word` CHANGE `title` `title` CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''; ALTER TABLE `tag` CHANGE `tagtext` `tagtext` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''; ALTER TABLE `userfield` CHANGE `temp` `temp` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `field7` `field7` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; هذا فيه تحذير ALTER TABLE `usergroup` CHANGE `title` `title` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `description` `description` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `usertitle` `usertitle` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `opentag` `opentag` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `closetag` `closetag` CHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
اضافة رد
|
شرح تحويل الترميز إلى utf-8 وتخزين INNODB لقاعدة البيانات SQL دفعة واحدة وبدون سكربت
|
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
شرح عمل نسخة احتياطية لقاعدة البيانات من خلال phpmyadmin | هيلبرنت | ركن تطوير منتديات vb3.8.0 | 9 | 07-26-2021 10:42 PM |
[ vBulletin 4 ] : هاك اخذ نسخه احتياطيه لقاعدة البيانات والجداول للجيل الرابع | هيلبرنت | ركن تطوير المنتديات vB 4.0.0 | 1 | 01-26-2021 09:56 PM |
حذف جميع الصور الرمزية دفعة واحدة | هيلبرنت | ركن شروحات الزين فورو XENFORO | 0 | 12-02-2015 11:05 PM |
أسهل طريقة لتأكيد طلبات الصدقة دفعة واحدة | هيلبرنت | ركن مواقع التواصل الإجتماعي | 2 | 10-08-2015 04:49 PM |
شرح طريقة حذف جميع التغريدات على تويتر دفعة واحدة | هيلبرنت | ركن مواقع التواصل الإجتماعي | 0 | 10-06-2015 11:05 PM |