- DROP TABLE IF EXISTS pre_common_member_action_log;
- CREATE TABLE pre_common_member_action_log (
- id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- uid mediumint(8) unsigned NOT NULL DEFAULT '0',
- `action` tinyint(5) NOT NULL DEFAULT '0',
- dateline int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (id),
- KEY dateline (dateline,`action`,uid)
- ) TYPE=MyISAM;
- DROP TABLE IF EXISTS pre_common_regip;
- CREATE TABLE pre_common_regip (
- ip char(15) NOT NULL DEFAULT '',
- dateline int(10) unsigned NOT NULL DEFAULT '0',
- count smallint(6) NOT NULL DEFAULT '0',
- KEY ip (ip)
- ) TYPE=MyISAM;
复制代码 |