XFileSharing Pro - ip2files

Message
Author
ankurs
Posts: 1054
Joined: Mar 10, 2009 2:34 am

ip2files

#1 Postby ankurs » Jan 17, 2011 8:17 pm

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

adiga
Posts: 177
Joined: Jul 23, 2009 2:27 am

#2 Postby adiga » Jan 18, 2011 12:22 am

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;

ankurs
Posts: 1054
Joined: Mar 10, 2009 2:34 am

#3 Postby ankurs » Jan 18, 2011 4:53 am

thanks adiga :)

adiga
Posts: 177
Joined: Jul 23, 2009 2:27 am

#4 Postby adiga » Jan 18, 2011 1:17 pm

welcome ankurs