المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : أوامر تحويل الترميز إلى utf-8 وتخزين INNODB دفعه واحدة بدون سكربت

ملك الفضائيات
20-07-2019, 09:11 PM
شرح تحويل الترميز إلى 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','groupmessag e','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','picturecomme nt','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','groupmessa ge','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','usernam e','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
فقط للاعضاء المسجلين يمكنهم رؤية الروابط (فقط للاعضاء المسجلين يمكنهم رؤية الروابط)





منقول للفائدةفقط للاعضاء المسجلين يمكنهم رؤية الروابط
فقط للاعضاء المسجلين يمكنهم رؤية الروابط
فقط للاعضاء المسجلين يمكنهم رؤية الروابط
فقط للاعضاء المسجلين يمكنهم رؤية الروابط
فقط للاعضاء المسجلين يمكنهم رؤية الروابط
فقط للاعضاء المسجلين يمكنهم رؤية الروابط
فقط للاعضاء المسجلين يمكنهم رؤية الروابط
عماد للستلايت
10-12-2020, 04:01 PM
شكرا أخي العزيز