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

 

 

         :: ÈÑæÏßÊ áÚÑÖ ãæÇÖíÚß æãæÇÖíÚ ÇáÇÚÖÇÁ ÇÓÝá ÇáÊæÞíÚ ÊÞæíÉ ÇáÇÑÔÝÉ ( ÇáßÇÊÈ : ÇáÜÜÓÜÜÇåÑ )       :: ÈäÊ ÇáÕÍä ( ÇáßÇÊÈ : ÓíÝ ÇáÚãæÑ )       :: ÊÓÌíá ÇáÍÖæÑ Çáíæãí áÌãíÚ ÇáãÑÇÞÈíä æÇáãÔÑÝíä ( ÇáßÇÊÈ : ÓíÝ ÇáÚãæÑ )       :: åÇß ÃÑÔÝäí ÂÎÑ ÅÕÏÇÑ ÇáÍÒãå ÇáÃÞæì áÊÍÓíä ÚáÇÞÉ ãäÊÏÇß ( ÇáßÇÊÈ : ÓíÝ ÇáÚãæÑ )       :: ÍßãÉ Çáíæã ( ÇáßÇÊÈ : ÓíÝ ÇáÚãæÑ )       :: æÍÏå ÊÓÃá ÃÎæåÇ ( ÇáßÇÊÈ : ÊææÝå ÇáÍÑÈí )       :: ÊÇÑíÎ ÇáÚÑÇÞ ÇáÞÏíã ÇáÇáå äíäæÑäÇ Ýí ÈáÇÏ ÇáÑÇÝÏíä ( ÇáßÇÊÈ : ÓíÝ ÇáÚãæÑ )       :: ÇÞÏã ÚÔÑÉ ãÓÇÌÏ Ýí ÇáÚÑÇÞ ( ÇáßÇÊÈ : ÓíÝ ÇáÚãæÑ )       :: áÇ ÊÓÊÞá áÍÙÉ ÊÓÊÛÝÑ Çááå ÊÚÇáì ÝíåÇ ( ÇáßÇÊÈ : ÓíÝ ÇáÚãæÑ )       :: ÇáæÍÏÉ áíÓÊ ÈÐáß ÇáÓæÁ ( ÇáßÇÊÈ : ÓíÝ ÇáÚãæÑ )      

ÓíÝ ÇáÚãæÑ ãä ÇáÃÏÑÉ : ÃÎí ÇáÒÇÆÑ ÃÎÊö ÇáÒÇÆÑÉ ßæäæÇ ãÊÃßÏíä ÈÇäßã ãåãíä ÈÇáäÓÈÉ áäÇ ÝáåãæÇ æáÇ ÊÈÎáæÇ ÚáíäÇ æÈÇÏÑæÇ ÈÇáÊÓÌíá äÍä ÌãíÚÇð ÈÇäÊÙÇÑßã
ÅÖÇÝÉ ÅåÏÇÁ

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

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

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

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

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

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


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

ÚÏÏ ÇáÑÏæÏ : 3   - ÇáãÔÇåÏÇÊ 304   -   ßæÏ ÚÏã ÇáäÓÎ ááÒÇÆÑÇáãæÖæÚ ÇáÓÇÈÞ  -  åÇß ÊÍæíá ÇáÕæÑÉ ÇáÓÇÈÞÉ ÇáÕæÑÉ ÇáÊÇáíÉ Ýí ÇáÃáÈæã Åáì ÊÞäíÉ Ajax ÈÇÏÆ ÇáãæÖæÚÇáãæÖæÚ ÇáÊÇáí  -    ÇáãÊæÇÌÏæä ÍÇáíÇ : 
ÅäÔÇÁ ãæÖæÚ ÌÏíÏ  ÅÖÇÝÉ ÑÏ

