IP : 18.219.205.55Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
jackpotjunglegam/
../
../
var/
softaculous/
./
eventum/
../
chyrp/
../
wp56/
../
zeus/
zeus.sql/
/
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Table structure for table `addressbook_table` --
CREATE TABLE `addressbook_table` ( `id` int(20) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `contact_name` varchar(100) NOT NULL, `first_name` varchar(100) NOT NULL, `last_name` varchar(100) NOT NULL, `company` varchar(500) NOT NULL, `email` varchar(200) NOT NULL, `address` varchar(500) NOT NULL, `city` varchar(100) NOT NULL, `suburb` varchar(100) NOT NULL, `state` varchar(100) NOT NULL, `country` varchar(100) NOT NULL, `zip` varchar(10) NOT NULL, `phone_no` varchar(20) NOT NULL, `fax` varchar(200) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- -- Dumping data for table `addressbook_table` --
INSERT INTO `addressbook_table` VALUES (1, 1, 'Demouser', 'Demouser', 'Demouser', '', 'demouser@ajsqaure.net', 'Lorem ipsum dolor', 'Lorem ipsum dolor', '', 'tamilnadu', 'AF', '625108', '', '');
-- -- Table structure for table `admin_settings_table` --
CREATE TABLE `admin_settings_table` ( `set_id` int(15) NOT NULL AUTO_INCREMENT, `customer_header` varchar(240) NOT NULL, `site_logo` varchar(240) NOT NULL, `google_analytics` text NOT NULL, `time_zone` varchar(100) NOT NULL, `site_moto` varchar(50) NOT NULL, `site_skin` varchar(50) NOT NULL, `admin_email` varchar(200) NOT NULL, `meta_kerwords` text NOT NULL, `meta_description` text NOT NULL, PRIMARY KEY (`set_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- -- Dumping data for table `admin_settings_table` --
INSERT INTO `admin_settings_table` VALUES (1, 'Exciting offers for this month !!!! ', 'images/logo.gif', '', '', '[[site_name]]', 'default', '[[admin_email]]', '', '');
-- -- Table structure for table `coupons_table` --
CREATE TABLE `coupons_table` ( `id` int(11) NOT NULL AUTO_INCREMENT, `coupon_code` varchar(25) NOT NULL, `coupan_name` varchar(200) NOT NULL, `created_date` datetime NOT NULL, `discount_amt` double NOT NULL, `discount_type` varchar(20) NOT NULL, `valid_from` date NOT NULL, `valid_to` date NOT NULL, `min_purchase` double NOT NULL, `no_of_uses` int(11) NOT NULL, `applies_to` mediumtext NOT NULL, `status` int(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- -- Table structure for table `currency_codes_table` --
CREATE TABLE `currency_codes_table` ( `currency_code` varchar(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `country_name` varchar(200) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `currency_name` varchar(200) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `numeric_code` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -- Dumping data for table `currency_codes_table` --
CREATE TABLE `faq_table` ( `faq_id` int(10) NOT NULL AUTO_INCREMENT, `faq_qn` mediumtext NOT NULL, `faq_ans` mediumtext NOT NULL, PRIMARY KEY (`faq_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-- -- Dumping data for table `faq_table` --
INSERT INTO `faq_table` VALUES (1, 'What is ZeusCart ?', 'Zeus Cart offers easy-to-use features to open your first online store quickly, advanced features for additional customization, and integration with desktop administrator control panel. Zeus Cart offers easy-to-use features to open your first online store quickly, advanced features for additional customization, and integration with desktop administrator control panel.Zeus Cart offers easy-to-use features to open your first online store quickly, advanced features for store quickly, advanced features for additional customization, store quickly, advanced features for additional customization, and integration with and integration with additional customization, and integration with desktop administrator control panel.'), (2, 'How it helps?', 'Allows user to purchase any item through online immediately.');
-- -- Table structure for table `paymentgateways_settings_table` --
CREATE TABLE `paymentgateways_settings_table` ( `pg_setting_id` int(9) NOT NULL AUTO_INCREMENT, `gateway_id` int(5) NOT NULL, `setting_name` varchar(300) NOT NULL, `setting_values` varchar(200) NOT NULL, `help_text` text NOT NULL, PRIMARY KEY (`pg_setting_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
-- -- Dumping data for table `paymentgateways_settings_table` --
INSERT INTO `paymentgateways_settings_table` VALUES (1, 5, 'API Login ID', '', 'The Login Id used for Authorize.Net Payment Gateway'), (2, 5, 'Transaction Key', '', 'The Transaction Key used for Authorize.Net Login'), (4, 5, 'Password', '', 'To be Provided Only when the Password Required Mode is Enabled.'), (7, 4, 'Merchant ID', '', 'The Merchant Id Used for Google Check Out'), (10, 1, 'Merchant ID', '', 'The Merchant Id Used for Paypal'), (11, 6, 'Merchant ID', '', 'The Merchant Id Used for 2Check Out'), (12, 7, 'Merchant ID', '', 'The Merchant Id Used for World Pay'), (13, 10, 'Merchant ID', '', 'The Merchant Id Used for Paymate'), (14, 11, 'Merchant ID', '', 'The Merchant Id Used for Money Bookers'), (15, 12, 'Merchant ID', '', 'The Merchant Id Used for PSI Gate'), (16, 13, 'Merchant ID', '', 'The Merchant Id Used for Strom Pay'), (17, 14, 'Merchant ID', '', 'The Merchant Id Used for Alert Pay'), (18, 15, 'Merchant ID', '', 'The Merchant Id Used for Your Pay'), (19, 16, 'Merchant ID', '', 'The Merchant Id Used for Itransact'), (20, 17, 'Merchant ID', '', 'The Merchant Id Used for Blue Pay'), (21, 18, 'Merchant ID', '', 'The Merchant Id Used for Safe Pay');
-- -- Table structure for table `products_table` --
CREATE TABLE `products_table` ( `product_id` int(25) NOT NULL AUTO_INCREMENT, `category_id` varchar(100) NOT NULL, `sku` varchar(100) NOT NULL, `title` varchar(250) NOT NULL, `alias` varchar(100) NOT NULL, `description` text NOT NULL, `brand` varchar(100) NOT NULL, `model` varchar(50) NOT NULL, `msrp` double NOT NULL, `price` double NOT NULL, `cse_enabled` int(1) NOT NULL, `cse_key` varchar(100) DEFAULT NULL, `weight` varchar(25) NOT NULL, `dimension` varchar(100) NOT NULL, `thumb_image` varchar(150) NOT NULL, `image` varchar(150) NOT NULL, `large_image_path` varchar(150) NOT NULL, `shipping_cost` double NOT NULL, `status` int(1) NOT NULL, `tag` varchar(200) NOT NULL, `meta_desc` varchar(255) NOT NULL, `meta_keywords` text NOT NULL, `intro_date` date NOT NULL, `is_featured` int(1) NOT NULL, `digital` int(10) NOT NULL, `gift` int(20) NOT NULL, `digital_product_path` varchar(200) NOT NULL, `has_variation` tinyint(10) NOT NULL, `product_status` int(1) NOT NULL COMMENT '1=>new products,2=>discount product', PRIMARY KEY (`product_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
-- -- Table structure for table `product_variation_table` --
CREATE TABLE `product_variation_table` ( `variation_id` bigint(12) NOT NULL AUTO_INCREMENT, `product_id` bigint(12) NOT NULL, `sku` varchar(100) NOT NULL, `variation_name` varchar(250) NOT NULL, `description` text NOT NULL, `msrp` double NOT NULL, `price` double NOT NULL, `weight` varchar(25) NOT NULL, `dimension` varchar(100) NOT NULL, `thumb_image` varchar(150) NOT NULL, `image` varchar(150) NOT NULL, `large_image` varchar(240) NOT NULL, `shipping_cost` double NOT NULL, `soh` bigint(12) NOT NULL, `rol` bigint(10) NOT NULL, `status` tinyint(1) NOT NULL, PRIMARY KEY (`variation_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- -- Table structure for table `shopping_cart_products_table` --
CREATE TABLE `shopping_cart_products_table` ( `id` int(20) NOT NULL AUTO_INCREMENT, `cart_id` int(25) NOT NULL, `product_id` varchar(100) NOT NULL, `product_qty` int(10) NOT NULL, `date_added` date NOT NULL, `product_unit_price` double NOT NULL, `shipping_cost` double NOT NULL, `variation_id` int(20) NOT NULL, `original_price` double NOT NULL, `gift_product` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- -- Table structure for table `social_link_content_table` --
CREATE TABLE `social_link_content_table` ( `content_id` int(20) NOT NULL AUTO_INCREMENT, `content_title` varchar(240) NOT NULL, `content_desc` mediumtext NOT NULL, PRIMARY KEY (`content_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- -- Dumping data for table `social_link_content_table` --
INSERT INTO `social_link_content_table` VALUES (1, 'Facebook Alert', '<ol><li>On Zeuscart V4, you can use click <strong><span style="color: #000000;">Login with Facebook</span></strong>, this will allow us to register your Facebook account on our website.</li><li>The second step, Click the "<span style="color: #000000;"><strong>Allow</strong></span>" Button, which will save your Name and Email on our website. No password is required as long as you are logged in Facebook.</li><li><strong>You will automatically be logged on to our website via Facebook. For security purposes, we recommend you log out your Facebook account once done.</strong></li></ol><p>Thanks & Regards<br />Zeuscart Team.</p>');
CREATE TABLE `users_table` ( `user_id` int(25) NOT NULL AUTO_INCREMENT, `user_display_name` varchar(50) NOT NULL, `user_fname` varchar(50) NOT NULL, `user_lname` varchar(50) NOT NULL, `user_email` varchar(50) NOT NULL, `user_pwd` varchar(150) NOT NULL, `user_group` int(11) NOT NULL, `user_country` varchar(100) NOT NULL, `user_status` int(2) NOT NULL, `user_doj` date NOT NULL, `billing_address_id` int(10) NOT NULL, `shipping_address_id` int(10) NOT NULL, `ipaddress` varchar(100) NOT NULL, `social_link_id` varchar(100) NOT NULL, `is_from_social_link` int(20) NOT NULL, `confirmation_code` int(20) NOT NULL, PRIMARY KEY (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- -- Table structure for table `wishlist_table` --
CREATE TABLE `wishlist_table` ( `wishlist_id` int(20) NOT NULL AUTO_INCREMENT, `user_id` int(20) NOT NULL, `product_id` int(20) NOT NULL, `date_added` date NOT NULL, `comments` mediumtext NOT NULL, PRIMARY KEY (`wishlist_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- -- Dumping data for table `wishlist_table` --
INSERT INTO `wishlist_table` VALUES (1, 1, 1, '2013-02-23', '');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;