الجزء الثالث

announcementread

كود:
CREATE TABLE `announcementread` ( 
`announcementid` int(10) unsigned NOT NULL default '0', 
`userid` int(10) unsigned NOT NULL default '0', 
PRIMARY KEY  (`announcementid`,`userid`), 
KEY `userid` (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

attachment

كود:
CREATE TABLE `attachment` ( 
`attachmentid` int(10) unsigned NOT NULL auto_increment, 
`userid` int(10) unsigned NOT NULL default '0', 
`dateline` int(10) unsigned NOT NULL default '0', 
`thumbnail_dateline` int(10) unsigned NOT NULL default '0', 
`filename` varchar(100) NOT NULL default '', 
`filedata` mediumblob, 
`visible` smallint(5) unsigned NOT NULL default '0', 
`counter` int(10) unsigned NOT NULL default '0', 
`filesize` int(10) unsigned NOT NULL default '0', 
`postid` int(10) unsigned NOT NULL default '0', 
`filehash` char(32) NOT NULL default '', 
`posthash` char(32) NOT NULL default '', 
`thumbnail` mediumblob, 
`thumbnail_filesize` int(10) unsigned NOT NULL default '0', 
`extension` varchar(20) character set latin1 collate latin1_bin NOT NULL default '', 
PRIMARY KEY  (`attachmentid`), 
KEY `filesize` (`filesize`), 
KEY `filehash` (`filehash`), 
KEY `userid` (`userid`), 
KEY `posthash` (`posthash`,`userid`), 
KEY `postid` (`postid`), 
KEY `visible` (`visible`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

attachmentpermission


كود:
CREATE TABLE `attachmentpermission` ( 
`attachmentpermissionid` int(10) unsigned NOT NULL auto_increment, 
`extension` varchar(20) character set latin1 collate latin1_bin NOT NULL default '', 
`usergroupid` int(10) unsigned NOT NULL default '0', 
`size` int(10) unsigned NOT NULL default '0', 
`width` smallint(5) unsigned NOT NULL default '0', 
`height` smallint(5) unsigned NOT NULL default '0', 
`attachmentpermissions` int(10) unsigned NOT NULL default '0', 
PRIMARY KEY  (`attachmentpermissionid`), 
UNIQUE KEY `extension` (`extension`,`usergroupid`), 
KEY `usergroupid` (`usergroupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

attachmenttype

كود:
CREATE TABLE `attachmenttype` ( 
`extension` char(20) character set latin1 collate latin1_bin NOT NULL default '', 
`mimetype` varchar(255) NOT NULL default '', 
`size` int(10) unsigned NOT NULL default '0', 
`width` smallint(5) unsigned NOT NULL default '0', 
`height` smallint(5) unsigned NOT NULL default '0', 
`enabled` smallint(5) unsigned NOT NULL default '1', 
`display` smallint(5) unsigned NOT NULL default '0', 
`thumbnail` smallint(5) unsigned NOT NULL default '0', 
`newwindow` smallint(5) unsigned NOT NULL default '0', 
PRIMARY KEY  (`extension`), 
KEY `enabled` (`enabled`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;