ÈÍË Íæá ÇáãæÖæÚ ÇäÔÑ Úáí FaceBook ÇäÔÑ Úáí twitter
ÇáÚæÏå ááÕÝÍå ÇáÑÆíÓíå ááãäÊÏì ÇäÔÇÁ ãæÖæÚ ÌÏíÏ ÑÏæÏ Çáíæã ßæÏ ÚÏã ÇáäÓÎ ááÒÇÆÑ åÇß ÊÍæíá ÇáÕæÑÉ ÇáÓÇÈÞÉ ÇáÕæÑÉ ÇáÊÇáíÉ Ýí ÇáÃáÈæã Åáì ÊÞäíÉ Ajax ÈÇÏÆ ÇáãæÖæÚ
 
LinkBack ÃÏæÇÊ ÇáãæÖæÚ ÇäæÇÚ ÚÑÖ ÇáãæÖæÚ
#1  
ÞÏíã 18 - 11 - 2025, 04:03 AM
åãÓ ÇáÔæÞ ÛíÑ ãÊæÇÌÏ ÍÇáíÇð
Saudi Arabia     Male
SMS ~ [ + ]
áä ÃäÏã Úáì Ãí ÔíÁ
ÏÎá ÍíÇÊí æíÑíÏ ÇáÑÍíá
ÝÇáãÎáÕ ÃÓÚÏäí
æÇáÓíÁ ãäÍäí ÇáÊÌÑÈå
æÇáÃÓæà ßÇä ÏÑÓÇð áí
ãÔÇåÏÉ ÃæÓãÊí
 ÚÖæíÊí » 1
 ÌíÊ ÝíÐÇ » 14 - 11 - 2010
 ÂÎÑ ÍÖæÑ » 7 - 7 - 2026 (08:05 PM)
 ÝÊÑÉÇáÇÞÇãÉ » 5724íæã
 ÇáãÓÊæì » $97 [♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥]
  ÇáäÔÇØ Çáíæãí » 6.82
ãæÇÖíÚí » 4278
ÇáÑÏæÏ » 34765
ÚÏÏãÔÇÑßÇÊí » 39,043
äÞÇØí ÇáÊÞííã » 84223
 ÇÈÍË Úä » ãæÇÖíÚí ❤ ÑÏæÏí
ÊáÞíÊ ÅÚÌÇÈ » 2683
ÇáÇÚÌÇÈÇÊ ÇáãÑÓáÉ » 1072
 ÇáÇÞÇãå » ÇáØÇÆÝ
 ÍÇáí Ýí » ÇáÓÚæÏíå
ÏæáÊí ÇáÍÈíÈå » ÏæáÊì ÇáÍÈíÈå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
Êã ÔßÑí »  240
ÔßÑÊ » 444
 
ÔßÑÇð: 444
Êã ÔßÑå 240 ãÑÉ Ýí 192 ãÔÇÑßÉ
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 æáÇ ÃäÕÍ ÈÏÑÇÌ ÇáÃãÑ


ÈÇáßÇãá Èá ßá 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 '';

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

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

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


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

 ÚÖæíÊí » 4738
 ÌíÊ ÝíÐÇ » 10 - 9 - 2015
 ÂÎÑ ÍÖæÑ » íæã ÃãÓ (01:24 PM)
 ÝÊÑÉÇáÇÞÇãÉ » 3963íæã
ãæÇÖíÚí » 1068
ÇáÑÏæÏ » 15588
ÚÏÏ ÇáãÔÇÑßÇÊ » 16,656
äÞÇØ ÇáÊÞííã » 42186
 ÇÈÍË Úä » ãæÇÖíÚí ❤ ÑÏæÏí
ÊáÞíÊ ÅÚÌÇÈ » 1150
ÇáÇÚÌÇÈÇÊ ÇáãÑÓáÉ » 2816
 ÇáãÓÊæì » $76 [♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥]
 ÍÇáí Ýí » ÇáÚÑÇÞ
ÏæáÊí ÇáÍÈíÈå » ÏæáÊì ÇáÍÈíÈåIraq
ÌäÓí  » Male
ÇáÚãÑ  » .. ÓäÉ
ÇáÍÇáÉ ÇáÇÌÊãÇÚíÉ  » ãÑÊÈØå
ãÔÑæÈì ÇáãÝÖá  » ãÔÑæÈì ÇáãÝÖá cola
ÇáÔæßæáÇÊå ÇáãÝÖáå  » ÇáÔæßæáÇÊå ÇáãÝÖáå galaxy
ÞäÇÊß ÇáãÝÖáÉ  » ÞäÇÊß ÇáãÝÖáÉfox
äÇÏíß ÇáãÝÖá  » äÇÏíß ÇáãÝÖábarcelona
ÓíÇÑÊí ÇáãÝÖáå  » ÓíÇÑÊí ÇáãÝÖáåBMW
Êã ÔßÑí »  108
ÔßÑÊ » 0
 
