تنبيه مهم لأصحاب الترميز cp1256 وقاموا بالترقية لـ 3.7.0

ALTER TABLE `album` CHANGE `title` `title` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `description` `description` TEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL ,
CHANGE `state` `state` ENUM( 'public', 'private', 'profile' ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL DEFAULT 'public

ALTER TABLE `bookmarksite` CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `iconpath` `iconpath` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `url` `url` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `forumprefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `groupmessage` CHANGE `postusername` `postusername` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `state` `state` ENUM( 'visible', 'moderation', 'deleted' ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL DEFAULT 'visible',
CHANGE `title` `title` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL

ALTER TABLE `groupmessage_hash` CHANGE `dupehash` `dupehash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `humanverify` CHANGE `hash` `hash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `answer` `answer` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL

ALTER TABLE `hvanswer` CHANGE `answer` `answer` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `hvquestion` CHANGE `regex` `regex` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `notice` CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `noticecriteria` CHANGE `criteriaid` `criteriaid` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `condition1` `condition1` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `condition2` `condition2` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `condition3` `condition3` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `picture` CHANGE `caption` `caption` TEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL ,
CHANGE `extension` `extension` VARCHAR( 20 ) CHARACTER SET cp1256 COLLATE cp1256_bin NOT NULL ,
CHANGE `idhash` `idhash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `picturecomment` CHANGE `postusername` `postusername` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `state` `state` ENUM( 'visible', 'moderation', 'deleted' ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL DEFAULT 'visible',
CHANGE `title` `title` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `picturecomment_hash` CHANGE `dupehash` `dupehash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `postedithistory` CHANGE `username` `username` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `reason` `reason` VARCHAR( 200 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL

ALTER TABLE `postlog` CHANGE `useragent` `useragent` CHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `prefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `prefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `socialgroup` CHANGE `name` `name` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `description` `description` TEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL ,
CHANGE `lastposter` `lastposter` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `type` `type` ENUM( 'public', 'moderated', 'inviteonly' ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL DEFAULT 'public'

ALTER TABLE `socialgroupmember` CHANGE `type` `type` ENUM( 'member', 'moderated', 'invited' ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL DEFAULT 'member'

ALTER TABLE `tag` CHANGE `tagtext` `tagtext` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `uploadcategorys` CHANGE `title` `title` TEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL ,
CHANGE `username` `username` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `uploadfiles` CHANGE `username` `username` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `file` `file` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `path` `path` VARCHAR( 50 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `userchangelog` CHANGE `fieldname` `fieldname` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `newvalue` `newvalue` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `oldvalue` `oldvalue` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `change_uniq` `change_uniq` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `usercss` CHANGE `selector` `selector` VARCHAR( 30 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `property` `property` VARCHAR( 30 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `value` `value` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `usercsscache` CHANGE `cachedcss` `cachedcss` TEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL

ALTER TABLE `visitormessage` CHANGE `postusername` `postusername` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `state` `state` ENUM( 'visible', 'moderation', 'deleted' ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL DEFAULT 'visible',
CHANGE `title` `title` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL

ALTER TABLE `visitormessage_hash` CHANGE `dupehash` `dupehash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `prefix` CHANGE `prefixid` `prefixid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

ALTER TABLE `postlog` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `postedithistory` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `profilevisitor` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `albumpicture` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `bookmarksite` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `forumprefixset` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `groupmessage` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `groupmessage_hash` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `humanverify` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `hvanswer` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `hvquestion` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `notice` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `noticecriteria` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `picture` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `picturecomment` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `picturecomment_hash` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `prefix` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `prefixset` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `socialgroup` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `socialgroupmember` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `socialgrouppicture` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `spamlog` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `tachyforumcounter` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `tachythreadcounter` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `tag` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `tagsearch` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `tagthread` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `uploadfiles` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `userchangelog` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `usercss` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `usercsscache` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `visitormessage` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `visitormessage_hash` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

ALTER TABLE `uploadcategorys` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci