Server : LiteSpeed System : Linux in-mum-web1112.main-hosting.eu 4.18.0-553.34.1.lve.el8.x86_64 #1 SMP Thu Jan 9 16:30:32 UTC 2025 x86_64 User : u451330669 ( 451330669) PHP Version : 8.2.27 Disable Function : NONE Directory : /home/u451330669/domains/hificableties.com/public_html/ |
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: Apr 25, 2025 at 08:39 AM -- Server version: 10.11.10-MariaDB-log -- PHP Version: 7.2.34 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; 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 utf8mb4 */; -- -- Database: `u451330669_hifi` -- -- -------------------------------------------------------- -- -- Table structure for table `admin_users` -- CREATE TABLE `admin_users` ( `id` int(11) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `admin_users` -- INSERT INTO `admin_users` (`id`, `username`, `password`) VALUES (1, 'bhavik', 'bhavik'); -- -------------------------------------------------------- -- -- Table structure for table `banner` -- CREATE TABLE `banner` ( `id` int(11) NOT NULL, `banner` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `image` varchar(255) NOT NULL, `status` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `banner` -- INSERT INTO `banner` (`id`, `banner`, `name`, `image`, `status`) VALUES (2, 'nicegg', '', '810635933_IMG_20201211_100541-removebg-preview.png', 1), (4, 'ozas', '', '830158923_IMG_20201211_094952-removebg-preview.png', 1); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` int(11) NOT NULL, `categories` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `image` varchar(255) NOT NULL, `status` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `categories`, `name`, `image`, `status`) VALUES (1, 'NYLON CABLE TIES', '', '', 1), (2, 'CABLE NAIL CLIPS', '', '', 1), (3, 'PLASTIC WALL PLUG(GITTI)', '', '', 1), (4, 'UPVC PIPE FITTING CLAMPS', '', '', 1), (5, 'CPVC PIPE FITTING CLAMPS', '', '', 1), (6, 'PVC PIPE FITTING CLAMPS', '', '', 1), (7, 'DRY WALL SCREW', '', '', 1), (8, 'CONCRETE NAIL', '', '', 1), (9, 'DOUBLE NAIL CLAMP', '', '', 1); -- -------------------------------------------------------- -- -- Table structure for table `comment` -- CREATE TABLE `comment` ( `id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `comment` varchar(255) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `comment` -- INSERT INTO `comment` (`id`, `product_id`, `user_id`, `comment`, `created_at`) VALUES (59, 97, 1, 'nice', '2020-11-27 06:23:31'), (69, 106, 2, 'dssd', '2020-11-28 09:24:50'), (70, 106, 2, 'dssd', '2020-11-28 09:24:55'); -- -------------------------------------------------------- -- -- Table structure for table `contact_us` -- CREATE TABLE `contact_us` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `mobile` varchar(20) NOT NULL, `comment` text NOT NULL, `added_on` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `dilivery` -- CREATE TABLE `dilivery` ( `id` int(11) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `name` -- CREATE TABLE `name` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `mobile` varchar(50) NOT NULL, `comment` text NOT NULL, `added_on` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `name` -- INSERT INTO `name` (`id`, `name`, `email`, `mobile`, `comment`, `added_on`) VALUES (1, 'bhavik oza', 'bhavikoza7878@gmail.com', '07600765138', 'rtrsssssssssssssssssssss', 0), (31, 'bhavik oza', 'bhavikoza7878@gmail.com', '07600765138', 'sdsdsdd', 0), (43, 'bhavik oza', 'bhavikoza7878@gmail.com', '07600765138', 'dfdfdfdf', 0), (44, 'bhavik oza', 'bhavikoza7878@gmail.com', '07600765138', 'sdsd', 0); -- -------------------------------------------------------- -- -- Table structure for table `order` -- CREATE TABLE `order` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `full_name` varchar(255) NOT NULL, `address` varchar(250) NOT NULL, `city` varchar(50) NOT NULL, `state` varchar(15) NOT NULL, `pincode` int(11) NOT NULL, `mobile` varchar(15) NOT NULL, `payment_type` varchar(20) NOT NULL, `total_price` float NOT NULL, `payment_status` varchar(20) NOT NULL, `order_status` int(11) NOT NULL, `txnid` varchar(20) NOT NULL, `mihpayid` varchar(20) NOT NULL, `payu_status` varchar(10) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `order` -- INSERT INTO `order` (`id`, `user_id`, `full_name`, `address`, `city`, `state`, `pincode`, `mobile`, `payment_type`, `total_price`, `payment_status`, `order_status`, `txnid`, `mihpayid`, `payu_status`, `added_on`) VALUES (42, 1, 'bhavik oza', 'ankur society krishna nagar naroda', 'Ahmedabad', 'Gujarat', 382345, '+917600765138', 'COD', 2200, 'pending', 1, '0e60a26b1faa685bb48a', '', '', '0000-00-00 00:00:00'), (43, 2, 'sub cat', 'subcat news', 'subcatgty', 'subcat', 123456, '1234567890', 'COD', 269, 'pending', 1, '957a06eeed170fcc7a35', '', '', '0000-00-00 00:00:00'), (44, 2, 'testing nemw', 'testing adrress', 'test city', 'testing stat', 382345, '1234567899', 'COD', 120, 'pending', 1, '283cb6dfd0e9820b07f6', '', '', '0000-00-00 00:00:00'), (45, 1, 'bhavik', '12345678', 'hmjgh', 'lllkl', 123456, '123456789', 'COD', 120, 'pending', 1, '3441075c030b936dc932', '', '', '0000-00-00 00:00:00'), (46, 1, 'bhavik oza', 'ankur society krishna nagar naroda', 'Ahmedabad', 'Gujarat', 382345, '07600765138', 'COD', 140, 'pending', 1, '206ac9bcaf3e4663686b', '', '', '0000-00-00 00:00:00'), (47, 2, 'bhavik oza', 'ankur society krishna nagar naroda', 'Ahmedabad', 'Gujarat', 382345, '+917600765138', 'COD', 120, 'pending', 1, 'f0b4d82ef9848793d30e', '', '', '0000-00-00 00:00:00'), (48, 1, 'bhavik oza', 'ankur society krishna nagar naroda', 'Ahmedabad', 'Gujarat', 382345, '07600765138', 'COD', 130, 'pending', 1, 'ba18de58959011da50e8', '', '', '0000-00-00 00:00:00'), (49, 1, 'akash prajapti', 'c-63 ankur socity krisna nagar naroda', 'ahmedabad', 'gujarat', 0, '9876543210', 'COD', 140, 'pending', 1, '86b2c4f17500b77bccee', '', '', '0000-00-00 00:00:00'), (51, 23, 'akash prajapti', 'c-63 ankur socity krisna nagar naroda', 'ahmedabad', 'gujarat', 0, '9876543210', 'COD', 380, 'pending', 1, '8584af565f4d32bef27b', '', '', '0000-00-00 00:00:00'), (53, 23, 'bhavik oza', 'ankur society krishna nagar naroda', 'Ahmedabad', 'Gujarat', 382345, '07600765138', 'COD', 120, 'pending', 1, 'f681c3af761f5ee15f70', '', '', '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `order_detail` -- CREATE TABLE `order_detail` ( `id` int(11) NOT NULL, `order_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `seller_id` int(11) DEFAULT NULL, `qty` int(11) NOT NULL, `dilivery_charge` float NOT NULL, `price` float NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `order_detail` -- INSERT INTO `order_detail` (`id`, `order_id`, `product_id`, `seller_id`, `qty`, `dilivery_charge`, `price`) VALUES (50, 42, 83, NULL, 1, 200, 2000), (51, 43, 100, NULL, 1, 10, 259), (52, 44, 106, NULL, 1, 20, 100), (53, 45, 198, 1, 1, 0, 120), (54, 46, 232, 10, 1, 20, 120), (55, 47, 233, 10, 1, 0, 120), (56, 48, 243, 0, 1, 10, 120), (57, 49, 229, 10, 1, 20, 120), (58, 50, 238, 21, 1, 0, 120), (59, 51, 247, 0, 1, 100, 120), (60, 51, 248, 0, 1, 40, 120), (61, 52, 248, 0, 1, 40, 120), (62, 53, 251, 21, 1, 0, 120); -- -------------------------------------------------------- -- -- Table structure for table `order_status` -- CREATE TABLE `order_status` ( `id` int(11) NOT NULL, `name` varchar(32) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; -- -- Dumping data for table `order_status` -- INSERT INTO `order_status` (`id`, `name`) VALUES (1, 'Pending'), (4, 'Canceled'), (3, 'Shipped'), (2, 'Processing'), (5, 'Complete'); -- -------------------------------------------------------- -- -- Table structure for table `product` -- CREATE TABLE `product` ( `id` int(11) NOT NULL, `categories_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `mrp` varchar(50) NOT NULL, `price` varchar(50) NOT NULL, `qty` varchar(50) NOT NULL, `image` varchar(255) NOT NULL, `short_desc` varchar(255) NOT NULL, `description` text NOT NULL, `meta_title` varchar(200) NOT NULL, `meta_desc` varchar(255) NOT NULL, `meta_keyword` varchar(255) NOT NULL, `best_seller` int(11) NOT NULL, `size` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `product` -- INSERT INTO `product` (`id`, `categories_id`, `name`, `mrp`, `price`, `qty`, `image`, `short_desc`, `description`, `meta_title`, `meta_desc`, `meta_keyword`, `best_seller`, `size`, `status`) VALUES (1, 1, 'Cable Ties india', '', '', '', '1b4a4ec21e551e8223828a85838368e7.jpg', 'NYLON CABLE TIES', 'We are leading manufacturer and supplier of Wire Tie from Ahmedabad, Gujarat, India. Price shown above is. read mor', 'Cable Tie Manufacturers Near Me', '', 'We are leading manufacturer and supplier of Wire Tie from Ahmedabad, Gujarat, India.', 0, 'sdd', 1), (2, 1, 'Cable Ties india', '', '', '', '1b4a4ec21e551e8223828a85838368e7.jpg', '', '', 'Cable Ties india', '', 'Cable ties are small plastic fasteners used for holding electrical wires and cables. A cable tie is also known as a hose tie, zip tie.', 0, '', 1), (3, 1, 'Cable Ties', '', '', '', '752976655_WhatsApp Image 2021-03-27 at 9.51.20 AM.jpeg', 'NYLON CABLE TIES', '', 'Cable Ties ', '', 'Standard Nylon Cable Ties are made with high-quality nylon 6/6 and designed to secure wire bundles and harness components quickly, without slipping', 0, '', 1), (4, 1, 'Cable Ties', '', '', '', 'CableTiemanufacturer.jpg', '', '', 'cable tie manufacturer in india', '', 'Manufacturer of Cable Tie - Cable Ties, Nylon Cable Tie, Cable Ties With Low Profile Head and Releasable Cable Tie(Cable Ties Inside Serrated) offered by ', 0, '', 1), (6, 2, 'Cable nail clips', '', '', '', '148215601_cable clip.jpg 1.jpg', 'Cable nail clips: \r\nA cable clip is a device that manages wires and cables and secures them to a fixed point on a surface, like a wall, ceiling or floor. A wide range of cable clips is available to control cables of all sizes and shapes, in almost any num', '<p> </p>\r\n\r\n<p> </p>\r\n\r\n<p> </p>\r\n\r\n<p> </p>', 'Cable Nail Clip manufacturer', '', 'Business listings of Nail Cable Clip, Cable Nail clip manufacturers, suppliers and exporters in Ahmedabad, नेल केबल क्लिप विक्रेता, ...', 0, '', 1), (7, 1, 'Cable ties Manufacturer', '', '', '', '', '', '', 'Cable ties - India\'s Largest Manufacturer', '', 'Cable Ties, Industrial Cables & Cable Glands Wholesale Manufacturers from ahmedabad, Gujarat, India.', 0, '', 0), (8, 8, 'CONCRETE NAIL', '', '', '', '894008585_WhatsApp Image 2021-03-27 at 9.51.18 AM.jpeg', 'Concrete nail:\r\ninto masonry requires the right type of nail, a good quality hammer, and some technique. Concrete nails are often used in building construction and in home improvement projects, such as finishing a basement. A concrete nail is a special fa', '', 'Concrete Nails', '', 'Manufacturer Concrete Nail -india Concrete Nails offered by hificable ties Pipe Traders, Ahmedabad, Gujarat.', 0, '', 1), (9, 7, 'DRY WALL SCREW', '', '', '', '119380518_WhatsApp Image 2021-03-27 at 9.51.18 AM (1).jpeg', 'Dry wall screw:\r\nDrywall screws are used for fastening sheets of drywall to wall studs or ceiling joists. Compared to regular screws, drywall screws have deeper threads. This helps prevent the screws from being dislodged easily from the drywall.Drywall sc', '', 'Drywall Screws', '', ' Carbon black was added for greater resistance to ultra violet in outdoor usage. · Prolong useful life of cable tie under ...', 0, '', 1), (10, 3, 'Plastic wall plugs(gitti)', '', '', '', '916145872_WhatsApp Image 2021-04-04 at 12.39.10 PM.jpeg', 'Plastic wall plugs(gitti):\r\nA plastic wall plug is a plastic insert used to support the attachment of a screw into material that would not usually support its weight', '', 'Plastic Wall Plug manufacturers India', '', 'Manufacturer of Plastic Wall Plugs - Plastic Wall Plug, GRAY PLASTC WAL PLUG, Wall Plugs offered by hificable ties, Ahmedabad, Gujarat.', 0, '', 1), (11, 1, 'Cable Tie ', '', '', '', '752976655_WhatsApp Image 2021-03-27 at 9.51.20 AM.jpeg', 'NYLON CABLE TIES', '', 'Cable Tie manufacturer in Ahmedabad', '', 'Cable ties have to meet a broad range of requirements because they are used in a wide variety of applications – from the simple bundling of cables with ...', 0, '', 1), (12, 1, 'Cable Tie ', '', '', '', 'CableTiemanufacturer.jpg', '', '', 'Cable Tie manufacturer', '', 'We are leading manufacturer and supplier of Wire Tie from Ahmedabad, Gujarat, India. Price shown above is. read mor', 0, '', 1), (13, 6, 'UPVC PIPE FITTING CLAMPS ', '', '', '', '313945075_upvc-pipe-clamps-1-inch-500x500.jpg', 'pipe fitting clamps( upvc,cpvc,pvc)\r\nPipe clamps are found in all manner of household, industrial and outdoor settings. They’re used as an efficient and tidy way to restrain, secure and guide tubing or conduit for a range of plumbing, heating and electric', '<p>UPVC PIPE FITTING CLAMPS <br />\r\nAVAILABLE IN SIZES<br />\r\n1/2 INCH,<br />\r\n3/4 INCH,<br />\r\n1 INCH,<br />\r\n1-1/1/4 INCH <br />\r\n1-1/2 INCH,<br />\r\n2 INCH</p>', 'UPVC Pipe Clamps', '', 'pipe fitting clamps( upvc,cpvc,pvc) Pipe clamps are found in all manner of household, industrial and outdoor settings. They’re used as an efficient and tidy way to restrain, secure and guide tubing or conduit for a range of plumbing, heating and electric', 0, '', 1); -- -------------------------------------------------------- -- -- Table structure for table `seller` -- CREATE TABLE `seller` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(50) NOT NULL, `mobile` varchar(20) NOT NULL, `gst` varchar(20) NOT NULL, `password` varchar(15) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `seller` -- INSERT INTO `seller` (`id`, `name`, `email`, `mobile`, `gst`, `password`, `added_on`) VALUES (21, 'bhavik oza', 'bhavikoza7878@gmail.com', '9876543210', '123456789123564', 'bhavik', '2020-12-26 05:54:27'), (32, 'bhavik oza', 'bhavi@gmail.com', '9876543210', '123456789123564', '123456', '0000-00-00 00:00:00'), (33, 'bhavik oza', 'oza7878@gmail.com', '917600765138', '123456789123564', 'bhavik', '2020-12-30 04:11:20'); -- -------------------------------------------------------- -- -- Table structure for table `subcategories` -- CREATE TABLE `subcategories` ( `id` int(11) NOT NULL, `categories_id` int(11) NOT NULL, `image` varchar(300) NOT NULL, `subcategories` varchar(255) NOT NULL, `status` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `subcategories` -- INSERT INTO `subcategories` (`id`, `categories_id`, `image`, `subcategories`, `status`) VALUES (13, 68, '656572410_31YL3TnD0QL.jpg', 'Wash', 1), (14, 68, '229735269_270422324_21SWdYMZmaL.jpg', 'om', 1), (22, 72, '159249884_XCM_Manual_186x116_1198911XCM_Manual_1198911_991932_IN_Kitchen_PC_Dashboard_cards__3_1573726444_jpg_LOWER_QL85_._SY116_CB446704968_.jpg', 'tv', 1), (28, 77, '897073333_366054249_466407609_WhatsApp_Image_2020-11-29_at_2.22.27_PM-removebg-preview.png', 'oza', 1), (29, 77, '289594018_650605196_WhatsApp_Image_2020-11-29_at_2.22.27_PM-removebg-preview.png', 'dfdf', 1), (30, 77, '552321945_650605196_WhatsApp_Image_2020-11-29_at_2.22.27_PM-removebg-preview.png', 'grosry', 1), (39, 79, '214092124_248221193_253017915_XCM_Manual_186x116_1198911XCM_Manual_1198911_991932_IN_Kitchen_PC_Dashboard_cards__3_1573726444_jpg_LOWER_QL85_._SY116_CB446704968_.jpg', 'sadsd', 1), (40, 81, '677648135_214092124_248221193_253017915_XCM_Manual_186x116_1198911XCM_Manual_1198911_991932_IN_Kitchen_PC_Dashboard_cards__3_1573726444_jpg_LOWER_QL85_._SY116_CB446704968_.jpg', 'Wash', 1), (41, 81, '963191523_214092124_248221193_253017915_XCM_Manual_186x116_1198911XCM_Manual_1198911_991932_IN_Kitchen_PC_Dashboard_cards__3_1573726444_jpg_LOWER_QL85_._SY116_CB446704968_.jpg', 'ghghg', 1), (42, 80, '768352454_214092124_248221193_253017915_XCM_Manual_186x116_1198911XCM_Manual_1198911_991932_IN_Kitchen_PC_Dashboard_cards__3_1573726444_jpg_LOWER_QL85_._SY116_CB446704968_.jpg', 'sdfffgg', 1), (43, 81, '583092687_248221193_253017915_XCM_Manual_186x116_1198911XCM_Manual_1198911_991932_IN_Kitchen_PC_Dashboard_cards__3_1573726444_jpg_LOWER_QL85_._SY116_CB446704968_.jpg', 'sdsddfg', 1), (44, 81, '993202106_248221193_253017915_XCM_Manual_186x116_1198911XCM_Manual_1198911_991932_IN_Kitchen_PC_Dashboard_cards__3_1573726444_jpg_LOWER_QL85_._SY116_CB446704968_.jpg', 'sdsddfg', 1), (45, 80, '902682639_214092124_248221193_253017915_XCM_Manual_186x116_1198911XCM_Manual_1198911_991932_IN_Kitchen_PC_Dashboard_cards__3_1573726444_jpg_LOWER_QL85_._SY116_CB446704968_.jpg', 'Wash', 1); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `password` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `mobile` varchar(15) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `password`, `email`, `mobile`, `added_on`) VALUES (1, 'bhavik', 'bhavik', 'bhavik', '1234567890', '0000-00-00 00:00:00'), (2, 'akash', 'bhavik', 'bhavikoza7777@gmail.com', '8733975015', '0000-00-00 00:00:00'), (21, 'bhavik oza', '123456', 'bhavikoza@gmail.com', '7600765138', '2020-12-15 05:21:27'), (23, 'bhavik oza', '123456', 'bhavikoza7878@gmail.com', '07600765138', '2020-12-26 07:12:57'), (26, 'bhavik oza', 'sadsadsd', 'bhavikoz', '9157663638', '2021-02-02 08:19:27'); -- -------------------------------------------------------- -- -- Table structure for table `wishlist` -- CREATE TABLE `wishlist` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `wishlist` -- INSERT INTO `wishlist` (`id`, `user_id`, `product_id`, `added_on`) VALUES (39, 1, 67, '2020-11-20 05:37:05'), (40, 1, 83, '2020-11-26 05:08:39'), (41, 1, 96, '2020-11-26 05:41:34'), (52, 2, 116, '2020-11-30 05:45:38'), (53, 2, 109, '2020-11-30 05:48:22'), (54, 2, 113, '2020-11-30 06:30:21'), (55, 2, 118, '2020-11-30 06:42:02'), (56, 1, 121, '2020-12-03 10:18:31'), (64, 1, 243, '2021-02-02 12:19:07'); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin_users` -- ALTER TABLE `admin_users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `banner` -- ALTER TABLE `banner` ADD PRIMARY KEY (`id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `comment` -- ALTER TABLE `comment` ADD PRIMARY KEY (`id`); -- -- Indexes for table `contact_us` -- ALTER TABLE `contact_us` ADD PRIMARY KEY (`id`); -- -- Indexes for table `dilivery` -- ALTER TABLE `dilivery` ADD PRIMARY KEY (`id`); -- -- Indexes for table `name` -- ALTER TABLE `name` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order` -- ALTER TABLE `order` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order_detail` -- ALTER TABLE `order_detail` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order_status` -- ALTER TABLE `order_status` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product` -- ALTER TABLE `product` ADD PRIMARY KEY (`id`); -- -- Indexes for table `seller` -- ALTER TABLE `seller` ADD PRIMARY KEY (`id`); -- -- Indexes for table `subcategories` -- ALTER TABLE `subcategories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wishlist` -- ALTER TABLE `wishlist` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin_users` -- ALTER TABLE `admin_users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `banner` -- ALTER TABLE `banner` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `comment` -- ALTER TABLE `comment` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71; -- -- AUTO_INCREMENT for table `contact_us` -- ALTER TABLE `contact_us` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `dilivery` -- ALTER TABLE `dilivery` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `name` -- ALTER TABLE `name` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45; -- -- AUTO_INCREMENT for table `order` -- ALTER TABLE `order` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54; -- -- AUTO_INCREMENT for table `order_detail` -- ALTER TABLE `order_detail` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63; -- -- AUTO_INCREMENT for table `order_status` -- ALTER TABLE `order_status` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `product` -- ALTER TABLE `product` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `seller` -- ALTER TABLE `seller` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34; -- -- AUTO_INCREMENT for table `subcategories` -- ALTER TABLE `subcategories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27; -- -- AUTO_INCREMENT for table `wishlist` -- ALTER TABLE `wishlist` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65; COMMIT; /*!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 */;