| سالجان |
10-03-2019 10:11 AM |
قاعدة البيانات SQL vb3_3
] calendarcustomfield
كود:
رمز 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
|
