ÔÑÍ ÊÍæíá ÇáÊÑãíÒ Åáì utf-8 æÊÎÒíä INNODB áÞÇÚÏÉ ÇáÈíÇäÇÊ SQL ÏÝÚÉ æÇÍÏÉ æÈÏæä ÓßÑÈÊ - ÔÈßÉ åãÓ ÇáÔæÞ
{♥ ÈãäÇÓÈÉ ãÑæÑ 15 ÚÇã ÚÞÏðÇ æäÕÝðÇ Úáì ÊÃÓíÓ ÔÈßÉ åãÓ ÇáÔæÞ ãä ÊãíÒ Çáì ÊãíÒ ♥}  
   

 

 

         :: íÇ ÓÇßäå ( ÇáßÇÊÈ : ÊÇíå )       :: ÊÕäíÝ ÇÚÖÇÁ ÇáãäÊÏíÇÊ ( ÇáßÇÊÈ : ÊææÝå ÇáÍÑÈí )       :: ÇÒíÇÁ ááãÍÌÈÇÊ ( ÇáßÇÊÈ : ÊææÝå ÇáÍÑÈí )       :: ßÈÉ ÇáÈÑÛá ÇáÔÇãíÉ ( ÇáßÇÊÈ : ÊææÝå ÇáÍÑÈí )       :: äÙÝí ÇáÓãß ÌíÏÇð ( ÇáßÇÊÈ : ÊææÝå ÇáÍÑÈí )       :: ÞÏãí ÇáÞÑÕÇä ÓÇÎäÇð Ýí ØÈÞ ßÈíÑ ( ÇáßÇÊÈ : ÊææÝå ÇáÍÑÈí )       :: ßä ßÇáÓÚÇÏÉ ( ÇáßÇÊÈ : ÊææÝå ÇáÍÑÈí )       :: ÑæÇÆÚ ÇáÔÚÑ ÇáÚÑÇÞí/ÓÚÏí íæÓÝ/ÈÇÈ ÓáíãÇä ( ÇáßÇÊÈ : åãÓÉ ÇáÔæÞ )       :: ÑæÇÆÚ ÇáÔÚÑ ÇáÚÑÇÞí/ÚÈÏÇáÑÍãä ÇáÓæíÏí/ÍÒãÊ ÇáÚáã ãä ÕÛÑ Çáì Çä ( ÇáßÇÊÈ : åãÓÉ ÇáÔæÞ )       :: ÑæÇÆÚ ÇáÔÚÑ ÇáÚÑÇÞí/äÇÒß ÇáãáÇÆßÉ/ÇäÔæÏÉ ÇáÇãæÇÊ ( ÇáßÇÊÈ : åãÓÉ ÇáÔæÞ )      

ÅÖÇÝÉ ÅåÏÇÁ

 
 
   
{ ÇÚáÇäÇÊ ÔÈßÉ åãÓ ÇáÔæÞ ) ~
 
 
 
   
ÝóÚÇáíöÇÊ ÔÈóßÉ åãóÓ ÇáÔõæÞö
 
 
Elegant Rose - Double Heart
 ÛíÑ ãÓÌá  : ÈÕÝÊß ÃÍÏ ÑßÇÆÒ ÇáãäÊÏì æÃÚÖÇÆå ÇáÝÇÚáíä ¡ íÓÑ ÇáÅÏÇÑÉ Ãä ÊÊÞÏã áß ÈÇáÔßÑ ÇáÌÒíá Úáì ÌåæÏß ÇáÑÇÆÚå .. æÊÃãá ãäß ÝÖáÇð áÇ ÃãÑÇð ÇáãÔÇÑßÉ Ýí ÃÛáÈ ÇáÃÞÓÇã æÊÔÌíÚ ßÇÝÉ ÇáÃÚÖÇÁ ÈÇáÑÏæÏ Úáíåã æÇáÊÝÇÚá ãÚåã ÈÞÏÑ ÇáãÓÊØÇÚ . ( Èßã äÑÊÞí . ÛíÑ ãÓÌá  . æÈßã äÊØæÑ ) åãÓ ÇáÔæÞ

