|
أوامر تحويل الترميز إلى utf-8 وتخزين INNODB دفعه واحدة بدون سكربت
شرح تحويل الترميز إلى utf-8 وتخزين INNODB لقاعدة البيانات SQL دفعة واحدة وبدون سكربت و بطريقه آمنة هذا الموضوع هو الموضوع الوحيد على مستوى المنتديات العربية والأجنبية حصرياً لمعهد ترايدنت الحبيب علماً بأنه مطلوب وبكثرة ولكن بسبب الكسل العام في جميع المنتديات قررت ان اقوم بطرحه ولا أسمح بنقل الموضوع الى بذكر المصدر بسم الله نبداء اولاً يجب عمل نسخه احتياطيه لقاعدة البيانات الآن انسخ جميع الأوامر و أزرعها لكي تقوم بتغيير الترميز إلى 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 [عزيزى الزائر لايمكنك مشاهده الروابط الا بعد التسجيلللتسجيل اضغط هنا] منقول للفائدة[عزيزى الزائر لايمكنك مشاهده الروابط الا بعد التسجيلللتسجيل اضغط هنا] [عزيزى الزائر لايمكنك مشاهده الروابط الا بعد التسجيلللتسجيل اضغط هنا] [عزيزى الزائر لايمكنك مشاهده الروابط الا بعد التسجيلللتسجيل اضغط هنا] [عزيزى الزائر لايمكنك مشاهده الروابط الا بعد التسجيلللتسجيل اضغط هنا] [عزيزى الزائر لايمكنك مشاهده الروابط الا بعد التسجيلللتسجيل اضغط هنا] [عزيزى الزائر لايمكنك مشاهده الروابط الا بعد التسجيلللتسجيل اضغط هنا] [عزيزى الزائر لايمكنك مشاهده الروابط الا بعد التسجيلللتسجيل اضغط هنا] |
رد: أوامر تحويل الترميز إلى utf-8 وتخزين INNODB دفعه واحدة بدون سكربت
شكرا أخي العزيز
|
| الساعة الآن 06:22 AM |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd
جميع الحقوق محفوظة لمنتديات فنان سات
www.fanansatiraq.com