-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Nov 04, 2024 at 08:47 AM -- Server version: 5.7.44-cll-lve -- PHP Version: 8.1.30 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: `addmyentry_crmsof` -- -- -------------------------------------------------------- -- -- Table structure for table `about` -- CREATE TABLE `about` ( `id` int(45) NOT NULL, `description` varchar(200) NOT NULL, `about_image` varchar(300) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `about` -- INSERT INTO `about` (`id`, `description`, `about_image`) VALUES (15, '

fdhftreu65

', 'cutignblas.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE `category` ( `categoryId` int(11) NOT NULL, `cityId` int(11) NOT NULL, `category` varchar(50) NOT NULL, `status` int(11) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `category` -- INSERT INTO `category` (`categoryId`, `cityId`, `category`, `status`) VALUES (1, 2, 'Cricket', 1), (2, 3, 'Cricket', 1), (3, 3, 'Chess', 1), (4, 3, 'Carram', 1), (5, 2, 'Chess', 1); -- -------------------------------------------------------- -- -- Table structure for table `city` -- CREATE TABLE `city` ( `cityId` int(11) NOT NULL, `cityName` varchar(50) NOT NULL, `status` tinyint(4) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `city` -- INSERT INTO `city` (`cityId`, `cityName`, `status`) VALUES (2, 'PUTHUKKOTTAI', 1), (3, 'CHENNAI', 1); -- -------------------------------------------------------- -- -- Table structure for table `contact_us` -- CREATE TABLE `contact_us` ( `id` int(50) NOT NULL, `address` varchar(100) NOT NULL, `phone` varchar(20) NOT NULL, `email` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `contact_us` -- INSERT INTO `contact_us` (`id`, `address`, `phone`, `email`) VALUES (1, 'Mandaveli', '9737432818', 'enquiry@nextgenbusiness.in'); -- -------------------------------------------------------- -- -- Table structure for table `employes` -- CREATE TABLE `employes` ( `vendorId` int(11) NOT NULL, `loginId` int(11) NOT NULL DEFAULT '0', `name` char(50) DEFAULT NULL, `gender` varchar(50) DEFAULT NULL, `email` text, `phone` varchar(10) DEFAULT NULL, `Address` text, `organization` varchar(100) DEFAULT NULL, `image` text, `status` int(11) NOT NULL DEFAULT '1', `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `employes` -- INSERT INTO `employes` (`vendorId`, `loginId`, `name`, `gender`, `email`, `phone`, `Address`, `organization`, `image`, `status`, `createdAt`, `updatedAt`) VALUES (6, 7, 'shahnaz', NULL, 'shah.yesgle@gmail.com', '8939731132', 'KOlathur', '4000', 'upload/employee/photo/6_1.jpg', 1, '2022-11-02 06:00:28', '2022-11-02 06:00:28'), (7, 8, 'Lokesh', NULL, 'loki.yesgle@gmail.com', '8122340017', 'Kolathur', '9000', 'upload/employee/photo/7_1.jpg', 1, '2022-11-02 06:01:49', '2022-11-02 06:01:49'), (8, 9, 'Abinaya', NULL, 'abi.yesgle@gmail.com', '9514201028', 'Kolthur', '9000', 'upload/employee/photo/8_1.jpg', 1, '2022-11-02 06:03:11', '2022-11-02 06:03:11'), (9, 10, 'Saravana', NULL, 'Callinfoinc@gmail.com', '9962516035', 'Kolthur', '18000', 'upload/employee/photo/8_1.jpg', 1, '2022-11-03 06:03:11', '2022-11-03 03:40:53'), (10, 11, 'Mouleeswari', NULL, 'Mouleeswari@yesgle.in', '9962516036', 'Kolathur', '22000', 'upload/employee/photo/10_1.jpg', 1, '2022-11-04 14:45:11', '2022-11-04 14:45:11'), (11, 12, 'saravana', NULL, 'yesgleinfoddd@gmail.com', '9962516037', 'fsd', '9000', 'upload/employee/photo/11_1.jpg', 1, '2022-11-04 16:12:04', '2022-11-04 16:12:04'); -- -------------------------------------------------------- -- -- Table structure for table `event_post` -- CREATE TABLE `event_post` ( `postId` int(11) NOT NULL, `postImage` text NOT NULL, `tournamentName` varchar(200) NOT NULL, `subTitle` text NOT NULL, `adderss` varchar(100) NOT NULL, `area` varchar(100) NOT NULL, `cityId` int(11) NOT NULL, `categoryId` int(11) NOT NULL, `entryFees` varchar(20) NOT NULL, `priceType` varchar(20) NOT NULL, `eventDate` date DEFAULT NULL, `bookingEndDate` date DEFAULT NULL, `document` text NOT NULL, `venderId` int(11) NOT NULL, `companyName` varchar(100) NOT NULL, `cantactPersonName` varchar(100) NOT NULL, `status` tinyint(4) NOT NULL DEFAULT '0', `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `event_post` -- INSERT INTO `event_post` (`postId`, `postImage`, `tournamentName`, `subTitle`, `adderss`, `area`, `cityId`, `categoryId`, `entryFees`, `priceType`, `eventDate`, `bookingEndDate`, `document`, `venderId`, `companyName`, `cantactPersonName`, `status`, `createdAt`, `updatedAt`) VALUES (6, 'upload/vendor/eventPost/6_tm8.jpg', 'TNPL DEMO', 'TNPL DEMO', 'SRP COLANY', 'KOLATHUR', 3, 2, '2000', 'Trophy', '2022-12-01', '2022-11-30', 'upload/vendor/document/6_drimg.jpg', 7, '9000', 'Lokesh', 0, '2022-11-28 15:29:05', '2022-11-28 15:29:05'); -- -------------------------------------------------------- -- -- Table structure for table `login` -- CREATE TABLE `login` ( `login_id` int(11) NOT NULL, `usernumber` varchar(50) NOT NULL, `password` text, `cipher` text, `date` date DEFAULT NULL, `time` time DEFAULT NULL, `control` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `login` -- INSERT INTO `login` (`login_id`, `usernumber`, `password`, `cipher`, `date`, `time`, `control`) VALUES (1, 'admin@addmyentry.com', 'W1jqprpj==', '2036081476844021', '2022-10-03', '18:04:43', 1), (7, '8939731132', 'Kgo/DshvyrM3VA==', '3201984298340960', '2022-11-02', '06:00:28', 2), (8, '9962516035', 'LwZ//3s8K8ed/w==', '9650433316280689', '2022-11-25', '16:50:48', 2), (9, '9361395819', 'BrFEGveVLHiusg==', '4925625126669411', '2022-11-26', '15:14:00', 2), (10, '', '', '9204084450789675', '2022-12-20', '09:33:06', 2); -- -------------------------------------------------------- -- -- Table structure for table `social_links` -- CREATE TABLE `social_links` ( `id` int(50) NOT NULL, `logo` varchar(300) NOT NULL, `social_name` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `vendor` -- CREATE TABLE `vendor` ( `vendorId` int(11) NOT NULL, `loginId` int(11) NOT NULL DEFAULT '0', `contactPersonName` char(50) DEFAULT NULL, `gender` varchar(50) DEFAULT NULL, `email` text, `phone` varchar(10) DEFAULT NULL, `Address` text, `organization` varchar(100) DEFAULT NULL, `image` text, `status` int(11) NOT NULL DEFAULT '1', `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `vendor` -- INSERT INTO `vendor` (`vendorId`, `loginId`, `contactPersonName`, `gender`, `email`, `phone`, `Address`, `organization`, `image`, `status`, `createdAt`, `updatedAt`) VALUES (5, 1, 'Veera', NULL, 'veeramani4032@gmail.com', '8525897626', 'KOlathur', 'admin', 'upload/employee/photo/6_1.jpg', 1, '2022-11-02 00:30:28', '2022-11-24 09:23:26'), (6, 7, 'shahnaz', NULL, 'shah.yesgle@gmail.com', '8939731132', 'KOlathur', 'shahnaz', 'upload/employee/photo/6_1.jpg', 1, '2022-11-02 00:30:28', '2022-11-25 17:03:00'), (7, 8, 'Lokesh', NULL, 'loki.yesgle@gmail.com', '8122340017', 'Kolathur', '9000', 'upload/employee/photo/7_1.jpg', 1, '2022-11-02 00:31:49', '2022-11-02 00:31:49'), (8, 9, 'Abinaya', NULL, 'abi.yesgle@gmail.com', '9514201028', 'Kolthur', '9000', 'upload/employee/photo/8_1.jpg', 1, '2022-11-02 00:33:11', '2022-11-02 00:33:11'), (9, 10, 'Saravana', NULL, 'Callinfoinc@gmail.com', '9962516035', 'Kolthur', '18000', 'upload/employee/photo/8_1.jpg', 1, '2022-11-03 00:33:11', '2022-11-02 22:10:53'), (10, 11, 'Mouleeswari', NULL, 'Mouleeswari@yesgle.in', '9962516036', 'Kolathur', '22000', 'upload/employee/photo/10_1.jpg', 1, '2022-11-04 09:15:11', '2022-11-04 09:15:11'), (11, 12, 'saravana', NULL, 'yesgleinfoddd@gmail.com', '9962516037', 'fsd', '9000', 'upload/employee/photo/11_1.jpg', 1, '2022-11-04 10:42:04', '2022-11-04 10:42:04'), (12, 8, 'saravana', NULL, 'yesgleinfo@gmail.com', '9962516035', '', 'MVS Company', NULL, 1, '2022-11-25 16:50:48', '2022-11-25 17:03:30'), (13, 9, 'NanthaKumar', NULL, 'gefetix439@probdd.com', '9361395819', NULL, NULL, NULL, 1, '2022-11-26 15:14:00', '2022-11-26 15:14:00'), (14, 10, '', NULL, '', '', NULL, NULL, NULL, 1, '2022-12-20 09:33:06', '2022-12-20 09:33:06'); -- -- Indexes for dumped tables -- -- -- Indexes for table `about` -- ALTER TABLE `about` ADD PRIMARY KEY (`id`); -- -- Indexes for table `category` -- ALTER TABLE `category` ADD PRIMARY KEY (`categoryId`); -- -- Indexes for table `city` -- ALTER TABLE `city` ADD PRIMARY KEY (`cityId`); -- -- Indexes for table `contact_us` -- ALTER TABLE `contact_us` ADD PRIMARY KEY (`id`); -- -- Indexes for table `employes` -- ALTER TABLE `employes` ADD PRIMARY KEY (`vendorId`); -- -- Indexes for table `event_post` -- ALTER TABLE `event_post` ADD PRIMARY KEY (`postId`); -- -- Indexes for table `login` -- ALTER TABLE `login` ADD PRIMARY KEY (`login_id`); -- -- Indexes for table `social_links` -- ALTER TABLE `social_links` ADD PRIMARY KEY (`id`); -- -- Indexes for table `vendor` -- ALTER TABLE `vendor` ADD PRIMARY KEY (`vendorId`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `about` -- ALTER TABLE `about` MODIFY `id` int(45) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `category` -- ALTER TABLE `category` MODIFY `categoryId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `city` -- ALTER TABLE `city` MODIFY `cityId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `contact_us` -- ALTER TABLE `contact_us` MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `employes` -- ALTER TABLE `employes` MODIFY `vendorId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `event_post` -- ALTER TABLE `event_post` MODIFY `postId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `login` -- ALTER TABLE `login` MODIFY `login_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `social_links` -- ALTER TABLE `social_links` MODIFY `id` int(50) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `vendor` -- ALTER TABLE `vendor` MODIFY `vendorId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; 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 */;