ÇÎí ÇáÒÇÆÑ áÏíß ÑÓÇáÉ ÎÇÕÉ ãä ÔÈßÉ åãÓ ÇáÔæÞ ááÞÑÇÁÉ ! ÇÖÛØ åäÇ !

ÇáÚæÏÉ   ÔÈßÉ åãÓ ÇáÔæÞ > åãÓ ÊØæíÑ ÇáãæÇÞÚ > ÔÑæÍÇÊ æÎæÇÕ ÇáÝí Èí ÇáãäÞæáå
ÊÍÏíË ÇáÕÝÍÉ ÔÑÍ ÊÍæíá ÇáÊÑãíÒ Åáì utf-8 æÊÎÒíä INNODB áÞÇÚÏÉ ÇáÈíÇäÇÊ SQL ÏÝÚÉ æÇÍÏÉ æÈÏæä ÓßÑÈÊ
äÓíÊ ßáãÉ ÇáãÑæÑ ÇÖÛØ åäÇ ÇáÊÓÌíá
ÇáÊÓÌíá ÇáÊÚáíãÜÜÜÇÊ ÞÇÆãÉ ÇáÃÚÖÇÁ ÇáÊÞæíã ãæÇÖíÚ áÇ ÑÏæÏ áåÇ ÇáÈÍË ãÔÇÑßÇÊ Çáíæã ÇÌÚá ßÇÝÉ ÇáÃÞÓÇã ãÞÑæÁÉ

ÔÑæÍÇÊ æÎæÇÕ ÇáÝí Èí ÇáãäÞæáå ÔÑæÍÇÊ æÏÑæÓ æÃÝßÇÑ æÃÓÑÇÑ æÊÝÚíá ÎæÇÕ ãäÊÏíÇÊ ÇáÝí Èí

ÔÑÍ ÊÍæíá ÇáÊÑãíÒ Åáì utf-8 æÊÎÒíä INNODB áÞÇÚÏÉ ÇáÈíÇäÇÊ SQL ÏÝÚÉ æÇÍÏÉ æÈÏæä ÓßÑÈÊ

Çáíæã ÓíÊã ÔÑÍ ÃæÇãÑ ÊÍæíá ÇáÊÑãíÒ Åáì utf-8 æÊÎÒíä INNODB ÏÝÚå æÇÍÏÉ ÈÏæä ÓßÑÈÊ æ ÈØÑíÞå ÂãäÉ æÇáØÑíÞÉ ãÌÑÈÉ ãä ÞÈá ÇáÇÎ R a K a n ãÔÑÝ ÈÊÑÇíÏäÊ

ÅäÔÇÁ ãæÖæÚ ÌÏíÏ  ÅÖÇÝÉ ÑÏ

ÈÍË Íæá ÇáãæÖæÚ ÇäÔÑ Úáí FaceBook ÇäÔÑ Úáí twitter
ÇáÚæÏå ááÕÝÍå ÇáÑÆíÓíå ááãäÊÏì ÇäÔÇÁ ãæÖæÚ ÌÏíÏ ÑÏæÏ Çáíæã ÔÑÍ ÊÍæíá ÇáÕÝÍÉ ÇáÑÆíÓíÉ Åáì ÕÝÍÉ ÇáãäÊÏì vb/ÈÔßá ãÈÇÔÑ ÚäÏ ÇáÏÎæá -
 
LinkBack ÃÏæÇÊ ÇáãæÖæÚ ÇäæÇÚ ÚÑÖ ÇáãæÖæÚ
#1  
ÞÏíã 18 - 11 - 2025, 04:03 AM
åãÓ ÇáÔæÞ ÛíÑ ãÊæÇÌÏ ÍÇáíÇð
Saudi Arabia     Male
SMS ~ [ + ]
áä ÃäÏã Úáì Ãí ÔíÁ
ÏÎá ÍíÇÊí æíÑíÏ ÇáÑÍíá
ÝÇáãÎáÕ ÃÓÚÏäí
æÇáÓíÁ ãäÍäí ÇáÊÌÑÈå
æÇáÃÓæà ßÇä ÏÑÓÇð áí
ãÔÇåÏÉ ÃæÓãÊí
 ÚÖæíÊí » 1
 ÌíÊ ÝíÐÇ » 14 - 11 - 2010
 ÂÎÑ ÍÖæÑ » Çáíæã (07:46 AM)
 ÝÊÑÉÇáÇÞÇãÉ » 5502íæã
 ÇáãÓÊæì » $60 [♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥]
  ÇáäÔÇØ Çáíæãí » 1.46