ÔßÑÇð: 0
Êã ÔßÑå 108 ãÑÉ Ýí 101 ãÔÇÑßÉ

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

MMS ~
MMS ~


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

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

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

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


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



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


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

 ÚÖæíÊí » 5609
 ÌíÊ ÝíÐÇ » 1 - 8 - 2019
 ÂÎÑ ÍÖæÑ » Çáíæã (01:12 AM)
 ÝÊÑÉÇáÇÞÇãÉ » 2541íæã
ãæÇÖíÚí » 292
ÇáÑÏæÏ » 77674
ÚÏÏ ÇáãÔÇÑßÇÊ » 77,966
äÞÇØ ÇáÊÞííã » 43400
 ÇÈÍË Úä » ãæÇÖíÚí ❤ ÑÏæÏí
ÊáÞíÊ ÅÚÌÇÈ » 1013
ÇáÇÚÌÇÈÇÊ ÇáãÑÓáÉ » 929
 ÇáãÓÊæì » $118 [♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥]
 ÍÇáí Ýí » ÔÈßÉ åãÓ ÇáÔæÞ
ÏæáÊí ÇáÍÈíÈå » ÏæáÊì ÇáÍÈíÈåSaudi Arabia
ÌäÓí  » Female
ÇáÚãÑ  » 25 ÓäÉ
ÇáÍÇáÉ ÇáÇÌÊãÇÚíÉ  » ãÑÊÈØå
ãÔÑæÈì ÇáãÝÖá  » ãÔÑæÈì ÇáãÝÖá bison
ÇáÔæßæáÇÊå ÇáãÝÖáå  » ÇáÔæßæáÇÊå ÇáãÝÖáå baunty
ÞäÇÊß ÇáãÝÖáÉ  » ÞäÇÊß ÇáãÝÖáÉline-sport
äÇÏíß ÇáãÝÖá  » äÇÏíß ÇáãÝÖáhilal
ÓíÇÑÊí ÇáãÝÖáå  » ÓíÇÑÊí ÇáãÝÖáå
Êã ÔßÑí »  136
ÔßÑÊ » 0
 
ÔßÑÇð: 0
Êã ÔßÑå 136 ãÑÉ Ýí 125 ãÔÇÑßÉ

ÇÕÏÇÑ ÇáÝæÊæÔæÈ : 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 ÏÝÚÉ æÇÍÏÉ æÈÏæä Óß


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



ÑÏ ãÚ ÇÞÊÈÇÓ
ÞÏíã 2 - 1 - 2026, 03:44 PM   #4


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

 ÚÖæíÊí » 4738
 ÌíÊ ÝíÐÇ » 10 - 9 - 2015
 ÂÎÑ ÍÖæÑ » íæã ÃãÓ (01:24 PM)
 ÝÊÑÉÇáÇÞÇãÉ » 3963íæã
ãæÇÖíÚí » 1068
ÇáÑÏæÏ » 15588
ÚÏÏ ÇáãÔÇÑßÇÊ » 16,656
äÞÇØ ÇáÊÞííã » 42186
 ÇÈÍË Úä » ãæÇÖíÚí ❤ ÑÏæÏí
ÊáÞíÊ ÅÚÌÇÈ » 1150
ÇáÇÚÌÇÈÇÊ ÇáãÑÓáÉ » 2816
 ÇáãÓÊæì » $76 [♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥♥ Bé-Yêu ♥]
 ÍÇáí Ýí » ÇáÚÑÇÞ
