الترقيه بعد زراعه أمر بناء لتجنب المشاكل

[سالجان]

الترقيه بعد زراعه أمر بناء لتجنب المشاكل

رمز PHP:
كود PHP:
CREATE TABLE `calendarcustomfield` ( 
  `calendarcustomfieldid` int(10) unsigned NOT NULL auto_increment, 
  `calendarid` int(10) unsigned NOT NULL default '0', 
  `title` varchar(255) NOT NULL default '', 
  `description` mediumtext, 
  `options` mediumtext, 
  `allowentry` smallint(6) NOT NULL default '1', 
  `required` smallint(6) NOT NULL default '0', 
  `length` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`calendarcustomfieldid`), 
  KEY `calendarid` (`calendarid`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;  
calendarmoderator
رمز PHP:
كود PHP:
CREATE TABLE `calendarmoderator` ( 
  `calendarmoderatorid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `calendarid` int(10) unsigned NOT NULL default '0', 
  `neweventemail` smallint(6) NOT NULL default '0', 
  `permissions` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`calendarmoderatorid`), 
  KEY `userid` (`userid`,`calendarid`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;  
calendarpermission

رمز PHP:
كود PHP:
                       CREATE TABLE `calendarpermission` ( 
  `calendarpermissionid` int(10) unsigned NOT NULL auto_increment, 
  `calendarid` int(10) unsigned NOT NULL default '0', 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  `calendarpermissions` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`calendarpermissionid`), 
  KEY `calendarid` (`calendarid`), 
  KEY `usergroupid` (`usergroupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;  
cpsession رمز PHP:
كود PHP:

CREATE TABLE `cpsession` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `hash` varchar(32) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`userid`,`hash`) 
) ENGINE=MEMORY DEFAULT CHARSET=utf8;  
cron

رمز PHP:
كود PHP:
                       CREATE TABLE `cron` ( 
  `cronid` int(10) unsigned NOT NULL auto_increment, 
  `nextrun` int(10) unsigned NOT NULL default '0', 
  `weekday` smallint(6) NOT NULL default '0', 
  `day` smallint(6) NOT NULL default '0', 
  `hour` smallint(6) NOT NULL default '0', 
  `minute` varchar(100) NOT NULL default '', 
  `filename` char(50) NOT NULL default '', 
  `loglevel` smallint(6) NOT NULL default '0', 
  `active` smallint(6) NOT NULL default '1', 
  `varname` varchar(100) NOT NULL default '', 
  `volatile` smallint(5) unsigned NOT NULL default '0', 
  `product` varchar(25) NOT NULL default '', 
  PRIMARY KEY  (`cronid`), 
  UNIQUE KEY `varname` (`varname`), 
  KEY `nextrun` (`nextrun`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;  
cronlog
رمز PHP:
كود PHP:
CREATE TABLE `cronlog` ( 
  `cronlogid` int(10) unsigned NOT NULL auto_increment, 
  `varname` varchar(100) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `description` mediumtext, 
  `type` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`cronlogid`), 
  KEY `varname` (`varname`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;  
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=utf8;  
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=utf8;  
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=utf8;  
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=utf8;  
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=utf8 AUTO_INCREMENT=1 ;