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

START TRANSACTION;



-- --------------------------------------------------------

--
-- Table structure for table `amenities`
--

CREATE TABLE `amenities` (
  `Id` int(15) NOT NULL,
  `amenitiesgroupId` int(15) DEFAULT NULL,
  `icons` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `status` int(10) NOT NULL,
  `orderby` int(10) NOT NULL,
  `createdby` int(15) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `amenities`
--

INSERT INTO `amenities` (`Id`, `amenitiesgroupId`, `icons`, `name`, `description`, `status`, `orderby`, `createdby`, `createddate`) VALUES
(2, 6, '<i class=\"bi bi-car-front-fill\"></i>', 'Car Parking', NULL, 1, 0, 1, '2025-12-07 19:05:07'),
(3, 6, '<i class=\"bi bi-luggage\"></i>', 'Fully Furnished', NULL, 1, 0, 1, '2025-12-07 19:05:10'),
(4, 6, '<i class=\"bi bi-controller\"></i>', 'Game', NULL, 1, 0, 1, '2025-12-07 19:05:13'),
(5, 6, '<i class=\"bi bi-house-add-fill\"></i>', 'Home', NULL, 1, 0, 1, '2025-12-07 19:05:15'),
(6, 6, '<i class=\"fa-solid fa-square-parking\"></i>', 'omkar', 'dasdsa', 1, 20, 1, '2025-12-07 19:05:18'),
(7, 6, '<i class=\"bi bi-sign-no-parking\"></i>', 'test', '4645', 1, 25, 1, '2025-11-21 12:49:44'),
(9, 6, NULL, 'omkar', 'sadas', 1, 10, 1, '2025-12-07 19:05:22');

-- --------------------------------------------------------

--
-- Table structure for table `amenitiesgroup`
--

CREATE TABLE `amenitiesgroup` (
  `Id` int(15) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` int(10) DEFAULT NULL,
  `orderby` int(10) DEFAULT NULL,
  `createdby` int(15) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `amenitiesgroup`
--

INSERT INTO `amenitiesgroup` (`Id`, `name`, `description`, `status`, `orderby`, `createdby`, `createddate`) VALUES
(1, 'vipas', 'asdfsgdthfyjuyrhtsdfgfhj', 1, 5, 1, '2025-11-13 07:48:55'),
(4, 'test 7', 'dfgfhjghk,j', 1, 10, 1, '2025-11-13 09:32:54'),
(5, 'waada', 'dwefwregthryj', 1, 15, 1, '2025-12-07 19:01:38'),
(6, 'nccwdefrgthygjk', 'fdsdghfgjhk', 1, 0, 1, '2025-11-21 10:17:13'),
(7, 'wersdgtfhgj', 'wadefsdgrfhj', 1, 45, 1, '2025-11-21 10:36:48'),
(8, 'waadaaaaaaaaaaaaa', 'dwertyuuuuuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 55, 1, '2025-11-21 10:37:25'),
(9, 'China', 'asdfg', 1, 5, 1, '2025-11-21 10:51:17'),
(10, '45', '445', 1, 45, 1, '2025-11-21 11:22:34'),
(11, 'omkar', 'sad', 1, 10, 1, '2025-11-21 14:15:05'),
(12, 'omkar', 'sadas', 1, 10, 1, '2025-11-21 14:17:38');

-- --------------------------------------------------------

--
-- Table structure for table `balancesheet`
--

CREATE TABLE `balancesheet` (
  `Id` int(15) NOT NULL,
  `GroupName` varchar(255) DEFAULT NULL,
  `GroupNameOtherLang` varchar(255) DEFAULT NULL,
  `BsGrpCode` varchar(255) DEFAULT NULL,
  `Liability` int(10) NOT NULL DEFAULT 0,
  `Asset` int(10) NOT NULL DEFAULT 0,
  `SortOrder` int(10) NOT NULL,
  `GroupNameOtherLangNoUniCode` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `balancesheet`
--

INSERT INTO `balancesheet` (`Id`, `GroupName`, `GroupNameOtherLang`, `BsGrpCode`, `Liability`, `Asset`, `SortOrder`, `GroupNameOtherLangNoUniCode`) VALUES
(1, 'Capital Account', NULL, 'ACA', 1, 0, 5, NULL),
(2, 'Loan(Liability)', NULL, 'LLL', 1, 0, 10, NULL),
(3, 'Fixed Assets', NULL, 'AFA', 1, 0, 15, NULL),
(4, 'Investment', NULL, 'INV', 1, 0, 20, NULL),
(5, 'Curent(Assets)', NULL, NULL, 0, 1, 25, NULL),
(6, 'Curent(Liability)', NULL, NULL, 1, 0, 30, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `bankaccount`
--

CREATE TABLE `bankaccount` (
  `Id` int(15) NOT NULL,
  `orgId` int(15) NOT NULL,
  `bankname` varchar(255) DEFAULT NULL,
  `accountno` varchar(255) DEFAULT NULL,
  `ifsccode` varchar(255) DEFAULT NULL,
  `branch` varchar(255) DEFAULT NULL,
  `bankaddress` varchar(255) DEFAULT NULL,
  `showoninvoice` int(10) NOT NULL DEFAULT 1,
  `createdby` int(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bankaccount`
--

INSERT INTO `bankaccount` (`Id`, `orgId`, `bankname`, `accountno`, `ifsccode`, `branch`, `bankaddress`, `showoninvoice`, `createdby`) VALUES
(1, 12, 'chii', 'wqerti', 'trytjuhi', 'rtryi', 'dsfgdiii', 4446, 1);

-- --------------------------------------------------------

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `Id` int(11) NOT NULL,
  `customerId` int(11) NOT NULL,
  `roomtypeId` int(15) DEFAULT NULL,
  `roomId` int(11) NOT NULL,
  `checkin` datetime NOT NULL,
  `checkout` datetime NOT NULL,
  `estimatedcheckout` datetime DEFAULT NULL,
  `adult` int(15) DEFAULT NULL,
  `child` int(15) DEFAULT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `discount` decimal(10,2) DEFAULT NULL,
  `cgst` decimal(10,2) DEFAULT NULL,
  `sgst` decimal(10,2) DEFAULT NULL,
  `payment_status` enum('pending','paid','cancelled') DEFAULT 'pending',
  `booking_status` enum('confirmed','cancelled','checked_in','checked_out') DEFAULT 'confirmed',
  `modeofbooking` varchar(255) NOT NULL,
  `message` text DEFAULT NULL,
  `createdby` int(15) NOT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bookings`
--

INSERT INTO `bookings` (`Id`, `customerId`, `roomtypeId`, `roomId`, `checkin`, `checkout`, `estimatedcheckout`, `adult`, `child`, `total_amount`, `discount`, `cgst`, `sgst`, `payment_status`, `booking_status`, `modeofbooking`, `message`, `createdby`, `createddate`) VALUES
(1, 1, 29, 0, '2025-12-15 21:55:00', '2025-12-16 21:55:00', NULL, 1, 1, 0.00, NULL, NULL, NULL, 'pending', 'confirmed', 'Online', 'fd', 0, '2025-12-17 11:00:54'),
(2, 2, 26, 9, '2025-12-15 22:05:00', '2025-12-16 22:05:00', NULL, 0, 0, 1295.64, NULL, NULL, NULL, '', 'confirmed', 'offline', '', 1, '2025-12-17 11:00:58'),
(3, 3, 26, 0, '2025-12-16 19:47:00', '2025-12-21 19:47:00', NULL, 2, 2, 0.00, NULL, NULL, NULL, 'pending', 'confirmed', 'Online', '56 6464 16 464 654', 0, '2025-12-17 11:01:11'),
(4, 4, 26, 11, '2025-12-17 13:33:00', '2025-12-18 13:33:00', NULL, 2, 1, 943.95, NULL, NULL, NULL, '', 'checked_in', 'offline', '', 1, '2025-12-17 11:01:24'),
(5, 15, 25, 7, '2025-12-17 17:33:00', '2025-12-18 17:32:00', NULL, 1, 2, 3516.45, 500.00, 83.73, 83.73, 'pending', 'checked_in', 'offline', '', 1, '2025-12-17 12:06:37'),
(6, 16, 24, 8, '2025-12-17 17:52:00', '2025-12-18 17:52:00', NULL, 1, 1, 3234.00, 1000.00, 77.00, 77.00, 'pending', 'checked_in', 'offline', '', 1, '2025-12-17 12:23:29'),
(7, 17, 24, 10, '2025-12-17 18:01:00', '2025-12-18 18:01:00', NULL, 2, 1, 4284.00, 0.00, 102.00, 102.00, 'pending', 'checked_in', 'offline', '', 1, '2025-12-17 12:31:43'),
(8, 18, 23, 0, '2025-12-17 18:03:00', '2025-12-18 18:03:00', NULL, 2, 1, 2467.50, 0.00, 58.75, 58.75, 'pending', 'checked_in', 'offline', '', 1, '2025-12-17 12:34:06');

-- --------------------------------------------------------

--
-- Table structure for table `booking_services`
--

CREATE TABLE `booking_services` (
  `Id` int(11) NOT NULL,
  `bookingId` int(11) NOT NULL,
  `serviceId` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `discount` int(15) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `drinksorder` int(15) NOT NULL,
  `foodorder` int(15) NOT NULL,
  `status` int(15) NOT NULL,
  `orderby` int(15) DEFAULT NULL,
  `createdby` int(15) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `booking_services`
--

INSERT INTO `booking_services` (`Id`, `bookingId`, `serviceId`, `price`, `quantity`, `discount`, `total`, `drinksorder`, `foodorder`, `status`, `orderby`, `createdby`, `createddate`) VALUES
(1, 4, 7, 0.00, 0, 0, 0.00, 0, 0, 0, 0, 1, '2025-12-19 07:30:27');

-- --------------------------------------------------------

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `Id` int(15) NOT NULL,
  `name` varchar(255) NOT NULL,
  `Image` varchar(255) DEFAULT NULL,
  `orderby` int(10) NOT NULL,
  `status` int(10) NOT NULL,
  `createdby` int(10) NOT NULL,
  `createdDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`Id`, `name`, `Image`, `orderby`, `status`, `createdby`, `createdDate`) VALUES
(2, 'Party Hall', '0049c660a434d0b6a75d8058545779fc.jpg', 20, 1, 1, '2025-12-15 07:00:21'),
(3, 'Rooms', 'e450d54968c19eeb3c24590b93556ee6.jpg', 30, 1, 1, '2025-12-15 07:00:30'),
(4, 'Restaurant', '1ea978d63a210c391737d8ad0a12818b.jpg', 30, 1, 1, '2025-12-15 07:00:45'),
(5, 'Main', '51579105fd51a076080c610bb25a4a9c.jpg', 30, 1, 1, '2025-12-15 07:00:58'),
(6, 'Food', '757e2006d63b282adc459330850bc952.jpg', 30, 1, 1, '2025-12-15 07:01:12'),
(7, 'BathRoom', '958069c6bb6cc773cdc7d6a628754b4d.jpg', 30, 1, 1, '2025-12-15 07:00:01');

-- --------------------------------------------------------

--
-- Table structure for table `clintreviews`
--

CREATE TABLE `clintreviews` (
  `Id` int(15) NOT NULL,
  `image` longtext DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `reviewer_email` varchar(255) DEFAULT NULL,
  `rating` int(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `createdBy` int(15) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `clintreviews`
--

INSERT INTO `clintreviews` (`Id`, `image`, `name`, `reviewer_email`, `rating`, `comment`, `createdBy`, `created_at`) VALUES
(2, 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogI0ZGNTczMzsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4dC1hbmNob3I6IG1pZGRsZTsgYWxpZ25tZW50LWJhc2VsaW5lOiBtaWRkbGU7IGZvbnQtZmFtaWx5OiBBcmlhbDsgfQ0KICAgIDwvc3R5bGU+DQogICAgPHJlY3Qgd2lkdGg9IjEwMCIgaGVpZ2h0PSIxMDAiIGNsYXNzPSJiYWNrZ3JvdW5kIi8+DQogICAgPHRleHQgeD0iNTAiIHk9IjUwIiBjbGFzcz0ibGV0dGVyIj5BPC90ZXh0Pg0KPC9zdmc+', 'Anita Sharma', NULL, NULL, ' \"Little Moon School provides a nurturing and safe environment for children. The teachers are caring, and the campus is clean and well-maintained. My child loves coming to school every day!\"', 1, '2025-06-16 14:12:59'),
(3, 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogI0ZGQkYwMDsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4dC1hbmNob3I6IG1pZGRsZTsgYWxpZ25tZW50LWJhc2VsaW5lOiBtaWRkbGU7IGZvbnQtZmFtaWx5OiBBcmlhbDsgfQ0KICAgIDwvc3R5bGU+DQogICAgPHJlY3Qgd2lkdGg9IjEwMCIgaGVpZ2h0PSIxMDAiIGNsYXNzPSJiYWNrZ3JvdW5kIi8+DQogICAgPHRleHQgeD0iNTAiIHk9IjUwIiBjbGFzcz0ibGV0dGVyIj5SPC90ZXh0Pg0KPC9zdmc+', 'Rajesh Patel', NULL, NULL, ' \"The school has a perfect balance of academics and extracurricular activities. The playgrounds, labs, and classrooms are modern and child-friendly. Highly recommended!\"', 1, '2025-06-16 14:13:05'),
(4, 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogI0ZGNEM0QzsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4dC1hbmNob3I6IG1pZGRsZTsgYWxpZ25tZW50LWJhc2VsaW5lOiBtaWRkbGU7IGZvbnQtZmFtaWx5OiBBcmlhbDsgfQ0KICAgIDwvc3R5bGU+DQogICAgPHJlY3Qgd2lkdGg9IjEwMCIgaGVpZ2h0PSIxMDAiIGNsYXNzPSJiYWNrZ3JvdW5kIi8+DQogICAgPHRleHQgeD0iNTAiIHk9IjUwIiBjbGFzcz0ibGV0dGVyIj5QPC90ZXh0Pg0KPC9zdmc+', 'Priya Nair', NULL, NULL, '  \"I appreciate the school’s focus on holistic development. The eco-friendly campus and emphasis on discipline make it an ideal place for learning. My child has grown so much here!\"', 1, '2025-06-16 14:13:12'),
(5, 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogI0ZGMzNEMjsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4dC1hbmNob3I6IG1pZGRsZTsgYWxpZ25tZW50LWJhc2VsaW5lOiBtaWRkbGU7IGZvbnQtZmFtaWx5OiBBcmlhbDsgfQ0KICAgIDwvc3R5bGU+DQogICAgPHJlY3Qgd2lkdGg9IjEwMCIgaGVpZ2h0PSIxMDAiIGNsYXNzPSJiYWNrZ3JvdW5kIi8+DQogICAgPHRleHQgeD0iNTAiIHk9IjUwIiBjbGFzcz0ibGV0dGVyIj5NPC90ZXh0Pg0KPC9zdmc+', 'Mr. & Mrs. Kapoor ', NULL, NULL, ' \"The school environment is positive and motivating. The teachers encourage creativity, and the infrastructure supports a great learning experience. Very happy with our choice!\"', 1, '2025-06-16 14:13:38'),
(6, 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogI0ZGNTczMzsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4dC1hbmNob3I6IG1pZGRsZTsgYWxpZ25tZW50LWJhc2VsaW5lOiBtaWRkbGU7IGZvbnQtZmFtaWx5OiBBcmlhbDsgfQ0KICAgIDwvc3R5bGU+DQogICAgPHJlY3Qgd2lkdGg9IjEwMCIgaGVpZ2h0PSIxMDAiIGNsYXNzPSJiYWNrZ3JvdW5kIi8+DQogICAgPHRleHQgeD0iNTAiIHk9IjUwIiBjbGFzcz0ibGV0dGVyIj5TPC90ZXh0Pg0KPC9zdmc+', 'Sunita Reddy', NULL, NULL, ' \"The school promotes values along with education. The classrooms are spacious, and the library is well-stocked. My child feels at home here. Thank you, Little Moon!\"', 1, '2025-06-16 14:14:03'),
(7, 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogI0E2MzNGRjsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4dC1hbmNob3I6IG1pZGRsZTsgYWxpZ25tZW50LWJhc2VsaW5lOiBtaWRkbGU7IGZvbnQtZmFtaWx5OiBBcmlhbDsgfQ0KICAgIDwvc3R5bGU+DQogICAgPHJlY3Qgd2lkdGg9IjEwMCIgaGVpZ2h0PSIxMDAiIGNsYXNzPSJiYWNrZ3JvdW5kIi8+DQogICAgPHRleHQgeD0iNTAiIHk9IjUwIiBjbGFzcz0ibGV0dGVyIj5WPC90ZXh0Pg0KPC9zdmc+', 'Vikram Singh', NULL, NULL, ' \"The school has excellent security measures, and the staff is always welcoming. The sports facilities and cultural activities make learning fun and engaging.\"', 1, '2025-06-16 14:14:35'),
(8, 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogI0ZGMzNEMjsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4dC1hbmNob3I6IG1pZGRsZTsgYWxpZ25tZW50LWJhc2VsaW5lOiBtaWRkbGU7IGZvbnQtZmFtaWx5OiBBcmlhbDsgfQ0KICAgIDwvc3R5bGU+DQogICAgPHJlY3Qgd2lkdGg9IjEwMCIgaGVpZ2h0PSIxMDAiIGNsYXNzPSJiYWNrZ3JvdW5kIi8+DQogICAgPHRleHQgeD0iNTAiIHk9IjUwIiBjbGFzcz0ibGV0dGVyIj5NPC90ZXh0Pg0KPC9zdmc+', 'Meena Iyer', NULL, NULL, ' \"A perfect blend of discipline and freedom. The school encourages curiosity and independent thinking. The green campus and hygiene standards are impressive!\"', 1, '2025-06-16 14:14:59'),
(9, 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogI0ZGNTczMzsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4dC1hbmNob3I6IG1pZGRsZTsgYWxpZ25tZW50LWJhc2VsaW5lOiBtaWRkbGU7IGZvbnQtZmFtaWx5OiBBcmlhbDsgfQ0KICAgIDwvc3R5bGU+DQogICAgPHJlY3Qgd2lkdGg9IjEwMCIgaGVpZ2h0PSIxMDAiIGNsYXNzPSJiYWNrZ3JvdW5kIi8+DQogICAgPHRleHQgeD0iNTAiIHk9IjUwIiBjbGFzcz0ibGV0dGVyIj5BPC90ZXh0Pg0KPC9zdmc+', 'Arjun Malhotra', NULL, NULL, '   \"Little Moon School provides a world-class environment with caring teachers and modern facilities. My child has developed confidence and a love for learning. Best decision ever!\"', 1, '2025-06-27 06:41:06');

-- --------------------------------------------------------

--
-- Table structure for table `contactinfo`
--

CREATE TABLE `contactinfo` (
  `Id` int(15) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `mobilephone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `map` longtext DEFAULT NULL,
  `whatsapp` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `linkedin` varchar(255) DEFAULT NULL,
  `status` int(15) NOT NULL,
  `orderby` int(15) DEFAULT NULL,
  `createdby` int(15) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contactinfo`
--

INSERT INTO `contactinfo` (`Id`, `address`, `mobilephone`, `email`, `map`, `whatsapp`, `instagram`, `facebook`, `twitter`, `linkedin`, `status`, `orderby`, `createdby`, `createddate`) VALUES
(1, 'dfghjkjlksdfg             ', '2345678905', 'sfdghjbcbcdjdjf5', NULL, '7411239232', 'https://www.instagram.com/', 'https://www.facebook.com/', 'https://x.com/', 'https://www.linkedin.com/feed/', 0, 0, 1, '2025-09-19 13:14:38'),
(3, 'adsfghjk', '2345678', 'adsfghjk', NULL, '345678', 'sdfghjk', 'dfrtyfu', NULL, NULL, 1, 15, 1, '2025-09-09 07:33:43');

-- --------------------------------------------------------

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `Id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `address` text NOT NULL,
  `createdby` int(15) DEFAULT NULL,
  `idproof` varchar(255) DEFAULT NULL,
  `idproofnumber` varchar(255) DEFAULT NULL,
  `idproofimage` varchar(255) DEFAULT NULL,
  `capturedImage` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`Id`, `name`, `email`, `phone`, `address`, `createdby`, `idproof`, `idproofnumber`, `idproofimage`, `capturedImage`, `created_at`) VALUES
(1, 'Omkar Telasang', 'omkartelasang@gmail.com', '07353665845', '', 0, '46546', NULL, NULL, '', '2025-12-15 16:25:33'),
(2, '7353665845', 'omkartelasang@gmail.com', '7353665845', '', 1, '64', '', '1e44c18e6582807b20f84eab0adc3b90.png', '', '2025-12-15 16:39:00'),
(3, 'Omkar Telasang', 'omkartelasang@gmail.com', '07353665845', '', 0, 'Aadhar ', NULL, NULL, '', '2025-12-16 14:18:03'),
(4, '454', 'omkartelasang@gmail.com', '7353665845', '', 1, '65', '12345678958', '8725b4df9f9944fe8d941c34250e26b6.png', '', '2025-12-17 08:04:19'),
(5, '', '', '', '', 1, '', '', '', '', '2025-12-17 11:10:22'),
(6, 'Omkar Telasang', 'omkartelasang@gmail.com', '7353665845', '', 1, '64', '', '3a240c8eaf5ecd521334faa5194cb4c5.png', '', '2025-12-17 11:11:22'),
(7, 'Omkar Telasang', 'omkartelasang@gmail.com', '7353665845', '', 1, '65', '465465464', 'f8e57f1c747351acaeb33883cbf5582b.png', '', '2025-12-17 11:12:12'),
(8, 'Omkar Telasang', 'omkartelasang@gmail.com', '7353665845', '', 1, '66', '', 'f107810f6b23cff867e72566fb5cdc27.png', '', '2025-12-17 11:14:11'),
(9, 'Omkar Telasang', 'omkartelasang@gmail.com', '7353665845', '', 1, '66', '12345678958', '', '', '2025-12-17 11:31:21'),
(10, 'Omkar Telasang', 'omkartelasang@gmail.com', '7353665845', '', 1, '67', '12345678958', 'd0985081c6c2a7e6b1e6ef11ff41c299.png', '', '2025-12-17 11:36:45'),
(11, 'Omkar Telasang', 'omkartelasang@gmail.com', '7353665845', '', 1, '67', '6466', '', '', '2025-12-17 11:38:47'),
(12, 'Omkar Telasang', 'omkartelasang@gmail.com', '7353665845', '', 1, '66', '12345678958', '9c9327381ed36e693691ca53ddb1981e.png', '', '2025-12-17 12:00:00'),
(13, 'Omkar Telasang', 'omkartelasang@gmail.com', '7353665845', '', 1, '66', '12345678958', '', '', '2025-12-17 12:02:09'),
(14, 'Omkar Telasang', 'omkartelasang@gmail.com', '7353665845', '', 1, '66', '12345678958', '', '', '2025-12-17 12:02:52'),
(15, 'Omkar Telasang', 'omkartelasang@gmail.com', '7353665845', '', 1, '66', '12345678958', '', '', '2025-12-17 12:06:37'),
(16, 'Omkar Telasang', 'omkartelasang@gmail.com', '7353665845', '', 1, '67', '12345678958', '20ecb46770be354c49541c947c5251df.png', '', '2025-12-17 12:23:29'),
(17, 'Omkar Telasang', 'omkartelasang@gmail.com', '7353665845', '', 1, '66', '12345678958', '7769c8b4004b294b2f8e60eafdc9df05.png', '', '2025-12-17 12:31:43'),
(18, 'Omkar Telasang', 'omkartelasang@gmail.com', '7353665845', '', 1, '66', '', '147bdf3c4adcaa9d4ff222f707b066a1.png', '', '2025-12-17 12:34:06');

-- --------------------------------------------------------

--
-- Table structure for table `defultconfigure`
--

CREATE TABLE `defultconfigure` (
  `Id` int(11) NOT NULL,
  `ConfigKey` varchar(255) NOT NULL,
  `Description` varchar(1000) DEFAULT NULL,
  `ValString` varchar(1000) DEFAULT NULL,
  `ValInt` int(255) DEFAULT NULL,
  `ValDecimal` decimal(55,0) DEFAULT NULL,
  `ValMoney` varchar(255) DEFAULT NULL,
  `ValDate` datetime DEFAULT NULL,
  `ValBool` bit(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `floor`
--

CREATE TABLE `floor` (
  `Id` int(15) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` int(15) NOT NULL,
  `orderby` int(15) DEFAULT NULL,
  `createdby` int(15) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `floor`
--

INSERT INTO `floor` (`Id`, `name`, `status`, `orderby`, `createdby`, `createddate`) VALUES
(19, 'Single', 1, 5, 1, '2025-11-26 07:36:35'),
(20, 'Deluxe King Room', 1, 10, 1, '2025-11-26 07:36:52');

-- --------------------------------------------------------

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `Id` int(15) NOT NULL,
  `yearId` int(15) NOT NULL,
  `catogeryId` int(15) NOT NULL,
  `showinslider` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `orderby` int(11) NOT NULL,
  `createdby` int(15) NOT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`Id`, `yearId`, `catogeryId`, `showinslider`, `image`, `name`, `description`, `status`, `orderby`, `createdby`, `createddate`) VALUES
(12, 0, 3, '1', 'e450d54968c19eeb3c24590b93556ee6.jpg', 'Rooms', ' Anything', 1, 5, 1, '2025-12-08 11:23:00'),
(13, 0, 3, '0', 'f245f3687c8f57c41f13d94acc71f1b9.jpg', 'rooms', ' anyting', 1, 10, 1, '2025-12-08 11:23:52'),
(14, 0, 4, '1', 'dd0c70bb07a08619dd8c42ee8187ce49.jpg', 'restaurant ', '  anything', 1, 5, 1, '2025-12-08 11:26:45'),
(15, 0, 4, '1', 'dd0c70bb07a08619dd8c42ee8187ce49.jpg', 'restaurant ', ' anything', 1, 10, 1, '2025-12-08 11:25:59'),
(16, 0, 6, '1', '757e2006d63b282adc459330850bc952.jpg', 'Food', ' sdfgdhb', 1, 5, 1, '2025-12-08 11:27:20'),
(17, 0, 3, '0', 'e450d54968c19eeb3c24590b93556ee6.jpg', 'Rooms', ' sdfcgvn', 1, 15, 1, '2025-12-08 11:27:56'),
(18, 0, 6, '0', '757e2006d63b282adc459330850bc952.jpg', 'Food', ' sdfsgfhgj', 1, 10, 1, '2025-12-08 11:28:32'),
(19, 0, 7, '0', '8cd54a330b778b961b3b94708b64a92b.jpg', 'Bathroom', ' asdfghm', 1, 5, 1, '2025-12-08 11:29:03'),
(20, 0, 2, '1', '0049c660a434d0b6a75d8058545779fc.jpg', 'Party Hall', ' wertfygju', 1, 5, 1, '2025-12-08 11:29:41'),
(21, 0, 5, '0', '51579105fd51a076080c610bb25a4a9c.jpg', 'Main', ' v bgnmj,', 1, 5, 1, '2025-12-08 11:32:42');

-- --------------------------------------------------------

--
-- Table structure for table `headaccounts`
--

CREATE TABLE `headaccounts` (
  `Id` int(11) NOT NULL,
  `AccountName` varchar(255) DEFAULT NULL,
  `ShortDescription` varchar(255) DEFAULT NULL,
  `LongDescription` varchar(255) DEFAULT NULL,
  `ParentAccId` int(15) DEFAULT NULL,
  `AccGrpCode` char(2) DEFAULT NULL,
  `AccSubGrpCode` char(2) DEFAULT NULL,
  `DisplayOrder` int(10) DEFAULT NULL,
  `ProfitLossId` int(15) DEFAULT NULL,
  `BalanceSheetId` int(15) DEFAULT NULL,
  `LongDescriptionNoUniCode` varchar(255) NOT NULL,
  `ShowInCashBook` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `headaccounts`
--

INSERT INTO `headaccounts` (`Id`, `AccountName`, `ShortDescription`, `LongDescription`, `ParentAccId`, `AccGrpCode`, `AccSubGrpCode`, `DisplayOrder`, `ProfitLossId`, `BalanceSheetId`, `LongDescriptionNoUniCode`, `ShowInCashBook`) VALUES
(1, 'Bank Accounts', 'All Miscellaneous Expenses', 'NULL ', 0, 'BA', 'SB', 1, 0, 1, 'NULL', 1),
(2, 'Bank OCC A/C', 'NULL', 'NULL ', 0, 'BA', 'CB', 0, 0, 1, 'NULL', 1),
(3, 'Bank OD A/C', 'NULL', 'NULL ', 0, 'BA', 'SB', 0, 0, 1, 'NULL', 1),
(4, 'Cash-in-Hand', 'NULL', 'NULL ', 0, 'CH', 'CH', 0, 0, 5, 'NULL', 1),
(5, 'Furniture', 'NULL', 'NULL ', 0, 'FA', 'FA', 0, 0, 3, 'NULL', 1),
(6, 'Machinery', 'NULL', 'NULL ', 0, 'FA', 'MA', 0, 0, 3, 'NULL', 1),
(7, 'Building', 'NULL', 'NULL ', 0, 'FA', 'BA', 0, 0, 3, 'NULL', 1),
(8, 'Vehicle', 'NULL', 'NULL ', 0, 'FA', 'VA', 0, 0, 3, 'NULL', 1),
(9, 'Electrical Fittings', 'NULL', 'NULL ', 0, 'FA', 'EF', 0, 0, 3, 'NULL', 1),
(10, 'Duties & Taxes', 'NULL', 'NULL ', 0, 'DT', 'DT', 0, 0, 4, 'NULL', 1),
(11, 'Computer', 'NULL', 'NULL ', 0, 'FA', 'CA', 0, 0, 3, 'NULL', 1),
(12, 'Telephone Deposits', 'NULL', 'NULL ', 0, 'DA', 'TD', 0, 0, 5, 'NULL', 1),
(13, 'Building Advance', 'NULL', 'NULL ', 0, 'DA', 'BA', 0, 0, 5, 'NULL', 1),
(14, 'Security Deposit', 'NULL', 'NULL ', 0, 'DA', 'SD', 0, 0, 5, 'NULL', 1),
(15, 'Fixed Deposits', 'NULL', 'NULL ', 0, 'DA', 'FD', 0, 0, 5, 'NULL', 1),
(16, 'Wages', 'NULL', 'NULL ', 0, 'DE', 'WA', 0, 3, 0, 'NULL', 1),
(17, 'Manufacturing Charges', 'NULL', 'NULL ', 0, 'DE', 'MC', 0, 3, 0, 'NULL', 1),
(18, 'Packing Charges', 'NULL', 'NULL ', 0, 'DE', 'PC', 0, 3, 0, 'NULL', 1),
(19, 'Carting Charges', 'NULL', 'NULL ', 0, 'DE', 'CC', 0, 3, 0, 'NULL', 1),
(20, 'Salary Paid', 'NULL', 'NULL ', 0, 'IE', 'SP', 0, 4, 0, 'NULL', 1),
(21, 'Rent Paid', 'NULL', 'NULL ', 0, 'IE', 'RP', 0, 4, 0, 'NULL', 1),
(22, 'Electricity Charge', 'NULL', 'NULL ', 0, 'IE', 'EC', 0, 4, 0, 'NULL', 1),
(23, 'Telephone Charge', 'NULL', 'NULL ', 0, 'IE', 'TC', 0, 4, 0, 'NULL', 1),
(24, 'Discount Allowed', 'NULL', 'NULL ', 0, 'IE', 'DA', 0, 4, 0, 'NULL', 1),
(25, 'Interest paid', 'NULL', 'NULL ', 0, 'IE', 'IP', 0, 4, 0, 'NULL', 1),
(26, 'Commission paid', 'NULL', 'NULL ', 0, 'IE', 'CP', 0, 4, 0, 'NULL', 1),
(27, 'Depreciation in Fixed Assets', 'NULL', 'NULL ', 0, 'IE', 'DF', 0, 4, 0, 'NULL', 1),
(28, 'Stationary', 'NULL', 'NULL ', 0, 'IE', 'SA', 0, 4, 0, 'NULL', 1),
(29, 'DD charges', 'NULL', 'NULL ', 0, 'IE', 'DC', 0, 4, 0, 'NULL', 1),
(30, 'Conveyance Expenses', 'NULL', 'NULL ', 0, 'IE', 'CE', 0, 4, 0, 'NULL', 1),
(31, 'Intrest received', 'NULL', 'NULL ', 0, 'II', 'IR', 0, 5, 0, 'NULL', 1),
(32, 'Rent Received', 'NULL', 'NULL ', 0, 'II', 'RR', 0, 5, 0, 'NULL', 1),
(33, 'Received Commission', 'NULL', 'NULL ', 0, 'II', 'RC', 0, 5, 0, 'NULL', 1),
(34, 'Discount Received', 'NULL', 'NULL ', 0, 'II', 'DR', 0, 5, 0, 'NULL', 1),
(35, 'Drawings', 'NULL', 'NULL ', 0, 'CA', 'DA', 0, 0, 1, 'NULL', 1),
(36, 'Secured Loans', 'NULL', 'NULL ', 0, 'LN', 'SL', 0, 0, 2, 'NULL', 1),
(37, 'Unsecured Loans', 'NULL', 'NULL ', 0, 'LN', 'UL', 0, 0, 2, 'NULL', 1),
(38, 'Sundry Crediotors', 'NULL', 'NULL ', 0, 'SC', 'SC', 0, 0, 5, 'NULL', 1),
(39, 'Loans and Advances', 'NULL', 'NULL ', 0, 'LA', 'LA', 0, 0, 5, 'NULL', 1),
(40, 'Stock in Hand', 'NULL', 'NULL ', 0, 'SH', 'SH', 0, 0, 4, 'NULL', 1),
(41, 'Shares', 'NULL', 'NULL ', 0, 'IN', 'SI', 0, 0, 4, 'NULL', 1),
(42, 'Mutual Fund', 'NULL', 'NULL ', 0, 'IN', 'MI', 0, 0, 4, 'NULL', 1),
(43, 'Sales Goods', 'NULL', 'NULL ', 0, 'SG', 'SG', 0, 2, 0, 'NULL', 1),
(44, 'Purchase Goods', 'NULL', 'NULL ', 0, 'PG', 'PG', 0, 1, 0, 'NULL', 1),
(45, 'Srt Bank', 'NULL', 'Srt Bank ', 0, 'BA', 'SR', 0, 0, 6, 'Srt Bank', 1),
(46, 'CANARA BANK', 'NULL', 'CANARA BANK ', 0, 'BA', 'CA', 0, 0, 6, 'CANARA BANK', 1),
(47, 'Purchase Return', 'NULL', 'NULL ', 0, 'PR', 'PG', 0, 0, 0, 'NULL', 1),
(48, 'Sale Return', 'NULL', 'NULL ', 0, 'SR', 'SG', 0, 0, 0, 'NULL', 1),
(49, 'Purchase Credit', 'NULL', 'NULL ', 0, 'PC', 'PG', 0, 0, 0, 'NULL', 1),
(50, 'Sale Credit', 'NULL', 'NULL ', 0, 'SC', 'SG', 0, 0, 0, 'NULL', 1),
(51, 'Wallet', 'NULL', 'NULL ', 0, 'WA', 'WL', 0, 0, 0, 'NULL', 1);

-- --------------------------------------------------------

--
-- Table structure for table `item`
--

CREATE TABLE `item` (
  `Id` int(15) NOT NULL,
  `orginfoId` int(15) DEFAULT NULL,
  `itemcetogeryId` int(15) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `price` int(10) DEFAULT NULL,
  `halfprice` int(10) DEFAULT NULL,
  `status` int(10) NOT NULL DEFAULT 1,
  `instock` int(10) NOT NULL DEFAULT 1,
  `createdby` int(15) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `item`
--

INSERT INTO `item` (`Id`, `orginfoId`, `itemcetogeryId`, `name`, `image`, `description`, `price`, `halfprice`, `status`, `instock`, `createdby`, `createddate`) VALUES
(3, 13, 2, 'Chinaa', 'a5db431b88b518badfcf5b8782b63a0d.jpg', 'defgnhm', 444, 244, 1, 1, 1, '2025-12-19 10:53:41'),
(4, 13, 3, 'gobi', 'f2b37bc4a0d6691269b62f35ccd05316.jpg', 'dsfgbgcnvhmb', 80, 50, 1, 1, 1, '2025-12-19 13:02:40');

-- --------------------------------------------------------

--
-- Table structure for table `itemcetogery`
--

CREATE TABLE `itemcetogery` (
  `Id` int(15) NOT NULL,
  `orginfoId` int(15) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `status` int(10) NOT NULL DEFAULT 1,
  `orderby` int(15) DEFAULT NULL,
  `createdby` int(15) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `itemcetogery`
--

INSERT INTO `itemcetogery` (`Id`, `orginfoId`, `name`, `image`, `status`, `orderby`, `createdby`, `createddate`) VALUES
(1, NULL, 'Starter', NULL, 1, NULL, 1, '2025-12-19 13:00:04'),
(2, NULL, 'Dinner', NULL, 1, NULL, 1, '2025-12-19 10:53:05'),
(3, NULL, 'Rice', NULL, 1, NULL, 1, '2025-12-19 10:53:25');

-- --------------------------------------------------------

--
-- Table structure for table `lookupvalues`
--

CREATE TABLE `lookupvalues` (
  `Id` int(15) NOT NULL,
  `GroupName` varchar(255) DEFAULT NULL,
  `DisplayValue` varchar(255) DEFAULT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `SortOrder` int(10) DEFAULT NULL,
  `Active` int(10) NOT NULL DEFAULT 1,
  `ValueCode` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `lookupvalues`
--

INSERT INTO `lookupvalues` (`Id`, `GroupName`, `DisplayValue`, `Description`, `SortOrder`, `Active`, `ValueCode`) VALUES
(1, 'Unit', 'Ltr', 'NULL ', 15, 1, 'NULL'),
(2, 'GSTSlab', '0%', '0 ', 5, 0, 'GST0'),
(3, 'GSTSlab', '5%', '5 ', 10, 1, 'GST5'),
(4, 'GSTSlab', '12%', '12 ', 15, 0, 'GST12'),
(5, 'GSTSlab', '18%', '18 ', 20, 1, 'GST18'),
(6, 'GSTSlab', '28%', '28 ', 25, 0, 'GST28'),
(7, 'TransactionType', '', 'NULL ', 1, 1, 'NULL'),
(8, 'TransactionType', 'CR', 'NULL ', 5, 1, 'TTCR'),
(9, 'TransactionType', 'DR', 'NULL ', 10, 1, 'TTDR'),
(10, 'PaymentMethod', 'Cash', 'NULL ', 5, 1, 'PMCA'),
(11, 'PaymentMethod', 'Debit Card', 'NULL ', 10, 1, 'PMTC'),
(12, 'PaymentMethod', 'Credit Card', 'NULL ', 15, 1, 'PMTC'),
(13, 'PaymentMethod', 'Net Banking', 'NULL ', 20, 1, 'PMTC'),
(14, 'PaymentMethod', 'PhonePe', 'NULL ', 25, 1, 'PMTC'),
(15, 'PaymentMethod', 'Paytm', 'NULL ', 30, 1, 'PMTC'),
(16, 'PaymentMethod', 'Google Pay', 'NULL ', 35, 1, 'PMTC'),
(17, 'PaymentMethod', 'Others', 'NULL ', 40, 1, 'PMTC'),
(18, 'Gender', '', 'NULL ', 5, 1, 'NULL'),
(19, 'Gender', 'Male', 'NULL ', 10, 1, 'NULL'),
(20, 'Gender', 'Female', 'NULL ', 15, 1, 'NULL'),
(21, 'Gender', 'Transgender', 'NULL ', 20, 1, 'NULL'),
(22, 'Status', '', ' ', 1, 1, 'NULL'),
(23, 'Status', 'Applied', 'NULL ', 5, 1, 'NULL'),
(24, 'Status', 'Pending', 'NULL ', 10, 1, 'NULL'),
(25, 'Status', 'Approved', 'NULL ', 15, 1, 'NULL'),
(26, 'Status', 'Active', 'NULL ', 20, 1, 'NULL'),
(27, 'Status', 'Suspend', 'NULL ', 25, 1, 'NULL'),
(28, 'Status', 'Locked', 'NULL ', 30, 1, 'NULL'),
(29, 'Status', 'Closed', 'NULL ', 35, 1, 'NULL'),
(30, 'PaymentMethod', 'By Cheque', 'NULL ', 7, 1, 'NULL'),
(31, 'PaymentMethod', 'Account Transfer', 'NULL ', 8, 1, 'NULL'),
(32, 'Unit', 'Pic', 'NULL ', 5, 1, 'NULL'),
(33, 'Unit', 'Pkg', 'NULL ', 6, 1, 'NULL'),
(34, 'Unit', 'Box', 'NULL ', 20, 1, 'NULL'),
(35, 'Unit', 'Bag', 'NULL ', 25, 1, 'NULL'),
(36, 'Unit', 'Nom', 'NULL ', 30, 1, 'NULL'),
(37, 'DiscountType', 'Per Unit', 'NULL ', 10, 1, 'NULL'),
(38, 'DiscountType', 'Amount', 'NULL ', 15, 1, 'NULL'),
(39, 'DiscountType', 'Percentege', 'NULL ', 20, 1, 'NULL'),
(40, 'YearMonths', 'January', 'NULL ', 1, 1, '1'),
(41, 'YearMonths', 'February', 'NULL ', 2, 1, '2'),
(42, 'YearMonths', 'March', 'NULL ', 3, 1, '3'),
(43, 'YearMonths', 'April', 'NULL ', 4, 1, '4'),
(44, 'YearMonths', 'May', 'NULL ', 5, 1, '5'),
(45, 'YearMonths', 'June', 'NULL ', 6, 1, '6'),
(46, 'YearMonths', 'July', 'NULL ', 7, 1, '7'),
(47, 'YearMonths', 'August', 'NULL ', 8, 1, '8'),
(48, 'YearMonths', 'September', 'NULL ', 9, 1, '9'),
(49, 'YearMonths', 'October', 'NULL ', 10, 1, '10'),
(50, 'YearMonths', 'November', 'NULL ', 11, 1, '11'),
(51, 'YearMonths', 'December', 'NULL ', 12, 1, '12'),
(52, 'EventType', 'Holiday', 'NULL ', 0, 1, 'HDY'),
(53, 'PaymentMethod', 'Credit', 'NULL ', 45, 1, 'PMC'),
(54, 'SalaryType', 'Per Day', 'NULL ', 10, 1, 'STD'),
(55, 'SalaryType', 'Per Month', 'NULL ', 15, 1, 'STM'),
(56, 'StaffStatus', 'Active', 'NULL ', 10, 1, 'NULL'),
(57, 'StaffStatus', 'InActive', 'NULL ', 15, 1, 'NULL'),
(58, 'CustomerType', 'Customer', 'NULL ', 5, 1, 'CUST'),
(59, 'CustomerType', 'Dealer', 'NULL ', 10, 1, 'DLR'),
(60, 'PaymentMethod', 'Wallet', 'NULL ', 50, 1, 'PMWL'),
(61, 'TableStatus', 'Available', NULL, 5, 1, 'TSA'),
(62, 'TableStatus', 'Occupied', NULL, 10, 1, 'TSO'),
(63, 'TableStatus', 'Reserved', NULL, 15, 1, 'TSR'),
(64, 'idproof', 'Aadhar', NULL, 5, 1, 'ADR'),
(65, 'idproof', 'PAN', NULL, 10, 1, 'PA'),
(66, 'idproof', 'Voter ID', NULL, 15, 1, 'VTD'),
(67, 'idproof', 'Passport', NULL, 20, 1, 'PPT'),
(68, 'roomstatus', 'Available', NULL, 5, 1, 'RAVL'),
(69, 'roomstatus', 'Booked', NULL, 10, 1, 'RBKD'),
(70, 'roomstatus', 'Maintenance', NULL, 15, 1, 'RMTC');

-- --------------------------------------------------------

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `Id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `type` enum('email','sms','whatsapp') NOT NULL,
  `sent_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `orginfo`
--

CREATE TABLE `orginfo` (
  `Id` int(15) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `Phone` varchar(255) DEFAULT NULL,
  `Website` varchar(255) DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `GST` varchar(255) DEFAULT NULL,
  `Address` varchar(1000) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `logoWidth` int(255) DEFAULT 150,
  `BankName` varchar(500) DEFAULT NULL,
  `AccountNo` varchar(30) DEFAULT NULL,
  `IFSCCode` varchar(14) DEFAULT NULL,
  `membership` int(255) NOT NULL,
  `payment_time` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `orginfo`
--

INSERT INTO `orginfo` (`Id`, `name`, `Phone`, `Website`, `Email`, `GST`, `Address`, `logo`, `logoWidth`, `BankName`, `AccountNo`, `IFSCCode`, `membership`, `payment_time`) VALUES
(1, 'Vipas', '07353665845', '', 'omkartelasang@gmail.com', '', 'Near water tank', '72449997b43ea70e949f3d3829402861.jpg', 150, '', '', '', 0, ''),
(2, 'omkar Shop', '7353665845', NULL, 'omkartelasang+5@gmail.com', NULL, NULL, NULL, 150, NULL, NULL, NULL, 0, ''),
(3, 'vipas hotel', '7353665845', NULL, 'omkartelasang@gmail.com', NULL, NULL, NULL, 150, NULL, NULL, NULL, 0, ''),
(4, 'Your Toy Buy', '07353665845', NULL, 'omkartelasang@gmail.com', NULL, NULL, NULL, 150, NULL, NULL, NULL, 0, ''),
(5, 'Your Toy Buy5', '07353665845', NULL, 'omkartelasang@gmail.com', NULL, NULL, NULL, 150, NULL, NULL, NULL, 0, ''),
(6, 'Your Toy Buy56', '07353665845', NULL, 'omkartelasang@gmail.com', NULL, NULL, NULL, 150, NULL, NULL, NULL, 0, ''),
(7, 'Satvam', '07353665845', '', 'omkartelasang@gmail.com', '', '', '0b4b563ff1a5c5972080b40c2a47cf73.png', 150, '', '', '', 0, ''),
(8, 'stavam', '7353665845', NULL, 'omkartelasang@gmail.com', NULL, NULL, NULL, 150, NULL, NULL, NULL, 0, ''),
(9, 'oakdhh', '07353665845', NULL, 'omkartelasang@gmail.com', NULL, NULL, NULL, 150, NULL, NULL, NULL, 0, ''),
(10, 'emailtest', '7353665845', NULL, 'omkartelasang@gmail.com', NULL, NULL, NULL, 150, NULL, NULL, NULL, 0, ''),
(11, 'emailtest1', '07353665845', NULL, 'omkartelasang@gmail.com', NULL, NULL, NULL, 150, NULL, NULL, NULL, 0, ''),
(12, 'emailtest12', '07353665845', NULL, 'omkartelasang@gmail.com', NULL, NULL, NULL, 150, NULL, NULL, NULL, 0, ''),
(13, 'Arabian Knights', '7353665845', NULL, 'omkartelasang@gmail.com', NULL, NULL, NULL, 150, NULL, NULL, NULL, 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `payment_id` int(11) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `payment_method` enum('cash','card','upi','online') NOT NULL,
  `transaction_id` varchar(100) DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment_date` datetime DEFAULT current_timestamp(),
  `status` enum('success','failed','pending') DEFAULT 'pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `profitloss`
--

CREATE TABLE `profitloss` (
  `Id` int(15) NOT NULL,
  `GroupName` varchar(255) DEFAULT NULL,
  `GroupNameOtherLang` varchar(255) DEFAULT NULL,
  `Expenditure` int(10) NOT NULL DEFAULT 0,
  `Income` int(10) NOT NULL DEFAULT 0,
  `SortOrder` int(10) NOT NULL,
  `GroupNameOtherLanguNoUniCode` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `profitloss`
--

INSERT INTO `profitloss` (`Id`, `GroupName`, `GroupNameOtherLang`, `Expenditure`, `Income`, `SortOrder`, `GroupNameOtherLanguNoUniCode`) VALUES
(1, 'Purchase Account', NULL, 1, 0, 5, ''),
(2, 'Sales Account', NULL, 0, 1, 5, ''),
(3, 'Direct Expenses', NULL, 1, 0, 10, ''),
(4, 'Indirect Expenses', NULL, 1, 0, 15, ''),
(5, 'Indirect Incomes', NULL, 0, 1, 20, '');

-- --------------------------------------------------------

--
-- Table structure for table `purchase`
--

CREATE TABLE `purchase` (
  `Id` int(15) NOT NULL,
  `vendorId` int(10) DEFAULT NULL,
  `purchaseDate` date DEFAULT NULL,
  `purchaseInvoice` varchar(1000) DEFAULT NULL,
  `totalAmount` decimal(60,0) DEFAULT NULL,
  `SgstTotal` decimal(60,0) DEFAULT NULL,
  `CgstTotal` decimal(60,0) DEFAULT NULL,
  `IgstTotal` decimal(60,0) DEFAULT NULL,
  `DiscountPercentage` decimal(60,0) NOT NULL,
  `DiscountAmount` decimal(60,0) DEFAULT NULL,
  `PurchaseCredit` decimal(60,0) DEFAULT NULL,
  `grandTotal` decimal(60,0) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `createdby` int(15) DEFAULT NULL,
  `orgId` int(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `Id` int(15) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `rolecode` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `role`
--

INSERT INTO `role` (`Id`, `name`, `rolecode`, `description`) VALUES
(1, 'Admin', 'AMD', 'sass4654'),
(3, 'Teacher', 'Teach', 'sass');

-- --------------------------------------------------------

--
-- Table structure for table `room`
--

CREATE TABLE `room` (
  `Id` int(15) NOT NULL,
  `number` int(15) DEFAULT NULL,
  `room_type` int(15) DEFAULT NULL,
  `room_floor` int(15) NOT NULL,
  `price` varchar(255) DEFAULT NULL,
  `occupancy` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `status` int(10) NOT NULL,
  `createdby` int(15) NOT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `room`
--

INSERT INTO `room` (`Id`, `number`, `room_type`, `room_floor`, `price`, `occupancy`, `description`, `status`, `createdby`, `createddate`) VALUES
(7, 101, 25, 0, '1099', '2', 'Featuring free toiletries, this double room includes a private bathroom with a walk-in shower and a hairdryer. The air-conditioned double room features a flat-screen TV with cable channels, a private entrance, a coffee machine, a seating area as well as garden views. The unit has 1 bed.', 69, 1, '2025-12-17 12:06:37'),
(8, 102, 24, 0, '1899', '3', 'Featuring free toiletries, this double room includes a private bathroom with a walk-in shower and a hairdryer. The air-conditioned double room features a flat-screen TV with cable channels, a private entrance, a coffee machine, a seating area as well as garden views. The unit has 1 bed.', 69, 1, '2025-12-17 12:23:29'),
(9, 103, 26, 20, NULL, '5', 'dfdgfhg', 69, 1, '2025-12-15 16:39:00'),
(10, 250, 24, 19, NULL, '10', '', 69, 1, '2025-12-17 12:31:43'),
(11, 300, 26, 19, NULL, '5', '', 69, 1, '2025-12-17 08:04:19'),
(12, 235, 23, 20, NULL, '5', '', 68, 1, '2025-12-17 12:54:15'),
(13, 200, 23, 20, NULL, '10', '', 68, 1, '2025-12-17 12:54:29');

-- --------------------------------------------------------

--
-- Table structure for table `roombookingorder`
--

CREATE TABLE `roombookingorder` (
  `Id` int(15) NOT NULL,
  `bookingId` int(15) DEFAULT NULL,
  `orderId` int(15) DEFAULT NULL,
  `roomId` int(15) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `quantity` varchar(255) DEFAULT NULL,
  `total` int(15) DEFAULT NULL,
  `status` int(15) NOT NULL,
  `orderby` int(15) DEFAULT NULL,
  `createdby` int(15) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roombookingorder`
--

INSERT INTO `roombookingorder` (`Id`, `bookingId`, `orderId`, `roomId`, `price`, `quantity`, `total`, `status`, `orderby`, `createdby`, `createddate`) VALUES
(1, 22, 0, NULL, '4555', '2', 45555, 1, 5, 1, '2025-12-10 12:14:59'),
(2, 10, 0, 8, '454', '1', 454, 1, 5, 1, '2025-12-10 13:33:54');

-- --------------------------------------------------------

--
-- Table structure for table `roomfloor`
--

CREATE TABLE `roomfloor` (
  `Id` int(11) NOT NULL,
  `roomId` int(11) NOT NULL,
  `floorId` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `roomreviews`
--

CREATE TABLE `roomreviews` (
  `id` int(10) UNSIGNED NOT NULL,
  `roomtypeId` int(10) UNSIGNED NOT NULL,
  `reviewer_name` varchar(100) NOT NULL,
  `reviewer_email` varchar(150) NOT NULL,
  `rating` tinyint(3) UNSIGNED NOT NULL CHECK (`rating` between 1 and 5),
  `comment` text NOT NULL,
  `image` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roomreviews`
--

INSERT INTO `roomreviews` (`id`, `roomtypeId`, `reviewer_name`, `reviewer_email`, `rating`, `comment`, `image`, `created_at`) VALUES
(1, 22, 'name', 'omkartelasang@gmail.com', 4, 'sa', '525', '2025-12-07 16:53:40'),
(2, 22, 'name', 'omkartelasang@gmail.com', 2, '464', 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogI0ZGNjYwMDsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4d', '2025-12-07 17:46:46'),
(3, 22, 'omkar', 'omkartelasang@gmail.com', 4, 'sd', 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogI0ZGOTk5OTsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4d', '2025-12-07 18:03:08'),
(4, 22, 'Omkar Tesat', 'omkartelasang@gmail.com', 4, '456', 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogI0ZGOTk5OTsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4dC1hbmNob3I6IG1pZGRsZTsgYWxpZ25tZW50LWJhc2VsaW5lOiBtaWRkbGU7IGZvbnQtZmFtaWx5OiBBcmlhbDsgfQ0KICAgIDwvc3R5bGU+DQogICAgPHJlY3Qgd2lkdGg9IjEwMCIgaGVpZ2h0PSIxMDAiIGNsYXNzPSJiYWNrZ3JvdW5kIi8+DQogICAgPHRleHQgeD0iNTAiIHk9IjUwIiBjbGFzcz0ibGV0dGVyIj5PPC90ZXh0Pg0KPC9zdmc+', '2025-12-07 18:12:34'),
(5, 22, 'name', 'omkartelasang@gmail.com', 4, '456', 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogI0ZGNjYwMDsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4dC1hbmNob3I6IG1pZGRsZTsgYWxpZ25tZW50LWJhc2VsaW5lOiBtaWRkbGU7IGZvbnQtZmFtaWx5OiBBcmlhbDsgfQ0KICAgIDwvc3R5bGU+DQogICAgPHJlY3Qgd2lkdGg9IjEwMCIgaGVpZ2h0PSIxMDAiIGNsYXNzPSJiYWNrZ3JvdW5kIi8+DQogICAgPHRleHQgeD0iNTAiIHk9IjUwIiBjbGFzcz0ibGV0dGVyIj5OPC90ZXh0Pg0KPC9zdmc+', '2025-12-07 18:13:47'),
(6, 22, 'Omkar Tesat', 'omkartelasang@gmail.com', 5, 'fh hkfjh kjhdsfknkjhdf mbkjfshdk', 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogI0ZGOTk5OTsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4dC1hbmNob3I6IG1pZGRsZTsgYWxpZ25tZW50LWJhc2VsaW5lOiBtaWRkbGU7IGZvbnQtZmFtaWx5OiBBcmlhbDsgfQ0KICAgIDwvc3R5bGU+DQogICAgPHJlY3Qgd2lkdGg9IjEwMCIgaGVpZ2h0PSIxMDAiIGNsYXNzPSJiYWNrZ3JvdW5kIi8+DQogICAgPHRleHQgeD0iNTAiIHk9IjUwIiBjbGFzcz0ibGV0dGVyIj5PPC90ZXh0Pg0KPC9zdmc+', '2025-12-07 18:14:51'),
(7, 22, 'Omkar Tesat', 'omkartelasang@gmail.com', 3, 'workinhd', 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogI0ZGOTk5OTsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4dC1hbmNob3I6IG1pZGRsZTsgYWxpZ25tZW50LWJhc2VsaW5lOiBtaWRkbGU7IGZvbnQtZmFtaWx5OiBBcmlhbDsgfQ0KICAgIDwvc3R5bGU+DQogICAgPHJlY3Qgd2lkdGg9IjEwMCIgaGVpZ2h0PSIxMDAiIGNsYXNzPSJiYWNrZ3JvdW5kIi8+DQogICAgPHRleHQgeD0iNTAiIHk9IjUwIiBjbGFzcz0ibGV0dGVyIj5PPC90ZXh0Pg0KPC9zdmc+', '2025-12-07 18:17:58'),
(8, 23, 'chidambar', 'chidambark106@gmail.com', 5, 'everything is good', 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogIzMzNTdGRjsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4dC1hbmNob3I6IG1pZGRsZTsgYWxpZ25tZW50LWJhc2VsaW5lOiBtaWRkbGU7IGZvbnQtZmFtaWx5OiBBcmlhbDsgfQ0KICAgIDwvc3R5bGU+DQogICAgPHJlY3Qgd2lkdGg9IjEwMCIgaGVpZ2h0PSIxMDAiIGNsYXNzPSJiYWNrZ3JvdW5kIi8+DQogICAgPHRleHQgeD0iNTAiIHk9IjUwIiBjbGFzcz0ibGV0dGVyIj5DPC90ZXh0Pg0KPC9zdmc+', '2025-12-08 08:03:48'),
(9, 23, 'chidu', 'chidambark106@gmail.com', 2, 'fine', 'data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiAgICA8c3R5bGU+DQogICAgICAgIC5iYWNrZ3JvdW5kIHsgZmlsbDogIzMzNTdGRjsgfQ0KICAgICAgICAubGV0dGVyIHsgZm9udC1zaXplOiA1MHB4OyBmaWxsOiB3aGl0ZTsgdGV4dC1hbmNob3I6IG1pZGRsZTsgYWxpZ25tZW50LWJhc2VsaW5lOiBtaWRkbGU7IGZvbnQtZmFtaWx5OiBBcmlhbDsgfQ0KICAgIDwvc3R5bGU+DQogICAgPHJlY3Qgd2lkdGg9IjEwMCIgaGVpZ2h0PSIxMDAiIGNsYXNzPSJiYWNrZ3JvdW5kIi8+DQogICAgPHRleHQgeD0iNTAiIHk9IjUwIiBjbGFzcz0ibGV0dGVyIj5DPC90ZXh0Pg0KPC9zdmc+', '2025-12-08 08:04:09');

-- --------------------------------------------------------

--
-- Table structure for table `roomtype`
--

CREATE TABLE `roomtype` (
  `Id` int(15) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(10,0) DEFAULT NULL,
  `GSTSlab` int(15) NOT NULL,
  `occupancy` int(11) DEFAULT NULL,
  `bath` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `orderby` int(11) DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roomtype`
--

INSERT INTO `roomtype` (`Id`, `name`, `description`, `price`, `GSTSlab`, `occupancy`, `bath`, `status`, `orderby`, `createdby`, `createddate`) VALUES
(22, 'Double', 'This air-conditioned family room includes a flat-screen TV with cable channels and a private bathroom. The unit offers 2 beds.', 1899, 3, NULL, NULL, 1, 5, 1, '2025-12-16 12:51:33'),
(23, 'Deluxe King Room', 'This air-conditioned family room includes a flat-screen TV with cable channels and a private bathroom. The unit offers 2 beds.hi', 2350, 3, NULL, NULL, 1, 10, 1, '2025-12-16 12:51:38'),
(24, 'Family Suite', 'This air-conditioned family room includes a flat-screen TV with cable channels and a private bathroom. The unit offers 2 beds.', 4080, 3, NULL, NULL, 1, 15, 1, '2025-12-16 12:51:44'),
(25, 'Executive Room', 'This air-conditioned family room includes a flat-screen TV with cable channels and a private bathroom. The unit offers 2 beds.', 3849, 3, NULL, NULL, 1, 20, 1, '2025-12-16 12:51:50'),
(26, 'Small', 'dsfg', 899, 3, NULL, NULL, 1, 25, 1, '2025-12-16 12:51:54'),
(27, 'test', 'sasd', 545, 3, NULL, NULL, 1, 10, 1, '2025-12-16 12:50:26');

-- --------------------------------------------------------

--
-- Table structure for table `roomtypeamenities`
--

CREATE TABLE `roomtypeamenities` (
  `Id` int(15) NOT NULL,
  `roomtypeId` int(10) DEFAULT NULL,
  `amenitiesId` int(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roomtypeamenities`
--

INSERT INTO `roomtypeamenities` (`Id`, `roomtypeId`, `amenitiesId`) VALUES
(1, 16, 0),
(2, 17, 2),
(3, 17, 3),
(4, 17, 4),
(5, 17, 5),
(6, 17, 7),
(7, 18, 2),
(8, 18, 3),
(9, 18, 4),
(10, 19, 2),
(11, 20, 3),
(12, 21, 4),
(13, 22, 2),
(14, 22, 3),
(15, 23, 3),
(16, 23, 4),
(17, 23, 7),
(18, 24, 2),
(19, 24, 3),
(20, 24, 4),
(21, 24, 7),
(22, 25, 3),
(23, 25, 5),
(24, 25, 7),
(25, 26, 2),
(26, 26, 3),
(27, 26, 4),
(28, 22, 4),
(29, 27, 2),
(30, 27, 3),
(31, 27, 4);

-- --------------------------------------------------------

--
-- Table structure for table `roomtypemedia`
--

CREATE TABLE `roomtypemedia` (
  `Id` int(15) NOT NULL,
  `roomtypeId` int(15) DEFAULT NULL,
  `photo1` varchar(255) DEFAULT NULL,
  `photo2` varchar(255) DEFAULT NULL,
  `photo3` varchar(255) DEFAULT NULL,
  `photo4` varchar(255) DEFAULT NULL,
  `photo5` varchar(255) DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `status` int(15) NOT NULL,
  `orderby` int(15) DEFAULT NULL,
  `createdby` int(15) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roomtypemedia`
--

INSERT INTO `roomtypemedia` (`Id`, `roomtypeId`, `photo1`, `photo2`, `photo3`, `photo4`, `photo5`, `video`, `status`, `orderby`, `createdby`, `createddate`) VALUES
(1, 0, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '70173585ad7bf13fbfe4f5af994bcf6e.jpeg', '6e1142ed2dbda28e34f0be37c32838f6.jpeg', '0ed26294377270be5979b481b814351d.jpeg', NULL, NULL, 1, 5, 1, '2025-12-15 15:39:46'),
(3, 0, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '70173585ad7bf13fbfe4f5af994bcf6e.jpg', '6e1142ed2dbda28e34f0be37c32838f6.jpeg', '0ed26294377270be5979b481b814351d.jpeg', NULL, NULL, 1, 5, 1, '2025-12-15 15:39:46'),
(4, 0, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '2ffd785f3dc4869aafe7d04adc7f76d3.jpeg', '', '', NULL, NULL, 1, 5, 1, '2025-12-15 15:39:46'),
(5, 0, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '1a89989c09016f87db9e1523720bfdd1.jpeg', '', '', NULL, NULL, 0, 25, 1, '2025-12-15 15:39:46'),
(11, 0, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '', '', '', NULL, NULL, 1, 25, 1, '2025-12-15 15:39:46'),
(12, NULL, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '', '', '', NULL, NULL, 1, 0, 1, '2025-12-15 15:39:46'),
(13, NULL, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '', '', '', NULL, NULL, 1, 5, 1, '2025-12-15 15:39:46'),
(14, NULL, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '', '', '', NULL, NULL, 1, 0, 1, '2025-12-15 15:39:46'),
(15, NULL, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '', '', '', NULL, NULL, 1, 0, 1, '2025-12-15 15:39:46'),
(16, NULL, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '', '', '', NULL, NULL, 1, 45, 1, '2025-12-15 15:39:46'),
(17, NULL, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '', '', '', NULL, NULL, 1, 55, 1, '2025-12-15 15:39:46'),
(18, NULL, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '', '', '', NULL, NULL, 1, 5, 1, '2025-12-15 15:39:46'),
(19, 15, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '1888489207c33be76c5d8072af264e6e.png', '', '', NULL, NULL, 1, 45, 1, '2025-12-15 15:39:46'),
(20, 16, '18fdd6361290b323e9ee2f99ce904e0a.jpg', 'f58707237025d228a6824830911bce1d.png', '', '', NULL, NULL, 1, 10, 1, '2025-12-15 15:39:46'),
(21, 17, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '', '', '', NULL, NULL, 1, 10, 1, '2025-12-15 15:39:46'),
(22, 18, '18fdd6361290b323e9ee2f99ce904e0a.jpg', 'f58707237025d228a6824830911bce1d.jpg', '024087812fb3315bc4fcbb60f7f1bfa5.jpeg', '19e55a774b8846bddbe842c4503ac712.png', NULL, NULL, 1, 50, 1, '2025-12-15 15:39:46'),
(23, 19, '18fdd6361290b323e9ee2f99ce904e0a.jpg', 'b95bc5ee8952e5bce3606f926182267e.jpg', '5b1f89dc5628f9968f92fd3c651f4739.jpg', '9b5faa74cf86629e0cb2cf9ea4ed5a41.jpg', NULL, NULL, 1, 5, 1, '2025-12-15 15:39:46'),
(24, 20, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '', '', '', NULL, NULL, 1, 55, 1, '2025-12-15 15:39:46'),
(25, 21, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '2ffd785f3dc4869aafe7d04adc7f76d3.jpeg', '', '', NULL, NULL, 1, 5, 1, '2025-12-15 15:39:46'),
(26, 22, 'ebd1a3b551e3286c52b613f427fe5ecb.jpg', '18fdd6361290b323e9ee2f99ce904e0a.png', '96b23abd3090d48f314eaf605826efa6.jpg', '3752bae380ad88f1c8f5b5ce3e9fc9bb.jpg', NULL, NULL, 1, 5, 1, '2025-12-16 14:14:23'),
(27, 23, '18fdd6361290b323e9ee2f99ce904e0a.jpg', 'b95bc5ee8952e5bce3606f926182267e.jpg', '5b1f89dc5628f9968f92fd3c651f4739.jpg', '9b5faa74cf86629e0cb2cf9ea4ed5a41.jpg', NULL, NULL, 1, 10, 1, '2025-12-15 15:39:46'),
(28, 24, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '7f6363cd74375cc8f70b5f5f50e86014.jpg', 'd34791dc491eafd2fcfe5bfe92964a31.jpg', 'a51103ebf8304a5de1840e90f6ea5115.jpg', NULL, NULL, 1, 15, 1, '2025-12-15 15:39:46'),
(29, 25, '18fdd6361290b323e9ee2f99ce904e0a.jpg', 'e6a5989bc6ecf43fa445cf626b07cac1.jpg', 'f820882b471b1252b8e477c9b0099108.jpg', '7561a706f0400a6a50213f8ff70e467a.jpg', NULL, NULL, 1, 20, 1, '2025-12-15 15:39:46'),
(30, 26, '18fdd6361290b323e9ee2f99ce904e0a.jpg', '07a8d68142544a6401ade020d466ef9a.jpg', 'c4f8e2fee522f257de0a3ca821e05cf0.jpg', 'a26f4cf325437db547e5d83fe40ff52d.jpg', NULL, NULL, 1, 25, 1, '2025-12-15 15:39:46'),
(31, 27, '469bc6c9249abfbdf2ae8b16a57d3021.png', 'b2e60e720958512df766b6d7ba3760a3.png', 'bec5e46480b722bba6e8f86947e71897.jpg', '', NULL, NULL, 1, 10, 1, '2025-12-16 12:50:26');

-- --------------------------------------------------------

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `Id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `description` text DEFAULT NULL,
  `status` int(15) NOT NULL,
  `orderby` int(15) DEFAULT NULL,
  `createdby` int(15) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`Id`, `name`, `price`, `description`, `status`, `orderby`, `createdby`, `createddate`) VALUES
(3, 'cvgcnhgmjhk', 55.00, 'etrdhfjgb,njfhrter', 1, NULL, 1, '2025-11-11 09:55:49'),
(4, 'cfdsgrdthfyjguhkj', 345.00, 'aesdxfdgdhfgb', 1, NULL, 1, '2025-11-11 10:12:53'),
(5, 'werfdgfhg', 456.00, 'waresdg thfjg', 1, NULL, 1, '2025-11-11 10:14:14'),
(6, 'cvgcnhgmjhk', 4567.00, 'efwbtrnhyjumk', 1, 60, 1, '2025-11-11 10:15:06'),
(7, 'dafsdbg', 345.00, 'dwefrgdthfjgh', 1, 5, 1, '2025-11-21 06:50:53');

-- --------------------------------------------------------

--
-- Table structure for table `servicingtable`
--

CREATE TABLE `servicingtable` (
  `Id` int(15) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `capacity` int(10) DEFAULT NULL,
  `status` int(10) DEFAULT NULL,
  `orderBy` int(10) DEFAULT NULL,
  `DisplayValue` int(10) NOT NULL,
  `createdBy` int(15) DEFAULT NULL,
  `CreatedDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `servicingtable`
--

INSERT INTO `servicingtable` (`Id`, `name`, `capacity`, `status`, `orderBy`, `DisplayValue`, `createdBy`, `CreatedDate`) VALUES
(2, 'Table 1', 4, NULL, 10, 1, NULL, '2025-09-07 18:17:45'),
(3, 'Table 2', 6, NULL, 10, 1, NULL, '2025-09-07 18:12:00');

-- --------------------------------------------------------

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `Id` int(15) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `active` int(10) NOT NULL,
  `orderBy` int(255) DEFAULT NULL,
  `orginfoId` int(15) DEFAULT NULL,
  `createdBy` int(15) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`Id`, `name`, `image`, `active`, `orderBy`, `orginfoId`, `createdBy`, `createddate`) VALUES
(9, '1 sider 2', 'b3b5574e3e21d8ff56e5829d44cf7414.jpg', 1, 0, 1, 1, '2025-09-07 09:20:56'),
(10, '2 slider', '04eac8ddc29a78bd0cc0760fd6e113e8.jpg', 1, 0, 1, 1, '2025-03-01 16:54:15'),
(14, '3 slider', '0c8925e23ab38f06fc9b781a03209e7f.jpg', 1, 0, 1, 1, '2025-03-01 17:11:03');

-- --------------------------------------------------------

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `Id` int(15) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `aadhaar` varchar(255) DEFAULT NULL,
  `pannumber` varchar(255) DEFAULT NULL,
  `roleId` int(15) DEFAULT NULL,
  `startDate` date DEFAULT NULL,
  `EndDate` date DEFAULT NULL,
  `active` int(10) NOT NULL DEFAULT 1,
  `createdby` int(15) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `orgId` int(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` (`Id`, `name`, `phone`, `email`, `aadhaar`, `pannumber`, `roleId`, `startDate`, `EndDate`, `active`, `createdby`, `createddate`, `orgId`) VALUES
(1, 'Omkar Telasang', '07353665845', 'omkartelasang@gmail.com', '46546445654654', 'sdkjhkd ksdhkjhds khjkjsdh', 1256232, '2025-05-12', '2025-05-26', 1, NULL, '2025-05-11 17:58:59', 1),
(2, 'Omkar Telasang', '07353665845', 'omkartelasang@gmail.com', '456454654', '4556464', 1010, '4654-06-07', '2025-05-28', 1, NULL, '2025-05-12 04:07:24', 1);

-- --------------------------------------------------------

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `Id` int(15) NOT NULL,
  `SaleId` int(15) DEFAULT NULL,
  `bookingId` int(15) DEFAULT NULL,
  `PurchaseId` int(15) DEFAULT NULL,
  `BankAccountId` int(15) DEFAULT NULL,
  `AccountHeadId` int(15) DEFAULT NULL,
  `VoucherNo` varchar(15) DEFAULT NULL,
  `TransactionDate` date DEFAULT NULL,
  `Amount` varchar(255) DEFAULT NULL,
  `TransactionTypeId` int(15) DEFAULT NULL,
  `ModTransactionTypeId` int(15) DEFAULT NULL,
  `PaymentMethodId` int(15) DEFAULT NULL,
  `ReferenceNumber` varchar(15) DEFAULT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `OrgAccountId` int(15) DEFAULT NULL,
  `TranReferId` int(15) DEFAULT NULL,
  `StaffId` int(15) DEFAULT NULL,
  `CustomerId` int(15) DEFAULT NULL,
  `VendorId` int(15) DEFAULT NULL,
  `CreatedBy` int(15) DEFAULT NULL,
  `CreatedDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `orgId` int(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` (`Id`, `SaleId`, `bookingId`, `PurchaseId`, `BankAccountId`, `AccountHeadId`, `VoucherNo`, `TransactionDate`, `Amount`, `TransactionTypeId`, `ModTransactionTypeId`, `PaymentMethodId`, `ReferenceNumber`, `Description`, `OrgAccountId`, `TranReferId`, `StaffId`, `CustomerId`, `VendorId`, `CreatedBy`, `CreatedDate`, `orgId`) VALUES
(1, NULL, 2, NULL, NULL, 43, NULL, '2025-12-15', '1295.64', 8, 9, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2025-12-15 16:39:00', 0),
(2, NULL, 4, NULL, NULL, 43, NULL, '2025-12-17', '943.95', 8, 9, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2025-12-17 08:04:19', 0),
(3, NULL, 5, NULL, NULL, 43, NULL, '2025-12-17', '3516.45', 8, 9, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2025-12-17 12:06:37', 0),
(4, NULL, 6, NULL, NULL, 43, NULL, '2025-12-17', '3234.00', 8, 9, 14, '4654', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2025-12-17 12:23:29', 0),
(5, NULL, 8, NULL, 1, 43, NULL, '2025-12-17', '2467.50', 8, 9, 13, '465464', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2025-12-17 12:34:06', 0);

-- --------------------------------------------------------

--
-- Table structure for table `vipicon`
--

CREATE TABLE `vipicon` (
  `Id` int(15) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `icontag` varchar(255) DEFAULT NULL,
  `status` int(15) NOT NULL,
  `orderby` int(15) DEFAULT NULL,
  `createdby` int(15) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vipicon`
--

INSERT INTO `vipicon` (`Id`, `name`, `icontag`, `status`, `orderby`, `createdby`, `createddate`) VALUES
(3, 'vipasdwefgd', 'ghjkdefsdg', 1, 5, 1, '2025-11-20 09:06:01'),
(4, 'BB House', '&lt;i class=&quot;bi bi-house&quot;&gt;&lt;/i&gt;', 1, 5, 1, '2025-11-21 11:51:17'),
(5, 'parking', '<i class=\"fa-solid fa-square-parking\"></i>', 1, 10, 1, '2025-11-21 12:02:03'),
(6, 'parking', '<i class=\"fa-solid fa-square-parking\"></i>', 1, 25, 1, '2025-11-21 12:02:08'),
(7, '91', '<i class=\"bi bi-p-circle\"></i>', 1, 12, 1, '2025-11-21 12:01:33'),
(8, 'No Parking', '<i class=\"bi bi-sign-no-parking\"></i>', 1, 20, 1, '2025-11-21 12:22:20'),
(9, 'yes parking', '<i class=\"bi bi-sign-no-parking\"></i>', 1, 25, 1, '2025-11-21 12:22:56'),
(10, 'swimming', '<i class=\"fa-solid fa-person-swimming\"></i>', 1, 20, 1, '2025-11-24 09:24:39');

-- --------------------------------------------------------

--
-- Table structure for table `vipiconlink`
--

CREATE TABLE `vipiconlink` (
  `Id` int(15) NOT NULL,
  `link` varchar(255) DEFAULT NULL,
  `status` int(15) NOT NULL,
  `orderby` int(15) DEFAULT NULL,
  `createdby` int(15) DEFAULT NULL,
  `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vipiconlink`
--

INSERT INTO `vipiconlink` (`Id`, `link`, `status`, `orderby`, `createdby`, `createddate`) VALUES
(2, '  <link rel=\"stylesheet\" href=\"https://cdnjs.cloudflare.com/ajax/libs/font-awesome/7.0.1/css/all.min.css\">', 1, 10, 1, '2025-11-21 11:48:47'),
(3, '<link rel=\"stylesheet\" href=\"https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.1/font/bootstrap-icons.css\">', 1, 10, NULL, '2025-11-21 11:46:40');

--
-- Indexes for table `amenities`
--
ALTER TABLE `amenities`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `amenitiesgroup`
--
ALTER TABLE `amenitiesgroup`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `balancesheet`
--
ALTER TABLE `balancesheet`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `bankaccount`
--
ALTER TABLE `bankaccount`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `booking_services`
--
ALTER TABLE `booking_services`
  ADD PRIMARY KEY (`Id`),
  ADD KEY `fk_bookingservices_service` (`serviceId`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `clintreviews`
--
ALTER TABLE `clintreviews`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `contactinfo`
--
ALTER TABLE `contactinfo`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `defultconfigure`
--
ALTER TABLE `defultconfigure`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `floor`
--
ALTER TABLE `floor`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `gallery`
--
ALTER TABLE `gallery`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `headaccounts`
--
ALTER TABLE `headaccounts`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `item`
--
ALTER TABLE `item`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `itemcetogery`
--
ALTER TABLE `itemcetogery`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `lookupvalues`
--
ALTER TABLE `lookupvalues`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `orginfo`
--
ALTER TABLE `orginfo`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`payment_id`);

--
-- Indexes for table `profitloss`
--
ALTER TABLE `profitloss`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `purchase`
--
ALTER TABLE `purchase`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `role`
--
ALTER TABLE `role`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `room`
--
ALTER TABLE `room`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `roombookingorder`
--
ALTER TABLE `roombookingorder`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `roomfloor`
--
ALTER TABLE `roomfloor`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `roomreviews`
--
ALTER TABLE `roomreviews`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roomtype`
--
ALTER TABLE `roomtype`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `roomtypeamenities`
--
ALTER TABLE `roomtypeamenities`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `roomtypemedia`
--
ALTER TABLE `roomtypemedia`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `servicingtable`
--
ALTER TABLE `servicingtable`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `slider`
--
ALTER TABLE `slider`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `staff`
--
ALTER TABLE `staff`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `transaction`
--
ALTER TABLE `transaction`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `vipicon`
--
ALTER TABLE `vipicon`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `vipiconlink`
--
ALTER TABLE `vipiconlink`
  ADD PRIMARY KEY (`Id`);

--
-- AUTO_INCREMENT for table `amenities`
--
ALTER TABLE `amenities`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `amenitiesgroup`
--
ALTER TABLE `amenitiesgroup`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `balancesheet`
--
ALTER TABLE `balancesheet`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `bankaccount`
--
ALTER TABLE `bankaccount`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `booking_services`
--
ALTER TABLE `booking_services`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `clintreviews`
--
ALTER TABLE `clintreviews`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `contactinfo`
--
ALTER TABLE `contactinfo`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `defultconfigure`
--
ALTER TABLE `defultconfigure`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `floor`
--
ALTER TABLE `floor`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `headaccounts`
--
ALTER TABLE `headaccounts`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT for table `item`
--
ALTER TABLE `item`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `itemcetogery`
--
ALTER TABLE `itemcetogery`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `lookupvalues`
--
ALTER TABLE `lookupvalues`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `orginfo`
--
ALTER TABLE `orginfo`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `payment_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `profitloss`
--
ALTER TABLE `profitloss`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `purchase`
--
ALTER TABLE `purchase`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `role`
--
ALTER TABLE `role`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `room`
--
ALTER TABLE `room`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `roombookingorder`
--
ALTER TABLE `roombookingorder`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `roomfloor`
--
ALTER TABLE `roomfloor`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roomreviews`
--
ALTER TABLE `roomreviews`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `roomtype`
--
ALTER TABLE `roomtype`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `roomtypeamenities`
--
ALTER TABLE `roomtypeamenities`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `roomtypemedia`
--
ALTER TABLE `roomtypemedia`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `servicingtable`
--
ALTER TABLE `servicingtable`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `staff`
--
ALTER TABLE `staff`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `vipicon`
--
ALTER TABLE `vipicon`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `vipiconlink`
--
ALTER TABLE `vipiconlink`
  MODIFY `Id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `booking_services`
--
ALTER TABLE `booking_services`
  ADD CONSTRAINT `fk_bookingservices_service` FOREIGN KEY (`serviceId`) REFERENCES `services` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

