-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Nov 06, 2023 at 12:47 PM -- Server version: 8.0.35 -- PHP Version: 8.1.16 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: `akihvfyj_fastlundry` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int NOT NULL, `username` longtext NOT NULL, `password` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `username`, `password`) VALUES (1, 'admin', 'admin@123'); -- -------------------------------------------------------- -- -- Table structure for table `banner` -- CREATE TABLE `banner` ( `id` int NOT NULL, `img` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `banner` -- -- -------------------------------------------------------- -- -- Table structure for table `payout_setting` -- CREATE TABLE `payout_setting` ( `id` int NOT NULL, `owner_id` int NOT NULL, `amt` int NOT NULL, `status` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `proof` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `r_date` datetime NOT NULL, `r_type` enum('UPI','BANK Transfer','Paypal') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `acc_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `bank_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `acc_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ifsc_code` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `upi_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `paypal_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `service_details` -- CREATE TABLE `service_details` ( `id` int NOT NULL, `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `rimg` text NOT NULL, `status` int NOT NULL, `rate` float NOT NULL, `slogan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lcode` text, `catid` text NOT NULL, `full_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `pincode` text NOT NULL, `landmark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lats` text NOT NULL, `longs` text NOT NULL, `store_charge` float NOT NULL, `dcharge` float DEFAULT NULL, `morder` int NOT NULL, `commission` float NOT NULL, `bank_name` text NOT NULL, `ifsc` text NOT NULL, `receipt_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `acc_number` text NOT NULL, `paypal_id` text NOT NULL, `upi_id` text NOT NULL, `email` text NOT NULL, `password` text NOT NULL, `rstatus` int NOT NULL DEFAULT '1', `mobile` text NOT NULL, `sdesc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `charge_type` int NOT NULL, `ukm` int DEFAULT NULL, `uprice` int DEFAULT NULL, `aprice` int DEFAULT NULL, `zone_id` int NOT NULL, `cover_img` text NOT NULL, `slogan_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `cdesc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `opentime` time NOT NULL, `closetime` time NOT NULL, `cancle_policy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `service_details` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_address` -- CREATE TABLE `tbl_address` ( `id` int NOT NULL, `uid` int NOT NULL, `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `landmark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `r_instruction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `a_type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `a_lat` text NOT NULL, `a_long` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_address` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_cash` -- CREATE TABLE `tbl_cash` ( `id` int NOT NULL, `rid` int NOT NULL, `amt` float NOT NULL, `message` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `pdate` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tbl_category` -- CREATE TABLE `tbl_category` ( `id` int NOT NULL, `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `img` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `status` int NOT NULL, `cover` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_category` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_coupon` -- CREATE TABLE `tbl_coupon` ( `id` int NOT NULL, `store_id` int NOT NULL, `coupon_img` text NOT NULL, `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `coupon_code` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `subtitle` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `expire_date` date NOT NULL, `min_amt` float NOT NULL, `coupon_val` float NOT NULL, `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `status` int NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_coupon` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_data_required` -- CREATE TABLE `tbl_data_required` ( `id` int NOT NULL, `data` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `tbl_data_required` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_faq` -- CREATE TABLE `tbl_faq` ( `id` int NOT NULL, `store_id` int NOT NULL, `question` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `answer` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `status` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_faq` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_fav` -- CREATE TABLE `tbl_fav` ( `id` int NOT NULL, `uid` int NOT NULL, `store_id` int NOT NULL, `zone_id` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_fav` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_mcat` -- CREATE TABLE `tbl_mcat` ( `id` int NOT NULL, `store_id` int NOT NULL, `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `status` int NOT NULL, `img` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_mcat` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_normal_order` -- CREATE TABLE `tbl_normal_order` ( `id` int NOT NULL, `store_id` int NOT NULL, `uid` int NOT NULL, `odate` date NOT NULL, `p_method_id` int NOT NULL, `address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `landmark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci, `d_charge` float NOT NULL, `cou_id` float NOT NULL, `cou_amt` float NOT NULL, `o_total` float NOT NULL, `subtotal` float NOT NULL, `trans_id` text, `a_note` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci, `a_status` int NOT NULL DEFAULT '0', `rid` int NOT NULL DEFAULT '0', `wall_amt` float NOT NULL, `name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `mobile` double NOT NULL, `status` enum('Pending','Processing','Completed','Cancelled','On Route') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `comment_reject` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci, `tslot` text NOT NULL, `is_rate` int NOT NULL DEFAULT '0', `review_date` date DEFAULT NULL, `total_rate` int NOT NULL DEFAULT '0', `rate_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `commission` int NOT NULL DEFAULT '0', `store_charge` float NOT NULL, `order_status` int NOT NULL DEFAULT '0', `sign` text, `dslot` text NOT NULL, `pick_date` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_normal_order` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_normal_order_product` -- CREATE TABLE `tbl_normal_order_product` ( `id` int NOT NULL, `oid` int NOT NULL, `pquantity` int NOT NULL, `ptitle` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `pdiscount` int NOT NULL, `pimg` text NOT NULL, `pprice` int NOT NULL, `ptype` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_normal_order_product` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_notification` -- CREATE TABLE `tbl_notification` ( `id` int NOT NULL, `uid` int NOT NULL, `datetime` datetime NOT NULL, `title` text NOT NULL, `description` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_notification` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_page` -- CREATE TABLE `tbl_page` ( `id` int NOT NULL, `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `status` int NOT NULL, `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_page` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_payment_list` -- CREATE TABLE `tbl_payment_list` ( `id` int NOT NULL, `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `img` text NOT NULL, `attributes` text NOT NULL, `status` int NOT NULL DEFAULT '1', `subtitle` text NOT NULL, `p_show` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_payment_list` -- INSERT INTO `tbl_payment_list` (`id`, `title`, `img`, `attributes`, `status`, `subtitle`, `p_show`) VALUES (1, 'Paypal', 'images/payment/1663146734.png', 'Client_id,Secret_Key,0', 1, 'Credit/Debit card with Easier way to pay – online and on your mobile.', 1), (2, 'Stripe', 'images/payment/1663146748.png', 'pk_key,sk_key', 1, 'Accept all major debit and credit cards from customers in every country', 1), (3, 'Wallet', 'assets/category/catimg/1604897167.png', '-', 0, 'For Wallet Use Only', 0), (4, 'Razorpay', 'images/payment/1665207685.png', 'rzp_key', 1, 'Card, UPI, Net banking, Wallet(Phone Pe, Amazon Pay, Freecharge)', 1), (5, 'Cash On Delivery', 'images/payment/1669368349.png', '-', 1, 'Cash on Delivery', 0), (6, 'Paytm', 'images/payment/1670319015.png', 'MID,MKEY,TEST', 1, 'Credit/Debit card,net banking,Paytm wallet', 1), (7, 'Flutterwave', 'images/payment/1670319098.png', 'FLWSECK_KEY', 1, 'Card, pay with USSD, pay with bank, pay with barter', 1), (9, 'Paystack', '', 'pk_key,sk_key', 1, 'Credit/Debit card with an Easier way to pay – online and on your mobile.', 1); -- -------------------------------------------------------- -- -- Table structure for table `tbl_photo` -- CREATE TABLE `tbl_photo` ( `id` int NOT NULL, `store_id` int NOT NULL, `img` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `status` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_photo` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_product` -- CREATE TABLE `tbl_product` ( `id` int NOT NULL, `store_id` int NOT NULL, `cat_id` int NOT NULL, `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `img` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `status` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_product` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_product_attribute` -- CREATE TABLE `tbl_product_attribute` ( `id` int NOT NULL, `store_id` int NOT NULL, `product_id` int NOT NULL, `normal_price` float NOT NULL, `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `discount` float NOT NULL, `out_of_stock` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_product_attribute` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_rider` -- CREATE TABLE `tbl_rider` ( `id` int NOT NULL, `store_id` int NOT NULL, `img` text NOT NULL, `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `email` text NOT NULL, `ccode` text NOT NULL, `mobile` text NOT NULL, `password` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `rdate` date NOT NULL, `status` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_rider` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_rnoti` -- CREATE TABLE `tbl_rnoti` ( `id` int NOT NULL, `rid` int NOT NULL, `msg` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `date` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_rnoti` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_setting` -- CREATE TABLE `tbl_setting` ( `id` int(11) NOT NULL, `webname` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `weblogo` text NOT NULL, `timezone` text NOT NULL, `currency` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `pstore` int(11) NOT NULL, `one_key` text NOT NULL, `one_hash` text NOT NULL, `d_key` text NOT NULL, `d_hash` text NOT NULL, `s_key` text NOT NULL, `s_hash` text NOT NULL, `scredit` int(11) NOT NULL, `rcredit` int(11) NOT NULL, `show_dark` int(11) NOT NULL, `google_key` text NOT NULL, `sms_type` text NOT NULL, `auth_key` text NOT NULL, `otp_id` text NOT NULL, `acc_id` text NOT NULL, `auth_token` text NOT NULL, `twilio_number` text NOT NULL, `otp_auth` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `tbl_setting` -- INSERT INTO `tbl_setting` (`id`, `webname`, `weblogo`, `timezone`, `currency`, `pstore`, `one_key`, `one_hash`, `d_key`, `d_hash`, `s_key`, `s_hash`, `scredit`, `rcredit`, `show_dark`, `google_key`, `sms_type`, `auth_key`, `otp_id`, `acc_id`, `auth_token`, `twilio_number`, `otp_auth`) VALUES (1, 'FastLaundry 1.0', 'path', 'Asia/Kolkata', '$', 50, 'key', 'hash', 'key', 'hash', 'key', 'hash', 10, 50, 0, 'google_key','msg91','****','****','****','****','****','No'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_snoti` -- CREATE TABLE `tbl_snoti` ( `id` int NOT NULL, `sid` int NOT NULL, `datetime` datetime NOT NULL, `title` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_snoti` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_time` -- CREATE TABLE `tbl_time` ( `id` int NOT NULL, `store_id` int NOT NULL, `mintime` time NOT NULL, `maxtime` time NOT NULL, `status` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_time` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_user` -- CREATE TABLE `tbl_user` ( `id` int NOT NULL, `name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `email` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `ccode` text NOT NULL, `mobile` text NOT NULL, `refercode` int NOT NULL, `parentcode` int DEFAULT NULL, `password` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `registartion_date` datetime NOT NULL, `status` int NOT NULL DEFAULT '1', `wallet` float NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_user` -- -- -------------------------------------------------------- -- -- Table structure for table `wallet_report` -- CREATE TABLE `wallet_report` ( `id` int NOT NULL, `uid` int NOT NULL, `message` text NOT NULL, `status` text NOT NULL, `amt` int NOT NULL, `tdate` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `wallet_report` -- -- -------------------------------------------------------- -- -- Table structure for table `zones` -- CREATE TABLE `zones` ( `id` int NOT NULL, `title` text NOT NULL, `status` int NOT NULL, `coordinates` polygon NOT NULL, `alias` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `zones` -- -- -- Indexes for dumped tables -- -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `banner` -- ALTER TABLE `banner` ADD PRIMARY KEY (`id`); -- -- Indexes for table `payout_setting` -- ALTER TABLE `payout_setting` ADD PRIMARY KEY (`id`); -- -- Indexes for table `service_details` -- ALTER TABLE `service_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_address` -- ALTER TABLE `tbl_address` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_cash` -- ALTER TABLE `tbl_cash` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_category` -- ALTER TABLE `tbl_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_coupon` -- ALTER TABLE `tbl_coupon` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_data_required` -- ALTER TABLE `tbl_data_required` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_faq` -- ALTER TABLE `tbl_faq` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_fav` -- ALTER TABLE `tbl_fav` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_mcat` -- ALTER TABLE `tbl_mcat` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_normal_order` -- ALTER TABLE `tbl_normal_order` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_normal_order_product` -- ALTER TABLE `tbl_normal_order_product` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_notification` -- ALTER TABLE `tbl_notification` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_page` -- ALTER TABLE `tbl_page` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_payment_list` -- ALTER TABLE `tbl_payment_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_photo` -- ALTER TABLE `tbl_photo` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_product` -- ALTER TABLE `tbl_product` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_product_attribute` -- ALTER TABLE `tbl_product_attribute` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_rider` -- ALTER TABLE `tbl_rider` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_rnoti` -- ALTER TABLE `tbl_rnoti` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_setting` -- ALTER TABLE `tbl_setting` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_snoti` -- ALTER TABLE `tbl_snoti` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_time` -- ALTER TABLE `tbl_time` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_user` -- ALTER TABLE `tbl_user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wallet_report` -- ALTER TABLE `wallet_report` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zones` -- ALTER TABLE `zones` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `banner` -- ALTER TABLE `banner` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `payout_setting` -- ALTER TABLE `payout_setting` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `service_details` -- ALTER TABLE `service_details` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_address` -- ALTER TABLE `tbl_address` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_cash` -- ALTER TABLE `tbl_cash` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_category` -- ALTER TABLE `tbl_category` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_coupon` -- ALTER TABLE `tbl_coupon` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_data_required` -- ALTER TABLE `tbl_data_required` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tbl_faq` -- ALTER TABLE `tbl_faq` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_fav` -- ALTER TABLE `tbl_fav` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_mcat` -- ALTER TABLE `tbl_mcat` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_normal_order` -- ALTER TABLE `tbl_normal_order` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_normal_order_product` -- ALTER TABLE `tbl_normal_order_product` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_notification` -- ALTER TABLE `tbl_notification` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_page` -- ALTER TABLE `tbl_page` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_payment_list` -- ALTER TABLE `tbl_payment_list` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `tbl_photo` -- ALTER TABLE `tbl_photo` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_product` -- ALTER TABLE `tbl_product` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_product_attribute` -- ALTER TABLE `tbl_product_attribute` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_rider` -- ALTER TABLE `tbl_rider` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_rnoti` -- ALTER TABLE `tbl_rnoti` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_setting` -- ALTER TABLE `tbl_setting` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tbl_snoti` -- ALTER TABLE `tbl_snoti` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_time` -- ALTER TABLE `tbl_time` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_user` -- ALTER TABLE `tbl_user` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wallet_report` -- ALTER TABLE `wallet_report` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zones` -- ALTER TABLE `zones` MODIFY `id` int NOT NULL AUTO_INCREMENT; 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 */;