access
رمز PHP:
كود PHP:
                       CREATE TABLE `access` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `forumid` smallint(5) unsigned NOT NULL default '0', 
  `accessmask` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`userid`,`forumid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
adminhelp

رمز PHP:
كود PHP:
                       CREATE TABLE `adminhelp` ( 
  `adminhelpid` int(10) unsigned NOT NULL auto_increment, 
  `script` varchar(50) NOT NULL default '', 
  `action` varchar(25) NOT NULL default '', 
  `optionname` varchar(100) NOT NULL default '', 
  `displayorder` smallint(5) unsigned NOT NULL default '1', 
  `volatile` smallint(5) unsigned NOT NULL default '0', 
  `product` varchar(25) NOT NULL default '', 
  PRIMARY KEY  (`adminhelpid`), 
  UNIQUE KEY `phraseunique` (`script`,`action`,`optionname`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
administrator
رمز PHP:
كود PHP:
CREATE TABLE `administrator` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `adminpermissions` int(10) unsigned NOT NULL default '0', 
  `navprefs` mediumtext, 
  `cssprefs` varchar(250) NOT NULL default '', 
  `notes` mediumtext, 
  `dismissednews` text, 
  `languageid` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
adminlog
رمز PHP:
كود PHP:
CREATE TABLE `adminlog` ( 
  `adminlogid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `script` varchar(50) NOT NULL default '', 
  `action` varchar(20) NOT NULL default '', 
  `extrainfo` varchar(200) NOT NULL default '', 
  `ipaddress` char(15) NOT NULL default '', 
  PRIMARY KEY  (`adminlogid`), 
  KEY `script_action` (`script`,`action`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
adminmessage

رمز PHP:
كود PHP:
CREATE TABLE `adminmessage` ( 
  `adminmessageid` int(10) unsigned NOT NULL auto_increment, 
  `varname` varchar(250) NOT NULL default '', 
  `dismissable` smallint(5) unsigned NOT NULL default '0', 
  `script` varchar(50) NOT NULL default '', 
  `action` varchar(20) NOT NULL default '', 
  `execurl` mediumtext, 
  `method` enum('get','post') NOT NULL default 'post', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `status` enum('undone','done','dismissed') NOT NULL default 'undone', 
  `statususerid` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`adminmessageid`), 
  KEY `script_action` (`script`,`action`), 
  KEY `varname` (`varname`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
adminutil

رمز PHP:
كود PHP:
                       CREATE TABLE `adminutil` ( 
  `title` varchar(50) NOT NULL default '', 
  `text` mediumtext, 
  PRIMARY KEY  (`title`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
album

رمز PHP:
كود PHP:
                       CREATE TABLE `album` ( 
  `albumid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `createdate` int(10) unsigned NOT NULL default '0', 
  `lastpicturedate` int(10) unsigned NOT NULL default '0', 
  `visible` int(10) unsigned NOT NULL default '0', 
  `moderation` int(10) unsigned NOT NULL default '0', 
  `title` varchar(100) NOT NULL default '', 
  `description` mediumtext, 
  `state` enum('public','private','profile') NOT NULL default 'public', 
  `coverpictureid` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`albumid`), 
  KEY `userid` (`userid`,`lastpicturedate`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
albumpicture

رمز PHP:
كود PHP:
                       CREATE TABLE `albumpicture` ( 
  `albumid` int(10) unsigned NOT NULL default '0', 
  `pictureid` int(10) unsigned NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`albumid`,`pictureid`), 
  KEY `albumid` (`albumid`,`dateline`), 
  KEY `pictureid` (`pictureid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
albumupdate
رمز PHP:
كود PHP:
CREATE TABLE `albumupdate` ( 
  `albumid` int(10) unsigned NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`albumid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
announcement رمز PHP:
كود PHP:
CREATE TABLE `announcement` ( 
  `announcementid` smallint(5) unsigned NOT NULL auto_increment, 
  `title` varchar(250) NOT NULL default '', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `startdate` int(10) unsigned NOT NULL default '0', 
  `enddate` int(10) unsigned NOT NULL default '0', 
  `pagetext` mediumtext, 
  `forumid` smallint(6) NOT NULL default '0', 
  `views` int(10) unsigned NOT NULL default '0', 
  `announcementoptions` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`announcementid`), 
  KEY `forumid` (`forumid`), 
  KEY `startdate` (`enddate`,`forumid`,`startdate`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
announcementread


رمز PHP:
كود PHP:
                       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

رمز PHP:
كود PHP:
                       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

رمز PHP:
كود PHP:
                       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

رمز PHP:
كود PHP:
                       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;  
attachmentviews


رمز PHP:
كود PHP:
                       CREATE TABLE `attachmentviews` ( 
  `attachmentid` int(10) unsigned NOT NULL default '0', 
  KEY `postid` (`attachmentid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
avatar

رمز PHP:
كود PHP:
                       CREATE TABLE `avatar` ( 
  `avatarid` smallint(5) unsigned NOT NULL auto_increment, 
  `title` varchar(100) NOT NULL default '', 
  `minimumposts` int(10) unsigned NOT NULL default '0', 
  `avatarpath` varchar(100) NOT NULL default '', 
  `imagecategoryid` smallint(5) unsigned NOT NULL default '0', 
  `displayorder` smallint(5) unsigned NOT NULL default '1', 
  PRIMARY KEY  (`avatarid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
bbcode

رمز PHP:
كود PHP:
CREATE TABLE `bbcode` ( 
  `bbcodeid` smallint(5) unsigned NOT NULL auto_increment, 
  `bbcodetag` varchar(200) NOT NULL default '', 
  `bbcodereplacement` mediumtext, 
  `bbcodeexample` varchar(200) NOT NULL default '', 
  `bbcodeexplanation` mediumtext, 
  `twoparams` smallint(6) NOT NULL default '0', 
  `title` varchar(100) NOT NULL default '', 
  `buttonimage` varchar(250) NOT NULL default '', 
  `options` int(10) unsigned NOT NULL default '1', 
  PRIMARY KEY  (`bbcodeid`), 
  UNIQUE KEY `uniquetag` (`bbcodetag`,`twoparams`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
bookmarksite
رمز PHP:
كود PHP:
CREATE TABLE `bookmarksite` ( 
  `bookmarksiteid` int(10) unsigned NOT NULL auto_increment, 
  `title` varchar(250) NOT NULL default '', 
  `iconpath` varchar(250) NOT NULL default '', 
  `active` smallint(5) unsigned NOT NULL default '0', 
  `displayorder` int(10) unsigned NOT NULL default '0', 
  `url` varchar(250) NOT NULL default '', 
  PRIMARY KEY  (`bookmarksiteid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
calendar
رمز PHP:
[PHP]
كود PHP:
CREATE TABLE `calendar` ( 
  `calendarid` int(10) unsigned NOT NULL auto_increment, 
  `title` varchar(255) NOT NULL default '', 
  `description` varchar(100) NOT NULL default '', 
  `displayorder` smallint(6) NOT NULL default '0', 
  `neweventemail` text, 
  `moderatenew` smallint(6) NOT NULL default '0', 
  `startofweek` smallint(6) NOT NULL default '0', 
  `options` int(10) unsigned NOT NULL default '0', 
  `cutoff` smallint(5) unsigned NOT NULL default '0', 
  `eventcount` smallint(5) unsigned NOT NULL default '0', 
  `birthdaycount` smallint(5) unsigned NOT NULL default '0', 
  `startyear` smallint(5) unsigned NOT NULL default '2000', 
  `endyear` smallint(5) unsigned NOT NULL default '2006', 
  `holidays` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`calendarid`), 
  KEY `displayorder` (`displayorder`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
[/PHP