can someone send me database structure for ip2files for version 1.6
my db crashed and i lost this table ; currently i have put 1.8 structure by just renaming money to points column
XFileSharing Pro - ip2files
Code: Select all
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;