Hello [first name] [Last name],
\r\n\r\nThank you for registering with Letshop.
\r\n\r\nTo gain access, [url]
\r\n\r\nThen sign in using these credentials:
\r\n\r\nEmail: [licence email]
\r\n\r\nPassword: you have set at time of account opening
\r\n\r\nBe sure to save these details securely to facilitate
\r\nlogging in the future.
The system is simple to access and operate. If you have
\r\nany trouble or any questions, please feel free to contact
\r\nus
Once again, thank you for choosing us!
\r\n\r\n\r\n\r\n
Regards
\r\n\r\n', '
Email Used when user Register with us. Sends this mail to welcome them
\r\n', 1, 1, '2017-11-10 00:00:00', '2018-01-16 17:16:01'), (2, 1, 'forget_password', 'Forget Password', 'Request for new password', 'Hi [first name] [last name] ,
\r\n\r\n
\r\nClick here to reset pasword: [reset link]
\r\n
\r\nYour login email is [licence email]
Best regards
', 'If user forgets their password and request for new one ', 3, 1, '2017-11-10 00:00:00', '2017-12-21 18:43:20'), (3, 1, 'reset_password', 'Reset Password Successfully', 'Reset Password Successfully', 'Hi [first name] [last name] ,
\r\n\r\n\r\n\r\n
You have successfully reset your password.
\r\n\r\nPlease now login with
\r\n\r\nemail : [licence email]
\r\n\r\nand password which you heve recently set
', 'Confirms their password reset request is successful.', 2, 1, '2017-11-10 00:00:00', '2017-12-21 18:43:19'), (4, 1, 'contact_us', 'Contact Us', 'Request for Contacting us', 'Hello [first name] [Last name],
\r\n\r\ntried to contact with Letshop.
\r\n\r\nPlease reply on mail: [licence email]
\r\n\r\nfor the following query
\r\n\r\n[message]
\r\n\r\n\r\n\r\n
', 'This email is used when user wants to contact with the admin and posts their query.', 4, 1, '2017-11-13 00:00:00', '2017-12-28 15:57:52'), (5, 1, 'subscription', 'Subcription', 'Subscribe with Letsshop', '
Hello
\r\n\r\nThank you for your subscription with the mail [licence email]
\r\n\r\non [date and time]
\r\n\r\nWe will update you regularly with our offers and discount
', 'Confirmation that user is successfully subscribed
\r\n', 5, 1, '2017-11-13 00:00:00', '2018-01-08 15:23:06'), (6, 1, 'guest_register', 'Guest Registration', 'Congratulations You are registered', 'Hello [first name] [Last name],
\r\n\r\nThank you for registering with Letshop.
\r\n\r\nTo gain access, [url]
\r\n\r\nThen sign in using these credentials:
\r\n\r\nEmail: [licence email]
\r\n\r\nPassword: [password]
\r\n\r\nBe sure to save these details securely to facilitate
\r\nlogging in the future.
The system is simple to access and operate. If you have
\r\nany trouble or any questions, please feel free to contact
\r\nus
Once again, thank you for choosing us!
\r\n\r\nBest Regards
\r\n\r\n', 'If account is created for guest user . This email is used to send the credentials to the user for their account.', 6, 1, '2017-11-15 00:00:00', '2017-12-21 18:43:18'), (7, 1, 'order_summary', 'Order Summary', 'Your Order details are', '
Hello [first name] [Last name]
\r\n\r\n[product details]
\r\n\r\nCity [city] , State [state]
\r\n\r\nCountry [country]
\r\n\r\n[zipcode]
\r\n\r\nTotal amount to be paid is [amount]
\r\n\r\nOrdered on [date and time]
\r\n\r\nThank You for shopping with us
', 'Details of the orders including its shipping details order details and payment details', 7, 1, '2017-11-16 00:00:00', '2017-12-21 18:43:17'), (8, 1, 'status_of_product', 'Status Of Product', 'Your Product Status is', 'Hello [first name] [Last name]
\r\n\r\nYour order [product name]
\r\n\r\nQuantity - [product quantity] ordered on [date and time]
\r\n\r\nHas been [status]
\r\n\r\nAmount Paid [product price]
\r\n\r\nThank You for shopping with us
', 'This email is send to update the user about the current status of their order', 8, 1, '2017-11-21 00:00:00', '2017-12-21 18:43:17'), (9, 1, 'recurring_payment', 'Recurring Payment', 'Payment Succcessfull', 'Hello [first name] [Last name]
\r\n\r\nThe scheduled payment for the product is successful. on [date and time]
\r\n\r\nHere are the details
\r\n\r\nProduct Name: [product name]
\r\n\r\nPrice: [recurring_price]
\r\n\r\nProduct Quantity: [product quantity]
\r\n\r\nThe Payment is scheduled for [duration]
\r\n\r\nFor [times] times
\r\n\r\nTotal Amount Paid : [total]
\r\n\r\nThe amount is paid by using [mode]
\r\n\r\nYou can check by login from [licence email]
\r\n\r\nThank You
', 'This is to notify the user about their scheduled recurring payments is successful', 9, 1, '2017-12-21 00:00:00', '2017-12-21 18:43:16'), (10, 1, 'recurring_payment_failure', 'Recurring Payment Failure', 'Failure of Payment Update Card', 'Hello [first name] [Last name]
\r\n\r\nYour payment for the last scheduled order
\r\n\r\n[product name] : x [product quantity] price [recurring_price]
\r\n\r\ntotal = [total]
\r\n\r\nusing [mode]
\r\n\r\nis failed.
\r\n\r\nPlease click on below link to update your credentials.
\r\n\r\n\r\n\r\n\r\n\r\n
Thank you
', 'This is to notify that the payment for their recurring order is failed.Kindly update their cards', 10, 1, '2017-12-21 00:00:00', '2017-12-21 18:43:16'), (11, 1, 'refund_successful', 'Refund Successful', 'Order Refund Successfull', 'Hello [first name] [Last name]
\n\nYour refund for the order
\n\nProduct Name: [product name]
\n\nQuantity: [product quantity]
\n\nProduct Price : [product price]
\n\nis successful.
\n\nYou can check your order status in your account associated with [licence email]
\n\nOrder again
\n\nHave a nice day
\n\nThank You
\n', 'This is to notify users refund request is successful and we have refunded for their order', 8, 1, '2017-12-21 00:00:00', '2017-12-21 18:57:04'), (12, 1, 'forget_password_admin', 'Admin Forget Password', 'Forget Password', 'Hi [first name] [last name] ,
\r\n\r\n
\r\nClick here to reset pasword: [reset link]
\r\n
\r\nYour login email is [licence email]
Best regards
', 'Admin password reset request ', 3, 1, '2018-01-01 00:00:00', NULL), (13, 1, 'canceled_refund_request', 'Canceled Refund Request', 'Your refund request is Canceled', 'Hello [first name] [Last name]
\n\nYour request for [product name] [product price] [product quantity] is cancelled by the admin.
\n\nThank you
\n\n[licence email]
\n', 'cancelled refund request
\r\n', 8, 1, '2018-01-11 00:00:00', '2018-01-11 17:27:24'); -- -------------------------------------------------------- -- -- Table structure for table `email_template_type` -- CREATE TABLE `email_template_type` ( `email_template_type_id` int(11) NOT NULL, `token` varchar(255) NOT NULL, `msg_token` varchar(255) NOT NULL, `template_type_status` tinyint(1) NOT NULL, `template_type_created` datetime NOT NULL, `template_type_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `email_template_type` -- INSERT INTO `email_template_type` (`email_template_type_id`, `token`, `msg_token`, `template_type_status`, `template_type_created`, `template_type_modified`) VALUES (1, '[licence email],[first name],[Last name],[url]', '[licence email],[first name],[Last name],[amount],[date and time], [password]', 1, '2017-11-10 00:00:00', NULL), (2, '[licence email],[first name],[last name],[date and time]', '[licence email],[first name],[last name],[date and time]', 1, '2017-11-10 00:00:00', NULL), (3, '[licence email],[first name],[last name],[reset link],[date and time]', '[licence email],[first name],[last name],[reset link],[date and time]', 1, '2017-11-10 00:00:00', NULL), (4, '[licence email],[first name],[Last name],[date and time],[message]', '[licence email],[first name],[Last name],[amount],[date and time], [password]', 1, '2017-11-13 00:00:00', NULL), (5, '[licence email],[date and time]', '[licence email],[date and time]', 1, '2017-11-13 00:00:00', NULL), (6, '[licence email],[first name],[Last name],[url],[password]', '[licence email],[first name],[Last name],[amount],[date and time], [password]', 1, '2017-11-15 00:00:00', NULL), (7, '[licence email],[first name],[Last name],[amount],[date and time],[city],[state],[country],[zipcode],[product details]', '[licence email],[first name],[Last name],[amount],[date and time], [password]', 1, '2017-11-16 00:00:00', NULL), (8, '[licence email],[first name],[Last name],[date and time],[product name], [product price], [product quantity],[status]', '[licence email],[first name],[Last name],[date and time],[product name], [product price], [product quantity]', 1, '2017-11-21 00:00:00', NULL), (9, '[licence email],[first name],[Last name],[date and time],[product name], [recurring_price], [product quantity],[duration] ,[times],[total],[mode]', '[licence email],[first name],[Last name],[date and time],[product name], [product price], [product quantity]', 1, '2017-12-21 00:00:00', NULL), (10, '[licence email],[first name],[Last name],[date and time],[product name], [recurring_price], [product quantity],[duration] ,[times],[total],[mode],[url]', '[licence email],[first name],[Last name],[date and time],[product name], [recurring_price], [product quantity],[duration] ,[times],[total],[mode]', 1, '2017-12-21 00:00:00', NULL); -- -------------------------------------------------------- -- -- Table structure for table `faqs` -- CREATE TABLE `faqs` ( `faq_id` int(11) NOT NULL, `products_id` int(11) NOT NULL, `faq_question` varchar(1000) NOT NULL, `faq_answer` text NOT NULL, `faq_status` tinyint(1) NOT NULL COMMENT '0 for inactive 1 for active', `faq_created` datetime NOT NULL, `faq_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `faqs` -- INSERT INTO `faqs` (`faq_id`, `products_id`, `faq_question`, `faq_answer`, `faq_status`, `faq_created`, `faq_modified`) VALUES (1, 61, 'What about Durability of product?', 'Philips is a brand, who always gives best in Home Appliances and serving the community. As always this o=product is also come with it\'s best.', 1, '2018-04-20 12:11:00', '2018-04-20 13:22:13'); -- -------------------------------------------------------- -- -- Table structure for table `footer_tabs` -- CREATE TABLE `footer_tabs` ( `footer_tab_id` int(11) NOT NULL, `groups_id` int(11) NOT NULL, `tab_1` varchar(255) NOT NULL, `tab_2` varchar(255) NOT NULL, `footer_tab_created` datetime NOT NULL, `footer_tab_modified` datetime DEFAULT NULL, `tab_3` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `groups` -- CREATE TABLE `groups` ( `group_id` int(11) NOT NULL, `group_name` varchar(20) NOT NULL, `group_status` tinyint(1) NOT NULL, `group_created` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `groups` -- INSERT INTO `groups` (`group_id`, `group_name`, `group_status`, `group_created`) VALUES (1, 'admin', 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `group_pages` -- CREATE TABLE `group_pages` ( `group_page_id` int(11) NOT NULL, `group_page_name` varchar(30) NOT NULL, `group_page_status` tinyint(1) NOT NULL COMMENT '0 for deactive;1 for active', `group_pages_created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `group_pages` -- INSERT INTO `group_pages` (`group_page_id`, `group_page_name`, `group_page_status`, `group_pages_created`) VALUES (1, 'Policy', 1, '2018-04-16 00:00:00'), (2, 'Company', 1, '2018-04-16 05:06:17'), (3, 'Our Businesss', 1, '2018-04-16 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `headings_info` -- CREATE TABLE `headings_info` ( `heading_info_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, `popular` varchar(255) NOT NULL, `products` varchar(255) NOT NULL, `product_image_original` varchar(255) NOT NULL, `product_mask_name` varchar(255) NOT NULL, `product_status` tinyint(1) NOT NULL, `heading_info_created` datetime NOT NULL, `heading_info_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `login_logs` -- CREATE TABLE `login_logs` ( `users_id` int(10) NOT NULL, `login_log_from` int(10) NOT NULL, `login_log_mode` varchar(256) NOT NULL, `login_log_ip_address` varchar(256) NOT NULL, `login_log_user_agent` varchar(256) NOT NULL, `login_log_created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `logo_images` -- CREATE TABLE `logo_images` ( `logo_image_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, `logo_type` tinyint(1) DEFAULT NULL, `logo_status` tinyint(1) DEFAULT NULL, `logo_image_original` varchar(255) DEFAULT NULL, `logo_mask_name` varchar(255) DEFAULT NULL, `logo_image_created` datetime DEFAULT NULL, `logo_modified` datetime DEFAULT NULL, `favicon_image_original` varchar(255) DEFAULT NULL, `favicon_mask_name` varchar(255) DEFAULT NULL, `favicon_type` tinyint(1) DEFAULT NULL, `favicon_status` tinyint(1) DEFAULT NULL, `favicon_created` datetime DEFAULT NULL, `favicon_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `menu_positions` -- CREATE TABLE `menu_positions` ( `menu_position_id` int(11) NOT NULL, `groups_id` int(11) NOT NULL, `positioning` tinyint(1) NOT NULL, `menu_name` varchar(5) NOT NULL, `menu_type` tinyint(4) NOT NULL COMMENT '1 home, 2 product,3 categories,4 brands,5 for blog , 6 contact', `menu_status` tinyint(4) NOT NULL COMMENT '1 for show , 0 for hide', `menu_position_created` datetime NOT NULL, `menu_position_updated` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `menu_positions` -- INSERT INTO `menu_positions` (`menu_position_id`, `groups_id`, `positioning`, `menu_name`, `menu_type`, `menu_status`, `menu_position_created`, `menu_position_updated`) VALUES (2, 1, 1, 'set_1', 1, 1, '2018-04-02 00:00:00', '2018-04-20 11:48:17'), (3, 1, 3, 'set_2', 2, 1, '2018-04-02 00:00:00', '2018-04-20 11:48:18'), (5, 1, 2, 'set_4', 4, 1, '2018-04-02 00:00:00', '2018-04-20 11:48:17'), (6, 1, 5, 'set_5', 5, 1, '2018-04-02 00:00:00', '2018-04-20 11:48:18'), (7, 1, 4, 'set_6', 6, 1, '2018-04-02 00:00:00', '2018-04-20 11:48:18'); -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE `pages` ( `page_id` int(11) NOT NULL, `group_pages_id` int(11) NOT NULL, `page_type` tinyint(1) NOT NULL COMMENT '1 for policy , 2 for company , 3 for buissness', `page_name` varchar(50) NOT NULL, `page_slug` varchar(255) NOT NULL, `page_body` text NOT NULL, `page_metakeyword` varchar(1000) NOT NULL, `page_metadescription` varchar(1000) NOT NULL, `page_status` tinyint(1) NOT NULL DEFAULT '1', `page_created` datetime NOT NULL, `page_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `pages` -- INSERT INTO `pages` (`page_id`, `group_pages_id`, `page_type`, `page_name`, `page_slug`, `page_body`, `page_metakeyword`, `page_metadescription`, `page_status`, `page_created`, `page_modified`) VALUES (1, 1, 0, 'How It Works', 'how_it_works', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
\r\n\r\nContrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', 'How it Works', 'How it Works', 1, '2017-10-13 00:00:00', '2018-04-16 17:02:05'), (2, 1, 1, 'Terms & Conditions', 'terms_conditions', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
\r\n\r\nContrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', 'Terms & Conditions', 'Terms & Conditions', 1, '2017-10-13 00:00:00', '2018-04-16 16:49:12'), (3, 1, 1, 'Privacy Policy', 'privacy_policy', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
\r\n\r\nContrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', 'Privacy Policy', 'Privacy Policy', 1, '2017-10-13 00:00:00', '2018-04-16 16:49:28'), (4, 2, 2, 'About us', 'about_us', 'accompanied by English versions from the 1914 translation by H. Rackham.
', 'About us', 'About us', 1, '2017-10-13 16:35:48', '2018-04-16 17:00:21'), (5, 1, 1, 'Terms of Sale ', 'terms_of_sale', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
\r\n\r\nnm,
', 'Terms & Conditions', 'Terms & Conditions', 1, '2017-10-13 16:35:48', '2018-04-16 17:00:16'), (6, 1, 1, 'Terms of Use', 'terms_of_use', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
\r\n\r\nContrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', 'Terms of Use', 'Terms of Use', 1, '2017-10-13 16:35:48', '2018-04-16 17:00:19'), (7, 2, 2, 'Core Values', 'core_values', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
\r\n\r\nContrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', 'Core Values', 'Core Values', 1, '2017-10-13 16:35:48', '2018-04-16 17:00:23'), (8, 2, 3, 'Careers', 'careers', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
\r\n\r\nContrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.
', 'Careers', 'Careers', 1, '2017-10-13 16:35:48', '2018-04-17 18:49:19'), (9, 1, 1, 'Report Abuse', 'report_abuse', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Report Abuse', 'Report Abuse', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:40'), (10, 2, 2, 'Engineering', 'engineering', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32.
', 'Engineering', 'Engineering', 1, '2017-10-24 00:00:00', '2018-04-16 16:59:32'), (11, 3, 3, 'Online Shopping', 'online_shopping', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Online Shopping', 'Online Shopping', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:14'), (12, 3, 3, 'Sell on Online', 'sell_on_online', ''Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \\"de Finibus Bonorum et Malorum\\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \\"Lorem ipsum dolor sit amet..\\", comes from a line in section 1.10.32. The standard chunk of Lorem
', 'Sell on Online', 'Sell on Online', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:12'), (13, 3, 3, 'Advertise on Online', 'advertise_on_online', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Advertise on Online', 'Advertise on Online', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:12'), (14, 3, 3, 'Media Enquiries', 'media_enquiries', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Media Enquiries', 'Media Enquiries', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:11'), (15, 3, 3, 'Be an Affiliate ', 'be_an_affiliate ', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.\r\n\r\nContrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 'Be an Affiliate ', 'Be an Affiliate ', 1, '2017-10-24 00:00:00', '2018-04-16 17:01:11'); -- -------------------------------------------------------- -- -- Table structure for table `payment_details` -- CREATE TABLE `payment_details` ( `payment_detail_id` int(11) NOT NULL, `customer_orders_id` int(11) DEFAULT NULL, `customers_id` int(11) NOT NULL, `description` text NOT NULL, `paid_amount` decimal(10,2) NOT NULL, `currency` varchar(255) NOT NULL, `payment_status` int(11) NOT NULL, `payment_mode` tinyint(1) NOT NULL COMMENT '1 for paypal , 2 for authorise , 3 for stripe', `payment_details_created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `plans` -- CREATE TABLE `plans` ( `plan_logs_id` int(11) NOT NULL, `plans_id` int(11) NOT NULL, `product_limit` varchar(255) CHARACTER SET utf8 NOT NULL, `plan_log_created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `product_id` int(10) NOT NULL, `product_name` varchar(256) CHARACTER SET utf8 NOT NULL, `product_description` text CHARACTER SET utf8 NOT NULL, `mrp_price` decimal(10,2) NOT NULL, `sale_price` decimal(10,2) DEFAULT '0.00', `shipping_price` decimal(10,2) NOT NULL DEFAULT '0.00', `recurring` tinyint(1) NOT NULL, `duration` tinyint(1) DEFAULT NULL, `returning` int(10) NOT NULL, `recurring_price` varchar(255) DEFAULT NULL, `infinite` tinyint(1) DEFAULT '0', `times` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `brands_id` int(10) DEFAULT NULL, `categories_id` int(11) DEFAULT NULL, `product_status` tinyint(1) NOT NULL COMMENT '1 for active , 0 for Inactive', `product_slug` varchar(256) CHARACTER SET utf8 NOT NULL, `video_link` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `meta_tags` varchar(256) CHARACTER SET utf8 DEFAULT NULL, `keywords` varchar(256) CHARACTER SET utf8 DEFAULT NULL, `meta_description` text CHARACTER SET utf8, `product_tag` varchar(256) CHARACTER SET utf8 DEFAULT NULL, `is_featured` tinyint(1) DEFAULT '0', `product_created` datetime NOT NULL, `product_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `products` -- INSERT INTO `products` (`product_id`, `product_name`, `product_description`, `mrp_price`, `sale_price`, `shipping_price`, `recurring`, `duration`, `returning`, `recurring_price`, `infinite`, `times`, `brands_id`, `categories_id`, `product_status`, `product_slug`, `video_link`, `meta_tags`, `keywords`, `meta_description`, `product_tag`, `is_featured`, `product_created`, `product_modified`) VALUES (57, 'Test 3', 'Testing Product 3
', '200.00', '120.00', '20.00', 0, 0, 15, '', 1, '', 61, 28, -1, 'radio', '', 'sd', 'ds', 'sd', NULL, 1, '2018-03-13 16:19:33', '2018-04-20 11:48:40'), (58, 'Test 4', 'test
', '90.00', '74.00', '12.00', 0, 0, 15, '', 1, '', 61, 26, -1, 'jbl-c100si-in-ear-headphones-with-mic-black', NULL, NULL, NULL, NULL, NULL, 1, '2018-03-14 12:41:27', '2018-04-20 11:48:36'), (59, 'Test 2', 'test your product
', '500.00', '300.00', '20.00', 0, 0, 12, '5', 1, '', 61, 25, -1, 'fogg-stainless-steel-day-and-date-blue-dial-analog-mens-watch-2038-bl', NULL, NULL, NULL, NULL, NULL, 1, '2018-03-14 12:49:39', '2018-04-20 11:48:34'), (60, 'Test1', 'testing product
', '250.00', '150.00', '0.00', 1, 1, 15, '5', 1, '', 61, 27, -1, 'inkovy-full-sleeve-mens-cotton-hooded-t-shirt', NULL, NULL, NULL, NULL, NULL, 1, '2018-03-21 14:56:11', '2018-04-20 11:48:33'), (61, 'Lakmé Youth Infinity Skin Firming Night Crème', 'Application
\r\n\r\nStep 1: Take a dollop of the crème in your palm. Step 2: Use your finger and apply it evenly across your face. Step 3: Gently massage the crème with your 2 fingers (index and middle) into your skin in an upward direction. Step 4: Do this once every night before going to bed.
\r\n\r\n\r\n\r\n
Description
\r\n\r\nWake up to younger, tighter & flawless skin as Lakmé Youth Infinity Skin Firming Night Crème regenerates your skin overnight, making it brighter, softer & smoother with every application. It is dermatologically tested, suitable for all skin types and is highly recommended by Salon Experts.
', '239.00', '0.00', '0.00', 0, 0, 15, '', 1, '', 61, 24, 1, 'godrej-255-l-direct-cool-single-door-4-star-refrigerator-erica-blue-rd-edge-duo-255-pd-inv42', '', 'Lakmé Youth Infinity Skin Firming Night Crème', 'Lakmé Youth Infinity Skin Firming Night Crème', 'Lakmé Youth Infinity Skin Firming Night Crème', 'Lakmé Youth Infinity Skin Firming Night Crème', 1, '2018-04-20 11:53:42', '2018-04-23 12:27:50'), (62, 'Fashion Brow Pomade Crayon', 'Master the perfect brow in one simple sweep. Sculpt and tame bushy brows into refined shape with one creamy swipe of the crayon. This easy-to-use pomade crayon sculpts and tames eyebrows as it colors.
\r\n\r\n1. Achieve perfect brows in just one stroke.
\r\n2. Suitable to sculpt bushy brows.
\r\n3. Creamy texture that is easy to use.
\r\n\r\n
Draw small strokes along the brow contour to achieve groomed, well-shaped brows.
', '490.00', '0.00', '0.00', 0, 0, 15, '', 1, '', 61, 29, 1, 'samsung-394-l-3-star-frost-free-double-door-refrigerator-rt39m5538s8tl-elegant-inox-5-in-1-convertibleinverter-compressor', NULL, 'Fashion Brow Pomade Crayon', 'Fashion Brow Pomade Crayon', 'Fashion Brow Pomade Crayon', 'Fashion Brow Pomade Crayon', 1, '2018-04-20 12:27:06', '2018-04-23 12:33:16'), (63, 'Redmi 4 (Black, 32 GB)', 'Go beyond the conventional and highlight for a vibrant and chiseled look. The Color and Highlight Kit allows you to blush your own way. Use each shade alone or Mix and match to create a custom cheek color.
\r\n\r\n\r\n\r\n
\r\n\r\n
The new perlite formula absorbs oil and sweat and gives you a fresh look all through the day, now with SPF 28. It's time to bid goodbye to touch-ups and stay fresh and fair up to 12 hours.
\r\n\r\n\r\n\r\n
White Super Fresh has UV filters protects skin from both sun darkening and damage
\r\n- Helps you stay 12HR Fair and Fresh
\r\n- Contains Perlite, a pure mineral that helps absorbs oil and sweat
\r\n- Gives a naturally perfect-looking complexion
\r\n- Contains SPF 28 to protect your skin
\r\n- Suitable for everyday use
\r\n\r\n
STEP 1: Using the sponge applicator, apply to the forehead, nose, cheeks, and chin.
\r\nSTEP 2: Blend all over using gentle downward strokes.
Applicable
\r\n\r\nStep 1 - Take a coin-sized amount of the product on the palm.
\r\nStep 2 - Using fingers, dot the sunscreen on the forehead, cheeks, chin and neck.
\r\nStep 3 – Use fingertips to dot the gel evenly across the face.
\r\nStep 4 – Reapply after every 2-3 hours for effective results.
Description
\r\n\r\nGet 97% protection from harmful UV rays with Lakme’s all new gel format sunscreen. Non-sticky and lightweight by nature, the Lakmé Sun Expert Ultra Matte Gel Sunscreen SPF50 is ideal to use in Indian weather conditions and perfect for those with oily skin. It spreads effortlessly and gives your skin an ultra matte finish.
', '400.00', '0.00', '20.00', 0, 0, 15, '', 1, '', 62, 35, 1, 'charles-study-chair-2-axis-adjustable', '', 'Lakmé Sun Expert Ultra Matte Gel Sunscreen SPF 50 PA+++ 50 ML', 'Lakmé Sun Expert Ultra Matte Gel Sunscreen SPF 50 PA+++ 50 ML', '', 'Lakmé Sun Expert Ultra Matte Gel Sunscreen SPF 50 PA+++ 50 ML', 1, '2018-04-20 16:45:13', '2018-04-23 12:26:15'), (67, 'Lasting Drama Gel Smooth Charcoal', 'The Eye Studio Lasting Drama Gel Pencil has a long-lasting gel formula that helps achieve bold and intense pigmentation that lasts all day without any creasing. This smudge-resistant gel eyeliner glides on smoothly for intense definition and color that stays put all day.
\r\n\r\n\r\n\r\n
1. Delivers intense pigmentation that lasts up to 16 hours.
\r\n
\r\n2. Water-proof and Smudge-resistant formula
\r\n
\r\n3. Ophthalmologist, dermatologist and allergy tested.
\r\n
\r\n4. Suitable for sensitive eyes and contact lens wearers.
\r\n\r\n
1. Glide the gel liner along the lash line from the inner to outer corner of the eye.
\r\n2. Eyeliner is easily removed with Oil-Free Eye Makeup Remover.
2
', '2.00', '0.00', '0.00', 0, 1, 2, '0', 1, '0', 61, 24, -1, 'sdf', NULL, NULL, NULL, NULL, NULL, 0, '2018-04-23 12:48:04', '2018-04-23 12:48:10'); -- -------------------------------------------------------- -- -- Table structure for table `product_colors` -- CREATE TABLE `product_colors` ( `product_colors_id` bigint(20) NOT NULL, `products_id` int(10) NOT NULL, `colors_name` varchar(256) CHARACTER SET utf8 NOT NULL, `product_color_created` datetime NOT NULL, `product_color_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `product_csv_files` -- CREATE TABLE `product_csv_files` ( `csv_file_id` int(11) NOT NULL, `csv_file_original` varchar(255) NOT NULL, `csv_mask_name` text NOT NULL, `csv_file_created_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `product_dimensions` -- CREATE TABLE `product_dimensions` ( `product_dimensions_id` int(10) NOT NULL, `products_id` int(10) NOT NULL, `height` decimal(10,2) DEFAULT NULL, `width` decimal(10,2) DEFAULT NULL, `weight` decimal(10,2) DEFAULT NULL, `dimensions_created` datetime NOT NULL, `dimensions_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `product_dimensions` -- INSERT INTO `product_dimensions` (`product_dimensions_id`, `products_id`, `height`, `width`, `weight`, `dimensions_created`, `dimensions_modified`) VALUES (1, 61, '0.00', '0.00', '0.00', '2018-04-20 12:02:18', '2018-04-20 16:37:53'), (2, 62, '0.00', '0.00', '0.00', '2018-04-20 12:29:54', '2018-04-23 12:41:40'), (3, 64, '0.00', '0.00', '0.00', '2018-04-20 13:31:21', '2018-04-23 12:19:54'), (4, 65, '0.00', '0.00', '0.00', '2018-04-20 14:35:50', '2018-04-20 14:46:03'); -- -------------------------------------------------------- -- -- Table structure for table `product_images` -- CREATE TABLE `product_images` ( `product_image_id` int(10) NOT NULL, `products_id` int(10) NOT NULL, `product_image_original` varchar(256) NOT NULL, `product_mask_name` varchar(256) NOT NULL, `image_created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `product_images` -- INSERT INTO `product_images` (`product_image_id`, `products_id`, `product_image_original`, `product_mask_name`, `image_created`) VALUES (201, 59, '260c8d0454b4b03ca573ee4730c7fd1b.jpg', '072a068cf8d3c99e5f7954ad5296da31.jpg', '2018-04-13 13:44:57'), (202, 58, 'f4ac2515ed82a343e7a45b6ebf986c3d.jpg', '1d9be41ad2ec862ea394d6cede7bfadb.jpg', '2018-04-13 13:45:13'), (203, 57, 'eeea355f874be87000beae8e2db2def6.jpg', 'bb9f2f2318d1a762418727a8920b2653.jpg', '2018-04-13 13:45:30'), (204, 60, 'c353498c74d7673ba202b9cb2334b1cb.jpg', 'f41b5f789314d10212b86f9d27d94e10.jpg', '2018-04-13 13:50:18'), (225, 63, '1d47956f98aa99c81550d61e6b0dbcdab334db28.jpeg', '5ad93adafdeb6ea72372d5bdbd3c3e6d.jpeg', '2018-04-20 13:00:14'), (226, 63, '1d47956f98aa99c81550d61e6b0dbcdab334db28.jpeg', '7a1a73874c84c9cee3ae466f24696507.jpeg', '2018-04-20 13:00:41'), (227, 63, '201609280114371436xrnv.JPG', '3ed962da9f337453c81218490454fc82.JPG', '2018-04-20 13:00:56'), (228, 63, '1F3455FF-B5FC-4553-7C1C-94C8E8325D0A.jpg', 'dcacce655ab825b4ba89646f70144011.jpg', '2018-04-20 13:01:41'), (253, 65, 'White Super Fresh_Coral_O.jpg', '55750ac2fd2bc284056c92730729bb4f.jpg', '2018-04-23 12:14:46'), (254, 64, '880x1320_Master-blush_O_.jpg', '1aa23fa32b1abaa1e705dd85f91fc960.jpg', '2018-04-23 12:18:15'), (255, 66, 'LAPR_Day-lightening-creme-uv-lotion-50.jpg', 'c2ddf9799fd030a4a7d910dd99bd7100.jpg', '2018-04-23 12:21:24'), (256, 61, 'LYI_SKinSculptingNightCreme.jpg', '108c27c684220c095e2b92dafbf284f2.jpg', '2018-04-23 12:25:47'), (257, 62, '880x1320_Bro-Pomade-Assets_soft-brown_O.jpg', '4eb27cdf202b3139746f3bff875f99b3.jpg', '2018-04-23 12:41:30'), (259, 67, '880x1320_Drama-Gel-Pencils-SmoothCharcoal_O.png', 'ea4f1dec3058c7cec2f508e74716c361.png', '2018-04-23 12:49:17'); -- -------------------------------------------------------- -- -- Table structure for table `product_subcategories` -- CREATE TABLE `product_subcategories` ( `product_sub_category_id` bigint(10) NOT NULL, `products_id` int(10) NOT NULL, `sub_categories_id` int(10) NOT NULL, `product_sub_category_created_on` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `product_subcategories` -- INSERT INTO `product_subcategories` (`product_sub_category_id`, `products_id`, `sub_categories_id`, `product_sub_category_created_on`) VALUES (71, 60, 29, NULL), (74, 59, 27, NULL), (75, 58, 28, NULL), (84, 63, 36, NULL), (96, 64, 43, NULL), (97, 62, 41, NULL), (101, 65, 47, NULL), (102, 66, 49, NULL), (104, 67, 42, '2018-04-23 12:43:51'), (105, 68, 26, '2018-04-23 12:48:04'), (106, 61, 26, NULL); -- -------------------------------------------------------- -- -- Table structure for table `refund_payments` -- CREATE TABLE `refund_payments` ( `refund_payment_id` int(11) NOT NULL, `customers_id` int(11) NOT NULL, `order_numbers` varchar(255) NOT NULL, `transaction_id` varchar(255) NOT NULL, `currency` varchar(255) NOT NULL, `amount` decimal(10,2) NOT NULL, `method` tinyint(1) NOT NULL, `status` tinyint(1) NOT NULL, `refundtransactioniId` varchar(255) DEFAULT NULL, `refundfeesamout` decimal(10,2) DEFAULT NULL, `refundresponse` text NOT NULL, `netrefundamt` decimal(10,2) DEFAULT NULL, `refund_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT ' 0 for default orders, 1 for recurring orders', `created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `related_products` -- CREATE TABLE `related_products` ( `related_product_id` int(11) NOT NULL, `products_id` int(11) NOT NULL, `product_related_id` int(11) NOT NULL, `related_product_created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `related_products` -- INSERT INTO `related_products` (`related_product_id`, `products_id`, `product_related_id`, `related_product_created`) VALUES (1, 59, 58, '2018-03-14 12:52:08'), (2, 59, 57, '2018-03-14 12:52:09'), (5, 65, 62, '2018-04-20 14:38:06'), (6, 65, 64, '2018-04-20 14:45:36'), (7, 64, 65, '2018-04-20 16:12:52'), (9, 66, 61, '2018-04-20 16:52:45'), (10, 66, 62, '2018-04-20 16:52:46'), (11, 61, 61, '2018-04-23 12:28:10'), (12, 61, 66, '2018-04-23 12:28:17'), (13, 62, 62, '2018-04-23 12:41:51'), (14, 67, 67, '2018-04-23 12:49:31'), (15, 67, 62, '2018-04-23 12:49:33'); -- -------------------------------------------------------- -- -- Table structure for table `return_cancel_orders` -- CREATE TABLE `return_cancel_orders` ( `return_cancel_order_id` int(11) NOT NULL, `customers_id` int(11) NOT NULL, `order_numbers` varchar(255) NOT NULL, `status` tinyint(1) NOT NULL COMMENT '0, for no action , 1 for refunded , 2 for cancelled', `ip_address` varchar(255) NOT NULL, `single` tinyint(1) NOT NULL, `reason` text, `action` tinyint(1) NOT NULL COMMENT '0 for cancel order and 1 for return order , 2 for recurring refund', `recurring_id` int(11) DEFAULT NULL, `return_cancel_orders_created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `reviews` -- CREATE TABLE `reviews` ( `review_id` int(11) NOT NULL, `customers_id` int(11) NOT NULL, `orders_num` varchar(256) NOT NULL, `products_id` int(11) NOT NULL, `rating` tinyint(1) NOT NULL DEFAULT '0', `reviews` text, `review_status` tinyint(1) NOT NULL, `review_created` datetime NOT NULL, `review_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `save_cards` -- CREATE TABLE `save_cards` ( `save_card_id` int(11) NOT NULL, `customers_id` int(11) NOT NULL, `method` tinyint(1) NOT NULL, `name_on_card` varchar(255) DEFAULT NULL, `card_number` varchar(255) DEFAULT NULL, `authorise_address` varchar(255) DEFAULT NULL, `authorise_city` varchar(255) DEFAULT NULL, `authorise_state` varchar(255) DEFAULT NULL, `authorise_postal_code` varchar(255) DEFAULT NULL, `authorise_country` varchar(255) DEFAULT NULL, `stripe_month` tinyint(4) DEFAULT NULL, `stripe_year` varchar(4) DEFAULT NULL, `save_cards_created` datetime NOT NULL, `save_cards_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `settings_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, `site_name` varchar(255) NOT NULL, `site_keyword` varchar(255) DEFAULT NULL, `site_description` text, `blog_page` varchar(255) NOT NULL, `google_analytic_code` text, `facebook_tracking` text, `facebook_id` varchar(255) DEFAULT NULL, `twitter_user_id` varchar(255) DEFAULT NULL, `youtube_channel_id` varchar(255) DEFAULT NULL, `instagram_user_id` varchar(255) DEFAULT NULL, `email` varchar(50) NOT NULL, `phone` varchar(255) NOT NULL, `settings_created` datetime NOT NULL, `settings_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`settings_id`, `group_id`, `site_name`, `site_keyword`, `site_description`, `blog_page`, `google_analytic_code`, `facebook_tracking`, `facebook_id`, `twitter_user_id`, `youtube_channel_id`, `instagram_user_id`, `email`, `phone`, `settings_created`, `settings_modified`) VALUES (1, 1, 'Cosmetics', 'Cosmetics', 'Cosmetics', '', ' ', '', '', '', '', '', 'email@email.com', '9785514253', '2018-04-23 14:14:36', '2018-04-23 14:15:04'); -- -------------------------------------------------------- -- -- Table structure for table `status` -- CREATE TABLE `status` ( `status_id` int(11) NOT NULL, `status` varchar(256) CHARACTER SET utf8 NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `status` -- INSERT INTO `status` (`status_id`, `status`) VALUES (1, 'Pending'), (2, 'Processed'), (3, 'Shipped'), (4, 'Delivered'), (5, 'Returned'), (6, 'Refunded'), (7, 'Stopped'); -- -------------------------------------------------------- -- -- Table structure for table `status_logs` -- CREATE TABLE `status_logs` ( `status_log_id` int(11) NOT NULL, `users_id` int(11) NOT NULL, `customer_order_details_id` int(11) NOT NULL, `order_status` tinyint(1) NOT NULL, `log_created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `subscribers` -- CREATE TABLE `subscribers` ( `subscriber_id` int(11) NOT NULL, `customers_email` varchar(255) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `subscribed_on` datetime NOT NULL, `subscriber_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `sub_categories` -- CREATE TABLE `sub_categories` ( `sub_category_id` int(11) NOT NULL, `categories_id` int(11) NOT NULL, `sub_category_name` varchar(256) CHARACTER SET utf8 NOT NULL, `sub_category_slug` varchar(256) CHARACTER SET utf8 NOT NULL, `sub_category_status` tinyint(1) NOT NULL COMMENT '1 for active 0 for unactive', `sub_category_created` datetime NOT NULL, `sub_category_modified` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `sub_categories` -- INSERT INTO `sub_categories` (`sub_category_id`, `categories_id`, `sub_category_name`, `sub_category_slug`, `sub_category_status`, `sub_category_created`, `sub_category_modified`) VALUES (26, 24, 'General', 'general', 1, '2017-10-25 00:00:00', NULL), (41, 29, 'Eyebrow', 'eyebrow_', 1, '2018-04-20 12:58:33', '2018-04-23 11:50:36'), (42, 29, 'Eyeliner', 'eyeliner_', 1, '2018-04-20 12:58:33', '2018-04-23 11:50:51'), (43, 32, 'Blush', 'blush_', 1, '2018-04-20 12:58:50', '2018-04-23 11:51:16'), (47, 32, 'Powder', 'powder_', 1, '2018-04-20 16:06:34', '2018-04-23 11:52:13'), (49, 35, 'Sun Protection', 'sun-protection_', 1, '2018-04-20 16:31:59', '2018-04-23 11:53:16'); -- -------------------------------------------------------- -- -- Table structure for table `sub_menu` -- CREATE TABLE `sub_menu` ( `sub_menu_id` int(11) NOT NULL, `categories_id` int(11) NOT NULL, `groups_id` int(11) NOT NULL, `sub_menu_created` datetime NOT NULL, `sub_menu_updated` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `sub_menu` -- INSERT INTO `sub_menu` (`sub_menu_id`, `categories_id`, `groups_id`, `sub_menu_created`, `sub_menu_updated`) VALUES (14, 29, 1, '2018-04-23 14:07:54', NULL), (15, 32, 1, '2018-04-23 14:07:54', NULL), (16, 35, 1, '2018-04-23 14:07:54', NULL); -- -------------------------------------------------------- -- -- Table structure for table `templates` -- CREATE TABLE `templates` ( `template_id` int(11) NOT NULL, `groups_id` int(11) NOT NULL, `value` tinyint(1) NOT NULL, `template_created` datetime NOT NULL, `template_updated` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `templates` -- INSERT INTO `templates` (`template_id`, `groups_id`, `value`, `template_created`, `template_updated`) VALUES (2, 1, 2, '2018-03-23 17:47:13', '2018-04-23 14:10:16'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `user_id` int(10) NOT NULL, `groups_id` int(11) NOT NULL DEFAULT '1', `group_slug` varchar(20) CHARACTER SET utf8 NOT NULL, `user_email` varchar(256) CHARACTER SET utf8 NOT NULL, `user_firstname` varchar(50) CHARACTER SET utf8 NOT NULL, `user_lastname` varchar(50) CHARACTER SET utf8 NOT NULL, `user_password` varchar(256) CHARACTER SET utf8 NOT NULL, `user_status` tinyint(1) NOT NULL COMMENT '0 for deactivate and 1 for activate', `user_ip` varchar(20) CHARACTER SET utf8 NOT NULL, `user_created` datetime NOT NULL, `user_update` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`user_id`, `groups_id`, `group_slug`, `user_email`, `user_firstname`, `user_lastname`, `user_password`, `user_status`, `user_ip`, `user_created`, `user_update`) VALUES (1, 1, 'admin', 'agent@wpgateway.com', 'agent@wpgateway.com', ' ', '21232f297a57a5a743894a0e4a801fc3', 1, '192.168.0.105', '2017-09-14 00:00:00', '2018-03-29 14:53:37'); -- -------------------------------------------------------- -- -- Table structure for table `user_credentials` -- CREATE TABLE `user_credentials` ( `user_credential_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, `no_of_days` int(11) NOT NULL DEFAULT '15', `user_stripe_key` varchar(255) DEFAULT NULL, `user_auth_login_name` varchar(255) DEFAULT NULL, `user_auth_transaction_key` varchar(255) DEFAULT NULL, `user_paypal_method_type` tinyint(1) DEFAULT NULL COMMENT '1 for standard; 2 for recurring bussiness ; 3 for paypal recurring', `paypal_standard_email` varchar(255) DEFAULT NULL, `paypal_api_name` varchar(255) DEFAULT NULL, `paypal_api_password` varchar(255) DEFAULT NULL, `paypal_signature` text, `use_stripe` tinyint(1) NOT NULL DEFAULT '0', `use_authorise` tinyint(1) NOT NULL DEFAULT '0', `use_paypal` tinyint(1) NOT NULL DEFAULT '0', `user_credentials_updation_on` datetime DEFAULT NULL, `user_credential_created_on` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `versions` -- CREATE TABLE `versions` ( `version_id` int(11) NOT NULL, `version_no` decimal(10,2) NOT NULL, `version_created` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `versions` -- INSERT INTO `versions` (`version_id`, `version_no`, `version_created`) VALUES (1, '1.00', '2018-02-22 00:00:00'); -- -- Indexes for dumped tables -- -- -- Indexes for table `address_book` -- ALTER TABLE `address_book` ADD PRIMARY KEY (`address_id`), ADD KEY `customers_id` (`customers_id`), ADD KEY `customers_id_2` (`customers_id`), ADD KEY `address_city` (`address_city`), ADD KEY `address_country` (`address_country`), ADD KEY `is_default` (`is_default`); -- -- Indexes for table `add_register_user_payment` -- ALTER TABLE `add_register_user_payment` ADD PRIMARY KEY (`register_payment_id`); -- -- Indexes for table `banner_images` -- ALTER TABLE `banner_images` ADD PRIMARY KEY (`banner_image_id`); -- -- Indexes for table `banner_text` -- ALTER TABLE `banner_text` ADD PRIMARY KEY (`banner_text`); -- -- Indexes for table `brands` -- ALTER TABLE `brands` ADD PRIMARY KEY (`brand_id`); -- -- Indexes for table `cart_added` -- ALTER TABLE `cart_added` ADD PRIMARY KEY (`cart_added_id`), ADD KEY `products_id` (`products_id`), ADD KEY `customers_id` (`customers_id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`category_id`); -- -- Indexes for table `color_settings` -- ALTER TABLE `color_settings` ADD PRIMARY KEY (`color_settings_id`); -- -- Indexes for table `contact_info` -- ALTER TABLE `contact_info` ADD PRIMARY KEY (`contact_info_id`), ADD KEY `users_id` (`group_id`), ADD KEY `postal_code` (`postal_code`); -- -- Indexes for table `countries` -- ALTER TABLE `countries` ADD PRIMARY KEY (`country_id`); -- -- Indexes for table `coupons` -- ALTER TABLE `coupons` ADD PRIMARY KEY (`coupon_id`), ADD KEY `coupon_code` (`coupon_code`), ADD KEY `discount_type` (`discount_type`); -- -- Indexes for table `coupon_applied` -- ALTER TABLE `coupon_applied` ADD PRIMARY KEY (`coupon_applied_id`); -- -- Indexes for table `cron_cards` -- ALTER TABLE `cron_cards` ADD PRIMARY KEY (`cron_card_id`); -- -- Indexes for table `cron_payments` -- ALTER TABLE `cron_payments` ADD PRIMARY KEY (`cron_payment_id`); -- -- Indexes for table `cron_payment_logs` -- ALTER TABLE `cron_payment_logs` ADD PRIMARY KEY (`cron_payment_log_id`); -- -- Indexes for table `cron_stop` -- ALTER TABLE `cron_stop` ADD PRIMARY KEY (`cron_stop_id`); -- -- Indexes for table `currencies` -- ALTER TABLE `currencies` ADD PRIMARY KEY (`currency_id`); -- -- Indexes for table `currency_symbols` -- ALTER TABLE `currency_symbols` ADD PRIMARY KEY (`symbol_id`); -- -- Indexes for table `customers` -- ALTER TABLE `customers` ADD PRIMARY KEY (`customer_id`), ADD KEY `customer_status` (`customer_status`), ADD KEY `customer_email` (`customer_email`), ADD KEY `customer_phone` (`customer_phone`), ADD KEY `customer_firstname` (`customer_firstname`), ADD KEY `customer_id` (`customer_id`); -- -- Indexes for table `customer_orders` -- ALTER TABLE `customer_orders` ADD PRIMARY KEY (`customer_order_id`), ADD KEY `customer_order_id` (`customer_order_id`), ADD KEY `customers_id` (`customers_id`), ADD KEY `customer_number` (`customer_number`), ADD KEY `coupons_code` (`coupons_code`); -- -- Indexes for table `customer_order_details` -- ALTER TABLE `customer_order_details` ADD PRIMARY KEY (`customer_order_detail_id`), ADD KEY `customer_orders_id` (`customer_orders_id`), ADD KEY `order_number` (`order_number`), ADD KEY `products_id` (`products_id`); -- -- Indexes for table `email_logs` -- ALTER TABLE `email_logs` ADD PRIMARY KEY (`email_log_id`); -- -- Indexes for table `email_settings` -- ALTER TABLE `email_settings` ADD PRIMARY KEY (`email_settings_id`); -- -- Indexes for table `email_templates` -- ALTER TABLE `email_templates` ADD PRIMARY KEY (`email_template_id`), ADD KEY `user_id` (`group_id`), ADD KEY `template_name` (`template_name`); -- -- Indexes for table `email_template_type` -- ALTER TABLE `email_template_type` ADD PRIMARY KEY (`email_template_type_id`); -- -- Indexes for table `faqs` -- ALTER TABLE `faqs` ADD PRIMARY KEY (`faq_id`); -- -- Indexes for table `footer_tabs` -- ALTER TABLE `footer_tabs` ADD PRIMARY KEY (`footer_tab_id`); -- -- Indexes for table `group_pages` -- ALTER TABLE `group_pages` ADD PRIMARY KEY (`group_page_id`); -- -- Indexes for table `headings_info` -- ALTER TABLE `headings_info` ADD PRIMARY KEY (`heading_info_id`); -- -- Indexes for table `logo_images` -- ALTER TABLE `logo_images` ADD PRIMARY KEY (`logo_image_id`); -- -- Indexes for table `menu_positions` -- ALTER TABLE `menu_positions` ADD PRIMARY KEY (`menu_position_id`), ADD KEY `menu_status` (`menu_status`), ADD KEY `menu_type` (`menu_type`), ADD KEY `positioning` (`positioning`), ADD KEY `groups_id` (`groups_id`); -- -- Indexes for table `pages` -- ALTER TABLE `pages` ADD PRIMARY KEY (`page_id`), ADD KEY `page_name` (`page_name`), ADD KEY `page_status` (`page_status`); -- -- Indexes for table `payment_details` -- ALTER TABLE `payment_details` ADD PRIMARY KEY (`payment_detail_id`), ADD KEY `payment_status` (`payment_status`), ADD KEY `payment_mode` (`payment_mode`), ADD KEY `customer_orders_id` (`customer_orders_id`), ADD KEY `customers_id` (`customers_id`); -- -- Indexes for table `plans` -- ALTER TABLE `plans` ADD PRIMARY KEY (`plan_logs_id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`product_id`), ADD KEY `product_name` (`product_name`), ADD KEY `product_price` (`mrp_price`), ADD KEY `brands_id` (`brands_id`), ADD KEY `sale_price` (`sale_price`), ADD KEY `is_featured` (`is_featured`), ADD KEY `product_status` (`product_status`), ADD KEY `product_slug` (`product_slug`); -- -- Indexes for table `product_colors` -- ALTER TABLE `product_colors` ADD PRIMARY KEY (`product_colors_id`); -- -- Indexes for table `product_csv_files` -- ALTER TABLE `product_csv_files` ADD PRIMARY KEY (`csv_file_id`); -- -- Indexes for table `product_dimensions` -- ALTER TABLE `product_dimensions` ADD PRIMARY KEY (`product_dimensions_id`); -- -- Indexes for table `product_images` -- ALTER TABLE `product_images` ADD PRIMARY KEY (`product_image_id`); -- -- Indexes for table `product_subcategories` -- ALTER TABLE `product_subcategories` ADD PRIMARY KEY (`product_sub_category_id`), ADD KEY `products_id` (`products_id`), ADD KEY `subcategory_id` (`sub_categories_id`); -- -- Indexes for table `refund_payments` -- ALTER TABLE `refund_payments` ADD PRIMARY KEY (`refund_payment_id`); -- -- Indexes for table `related_products` -- ALTER TABLE `related_products` ADD PRIMARY KEY (`related_product_id`); -- -- Indexes for table `return_cancel_orders` -- ALTER TABLE `return_cancel_orders` ADD PRIMARY KEY (`return_cancel_order_id`); -- -- Indexes for table `reviews` -- ALTER TABLE `reviews` ADD PRIMARY KEY (`review_id`); -- -- Indexes for table `save_cards` -- ALTER TABLE `save_cards` ADD PRIMARY KEY (`save_card_id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`settings_id`), ADD KEY `users_id` (`group_id`), ADD KEY `facebook_id` (`facebook_id`), ADD KEY `site_name` (`site_name`), ADD KEY `email` (`email`); -- -- Indexes for table `status` -- ALTER TABLE `status` ADD PRIMARY KEY (`status_id`); -- -- Indexes for table `status_logs` -- ALTER TABLE `status_logs` ADD PRIMARY KEY (`status_log_id`); -- -- Indexes for table `subscribers` -- ALTER TABLE `subscribers` ADD PRIMARY KEY (`subscriber_id`); -- -- Indexes for table `sub_categories` -- ALTER TABLE `sub_categories` ADD PRIMARY KEY (`sub_category_id`), ADD KEY `categories_id` (`categories_id`); -- -- Indexes for table `sub_menu` -- ALTER TABLE `sub_menu` ADD PRIMARY KEY (`sub_menu_id`); -- -- Indexes for table `templates` -- ALTER TABLE `templates` ADD PRIMARY KEY (`template_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`user_id`); -- -- Indexes for table `user_credentials` -- ALTER TABLE `user_credentials` ADD PRIMARY KEY (`user_credential_id`), ADD UNIQUE KEY `users_id` (`group_id`) USING BTREE; -- -- Indexes for table `versions` -- ALTER TABLE `versions` ADD PRIMARY KEY (`version_id`), ADD KEY `version_no` (`version_no`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `address_book` -- ALTER TABLE `address_book` MODIFY `address_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `add_register_user_payment` -- ALTER TABLE `add_register_user_payment` MODIFY `register_payment_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `banner_images` -- ALTER TABLE `banner_images` MODIFY `banner_image_id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `banner_text` -- ALTER TABLE `banner_text` MODIFY `banner_text` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `brands` -- ALTER TABLE `brands` MODIFY `brand_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66; -- -- AUTO_INCREMENT for table `cart_added` -- ALTER TABLE `cart_added` MODIFY `cart_added_id` bigint(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36; -- -- AUTO_INCREMENT for table `color_settings` -- ALTER TABLE `color_settings` MODIFY `color_settings_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `contact_info` -- ALTER TABLE `contact_info` MODIFY `contact_info_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `countries` -- ALTER TABLE `countries` MODIFY `country_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=227; -- -- AUTO_INCREMENT for table `coupons` -- ALTER TABLE `coupons` MODIFY `coupon_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `coupon_applied` -- ALTER TABLE `coupon_applied` MODIFY `coupon_applied_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `cron_cards` -- ALTER TABLE `cron_cards` MODIFY `cron_card_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `cron_payments` -- ALTER TABLE `cron_payments` MODIFY `cron_payment_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `cron_payment_logs` -- ALTER TABLE `cron_payment_logs` MODIFY `cron_payment_log_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `cron_stop` -- ALTER TABLE `cron_stop` MODIFY `cron_stop_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `currencies` -- ALTER TABLE `currencies` MODIFY `currency_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `currency_symbols` -- ALTER TABLE `currency_symbols` MODIFY `symbol_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `customers` -- ALTER TABLE `customers` MODIFY `customer_id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `customer_orders` -- ALTER TABLE `customer_orders` MODIFY `customer_order_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `customer_order_details` -- ALTER TABLE `customer_order_details` MODIFY `customer_order_detail_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `email_logs` -- ALTER TABLE `email_logs` MODIFY `email_log_id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `email_settings` -- ALTER TABLE `email_settings` MODIFY `email_settings_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `email_templates` -- ALTER TABLE `email_templates` MODIFY `email_template_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `email_template_type` -- ALTER TABLE `email_template_type` MODIFY `email_template_type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `faqs` -- ALTER TABLE `faqs` MODIFY `faq_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `footer_tabs` -- ALTER TABLE `footer_tabs` MODIFY `footer_tab_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `group_pages` -- ALTER TABLE `group_pages` MODIFY `group_page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `headings_info` -- ALTER TABLE `headings_info` MODIFY `heading_info_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `logo_images` -- ALTER TABLE `logo_images` MODIFY `logo_image_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `menu_positions` -- ALTER TABLE `menu_positions` MODIFY `menu_position_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `pages` -- ALTER TABLE `pages` MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `payment_details` -- ALTER TABLE `payment_details` MODIFY `payment_detail_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `plans` -- ALTER TABLE `plans` MODIFY `plan_logs_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `product_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69; -- -- AUTO_INCREMENT for table `product_colors` -- ALTER TABLE `product_colors` MODIFY `product_colors_id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `product_csv_files` -- ALTER TABLE `product_csv_files` MODIFY `csv_file_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `product_dimensions` -- ALTER TABLE `product_dimensions` MODIFY `product_dimensions_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `product_images` -- ALTER TABLE `product_images` MODIFY `product_image_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=260; -- -- AUTO_INCREMENT for table `product_subcategories` -- ALTER TABLE `product_subcategories` MODIFY `product_sub_category_id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107; -- -- AUTO_INCREMENT for table `refund_payments` -- ALTER TABLE `refund_payments` MODIFY `refund_payment_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `related_products` -- ALTER TABLE `related_products` MODIFY `related_product_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `return_cancel_orders` -- ALTER TABLE `return_cancel_orders` MODIFY `return_cancel_order_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `reviews` -- ALTER TABLE `reviews` MODIFY `review_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `save_cards` -- ALTER TABLE `save_cards` MODIFY `save_card_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `settings_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `status` -- ALTER TABLE `status` MODIFY `status_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `status_logs` -- ALTER TABLE `status_logs` MODIFY `status_log_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `subscribers` -- ALTER TABLE `subscribers` MODIFY `subscriber_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `sub_categories` -- ALTER TABLE `sub_categories` MODIFY `sub_category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50; -- -- AUTO_INCREMENT for table `sub_menu` -- ALTER TABLE `sub_menu` MODIFY `sub_menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `templates` -- ALTER TABLE `templates` MODIFY `template_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `user_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `user_credentials` -- ALTER TABLE `user_credentials` MODIFY `user_credential_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `versions` -- ALTER TABLE `versions` MODIFY `version_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; COMMIT;