-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Oct 21, 2024 at 10:53 AM -- Server version: 10.4.32-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: `main_database` -- -- -------------------------------------------------------- -- -- Table structure for table `auctions` -- CREATE TABLE `auctions` ( `user_id` int(11) NOT NULL, `user_role` int(11) NOT NULL, `id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `property_name` varchar(255) NOT NULL, `auction_id` varchar(255) NOT NULL, `property_area` varchar(255) NOT NULL, `property_category` varchar(255) NOT NULL, `property_location` varchar(255) NOT NULL, `property_address` varchar(255) NOT NULL, `property_city` varchar(255) NOT NULL, `property_description` varchar(300) NOT NULL, `auction_start_date` datetime NOT NULL, `auction_end_date` datetime NOT NULL, `inspection_date` datetime DEFAULT NULL, `live_auction_start_date` datetime NOT NULL, `live_auction_end_date` datetime NOT NULL, `emd` int(11) NOT NULL, `catalog` varchar(300) DEFAULT NULL, `starting_price` int(11) NOT NULL, `minimum_bid` int(11) NOT NULL, `bid_increment` int(11) NOT NULL, `terms_conditions` text NOT NULL, `is_featured` tinyint(1) NOT NULL DEFAULT 0, `auction_status` enum('active','closed') NOT NULL DEFAULT 'active', `contact_name` varchar(255) NOT NULL, `contact_no` varchar(12) NOT NULL, `inspection_address` varchar(300) DEFAULT NULL, `image_upload_1` varchar(255) DEFAULT NULL, `image_upload_2` varchar(255) DEFAULT NULL, `image_upload_3` varchar(255) DEFAULT NULL, `image_upload_4` varchar(255) DEFAULT NULL, `status` enum('pending','approved','denied') NOT NULL DEFAULT 'pending', `auctions_status` enum('upcoming','live','ended') NOT NULL DEFAULT 'upcoming', `seller_id` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `auctions` -- INSERT INTO `auctions` (`user_id`, `user_role`, `id`, `title`, `property_name`, `auction_id`, `property_area`, `property_category`, `property_location`, `property_address`, `property_city`, `property_description`, `auction_start_date`, `auction_end_date`, `inspection_date`, `live_auction_start_date`, `live_auction_end_date`, `emd`, `catalog`, `starting_price`, `minimum_bid`, `bid_increment`, `terms_conditions`, `is_featured`, `auction_status`, `contact_name`, `contact_no`, `inspection_address`, `image_upload_1`, `image_upload_2`, `image_upload_3`, `image_upload_4`, `status`, `auctions_status`, `seller_id`, `created_at`, `updated_at`) VALUES (0, 0, 4, 'sd', 'dsa', 'da', 'asd', 'ds', 'da', 'sa', 'sa', 'sa', '2024-08-03 19:37:00', '2024-08-02 19:37:00', '2024-08-02 19:37:00', '2024-08-03 20:38:00', '2024-08-11 18:36:00', 110, 'Charalambous, Demetris.pdf', 5, 55, 5, 'jk', 0, '', '325688', '5464', '313m;lk', 'cpacases-1280x720.jpg', 'consumer-rights-13-638.jpg', 'cpacases-1280x720.jpg', 'cpacases-1280x720.jpg', 'approved', 'upcoming', 0, '2024-08-02 13:43:50', '2024-08-05 01:58:43'), (0, 0, 5, 'df', 'dsf', 'dsf', 'd', 'fd', 'fd', 'fd', 'df', 'fddfsfsd', '2024-08-03 20:44:00', '2024-08-03 20:44:00', '2024-08-02 21:45:00', '2024-08-03 21:45:00', '2024-08-02 21:46:00', 10, '1815949032 Rishabh Shrivastava.pdf', 1, 1, 1, 'sdds', 0, '', 'ss', '654654', '465464', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'approved', 'upcoming', 0, '2024-08-02 14:14:58', '2024-09-02 14:25:54'), (0, 0, 26, 'asd', 'asd', 'saa', 'sd', 'sa', 'as', 'sad', 'sda', 'sad', '2024-08-03 07:05:00', '2024-08-04 06:06:00', '2024-08-03 08:06:00', '2024-08-03 07:05:00', '2024-08-03 08:07:00', 100, '1815949032 Rishabh Shrivastava.pdf', 5, 5, 1, 'sdzfxghj', 0, '', '566416', '3515615616', '55145', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'approved', 'upcoming', 0, '2024-08-03 00:36:47', '2024-09-02 14:25:54'), (0, 0, 64, 'property', '2 bhk', '121', '458Sq feet', '2 BHK', '355 indore', '355 indore', 'indore', '2indore', '2024-08-03 12:55:00', '2024-08-03 12:55:00', '2024-08-03 12:55:00', '2024-08-03 11:54:00', '2024-08-03 11:54:00', 100, '1815949032 Rishabh Shrivastava.pdf', 5, 1, 1, 'no', 1, '', '988888888', '9*88888', '11641', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'approved', 'upcoming', 0, '2024-08-03 05:24:47', '2024-09-02 14:25:54'), (3, 0, 68, 'dssdf', 'hkj', 'hjk', 'hkh', 'kjh', 'hjk', 'hkh', 'kh', 'hkh', '2024-08-04 11:40:00', '2024-08-04 12:42:00', '2024-08-04 10:40:00', '2024-08-04 10:40:00', '2024-08-04 09:39:00', 10, '1815949032 Rishabh Shrivastava.pdf', 10, 1, 1, '1', 0, '', '132sd', '121', '122121', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'approved', 'upcoming', 0, '2024-08-04 03:09:31', '2024-09-02 14:25:54'), (3, 0, 70, '11111', '111', '111', '11', '11', '1111', '1111', '11111', '11111', '2024-08-04 09:51:00', '2024-08-04 09:51:00', '2024-08-04 09:51:00', '2024-08-04 09:52:00', '2024-08-04 09:52:00', 10, '1815949032 Rishabh Shrivastava.pdf', 11, 1, 1, '11', 0, '', '1', '1', '11', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'approved', 'upcoming', 0, '2024-08-04 03:29:09', '2024-09-02 14:25:54'), (3, 0, 72, '11111', '111', '111', '11', '11', '1111', '1111', '11111', '11111', '2024-08-04 09:51:00', '2024-08-04 09:51:00', '2024-08-04 09:51:00', '2024-08-04 09:52:00', '2024-08-04 09:52:00', 10, '1815949032 Rishabh Shrivastava.pdf', 11, 1, 1, '11', 0, '', '1', '1', '11', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'approved', 'upcoming', 0, '2024-08-04 03:52:22', '2024-09-02 14:25:54'), (3, 0, 88, '4', '6546', '4', '54', '65465', '4', '456', '464', '654', '0065-04-06 04:06:00', '0054-06-04 06:54:00', '0465-05-06 04:56:00', '0005-06-04 04:56:00', '0005-06-04 04:59:00', 4654, '1815949032 Rishabh Shrivastava.pdf', 654, 564, 65, '465', 0, '', '654', '654', '654', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'approved', 'upcoming', 0, '2024-08-04 07:50:52', '2024-09-02 14:25:54'), (3, 0, 89, '4', '6546', '4', '54', '65465', '4', '456', '464', '654', '0065-04-06 04:06:00', '0054-06-04 06:54:00', '0465-05-06 04:56:00', '0005-06-04 04:56:00', '0005-06-04 04:59:00', 4654, '1815949032 Rishabh Shrivastava.pdf', 654, 564, 65, '465', 0, '', '654', '654', '654', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'approved', 'upcoming', 0, '2024-08-04 20:53:28', '2024-09-02 14:25:54'), (3, 0, 92, '12', '11', '1', '1', '12', '2', '2', '2', '2', '2024-08-05 02:31:00', '2024-08-05 02:32:00', '2024-08-05 02:32:00', '2024-08-05 02:32:00', '2024-08-05 02:32:00', 12, '1815949032 Rishabh Shrivastava.pdf', 1, 1, 1, '1', 0, '', '3', '5', '21', 'image1.jpg', 'image1.jpg', 'image1.jpg', 'image1.jpg', '', 'upcoming', 0, '2024-08-04 21:00:53', '2024-09-02 14:25:54'), (27, 0, 96, 'VDSVDF', 'VFDVD', 'DF', 'FVFDVFD', 'VFDVDFVD', 'VDV', 'DVDFVDFV', 'DVDVD', 'FVDFVDFV', '2024-08-09 17:23:00', '2024-08-09 17:23:00', '0000-00-00 00:00:00', '2024-08-09 16:22:00', '2024-08-09 16:23:00', 9, '', 0, 0, 0, '0', 0, '', 'FGDF', 'FDGFD', 'GDFGDF', '', '', '', '', 'approved', 'upcoming', 0, '2024-08-09 10:53:24', '2024-09-02 23:07:06'), (27, 0, 97, 'fdgf', 'fdsfds', 'k', 'kl', '`kljjkll', 'lk', 'jl', 'klkj', 'dsfsdgdsf', '2024-08-13 02:26:00', '2024-08-13 02:25:00', '2024-08-13 02:25:00', '2024-08-13 02:25:00', '2024-08-13 02:26:00', 100, '1815949032 Rishabh Shrivastava.pdf', 100, 100, 100, '100', 0, '', '0', '0', '54', 'image1.jpg', '', '', '', 'approved', 'upcoming', 0, '2024-08-12 20:56:45', '2024-09-02 23:07:10'), (27, 0, 98, 'rishbah', 'gfd', 'dfghfd', 'gfd', 'gfd', 'gf', 'dfg', 'gf', 'gfdh', '2024-08-13 02:27:00', '2024-08-13 02:27:00', '2024-08-13 02:32:00', '2024-08-13 02:32:00', '2024-08-13 02:32:00', 100, '1815949032 Rishabh Shrivastava.pdf', 100, 10, 1, '1', 0, '', '1', '1', '1', 'image1.jpg', '', '', '', 'approved', 'upcoming', 0, '2024-08-12 21:03:06', '2024-09-05 23:43:15'), (27, 0, 99, 'rishabbh1', 'kjfldasj', 'lkdjsalj', 'jldksaj', 'jkfldsja', 'jklsdjl', 'kfjsdkl', 'fjkslajl', 'fslkjl', '2024-08-13 11:46:00', '2024-08-13 11:46:00', '2024-08-13 11:46:00', '2024-08-13 11:46:00', '2024-08-13 11:46:00', 10, '1815949032 Rishabh Shrivastava.pdf', 10, 10, 10, '10', 0, '', '01', '11', '1o', 'image1.jpg', '', '', '', 'pending', 'upcoming', 0, '2024-08-13 06:16:42', '2024-09-02 14:25:54'), (27, 0, 101, 'uyg', 'ihiu', 'ihi', 'jhjjhnjk', 'jjkk', 'knjk', 'knlk', 'lklk', 'kojkj', '2024-08-13 12:15:00', '2024-08-13 12:15:00', '2024-08-13 12:15:00', '2024-08-13 12:15:00', '2024-08-13 12:15:00', 10, '', 10, 3, 5, '0', 0, '', '54', '5', '5', '', '', '', '', 'pending', 'upcoming', 0, '2024-08-13 06:46:20', '2024-09-02 14:25:54'), (27, 0, 102, 'fgj', 'er', 'erw', 'ewr', 'r', 're', 'erw', 'ererw', 're', '2024-08-13 12:25:00', '2024-08-13 12:25:00', '2024-08-13 12:25:00', '2024-08-13 12:25:00', '2024-08-13 12:25:00', 0, 'image1.jpg', 2, 2, 2, '0', 0, '', '53', '563', '535', 'image1.jpg', '', '', '', 'pending', 'upcoming', 0, '2024-08-13 06:56:09', '2024-09-02 14:25:54'), (27, 0, 103, '1111', 'rishabhhhhhhh', 'gdgdoiufhasjdffhjksfhjklask', 'cvxvdjhafsjfhjkadshi', 'jghjghjgdhghjasfhjhdjashjklh', 'vxdfjhadsjhjkl', 'vdsafasdfsadfdsf', 'vfdfsafashjgadjskhjkdash', 'vxfdoashdfkajdhjkhfajkhf', '2024-08-15 12:29:00', '2024-08-15 12:29:00', '2024-08-15 12:29:00', '2024-08-15 12:29:00', '2024-08-15 12:29:00', 2147483647, '', 154654564, 1654654654, 1509, '6654654kjkjo', 0, '', '56465456465', '265465464', '55656456', '', '', '', '', 'pending', 'upcoming', 123, '2024-08-13 06:59:55', '2024-09-02 14:25:54'), (27, 0, 104, 'wrwe', 'rrrr', '123', '11', 'hjk', 'hjh', 'jh', 'jh', 'jkh', '2024-08-16 06:00:00', '2024-08-16 06:01:00', '2024-08-16 06:01:00', '2024-08-16 06:01:00', '2024-08-16 06:01:00', 232, '', 232, 2, 2, '23', 0, '', '21132312', '21312', '12321', '', '', '', '', 'approved', 'upcoming', 123, '2024-08-16 00:31:40', '2024-09-02 16:09:28'), (26, 0, 105, 'main property', 'villa house', '12345', '4287sq', 'row-house', 'vijay nagar', '48 vijay nagr', 'indore', 'this is the best villa for sale ', '2024-08-17 10:00:00', '2024-08-24 18:30:00', '2024-08-20 17:21:00', '2024-08-24 08:21:00', '2024-08-24 17:22:00', 500000, '1815949032 Rishabh Shrivastava.pdf', 2000000, 2100, 100, '0', 0, '', 'rishabh', '8777777777', '48 vijay nagar', 'image1.jpg', 'image2.jpg', 'cpacases-1280x720.jpg', 'images.jpg', 'approved', 'upcoming', 0, '2024-08-17 11:54:14', '2024-09-02 14:25:54'), (27, 0, 107, 'AuctionTest', 'Auciton', '12345', '2888', 'row-house', 'viajanagar', 'viajayar', 'indore', 'the row house for sales', '2024-09-10 16:31:00', '2024-09-19 16:31:00', '2024-09-18 16:31:00', '2024-09-10 16:36:00', '2024-09-15 16:31:00', 1000, '2e21313d-c690-4ec1-a561-fa1acd4b3698RISHI.docx', 5000, 1, 1, '0', 0, 'active', 'Rishabh ', '8770163254', 'klfhih', 'cpacases-1280x720.jpg', '', '', '', 'pending', 'upcoming', 0, '2024-09-10 11:02:40', '2024-09-10 11:02:40'), (0, 0, 108, 'Rishabh', '', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '2024-10-04 07:26:00', '2024-10-04 09:26:00', 100, NULL, 1000, 5, 5, 'kuch nhi', 0, 'active', 'rish', '897987979', NULL, 'kk.jpg', 'kk.jpg', NULL, NULL, 'pending', 'upcoming', 0, '2024-10-04 01:56:35', '2024-10-04 01:56:35'), (0, 0, 109, 'rishbTEST', '', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '2024-10-04 19:25:00', '2024-10-04 21:25:00', 10000, NULL, 1000, 0, 0, '', 0, 'active', '', '', NULL, NULL, NULL, NULL, NULL, 'pending', 'upcoming', 0, '2024-10-04 13:56:23', '2024-10-04 13:56:23'); -- -------------------------------------------------------- -- -- Table structure for table `authorized_users` -- CREATE TABLE `authorized_users` ( `id` int(11) NOT NULL, `auction_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `authorized_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `authorized_users` -- INSERT INTO `authorized_users` (`id`, `auction_id`, `user_id`, `authorized_at`) VALUES (1, 4, 0, '2024-10-04 07:28:10'), (2, 0, 0, '2024-10-04 07:28:16'), (3, 0, 0, '2024-10-04 07:28:21'), (4, 0, 0, '2024-10-04 07:30:10'), (5, 109, 1, '2024-10-04 19:26:23'), (6, 109, 3, '2024-10-04 19:26:23'), (7, 109, 4, '2024-10-04 19:26:23'), (8, 109, 6, '2024-10-04 19:26:23'), (9, 109, 7, '2024-10-04 19:26:23'), (10, 109, 26, '2024-10-04 19:26:23'), (11, 109, 27, '2024-10-04 19:26:23'), (12, 109, 28, '2024-10-04 19:26:23'), (13, 109, 29, '2024-10-04 19:26:23'), (14, 109, 31, '2024-10-04 19:26:23'), (15, 109, 32, '2024-10-04 19:26:23'); -- -------------------------------------------------------- -- -- Table structure for table `bidder_approvals` -- CREATE TABLE `bidder_approvals` ( `id` int(11) NOT NULL, `bidder_id` int(11) NOT NULL, `auction_id` int(11) NOT NULL, `is_approved` tinyint(1) NOT NULL DEFAULT 0, `approved_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `bidder_requests` -- CREATE TABLE `bidder_requests` ( `id` int(11) NOT NULL, `auction_id` int(11) NOT NULL, `bidder_id` int(11) NOT NULL, `emd_paid` int(11) NOT NULL, `request_status` int(11) NOT NULL DEFAULT 0, `requested_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `bidder_requests` -- INSERT INTO `bidder_requests` (`id`, `auction_id`, `bidder_id`, `emd_paid`, `request_status`, `requested_at`) VALUES (1, 1, 2, 10000, 0, '2024-09-10 10:37:30'), (2, 1, 2, 1000, 0, '2024-09-10 10:45:19'), (3, 107, 1, 1000, 0, '2024-09-10 11:04:56'), (4, 1, 2, 10000, 0, '2024-09-13 11:32:56'), (5, 1, 2, 10000, 0, '2024-09-16 21:09:04'), (6, 1, 2, 10, 0, '2024-09-16 21:10:33'), (7, 1, 2, 77, 0, '2024-09-16 21:33:52'); -- -------------------------------------------------------- -- -- Table structure for table `bids` -- CREATE TABLE `bids` ( `id` int(11) NOT NULL, `auction_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `bid_amount` int(11) NOT NULL, `bid_time` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `bid_requests` -- CREATE TABLE `bid_requests` ( `request_id` int(11) NOT NULL, `auction_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `status` varchar(10) NOT NULL DEFAULT 'pending', `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `contacts` -- CREATE TABLE `contacts` ( `phone` int(15) NOT NULL, `id` int(11) NOT NULL, `name` varchar(300) NOT NULL, `email` varchar(300) NOT NULL, `message` text NOT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `contacts` -- INSERT INTO `contacts` (`phone`, `id`, `name`, `email`, `message`, `timestamp`) VALUES (88888888, 47, 'test1', 'ED@DHKJA', 'DSFDFS', '2024-06-06 00:31:02'), (88888888, 48, 'test1', 'ED@DHKJA', 'DSFDFS', '2024-06-06 00:31:06'), (88888888, 49, 'test1', 'ED@DHKJA', 'DSFDFS', '2024-06-06 00:31:08'), (88888888, 50, 'test1', 'ED@DHKJA', 'DSFDFS', '2024-06-06 00:31:09'), (88888888, 51, 'test1', 'ED@DHKJA', 'DSFDFS', '2024-06-06 00:31:09'), (88888888, 52, 'test1', 'ED@DHKJA', 'DSFDFS', '2024-06-06 00:31:10'), (88888888, 53, 'test1', 'ED@DHKJA', 'DSFDFS', '2024-06-06 00:31:10'), (464646, 54, 'EST22', '454@gmail', 'DOPJFLD', '2024-06-06 00:31:26'), (2147483647, 55, 'rshri', 'r@gmail.com', 'DDFVD', '2024-06-06 00:33:01'), (982111111, 56, 'akljrlkew', 'rishabh@gmail.com', 'BK', '2024-06-06 00:35:17'), (0, 57, 'akljrlkew', 'rishabh@gmail.com', 'jhhhh', '2024-06-06 01:09:53'), (982111111, 58, 'rshri', 'f@gmail.com', 'hjhjh', '2024-06-06 08:22:45'), (982111111, 59, 'akljrlkew', 'test@www', 'hjj', '2024-06-06 08:36:15'), (5555555, 60, 'test', 'test@www', 'dgdg', '2024-06-06 08:36:53'), (9456464, 61, 'rshri`', 'kjf@fh', 'flishiufh', '2024-06-06 12:49:24'), (465, 62, 'bid', '464@hhiuh', 'jgj', '2024-06-06 17:33:35'), (2147483647, 63, 'Ayush', 'AyushShrivatava2205@gmail.com', 'hjvsdcvhasdhvhjvsagvwgefiuogwui\r\n\r\n', '2024-06-19 01:26:31'), (2147483647, 64, 'fhgfjhgk687696969', 'fdhfjhgj@dhfh', 'fjgjhgkj', '2024-10-17 17:45:23'), (2147483647, 65, 'fhgfjhgk687696969', 'fdhfjhgj@dhfh', 'fjgjhgkj', '2024-10-17 17:45:26'), (2147483647, 66, 'fhgfjhgk687696969', 'fdhfjhgj@dhfh', 'fjgjhgkj', '2024-10-17 17:45:31'), (2147483647, 67, 'fhgfjhgk687696969', 'fdhfjhgj@dhfh', 'fjgjhgkj', '2024-10-17 17:45:31'), (2147483647, 68, 'fhgfjhgk687696969', 'fdhfjhgj@dhfh', 'fjgjhgkj', '2024-10-17 17:45:41'); -- -------------------------------------------------------- -- -- Table structure for table `events` -- CREATE TABLE `events` ( `id` int(11) NOT NULL, `type` enum('disposal','procurement','upcoming') NOT NULL, `company_name` varchar(300) NOT NULL, `description` text NOT NULL, `event_datetime` datetime NOT NULL, `catalog_path` varchar(300) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `events` -- INSERT INTO `events` (`id`, `type`, `company_name`, `description`, `event_datetime`, `catalog_path`, `created_at`) VALUES (1, 'disposal', 'RishabhS', 'we are upload next auction document', '2024-07-20 14:51:00', 'uploads/6694bf2f262a04.38131693.pdf', '2024-07-15 06:18:23'), (15, 'disposal', 'njknkjn', 'heihoiahefjhopiwajho', '2024-08-01 05:57:00', 'uploads/Charalambous, Demetris.pdf', '2024-07-21 21:25:17'), (16, 'disposal', 'ljdojgls', 'srelkotlaeekjso', '2024-07-25 00:52:00', 'uploads/01 Activity Guide (1).pdf', '2024-07-24 15:18:25'), (17, 'disposal', 'hgfhfgdfdjfg', 'fdhl;dkjoesjojslekjlkgjslkjhlajlkjljlkjlksjlfjfaijh hie mmam annenanlaj', '2024-07-25 23:52:00', 'uploads/Active One (1).pdf', '2024-07-24 15:19:18'), (18, 'procurement', 'hkhkhjkh', 'l;lklfkdgksl;k', '2024-07-04 22:51:00', 'uploads/57141029_DPSTMT~000099999_20240430.pdf', '2024-07-24 15:20:11'), (19, 'upcoming', 'kldlksl', 'dmglskl hi anmm aijoijaoijoijgo hi am rishbh shrivastava could you please valide jldjsfjlsdjglsjlgjsegljskljksj', '2024-07-24 23:53:00', 'uploads/Foundation _9.0.pdf', '2024-07-24 15:21:12'), (20, 'upcoming', ';lmlml', ',m,m,m.,m', '2024-07-17 23:54:00', 'uploads/57141029_DPSTMT~000099999_20240430.pdf', '2024-07-24 15:22:17'), (21, 'procurement', 'fhdkjs', 'fsdkjfk', '2024-10-03 12:38:00', 'uploads/AP_123343_2024-10-01_chk_00010050.pdf', '2024-10-03 18:09:03'); -- -------------------------------------------------------- -- -- Table structure for table `faq_questions` -- CREATE TABLE `faq_questions` ( `id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `question` text NOT NULL, `answer` text NOT NULL, `description` text NOT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `feedback` -- CREATE TABLE `feedback` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `message` text NOT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `feedback` -- INSERT INTO `feedback` (`id`, `name`, `email`, `message`, `timestamp`) VALUES (1, 'gjfhfhjgkjh', 'rishabh.shrivastava1996@gmail.com', '', '2024-06-06 00:58:55'), (2, 'gjfhfhjgkjh', 'rishabh.shrivastava1996@gmail.com', '', '2024-06-06 01:02:08'), (3, 'rshri', 'r@gmail.com', 'jb', '2024-06-06 08:18:51'), (4, 'rshri', 'rishabh@gmail.com', 'jkbjk', '2024-06-06 08:27:42'), (5, 'test666', 'ee@test666', 'rtyuio', '2024-06-06 08:35:36'); -- -------------------------------------------------------- -- -- Table structure for table `messages` -- CREATE TABLE `messages` ( `id` int(11) NOT NULL, `user` varchar(300) NOT NULL, `message` text NOT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `messages` -- INSERT INTO `messages` (`id`, `user`, `message`, `timestamp`) VALUES (10, 'User', 'hello', '2024-06-02 11:13:27'), (11, 'User', 'hi', '2024-06-02 11:29:04'), (12, 'User', 'kese ho', '2024-06-02 11:29:16'), (13, 'User', 'keseseeeeeeee h', '2024-06-06 08:37:50'), (14, 'User', 'hi', '2024-06-06 12:49:48'), (15, 'User', 'naman', '2024-06-06 12:49:56'), (16, 'User', 'huh', '2024-08-01 17:34:43'), (17, 'User', 'hi', '2024-08-15 21:35:01'), (18, 'User', 'hi', '2024-08-15 21:37:55'), (19, 'User', 'hi', '2024-08-15 21:42:36'), (20, 'User', 'hi', '2024-08-15 21:42:42'), (21, 'User', 'hi', '2024-08-15 21:50:23'), (22, 'User', 'hi', '2024-08-15 21:50:32'), (23, 'User', 'hi', '2024-08-15 21:52:11'), (24, 'User', 'hi', '2024-08-15 21:52:36'), (25, 'User', 'hi', '2024-08-15 21:53:46'), (26, 'User', 'hi', '2024-08-15 21:55:18'), (27, 'User', 'hi', '2024-08-15 21:55:28'), (28, 'User', 'risss', '2024-08-15 21:55:32'), (29, 'User', 'gvhg', '2024-10-17 17:49:47'); -- -------------------------------------------------------- -- -- Table structure for table `newsletter_subscriptions` -- CREATE TABLE `newsletter_subscriptions` ( `id` int(11) NOT NULL, `email` varchar(255) NOT NULL, `subscribed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `newsletter_subscriptions` -- INSERT INTO `newsletter_subscriptions` (`id`, `email`, `subscribed_at`) VALUES (137, 'rishabh.shrivastava2712@gmail.com', '2024-07-14 21:34:17'), (140, 'hfhfg@gmail', '2024-08-01 17:18:43'), (141, 'rishabh25@gmail.com', '2024-08-09 10:48:48'), (142, 'rishabh25@gmail.com', '2024-08-09 10:48:48'); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `id` int(11) NOT NULL, `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `expires_at` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `password_resets` -- INSERT INTO `password_resets` (`id`, `email`, `token`, `expires_at`) VALUES (101, 'rishabh.shrivastava2712@gmail.com', '009657aea182c2aa57499af92694ed803a52dcc924c4bbf3f53e16a551b07a7c71a1ed1221f1ab04487b43653b84bca8c4a7', 1720230374), (141, 'rishabh.shrivastava2712@gmail.com', '04cbbae8f315ed985d65c8c4e56f0b16b2f912661f2c8b3ad629adff3930a638ec011b1e7c791bbdbb9cb2bb454fd9999b52', 1722026291), (136, 'rishabh.shrivastava2712@gmail.com', '084b4184182cd6850761a41abe55acc52f68c985705b4f3fdfc149f264e4e3f254d5c936817537454a14aebc77a51aeab395', 1722007431), (127, 'rishabh.shrivastava2712@gmail.com', '0dd265e0dde39fecbba875dd9ae554f55ed8f22ac7c59651278c5eff51de4efc9f6e9d7b57125aee9517676dee72c63d277a', 1721929062), (89, 'rishabh@gmail.com', '0e603588020bb55b2228599eca4bdc4b047957be0f38c2d27fd5abe8c263de7f8f226bc0b12b0d87259d3780cdc13edd3db7', 1719978104), (138, 'rishabh@gmail.com', '126661ea9f29558dab66ed868a5a415a89a75accc8bd896e1d450f0cacc42451627d22fb558fe22215eebc975340459a4753', 1722007444), (147, 'rishabh.shrivastava2712@gmail.com', '15226600f67cf1e4795af103f0b12c5b3395bf382dd2ec781e1c3489469bfbfd5aa5828e239902ee59d553235c0a999cfbcf', 1722136001), (145, 'rishabh.shrivastava2712@gmail.com', '174d7dda8bbf885044f7a20be713baad31e7064cd7a53e797623596c87608caf6475813aa7d2f43026934c992993112673c8', 1722036784), (150, 'rishabh@gmail.com', '1b53c1ff9d43b4edc45e2712a08a3b720c7fc8c81451fae07fe161cf0f96669314355cdece4a5bdaa659474cf232de5dac0d', 1726669809), (134, 'rishabh@gmail.com', '204f6a8cdafe6a25cc7125b59deb23eefe9aa16a35ae5e19a3210a10138ffc8a139363c28e15587454913ec302c7f971ea31', 1721931374), (130, 'rishabh.shrivastava2712@gmail.com', '206b66e678dfce5b36082064be606c52e6104eee34537c884d6fb2b36f2c5d028b96861a4b94457ad8a3d524212d62e19c12', 1721929439), (133, 'rishabh.shrivastava2712@gmail.com', '24b326f94f092752b264d0f935f1949b208776a4e3893225087d6b49009b0bb1e5d52882aa8ab1717c947d35cb3c2f1ba50a', 1721931299), (88, 'rishabh@gmail.com', '24ba09cecac6725213dd0f71061aadd9a212f0a791d8ee38cc1eff7da96c4d89d30fd9f41e44a6bf00199416b2ce77f2af01', 1719978103), (110, 'rishabh.shrivastava2712@gmail.com', '24c24e71d9e872f424f5e3ce58823fb485314cb89a46321ed8827ebf6fdb8ed9899642e5306c8250890b84dd8a198b79f753', 1720231158), (92, 'rishabh@gmail.com', '2e0650627cff09f173758c45ca3af34ee746b869865c8c00cbedb50e4e06b4c02eab23e350448e081ae3802667bd0c7850e9', 1719978112), (122, 'rishabh.shrivastava2712@gmail.com', '34248590702b056a6eee11c10f0e8e9e026fa633966e3015db3209b7661e37c8a3cb4deaa14cd7b2c0d7d13f252cb4dc41b3', 1721927750), (148, 'rishabh.shrivastava2712@gmail.com', '35676d26950446152b0481f7eecec203a453ebdd653ca4f72cf831befea76f1e7ebe19990b16f8a14e51d7cd67097428193b', 1722393790), (118, 'rishabh.shrivastava2712@gmail.com', '3e953bd5f9c909f99a1aab8423459e0bc2906d5e2694de98755aec65a07be2db2b50193dbb121b1a4d05d645c1018181b53b', 1720261288), (93, 'rishabh.shrivastava2712@gmail.com', '40a898c548f8625dad1dfbf5ac4b21fe8b986b97bbd94e7e24d42e6271a33f616fe03841fb12457eba5039dfd07c434ab854', 1719978128), (109, 'rishabh.shrivastava2712@gmail.com', '431ce356b1a6dfa7f6d216a34fe3205baf5070dc8e178c1cdfaa6d74ac6e6eb58952a44e048632813619aadb98fbaa5c3cf9', 1720231111), (96, 'rishabh.shrivastava2712@gmail.com', '4395ea8caf9a9869bbdaf779eefff7417830cc0e9156b7a020d2cb8beca98303513719c039688a071a611e0118df5caa1c23', 1720229136), (120, 'rishabh@gmail.com', '48056a9cfe5769d257ab40dd164aa7add41c4e88ccf553b35be5246d3ef3cba75d4f8f5f7dbe389cedbed774a8a187f5341a', 1721927487), (132, 'rishabh.shrivastava2712@gmail.com', '499adaa150038d5cfeb5d1b60113c435516f59193b494d5128f02c5b9a21a520136ab05199d1c0631c8e6bcc2f3103ecdb9b', 1721931237), (86, 'rishabh@gmail.com', '4d4107979cbd458752ee6ad69bdf596f5c88ce278ad6bbbcaf9be90931bcb3d323b5c02a8b9be4db534465be408927183500', 1719978102), (126, 'rishabh.shrivastava2712@gmail.com', '513ed659234ae1d4d65e2f58c34b1e532431093b62e84be072d4baf0a5b6865681a7ec5d6508661ece963dc6d40d5372796d', 1721929035), (125, 'rishabh.shrivastava2712@gmail.com', '54e766cfd939ac5df5eadf16050afd4f632fbad55887a6c5759418ff0e214ddc2677d1dfc5603fe50757a817188958eac955', 1721929005), (85, 'rishabh@gmail.com', '5a89ef0075316ff420d441162a392bf55d44e8c96b61a97962cf41914edd027f9643c1c0d555ad518c8dce2994e83b42126b', 1719978102), (139, 'rishabh.shrivastava2712@gmail.com', '5c799225601f0637f1309defd26e572494217eaef0eb86412f7235737847c6bf893fce07e261c908618e12118be9042eacbe', 1722007487), (151, 'rishabh@gmail.com', '5cd8c17c99173dfd661a4cdc85f56c7802da948f552e60e340878d97efc8f7ae0ef23055932c251ec687d10d7f94e5caf225', 1726669819), (112, 'rishabh.shrivastava2712@gmail.com', '5dbef416b8233b776b37f6dd82c7882bfd2955e111367edec4fe61bc79aeff42e1f6eafff3ddc44cada70a808f95ec9c4bed', 1720231622), (105, 'rishabh@gmail.com', '65d29842e11e993d5ef3665909f2f8629eedbba24e49139464962a67e1441922fbc8b382e0f0793126b7e27e1c6925eaeb67', 1720230799), (104, 'rishabh.shrivastava2712@gmail.com', '6730fbb5980bdcfa7d72f21033c59834c236320bfac9a8defa5c2dfbecc9979625d5312ed719d442eafa51812d194f679ff1', 1720230727), (131, 'rishabh.shrivastava2712@gmail.com', '6ad597fec9879589428b11243ad072fd51bb795364f4173f4ad807373b5f2f10828744416605e38c495b5a56d099c861cf43', 1721929509), (123, 'rishabh.shrivastava2712@gmail.com', '6e994611210a21c295a54a808ec4735c1278fe80e15e7d1cc119a6fcfe20a76280d463f3a33d67477f528c23bdfb84d28b82', 1721927926), (152, 'rishabh@gmail.com', '7166d560f0344b566bb3b668bd41e144ad747317d8dc1f660925ae6942b1cf266995c2918d9e4b973d5c3a7e223cd2277ec9', 1727022733), (144, 'rishabh@gmail.com', '74cdae14d0a0b803cc7364d82ec47f33779153b1cc3155ea22e0a21ec314c2c9e5d36d285e3e9656c49b6180b05cb28d8224', 1722028236), (106, 'rishabh.shrivastava2712@gmail.com', '75114b87c7eeefd05918d27366223315914342031b9f035a534b882bfb6ae58bc91f13db0775a7b85f51618a2d36ad3bac96', 1720230997), (129, 'rishabh.shrivastava2712@gmail.com', '77220f106c2ac1bda8d2b886b92280103c390850ffd0af4f30a966972bfa6894bd9fca81a595b79987a6f4b9954d62b72c67', 1721929331), (99, 'rishabh.shrivastava2712@gmail.com', '792e04d234058dc9a796294abb7a6055baf51f408f156ccc4895698bab9b703fc047402e4281b0b5f5ccba7f54dcce04ba19', 1720229353), (146, 'rishabh.shrivastava2712@gmail.com', '7a46ff7e8b4e902a88f71239c3f35afa5060b220dcbd7ab925357e49bfcc68bb621ddf7c9b73686ff78e1154dcfe61f4e76a', 1722037542), (135, 'rishabh@gmail.com', '81e0474756feee1c1235df6b8b1c73d7ac6a18bb3d3d17b44a2152f35ca3274a3999f3fcaa67f1b4562639fe051d437ed44e', 1721931454), (128, 'AyushShrivatava2205@gmail.com', '86df7579d9003198bd6ceb3dbd92b2f535f0f790e5adc53f37abe27e9cd840b8d0953e6d488e17f8effd81b5e45631f8d929', 1721929078), (107, 'rishabh.shrivastava2712@gmail.com', '8b1a701dc47c41c4dc0c96bf7d2d5d35bfc0d93b28771fd2b0d30e0b1ccd0bec4baec921199edbdf5e71092c70b43a391210', 1720231011), (87, 'rishabh@gmail.com', '921bea710d72fa0281f6184504f2beb646f385f0c0593b31763064ac8c14f9d6a953243f5fb29f23bb29c4d308a3ac98a964', 1719978103), (121, 'rishabh.shrivastava2712@gmail.com', '9353866d05714d97dab33d18cb7e372d4d2e69a9fa8f7d46205e20bfa81aa8f5996c3faca10a3a5bd6e05e95153e38f2def1', 1721927570), (97, 'rishabh.shrivastava2712@gmail.com', '99c888b6e914bc5be2c4e56dc6a6dc721444963cb5dd1fac58e06aeaf2bb123373e67f758b8e2ec03c8b1bcb75b5634cdc23', 1720229170), (117, 'rishabh.shrivastava2712@gmail.com', '9b79e0f5ba3c3fbacc8474efb8d9f4a44517be91367f9df747d45fe6b779854bfb874c0eead0576dd9fdb337d30d57432b3f', 1720255954), (103, 'rishabh.shrivastava2712@gmail.com', 'aa1d83d4c71397b17fd863663a6a74f0811778ea28975b1d0bd6292ef54678fdfc186cf39c6867347fbdc521093ec5673353', 1720230671), (137, 'rishabh.shrivastava2712@gmail.com', 'aa2a2a75a73c6aa188dc5a22343be164d9772fa75e6969adde702f011ac176d34e11d965e4a369f3b1e383396377cf2800f7', 1722007436), (91, 'rishabh@gmail.com', 'ab66119881fc60ddeba9f11ba674e23c12b38721c4419e158b2863c6463e44ec9e2e101d15e2e5417d965e02ba1451ec171b', 1719978112), (100, 'rishabh.shrivastava2712@gmail.com', 'b5b96b525baceefdf283aaef5cc4da3aab470d81a70563c4d603aa9ddb8455c31d102b0eb4e663145cdca22e0a2c599d9e7b', 1720230347), (119, 'rishabh.shrivastava2712@gmail.com', 'b938c221f3df2323d542bb0d63b7792affcc7a01faa49f5e35f589d996fe51e37479341027691eb578c30981f82b8688cf04', 1721927433), (140, 'rishabh@gmail.com', 'c0b23484c61ac199f52144e8f7c1032364a3a0a60385a0fef2b565834091a2f65c3fb727d03dd14959f5812b7e170e95b2cf', 1722007507), (90, 'rishabh@gmail.com', 'c232ddf2585c36fd1b3b7a8f7ecd146c142f1b382102b8d6d49ff78831bc1703b9b8f055cb5dffb8ab6278691422bf3d8331', 1719978111), (95, 'rishabh.shrivastava2712@gmail.com', 'c49a3c7efb155e77f37edf1b54f66a6d46ca866c336806c242cf568f7610d2af3d51441089e799c44eb2c0ef341dee19e6fb', 1720229109), (149, 'rishabh@gmail.com', 'cbe72bce737c7053556f0d9f444dd94da18202ce5bb11f3294268cacabc81491e6587e95c3f28691321b49f4fdadc53e8ac6', 1726669801), (102, 'rishabh.shrivastava2712@gmail.com', 'cbf54368505b3cfb544a47b7e9feb2e3a1914a2ff90dbde5c09ead9fccab4455a103e9a934c850e57c1e4a8eb649807ef7b4', 1720230413), (142, 'rishabh@gmail.com', 'ccac34dc0a430902f7d5d78e55f503399e77efa031d579f9bd99f67325310f711de50f1156eeb278d6324117fb109c5de0ec', 1722028186), (98, 'rishabh.shrivastava2712@gmail.com', 'e0474d9520474ccd228a660d83b4db45f7ef7f7cd3e5addaed7fd3d39148c27ae24e27c2e9f16b5a50069be9edae88f4850c', 1720229251), (108, 'rishabh.shrivastava2712@gmail.com', 'e0c2db74aeb40bad9fd82da360da296655125e6ceca05ddf69534a6612b627701eb0b74359521a4f9dbc2fe34973a30f1a70', 1720231039), (124, 'rishabh.shrivastava2712@gmail.com', 'e998239e6463e40f5d7bc41bd4eff7b2d4139a8061456b0d28b7ce56f775a8e55ecc918c7ef361f10471800a45e891e1ec02', 1721928901), (111, 'rishabh.shrivastava2712@gmail.com', 'f1b66732d44312f43fbdb76c87d3a52aec5d14ca6255d3d9f5ab4d4a84ab5adcbdb539dd34a8d858a754b7f3994d45137e59', 1720231200), (84, 'rishabh@gmail.com', 'f8fee87f79506d03b726681ccc970cc29d1a549a56c85b886f679da447daac4d11ef6d69181ca64c35c33b6d7720da0f9c48', 1719978102); -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` int(11) NOT NULL, `role_name` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`id`, `role_name`) VALUES (1, 'admin'), (3, 'bidder'), (2, 'seller'); -- -------------------------------------------------------- -- -- Table structure for table `subscriptions` -- CREATE TABLE `subscriptions` ( `id` int(11) NOT NULL, `name` int(255) NOT NULL, `email` varchar(300) NOT NULL, `subscription_date` timestamp NOT NULL DEFAULT current_timestamp(), `status` varchar(50) NOT NULL DEFAULT 'Pending' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `subscriptions` -- INSERT INTO `subscriptions` (`id`, `name`, `email`, `subscription_date`, `status`) VALUES (2, 0, '', '2024-06-03 18:04:14', 'Pending'), (3, 0, '', '2024-06-03 18:06:51', 'Pending'), (5, 0, '', '2024-06-03 18:07:57', 'Pending'), (6, 0, '', '2024-06-03 18:08:03', 'Pending'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(10) NOT NULL, `password` varchar(255) NOT NULL, `role_id` enum('bidder','seller','admin') NOT NULL, `company_name` varchar(255) DEFAULT NULL, `pan_card` varchar(15) DEFAULT NULL, `pan_card_photo` varchar(255) DEFAULT NULL, `gst_no` varchar(20) DEFAULT NULL, `gst_no_photo` varchar(255) DEFAULT NULL, `country` varchar(100) DEFAULT NULL, `state` varchar(100) DEFAULT NULL, `city` varchar(100) DEFAULT NULL, `current_address` varchar(255) DEFAULT NULL, `permanent_address` varchar(255) DEFAULT NULL, `status` enum('active','blocked') NOT NULL DEFAULT 'active', `membership` enum('single auction','monthly','quarterly','half yearly','yearly') NOT NULL, `profile_picture` varchar(255) DEFAULT NULL, `auction_limit` int(11) NOT NULL DEFAULT 0, `membership_start_date` date DEFAULT NULL, `membership_end_date` date DEFAULT NULL, `terms` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `phone`, `password`, `role_id`, `company_name`, `pan_card`, `pan_card_photo`, `gst_no`, `gst_no_photo`, `country`, `state`, `city`, `current_address`, `permanent_address`, `status`, `membership`, `profile_picture`, `auction_limit`, `membership_start_date`, `membership_end_date`, `terms`, `created_at`, `updated_at`) VALUES (1, 'rishabh', 'rishabh@gmail.com', '8770160324', '$2y$10$rXs8O0ezLtGzQqT5OaYu4eVBGJzKkTblIAHgahy0PewYnz6YheQP2', 'seller', 'njknkjn', 'dnsjkbnajkd', '', '6546546x6c', '', 'sdfdsfdsdf', 'dsfsddsfcd', 'dsfdsfdsfsd', 'BJHBJHBHJB', 'BJBJHBJHB', '', 'half yearly', 'uploads/profile/IMG_20190330_162420-01.jpeg', 100, '2024-07-04', '2024-08-23', 1, '2024-07-04 10:47:04', '2024-10-17 17:52:33'), (3, 'rishab5454', 'rishabh.shrivastava2712@gmail.com', '9826811402', '$2y$10$UFqNRpjdVMJ1IxV4uYpflOHxVxMdQ8ob28AogkpG9guysnBzz/Lx2', 'seller', 'njknkjn', '', '', '', '', 'sdfdsfdsdf', 'dsfsddsfcd', 'dsfdsfdsfsd', 'BJHBJHBHJB', 'sdfsdfd', '', 'monthly', 'fcbc7370d326df25b0450c6b60f30c03.jpg', 0, '2024-07-04', '2024-08-04', 1, '2024-07-04 15:53:50', '2024-08-11 16:26:06'), (4, 'rishabh', 'AyushShrivatava2205@gmail.com', '9881111111', '$2y$10$T4eNvRFfHL8xoSBmsWzy.OHqlBpAf2d.8mXxvbYokZP0mVjbG3cti', 'admin', 'njknkjn', 'sfas131', '', 'huhuih', '', 'gyuguy', 'dsfsddsfcd', 'dsfdsfdsfsd', 'BJHBJHBHJB', 'fefe', '', 'monthly', '', 0, '2024-07-04', '2024-08-04', 1, '2024-07-04 21:56:38', '2024-07-11 16:55:25'), (6, 'rishabh', 'admin@admin.com', '8770160328', '$2y$10$sDw85o57EtgRWkizqe6pmuKUvYTmlxOIBj5cCtkJ.Bp8PHlTAtepm', 'bidder', '1233', 'dnsjkbnajkd', '', '6546546x6c', '', 'sdfdsfdsdf', 'dsfsddsfcd', 'dsfdsfdsfsd', 'BJHBJHBHJB', 'sdfsdfd', '', 'monthly', '', 0, '2024-07-05', '2024-08-05', 1, '2024-07-04 22:35:47', '2024-10-17 17:51:33'), (7, 'rishabh', 'admin@example.com', '9826811411', '$2y$10$aVWbBmjM.hI.puIZTfWBJOABflzdEfdOu0lipjzupjOX8hOl1Gzqa', 'admin', 'njknkjn', 'dnsjkbnajkd', 'cpacases-1280x720.jpg', '6546546x6c32', 'IMG-20190315-WA0047-01.jpeg', 'sdfdsfdsdf', 'dsfsddsfcd', 'dsfdsfdsfsd', 'BJHBJHBHJB', 'sdfsdfd', '', 'monthly', '099316f5ba072a91381e71cc7b20011e.jpeg', 0, '2024-07-05', '2024-08-05', 1, '2024-07-04 22:38:09', '2024-07-29 20:09:22'), (26, 'rishabh', 'rishabh12@gmail.com', '9826811405', '$2y$10$.Vej2bwbLeocXCnBgcWa6updfFYaoErSbCudEYRGeFUZ0e3p2TpBO', 'admin', 'sfdasda', 'dnsjkbnajkd', '', '6546546x6c', '', 'ddsds', '1212mjbjhb', 'BJBHJBJH', 'BJHBJHBHJB', 'BJBJHBJHB', 'blocked', 'monthly', '', 0, '2024-07-10', '2024-08-10', 1, '2024-07-10 18:15:36', '2024-08-22 11:50:32'), (27, 'rishabh', 'rishabh3@gmail.com', '9826811474', '$2y$10$qI66NpErfEYHPrBh9trRBerE214fJbEDMTQpsntO6oC0e1Zt8Wmt2', 'seller', 'njknkjn', 'dnsjkbnajkd', 'IMG-20190315-WA0063-01.jpeg', 'huhuih', 'IMG_20190330_162418-01.jpeg', 'sdfdsfdsdf', '1212mjbjhb', 'oninim', 'BJHBJHBHJB', 'sdfsdfd', '', 'monthly', 'IMG_20190330_162420-01.jpeg', 0, '2024-07-10', '2024-08-10', 1, '2024-07-10 18:16:35', '2024-08-13 07:30:51'), (28, 'rishu', 'adminR@gmail.com', '9826811401', '$2y$10$Obo1fZs3f7XDgbjz5THR1OdnkhoteqMq6LB3YVo.EWuQthJVgP4MC', 'admin', 'njknkjn', 'dnsjkbnajkd', 'cpacases-1280x720.jpg', '6546546x6c', 'images.jpg', 'sdfdsfdsdf', 'Madhya Pradesh', 'dsfdsfdsfsd', 'BJHBJHBHJB', 'sdfsdfd', '', 'monthly', 'IMG_20190330_162420-01.jpeg', 0, '2024-07-18', '2024-08-18', 1, '2024-07-18 12:27:46', '2024-07-18 12:27:46'), (29, 'rishabh', 'rishabhreter@gmail.com', '1234555555', '$2y$10$G7x4ehUb5W1o.avdVhNCVux1M.xPYUtygMMOKrC/vGlW4eFdvViGW', 'seller', '123456', 'dnsjkbnajkd', 'cpacases-1280x720.jpg', '6546546x6c', '', 'gyuguy', 'Madhya Pradesh', 'dsfdsfdsfsd', 'BJHBJHBHJB8', 'BJBJHBJHB', '', 'monthly', '', 0, '2024-07-18', '2024-08-18', 1, '2024-07-18 13:28:21', '2024-07-27 02:11:54'), (31, 'rishabh', 'admi12@gmail.com', '1234561199', '$2y$10$CkGDQN897LEmpTkNOhZ.LOs5hXOYTWGd7OEYuQCbhjUkhbPQP/U1S', 'admin', 'sfdasda', 'sfas131', 'cpacases-1280x720.jpg', 'huhuih', 'images.jpg', 'sdfdsfdsdf', '1212mjbjhb', 'dsfdsfdsfsd', 'BJHBJHBHJB', 'BJBJHBJHB', '', 'monthly', 'IMG-20190315-WA0051-01.jpeg', 0, '2024-07-28', '2024-08-28', 1, '2024-07-27 23:36:41', '2024-07-27 23:40:05'), (32, 'rishabh12', 'rishabh25@gmail.com', '8770160321', '$2y$10$O9jc7NsC7cT9DFJ3g7wAPO15V4s8UG1LOrWbG4ctsrm8E9p0aB6zC', 'admin', 'njknkjn', 'dnsjkbnajkd', 'images.jpg', '6546546x6c', 'IMG-20170922-WA0054-02.jpeg', 'gyuguy', '1212mjbjhb', 'BJBHJBJH', 'jhbjhbj', 'BJBJHBJHB', '', 'monthly', 'c6bf61496bb2ece847c951ede14d5aa6.jpeg', 0, '2024-07-29', '2024-08-29', 1, '2024-07-29 20:14:38', '2024-07-30 02:08:49'); -- -- Indexes for dumped tables -- -- -- Indexes for table `auctions` -- ALTER TABLE `auctions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `authorized_users` -- ALTER TABLE `authorized_users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bidder_approvals` -- ALTER TABLE `bidder_approvals` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bidder_requests` -- ALTER TABLE `bidder_requests` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bids` -- ALTER TABLE `bids` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bid_requests` -- ALTER TABLE `bid_requests` ADD PRIMARY KEY (`request_id`); -- -- Indexes for table `contacts` -- ALTER TABLE `contacts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `events` -- ALTER TABLE `events` ADD PRIMARY KEY (`id`); -- -- Indexes for table `faq_questions` -- ALTER TABLE `faq_questions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `feedback` -- ALTER TABLE `feedback` ADD PRIMARY KEY (`id`); -- -- Indexes for table `messages` -- ALTER TABLE `messages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `newsletter_subscriptions` -- ALTER TABLE `newsletter_subscriptions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD PRIMARY KEY (`token`), ADD UNIQUE KEY `id` (`id`) USING BTREE; -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `role_name` (`role_name`); -- -- Indexes for table `subscriptions` -- ALTER TABLE `subscriptions` ADD PRIMARY KEY (`id`) USING BTREE; -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`), ADD UNIQUE KEY `phone` (`phone`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `auctions` -- ALTER TABLE `auctions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=110; -- -- AUTO_INCREMENT for table `authorized_users` -- ALTER TABLE `authorized_users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `bidder_approvals` -- ALTER TABLE `bidder_approvals` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bidder_requests` -- ALTER TABLE `bidder_requests` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `bids` -- ALTER TABLE `bids` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bid_requests` -- ALTER TABLE `bid_requests` MODIFY `request_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `contacts` -- ALTER TABLE `contacts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69; -- -- AUTO_INCREMENT for table `events` -- ALTER TABLE `events` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `faq_questions` -- ALTER TABLE `faq_questions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `feedback` -- ALTER TABLE `feedback` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `messages` -- ALTER TABLE `messages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30; -- -- AUTO_INCREMENT for table `newsletter_subscriptions` -- ALTER TABLE `newsletter_subscriptions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=143; -- -- AUTO_INCREMENT for table `password_resets` -- ALTER TABLE `password_resets` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=153; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `subscriptions` -- ALTER TABLE `subscriptions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; 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 */;