ãæÇÖíÚí » 4092
ÇáÑÏæÏ » 3940
ÚÏÏãÔÇÑßÇÊí » 8,032
äÞÇØí ÇáÊÞííã » 23992
 ÇÈÍË Úä » ãæÇÖíÚí ❤ ÑÏæÏí
ÊáÞíÊ ÅÚÌÇÈ » 2199
ÇáÇÚÌÇÈÇÊ ÇáãÑÓáÉ » 633
 ÇáÇÞÇãå » ÇáØÇÆÝ
 ÍÇáí Ýí » ÇáÓÚæÏíå
ÏæáÊí ÇáÍÈíÈå » ÏæáÊì ÇáÍÈíÈåSaudi Arabia
ÌäÓí  » Male
ÇáÚãÑ  » 33 ÓäÉ
ÇáÍÇáÉ ÇáÇÌÊãÇÚíÉ  » ãÑÊÈØ
 ÇáÊÞííã » åãÓ ÇáÔæÞ has a reputation beyond reputeåãÓ ÇáÔæÞ has a reputation beyond reputeåãÓ ÇáÔæÞ has a reputation beyond reputeåãÓ ÇáÔæÞ has a reputation beyond reputeåãÓ ÇáÔæÞ has a reputation beyond reputeåãÓ ÇáÔæÞ has a reputation beyond reputeåãÓ ÇáÔæÞ has a reputation beyond reputeåãÓ ÇáÔæÞ has a reputation beyond reputeåãÓ ÇáÔæÞ has a reputation beyond reputeåãÓ ÇáÔæÞ has a reputation beyond reputeåãÓ ÇáÔæÞ has a reputation beyond repute
ãÔÑæÈì ÇáãÝÖá  » ãÔÑæÈì ÇáãÝÖá bison
ÇáÔæßæáÇÊå ÇáãÝÖáå  » ÇáÔæßæáÇÊå ÇáãÝÖáå twix
ÞäÇÊß ÇáãÝÖáÉ  » ÞäÇÊß ÇáãÝÖáÉfnoun
äÇÏíß ÇáãÝÖá  » äÇÏíß ÇáãÝÖánaser
ÓÈÇÑÊí ÇáãÝÖáå  » ÓÈÇÑÊí ÇáãÝÖáåBentley
Êã ÔßÑí »  34
ÔßÑÊ » 62
 
ÔßÑÇð: 62
Êã ÔßÑå 34 ãÑÉ Ýí 30 ãÔÇÑßÉ
E ÔÑÍ ÊÍæíá ÇáÊÑãíÒ Åáì utf-8 æÊÎÒíä INNODB áÞÇÚÏÉ ÇáÈíÇäÇÊ SQL ÏÝÚÉ æÇÍÏÉ æÈÏæä ÓßÑÈÊ
Facebook Twitter
ãáÇÍÙÉ åÇãÉ áÞÑÇÁ ÇáãæÖæÚ ♥ ÛíÑ ãÓÌá ♥
ÞÈá ÞÑÇÁÊß ááãæÖæÚ äæÏ ÅÈáÇÛß ÈÃäå ÞÏ íÍÊæí ÇáãæÖæÚ Úáì ÚÈÇÑÇÊ Çæ ÕæÑ áÇ ÊäÇÓÈ ÇáÈÚÖ
ÝÅä ßäÊ ãä ÇáÃÚÖÇÁ ÇáÊí áÇ ÊÚÌÈåã åÐå ÇáãæÇÖíÚ .. æÊÓÊÇÁ ãä ÞÑÇÆÊåÇ .. ÝäÞÏã áß
ÈÇÓã ÅÏÇÑÉ ÇáÔÈßÉ æßÇÊÈ ÇáãæÖæÚ .. ÇáÃÓÝ ÇáÔÏíÏ .. æäÊãäì ãäß ÚÏã ÞÑÇÁÉ ÇáãæÖæÚ
æÝí ÍÇá ÞÑÇÆÊß ááãæÖæÚ .. äÊãäì ãäß Çä ÑÛÈÊ ÈßÊÇÈÉ ÑÏ
Ãä ÊÈÊÚÏ ÈÑÏæÏß Úä ÇáÓÎÑíÉ æÇáÔÊÇÆã .. ÝåÐÇ ÞÏ íÚÑÖß ááØÑÏ Ãæ áÍÐÝ ãÔÇÑßÊß
ÅÏÇÑÉ ÔÈßÉ ( åãÓ ÇáÔæÞ )

 



