IP : 3.147.27.107Hostname : 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/
./
magento2/
../
phpcol/
../
ricar/
../
wacart/
wacart.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 */;
-- -- Dumping data for table `tbl_data_category_translated` --
INSERT INTO `tbl_data_category_translated` VALUES (1, 1, 'en-US', 'Root Category', 'This is root data category for the application under which all the data would reside', 1, 1, '[[regtime]]', '[[regtime]]');
-- -- Table structure for table `tbl_page_translated` --
CREATE TABLE `tbl_page_translated` ( `id` int(11) NOT NULL AUTO_INCREMENT, `owner_id` int(11) NOT NULL, `language` varchar(10) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `alias` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `menuitem` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `content` text COLLATE utf8_unicode_ci, `summary` text COLLATE utf8_unicode_ci, `metakeywords` text COLLATE utf8_unicode_ci, `metadescription` text COLLATE utf8_unicode_ci, `created_by` int(11) DEFAULT '0', `modified_by` int(11) DEFAULT '0', `created_datetime` datetime DEFAULT NULL, `modified_datetime` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_alias` (`alias`), KEY `idx_owner_id` (`owner_id`), KEY `idx_language` (`language`), KEY `idx_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
-- -- Dumping data for table `tbl_page_translated` --
INSERT INTO `tbl_page_translated` VALUES (1, 1, 'en-US', 'About Us', 'about-us', 'About Us', '<p>\n <strong class="first-paragraph">A</strong>t Usha Informatique, Web Development Company in India, we are driven by SPEED and EFFICIENCY to achieve superior quality and cost-competitiveness so as to enable our customer’s stay at the forefront of their industry.</p><p>At Usha Informatique, you can find a right combination of Technical excellence, outstanding design, effective strategy and the results are pretty impressive, to serve clients acroos the globe. We utilizes both continued technical and intellectual education to enhance each project that is brought to Usha Informatique that stands our clients into the world of technology with class.</p><p>Our knowledge and experience in Software and Web solutions have greatly boosted our clients in business augmentation. We specialize in delivering cost-effective software/web solutions by implementing an offshore development model. We have a dedicated team of software professionals to bring quality products to the clients.\n</p>\n\n', 'About us summary', 'about us', 'about us description', 1, 1, '[[regtime]]', '[[regtime]]'), (2, 2, 'en-US', 'Delivery Information', 'delivery-info', 'Delivery Information', '<p>This is delivery information</p>', 'Delivery information summary', 'delivery information', 'deliverr information description', 1, 1, '[[regtime]]', '[[regtime]]'), (3, 3, 'en-US', 'Privacy Policy', 'privacy-policy', 'Privacy Policy', '<p>This is privacy policy</p>', 'Privacy policy summary', 'privacy policy', 'privacy policy description', 1, 1, '[[regtime]]', '[[regtime]]'), (4, 4, 'en-US', 'Terms & Conditions', 'terms', 'Terms & Conditions', '<p>These are terms and conditions</p>', 'Terms & condition summary', 'terms & condition', 'terms & condition description', 1, 1, '[[regtime]]', '[[regtime]]');
-- -- Dumping data for table `tbl_product_category_translated` --
INSERT INTO `tbl_product_category_translated` VALUES (1, 1, 'en-US', 'Desktops', 'desktops', NULL, NULL, 'Shop Desktop feature only the best desktop deals on the market', 1, 1, '[[regtime]]', '[[regtime]]'), (2, 2, 'en-US', 'Laptops & Notebooks', 'laptops-notebooks', NULL, NULL, 'Shop Laptop feature only the best laptop deals on the market', 1, 1, '[[regtime]]', '[[regtime]]'), (3, 3, 'en-US', 'Camera', 'camera', NULL, NULL, 'Shop Camera feature only the best laptop deals on the market', 1, 1, '[[regtime]]', '[[regtime]]');
-- -- Dumping data for table `tbl_product_review_translated` --
INSERT INTO `tbl_product_review_translated` VALUES (1, 1, 'en-US', 'This is my first review', 1, 1, '[[regtime]]', '[[regtime]]'), (2, 2, 'en-US', 'This is my second review', 1, 1, '[[regtime]]', '[[regtime]]'), (3, 3, 'en-US', 'This is my third review', 1, 1, '[[regtime]]', '[[regtime]]'), (4, 4, 'en-US', 'This is my fourth review', 1, 1, '[[regtime]]', '[[regtime]]');
-- -- Dumping data for table `tbl_product_tax_class_translated` --
INSERT INTO `tbl_product_tax_class_translated` VALUES (1, 1, 'en-US', 'taxable goods', 'Applied to goods on which tax has to be applied', 1, 1, '[[regtime]]', '[[regtime]]');
-- -- Dumping data for table `tbl_store_translated` --
INSERT INTO `tbl_store_translated` VALUES (1, 1, 'en-US', 'Default', 'This is test store set up with the application', NULL, NULL, 1, 1, '[[regtime]]', '[[regtime]]');
-- -- Dumping data for table `tbl_zone_translated` --
INSERT INTO `tbl_zone_translated` VALUES (1, 1, 'en-US', 'North Zone', 'North Zone for India', 1, 1, '[[regtime]]', '[[regtime]]'), (2, 2, 'en-US', 'East Zone', 'East Zone for India', 1, 1, '[[regtime]]', '[[regtime]]');
-- -- Constraints for dumped tables --
-- -- Constraints for table `tbl_city_translated` -- ALTER TABLE `tbl_city_translated` ADD CONSTRAINT `fk_tbl_city_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_city` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_country_translated` -- ALTER TABLE `tbl_country_translated` ADD CONSTRAINT `fk_tbl_country_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_country` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_currency_translated` -- ALTER TABLE `tbl_currency_translated` ADD CONSTRAINT `fk_tbl_currency_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_currency` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_data_category_translated` -- ALTER TABLE `tbl_data_category_translated` ADD CONSTRAINT `fk_tbl_data_category_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_data_category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_extension_translated` -- ALTER TABLE `tbl_extension_translated` ADD CONSTRAINT `fk_tbl_extension_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_extension` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_invoice` -- ALTER TABLE `tbl_invoice` ADD CONSTRAINT `fk_tbl_invoice_order_id` FOREIGN KEY (`order_id`) REFERENCES `tbl_order` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `tbl_invoice_translated` -- ALTER TABLE `tbl_invoice_translated` ADD CONSTRAINT `fk_tbl_invoice_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_invoice` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_length_class_translated` -- ALTER TABLE `tbl_length_class_translated` ADD CONSTRAINT `fk_tbl_length_class_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_length_class` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_newsletter_translated` -- ALTER TABLE `tbl_newsletter_translated` ADD CONSTRAINT `fk_tbl_newsletter_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_newsletter` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_notification_layout_translated` -- ALTER TABLE `tbl_notification_layout_translated` ADD CONSTRAINT `fk_tbl_notification_layout_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_notification_layout` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_notification_template_translated` -- ALTER TABLE `tbl_notification_template_translated` ADD CONSTRAINT `fk_tbl_notification_template_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_notification_template` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_order_address_details` -- ALTER TABLE `tbl_order_address_details` ADD CONSTRAINT `fk_tbl_order_address_details_order_id` FOREIGN KEY (`order_id`) REFERENCES `tbl_order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_order_history` -- ALTER TABLE `tbl_order_history` ADD CONSTRAINT `fk_tbl_order_history_order_id` FOREIGN KEY (`order_id`) REFERENCES `tbl_order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_order_history_translated` -- ALTER TABLE `tbl_order_history_translated` ADD CONSTRAINT `fk_tbl_order_history_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_order_history` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_order_payment_details` -- ALTER TABLE `tbl_order_payment_details` ADD CONSTRAINT `fk_tbl_order_payment_details_order_id` FOREIGN KEY (`order_id`) REFERENCES `tbl_order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_order_payment_details_translated` -- ALTER TABLE `tbl_order_payment_details_translated` ADD CONSTRAINT `fk_tbl_order_payment_details_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_order_payment_details` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_order_payment_transaction_map` -- ALTER TABLE `tbl_order_payment_transaction_map` ADD CONSTRAINT `fk_tbl_order_payment_transaction_map_order_id` FOREIGN KEY (`order_id`) REFERENCES `tbl_order` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `tbl_order_product` -- ALTER TABLE `tbl_order_product` ADD CONSTRAINT `fk_tbl_order_product_order_id` FOREIGN KEY (`order_id`) REFERENCES `tbl_order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_order_status_translated` -- ALTER TABLE `tbl_order_status_translated` ADD CONSTRAINT `fk_tbl_order_status_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_order_status` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_order_translated` -- ALTER TABLE `tbl_order_translated` ADD CONSTRAINT `fk_tbl_order_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_page_translated` -- ALTER TABLE `tbl_page_translated` ADD CONSTRAINT `fk_tbl_page_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_page` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_product_attribute_group_translated` -- ALTER TABLE `tbl_product_attribute_group_translated` ADD CONSTRAINT `fk_tbl_product_attribute_group_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_product_attribute_group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_product_attribute_mapping` -- ALTER TABLE `tbl_product_attribute_mapping` ADD CONSTRAINT `fk_tbl_product_attribute_mapping_product_id` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `tbl_product_attribute_translated` -- ALTER TABLE `tbl_product_attribute_translated` ADD CONSTRAINT `fk_tbl_product_attribute_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_product_attribute` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_product_category_mapping` -- ALTER TABLE `tbl_product_category_mapping` ADD CONSTRAINT `fk_tbl_product_category_mapping_product_id` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `tbl_product_category_translated` -- ALTER TABLE `tbl_product_category_translated` ADD CONSTRAINT `fk_tbl_product_category_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_product_category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_product_discount` -- ALTER TABLE `tbl_product_discount` ADD CONSTRAINT `fk_tbl_product_discount_product_id` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_product_download_mapping` -- ALTER TABLE `tbl_product_download_mapping` ADD CONSTRAINT `fk_tbl_product_download_mapping_product_id` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `tbl_product_download_translated` -- ALTER TABLE `tbl_product_download_translated` ADD CONSTRAINT `fk_tbl_product_download_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_product_download` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_product_image` -- ALTER TABLE `tbl_product_image` ADD CONSTRAINT `fk_tbl_product_id` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `tbl_product_image_translated` -- ALTER TABLE `tbl_product_image_translated` ADD CONSTRAINT `fk_tbl_product_image_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_product_image` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_product_option_mapping` -- ALTER TABLE `tbl_product_option_mapping` ADD CONSTRAINT `fk_tbl_product_option_mapping_product_id` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `tbl_product_option_translated` -- ALTER TABLE `tbl_product_option_translated` ADD CONSTRAINT `fk_tbl_product_option_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_product_option` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_product_option_value_translated` -- ALTER TABLE `tbl_product_option_value_translated` ADD CONSTRAINT `fk_tbl_product_option_value_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_product_option_value` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_product_rating` -- ALTER TABLE `tbl_product_rating` ADD CONSTRAINT `fk_tbl_product_rating_product_id` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `tbl_product_related_product_mapping` -- ALTER TABLE `tbl_product_related_product_mapping` ADD CONSTRAINT `fk_tbl_product_related_product_mapping_product_id` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `tbl_product_review` -- ALTER TABLE `tbl_product_review` ADD CONSTRAINT `fk_tbl_product_review_product_id` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `tbl_product_review_translated` -- ALTER TABLE `tbl_product_review_translated` ADD CONSTRAINT `fk_tbl_product_review_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_product_review` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_product_special` -- ALTER TABLE `tbl_product_special` ADD CONSTRAINT `fk_tbl_product_special_product_id` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_product_tag_mapping` -- ALTER TABLE `tbl_product_tag_mapping` ADD CONSTRAINT `fk_tbl_product_tag_mapping_product_id` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `tbl_product_tax_class_translated` -- ALTER TABLE `tbl_product_tax_class_translated` ADD CONSTRAINT `fk_tbl_product_tax_class_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_product_tax_class` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_product_translated` -- ALTER TABLE `tbl_product_translated` ADD CONSTRAINT `fk_tbl_product_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_state_translated` -- ALTER TABLE `tbl_state_translated` ADD CONSTRAINT `fk_tbl_state_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_state` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_stock_status_translated` -- ALTER TABLE `tbl_stock_status_translated` ADD CONSTRAINT `fk_tbl_stock_status_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_stock_status` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_store_translated` -- ALTER TABLE `tbl_store_translated` ADD CONSTRAINT `fk_tbl_store_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_tag_translated` -- ALTER TABLE `tbl_tag_translated` ADD CONSTRAINT `fk_tbl_tag_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_tag` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_tax_rule_translated` -- ALTER TABLE `tbl_tax_rule_translated` ADD CONSTRAINT `fk_tbl_tax_rule_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_tax_rule` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_weight_class_translated` -- ALTER TABLE `tbl_weight_class_translated` ADD CONSTRAINT `fk_tbl_weight_class_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_weight_class` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `tbl_zone_translated` -- ALTER TABLE `tbl_zone_translated` ADD CONSTRAINT `fk_tbl_zone_translated_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `tbl_zone` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
/*!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 */;