phpmyadmin下运行哦
- CREATE TABLE pre_common_session (
- sid char(6) NOT NULL DEFAULT '',
- ip1 tinyint(3) unsigned NOT NULL DEFAULT '0',
- ip2 tinyint(3) unsigned NOT NULL DEFAULT '0',
- ip3 tinyint(3) unsigned NOT NULL DEFAULT '0',
- ip4 tinyint(3) unsigned NOT NULL DEFAULT '0',
- uid mediumint(8) unsigned NOT NULL DEFAULT '0',
- username char(15) NOT NULL DEFAULT '',
- groupid smallint(6) unsigned NOT NULL DEFAULT '0',
- invisible tinyint(1) NOT NULL DEFAULT '0',
- `action` tinyint(1) unsigned NOT NULL DEFAULT '0',
- lastactivity int(10) unsigned NOT NULL DEFAULT '0',
- lastolupdate int(10) unsigned NOT NULL DEFAULT '0',
- fid mediumint(8) unsigned NOT NULL DEFAULT '0',
- tid mediumint(8) unsigned NOT NULL DEFAULT '0',
- UNIQUE KEY sid (sid),
- KEY uid (uid)
- ) TYPE=HEAP;
复制代码
和
- CREATE TABLE pre_common_cron (
- cronid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
- available tinyint(1) NOT NULL DEFAULT '0',
- `type` enum('user','system','plugin') NOT NULL DEFAULT 'user',
- `name` char(50) NOT NULL DEFAULT '',
- filename char(50) NOT NULL DEFAULT '',
- lastrun int(10) unsigned NOT NULL DEFAULT '0',
- nextrun int(10) unsigned NOT NULL DEFAULT '0',
- weekday tinyint(1) NOT NULL DEFAULT '0',
- `day` tinyint(2) NOT NULL DEFAULT '0',
- `hour` tinyint(2) NOT NULL DEFAULT '0',
- `minute` char(36) NOT NULL DEFAULT '',
- PRIMARY KEY (cronid),
- KEY nextrun (available,nextrun)
- ) TYPE=MyISAM;
复制代码 |