Code:
--
-- Table structure for table `downl_logs`
--
CREATE TABLE `downl_logs` (
`downl_id` int(11) NOT NULL auto_increment,
`file_id` varchar(40) NOT NULL default '',
`ip` varchar(30) NOT NULL default '',
`user_id` int(10) NOT NULL default '0',
`refer` varchar(20) NOT NULL default '',
`status` varchar(30) NOT NULL default '',
`date` varchar(30) NOT NULL default '',
`timestamp` varchar(30) NOT NULL default '',
PRIMARY KEY (`downl_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `file_packs`
--
CREATE TABLE `file_packs` (
`pack_id` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`desc` text NOT NULL,
PRIMARY KEY (`pack_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `files`
--
CREATE TABLE `files` (
`file_id` int(11) NOT NULL auto_increment,
`pack_id` int(10) NOT NULL default '0',
`cat` varchar(50) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`desc` text NOT NULL,
`file_name` varchar(100) NOT NULL default '',
`num_downloads` int(10) NOT NULL default '0',
PRIMARY KEY (`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `ip_logs`
--
CREATE TABLE `ip_logs` (
`ip_id` int(11) NOT NULL auto_increment,
`ip` varchar(30) NOT NULL default '',
`user_id` int(10) NOT NULL default '0',
`latest_date` varchar(30) NOT NULL default '',
`latest_timestamp` varchar(30) NOT NULL default '',
PRIMARY KEY (`ip_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `items`
--
CREATE TABLE `items` (
`item_id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`identifi` varchar(100) NOT NULL default '',
`price` varchar(30) NOT NULL default '',
`file_name` varchar(100) NOT NULL default '',
`file_pack` varchar(30) NOT NULL default '',
PRIMARY KEY (`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `login_logs`
--
CREATE TABLE `login_logs` (
`login_id` int(11) NOT NULL auto_increment,
`user_id` int(10) NOT NULL default '0',
`ip` varchar(30) NOT NULL default '',
`date` varchar(30) NOT NULL default '',
`timestamp` varchar(30) NOT NULL default '',
PRIMARY KEY (`login_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `sales`
--
CREATE TABLE `sales` (
`invoice_id` int(10) NOT NULL auto_increment,
`user_id` int(10) NOT NULL default '0',
`receiver_email` varchar(60) NOT NULL default '',
`auction_item_name` varchar(100) NOT NULL default '',
`auction_item_number` varchar(18) NOT NULL default '',
`quantity` varchar(6) NOT NULL default '',
`payment_status` varchar(10) NOT NULL default '',
`pending_reason` varchar(10) NOT NULL default '',
`payment_date` varchar(25) NOT NULL default '',
`mc_gross` varchar(20) NOT NULL default '',
`mc_fee` varchar(20) NOT NULL default '',
`tax` varchar(20) NOT NULL default '',
`mc_currency` varchar(4) NOT NULL default '',
`txn_id` varchar(20) NOT NULL default '',
`txn_id_refund` varchar(20) NOT NULL default '',
`txn_type` varchar(10) NOT NULL default '',
`payment_type` varchar(10) NOT NULL default '',
`notify_version` varchar(10) NOT NULL default '',
`verify_sign` varchar(10) NOT NULL default '',
`referrer_id` varchar(10) NOT NULL default '',
`memo` varchar(255) NOT NULL default '',
`for_auction` varchar(20) NOT NULL default '',
`auction_buyer_id` varchar(64) NOT NULL default '',
`auction_closing_date` varchar(21) NOT NULL default '',
`auction_multi_item` varchar(20) NOT NULL default '',
`account_username` varchar(50) NOT NULL default '',
`account_password` varchar(20) NOT NULL default '',
`received_timestamp` varchar(20) NOT NULL default '',
`received_date` varchar(30) NOT NULL default '',
`mark_paid` varchar(20) NOT NULL default '',
`mark_shipped` varchar(20) NOT NULL default '',
`mark_feedback` varchar(30) NOT NULL default '',
`feedback_received` varchar(100) NOT NULL default '',
`feedback_left` varchar(100) NOT NULL default '',
PRIMARY KEY (`invoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `user_perm`
--
CREATE TABLE `user_perm` (
`perm_id` int(11) NOT NULL auto_increment,
`user_id` int(10) NOT NULL default '0',
`pack_id` int(10) NOT NULL default '0',
`file_id` int(10) NOT NULL default '0',
`date` varchar(30) NOT NULL default '',
`timestamp` varchar(30) NOT NULL default '',
PRIMARY KEY (`perm_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`user_id` int(11) NOT NULL auto_increment,
`active` varchar(10) NOT NULL default '',
`username` varchar(100) NOT NULL default '',
`password` varchar(40) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`ebay_userid` varchar(50) NOT NULL default '',
`num_downloads` int(5) NOT NULL default '0',
`num_logins` int(5) NOT NULL default '0',
`num_ips` int(5) NOT NULL default '0',
`num_purchases` int(5) NOT NULL default '0',
`first_name` varchar(30) NOT NULL default '',
`last_name` varchar(50) NOT NULL default '',
`payer_status` varchar(10) NOT NULL default '',
`address_street` varchar(50) NOT NULL default '',
`address_city` varchar(30) NOT NULL default '',
`address_state` varchar(30) NOT NULL default '',
`address_zip` varchar(20) NOT NULL default '',
`address_country` varchar(30) NOT NULL default '',
`address_status` varchar(11) NOT NULL default '',
`latest_login_date` varchar(30) NOT NULL default '',
`latest_login_timestamp` varchar(30) NOT NULL default '',
`latest_updated` varchar(30) NOT NULL default '',
`latest_updated_timestamp` varchar(15) NOT NULL default '',
`created_date` varchar(30) NOT NULL default '',
`created_timestamp` varchar(30) NOT NULL default '',
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;