-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: May 05, 2005 at 12:54 PM
-- Server version: 4.0.22
-- PHP Version: 4.3.11
-- 
-- Database: `shopdb`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `registration`
-- 

CREATE TABLE `registration` (
  `owner_name` varchar(255) NOT NULL default '',
  `owner_email` varchar(255) NOT NULL default '',
  `script_name` varchar(255) NOT NULL default '',
  `reg_key` varchar(255) NOT NULL default '',
  `sec_pass` varchar(255) NOT NULL default '',
  `lc_type` varchar(255) NOT NULL default ''
) TYPE=MyISAM;

-- 
-- Dumping data for table `registration`
-- 

INSERT INTO `registration` VALUES ('', '', '', '', '', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `sc_banner`
-- 

CREATE TABLE `sc_banner` (
  `BID` int(11) NOT NULL auto_increment,
  `CONTENT` text NOT NULL,
  PRIMARY KEY  (`BID`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `sc_catalog`
-- 

CREATE TABLE `sc_catalog` (
  `cid` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `sort` int(11) default NULL,
  `parent` int(11) default NULL,
  PRIMARY KEY  (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `sc_catalog`
-- 

INSERT INTO `sc_catalog` VALUES (1, 'Category1', 1, 0);
INSERT INTO `sc_catalog` VALUES (2, 'Category2', 1, 0);
INSERT INTO `sc_catalog` VALUES (3, 'test', 5, 0);
INSERT INTO `sc_catalog` VALUES (4, 'category4', 6, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `sc_disclaimer`
-- 

CREATE TABLE `sc_disclaimer` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `value` text NOT NULL,
  `title` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `sc_disclaimer`
-- 

INSERT INTO `sc_disclaimer` VALUES (1, 'affdisclaimer', '                 Your Login at [sitename]: [login]\r\n                            Disclaimer:\r\n                            This is a message from [sitename].\r\n                            To cancel Affiliate Account, please go <a href=''http://www.yourdomain.com/demos/shopcartdx/unsub.php''>http://www.yourdomain.com/demos/shopcartdx/unsub.php</a>\r\n                      \r\n                                         \r\n                   ', 'Affliate Disclaimer');
INSERT INTO `sc_disclaimer` VALUES (2, 'clientdisclaimer', 'Your Login at [sitename]: [login]\r\n                            Disclaimer:\r\n                            This is a message from [sitename].\r\n                            To cancel Client Account, please go <a href=''http://www.yourdomain.com/demos/shopcartdx/unsub.php''>http://www.yourdomain.com/demos/shopcartdx/unsub.php</a>\r\n                      \r\n                                         \r\n                   ', 'Client Disclaimer');
INSERT INTO `sc_disclaimer` VALUES (3, 'alldisclaimer', 'Your Login at shopcartdx: [login]\r\n                            Disclaimer:\r\n                            This is a message from [sitename].\r\n                            To cancel Account, please go <a href=''http://www.yourdomain.com/demos/shopcartdx/unsub.php''>http://www.yourdomain.com/demos/shopcartdx/unsub.php</a>\r\n                      \r\n                                         \r\n                   ', 'All Disclaimer');

-- --------------------------------------------------------

-- 
-- Table structure for table `sc_member`
-- 

CREATE TABLE `sc_member` (
  `mid` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `login` varchar(30) NOT NULL default '',
  `password` varchar(100) NOT NULL default '',
  `email` varchar(100) default '',
  `address` varchar(255) NOT NULL default '',
  `city` varchar(50) NOT NULL default '',
  `state` varchar(50) NOT NULL default '',
  `zip` varchar(30) NOT NULL default '',
  `country` varchar(50) NOT NULL default '',
  `other_add` varchar(255) default NULL,
  `phone` varchar(50) NOT NULL default '',
  `regdate` timestamp(14) NOT NULL,
  `send_mail` int(11) NOT NULL default '1',
  `refer` int(11) NOT NULL default '0',
  `is_deleted` int(11) NOT NULL default '0',
  PRIMARY KEY  (`mid`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `sc_order`
-- 

CREATE TABLE `sc_order` (
  `oid` int(11) NOT NULL auto_increment,
  `o_date` timestamp(14) NOT NULL,
  `mid` int(11) NOT NULL default '0',
  `amount` double NOT NULL default '0',
  `pay_method` int(11) NOT NULL default '0',
  `pay_detail` varchar(50) NOT NULL default '',
  `ship_status` varchar(50) NOT NULL default '',
  `ship_date` varchar(50) NOT NULL default '',
  `ship_via` varchar(50) default '',
  `ship_info` varchar(50) default '',
  `payment_status` int(11) NOT NULL default '0',
  PRIMARY KEY  (`oid`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `sc_orderitem`
-- 

CREATE TABLE `sc_orderitem` (
  `oiid` int(11) NOT NULL auto_increment,
  `oid` int(11) NOT NULL default '0',
  `item_number` varchar(100) NOT NULL default '',
  `item_name` varchar(50) NOT NULL default '',
  `quantity` int(11) NOT NULL default '0',
  `price` double NOT NULL default '0',
  PRIMARY KEY  (`oiid`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `sc_product`
-- 

CREATE TABLE `sc_product` (
  `pid` int(11) NOT NULL auto_increment,
  `item_number` varchar(50) NOT NULL default '',
  `item_name` varchar(50) NOT NULL default '',
  `item_desc` varchar(255) NOT NULL default '',
  `item_detail` text NOT NULL,
  `item_image` varchar(50) default NULL,
  `large_image` varchar(250) default NULL,
  `reg_price` double NOT NULL default '0',
  `sale_price` double NOT NULL default '0',
  `sort` int(11) default '0',
  `cspecial` int(11) NOT NULL default '0',
  `cfeature` int(11) NOT NULL default '0',
  `down_url` varchar(255) default NULL,
  `cid` int(11) NOT NULL default '0',
  `modified_time` timestamp(14) NOT NULL,
  `shipping_price` double NOT NULL default '0',
  PRIMARY KEY  (`pid`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- --------------------------------------------------------

-- 
-- Table structure for table `sc_ref_credit_history`
-- 

CREATE TABLE `sc_ref_credit_history` (
  `PHID` int(11) NOT NULL auto_increment,
  `DATE` timestamp(14) NOT NULL,
  `AMOUNT` decimal(10,2) default NULL,
  `OID` int(11) NOT NULL default '0',
  `COMMENT` text,
  `RID` int(11) default NULL,
  `FROM_RID` int(11) NOT NULL default '0',
  `FROM_MID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`PHID`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- 
-- Dumping data for table `sc_ref_credit_history`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `sc_ref_level`
-- 

CREATE TABLE `sc_ref_level` (
  `LID` int(11) NOT NULL default '0',
  `TYPE` int(11) NOT NULL default '0',
  `AMOUNT` decimal(10,5) NOT NULL default '0.00000',
  PRIMARY KEY  (`LID`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `sc_ref_level`
-- 

INSERT INTO `sc_ref_level` VALUES (1, 1, 0.50000);
INSERT INTO `sc_ref_level` VALUES (2, 1, 0.10000);
INSERT INTO `sc_ref_level` VALUES (3, 2, 5.00000);

-- --------------------------------------------------------

-- 
-- Table structure for table `sc_ref_pay_history`
-- 

CREATE TABLE `sc_ref_pay_history` (
  `RPID` int(11) NOT NULL auto_increment,
  `DATE` timestamp(14) NOT NULL,
  `RID` int(11) NOT NULL default '0',
  `AMOUNT` decimal(10,3) NOT NULL default '0.000',
  `COMMENT` text NOT NULL,
  PRIMARY KEY  (`RPID`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- 
-- Dumping data for table `sc_ref_pay_history`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `sc_refer`
-- 

CREATE TABLE `sc_refer` (
  `RID` int(11) NOT NULL auto_increment,
  `NAME` varchar(100) default NULL,
  `LOGIN` varchar(50) default NULL,
  `PASSWORD` varchar(100) default NULL,
  `ADDRESS` varchar(255) default NULL,
  `CITY` varchar(255) default NULL,
  `ZIP` varchar(255) default NULL,
  `STATE` varchar(100) default NULL,
  `COUNTRY` varchar(100) default NULL,
  `TEL` varchar(100) default NULL,
  `EMAIL` varchar(100) default NULL,
  `URL` varchar(100) default NULL,
  `PAY_METHOD` int(11) NOT NULL default '0',
  `ACC_NO` varchar(50) NOT NULL default '',
  `JOIN_DATE` timestamp(14) NOT NULL,
  `JOIN_IP` varchar(20) default NULL,
  `AMOUNT` decimal(10,2) default '0.00',
  `send_mail` int(11) NOT NULL default '1',
  `PARENT` int(11) NOT NULL default '0',
  `IS_DELETED` int(11) NOT NULL default '0',
  PRIMARY KEY  (`RID`),
  FULLTEXT KEY `JOIN_IP` (`JOIN_IP`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `sc_refer`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `sc_setting`
-- 

CREATE TABLE `sc_setting` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `value` varchar(100) NOT NULL default '',
  `description` varchar(100) default NULL,
  `type` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

-- 
-- Dumping data for table `sc_setting`
-- 

INSERT INTO `sc_setting` VALUES (1, 'Sales Tax Percentage', '7.5', '(ie. 7.5 would be 7.5% - no need to add the % symbol), If no sales tax leave blank.', 2);
INSERT INTO `sc_setting` VALUES (2, 'Item Shipping Cost', '0', '', 100);
INSERT INTO `sc_setting` VALUES (3, 'Client Use Paypal', 'Yes', 'blank/"no" for not using', 3);
INSERT INTO `sc_setting` VALUES (4, 'Paypal Account', 'paypal@safelistbiz.com', 'BUSINESS Account', 3);
INSERT INTO `sc_setting` VALUES (5, 'Client Use E-gold', 'Yes', 'blank/"no" for not using', 3);
INSERT INTO `sc_setting` VALUES (6, 'E-gold account', '', 'PAYEE_ACCOUNT', 3);
INSERT INTO `sc_setting` VALUES (7, 'Client Use Stormpay', 'yes', 'blank/"no" for not using', 3);
INSERT INTO `sc_setting` VALUES (8, 'Stormpay account', 'sales@heavenlybiz.com', 'PAYEE_EMAIL', 3);
INSERT INTO `sc_setting` VALUES (9, 'Client Use 2checkout', 'yes', 'blank/"no" for not using', 3);
INSERT INTO `sc_setting` VALUES (10, '2checkout account', '55555', 'sid', 3);
INSERT INTO `sc_setting` VALUES (11, 'Client Use SFIpay', 'yes', 'blank/"no" for not using', 3);
INSERT INTO `sc_setting` VALUES (12, 'SFIpay account', 'sales@heavenlybiz.com', 'receiver', 3);
INSERT INTO `sc_setting` VALUES (13, 'Client Use IntGold', 'yes', 'blank/"no" for not using', 3);
INSERT INTO `sc_setting` VALUES (14, 'IntGold account', '79073', 'SELLER ACCOUNT ID', 3);
INSERT INTO `sc_setting` VALUES (15, 'Client Use MoneyBookers', 'yes', 'blank/"no" for not using', 3);
INSERT INTO `sc_setting` VALUES (16, 'MoneyBookers account', '', 'pay_to_email', 3);
INSERT INTO `sc_setting` VALUES (17, 'Domain name', 'http://www.myprofitscripts.com/demos/shopcartdx', 'e.g. http://www.domain.com/shop', 1);
INSERT INTO `sc_setting` VALUES (18, 'Admin Password', 'admin', '', 1);
INSERT INTO `sc_setting` VALUES (19, 'Products/Page', '4', 'No. of Items per page', 1);
INSERT INTO `sc_setting` VALUES (20, 'Main Cat', '2', 'Default Category to show client', 1);
INSERT INTO `sc_setting` VALUES (21, 'Min_pay', '10.00', 'Minimum amount allowed for Affiliates to request payout.', 1);
INSERT INTO `sc_setting` VALUES (22, 'Admin_Email', 'contact@magical-money.com', 'Email account to receive payment request', 1);
INSERT INTO `sc_setting` VALUES (23, 'Company_Name', 'Your Shop Name', 'Company Name charged at payment', 1);
INSERT INTO `sc_setting` VALUES (24, 'Site_Name', 'Your Shop Name', 'Name of the site', 1);
INSERT INTO `sc_setting` VALUES (25, 'Support_Email_Address', 'shop@yourdomain.com', 'Support email address', 1);
INSERT INTO `sc_setting` VALUES (26, 'Affiliate shown per page', '10', 'for admin page', 4);
INSERT INTO `sc_setting` VALUES (27, 'new item show', '5', 'in client page left menu', 4);
INSERT INTO `sc_setting` VALUES (28, 'Affiliate Use Paypal', 'Yes', 'blank/"no" for not using', 3);
INSERT INTO `sc_setting` VALUES (29, 'Affiliate Use E-gold', 'no', 'blank/"no" for not using', 3);
INSERT INTO `sc_setting` VALUES (30, 'Affiliate Use Stormpay', 'Yes', 'blank/"no" for not using', 3);
INSERT INTO `sc_setting` VALUES (31, 'Affiliate Use SFIpay', 'Yes', 'blank/"no" for not using', 3);
INSERT INTO `sc_setting` VALUES (32, 'Affiliate Use IntGold', 'Yes', 'blank/"no" for not using', 3);
INSERT INTO `sc_setting` VALUES (33, 'Affiliate Use MoneyBookers', 'Yes', 'blank/"no" for not using', 3);
INSERT INTO `sc_setting` VALUES (34, 'Force random choose affiliate', 'Yes', 'blank/"no" for not using', 4);