رمز 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=latin1 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=latin1 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=latin1 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=latin1;  
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=latin1 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=latin1 AUTO_INCREMENT=1 ;  
customavatar