customavatar


رمز PHP:
كود PHP:
                       CREATE TABLE `customavatar` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `filedata` mediumblob, 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `filename` varchar(100) NOT NULL default '', 
  `visible` smallint(6) NOT NULL default '1', 
  `filesize` int(10) unsigned NOT NULL default '0', 
  `width` smallint(5) unsigned NOT NULL default '0', 
  `height` smallint(5) unsigned NOT NULL default '0', 
  `filedata_thumb` mediumblob, 
  `width_thumb` int(10) unsigned NOT NULL default '0', 
  `height_thumb` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
customprofilepic
رمز PHP:
كود PHP:
CREATE TABLE `customprofilepic` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `filedata` mediumblob, 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `filename` varchar(100) NOT NULL default '', 
  `visible` smallint(6) NOT NULL default '1', 
  `filesize` int(10) unsigned NOT NULL default '0', 
  `width` smallint(5) unsigned NOT NULL default '0', 
  `height` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
datastore

رمز PHP:
كود PHP:
                       CREATE TABLE `datastore` ( 
  `title` char(50) NOT NULL default '', 
  `data` mediumtext, 
  `unserialize` smallint(6) NOT NULL default '0', 
  PRIMARY KEY  (`title`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
deletionlog
رمز PHP:
كود PHP:
CREATE TABLE `deletionlog` ( 
  `primaryid` int(10) unsigned NOT NULL default '0', 
  `type` enum('post','thread','visitormessage','groupmessage','picturecomment') NOT NULL default 'post', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `username` varchar(100) NOT NULL default '', 
  `reason` varchar(125) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`primaryid`,`type`), 
  KEY `type` (`type`,`dateline`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
discussion

رمز PHP:
كود PHP:
                       CREATE TABLE `discussion` ( 
  `discussionid` int(10) unsigned NOT NULL auto_increment, 
  `groupid` int(10) unsigned NOT NULL, 
  `firstpostid` int(10) unsigned NOT NULL, 
  `lastpostid` int(10) unsigned NOT NULL, 
  `lastpost` int(10) unsigned NOT NULL, 
  `lastposter` varchar(255) NOT NULL, 
  `lastposterid` int(10) unsigned NOT NULL, 
  `visible` int(10) unsigned NOT NULL default '0', 
  `deleted` int(10) unsigned NOT NULL default '0', 
  `moderation` int(10) unsigned NOT NULL default '0', 
  `subscribers` enum('0','1') default '0', 
  PRIMARY KEY  (`discussionid`), 
  KEY `groupid` (`groupid`,`lastpost`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;