| Server IP : 127.0.0.1 / Your IP : 216.73.216.48 Web Server : Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12 System : Windows NT DESKTOP-3H4FHQJ 10.0 build 19045 (Windows 10) AMD64 User : win 10 ( 0) PHP Version : 8.2.12 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : D:/xampp/htdocs-coblaa/market/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Mar 31, 2025 at 09:33 PM -- Server version: 10.1.37-MariaDB -- PHP Version: 8.2.12 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: `cb_marketdb` -- -- -------------------------------------------------------- -- -- Table structure for table `adverttb` -- CREATE TABLE `adverttb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `product_name` varchar(255) NOT NULL, `product_detail` text NOT NULL, `product_category` varchar(255) NOT NULL, `product_price` varchar(255) NOT NULL, `before_price` varchar(255) NOT NULL, `product_country` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `adress` varchar(255) NOT NULL, `contact` varchar(255) NOT NULL, `product_image` text NOT NULL, `product_url` text NOT NULL, `product_status` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `adverttb` -- INSERT INTO `adverttb` (`id`, `my_id`, `product_name`, `product_detail`, `product_category`, `product_price`, `before_price`, `product_country`, `country`, `city`, `adress`, `contact`, `product_image`, `product_url`, `product_status`, `curr_date`, `curr_time`) VALUES (1, 'CB1', 'HP True Wireless Headphones', 'HP True Wireless Headphones ENC Noise Cancelling Earbuds - Comfortable For IPhone/ Android, Built-in Microphone Sweat Resistant Earphones, Wireless Headphones', 'Mobiles', '', '', 'All', 'Bahrain', 'Manama', '', '', '887754799.webp', 'https://temu.to/k/e6qyc25jeps', 'Brand New', '2025-03-03', '16:54:25'), (2, 'CB1', 'Couple Watches Exquisite And Versatile', 'Couple Watches Exquisite And Versatile, Beautiful And Gentle Personality Ladies Watches, High-end And Atmospheric Casual Sports Business Student Men\'s Watches', 'Fashion', '', '', 'All', 'Bahrain', 'Manama', '', '', '1499963376.webp', 'https://temu.to/k/e5mc1arqxzh', 'Brand New', '2025-03-03', '16:58:38'), (3, 'CB1', 'Men\'s Electric Shaver, USB Charging, Digital Display', 'Men\'s Electric Shaver, USB Charging, Digital Display Function, Compact and Portable, Suitable for Business Trips, a Holiday Gift for Men', 'Beauty, Health', '', '', 'All', 'Bahrain', 'Manama', '', '', '654727971.webp', 'https://temu.to/k/edje0bxlsni', 'Brand New', '2025-03-03', '20:27:46'), (4, 'CB1', 'Eight-piece Set Four-in-One KM-6630 Four-in-One', 'Eight-piece Set Four-in-One KM-6630 Four-in-One Professional Rechargeable Nose and Ear Hair Trimmer Men\'s Personal Care Tool', 'Beauty, Health', '', '', 'All', 'Bahrain', 'Manama', '', '', '14006019.webp', 'https://app.temu.com/m/n5kvibhp0wg', 'Brand New', '2025-03-03', '20:37:11'), (5, 'CB1', 'Mini Electric Garlic Chopper and Meat Grinder', 'Mini Electric Garlic Chopper and Meat Grinder with Rechargeable Battery, Durable Plastic Body, 1200 RPM Motor Speed, USB Charging, 100/250ml Crushing Capacity', 'Appliances', '', '', 'All', 'Bahrain', 'Manama', '', '', '132717178.webp', 'https://temu.to/k/ef7l2a26q4r', 'Brand New', '2025-03-03', '20:43:49'), (6, 'CB1', 'Stainless Steel Deep Frying Pot with Strainer Basket', 'Stainless Steel Deep Frying Pot with Strainer Basket and Tong, Japanese Tempura Style Kitchen Accessory for French Fries and Chicken, Food-Safe Cookware with Fine Perforated Design for Even Heat Distribution, Durable and Easy to Clean, Ideal for Home Cooking and Frying Enthusiasts, Chicken Frying Pot | Sleek Kitchenware | Heat Distribution Pot', 'Appliances', '', '', 'All', 'Bahrain', 'Manama', '', '', '1131918304.webp', 'https://temu.to/k/ed4omxqxc2d', 'Brand New', '2025-03-03', '21:08:28'), (7, 'CB1', 'UAO Stainless Steel Electric Grinder', 'UAO Stainless Steel Electric Grinder - 220V Multi-Function, Ultrafine Coffee & Grain Mill, Easy to Clean & Operate, Sleek Blue Design with Transparent Lid - Ideal for Home Use & Holiday Gifts', 'Appliances', '', '', 'All', 'Bahrain', 'Manama', '', '', '1249558224.webp', 'https://temu.to/k/ets19cdceir', 'Brand New', '2025-03-03', '21:13:53'), (8, 'CB1', 'Luggage Scale, Electronic Scale', 'Luggage Scale, Electronic Scale, Portable Scale, Hook Scale, Parcel Scale, 50KG Mini Hanging Scale, Portable Spring Lifting Scale, Fishing Scale', 'Electronics', '', '', 'All', 'Bahrain', 'Manama', '', '', '1625644150.webp', 'https://temu.to/k/eu5e6uwityh', 'Brand New', '2025-03-03', '21:22:37'), (9, 'CB1', 'Portable USB-Rechargeable Blender & Juicer', 'Portable USB-Rechargeable Blender & Juicer', 'Appliances', '', '', 'All', 'Bahrain', 'Manama', '', '', '610913697.webp', 'https://temu.to/k/eputpsb3zd2', 'Brand New', '2025-03-03', '21:28:12'), (10, 'CB1', 'JBL WAVE FLEX True Wireless Earphones', 'JBL WAVE FLEX True Wireless Earphones Semi-In-Ear Music Calling Noise Reduction Sports High-Quality Earphones, Comfortable Earphones, Built-in Microphone', 'Mobiles', '', '', 'All', 'Bahrain', 'Manama', '', '', '1667632674.webp', 'https://temu.to/k/ep71b93nzga', 'Brand New', '2025-03-05', '14:57:29'), (11, 'CB1', 'Food Storage Made Simple: 3pcs', 'Food Storage Made Simple: 3pcs Plastic Containers with Vented Lids', 'Appliances', '', '', 'All', 'Bahrain', 'Manama', '', '', '172719318.webp', 'https://temu.to/k/enlpjuysj0q', 'Brand New', '2025-03-05', '15:01:14'), (12, 'CB1', 'WEEME Golden Hair Cutting 3 Piece Set for Men.', 'WEEME Golden Hair Cutting Three-Piece Set, Men\'S Grooming Kit, Barber\'S Haircutting Set, Valentine\'S Day Gift Box. USB Rechargeable, LCD Display. Includes 1 Black And Golden Professional Hair Clipper + 1 Golden Men\'S Razor + 1 Golden T-Blade Trimmer + 8 Guide Combs + 3 USB Power Cables + 3 Cleaning Brushes + 1 Comb. A Gift for Fathers, Boyfriends, Father\'S Day Presents, Birthday Gifts, And Holiday Gifts.', 'Electronics', '', '', 'All', 'Bahrain', 'Manama', '', '', '995078587.webp', 'https://temu.to/k/e8u3i9yb4mm', 'Brand New', '2025-03-05', '15:05:33'), (13, 'CB1', 'Selfie Stick Multifunctional Tripod Wireless Remote', 'Selfie Stick Multifunctional Tripod Wireless Remote Control Selfie Stick Extended Remote Control Mobile Phone Holder Live Broadcast Tripod Multifunctional Photo Universal Travel Selfie Artifact', 'Phone Accessories', '', '', 'All', 'Bahrain', 'Manama', '', '', '303767370.webp', 'https://temu.to/k/ebxxuxf1ytm', 'Brand New', '2025-03-05', '15:28:51'), (14, 'CB1', 'CX Organ Finger Ring Phone Holder', 'CX Organ Finger Ring Holder (Short Rope+Long Rope) for iPhone 16/15/14/13/12/11 Pro Max SE 2020/SE 2022/X/XS/XR/XS Max 16 Plus 15 Plus 14 Plus 7 8 Plus Case Wallet with Card Holder, 360°Rotation Finger Ring Holder Kickstand, RFID Blocking Protective Shockproof Cover', 'Phone Accessories', '', '', 'All', 'Bahrain', 'Manama', '', '', '958607190.webp', 'https://temu.to/k/eknidf3iyrn', 'Brand New', '2025-03-05', '15:31:47'), (15, 'CB1', 'Casual Men\'s Fashion Suit', 'Casual Men\'s Fashion Suit Lightweight and Comfortable Long Sleeve Trousers Set', 'Men Fashion', '', '', 'All', 'Bahrain', 'Manama', '', '', '1186226535.webp', 'https://temu.to/k/er0e5tnsggr', 'Brand New', '2025-03-05', '15:34:47'), (16, 'CB1', 'Women\'s Watch Vintage Square Pointer', '5pcs/set Women\'s Watch Vintage Square Pointer Quartz Watch Analog Green Wrist Watch & Rhinestone Jewelry Set, Gift For Mom', 'Women Fashion', '', '', 'All', 'Bahrain', 'Manama', '', '', '432874882.webp', 'https://temu.to/k/ej9eptpbshz', 'Brand New', '2025-03-05', '15:38:28'), (17, 'CB1', 'PEJE Smart Watch for Men & Women', 'PEJE Smart Watch for Men & Women, 3.53cm Full Touch Screen,, 100+ Sports Modes, Weather & Music Control, Voice Assistant, Fitness & Health Tracking, USB Charging, Glitter Embellishment, Silica Gel Strap, 230mAh Battery', 'Phone Accessories', '', '', 'All', 'Bahrain', 'Manama', '', '', '1503600939.webp', 'https://temu.to/k/ec878899wcm', 'Brand New', '2025-03-05', '15:41:55'), (18, 'CB1', 'Men\'s Trendy Solid Sports Outfit Sets', 'Men\'s Trendy Solid Sports Outfit Sets, Stand Collar Long Sleeve Zip Up Jackets & Elastic Waist Sweatpants For Outdoor Casual, Spring And Autumn', 'Men Fashion', '', '', 'All', 'Bahrain', 'Manama', '', '', '330834532.webp', '', 'Brand New', '2025-03-05', '15:43:58'), (19, 'CB1', 'Women\'s Wedge Slide Sandals', 'Women\'s Wedge Slide Sandals, Open Toe Cross Strap Slip On Shoes, Casual Outdoor Sandals', 'Women Fashion', '', '', 'All', 'Bahrain', 'Manama', '', '', '1982873577.webp', 'https://temu.to/k/ekgmezpbdrv', 'Brand New', '2025-03-05', '15:46:07'), (20, 'CB1', 'Women\'s Black & Brown Faux Cover Wedge Sandals', 'Women\'s Black & Brown Faux Cover Wedge Sandals - Floral Decor Open Toe Slip-On Shoes with Comfortable Thick Sole for Casual Attire', 'Women Fashion', '', '', 'All', 'Bahrain', 'Manama', '', '', '1664102067.webp', 'https://temu.to/k/egureqeerds', 'Brand New', '2025-03-05', '15:52:54'), (21, 'CB1', 'Women\'S Solid Color Sleeveless Polyester 100%', 'Small\r\nTrue to size\r\nLarge\r\n3%\r\n94%\r\n3%\r\navatar\r\ngr***56\r\ninon 1 Dec 2024\r\nlovely casual outfit\r\nSee more\r\navatar\r\nre***on\r\ninon 13 Oct 2024\r\nthis set is gorgeous. it fits perfectly well and good value for money\r\nSee more\r\navatar\r\n58***29\r\ninon 20 Oct 2024\r\nreally nice material love the colour n\r\nabsolutely beautiful..I am happy with my purchase, it\'s comfy and fits well for me., , highly recommended\r\nSee more\r\navatar\r\nkrisboy favour\r\ninon 29 Jan 2025\r\nLovely casual outfit, good quality product, perfect as described.\r\nSe', 'Women Fashion', '', '', 'All', 'Bahrain', 'Manama', '', '', '743682985.webp', 'https://temu.to/k/es8khsyor6h', 'Brand New', '2025-03-06', '16:02:38'), (22, 'CB1', 'Men\'s Letter Embroidered Casual', 'Men\'s Letter Embroidered Casual Bomber Jacket Gifts Best Sellers', 'Men Fashion', '', '', 'All', 'Bahrain', 'Manama', '', '', '1234457397.webp', 'https://temu.to/k/eumm0z8u4t3', 'Brand New', '2025-03-06', '16:07:51'), (23, 'CB1', '360° Rotating Tablet Phone Holder', '360° Rotating Tablet Phone Holder Spiral Base Lazy Stand Mobile Phone Tablet Bedside Stand Bed Lazy Stand', 'Phone Accessories', '', '', 'All', 'Bahrain', 'Manama', '', '', '480993464.webp', 'https://temu.to/k/eavzd0d2xr2', 'Brand New', '2025-03-06', '16:10:35'), (24, 'CB1', 'The classic creative desk lamp', 'The classic creative desk lamp that can bring not necessarily decoration to the home is suitable for bedroom, study, living room, as a gift', 'Electronics', '', '', 'All', 'Bahrain', 'Manama', '', '', '1199901449.webp', 'https://temu.to/k/e1o15rqh1ls', 'Brand New', '2025-03-06', '16:13:05'), (25, 'CB1', 'Party Rhinestone Two-piece Set', 'Party Rhinestone Two-piece Set, Bodycon Crop Top & High Waist Floor Length Skirt, Women\'s Clothing', 'Women Fashion', '', '', 'All', 'Bahrain', 'Manama', '', '', '359779524.webp', 'https://temu.to/k/ekicc4vzoiq', 'Brand New', '2025-03-06', '16:15:31'), (26, 'CB1', 'Stylish Smart Watch for Men & Women', 'Stylish Smart Watch for Men & Women - 4.65cm HD Display, Wireless Calling, Long Battery Life, Silicone Band, Zinc Alloy Case', 'Men Fashion', '', '', 'All', 'Bahrain', 'Manama', '', '', '158035568.webp', 'https://temu.to/k/e0fnm81j871', 'Brand New', '2025-03-06', '16:19:33'); -- -------------------------------------------------------- -- -- Table structure for table `ad_viewtb` -- CREATE TABLE `ad_viewtb` ( `id` int(11) NOT NULL, `ad_product_id` varchar(255) NOT NULL, `user_ip` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `carttb` -- CREATE TABLE `carttb` ( `id` int(11) NOT NULL, `advert_id` varchar(255) NOT NULL, `user_ip` varchar(255) NOT NULL, `item_qty` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_date` varchar(255) NOT NULL, `cur_month` varchar(255) NOT NULL, `cur_year` varchar(255) NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `categorytb` -- CREATE TABLE `categorytb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `cat_img` varchar(255) NOT NULL, `cat_name` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_date` date NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `categorytb` -- INSERT INTO `categorytb` (`id`, `my_id`, `cat_img`, `cat_name`, `cur_country`, `cur_city`, `cur_date`, `cur_time`) VALUES (1, '2', 'cat22.jpg', 'Computers', '', '', '2022-01-19', '15:54:47'), (2, '2', 'cat4.jpg', 'Electronics', '', '', '2022-01-19', '15:56:30'), (3, '2', 'cat12.jpg', 'Appliances', '', '', '2022-01-19', '15:56:30'), (4, '2', 'cat1.jpg', 'Mobiles', '', '', '2022-01-19', '15:57:57'), (5, '2', 'cat10.jpg', 'Fashion', '', '', '2022-01-19', '15:57:57'), (6, '2', 'cat14.jpg', 'Furniture', '', '', '2022-01-19', '15:59:28'), (7, '2', 'cat16.jpg', 'Grocery', '', '', '2022-01-19', '15:59:28'), (8, '2', 'cat20.jpg', 'Sports', '', '', '2022-01-19', '16:00:35'), (9, '2', 'cat25.jpg', 'Gaming', '', '', '2022-01-19', '16:00:35'), (10, '2', 'cat19.jpg', 'Beauty, Health', '', '', '2022-01-19', '16:01:44'), (11, 'CB1', '190499175.webp', 'Men Fashion', 'Bahrain', 'Manama', '2025-03-05', '15:13:07'), (12, 'CB1', '438142591.webp', 'Women Fashion', 'Bahrain', 'Manama', '2025-03-05', '15:15:58'), (13, 'CB1', '2026960030.webp', 'Kids Girls Fashion', 'Bahrain', 'Manama', '2025-03-05', '15:17:44'), (14, 'CB1', '2099452006.webp', 'Kids Boy Fashion', 'Bahrain', 'Manama', '2025-03-05', '15:19:30'), (15, 'CB1', '1517516539.webp', 'Phone Accessories', 'Bahrain', 'Manama', '2025-03-05', '15:22:44'), (16, 'CB1', '1661320256.jpeg', 'Computer Accessories', 'Bahrain', 'Manama', '2025-03-05', '15:23:33'); -- -------------------------------------------------------- -- -- Table structure for table `more_advert_imagestb` -- CREATE TABLE `more_advert_imagestb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `advert_id` varchar(255) NOT NULL, `image_url2` varchar(255) NOT NULL, `image_url3` varchar(255) NOT NULL, `image_url4` varchar(255) NOT NULL, `date` date NOT NULL, `time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `more_advert_imagestb` -- INSERT INTO `more_advert_imagestb` (`id`, `my_id`, `advert_id`, `image_url2`, `image_url3`, `image_url4`, `date`, `time`) VALUES (1, 'CB1', '1', '966230528.webp', '832888870.webp', '1364248587.webp', '2025-03-03', '16:54:25'), (2, 'CB1', '2', '815282536.webp', '234328937.webp', '1959733047.webp', '2025-03-03', '16:58:38'), (3, 'CB1', '3', '1443019210.webp', '628994019.webp', '1191302030.webp', '2025-03-03', '20:27:46'), (4, 'CB1', '4', '1821156076.webp', '881935412.webp', '711638455.webp', '2025-03-03', '20:37:11'), (5, 'CB1', '5', '1820513093.webp', '1302919822.webp', '1897478325.webp', '2025-03-03', '20:43:49'), (6, 'CB1', '6', '1779122484.webp', '1482645442.webp', '2094832830.webp', '2025-03-03', '21:08:28'), (7, 'CB1', '7', '1464396986.webp', '1388697361.webp', '482626793.webp', '2025-03-03', '21:13:53'), (8, 'CB1', '8', '2133758429.webp', '1477150261.webp', '1722074182.webp', '2025-03-03', '21:22:37'), (9, 'CB1', '9', '1904933556.webp', '1212683878.webp', '1045505574.webp', '2025-03-03', '21:28:12'), (10, 'CB1', '10', '1376367090.webp', '1297454994.webp', '513543321.webp', '2025-03-05', '14:57:29'), (11, 'CB1', '11', '1297034718.webp', '109412242.webp', '1761436580.webp', '2025-03-05', '15:01:14'), (12, 'CB1', '12', '2032119082.webp', '49985587.webp', '41775094.webp', '2025-03-05', '15:05:33'), (13, 'CB1', '13', '554908571.webp', '1687503413.webp', '511872940.webp', '2025-03-05', '15:28:51'), (14, 'CB1', '14', '1823449994.webp', '189860812.webp', '1931931388.webp', '2025-03-05', '15:31:47'), (15, 'CB1', '15', '747435612.webp', '1725173662.webp', '1940677404.webp', '2025-03-05', '15:34:47'), (16, 'CB1', '16', '1240104134.webp', '212638967.webp', '918531502.webp', '2025-03-05', '15:38:28'), (17, 'CB1', '17', '844735456.webp', '1309193881.webp', '1089394873.webp', '2025-03-05', '15:41:55'), (18, 'CB1', '18', '168904740.webp', '1119175935.webp', '1725606626.webp', '2025-03-05', '15:43:58'), (19, 'CB1', '19', '998649515.webp', '1959754626.webp', '1110295889.webp', '2025-03-05', '15:46:07'), (20, 'CB1', '20', '1990753541.webp', '412886030.webp', '487306664.webp', '2025-03-05', '15:52:54'), (21, 'CB1', '21', '1673416801.webp', '1803535340.webp', '1592620939.webp', '2025-03-06', '16:02:38'), (22, 'CB1', '22', '231412368.webp', '433033790.webp', '537629367.webp', '2025-03-06', '16:07:51'), (23, 'CB1', '23', '603721216.webp', '1314572114.webp', '216452713.webp', '2025-03-06', '16:10:35'), (24, 'CB1', '24', '550884668.webp', '950997546.webp', '1841634922.webp', '2025-03-06', '16:13:05'), (25, 'CB1', '25', '1220423327.webp', '1065202412.webp', 'clear1.clear', '2025-03-06', '16:15:31'), (26, 'CB1', '26', '1515210413.webp', '1217059117.webp', '276372627.webp', '2025-03-06', '16:19:33'); -- -------------------------------------------------------- -- -- Table structure for table `purchased_filtertb` -- CREATE TABLE `purchased_filtertb` ( `id` int(11) NOT NULL, `user_ip` varchar(255) NOT NULL, `invoice_no` varchar(255) NOT NULL, `total_pay` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `purchased_itemtb` -- CREATE TABLE `purchased_itemtb` ( `id` int(11) NOT NULL, `invoice_no` varchar(255) NOT NULL, `advert_id` varchar(255) NOT NULL, `user_ip` varchar(255) NOT NULL, `item_qty` varchar(255) NOT NULL, `price_per_unit` varchar(255) NOT NULL, `trans_id` varchar(255) NOT NULL, `paying_mobile_no` varchar(255) NOT NULL, `client_name` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_date` varchar(255) NOT NULL, `cur_month` varchar(255) NOT NULL, `cur_year` varchar(255) NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `userstb` -- CREATE TABLE `userstb` ( `id` int(11) NOT NULL, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `contact` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `userstb` -- INSERT INTO `userstb` (`id`, `first_name`, `last_name`, `email`, `contact`, `password`, `country`, `city`, `curr_date`, `curr_time`) VALUES (1, 'tincy', 'kvt', 'tincy@kvt.com', '44444', '1234', '', '', '2019-04-19', '17:12:04'); -- -- Indexes for dumped tables -- -- -- Indexes for table `adverttb` -- ALTER TABLE `adverttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ad_viewtb` -- ALTER TABLE `ad_viewtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `carttb` -- ALTER TABLE `carttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `categorytb` -- ALTER TABLE `categorytb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `more_advert_imagestb` -- ALTER TABLE `more_advert_imagestb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `purchased_filtertb` -- ALTER TABLE `purchased_filtertb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `purchased_itemtb` -- ALTER TABLE `purchased_itemtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `userstb` -- ALTER TABLE `userstb` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `adverttb` -- ALTER TABLE `adverttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27; -- -- AUTO_INCREMENT for table `ad_viewtb` -- ALTER TABLE `ad_viewtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `carttb` -- ALTER TABLE `carttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `categorytb` -- ALTER TABLE `categorytb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `more_advert_imagestb` -- ALTER TABLE `more_advert_imagestb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27; -- -- AUTO_INCREMENT for table `purchased_filtertb` -- ALTER TABLE `purchased_filtertb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `purchased_itemtb` -- ALTER TABLE `purchased_itemtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `userstb` -- ALTER TABLE `userstb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; 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 */;