هذا الموضوع هو الموضوع الوحيد على مستوى المنتديات العربية والأجنبية حصرياً لمعهد ترايدنت الحبيب
علماً بأنه مطلوب وبكثرة ولكن بسبب الكسل العام في جميع المنتديات قررت ان اقوم بطرحه
ولا أسمح بنقل الموضوع الى بذكر المصدر
بسم الله نبداء
اولاً يجب عمل نسخه احتياطيه لقاعدة البيانات
الآن انسخ جميع الأوامر و أزرعها لكي تقوم بتغيير الترميز إلى utf-8 بجميع الجداول والحقول وكذلك يقوم بتعديل القيم الى القيمه الافتراضيه الصحيحه (أنصح به)
رمز PHP:
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 latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cpglobal` `phrasegroup_cpglobal` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `phrasegroup_cppermission` `phrasegroup_cppermission` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `phrasegroup_forum` `phrasegroup_forum` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `phrasegroup_calendar` `phrasegroup_calendar` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_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 latin1 COLLATE latin1_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 '';
وهذا شرح تنفيذ زراعه أمر في قاعدة البيانات
1 عزيزى العضو \ الزائر لايمكنك مشاهده الروابط الا بعد الرد
2 عزيزى العضو \ الزائر لايمكنك مشاهده الروابط الا بعد الرد
3 عزيزى العضو \ الزائر لايمكنك مشاهده الروابط الا بعد الرد
التعليمات الإدارية
نور المنتدى بالعضو الجديد
« آخـــر الــمــواضــيــع »
20-07-2019, 09:11 PM
أوامر تحويل الترميز إلى utf-8 وتخزين INNODB دفعه واحدة بدون سكربت
رد: أوامر تحويل الترميز إلى utf-8 وتخزين INNODB دفعه واحدة بدون سكربت
العرض العادي
