-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- 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, '<p>fdhftreu65</p>', '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 `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 `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 `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;

