| 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 4.8.4 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Feb 27, 2025 at 10:48 AM -- Server version: 10.1.37-MariaDB -- PHP Version: 7.3.1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; 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, `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`, `country`, `city`, `adress`, `contact`, `product_image`, `product_url`, `product_status`, `curr_date`, `curr_time`) VALUES (1, '2', 'Redmi 9A ', 'Display Size: 6.53inches\r\nProcessor: Octa core\r\nInternal Memory: 32GB\r\nRAM: 2GB\r\nCamera: 13MP\r\nSeconda', 'Mobiles', '341000', '400000', 'Bahrain', '', '', '', '1402181997.jfif', '', '', '2022-02-19', '23:34:43'), (2, '2', 'Redmi 9i 6.53\" 4GB RAM, 64GB,13MP, 5000mAh - Blue', '4 GB RAM, 64 GB ROM, Expandable Upto 512 GB\r\n16.59 cm (6.53 inch) HD+ Display\r\n13MP Rear Camera |', 'Mobiles', '419000', '650000', 'Bahrain', '', '', '', '129728934.jpeg', '', '', '2022-02-19', '23:54:45'), (3, '2', 'Men\'s Shoes ', 'The best walk on the market\r\nIn all colors.', 'Fashion', '50000', '70000', 'Uganda', 'Kampala', '', '', '2144836768.jpg', '', '', '2022-05-10', '00:32:15'), (4, '2', 'Men\'s Shoes ', 'Timberland is the best easy smart walk in the market.\r\nLook great ', 'Fashion', '60000', '80000', 'Uganda', 'Kampala', '', '', '1610896269.jpg', '', '', '2022-05-10', '00:56:55'), (5, '2', 'Shoes', 'Vivaia very simple and smart ', 'Fashion', '35,000', '40,000', 'Saudi Arabia', '', '', '', '1267148427.jpg', '', '', '2022-05-10', '01:20:14'), (6, '2', 'Dell Latitude E6400', 'Dell Latitude E6400\r\nIntel core 2 duo 2.90Ghz\r\nRam: 2GB\r\nHDD: 250GB\r\nDVD writer \r\nWebcam \r\nBluetooth \r\n', 'Computers', '420000', '500000', 'Uganda', 'Kampala', '', '', '1542785630.jpg', '', 'Second Hand', '2022-05-24', '10:46:28'), (7, '2', 'Dell Precision 3400', 'Full set 17 inch monitor,Intel core 2 duo 2 40Ghz,Ram:2GB, HDD:500GB, DVD writer, 1gb nvidia GF', 'Computers', '690000', '750000', 'Uganda', 'Kampala', '', '', '1596818255.jpg', '', 'Second Hand', '2022-05-24', '11:16:20'), (8, '32', 'Infinix smart 5', 'Infinix smart 5, 4G LTE, Android 10, size 6.6, Ram 2GB, Storage 32GB, Camera 13mp, Fingerprint', 'Mobiles', '300,000 ', '398, 000', 'Saudi Arabia', '', '', '', '1116890600.jpg', '', 'Second Hand', '2022-05-24', '23:23:51'), (9, '2', 'Samsung Galaxy A10', '4G LTE, Android 10, size 6.2\", Ram 2gb, Storage 32gb,Camera 13mp,battery 3400', 'Mobiles', '250000', '300000', 'Uganda', '', '', '', '583550990.jpg', '', 'Second Hand', '2022-05-26', '11:15:29'), (10, '2', 'Samsung TV 32 inches ', 'Samsung TV 32 inches, HD quality pictures, with USB port, HDMI port', 'Electronics', '450000', '500000', 'Uganda', 'Kampala', '', '', '1935580235.jpg', '', 'Second Hand', '2022-05-27', '00:05:36'), (11, '2', 'Camera Canon EOS 20D', 'Camera Canon EOS 20D', 'Electronics', '470000', '500000', 'Bahrain', '', '', '', '867849891.jpg', '', 'Second Hand', '2022-06-25', '18:49:07'), (12, '2', 'Luxury Sofa', 'Call or Whatsapp +256 784 280548.\r\nSmart furniture', 'Furniture', '1.1M', '2M', 'Bahrain', '', '', '', '898331975.jfif', '', 'Brand New', '2022-09-06', '19:40:07'), (13, '2', 'WD External Hard Drive 750GB', 'Western Digital WD External Hard Drive 750GB.\r\nCall or whatApp 0704577499', 'Computers', '175000', '210000', 'Bahrain', '', '', '', '400548976.jpeg', '', 'Second Hand', '2022-09-06', '19:52:43'), (14, '2', 'Hisense LED 32 inches', 'Hisense LED Digital Tv 32 inches HD quality picture with USB port,HDMI port,VGA port, Satellite', 'Electronics', '450000', '500000', 'Bahrain', '', '', '', '862780214.jpeg', '', 'Second Hand', '2022-09-06', '20:01:30'), (15, '2', 'RHM mini woofer', 'With Radio,USB port,SD card,Bluetooth,Remote control Mob 0704577499', 'Electronics', '130000', '150000', 'Bahrain', '', '', '', '59976171.jpeg', '', 'Second Hand', '2022-09-06', '20:06:18'), (16, '2', 'Hisense LED 32 inches', 'Hisense LED Digital Tv 32 inches HD quality picture with USB,HDMI,VGA, Satellite 0704577499', 'Electronics', '450000', '490000', 'Bahrain', '', '', '', '1209347974.jpeg', '', 'Second Hand', '2022-09-06', '20:13:11'), (17, '2', 'Samsung Galaxy A03', '4g Lite,Android 11,Size 6.5\",Ram 2gb,Storage 32gb,camera 12mp battery 5000mah 0704577499', 'Mobiles', '320000', '360000', 'Bahrain', '', '', '', '1586332566.jpeg', '', 'Second Hand', '2022-09-06', '20:26:13'), (18, '2', 'High General Projector ', 'High general projector LED-33+,2HDMI,USB,VGA,Banana port\r\n0704577499', 'Electronics', '550000', '600000', 'Bahrain', 'Manama', '', '', '711220477.jpg', '', 'Second Hand', '2022-09-12', '13:46:49'), (19, '2', 'Garrison air conditioner AC Garrison 8500BTU', 'Garrison air conditioner AC\r\nGarrison 8500BTU portable Air Conditioner.\r\n0704577499', 'Electronics', '400000', '470000', 'Bahrain', '', '', '', '2062552435.jpg', '', 'Second Hand', '2022-09-12', '18:33:01'), (20, '2', 'Dell inspiron 1525', 'Intel Dual core 2.0Ghz,Ram 4gb,HDD 120gb,DVD writer 0704577499', 'Computers', '340000', '400000', 'Bahrain', '', '', '', '278371396.jpg', '', 'Second Hand', '2022-09-13', '13:42:19'), (21, '2', 'Hp Intel 865, 2.40Ghz, ', 'Hp Intel 865, 2.40Ghz, Ram 1gb,HDD 80gb 0704577499', 'Computers', '390000', '450000', 'Bahrain', '', '', '', '119887233.jpg', '', 'Second Hand', '2022-09-13', '17:21:03'), (22, '2', 'Huawei p10 lite,Ram 4gb,storage 64gb,camera 12mp,', 'Huawei p10 lite,Ram 4gb,storage 64gb,camera 12mp, android 8.0 0704577499', 'Mobiles', '320000', '380000', 'Bahrain', '', '', '', '689507048.jpg', '', 'Second Hand', '2022-09-15', '00:21:41'), (23, '2', 'Hp stream notebook,Intel Celeron 2.16ghz', 'Hp stream notebook,Intel Celeron 2.16ghz,Ram 2gb,HDD 32gb, 0704577499', 'Computers', '270000', '300000', 'Bahrain', '', '', '', '873977272.jpg', '', 'Second Hand', '2022-09-15', '18:45:46'), (24, '2', 'Ailipu Woofer', 'Ailipu Woofer,Radio,USB,SD card,Bluetooth, 0704577499', 'Electronics', '220000', '250000', 'Bahrain', '', '', '', '1982813703.jpg', '', 'Second Hand', '2022-09-16', '09:02:34'), (25, '2', 'Cortina LED TV 32 inches ', 'Cortina LED TV 32 inches with inbuilt decoder,USB,HDMI, VGA 0704577499', 'Electronics', '470000', '500000', 'Bahrain', '', '', '', '467064101.jpg', '', 'Second Hand', '2022-09-16', '09:07:03'), (26, '2', 'Hp Intel 865 full set', 'Hp Intel 865 full set,2.4Ghz,Ram 1gb, HDD 80g,bDVD 0704577499', 'Computers', '390000', '450000', 'Bahrain', '', '', '', '1914138270.jpg', '', 'Second Hand', '2022-09-23', '01:03:11'), (27, '2', 'LG LED Digital TV 32 inches HD quality', 'LG LED Digital TV 32 inches HD quality,USB,inbuilt decoder 0704577499', 'Electronics', '500000', '600000', 'Bahrain', '', '', '', '127656349.jpg', '', 'Second Hand', '2022-09-23', '21:22:35'), (28, '2', 'Macbook Air 2013,13.3\",Intel core i5', 'Macbook Air 2013,13.3\",Intel core i5,Ram 4gb,SSD 256gb 0704577499\r\nBattery 6Hrs', 'Computers', '1200000', '1500000', 'Bahrain', '', '', '', '76015274.jpg', '', 'Second Hand', '2022-09-24', '18:01:29'), (29, '2', 'Hp Envy Touchsmart,Inte core i7-4700MQ', 'Hp Envy Touchsmart,Inte core i7-4700MQ 4th gen 2.40Ghz,Ram 4gb,HDD 250gb 0704577499', 'Computers', '600000', '680000', 'Bahrain', '', '', '', '2129769855.jpg', '', 'Second Hand', '2022-09-26', '18:20:45'), (30, '2', 'Hp EliteBook 8440p Intel core i5 2.40Ghz', 'Hp EliteBook 8440p Intel core i5 2.40Ghz, Ram 4gb,HDD 500GB,DVD 0704577499', 'Computers', '370000', '480000', 'Bahrain', '', '', '', '1788023636.jpg', '', 'Second Hand', '2022-09-30', '08:43:33'), (31, '2', 'Easy push', 'Easy push close ', 'Fashion', '20000', '40000', 'Bahrain', '', '', '', '524749411.jpg', '', 'Brand New', '2022-09-30', '17:35:07'), (32, '2', 'Connex L1470,Intel Atom,1.4ghz,Ram 2gb', 'Connex L1470,Intel Atom,1.4ghz,Ram 2gb,HDD 32gb,webcam,battery 4hr 0704577499', 'Computers', '450000', '500000', '', '', '', '', '1044850377.jpg', '', 'Second Hand', '2022-10-06', '17:11:57'), (33, '2', 'Dell Optiplex 390,Fullset 17\" monitor', 'Dell Optiplex 390,Fullset 17\" monitor,intel core i5 3.1Ghz,Ram 4gb,HDD 500gb 0704577499', 'Computers', '690000', '750000', 'Bahrain', '', '', '', '993983452.jpg', '', 'Second Hand', '2022-10-10', '20:41:51'), (34, '2', 'Shoes', 'We do deliver ', 'Fashion', '145oook', '135k', 'France', '', '', '', '464703703.jpg', '', 'Brand New', '2022-10-22', '19:16:24'); -- -------------------------------------------------------- -- -- 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; -- -- Dumping data for table `carttb` -- INSERT INTO `carttb` (`id`, `advert_id`, `user_ip`, `item_qty`, `cur_country`, `cur_city`, `cur_date`, `cur_month`, `cur_year`, `cur_time`) VALUES (4, '3', '139.64.8.55', '1', 'Saudi Arabia', '', '10', 'May', '2022', '01:00:38'); -- -------------------------------------------------------- -- -- 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'); -- -------------------------------------------------------- -- -- 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, '2', '1', '701479589.jpg', '2127360051.jfif', '1721050422.jpg', '2022-02-19', '23:34:43'), (2, '2', '2', '270333475.png', '108201825.jpeg', 'clear1.clear', '2022-02-19', '23:54:46'), (3, '2', '3', '1551988184.jpg', 'clear1.clear', 'clear1.clear', '2022-05-10', '00:32:15'), (4, '2', '4', '1939784274.jpg', '1639171383.jpg', '734450012.jpg', '2022-05-10', '00:56:55'), (5, '2', '5', '1183998435.jpg', '1279560554.jpg', 'clear1.clear', '2022-05-10', '01:20:14'), (6, '2', '6', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-05-24', '10:46:28'), (7, '2', '7', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-05-24', '11:16:20'), (8, '2', '8', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-05-24', '23:23:51'), (9, '2', '9', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-05-26', '11:15:29'), (10, '2', '10', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-05-27', '00:05:36'), (11, '2', '11', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-06-25', '18:49:07'), (12, '2', '12', '240342778.jpeg', 'clear1.clear', 'clear1.clear', '2022-09-06', '19:40:07'), (13, '2', '13', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-06', '19:52:43'), (14, '2', '14', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-06', '20:01:30'), (15, '2', '15', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-06', '20:06:18'), (16, '2', '16', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-06', '20:13:11'), (17, '2', '17', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-06', '20:26:13'), (18, '2', '18', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-12', '13:46:49'), (19, '2', '19', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-12', '18:33:02'), (20, '2', '20', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-13', '13:42:19'), (21, '2', '21', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-13', '17:21:03'), (22, '2', '22', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-15', '00:21:41'), (23, '2', '23', '1627718140.jpg', 'clear1.clear', 'clear1.clear', '2022-09-15', '18:45:46'), (24, '2', '24', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-16', '09:02:34'), (25, '2', '25', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-16', '09:07:03'), (26, '2', '26', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-23', '01:03:11'), (27, '2', '27', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-23', '21:22:35'), (28, '2', '28', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-24', '18:01:29'), (29, '2', '29', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-26', '18:20:45'), (30, '2', '30', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-30', '08:43:33'), (31, '2', '31', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-09-30', '17:35:07'), (32, '2', '32', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-10-06', '17:11:57'), (33, '2', '33', 'clear1.clear', 'clear1.clear', 'clear1.clear', '2022-10-10', '20:41:52'), (34, '2', '34', '1263232595.jpg', '965022424.jpg', '1388958732.jpg', '2022-10-22', '19:16:24'); -- -------------------------------------------------------- -- -- 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; -- -- Dumping data for table `purchased_itemtb` -- INSERT INTO `purchased_itemtb` (`id`, `invoice_no`, `advert_id`, `user_ip`, `item_qty`, `price_per_unit`, `trans_id`, `paying_mobile_no`, `client_name`, `cur_country`, `cur_city`, `cur_date`, `cur_month`, `cur_year`, `cur_time`) VALUES (4, '', '3', '139.64.8.55', '1', '50000', '', '', '', 'Saudi Arabia', '', '10', 'May', '2022', '01:00:39'); -- -------------------------------------------------------- -- -- 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=35; -- -- 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=5; -- -- AUTO_INCREMENT for table `categorytb` -- ALTER TABLE `categorytb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `more_advert_imagestb` -- ALTER TABLE `more_advert_imagestb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; -- -- 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=5; -- -- 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 */;