Çáíæã ÓíÊã ÔÑÍ ÃæÇãÑ ÊÍæíá ÇáÊÑãíÒ Åáì utf-8 æÊÎÒíä INNODB ÏÝÚå æÇÍÏÉ ÈÏæä ÓßÑÈÊ æ ÈØÑíÞå ÂãäÉ


æÇáØÑíÞÉ ãÌÑÈÉ ãä ÞÈá ÇáÇÎ R a K a n ãÔÑÝ ÈÊÑÇíÏäÊ ÝÇáãæÖæÚ ÍÕÑì áåã æãÇÞãäÇ åäÇ Óæì ÇáäÞá ãäåã ÝÞØ



[ íÊæÇÝÞ ãÚ Çí ÇÕÏÇÑ ] : ÌãíÚ ÇÕÏÇÑÇÊ vbulletin 3.8
[ ÈæÇÓØÉ ] : äÞáÇ Úä R a K a n


ÇæáÇð : íÌÈ Úãá äÓÎå ÇÍÊíÇØíå áÞÇÚÏÉ ÇáÈíÇäÇÊ

ËÇäíÇ: ÇäÓÎ ÌãíÚ ÇáÃæÇãÑ æ ÃÒÑÚåÇ áßí ÊÞæã ÈÊÛííÑ


ÇáÊÑãíÒ Åáì utf-8 ÈÌãíÚ ÇáÌÏÇæá æÇáÍÞæá æßÐáß íÞæã


ÈÊÚÏíá ÇáÞíã Çáì ÇáÞíãå ÇáÇÝÊÑÇÖíå ÇáÕÍíÍå (ÃäÕÍ Èå)


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


 ÔÑÍ ÎØæÇÊ ÊäÝíÐ ÒÑÇÚå ÃãÑ Ýí ÞÇÚÏÉ ÇáÈíÇäÇÊ
utf-8 INNODB ÇáÈíÇäÇÊ do.php?img=51062

utf-8 INNODB ÇáÈíÇäÇÊ do.php?img=51063

utf-8 INNODB ÇáÈíÇäÇÊ do.php?img=51064


ÇäÓÎ ÌãíÚ ÇáÃæãÑ æÇÒÑÚåÇ áÊÞæã ÈÊÛííÑ ÇáÊÑãíÒ Åáì utf-8 ãÚ ÇáÊÎÒíä INNODB æáÇ ÃäÕÍ ÈÏÑÇÌ ÇáÃãÑ


ÈÇáßÇãá Èá ßá 3 ÕÝæÝ ãä ÇáÇæÇãÑ æßÐáß ÇäÓÎ ÓØÑ æÇÍÏ ááÌÏÇæá ÇáßÈíÑå ,,, ÇáÓÈÈ Çä Úãáíå ÊÍæíá ÇáÊÎÒíä ÊÃÎÐ


æÞÊ Øæíá æÊÓÈÈ ÈÚÖ ÇáÇÍíÇä Çáì ÇÓÊåáÇß ÇáÎÇÏã áÐáß áÇ ÇäÕÍ Èå ÇáÇ ááÖÑæÑå ÇáÞÕæì

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



