adiga
Joined: 23 Jul 2009 Posts: 154
|
Posted: Jan 18, 2011 12:22 am Post subject: |
|
|
| Code: | CREATE TABLE `IP2Files` (
`file_id` int(10) unsigned NOT NULL default '0',
`ip` int(20) unsigned NOT NULL default '0',
`usr_id` mediumint(8) unsigned NOT NULL default '0',
`owner_id` mediumint(8) unsigned NOT NULL default '0',
`size` bigint(20) unsigned NOT NULL default '0',
`referer` varchar(255) NOT NULL default '',
`points` decimal(5,2) unsigned NOT NULL default '0.00',
`created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`file_id`,`ip`),
KEY `owner` (`owner_id`),
KEY `user` (`usr_id`),
KEY `ip` (`ip`),
KEY `date` (`created`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|
|