# --------------------------------------------------------
# Host:                         jakelprice.com
# Server version:               5.0.91-community-log
# Server OS:                    unknown-linux-gnu
# HeidiSQL version:             6.0.0.3603
# Date/time:                    2011-02-23 12:00:44
# --------------------------------------------------------


# Dumping structure for table jakelpri_buysell.cats
CREATE TABLE IF NOT EXISTS `cats` (
  `catID` int(10) NOT NULL auto_increment,
  `catName` varchar(255) NOT NULL,
  `catText` varchar(255) NOT NULL,
  PRIMARY KEY  (`catID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Category Table';

# Dumping data for table jakelpri_buysell.cats: 1 rows
INSERT INTO `cats` (`catID`, `catName`, `catText`) VALUES
	(1, 'Category One', 'Some Category Text');


# Dumping structure for table jakelpri_buysell.comments
CREATE TABLE IF NOT EXISTS `comments` (
  `comment_id` int(10) NOT NULL auto_increment,
  `comment_item` int(10) NOT NULL default '0',
  `comment_author` varchar(255) NOT NULL default '0',
  `comment_date` varchar(255) NOT NULL default '0',
  `comment_pur` int(10) NOT NULL default '0',
  `comment_aut` int(10) NOT NULL default '0',
  `comment` text NOT NULL,
  PRIMARY KEY  (`comment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# Dumping data for table jakelpri_buysell.comments: 0 rows


# Dumping structure for table jakelpri_buysell.history
CREATE TABLE IF NOT EXISTS `history` (
  `histID` int(10) NOT NULL auto_increment,
  `userID` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `Log` varchar(255) NOT NULL,
  PRIMARY KEY  (`histID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COMMENT='Table recording everyones history - logging';

# Dumping data for table jakelpri_buysell.history: 0 rows


# Dumping structure for table jakelpri_buysell.items
CREATE TABLE IF NOT EXISTS `items` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `author` int(10) NOT NULL,
  `cat` int(255) NOT NULL COMMENT 'Link to ''cats'' table',
  `descr` text NOT NULL,
  `date` varchar(50) NOT NULL,
  `price` double NOT NULL,
  `sales` int(10) NOT NULL,
  `image_main` varchar(255) NOT NULL,
  `image_thumb` varchar(255) NOT NULL,
  `download_link` varchar(255) NOT NULL,
  `published` int(10) NOT NULL COMMENT '0 = False, 1 = True',
  `live_link` varchar(255) NOT NULL COMMENT 'Link to view link',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Item and Product Table';

# Dumping data for table jakelpri_buysell.items: 0 rows


# Dumping structure for table jakelpri_buysell.payments
CREATE TABLE IF NOT EXISTS `payments` (
  `paymentID` int(10) NOT NULL auto_increment,
  `payType` varchar(50) NOT NULL,
  `txn` varchar(255) NOT NULL,
  `buyer_id` varchar(255) NOT NULL,
  `item_id` int(10) NOT NULL,
  `amount` float NOT NULL,
  `fee` float NOT NULL,
  PRIMARY KEY  (`paymentID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table holding all Payments';

# Dumping data for table jakelpri_buysell.payments: 0 rows


# Dumping structure for table jakelpri_buysell.payout
CREATE TABLE IF NOT EXISTS `payout` (
  `id` int(10) NOT NULL auto_increment,
  `user_id` int(10) NOT NULL default '0',
  `amount` varchar(50) NOT NULL default '0',
  `dt` int(15) NOT NULL default '0',
  `com` int(10) NOT NULL default '0',
  `dt_com` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Payout table';

# Dumping data for table jakelpri_buysell.payout: 0 rows


# Dumping structure for table jakelpri_buysell.settings
CREATE TABLE IF NOT EXISTS `settings` (
  `name` varchar(255) default NULL,
  `value` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Settings Table';

# Dumping data for table jakelpri_buysell.settings: 7 rows
INSERT INTO `settings` (`name`, `value`) VALUES
	('sitename', 'New BuyandSell'),
	('debug', 'true'),
	('base_url', 'http://jakelprice.com/buyandsell/'),
	('paypal_email', 'jake@jakelprice.com'),
	('admin_email', 'jake@jakelprice.com'),
	('cut', '75'),
	('notify_new_sub', '1');