ÇáãæÖæÚ ÇáÃÕáí : ÔÑÍ ÊÍæíá ÇáÊÑãíÒ Åáì utf-8 æÊÎÒíä INNODB áÞÇÚÏÉ ÇáÈíÇäÇÊ SQL ÏÝÚÉ æÇÍÏÉ æÈÏæä ÓßÑÈÊ || ÇáßÇÊÈ : åãÓ ÇáÔæÞ || ÇáãÕÏÑ : ÔÈßÉ åãÓ ÇáÔæÞ

 





ÑÏ ãÚ ÇÞÊÈÇÓ

ÑÓÇáÉ áßá ÒæÇÑ ãäÊÏíÇÊ ÔÈßÉ åãÓ ÇáÔæÞ

ÚÒíÒí ÇáÒÇÆÑ ÃÊãäì Çäß ÇÓÊÝÏÊ ãä ÇáãæÖæÚ æáßä ãä ÇÌá  ãäÊÏíÇÊ ÔÈßÉ åãÓ ÇáÔæÞ  íÑÌÇÁ ÐßÑ ÇáãÕÏÑÚäÏ äÞáß áãæÖæÚ æíãßäß ÇáÊÓÌíá ãÚäÇ æÇáãÔÇÑßÉ ãÚäÇ æÇáäÞÇÔ Ýí ßÇÝå ÇáãæÇÖíÚ ÇáÌÇÏå ÇÐÇ ÑÛÈÊ Ýí ÐÇáß ÝÇäÇ áÇ ÇÏÚæß ááÊÓÌíá Èá ÇÏÚæß ááÅÈÏÇÚ ãÚäÇ . ááÊÓÌíá ÇÖÛÙ åäÇ .

ÞÏíã 18 - 11 - 2025, 10:51 AM   #2


ÇáÕæÑÉ ÇáÑãÒíÉ äÇØÞ ÇáÚÈíÏí

 ÚÖæíÊí » 4738
 ÌíÊ ÝíÐÇ » 10 - 9 - 2015
 ÂÎÑ ÍÖæÑ » íæã ÃãÓ (08:36 PM)
 ÝÊÑÉÇáÇÞÇãÉ » 3741íæã
ãæÇÖíÚí » 1036
ÇáÑÏæÏ » 9194
ÚÏÏ ÇáãÔÇÑßÇÊ » 10,230
äÞÇØ ÇáÊÞííã » 17886
 ÇÈÍË Úä » ãæÇÖíÚí ❤ ÑÏæÏí
ÊáÞíÊ ÅÚÌÇÈ » 967
ÇáÇÚÌÇÈÇÊ ÇáãÑÓáÉ » 2307
 ÇáãÓÊæì » $65 [♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥]
 ÍÇáí Ýí » ÇáÚÑÇÞ
ÏæáÊí ÇáÍÈíÈå » ÏæáÊì ÇáÍÈíÈåIraq
ÌäÓí  » Male
ÇáÚãÑ  » .. ÓäÉ
ÇáÍÇáÉ ÇáÇÌÊãÇÚíÉ  » ãÑÊÈØå
ãÔÑæÈì ÇáãÝÖá  » ãÔÑæÈì ÇáãÝÖá cola
ÇáÔæßæáÇÊå ÇáãÝÖáå  » ÇáÔæßæáÇÊå ÇáãÝÖáå galaxy
ÞäÇÊß ÇáãÝÖáÉ  » ÞäÇÊß ÇáãÝÖáÉfox
äÇÏíß ÇáãÝÖá  » äÇÏíß ÇáãÝÖábarcelona
ÓíÇÑÊí ÇáãÝÖáå  » ÓíÇÑÊí ÇáãÝÖáåBMW
Êã ÔßÑí »  21
ÔßÑÊ » 0
 
ÔßÑÇð: 0
Êã ÔßÑå 21 ãÑÉ Ýí 19 ãÔÇÑßÉ

ÇÕÏÇÑ ÇáÝæÊæÔæÈ : Adobe Photoshop CS3 My Camera: Panasonic