ÏæáÊí ÇáÍÈíÈå » ÏæáÊì ÇáÍÈíÈåIraq
ÌäÓí  » Male
ÇáÚãÑ  » .. ÓäÉ
ÇáÍÇáÉ ÇáÇÌÊãÇÚíÉ  » ãÑÊÈØå
ãÔÑæÈì ÇáãÝÖá  » ãÔÑæÈì ÇáãÝÖá cola
ÇáÔæßæáÇÊå ÇáãÝÖáå  » ÇáÔæßæáÇÊå ÇáãÝÖáå galaxy
ÞäÇÊß ÇáãÝÖáÉ  » ÞäÇÊß ÇáãÝÖáÉfox
äÇÏíß ÇáãÝÖá  » äÇÏíß ÇáãÝÖábarcelona
ÓíÇÑÊí ÇáãÝÖáå  » ÓíÇÑÊí ÇáãÝÖáåBMW
Êã ÔßÑí »  108
ÔßÑÊ » 0
 
ÔßÑÇð: 0
Êã ÔßÑå 108 ãÑÉ Ýí 101 ãÔÇÑßÉ

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

MMS ~
MMS ~


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

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

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

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


ÊÓáã ÃäÇãáß ÚÇáØÑÍ ÇáÑÇÆÜÚ
áÂÍÑãäÜÇ Çááå ÑæÚÉ ãæÃÖíÚß
ÔßÑÇ áãÌåæÏß ÇáããíÜÒ
ÏãÊ ÞáãÇÇ ãÈÏÚÇ Èíä ØíÇÊ ÇáãäÊÏì



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

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

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

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


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

ÇáÃÚÖÇÁ ÇáÐíä ÞÇãæÇ ÈÊÞííã åÐÇ ÇáãæÖæÚ : 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

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

ÚÏÏ ÇáÑÏæÏ : 3  ; , ÚÏÏ ÒæÇÑ ÇáãæÖæÚ :304

ãä ÇÚÏÇÏ ÇáÚÖæ   : åãÓ ÇáÔæÞ , Ýí ÞÓã : ÔÑæÍÇÊ æÎæÇÕ ÇáÝí Èí ÇáãäÞæáå
Google Pagerank mérés, keresőoptimalizálás

 

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

||

ÃÞÓÇã ÇáãäÊÏì

