الله يجزاكم الجنه ويوفقكم ساعدوني

CREATE TABLE `thread` (
  `pictureid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `caption` text,
  `extension` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `filedata` mediumblob,
  `filesize` int(10) unsigned NOT NULL DEFAULT '0',
  `width` smallint(5) unsigned NOT NULL DEFAULT '0',
  `height` smallint(5) unsigned NOT NULL DEFAULT '0',
  `thumbnail` mediumblob,
  `thumbnail_filesize` int(10) unsigned NOT NULL DEFAULT '0',
  `thumbnail_width` smallint(5) unsigned NOT NULL DEFAULT '0',
  `thumbnail_height` smallint(5) unsigned NOT NULL DEFAULT '0',
  `thumbnail_dateline` int(10) unsigned NOT NULL DEFAULT '0',
  `idhash` varchar(32) NOT NULL DEFAULT '',
  `reportthreadid` int(10) unsigned NOT NULL DEFAULT '0',
  `state` enum('visible','moderation') NOT NULL DEFAULT 'visible',
  PRIMARY KEY (`pictureid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;