MMS ~
MMS ~


 
ÇáÇæÓãå ÇáÍÇÕá ÚáíåÇ
 
æÓÇã / ÞíãÉ ÇáäÞØÉ: 50 ÇáÍÖæÑ ÇáããíÒ / ÞíãÉ ÇáäÞØÉ: 100 æÓÇã äÌãÉ ÇáÇÓÈæÚ / ÞíãÉ ÇáäÞØÉ: 100 æÓÇã / ÞíãÉ ÇáäÞØÉ: 127 æÓÇã ÇáÖíÇÝå / ÞíãÉ ÇáäÞØÉ: 70
ãÌãæÚ ÇáÃæÓãÉ: 5...) (ÇáãÒíÏ»

ãÌãæÚ ÇáÃæÓãÉ: 5

äÇØÞ ÇáÚÈíÏí ÛíÑ ãÊæÇÌÏ ÍÇáíÇð

ÇÝÊÑÇÖí ÑÏ: ÔÑÍ ÊÍæíá ÇáÊÑãíÒ Åáì utf-8 æÊÎÒíä INNODB áÞÇÚÏÉ ÇáÈíÇäÇÊ SQL ÏÝÚÉ æÇÍÏÉ æÈÏæä Óß


íÚØíß ÇáÝ ÇáÝ ÚÇÝíå
ãæÖæÚ ÑÇÇÇÆÚ æÌåæÏ ÃÑæÚ
ääÊÙÑ ãÒíÏßã ÈÔæææÞ



ÑÏ ãÚ ÇÞÊÈÇÓ
ÞÏíã 25 - 11 - 2025, 03:58 AM   #3


ÇáÕæÑÉ ÇáÑãÒíÉ ÊææÝå ÇáÍÑÈí

 ÚÖæíÊí » 5609
 ÌíÊ ÝíÐÇ » 1 - 8 - 2019
 ÂÎÑ ÍÖæÑ » íæã ÃãÓ (11:37 AM)
 ÝÊÑÉÇáÇÞÇãÉ » 2320íæã
ãæÇÖíÚí » 272
ÇáÑÏæÏ » 76413
ÚÏÏ ÇáãÔÇÑßÇÊ » 76,685
äÞÇØ ÇáÊÞííã » 15850
 ÇÈÍË Úä » ãæÇÖíÚí ❤ ÑÏæÏí
ÊáÞíÊ ÅÚÌÇÈ » 864
ÇáÇÚÌÇÈÇÊ ÇáãÑÓáÉ » 828
 ÇáãÓÊæì » $117 [♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥]
 ÍÇáí Ýí » ÔÈßÉ åãÓ ÇáÔæÞ
ÏæáÊí ÇáÍÈíÈå » ÏæáÊì ÇáÍÈíÈåSaudi Arabia
ÌäÓí  » Female
ÇáÚãÑ  » 25 ÓäÉ
ÇáÍÇáÉ ÇáÇÌÊãÇÚíÉ  » ãÑÊÈØå
ãÔÑæÈì ÇáãÝÖá  » ãÔÑæÈì ÇáãÝÖá bison
ÇáÔæßæáÇÊå ÇáãÝÖáå  » ÇáÔæßæáÇÊå ÇáãÝÖáå baunty
ÞäÇÊß ÇáãÝÖáÉ  » ÞäÇÊß ÇáãÝÖáÉline-sport
äÇÏíß ÇáãÝÖá  » äÇÏíß ÇáãÝÖáhilal
ÓíÇÑÊí ÇáãÝÖáå  » ÓíÇÑÊí ÇáãÝÖáå
Êã ÔßÑí »  24
ÔßÑÊ » 0
 
ÔßÑÇð: 0
Êã ÔßÑå 24 ãÑÉ Ýí 23 ãÔÇÑßÉ

ÇÕÏÇÑ ÇáÝæÊæÔæÈ : Adobe Photoshop 7,0 My Camera: Sony

MMS ~
MMS ~


 
ÇáÇæÓãå ÇáÍÇÕá ÚáíåÇ
 
æÓÇã / ÞíãÉ ÇáäÞØÉ: 100 æÓÇã / ÞíãÉ ÇáäÞØÉ: 127 æÓÇã / ÞíãÉ ÇáäÞØÉ: 100 æÓÇã / ÞíãÉ ÇáäÞØÉ: 127 æÓÇã / ÞíãÉ ÇáäÞØÉ: 127 æÓÇã / ÞíãÉ ÇáäÞØÉ: 100 æÓÇã ÇáÊæÇÕá / ÞíãÉ ÇáäÞØÉ: 100 æÓÇã / ÞíãÉ ÇáäÞØÉ: 100 æÓÇã / ÞíãÉ ÇáäÞØÉ: 100 æÓÇã ÇáÇÏÇÑå / ÞíãÉ ÇáäÞØÉ: 80 æÓÇã / ÞíãÉ ÇáäÞØÉ: 100 æÓÇã äÌã ÇáÇÓÈæÚ / ÞíãÉ ÇáäÞØÉ: 0 æÓÇã ÇáÖíÇÝå / ÞíãÉ ÇáäÞØÉ: 70
ãÌãæÚ ÇáÃæÓãÉ: 13...) (ÇáãÒíÏ»

ãÌãæÚ ÇáÃæÓãÉ: 13

ÊææÝå ÇáÍÑÈí ÛíÑ ãÊæÇÌÏ ÍÇáíÇð

ÇÝÊÑÇÖí ÑÏ: ÔÑÍ ÊÍæíá ÇáÊÑãíÒ Åáì utf-8 æÊÎÒíä INNODB áÞÇÚÏÉ ÇáÈíÇäÇÊ SQL ÏÝÚÉ æÇÍÏÉ æÈÏæä Óß


Çááå íÚØíß ÇáÚÇÝíÉ



ÑÏ ãÚ ÇÞÊÈÇÓ
ÅäÔÇÁ ãæÖæÚ ÌÏíÏ  ÅÖÇÝÉ ÑÏ

ãæÇÞÚ ÇáäÔÑ (ÇáãÝÖáÉ)

ÇáßáãÇÊ ÇáÏáÇáíÉ (Tags)
áÞÇÚÏÉ, ÇãÊÍÇäÇÊ, ÇáÊÑãíÒ, ÊÍæíá, innodb, ÏÝÚÊ, ÔÑÍ, ÓßÑÈÊ, sql, utf-8, åáí, äÇÌÍÉ, æÊÍÓíä, æÈÏæä

ÔÑÍ ÊÍæíá ÇáÊÑãíÒ Åáì utf-8 æÊÎÒíä INNODB áÞÇÚÏÉ ÇáÈíÇäÇÊ SQL ÏÝÚÉ æÇÍÏÉ æÈÏæä ÓßÑÈÊ


ÇáÐíä íÔÇåÏæä ãÍÊæì ÇáãæÖæÚ ÇáÂä : 2 ( ÇáÃÚÖÇÁ 0 æÇáÒæÇÑ 2)
 

ÇáÃÚÖÇÁ ÇáÐíä ÞÇãæÇ ÈÊÞííã åÐÇ ÇáãæÖæÚ : 0
áã íÞæã ÃÍÏ ÈÊÞííã åÐÇ ÇáãæÖæÚ

ÃÏæÇÊ ÇáãæÖæÚ
ÇäæÇÚ ÚÑÖ ÇáãæÖæÚ
ÇáÚÑÖ ÇáÚÇÏí ÇáÚÑÖ ÇáÚÇÏí

ÊÚáíãÇÊ ÇáãÔÇÑßÉ
áÇ ÊÓÊØíÚ ÅÖÇÝÉ ãæÇÖíÚ ÌÏíÏÉ
áÇ ÊÓÊØíÚ ÇáÑÏ Úáì ÇáãæÇÖíÚ
áÇ ÊÓÊØíÚ ÅÑÝÇÞ ãáÝÇÊ
áÇ ÊÓÊØíÚ ÊÚÏíá ãÔÇÑßÇÊß
BB code is ãÊÇÍÉ
ßæÏ [IMG] ãÊÇÍÉ
ßæÏ HTML ãÚØáÉ
Trackbacks are ãÊÇÍÉ
Pingbacks are ãÊÇÍÉ
Refbacks are ãÊÇÍÉ

ÇáãæÇÖíÚ ÇáãÊÔÇÈåå áãæÖæÚ: ÔÑÍ ÊÍæíá ÇáÊÑãíÒ Åáì utf-8 æÊÎÒíä INNODB áÞÇÚÏÉ ÇáÈíÇäÇÊ SQL ÏÝÚÉ æÇÍÏÉ æÈÏæä ÓßÑÈÊ áãæÖæÚ: ÔÑÍ ÊÍæíá ÇáÊÑãíÒ Åáì utf-8 æÊÎÒíä INNODB áÞÇÚÏÉ ÇáÈíÇäÇÊ SQL ÏÝÚÉ æÇÍÏÉ æÈÏæä ÓßÑÈÊ
ÇáãæÖæÚ ßÇÊÈ ÇáãæÖæÚ ÇáãäÊÏì ãÔÇÑßÇÊ ÂÎÑ ãÔÇÑßÉ
åÇß ÊÞáíá ÅÓÊåáÇß äÞá ÇáÈíÇäÇÊ ÇáÈÇäÏæíË æÊÍÓíä ÃÏÇÁ ÇáãäÊÏì ãÝíÏ ÇáÜÜÓÜÜÇåÑ åãÓ ÊØæíÑ ÇáãæÇÞÚ æÇáãäÊÏíÇÊ 2 10 - 11 - 2025 01:41 PM
ãáÝ ÇááÛÉ ááÅÕÏÇÑ vb3.8.11 æÃíÖÇ ÇáÊÑãíÒ UTF-8 åãÓ ÇáÔæÞ åãÓ ÊÍãíá ÇÕÏÇÑÇÊ vbulletin 3.8.x 2 27 - 8 - 2025 12:06 PM
ßæÏ ÊÍæíá ÇáÑæÇÈØ ãËá ÇáÝí Èí Óíæ æÈÏæä Çí ãÔÇßá ááäÓÎ 3 8 5 ÇáÜÜÓÜÜÇåÑ åãÓ ÊØæíÑ ÇáãæÇÞÚ æÇáãäÊÏíÇÊ 5 3 - 5 - 2025 04:28 PM
ßæÏ ÊÍæíá ÇáÑæÇÈØ ãËá ÇáÝí Èí Óíæ æÈÏæä Çí ãÔÇßá ááäÓÎ ÇáÜÜÓÜÜÇåÑ ÔÑæÍÇÊ æÎæÇÕ ÇáÝí Èí ÇáãäÞæáå 2 28 - 11 - 2023 06:17 AM
áßä ßÓÑåÇ áÞÇÚÏÉ åÇ áãÊíäÇÊ åãÓ ÇáÔæÞ åãÓ ÇáÔÚÑ æÇáÞæÇÝí 4 29 - 3 - 2017 11:49 AM

Google Pagerank mérés, keresőoptimalizálás

 

{ÞÇá ÊÚÇáì:"Åä ÇáÕáÇÉ ßÇäÊ Úáì ÇáãÄãäíä ßÊÇÈÇ ãæÞæÊÇ" }
   
||

ÇáÓÇÚÉ ÇáÂä 12:16 PM


ÔÈßÉ åãÓ ÇáÔæÞ - ÇáÃÑÔíÝ - ÞæÇäíä ÇáãäÊÏì - ãäÚ ÇáÒÎÇÑÝ - ÎÑíÙÉ ÇáãäÊÏì - ÇáÃÚáì

ÌãíÚ ÇáÍÞæÞ ãÍÝæÙå ááãäÊÏì
HêĽм √ 3.1 BY: ! ωαнαм ! © 2010
User Alert System provided by Advanced User Tagging (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
ÎÑÇÆØ ÔÈßÉ åãÓ ÇáÔæÞ

SEO by vBSEO