åãÓ ááÃÞÓÇã ÇáÚÇãå @ åãÓ ááäÞÇÔ æÇáÍæÇÑ ÇáÌÇÏ @ åãÓ ÇáãæÇÖíÚ ÇáÚÇãÉ @ åãÓ ááÊÑÍíÈ ÈÇáÇÚÖÇÁ ÇáÌÏÏ æÇáÊÚÇÑÝ @ åãÓ ááÕæÑ æÇáÛÑÇÆÈ @ åãÓ ááÓíÇÍå æÇáÓÝÑ @ åãÓ ááÃÞÓÇã ÇáÑíÇÖíå @ åãÓ ááÓíÇÑÇÊ æÇáÏÑÇÌÇÊ ÇáäÇÑíå @ åãÓ ÚÐÈ ÇáßáÇã æÇáÎæÇØÑ ÇáãäÞæáå @ åãÓ æÚÇáã ÍæÇÁ @ åãÓ ÚÇáã ÍæÇÁ @ åãÓ ÚÇáã ÇÏã ÇÒíÇÁ ÇáÑÌá ÚÇáã ÇáÑÌá ÇáÚÕÑí @ åãÓ ãØÈÎ ÍæÇÁ @ åãÓ ááÃËÇË æÇáÏíßæÑ @ åãÓ ßÑÓí ÇáÇÚÊÑÇÝ @ åãÓ ááÊÑÝíå æÇáÊÓáíå @ åãÓ ááÇáÚÇÈ æ ÇáÊÓÇáí @ åãÓ ááÃáÛÇÒ æÇáäßÊ æÇáÖÍß @ åãÓ ááãÓÇÈÜÞÇÊ æÇáÝÚÇáíÇÊ @ åãÓ ÇÓÊÑÇÍÉ ÇáÇÚÖÇÁ @ åãÓ ááÃÞÓÇã ÇáÊÚáíãíå @ åãÓ ÇáÔÇãá ááØáÇÈ æÇáØÇáÜÈÇÊ @ CuteEnglishForum @ åãÓ ááÝä @ åãÓ ááÇÎÈÇÑ ÇáÝäíÉ ÇáÚÑÈíÉ æÇáÚÇáãíÉ æÕæÑ ÇáãÔÇåíÑ @ åãÓ ááÈÑÇãÌ æÇáßãÈíæÊÑ @ åãÓ ÇáßãÈíæÊÑ æÇáÈÑÇãÌ æ ÇáÃäÊÑäÊ @ åãÓ ÈÑÇãÌ ÇáãÓäÌÑ æ ÇáÇÓßÇíÈí æÇáÈÑÇãÌ ÇáãÔÑæÍå @ åãÓ ÇáÇÏÇÑíÉ @ ÇÎÈÇÑ åãÓ ÇáÔæÞ @ åãÓ ááÚÑÖÇÊ æ ÇáãÍÇæÑÇÊ ÇáÔÚÑíå ÇáÞáØÇÊ @ ÞÓÜã ÇáÈÍæË æÇáßÊÈ ÇáÚáãíå Çæ ÇáÊÚáíãíå @ åãÓ ááÇÛÇäí @ åãÓ áßáãÇÊ ÇáÇÛÇäí æÇáÇáÈæãÇÊ @ åãÓ ãÞÇØÚ ÇáíæÊÈæÈ ÍæÇÁ @ åãÓ ÎÇÕ ÈÇ ÇáãÔÑÝíä @ åãÓ ÇáÈÑÇãÌ ÇáãÔÑæÍå åäÇ @ åãÓ ÊØæíÑ ÇáãæÇÞÚ @ åãÓ ÊØæíÑ ÇáãæÇÞÚ æÇáãäÊÏíÇÊ @ åãÓ Ñßä ÓÊÇíáÇÊ vBulletin @ åãÓ áÚÏÓÉ ÇáÇÚÖÇÁ @ åãÓ ááÌáÓÇÊ ÇáÎáíÌíÉ @ ÞÓã ÇáÃÛÇäí ÇáÚÑÈíÉ @ åãÓ ááÇÛÇäí ÇáÚÇãÉ æÇáÏÈßÇÊ @ åãÓ ááÑãßÓ @ åãÓ ááØÞÇÞÇÊ æÇáÔßÔßÉ @ åãÓ ááÇÞÓÇã ÇáÇÓáÇãíå @ äÝÍÇÊ ÇÓáÇãíå @ åãÓ ÇáÕæÊíÇÊ æ ÇáãÑÆíÇÊ ÇáÅÓáÇãíÉ @ åãÓ ááÎíãÉ ÇáÑãÖÇäíÉ @ åãÓ ááÍÌ æ ÇáÚãÑå @ åãÓ ááÍíÇÉ ÇáÒæÌíÉ @ åãÓ ÍÑÈ ÇáÊãÇÓíÍ x ÇáÓÍÇáí @ åãÓ ÇáÔÚÑ æ ÇáÔíáÇÊ ÇáÕæÊíå @ åãÓ åäÇ ãÏÑÓÉ ááãÈÊÏÆíä @ åãÓ ááÊåÇäí æ ÇåÏÇÁÇÊ @ åãÓ ááÑíÇÖå ÇáÓÚæÏíå æÇáÎáíÌíå @ åãÓ ãÔÇßá ÇáÇÚÖÇÁ ÇáÎÇÕå æÍáæáåÇ @ ÚíÓì ÇáÇÍÓÇÆí @ åãÓ áãáÍÞÇÊ ãæÈÇíáÇÊ ÇáÇäÏÑæíÏ æÇáÈÑÇãÌ @ ÇÛÇäí ØÇåÑ ÇáÇÍÓÇÆí @ åãÓ ááÇÎÈÇÑ ÇáÚÇáãíÉ æ ÇáÚÑÈíå æÇáãÍáíå @ åãÓ ááØÈ æÇáÕÍå @ åãÓ ãæÈÇíáÇÊ ÇáÇäÏÑæíÏ @ åãÓ ááãÓäÌÑ ÊæÈíßÇÊ æËíãÇÊ æÇáÕæÑ @ åãÓ áÜ ÓåÑÊäÇ ÇáÎãíÓíå ÎáæåÇ ÕÈÇÍí ãÚäÇ @ åãÓ Èíä ÇáÍÇÖÑ æÇáãÇÖí @ åãÓ ÇáÇÕÇáå ÇáÚÑÈíå Èäí ãÇáß ÇÖã @ åãÓ Ðæí ÇáÅÍÊíÇÌÇÊ ÇáÎÇÕÉ @ åãÓ ááÇÔÛÇá ÇáíÏæíå @ åãÓ áÚÇáã ÇáäÈÇÊ æÇáËÑæå æÇáÒÑÇÚå æÇáÍíæÇäíå @ åãÓ ÔÎÕíÇÊ áåÇ ÈÕãÉ Ýí ÇáÊÇÑíÎ @ åãÓ ÑíÔÉ ÝäÇä @ åãÓ ááÝäæä ÇáÊÔßíáíå @ åãÓ ÇáÓíÑÉ ÇáäÈæíÉ @ åãÓ ááÇÞÓÇã ÇáÃÏÈíå @ åãÓ ÇáÔÚÑ æÇáÞæÇÝí @ åãÓ ááÞÕÕ æÍßÇíÇÊ æÑæÇíÇÊ @ ÇÏÈÇÁ æÔÚÑÇÁ åãÓ ÇáÍÕÑíÉ @ åãÓ ßÊÇÈÇÊ ÇáÇÚÖÇÁ ÇáÍÕÑíå @ åãÓ ãÓÇÈÞÉ ÑãÖÇä @ åãÓ ááãØÈÎ ÇáÑãÖÇäí @ åãÓ ááÇÓÑå æÇáØÝá @ ÊØæíÑ ÇáÐÇÊ æÇáÈÑãÌå ÇááÛæíå ÇáÚÕÈíå @ ÚÇáã ÇáÇäãí æÇáßÇÑíßÇÊíÑ @ åãÓ ØáÈÇÊ ÇáÇÚÖÇÁ åäÇ @ ãÌáÉ ÔÈßÉ åãÓ ÇáÔæÞ @ åãÓ ááÃÝáÇã æÇáãÜÓÜáÓÜáÇÊ @ åãÓ ááÑíÇÖå ÇáÚÑÈíå æÇáÚÇáãíå @ åãÓ ÇáÞÑÂä ÇáßÑíã @ åãÓ ÏæÇæíä ÇáÔÚÑÇÁ @ åãÓ ááÕæÑ ÇáÏíäíÉ æÇáÇÓáÇãíÉ @ åãÓ áãÏæäÇÊ ÇáÇÚÖÇÁ @ åãÓ áãÓÇÈÞÇÊ ÇáãÏæäÇÊ @ åãÓå Ïíäíå ÇáÕÈÇÍíå @ åãÓå Ïíäíå ãÓÇÆíå @ åãÓ ááãæÇÖíÚ ÇáãÎÇáÝå @ ãæÇÖíÚ ÇáÒæÇÑ ÇáãÍáæáå @ åãÓ áãÞÇØÚ ÇáíæÊæÈ @ åãÓ ááÝæÊæÔæÈ æÇáÇäÝæÌÑÇÝíß @ åãÓ ÈÑÇãÌ ÇáÝæÊæÔæÈ æÇáÊÕÇãíã @ åãÓ ÇáÊÕÇãíã ÇáÍÕÑíÉ @ åãÓ ØáÈÇÊ ÊÕãíã ÇáÑãÒíÇÊ æÇáÊæÇÞíÚ æãáÍÞÇÊåÇ @ åãÓ ÏÑæÓ ÇáÝæÊæÔæÈ ÇáÍÕÑíÉ @ åãÓ ÇáÏÑæÓ ÇáãäÞæáå @ åãÓ ÃÏæÇÊ ÇáÝæÊæÔæÈ ÇáãäÞæáå @ ÃÏæÇÊ ÇáÝæÊæÔæÈ ÇáãäÞæáå @ åãÓ ÊÕÇãíã ÇáÓæíÊÔ ãÇßÓ æãáÍÞÇÊ @ åãÓ ÇáÇßÓÓæÇÑÇÊ áÊäÓíÞ æÊÒíä ÇáãæÇÖíÚ @ åãÓ ÏæÑí ÇáÊæÞÚÇÊ @ ÞäÇÉ ÔÈßÉ åãÓ ÇáÔæÞ @ åãÓ ááÇáÚÇÈ ÇáßÊÑæäíå æÇáÝíÏíæ @ ÞäÇÉ áÃáÚÇÈ ÇáÝíÏíæ @ åãÓ ÇáÚÇÈ ÇáãÛÇãÑÇÊ æÇáÍÑßÉ @ åãÓ ÃáÚÇÈ ÇáÃßÔä ãÚ ÇáÞÊÇá @ åãÓ ÇáÃáÚÇÈ ÇáÇÓÊÑÇÊíÌíÉ æÇáÑíÇÖíå @ åãÓ ÃáÚÇÈ ÇáãÍÇßÇÉ æ ÇáÊÕæíÈ æÇáÊÎÝí @ åãÓ ááÊæÇÕá ÇáÇÌÊãÇÚí @ ÊæíÊÑ @ ÇäÓÊÛÑÇã @ Êíß Êæß @ ÓäÇÈ @ åãÓ ááÊãÇÑíä ÇáÑíÇÖíÉ @ åãÓ ÕæÑå æÞÕíÏå æãÞØÚ @ åãÓ ÊÕÇãíã ÍÕÑíÉ @ ÇáÇÎÈÇÑ ÇáÝíÏíæ @ åãÓ ááÇÏÈíÇÊ ÇáÊí Êã äÔÑåÇ ÈÞáã ÇáÚÖæ @ åãÓ ááæÙÇÆÝ Ýí ÌãíÚ ÇáÞØÇÚÇÊ @ åãÓ ááÏæÑÇÊ ÇáãÚáäå @ åãÓ ááÏæÑÇÊ ÇáãÚáäå @ åãÓ ááãÞÇáÇÊ ÇáÇÏÈíå ÇáãäÞæáå @ ÇáÓßÑÇÈÒ æÇáÕæÑ ÇáãÞÕæÕÉ @ åãÓ ááÞÕÕ æÍßÇíÇÊ æÑæÇíÇÊ ÈÞáã ÇáÚÖæ @ ÑÓÇáÉ Çáíæã @ åãÓ ÑÓÇáÉ Çáíæã @ åãÓ ÃÌÇËÇ ßÑíÓÊí @ ÔÑæÍÇÊ æÎæÇÕ ÇáÝí Èí ÇáãäÞæáå @ åãÓ ááÑíÇÖå ÇáãÊäæÚå @ @ åãÓ ÊÍãíá ÇÕÏÇÑÇÊ vbulletin 3.8.x @ ØáÈÇÊ ÊäÓíÞ ÇáãæÇÖíÚ ãä åäÇ @ åãÓ ØáÈÇÊ ÊäÓíÞ ÇáãæÇÖíÚ @ ÊØæíÑ ãäÊÏíÇÊ ÇáÌíá ÇáÑÇÈÚ æÇáÎÇãÓ ÇáãäÞæáÉ @ åãÓ ÇáÚãÑÉ æÇáÒíÇÑÉ @ åãÓ æåÌ ÇáÝßÑ ááãÞÇáÇÊ ÈÞáã ÇáÃÚÖÇÁ @ åãÓ áÔÑæÍÇÊ ÊÎÕ ÇáãäÊÏíÇÊ @



ÔÈßÉ åãÓ ÇáÔæÞ - ÇáÃÑÔíÝ - ÇáÃÚáì

ÌãíÚ ÇáÍÞæÞ ãÍÝæÙå ááãäÊÏì
HêĽм √ 3.1 BY: ! ωαнαм ! © 2010
Developed By Marco Mamdouh
User Alert System provided by Advanced User Tagging (Lite) - vBulletin Mods & Addons Copyright © 2026 DragonByte Technologies Ltd.

SEO by vBSEO