--
-- Host: localhost    Database: destinyhotels-353031377234
-- ------------------------------------------------------


--
-- Table structure for table `acc_account`
--

CREATE TABLE `acc_account` (
  `account_id` int NOT NULL AUTO_INCREMENT,
  `sector_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `sector_type` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` tinyint(1) NOT NULL,
  `date` date DEFAULT '1970-01-02',
  PRIMARY KEY (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `acc_account`
--


--
-- Table structure for table `acc_account_name`
--

CREATE TABLE `acc_account_name` (
  `account_id` int unsigned NOT NULL AUTO_INCREMENT,
  `account_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `account_type` int NOT NULL,
  PRIMARY KEY (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `acc_account_name`
--

INSERT INTO `acc_account_name` VALUES (1,'Employee Salary',0),(3,'Example',1),(4,'Loan Expense',0),(5,'Loan Income',1);

--
-- Table structure for table `acc_bank`
--

CREATE TABLE `acc_bank` (
  `bank_id` int NOT NULL AUTO_INCREMENT,
  `bank_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `branch_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `account_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `opening_credit` int DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`bank_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `acc_bank`
--

INSERT INTO `acc_bank` VALUES (1,'DBBL','GUlshan','110.101.3243',934875987,1,'2018-06-14'),(2,'CITY bANK','Motijheel','120324234',3452324,1,'2018-06-14'),(3,'Family Bank','sonalux','23456',0,1,'2018-08-16');

--
-- Table structure for table `acc_coa`
--

CREATE TABLE `acc_coa` (
  `HeadCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `HeadName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `PHeadName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `HeadLevel` int NOT NULL,
  `IsActive` tinyint(1) NOT NULL,
  `IsTransaction` tinyint(1) NOT NULL,
  `IsGL` tinyint(1) NOT NULL,
  `HeadType` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `IsBudget` tinyint(1) NOT NULL,
  `IsDepreciation` tinyint(1) NOT NULL,
  `DepreciationRate` decimal(18,2) NOT NULL,
  `CreateBy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `CreateDate` datetime NOT NULL,
  `UpdateBy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `UpdateDate` datetime NOT NULL,
  PRIMARY KEY (`HeadName`),
  KEY `HeadCode` (`HeadCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `acc_coa`
--

INSERT INTO `acc_coa` VALUES ('4021403','AC','Repair and Maintenance',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:33:55','','0000-00-00 00:00:00'),('50202','Account Payable','Current Liabilities',2,1,0,1,'L',0,0,0.00,'admin','2015-10-15 19:50:43','','0000-00-00 00:00:00'),('10203','Account Receivable','Current Asset',2,1,0,0,'A',0,0,0.00,'','0000-00-00 00:00:00','admin','2013-09-18 15:29:35'),('1020201','Advance','Advance, Deposit And Pre-payments',3,1,0,1,'A',0,0,0.00,'Zoherul','2015-05-31 13:29:12','admin','2015-12-31 16:46:32'),('102020103','Advance House Rent','Advance',4,1,1,0,'A',0,0,0.00,'admin','2016-10-02 16:55:38','admin','2016-10-02 16:57:32'),('10202','Advance, Deposit And Pre-payments','Current Asset',2,1,0,1,'A',0,0,0.00,'1','2021-10-02 18:18:36','admin','2015-12-31 16:46:24'),('4020602','Advertisement and Publicity','Promonational Expence',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:51:44','','0000-00-00 00:00:00'),('102010206','AIBL','Cash At Bank',4,1,1,0,'A',0,0,0.00,'1','2021-10-06 09:16:58','','0000-00-00 00:00:00'),('1010410','Air Cooler','Others Assets',3,1,1,0,'A',0,0,0.00,'admin','2016-05-23 12:13:55','','0000-00-00 00:00:00'),('4020603','AIT Against Advertisement','Promonational Expence',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:52:09','','0000-00-00 00:00:00'),('1','Assets','COA',0,1,0,0,'A',0,0,0.00,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('1010204','Attendance Machine','Office Equipment',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:49:31','','0000-00-00 00:00:00'),('40216','Audit Fee','Other Expenses',2,1,1,1,'E',0,0,0.00,'admin','2017-07-18 12:54:30','','0000-00-00 00:00:00'),('102010202','Bank AlFalah','Cash At Bank',4,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:32:37','admin','2015-10-15 15:32:52'),('4021002','Bank Charge','Financial Expenses',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:21:03','','0000-00-00 00:00:00'),('30203','Bank Interest','Other Income',2,1,1,1,'I',0,0,0.00,'Obaidul','2015-01-03 14:49:54','admin','2016-09-25 11:04:19'),('1010104','Book Shelf','Furniture & Fixturers',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:46:11','','0000-00-00 00:00:00'),('1010407','Books and Journal','Others Assets',3,1,1,0,'A',0,0,0.00,'admin','2016-03-27 10:45:37','','0000-00-00 00:00:00'),('4020604','Business Development Expenses','Promonational Expence',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:52:29','','0000-00-00 00:00:00'),('4020606','Campaign Expenses','Promonational Expence',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:52:57','admin','2016-09-19 14:52:48'),('4020502','Campus Rent','House Rent',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:46:53','admin','2017-04-27 17:02:39'),('40212','Car Running Expenses','Other Expenses',2,1,0,1,'E',0,0,0.00,'admin','2015-10-15 19:28:43','','0000-00-00 00:00:00'),('102010304','Card Payment','Online Payment',4,1,1,0,'A',0,0,0.00,'1','2021-09-27 11:56:27','','0000-00-00 00:00:00'),('10201','Cash & Cash Equivalent','Current Asset',2,1,0,1,'A',0,0,0.00,'1','2021-10-02 18:20:00','admin','2015-10-15 15:57:55'),('1020102','Cash At Bank','Cash & Cash Equivalent',3,1,0,1,'A',0,0,0.00,'1','2021-10-02 18:19:42','admin','2015-10-15 15:32:42'),('1020101','Cash In Hand','Cash & Cash Equivalent',3,1,1,0,'A',0,0,0.00,'1','2021-10-02 16:18:59','admin','2016-05-23 12:05:43'),('30101','Cash Sale','Store Income',1,1,1,1,'I',0,0,0.00,'2','2018-07-08 07:51:26','','0000-00-00 00:00:00'),('1010207','CCTV','Office Equipment',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:51:24','','0000-00-00 00:00:00'),('102020102','CEO Current A/C','Advance',4,1,1,0,'A',0,0,0.00,'admin','2016-09-25 11:54:54','','0000-00-00 00:00:00'),('1010101','Class Room Chair','Furniture & Fixturers',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:45:29','','0000-00-00 00:00:00'),('4021407','Close Circuit Cemera','Repair and Maintenance',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:35:35','','0000-00-00 00:00:00'),('4020601','Commision on Admission','Promonational Expence',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:51:21','admin','2016-09-19 14:42:54'),('1010206','Computer','Office Equipment',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:51:09','','0000-00-00 00:00:00'),('4021410','Computer (R)','Repair and Maintenance',3,1,1,0,'E',0,0,0.00,'Zoherul','2016-03-24 12:38:52','Zoherul','2016-03-24 12:41:40'),('1010102','Computer Table','Furniture & Fixturers',3,1,0,0,'A',0,0,0.00,'1','2021-10-24 15:49:49','','0000-00-00 00:00:00'),('301020401','Continuing Registration fee - UoL (Income)','Registration Fee (UOL) Income',4,1,1,0,'I',0,0,0.00,'admin','2015-10-15 17:40:40','','0000-00-00 00:00:00'),('4020904','Contratuall Staff Salary','Salary & Allowances',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:12:34','','0000-00-00 00:00:00'),('403','Cost of Sale','Expense',0,1,1,0,'E',0,0,0.00,'2','2018-07-08 10:37:16','','0000-00-00 00:00:00'),('30102','Credit Sale','Store Income',1,1,1,1,'I',0,0,0.00,'2','2018-07-08 07:51:34','','0000-00-00 00:00:00'),('4020709','Cultural Expense','Miscellaneous Expenses',3,1,1,0,'E',0,0,0.00,'nasmud','2017-04-29 12:45:10','','0000-00-00 00:00:00'),('102','Current Asset','Assets',1,1,0,0,'A',0,0,0.00,'1','2021-11-09 15:53:24','admin','2018-07-07 11:23:00'),('502','Current Liabilities','Liabilities',1,1,0,0,'L',0,0,0.00,'anwarul','2014-08-30 13:18:20','admin','2015-10-15 19:49:21'),('1020301','Customer Receivable','Account Receivable',3,1,0,1,'A',0,0,0.00,'2','2019-01-08 09:15:08','admin','2018-07-07 12:31:42'),('40100002','cw-Chichawatni','Store Expenses',2,1,1,0,'E',0,0,0.00,'2','2018-08-02 16:30:41','','0000-00-00 00:00:00'),('102010205','DBBL','Cash At Bank',4,1,1,0,'A',0,0,0.00,'1','2021-01-14 07:16:29','','0000-00-00 00:00:00'),('1020202','Deposit','Advance, Deposit And Pre-payments',3,1,0,0,'A',0,0,0.00,'admin','2015-10-15 15:40:42','','0000-00-00 00:00:00'),('4020605','Design & Printing Expense','Promonational Expence',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:55:00','','0000-00-00 00:00:00'),('102010201','Dhaka Bank','Cash At Bank',4,1,1,0,'A',0,0,0.00,'1','2021-01-14 07:02:53','','0000-00-00 00:00:00'),('4020404','Dish Bill','Utility Expenses',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:58:21','','0000-00-00 00:00:00'),('40215','Dividend','Other Expenses',2,1,1,1,'E',0,0,0.00,'admin','2016-09-25 14:07:55','','0000-00-00 00:00:00'),('4020403','Drinking Water Bill','Utility Expenses',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:58:10','','0000-00-00 00:00:00'),('1010211','DSLR Camera','Office Equipment',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:53:17','admin','2016-01-02 16:23:25'),('4020908','Earned Leave','Salary & Allowances',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:13:38','','0000-00-00 00:00:00'),('4020607','Education Fair Expenses','Promonational Expence',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:53:42','','0000-00-00 00:00:00'),('1010602','Electric Equipment','Electrical Equipment',3,1,1,0,'A',0,0,0.00,'admin','2016-03-27 10:44:51','','0000-00-00 00:00:00'),('1010203','Electric Kettle','Office Equipment',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:49:07','','0000-00-00 00:00:00'),('10106','Electrical Equipment','Non Current Assets',2,1,0,1,'A',0,0,0.00,'admin','2016-03-27 10:43:44','','0000-00-00 00:00:00'),('4020407','Electricity Bill','Utility Expenses',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:59:31','','0000-00-00 00:00:00'),('40201','Entertainment','Other Expenses',2,1,1,1,'E',0,0,0.00,'admin','2013-07-08 16:21:26','anwarul','2013-07-17 14:21:47'),('2','Equity','COA',0,1,0,0,'L',0,0,0.00,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('4','Expense','COA',0,1,0,0,'E',0,0,0.00,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('4020903','Faculty,Staff Salary & Allowances','Salary & Allowances',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:12:21','','0000-00-00 00:00:00'),('4021404','Fax Machine','Repair and Maintenance',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:34:15','','0000-00-00 00:00:00'),('4020905','Festival & Incentive Bonus','Salary & Allowances',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:12:48','','0000-00-00 00:00:00'),('1010103','File Cabinet','Furniture & Fixturers',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:46:02','','0000-00-00 00:00:00'),('40210','Financial Expenses','Other Expenses',2,1,0,1,'E',0,0,0.00,'anwarul','2013-08-20 12:24:31','admin','2015-10-15 19:20:36'),('1010403','Fire Extingushier','Others Assets',3,1,1,0,'A',0,0,0.00,'admin','2016-03-27 10:39:32','','0000-00-00 00:00:00'),('4021408','Furniture','Repair and Maintenance',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:35:47','','0000-00-00 00:00:00'),('10101','Furniture & Fixturers','Non Current Assets',2,1,0,1,'A',0,0,0.00,'anwarul','2013-08-20 16:18:15','anwarul','2013-08-21 13:35:40'),('4020406','Gas Bill','Utility Expenses',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:59:20','','0000-00-00 00:00:00'),('20201','General Reserve','Reserve & Surplus',2,1,1,0,'L',0,0,0.00,'admin','2016-09-25 14:07:12','admin','2016-10-02 17:48:49'),('10105','Generator','Non Current Assets',2,1,1,1,'A',0,0,0.00,'Zoherul','2016-02-27 16:02:35','admin','2016-05-23 12:05:18'),('4021414','Generator Repair','Repair and Maintenance',3,1,1,0,'E',0,0,0.00,'Zoherul','2016-06-16 10:21:05','','0000-00-00 00:00:00'),('40213','Generator Running Expenses','Other Expenses',2,1,0,1,'E',0,0,0.00,'admin','2015-10-15 19:29:29','','0000-00-00 00:00:00'),('10103','Groceries and Cutleries','Non Current Assets',2,1,1,1,'A',0,0,0.00,'2','2018-07-12 10:02:55','','0000-00-00 00:00:00'),('1010408','Gym Equipment','Others Assets',3,1,1,0,'A',0,0,0.00,'admin','2016-03-27 10:46:03','','0000-00-00 00:00:00'),('30305','Hall Room Service','Service',2,1,1,0,'I',0,0,0.00,'1','2021-12-19 18:52:31','','0000-00-00 00:00:00'),('4020907','Honorarium','Salary & Allowances',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:13:26','','0000-00-00 00:00:00'),('30301','Hotel Room Booking','Service',2,1,1,0,'I',0,0,0.00,'1','2021-10-02 16:52:00','','0000-00-00 00:00:00'),('40205','House Rent','Other Expenses',2,1,0,1,'E',0,0,0.00,'anwarul','2013-08-24 10:26:56','','0000-00-00 00:00:00'),('40100001','HP-Hasilpur','Academic Expenses',2,1,1,0,'E',0,0,0.00,'2','2018-07-29 03:44:23','','0000-00-00 00:00:00'),('4020702','HR Recruitment Expenses','Miscellaneous Expenses',3,1,1,0,'E',0,0,0.00,'admin','2016-09-25 12:55:49','','0000-00-00 00:00:00'),('4020703','Incentive on Admission','Miscellaneous Expenses',3,1,1,0,'E',0,0,0.00,'admin','2016-09-25 12:56:09','','0000-00-00 00:00:00'),('3','Income','COA',0,1,0,0,'I',0,0,0.00,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('30204','Income from Photocopy & Printing','Other Income',2,1,1,1,'I',0,0,0.00,'Zoherul','2015-07-14 10:29:54','admin','2016-09-25 11:04:28'),('5020302','Income Tax Payable','Liabilities for Expenses',3,1,0,1,'L',0,0,0.00,'admin','2016-09-19 11:18:17','admin','2016-09-28 13:18:35'),('102020302','Insurance Premium','Prepayment',4,1,1,0,'A',0,0,0.00,'admin','2016-09-19 13:10:57','','0000-00-00 00:00:00'),('4021001','Interest on Loan','Financial Expenses',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:20:53','admin','2016-09-19 14:53:34'),('4020401','Internet Bill','Utility Expenses',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:56:55','admin','2015-10-15 18:57:32'),('10107','Inventory','Non Current Assets',1,1,1,0,'A',0,0,0.00,'1','2021-10-02 16:45:42','','0000-00-00 00:00:00'),('1010210','LCD TV','Office Equipment',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:52:27','','0000-00-00 00:00:00'),('30103','Lease Sale','Store Income',1,1,1,1,'I',0,0,0.00,'2','2018-07-08 07:51:52','','0000-00-00 00:00:00'),('5','Liabilities','COA',0,1,0,0,'L',0,0,0.00,'admin','2013-07-04 12:32:07','admin','2015-10-15 19:46:54'),('50203','Liabilities for Expenses','Current Liabilities',2,1,0,1,'L',0,0,0.00,'1','2021-10-02 17:02:33','','0000-00-00 00:00:00'),('4020707','Library Expenses','Miscellaneous Expenses',3,1,1,0,'E',0,0,0.00,'admin','2017-01-10 15:34:54','','0000-00-00 00:00:00'),('4021409','Lift','Repair and Maintenance',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:36:12','','0000-00-00 00:00:00'),('50101','Long Term Borrowing','Non Current Liabilities',2,1,0,1,'L',0,0,0.00,'admin','2013-07-04 12:32:26','admin','2015-10-15 19:47:40'),('4020608','Marketing & Promotion Exp.','Promonational Expence',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:53:59','','0000-00-00 00:00:00'),('4020901','Medical Allowance','Salary & Allowances',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:11:33','','0000-00-00 00:00:00'),('1010411','Metal Ditector','Others Assets',3,1,1,0,'A',0,0,0.00,'Zoherul','2016-08-22 10:55:22','','0000-00-00 00:00:00'),('4021413','Micro Oven','Repair and Maintenance',3,1,1,0,'E',0,0,0.00,'Zoherul','2016-05-12 14:53:51','','0000-00-00 00:00:00'),('30202','Miscellaneous (Income)','Other Income',2,1,1,1,'I',0,0,0.00,'anwarul','2014-02-06 15:26:31','admin','2016-09-25 11:04:35'),('4020909','Miscellaneous Benifit','Salary & Allowances',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:13:53','','0000-00-00 00:00:00'),('4020701','Miscellaneous Exp','Miscellaneous Expenses',3,1,1,0,'E',0,0,0.00,'admin','2016-09-25 12:54:39','','0000-00-00 00:00:00'),('40207','Miscellaneous Expenses','Other Expenses',2,1,0,1,'E',0,0,0.00,'anwarul','2014-04-26 16:49:56','admin','2016-09-25 12:54:19'),('1010401','Mobile Phone','Others Assets',3,1,1,0,'A',0,0,0.00,'admin','2016-01-29 10:43:30','','0000-00-00 00:00:00'),('102020101','Mr Ashiqur Rahman','Advance',4,1,1,0,'A',0,0,0.00,'admin','2015-12-31 16:47:23','admin','2016-09-25 11:55:13'),('1010212','Network Accessories','Office Equipment',3,1,1,0,'A',0,0,0.00,'admin','2016-01-02 16:23:32','','0000-00-00 00:00:00'),('4020408','News Paper Bill','Utility Expenses',3,1,1,0,'E',0,0,0.00,'admin','2016-01-02 15:55:57','','0000-00-00 00:00:00'),('101','Non Current Assets','Assets',1,1,0,1,'A',0,0,0.00,'1','2021-10-03 18:21:23','admin','2015-10-15 15:29:11'),('501','Non Current Liabilities','Liabilities',1,1,0,0,'L',0,0,0.00,'anwarul','2014-08-30 13:18:20','admin','2015-10-15 19:49:21'),('1010404','Office Decoration','Others Assets',3,1,1,0,'A',0,0,0.00,'admin','2016-03-27 10:40:02','','0000-00-00 00:00:00'),('10102','Office Equipment','Non Current Assets',2,1,0,1,'A',0,0,0.00,'anwarul','2013-12-06 18:08:00','admin','2015-10-15 15:48:21'),('4021401','Office Repair & Maintenance','Repair and Maintenance',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:33:15','','0000-00-00 00:00:00'),('30201','Office Stationary (Income)','Other Income',2,1,1,1,'I',0,0,0.00,'anwarul','2013-07-17 15:21:06','admin','2016-09-25 11:04:50'),('1020103','Online Payment','Cash & Cash Equivalent',3,1,0,1,'A',0,0,0.00,'1','2021-10-02 18:20:18','','0000-00-00 00:00:00'),('402','Other Expenses','Expense',1,1,0,1,'E',0,0,0.00,'1','2021-10-27 17:56:45','admin','2015-10-15 18:37:42'),('302','Other Income','Income',1,1,0,0,'I',0,0,0.00,'2','2018-07-07 13:40:57','admin','2016-09-25 11:04:09'),('40211','Others (Non Academic Expenses)','Other Expenses',2,1,0,1,'E',0,0,0.00,'Obaidul','2014-12-03 16:05:42','admin','2015-10-15 19:22:09'),('30205','Others (Non-Academic Income)','Other Income',2,1,0,1,'I',0,0,0.00,'admin','2015-10-15 17:23:49','admin','2015-10-15 17:57:52'),('10104','Others Assets','Non Current Assets',2,1,0,1,'A',0,0,0.00,'admin','2016-01-29 10:43:16','','0000-00-00 00:00:00'),('4020910','Outstanding Salary','Salary & Allowances',3,1,1,0,'E',0,0,0.00,'Zoherul','2016-04-24 11:56:50','','0000-00-00 00:00:00'),('4021405','Oven','Repair and Maintenance',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:34:31','','0000-00-00 00:00:00'),('4021412','PABX-Repair','Repair and Maintenance',3,1,1,0,'E',0,0,0.00,'Zoherul','2016-04-24 14:40:18','','0000-00-00 00:00:00'),('4020902','Part-time Staff Salary','Salary & Allowances',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:12:06','','0000-00-00 00:00:00'),('102010301','Paypal','Online Payment',4,1,1,0,'A',0,0,0.00,'1','2021-01-13 10:02:51','','0000-00-00 00:00:00'),('1010202','Photocopy & Fax Machine','Office Equipment',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:47:27','admin','2016-05-23 12:14:40'),('4021411','Photocopy Machine Repair','Repair and Maintenance',3,1,1,0,'E',0,0,0.00,'Zoherul','2016-04-24 12:40:02','admin','2017-04-27 17:03:17'),('3020503','Practical Fee','Others (Non-Academic Income)',3,1,1,1,'I',0,0,0.00,'admin','2017-07-22 18:00:37','','0000-00-00 00:00:00'),('1020203','Prepayment','Advance, Deposit And Pre-payments',3,1,0,1,'A',0,0,0.00,'admin','2015-10-15 15:40:51','admin','2015-12-31 16:49:58'),('1010201','Printer','Office Equipment',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:47:15','','0000-00-00 00:00:00'),('40202','Printing and Stationary','Other Expenses',2,1,1,1,'E',0,0,0.00,'admin','2013-07-08 16:21:45','admin','2016-09-19 14:39:32'),('30207','Professional Training Course(Oracal)','Other Income',2,1,0,1,'I',0,0,0.00,'nasim','2017-06-22 13:24:16','nasim','2017-06-22 13:25:56'),('3020502','Professional Training Course(Oracal-1)','Others (Non-Academic Income)',3,1,1,0,'I',0,0,0.00,'nasim','2017-06-22 13:28:05','','0000-00-00 00:00:00'),('1010208','Projector','Office Equipment',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:51:44','','0000-00-00 00:00:00'),('40206','Promonational Expence','Other Expenses',2,1,0,1,'E',0,0,0.00,'anwarul','2013-07-11 13:48:57','anwarul','2013-07-17 14:23:03'),('102010306','Razorpay','Online Payment',4,1,1,0,'A',0,0,0.00,'1','2022-01-19 10:02:51','','0000-00-00 00:00:00'),('40214','Repair and Maintenance','Other Expenses',2,1,0,1,'E',0,0,0.00,'admin','2015-10-15 19:32:46','','0000-00-00 00:00:00'),('202','Reserve & Surplus','Equity',1,1,0,1,'L',0,0,0.00,'admin','2016-09-25 14:06:34','admin','2016-10-02 17:48:57'),('30303','Restaurant Food','Service',2,1,1,0,'I',0,0,0.00,'1','2021-10-02 16:52:31','','0000-00-00 00:00:00'),('20102','Retained Earnings','Share Holders Equity',2,1,1,1,'L',0,0,0.00,'admin','2016-05-23 11:20:40','admin','2016-09-25 14:05:06'),('4020708','River Cruse','Miscellaneous Expenses',3,1,1,0,'E',0,0,0.00,'admin','2017-04-24 15:35:25','','0000-00-00 00:00:00'),('102020105','Salary','Advance',4,1,0,1,'A',0,0,0.00,'1','2021-10-02 16:20:05','','0000-00-00 00:00:00'),('40209','Salary & Allowances','Other Expenses',2,1,0,1,'E',0,0,0.00,'anwarul','2013-12-12 11:22:58','','0000-00-00 00:00:00'),('404','Sale Discount','Expense',1,1,1,0,'E',0,0,0.00,'2','2018-07-19 10:15:11','','0000-00-00 00:00:00'),('1010406','Security Equipment','Others Assets',3,1,1,0,'A',0,0,0.00,'admin','2016-03-27 10:41:30','','0000-00-00 00:00:00'),('303','Service','Income',1,1,0,1,'I',0,0,0.00,'1','2021-09-27 11:37:54','','0000-00-00 00:00:00'),('30304','Service Charge','Service',2,1,1,0,'I',0,0,0.00,'1','2021-10-05 09:42:19','','0000-00-00 00:00:00'),('20101','Share Capital','Share Holders Equity',2,1,0,1,'L',0,0,0.00,'anwarul','2013-12-08 19:37:32','admin','2015-10-15 19:45:35'),('201','Share Holders Equity','Equity',1,1,0,0,'L',0,0,0.00,'','0000-00-00 00:00:00','admin','2015-10-15 19:43:51'),('50201','Short Term Borrowing','Current Liabilities',2,1,0,1,'L',0,0,0.00,'admin','2015-10-15 19:50:30','','0000-00-00 00:00:00'),('40208','Software Development Expenses','Other Expenses',2,1,0,1,'E',0,0,0.00,'anwarul','2013-11-21 14:13:01','admin','2015-10-15 19:02:51'),('4020906','Special Allowances','Salary & Allowances',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:13:13','','0000-00-00 00:00:00'),('50102','Sponsors Loan','Non Current Liabilities',2,1,0,1,'L',0,0,0.00,'admin','2015-10-15 19:48:02','','0000-00-00 00:00:00'),('4020706','Sports Expense','Miscellaneous Expenses',3,1,1,0,'E',0,0,0.00,'nasmud','2016-11-09 13:16:53','','0000-00-00 00:00:00'),('102010302','SSLCOMMERZ','Online Payment',4,1,1,0,'A',0,0,0.00,'1','2021-01-13 10:04:24','','0000-00-00 00:00:00'),('102010203','Standard Bank','Cash At Bank',4,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:33:33','admin','2015-10-15 15:33:48'),('102010204','State Bank','Cash At Bank',4,1,1,0,'A',0,0,0.00,'1','2021-01-14 07:22:24','','0000-00-00 00:00:00'),('401','Store Expenses','Expense',1,1,0,0,'E',0,0,0.00,'2','2018-07-07 13:38:59','admin','2015-10-15 17:58:46'),('301','Store Income','Income',1,1,0,0,'I',0,0,0.00,'2','2018-07-07 13:40:37','admin','2015-09-17 17:00:02'),('102010305','Stripe','Online Payment',4,1,1,0,'A',0,0,0.00,'1','2021-12-06 10:02:51','','0000-00-00 00:00:00'),('3020501','Students Info. Correction Fee','Others (Non-Academic Income)',3,1,1,0,'I',0,0,0.00,'admin','2015-10-15 17:24:45','','0000-00-00 00:00:00'),('1010601','Sub Station','Electrical Equipment',3,1,1,0,'A',0,0,0.00,'admin','2016-03-27 10:44:11','','0000-00-00 00:00:00'),('5020205','Suppliers','Account Payable',3,1,0,1,'L',0,0,0.00,'2','2018-12-15 06:50:12','','0000-00-00 00:00:00'),('5020303','TAX Payable','Liabilities for Expenses',3,1,1,0,'L',0,0,0.00,'1','2021-10-02 17:03:25','','0000-00-00 00:00:00'),('1020204','TAX Receivable','Advance, Deposit And Pre-payments',3,0,1,0,'A',0,0,0.00,'1','2021-10-04 12:29:26','','0000-00-00 00:00:00'),('4020704','TB Care Expenses','Miscellaneous Expenses',3,1,1,0,'E',0,0,0.00,'admin','2016-10-08 13:03:04','','0000-00-00 00:00:00'),('30206','TB Care Income','Other Income',2,1,1,1,'I',0,0,0.00,'admin','2016-10-08 13:00:56','','0000-00-00 00:00:00'),('4020501','TDS on House Rent','House Rent',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:44:07','admin','2016-09-19 14:40:16'),('502030201','TDS Payable House Rent','Income Tax Payable',4,1,1,0,'L',0,0,0.00,'admin','2016-09-19 11:19:42','admin','2016-09-28 13:19:37'),('502030203','TDS Payable on Advertisement Bill','Income Tax Payable',4,1,1,0,'L',0,0,0.00,'admin','2016-09-28 13:20:51','','0000-00-00 00:00:00'),('502030202','TDS Payable on Salary','Income Tax Payable',4,1,1,0,'L',0,0,0.00,'admin','2016-09-28 13:20:17','','0000-00-00 00:00:00'),('4021402','Tea Kettle','Repair and Maintenance',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:33:45','','0000-00-00 00:00:00'),('4020402','Telephone Bill','Utility Expenses',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:57:59','','0000-00-00 00:00:00'),('1010209','Telephone Set & PABX','Office Equipment',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:51:57','admin','2016-10-02 17:10:40'),('40203','Travelling & Conveyance','Other Expenses',2,1,1,1,'E',0,0,0.00,'admin','2013-07-08 16:22:06','admin','2015-10-15 18:45:13'),('4021406','TV','Repair and Maintenance',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 19:35:07','','0000-00-00 00:00:00'),('1010205','UPS','Office Equipment',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:50:38','','0000-00-00 00:00:00'),('40204','Utility Expenses','Other Expenses',2,1,0,1,'E',0,0,0.00,'anwarul','2013-07-11 16:20:24','admin','2016-01-02 15:55:22'),('4020503','VAT on House Rent Exp','House Rent',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:49:22','admin','2016-09-25 14:00:52'),('5020301','VAT Payable','Liabilities for Expenses',3,0,1,0,'L',0,0,0.00,'1','2021-10-28 09:56:55','admin','2016-09-28 13:23:53'),('1010409','Vehicle A/C','Others Assets',3,1,1,0,'A',0,0,0.00,'Zoherul','2016-05-12 12:13:21','','0000-00-00 00:00:00'),('1010405','Voltage Stablizer','Others Assets',3,1,1,0,'A',0,0,0.00,'admin','2016-03-27 10:40:59','','0000-00-00 00:00:00'),('1010105','Waiting Sofa - Steel','Furniture & Fixturers',3,1,1,0,'A',0,0,0.00,'admin','2015-10-15 15:46:29','','0000-00-00 00:00:00'),('102030101','Walk in Customer','Customer Receivable',4,1,1,0,'A',0,0,0.00,'1','2021-10-02 16:44:50','','0000-00-00 00:00:00'),('4020405','WASA Bill','Utility Expenses',3,1,1,0,'E',0,0,0.00,'admin','2015-10-15 18:58:51','','0000-00-00 00:00:00'),('1010402','Water Purifier','Others Assets',3,1,1,0,'A',0,0,0.00,'admin','2016-01-29 11:14:11','','0000-00-00 00:00:00'),('4020705','Website Development Expenses','Miscellaneous Expenses',3,1,1,0,'E',0,0,0.00,'admin','2016-10-15 12:42:47','','0000-00-00 00:00:00');

--
-- Table structure for table `acc_customer_income`
--

CREATE TABLE `acc_customer_income` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `Customer_Id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `VNo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `Date` date NOT NULL,
  `Amount` decimal(10,2) NOT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `acc_customer_income`
--


--
-- Table structure for table `acc_glsummarybalance`
--

CREATE TABLE `acc_glsummarybalance` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `COAID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Debit` decimal(18,2) DEFAULT NULL,
  `Credit` decimal(18,2) DEFAULT NULL,
  `FYear` int DEFAULT NULL,
  `CreateBy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `acc_glsummarybalance`
--


--
-- Table structure for table `acc_income_expence`
--

CREATE TABLE `acc_income_expence` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `VNo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `Vtype` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Date` date NOT NULL,
  `Paymode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `Perpose` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Narration` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `StoreID` int NOT NULL,
  `COAID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `Amount` decimal(10,2) NOT NULL,
  `IsApprove` tinyint NOT NULL,
  `CreateBy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `CreateDate` datetime NOT NULL,
  UNIQUE KEY `ID` (`ID`),
  KEY `VNo` (`VNo`,`IsApprove`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `acc_income_expence`
--


--
-- Table structure for table `acc_temp`
--

CREATE TABLE `acc_temp` (
  `COAID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `Name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `Debit` decimal(18,2) NOT NULL,
  `Credit` decimal(18,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `acc_temp`
--


--
-- Table structure for table `acc_transaction`
--

CREATE TABLE `acc_transaction` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `VNo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Vtype` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `VDate` date DEFAULT NULL,
  `COAID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `Narration` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `Debit` decimal(18,2) DEFAULT NULL,
  `Credit` decimal(18,2) DEFAULT NULL,
  `StoreID` int NOT NULL,
  `IsPosted` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CreateBy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL,
  `UpdateBy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `UpdateDate` datetime DEFAULT NULL,
  `IsAppove` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  UNIQUE KEY `ID` (`ID`),
  KEY `COAID` (`COAID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `acc_transaction`
--

INSERT INTO `acc_transaction` VALUES (1,'000001','CIV','2024-07-13','1020101','Cash in Hand Debited For advance payment Invoice# 000001',100.00,0.00,0,'1','1','2024-07-13 10:45:36',NULL,NULL,'1'),(2,'000001','CIV','2024-07-13','30301','Hotel credited for room advance rent Invoice# 000001',0.00,100.00,0,'1','1','2024-07-13 10:45:36',NULL,NULL,'1'),(3,'000001','CIV','2024-07-13','102030101','Hotel customer debited for advance room booking Invoice# 000001',100.00,0.00,0,'1','1','2024-07-13 10:45:36',NULL,NULL,'1'),(4,'000001','CIV','2024-07-13','102030101','Hotel customer credited for advance room booking Invoice# 000001',0.00,100.00,0,'1','1','2024-07-13 10:45:36',NULL,NULL,'1');

--
-- Table structure for table `accesslog`
--

CREATE TABLE `accesslog` (
  `sl_no` bigint NOT NULL AUTO_INCREMENT,
  `action_page` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `action_done` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `entry_date` datetime DEFAULT NULL,
  PRIMARY KEY (`sl_no`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `accesslog`
--

INSERT INTO `accesslog` VALUES (1,'Add Category','Insert Data','Category is Created','','2024-07-13 10:47:35'),(2,'Add Food','Insert Data','New Food Added','','2024-07-13 10:48:48'),(3,'Varient List','Insert Data','New Varient Created','','2024-07-13 10:49:33'),(4,'Table Floor List','Insert Data','New table Floor Created','','2024-07-13 10:52:11'),(5,'Table List','Insert Data','New table Created','','2024-07-13 10:53:01');

--
-- Table structure for table `add_ons`
--

CREATE TABLE `add_ons` (
  `add_on_id` int NOT NULL AUTO_INCREMENT,
  `add_on_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `is_active` tinyint NOT NULL,
  `tax0` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `tax1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`add_on_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `add_ons`
--


--
-- Table structure for table `award`
--

CREATE TABLE `award` (
  `award_id` int NOT NULL AUTO_INCREMENT,
  `award_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `aw_description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `awr_gift_item` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` date NOT NULL,
  `employee_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `awarded_by` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`award_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `award`
--


--
-- Table structure for table `bedstype`
--

CREATE TABLE `bedstype` (
  `Bedstypeid` int NOT NULL AUTO_INCREMENT,
  `bedstypetitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`Bedstypeid`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bedstype`
--

INSERT INTO `bedstype` VALUES (12,'Electric bed'),(13,'Standard Double'),(14,'Queen Bed'),(15,'Olympic Queen'),(16,'King Bed');

--
-- Table structure for table `bill`
--

CREATE TABLE `bill` (
  `bill_id` bigint NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL,
  `order_id` bigint NOT NULL,
  `total_amount` float NOT NULL,
  `discount` float NOT NULL,
  `service_charge` float NOT NULL,
  `shipping_type` int DEFAULT NULL COMMENT '1=home,2=pickup,3=none',
  `delivarydate` datetime DEFAULT NULL,
  `VAT` float NOT NULL,
  `bill_amount` float NOT NULL,
  `bill_date` date NOT NULL,
  `bill_time` time NOT NULL,
  `create_at` datetime DEFAULT '1970-01-01 01:01:01',
  `bill_status` tinyint(1) NOT NULL COMMENT '0=unpaid, 1=paid',
  `payment_method_id` tinyint NOT NULL,
  `create_by` int NOT NULL,
  `create_date` date NOT NULL,
  `update_by` int NOT NULL,
  `update_date` date NOT NULL,
  PRIMARY KEY (`bill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bill`
--


--
-- Table structure for table `bill_card_payment`
--

CREATE TABLE `bill_card_payment` (
  `row_id` bigint NOT NULL AUTO_INCREMENT,
  `bill_id` bigint NOT NULL,
  `multipay_id` int DEFAULT NULL,
  `card_no` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `terminal_name` int NOT NULL,
  `bank_name` int DEFAULT NULL,
  PRIMARY KEY (`row_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bill_card_payment`
--


--
-- Table structure for table `booked_details`
--

CREATE TABLE `booked_details` (
  `book_detailsid` int NOT NULL AUTO_INCREMENT,
  `bookedid` int NOT NULL,
  `booking_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `booking_source` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `booking_source_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `extracheckin` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `extracheckout` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `arival_from` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `purpose` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `extra_facility_days` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `extrabed` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `extraperson` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `extrachild` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `complementary` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `complementaryprice` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `discountreason` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `discountamount` decimal(10,2) DEFAULT NULL,
  `commissionpersent` int DEFAULT NULL,
  `commissionamount` decimal(10,2) DEFAULT NULL,
  `payment_method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `advance_amount` decimal(10,2) DEFAULT NULL,
  `advance_remarks` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `remarks` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `booked_from` int DEFAULT '0' COMMENT '0=admin,1=user',
  PRIMARY KEY (`book_detailsid`),
  KEY `bookedid` (`bookedid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `booked_details`
--

INSERT INTO `booked_details` VALUES (1,1,'1','','','2024-07-13 04:48','2024-07-14 04:00','','','1','0','0','0','ChooseComplementary','0','',0.00,0,0.00,'Cash Payment',100.00,'','',0);

--
-- Table structure for table `booked_info`
--

CREATE TABLE `booked_info` (
  `bookedid` int NOT NULL AUTO_INCREMENT,
  `booking_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date_time` datetime NOT NULL,
  `roomid` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `nuofpeople` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
  `children` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `total_room` int NOT NULL DEFAULT '0',
  `room_no` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `roomrate` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `promocode` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `total_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `paid_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `offer_discount` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0.00',
  `full_guest_name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `special_request` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `coments` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `checkindate` datetime NOT NULL,
  `checkoutdate` datetime NOT NULL,
  `cutomerid` int NOT NULL,
  `bookingstatus` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '0=pending,1=cancel,2=success,3=finish,4=checkin,5=checkout',
  `isSeen` int DEFAULT '0',
  PRIMARY KEY (`bookedid`),
  KEY `cutomerid` (`cutomerid`,`bookingstatus`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `booked_info`
--

INSERT INTO `booked_info` VALUES (1,'00000001','2024-07-13 10:45:36','1','2','0',1,'1','150',NULL,150.00,100.00,'0','Mr John Doe',NULL,'Booking from admin','2024-07-13 04:48:00','2024-07-14 04:00:00',1,'4',1);

--
-- Table structure for table `bookingtype`
--

CREATE TABLE `bookingtype` (
  `booktypeid` int NOT NULL AUTO_INCREMENT,
  `booktypetitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`booktypeid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bookingtype`
--

INSERT INTO `bookingtype` VALUES (1,'Single '),(2,'Company');

--
-- Table structure for table `candidate_basic_info`
--

CREATE TABLE `candidate_basic_info` (
  `can_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `first_name` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `last_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `alter_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `present_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `parmanent_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `picture` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `ssn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `state` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `city` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `zip` int NOT NULL,
  PRIMARY KEY (`can_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `candidate_basic_info`
--


--
-- Table structure for table `candidate_education_info`
--

CREATE TABLE `candidate_education_info` (
  `can_edu_id` int NOT NULL AUTO_INCREMENT,
  `can_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `degree_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `university_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `cgp` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `comments` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sequencee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`can_edu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `candidate_education_info`
--


--
-- Table structure for table `candidate_interview`
--

CREATE TABLE `candidate_interview` (
  `can_int_id` int NOT NULL AUTO_INCREMENT,
  `can_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `job_adv_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `interview_date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `interviewer_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `interview_marks` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `written_total_marks` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `mcq_total_marks` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `total_marks` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `recommandation` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `selection` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `details` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`can_int_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `candidate_interview`
--


--
-- Table structure for table `candidate_selection`
--

CREATE TABLE `candidate_selection` (
  `can_sel_id` int NOT NULL AUTO_INCREMENT,
  `can_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `employee_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `pos_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `selection_terms` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`can_sel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `candidate_selection`
--


--
-- Table structure for table `candidate_shortlist`
--

CREATE TABLE `candidate_shortlist` (
  `can_short_id` int NOT NULL AUTO_INCREMENT,
  `can_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `job_adv_id` int NOT NULL,
  `date_of_shortlist` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `interview_date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`can_short_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `candidate_shortlist`
--


--
-- Table structure for table `candidate_workexperience`
--

CREATE TABLE `candidate_workexperience` (
  `can_workexp_id` int NOT NULL AUTO_INCREMENT,
  `can_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `company_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `working_period` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `duties` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `supervisor` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `sequencee` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`can_workexp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `candidate_workexperience`
--


--
-- Table structure for table `check_addones`
--

CREATE TABLE `check_addones` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_menuid` int NOT NULL,
  `sub_order_id` int NOT NULL,
  `status` tinyint DEFAULT NULL COMMENT '1=insert, 0=notinserted',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `check_addones`
--


--
-- Table structure for table `common_setting`
--

CREATE TABLE `common_setting` (
  `id` int NOT NULL AUTO_INCREMENT,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `logo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `login_logo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `footer_logo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `invoice_logo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `powerbytxt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `common_setting`
--

INSERT INTO `common_setting` VALUES (1,NULL,'','','assets/img/2025-01-26/U.png','assets/img/2025-01-28/U.png','assets/img/2025-01-28/U3.png','assets/img/2025-01-28/U2.png','Desenvolvido por IlloStarUp\r\n');

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `currencyid` int NOT NULL AUTO_INCREMENT,
  `currencyname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `curr_icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `position` int NOT NULL DEFAULT '1' COMMENT '1=left.2=right',
  `curr_rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`currencyid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` VALUES (2,'USD','$',1,1.00),(4,'Real','R$',1,1.00);

--
-- Table structure for table `custom_table`
--

CREATE TABLE `custom_table` (
  `custom_id` int NOT NULL AUTO_INCREMENT,
  `custom_field` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `custom_data_type` int NOT NULL,
  `custom_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `employee_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`custom_id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `custom_table`
--

INSERT INTO `custom_table` VALUES (9,'Teacher Name',2,'Abdul Halim','EF6MQRAX'),(12,'Primary School',1,'Test Primary School','E4ZNFBIC'),(13,'High School Name',2,'Taker Hat High school','E4ZNFBIC'),(14,'Versity Name',3,'Nu','E4ZNFBIC'),(15,'Company Name',1,'Bdtask','ER6RJAY8'),(16,'House Name',3,'Shikder Bari','ER6RJAY8'),(17,'Person name',2,'Tuhin','ER6RJAY8'),(21,'customfield1',1,'custom value1','E0LHJ447'),(22,'dsfsdf',1,'sdfdsf','E0LHJ447'),(23,'dsfsd',1,'fdsfsdf','E0LHJ447'),(24,'',1,'','E0LHJ447'),(25,'',1,'','E0LHJ447'),(34,'isahadf',1,'23424','ELPGMMRL'),(35,'dfsdf',1,'dfgdfg','ELPGMMRL'),(36,'hhh',1,'sdfsdf','ELPGMMRL'),(37,'fdfgdfg',1,'dfg','ELPGMMRL'),(38,'dfgdfg',1,'','ELPGMMRL'),(39,'First isahaq',1,'sdfsdf','E4K0I0DA'),(40,'sdfsadf',1,'sdfsdf','EYOBEEFQ'),(41,'fsdfsadf',1,'234234324','EHBEEFQQ'),(43,'My Mother',1,'Ma','E4Y9T7CJ'),(44,'rrrr',2,'07-08-2018','E78PIKVA'),(57,'Chinese Cuisine',1,'coffee roastery located on a busy corner site in Farringdon\'s Exmouth Market. With glazed frontage on two sides ','EU3APTYY'),(58,'French Suicine',1,'coffee roastery located on a busy corner site in Farringdon\'s Exmouth Market. With glazed frontage on two sides ','EXL9WSCL'),(59,'Chinese Cuisine',1,'coffee roastery located on a busy corner site in Farringdon\'s Exmouth Market. With glazed frontage on two sides ','E3Y1WJMB'),(60,'Kitchen Lead',1,'coffee roastery located on a busy corner site in Farringdon\'s Exmouth Market. With glazed frontage on two sides ','EBK2UPRA');

--
-- Table structure for table `customer_order`
--

CREATE TABLE `customer_order` (
  `order_id` bigint NOT NULL AUTO_INCREMENT,
  `saleinvoice` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `marge_order_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `customer_id` int NOT NULL,
  `cutomertype` int NOT NULL,
  `isthirdparty` int NOT NULL DEFAULT '0' COMMENT '0=normal,1>all Third Party',
  `thirdpartyinvoiceid` int DEFAULT NULL,
  `waiter_id` int DEFAULT NULL,
  `kitchen` int DEFAULT NULL,
  `order_date` date NOT NULL,
  `order_time` time NOT NULL,
  `cookedtime` time NOT NULL DEFAULT '00:15:00',
  `table_no` int DEFAULT NULL,
  `tokenno` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `totalamount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `customerpaid` decimal(10,2) DEFAULT '0.00',
  `customer_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `anyreason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `order_status` tinyint(1) NOT NULL COMMENT '1=Pending, 2=Processing, 3=Ready, 4=Served,5=Cancel',
  `nofification` int NOT NULL DEFAULT '0' COMMENT '0=unseen,1=seen',
  `orderacceptreject` int DEFAULT NULL,
  `splitpay_status` tinyint NOT NULL DEFAULT '0' COMMENT '0=no split,1=split',
  `isupdate` int DEFAULT NULL,
  `shipping_date` datetime DEFAULT '1790-01-01 01:01:01',
  `tokenprint` int NOT NULL DEFAULT '0' COMMENT '1=print done,0=not done',
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customer_order`
--


--
-- Table structure for table `customer_type`
--

CREATE TABLE `customer_type` (
  `customer_type_id` int NOT NULL AUTO_INCREMENT,
  `customer_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ordering` int DEFAULT '0',
  PRIMARY KEY (`customer_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customer_type`
--

INSERT INTO `customer_type` VALUES (1,'Walk In Customer',1),(2,'Online Customer',1),(3,'Third Party',0),(4,'Take Way',0),(5,'QR Customer',0),(6,'Hotel Customer',1);

--
-- Table structure for table `dbt_blocklist`
--

CREATE TABLE `dbt_blocklist` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `ip_mail` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dbt_blocklist`
--


--
-- Table structure for table `dbt_security`
--

CREATE TABLE `dbt_security` (
  `id` int NOT NULL AUTO_INCREMENT,
  `keyword` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dbt_security`
--


--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `dept_id` int NOT NULL AUTO_INCREMENT,
  `department_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `parent_id` int NOT NULL,
  PRIMARY KEY (`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `department`
--


--
-- Table structure for table `duty_type`
--

CREATE TABLE `duty_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `duty_type`
--

INSERT INTO `duty_type` VALUES (1,'Full Time'),(2,'Part Time'),(3,'Contructual'),(4,'Other');

--
-- Table structure for table `emp_attendance`
--

CREATE TABLE `emp_attendance` (
  `att_id` int unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `sign_in` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_out` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `staytime` time DEFAULT NULL,
  PRIMARY KEY (`att_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `emp_attendance`
--


--
-- Table structure for table `employee_benifit`
--

CREATE TABLE `employee_benifit` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bnf_cl_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `bnf_cl_code_des` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `bnff_acural_date` date NOT NULL,
  `bnf_status` tinyint NOT NULL,
  `employee_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee_benifit`
--


--
-- Table structure for table `employee_history`
--

CREATE TABLE `employee_history` (
  `emp_his_id` int NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `pos_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `first_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `middle_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `last_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `alter_phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `present_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `parmanent_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `picture` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `degree_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `university_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cgp` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `passing_year` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `company_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `working_period` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `duties` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `supervisor` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `signature` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `is_admin` int NOT NULL DEFAULT '0',
  `dept_id` int DEFAULT NULL,
  `division_id` int NOT NULL,
  `maiden_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `state` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `city` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `zip` int NOT NULL,
  `citizenship` int NOT NULL,
  `duty_type` int NOT NULL,
  `hire_date` date NOT NULL,
  `original_hire_date` date NOT NULL,
  `termination_date` date NOT NULL,
  `termination_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `voluntary_termination` int NOT NULL,
  `rehire_date` date NOT NULL,
  `rate_type` int NOT NULL,
  `rate` float NOT NULL,
  `pay_frequency` int NOT NULL,
  `pay_frequency_txt` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `hourly_rate2` float NOT NULL,
  `hourly_rate3` float NOT NULL,
  `home_department` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `department_text` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `class_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `class_code_desc` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `class_acc_date` date NOT NULL,
  `class_status` tinyint NOT NULL,
  `is_super_visor` int DEFAULT NULL,
  `super_visor_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `supervisor_report` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `dob` date NOT NULL,
  `gender` int NOT NULL,
  `country` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `marital_status` int NOT NULL,
  `ethnic_group` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `eeo_class_gp` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ssn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `work_in_state` int NOT NULL,
  `live_in_state` int NOT NULL,
  `home_email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `business_email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `home_phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `business_phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `cell_phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `emerg_contct` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `emrg_h_phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `emrg_w_phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `emgr_contct_relation` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `alt_em_contct` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `alt_emg_h_phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `alt_emg_w_phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`emp_his_id`),
  KEY `employee_id` (`employee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee_history`
--


--
-- Table structure for table `employee_performance`
--

CREATE TABLE `employee_performance` (
  `emp_per_id` int unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `note` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `note_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `number_of_star` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `updated_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`emp_per_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee_performance`
--


--
-- Table structure for table `employee_sal_pay_type`
--

CREATE TABLE `employee_sal_pay_type` (
  `emp_sal_pay_type_id` int unsigned NOT NULL,
  `payment_period` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee_sal_pay_type`
--


--
-- Table structure for table `employee_salary_payment`
--

CREATE TABLE `employee_salary_payment` (
  `emp_sal_pay_id` int unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `total_salary` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `total_working_minutes` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `working_period` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `payment_due` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `payment_date` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `paid_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`emp_sal_pay_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee_salary_payment`
--


--
-- Table structure for table `employee_salary_setup`
--

CREATE TABLE `employee_salary_setup` (
  `e_s_s_id` int unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `sal_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `salary_type_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `create_date` date DEFAULT NULL,
  `update_date` datetime(6) DEFAULT NULL,
  `update_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `gross_salary` float NOT NULL,
  PRIMARY KEY (`e_s_s_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee_salary_setup`
--


--
-- Table structure for table `foodvariable`
--

CREATE TABLE `foodvariable` (
  `availableID` int NOT NULL AUTO_INCREMENT,
  `foodid` int NOT NULL,
  `availtime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `availday` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `is_active` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`availableID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `foodvariable`
--


--
-- Table structure for table `gender`
--

CREATE TABLE `gender` (
  `id` int NOT NULL AUTO_INCREMENT,
  `gender_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `gender`
--

INSERT INTO `gender` VALUES (1,'Male'),(2,'Female'),(3,'Other');

--
-- Table structure for table `grand_loan`
--

CREATE TABLE `grand_loan` (
  `loan_id` int NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `permission_by` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `loan_details` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `interest_rate` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `installment` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `installment_period` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `repayment_amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date_of_approve` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `repayment_start_date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_by` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `updated_by` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `loan_status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`loan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `grand_loan`
--


--
-- Table structure for table `item_category`
--

CREATE TABLE `item_category` (
  `CategoryID` int NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CategoryImage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Position` int DEFAULT NULL,
  `CategoryIsActive` int DEFAULT NULL,
  `offerstartdate` date DEFAULT '0000-00-00',
  `offerendate` date NOT NULL DEFAULT '0000-00-00',
  `isoffer` int DEFAULT '0',
  `parentid` int DEFAULT '0',
  `UserIDInserted` int NOT NULL DEFAULT '0',
  `UserIDUpdated` int NOT NULL DEFAULT '0',
  `UserIDLocked` int NOT NULL DEFAULT '0',
  `DateInserted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `DateUpdated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `DateLocked` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`CategoryID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `item_category`
--

INSERT INTO `item_category` VALUES (1,'Breakfast',NULL,NULL,1,'0000-00-00','0000-00-00',0,0,1,1,1,'2024-07-13 10:47:35','2024-07-13 10:47:35','2024-07-13 10:47:35');

--
-- Table structure for table `item_foods`
--

CREATE TABLE `item_foods` (
  `ProductsID` int NOT NULL AUTO_INCREMENT,
  `CategoryID` int NOT NULL,
  `ProductName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ProductImage` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bigthumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `medium_thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `small_thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `component` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `descrip` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `itemnotes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `menutype` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `productvat` int DEFAULT '0',
  `special` int NOT NULL DEFAULT '0',
  `OffersRate` int NOT NULL DEFAULT '0' COMMENT '1=offer rate',
  `offerIsavailable` int NOT NULL DEFAULT '0' COMMENT '1=offer available,0=No Offer',
  `offerstartdate` date DEFAULT '0000-00-00',
  `offerendate` date DEFAULT '0000-00-00',
  `Position` int DEFAULT NULL,
  `kitchenid` int NOT NULL,
  `isgroup` int DEFAULT NULL,
  `is_customqty` int DEFAULT '0',
  `cookedtime` time NOT NULL DEFAULT '00:00:00',
  `ProductsIsActive` int DEFAULT NULL,
  `UserIDInserted` int NOT NULL DEFAULT '0',
  `UserIDUpdated` int NOT NULL DEFAULT '0',
  `UserIDLocked` int NOT NULL DEFAULT '0',
  `DateInserted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `DateUpdated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `DateLocked` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `tax0` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `tax1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`ProductsID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `item_foods`
--

INSERT INTO `item_foods` VALUES (1,1,'French Toast','','','','','bread,butter,milk','','','',2,0,0,0,'0000-00-00','0000-00-00',NULL,0,NULL,NULL,'00:10:00',1,1,1,1,'2024-07-13 10:48:48','2024-07-13 10:48:48','2024-07-13 10:48:48',NULL,NULL);

--
-- Table structure for table `job_advertisement`
--

CREATE TABLE `job_advertisement` (
  `job_adv_id` int unsigned NOT NULL,
  `pos_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `adv_circular_date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `circular_dadeline` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `adv_file` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `adv_details` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `job_advertisement`
--


--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `id` int NOT NULL AUTO_INCREMENT,
  `phrase` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `english` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `malay` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `french` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `german` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `spanish` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `turkish` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `hindi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `portuguesbr` text COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2137 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `language`
--



--
-- Table structure for table `leave_apply`
--

CREATE TABLE `leave_apply` (
  `leave_appl_id` int NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `leave_type_id` int NOT NULL,
  `apply_strt_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `apply_end_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `apply_day` int NOT NULL,
  `leave_aprv_strt_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `leave_aprv_end_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `num_aprv_day` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `reason` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `apply_hard_copy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `apply_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `approve_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `approved_by` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `leave_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`leave_appl_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `leave_apply`
--


--
-- Table structure for table `leave_type`
--

CREATE TABLE `leave_type` (
  `leave_type_id` int NOT NULL AUTO_INCREMENT,
  `leave_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `leave_days` int NOT NULL,
  PRIMARY KEY (`leave_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `leave_type`
--

INSERT INTO `leave_type` VALUES (3,'Paid Leave',10),(4,'Paternity Leave',45),(5,'Medical Leave',7),(6,'Unpaid Leave',5);

--
-- Table structure for table `loan_installment`
--

CREATE TABLE `loan_installment` (
  `loan_inst_id` int NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(21) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `loan_id` varchar(21) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `installment_amount` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `payment` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `received_by` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `installment_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1',
  `notes` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`loan_inst_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `loan_installment`
--


--
-- Table structure for table `marital_info`
--

CREATE TABLE `marital_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `marital_sta` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `marital_info`
--


--
-- Table structure for table `membership`
--

CREATE TABLE `membership` (
  `id` int NOT NULL AUTO_INCREMENT,
  `membership_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `discount` float NOT NULL,
  `other_facilities` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `create_by` int NOT NULL,
  `create_date` date NOT NULL,
  `update_by` int NOT NULL,
  `update_date` date NOT NULL,
  `startpoint` int NOT NULL,
  `endpoint` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `membership`
--


--
-- Table structure for table `menu_add_on`
--

CREATE TABLE `menu_add_on` (
  `row_id` bigint NOT NULL AUTO_INCREMENT,
  `menu_id` int NOT NULL,
  `add_on_id` int NOT NULL,
  `is_active` tinyint NOT NULL,
  PRIMARY KEY (`row_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `menu_add_on`
--


--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sender_id` int NOT NULL,
  `receiver_id` int NOT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `datetime` datetime NOT NULL,
  `sender_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=unseen, 1=seen, 2=delete',
  `receiver_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=unseen, 1=seen, 2=delete',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `message`
--


--
-- Table structure for table `module`
--

CREATE TABLE `module` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `directory` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `module`
--

INSERT INTO `module` VALUES (1,'Duty Roster','Manage your hotel employee\'s shift time which are assigned in different position and different time and get employee list which are assigned in current roster','application/modules/duty_roster/assets/images/thumbnail.jpg','duty_roster',1),(2,'Hall room','Hall room reservation','application/modules/hall_room/assets/images/thumbnail.jpg','hall_room',1),(3,'House Keeping','House keeping module provides room service, laundry service and it also has house keeping android app for managing room cleanig with QR code ','application/modules/house_keeping/assets/images/thumbnail.jpg','house_keeping',1),(4,'WhatsApp','WhatsApp Chat & Booking','application/modules/whatsapp/assets/images/thumbnail.jpg','whatsapp',1),(5,'Transport Facility','Pick up and drop off Customer From airport To hotel or hotel to airport based on customer openion.','application/modules/transport_facility/assets/images/thumbnail.jpg','transport_facility',1),(6,'Stripe','Stripe payment gateway','application/modules/stripe/assets/images/thumbnail.jpg','stripe',1),(7,'Razorpay','Razorpay payment gateway','application/modules/razorpay/assets/images/thumbnail.jpg','razorpay',1),(8,'Restaurent Module','This is a POS system. Using this module you can manage a restaurent and order food for In house customer, outside customer and old customer.','application/modules/ordermanage/assets/images/thumbnail.jpg','ordermanage',1);

--
-- Table structure for table `module_permission`
--

CREATE TABLE `module_permission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fk_module_id` int NOT NULL,
  `fk_user_id` int NOT NULL,
  `create` tinyint(1) DEFAULT NULL,
  `read` tinyint(1) DEFAULT NULL,
  `update` tinyint(1) DEFAULT NULL,
  `delete` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_module_id` (`fk_module_id`),
  KEY `fk_user_id` (`fk_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `module_permission`
--


--
-- Table structure for table `multipay_bill`
--

CREATE TABLE `multipay_bill` (
  `multipay_id` int NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL,
  `multipayid` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `payment_type_id` int NOT NULL,
  `payment_acc_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `amount` float NOT NULL,
  PRIMARY KEY (`multipay_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `multipay_bill`
--


--
-- Table structure for table `notice_board`
--

CREATE TABLE `notice_board` (
  `notice_id` int NOT NULL AUTO_INCREMENT,
  `notice_descriptiion` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `notice_date` date NOT NULL,
  `notice_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `notice_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `notice_attachment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`notice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notice_board`
--


--
-- Table structure for table `order_menu`
--

CREATE TABLE `order_menu` (
  `row_id` bigint NOT NULL AUTO_INCREMENT,
  `order_id` bigint NOT NULL,
  `menu_id` int NOT NULL,
  `price` decimal(19,3) DEFAULT '0.000',
  `groupmid` int DEFAULT '0',
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `menuqty` float NOT NULL,
  `add_on_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `addonsqty` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `varientid` int NOT NULL,
  `groupvarient` int DEFAULT NULL,
  `addonsuid` int DEFAULT NULL,
  `qroupqty` int DEFAULT NULL,
  `isgroup` int DEFAULT '0',
  `food_status` int DEFAULT '0',
  `allfoodready` int DEFAULT NULL,
  `isupdate` int DEFAULT NULL,
  PRIMARY KEY (`row_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `order_menu`
--


--
-- Table structure for table `page_title`
--

CREATE TABLE `page_title` (
  `pageid` int NOT NULL AUTO_INCREMENT,
  `home` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `aboutus` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `contactus` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `gallery` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `roomlist` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `roomdetails` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`pageid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `page_title`
--

INSERT INTO `page_title` VALUES (1,'Bem-vindo ao nosso hotel',' Sobre nosso hotel','Contate-nos','Nossa Galeria','Nossa Galeria',' Todos os quartos');

--
-- Table structure for table `pay_frequency`
--

CREATE TABLE `pay_frequency` (
  `id` int NOT NULL AUTO_INCREMENT,
  `frequency_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pay_frequency`
--


--
-- Table structure for table `payment_currency`
--

CREATE TABLE `payment_currency` (
  `id` int NOT NULL AUTO_INCREMENT,
  `currency_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `currency_details` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payment_currency`
--


--
-- Table structure for table `payment_method`
--

CREATE TABLE `payment_method` (
  `payment_method_id` tinyint NOT NULL AUTO_INCREMENT,
  `payment_method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`payment_method_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payment_method`
--

INSERT INTO `payment_method` VALUES (1,'Card Payment',0),(3,'Paypal',1),(4,'Cash Payment',0),(5,'SSLCommerz',1),(6,'Bank Payment',0),(8,'Stripe',1),(9,'Razorpay',1);

--
-- Table structure for table `payroll_holiday`
--

CREATE TABLE `payroll_holiday` (
  `payrl_holi_id` int unsigned NOT NULL AUTO_INCREMENT,
  `holiday_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `start_date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `end_date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `no_of_days` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_by` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `updated_by` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`payrl_holi_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payroll_holiday`
--

INSERT INTO `payroll_holiday` VALUES (4,'Dussehra','2021-09-15','','1','',''),(5,'Vijayadashami','2021-10-15','2021-10-15','1','','');

--
-- Table structure for table `payroll_tax_setup`
--

CREATE TABLE `payroll_tax_setup` (
  `tax_setup_id` int unsigned NOT NULL AUTO_INCREMENT,
  `start_amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `end_amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `rate` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`tax_setup_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payroll_tax_setup`
--


--
-- Table structure for table `position`
--

CREATE TABLE `position` (
  `pos_id` int unsigned NOT NULL AUTO_INCREMENT,
  `position_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `position_details` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`pos_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `position`
--

INSERT INTO `position` VALUES (1,'Chef','Responsible for the pastry shop in a foodservice establishment. Ensures that the products produced in the pastry shop meet the quality standards in conjunction with the executive chef.'),(2,'HRM','Recruits and hires qualified employees, creates in-house job-training programs, and assists employees with their career needs.'),(3,'Kitchen manager','Supervises and coordinates activities concerning all back-of-the-house operations and personnel, including food preparation, kitchen and storeroom areas.'),(7,'Accounts','Play a key role in every restaurant. '),(9,'Waiter','Restaurant Waiter'),(13,'Hotel Manager','Manage Hotel'),(14,'Shift Manager','Manage Working Shift'),(17,'Driver','Drive a Specific Vehicle for Pic up & Drop off Customer');

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `category_id` int NOT NULL DEFAULT '1',
  `uom_id` int NOT NULL,
  `stock` int DEFAULT '0',
  `used` int DEFAULT '0',
  `destroyed` int NOT NULL DEFAULT '0',
  `reuseable` int NOT NULL DEFAULT '0' COMMENT '0=No,1=Yes',
  `is_active` tinyint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`,`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `products`
--


--
-- Table structure for table `promocode`
--

CREATE TABLE `promocode` (
  `promocodeid` int NOT NULL AUTO_INCREMENT,
  `roomid` int NOT NULL,
  `startdate` date NOT NULL,
  `enddate` date NOT NULL,
  `promocode` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `discount` int NOT NULL,
  `status` int NOT NULL,
  PRIMARY KEY (`promocodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `promocode`
--


--
-- Table structure for table `purchase_details`
--

CREATE TABLE `purchase_details` (
  `detailsid` int NOT NULL AUTO_INCREMENT,
  `purchaseid` int NOT NULL,
  `proid` int NOT NULL,
  `quantity` decimal(10,2) NOT NULL DEFAULT '0.00',
  `unitname` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `totalprice` decimal(10,2) NOT NULL DEFAULT '0.00',
  `purchaseby` int NOT NULL,
  `purchasedate` date NOT NULL,
  `purchaseexpiredate` date DEFAULT NULL,
  PRIMARY KEY (`detailsid`),
  KEY `purchaseid` (`purchaseid`,`proid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `purchase_details`
--


--
-- Table structure for table `purchase_return`
--

CREATE TABLE `purchase_return` (
  `preturn_id` int NOT NULL AUTO_INCREMENT,
  `supplier_id` int NOT NULL,
  `po_no` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `return_date` date NOT NULL,
  `totalamount` float NOT NULL,
  `totaldiscount` float NOT NULL,
  `return_reason` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `createby` int NOT NULL,
  `createdate` datetime NOT NULL,
  `updateby` int NOT NULL,
  `updatedate` datetime NOT NULL,
  PRIMARY KEY (`preturn_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `purchase_return`
--


--
-- Table structure for table `purchase_return_details`
--

CREATE TABLE `purchase_return_details` (
  `preturn_id` int NOT NULL,
  `product_id` bigint NOT NULL,
  `qty` int NOT NULL,
  `product_rate` float NOT NULL,
  `store_id` int NOT NULL,
  `discount` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `purchase_return_details`
--


--
-- Table structure for table `purchaseitem`
--

CREATE TABLE `purchaseitem` (
  `purID` int NOT NULL AUTO_INCREMENT,
  `invoiceid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `suplierID` int NOT NULL,
  `total_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `purchasedate` date NOT NULL,
  `purchaseexpiredate` date NOT NULL,
  `savedby` int NOT NULL,
  `status` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '0=unpaid,1=paid',
  PRIMARY KEY (`purID`),
  KEY `invoiceid` (`invoiceid`,`suplierID`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `purchaseitem`
--


--
-- Table structure for table `rate_type`
--

CREATE TABLE `rate_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `r_type_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `rate_type`
--


--
-- Table structure for table `rest_table`
--

CREATE TABLE `rest_table` (
  `tableid` int NOT NULL AUTO_INCREMENT,
  `tablename` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `person_capicity` int NOT NULL,
  `table_icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `floor` int DEFAULT '0',
  `status` int NOT NULL DEFAULT '0' COMMENT '1=booked,0=free',
  PRIMARY KEY (`tableid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `rest_table`
--

INSERT INTO `rest_table` VALUES (1,'table 2',2,'assets/img/icons/resttable/1.png',1,0);

--
-- Table structure for table `room_image`
--

CREATE TABLE `room_image` (
  `room_img_id` int NOT NULL AUTO_INCREMENT,
  `room_id` int NOT NULL,
  `room_imagename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`room_img_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `room_image`
--


--
-- Table structure for table `roomdetails`
--

CREATE TABLE `roomdetails` (
  `roomid` int NOT NULL AUTO_INCREMENT,
  `roomtype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `roomsize` int NOT NULL,
  `roomsizemesurement` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `roomactive` int NOT NULL,
  `bedsno` int NOT NULL,
  `bedstype` int NOT NULL,
  `number_of_star` int DEFAULT '4',
  `roomdescription` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `reservecondition` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `roomstatus` int NOT NULL DEFAULT '0',
  `capacity` int NOT NULL,
  `exbedcapability` int NOT NULL DEFAULT '1',
  `child_limit` int DEFAULT '0',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `bedcharge` decimal(10,0) NOT NULL,
  `personcharge` decimal(10,0) NOT NULL,
  PRIMARY KEY (`roomid`),
  KEY `roomtype` (`roomtype`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roomdetails`
--

INSERT INTO `roomdetails` VALUES (1,'Single',10,'10',1,1,13,3,'comfy','book ahead',0,2,0,NULL,150.00,150,150);

--
-- Table structure for table `roomfacilitydetails`
--

CREATE TABLE `roomfacilitydetails` (
  `facilityid` int NOT NULL AUTO_INCREMENT,
  `facilitytypeid` int NOT NULL,
  `facilitytitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`facilityid`),
  KEY `facilitytypeid` (`facilitytypeid`),
  KEY `facilitytypeid_2` (`facilitytypeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roomfacilitydetails`
--


--
-- Table structure for table `roomfacilitytype`
--

CREATE TABLE `roomfacilitytype` (
  `facilitytypeid` int NOT NULL AUTO_INCREMENT,
  `facilitytypetitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`facilitytypeid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roomfacilitytype`
--

INSERT INTO `roomfacilitytype` VALUES (1,'Wifi');

--
-- Table structure for table `roomfaility_ref_accomodation`
--

CREATE TABLE `roomfaility_ref_accomodation` (
  `accomodationid` int NOT NULL AUTO_INCREMENT,
  `facilititypeid` int NOT NULL,
  `facilityid` int NOT NULL,
  `room_id` int DEFAULT NULL,
  `hallid` int DEFAULT NULL,
  PRIMARY KEY (`accomodationid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roomfaility_ref_accomodation`
--


--
-- Table structure for table `roomsizemesurement`
--

CREATE TABLE `roomsizemesurement` (
  `mesurementid` int NOT NULL AUTO_INCREMENT,
  `roommesurementitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`mesurementid`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roomsizemesurement`
--

INSERT INTO `roomsizemesurement` VALUES (10,'Double'),(11,'Triple'),(12,'Quad'),(13,'Queen'),(14,'King'),(15,'Twin'),(16,'Double-Double'),(17,'Executive Suite');

--
-- Table structure for table `salary_setup_header`
--

CREATE TABLE `salary_setup_header` (
  `s_s_h_id` int unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `salary_payable` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `absent_deduct` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `tax_manager` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`s_s_h_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `salary_setup_header`
--


--
-- Table structure for table `salary_sheet_generate`
--

CREATE TABLE `salary_sheet_generate` (
  `ssg_id` int unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `gdate` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `start_date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `end_date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `generate_by` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`ssg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `salary_sheet_generate`
--


--
-- Table structure for table `salary_type`
--

CREATE TABLE `salary_type` (
  `salary_type_id` int unsigned NOT NULL AUTO_INCREMENT,
  `sal_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `emp_sal_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `default_amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`salary_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `salary_type`
--


--
-- Table structure for table `sampledata`
--

CREATE TABLE `sampledata` (
  `brand` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `dealer_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `authorized` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `address` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `contact_no` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `mobile_no` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `fax` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `website_addr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `state` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `city` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sampledata`
--


--
-- Table structure for table `schdule_purchse_info`
--

CREATE TABLE `schdule_purchse_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `purchase_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `domain` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ip_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `port` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `schdule_purchse_info`
--


--
-- Table structure for table `sec_menu_item`
--

CREATE TABLE `sec_menu_item` (
  `menu_id` int NOT NULL AUTO_INCREMENT,
  `menu_title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `page_url` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `module` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `parent_menu` int DEFAULT NULL,
  `is_report` tinyint(1) DEFAULT NULL,
  `createby` int NOT NULL,
  `createdate` datetime NOT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=260 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sec_menu_item`
--

INSERT INTO `sec_menu_item` VALUES (1,'c_o_a','treeview','accounts',0,0,1,'2019-06-12 00:00:00'),(2,'debit_voucher','debit_voucher','accounts',0,0,1,'2019-06-12 00:00:00'),(3,'credit_voucher','credit_voucher','accounts',0,0,1,'2019-06-12 00:00:00'),(4,'contra_voucher','contra_voucher','accounts',0,0,1,'2019-06-12 00:00:00'),(5,'journal_voucher','journal_voucher','accounts',0,0,1,'2019-06-12 00:00:00'),(6,'voucher_approval','voucher_approval','accounts',0,0,1,'2019-06-12 00:00:00'),(7,'account_report','','accounts',0,0,1,'2019-06-12 00:00:00'),(8,'voucher_report','coa','accounts',7,0,1,'2019-06-12 00:00:00'),(9,'cash_book','cash_book','accounts',7,0,1,'2019-06-12 00:00:00'),(10,'bank_book','bank_book','accounts',7,0,1,'2019-06-16 00:00:00'),(11,'general_ledger','general_ledger','accounts',7,0,1,'2019-06-16 00:00:00'),(12,'trial_balance','trial_balance','accounts',7,0,1,'2019-06-16 00:00:00'),(13,'profit_loss','profit_loss_report','accounts',7,0,1,'2019-06-16 00:00:00'),(14,'cash_flow','cash_flow_report','accounts',7,0,1,'2019-06-16 00:00:00'),(15,'coa_print','coa_print','accounts',7,0,1,'2019-06-16 00:00:00'),(16,'hrm','','hrm',0,0,1,'2019-06-16 00:00:00'),(17,'attendance','Home','hrm',0,0,1,'2019-06-16 00:00:00'),(18,'atn_form','atnview','hrm',17,0,1,'2019-06-16 00:00:00'),(19,'atn_report','attendance_list','hrm',17,0,1,'2019-06-16 00:00:00'),(20,'award','Award_controller','hrm',0,0,1,'2019-06-16 00:00:00'),(21,'new_award','create_award','hrm',20,0,1,'2019-06-16 00:00:00'),(22,'circularprocess','Candidate','hrm',0,0,1,'2019-06-16 00:00:00'),(23,'add_canbasic_info','caninfo_create','hrm',22,0,1,'2019-06-16 00:00:00'),(24,'can_basicinfo_list','canInfoview','hrm',22,0,1,'2019-06-16 00:00:00'),(25,'candidate_basic_info','Candidate_select','hrm',0,0,1,'2019-06-16 00:00:00'),(26,'candidate_shortlist','shortlist_form','hrm',25,0,1,'2019-06-16 00:00:00'),(27,'candidate_interview','interview_form','hrm',25,0,1,'2019-06-16 00:00:00'),(28,'candidate_selection','selection_form','hrm',25,0,1,'2019-06-16 00:00:00'),(29,'department','Department_controller','hrm',0,0,1,'2019-06-16 00:00:00'),(30,'departmentfrm','create_dept','hrm',29,0,1,'2019-06-16 00:00:00'),(31,'division','Division_controller','hrm',0,0,1,'2019-06-16 00:00:00'),(32,'add_division','division_form','hrm',31,0,1,'2019-06-16 00:00:00'),(33,'division_list','','hrm',0,0,1,'2019-06-16 00:00:00'),(34,'position','position_form','hrm',0,0,1,'2019-06-16 00:00:00'),(35,'employee','','hrm',0,0,1,'2019-06-16 00:00:00'),(36,'add_employee','employ_form','hrm',35,0,1,'2019-06-16 00:00:00'),(37,'manage_employee','employee_view','hrm',35,0,1,'2019-06-16 00:00:00'),(38,'emp_performance','emp_performance_form','hrm',35,0,1,'2019-06-16 00:00:00'),(39,'emp_sal_payment','paymentview','hrm',35,0,1,'2019-06-16 00:00:00'),(40,'leave','leave','hrm',0,0,1,'2019-06-16 00:00:00'),(41,'weekly_holiday','weeklyform','hrm',40,0,1,'2019-06-16 00:00:00'),(42,'holiday','holiday_form','hrm',40,0,1,'2019-06-16 00:00:00'),(43,'others_leave_application','others_leave','hrm',40,0,1,'2019-06-16 00:00:00'),(44,'add_leave_type','leave_type_form','hrm',40,0,1,'2019-06-16 00:00:00'),(45,'leave_application','others_leave','hrm',40,0,1,'2019-06-16 00:00:00'),(46,'loan','loan','hrm',0,0,1,'2019-06-16 00:00:00'),(47,'loan_grand','create_grandloan','hrm',46,0,1,'2019-06-16 00:00:00'),(48,'loan_installment','create_installment','hrm',46,0,1,'2019-06-16 00:00:00'),(49,'manage_installment','installmentView','hrm',46,0,1,'2019-06-16 00:00:00'),(50,'manage_granted_loan','loan_view','hrm',46,0,1,'2019-06-16 00:00:00'),(51,'loan_report','loan_report','hrm',46,0,1,'2019-06-16 00:00:00'),(52,'payroll','payroll','hrm',0,0,1,'2019-06-16 00:00:00'),(53,'salary_type_setup','create_salary_setup','hrm',52,0,1,'2019-06-16 00:00:00'),(54,'manage_salary_setup','emp_salary_setup_view','hrm',52,0,1,'2019-06-16 00:00:00'),(55,'salary_setup','create_s_setup','hrm',52,0,1,'2019-06-16 00:00:00'),(56,'manage_salary_type','salary_setup_view','hrm',52,0,1,'2019-06-16 00:00:00'),(57,'salary_generate','create_salary_generate','hrm',52,0,1,'2019-06-16 00:00:00'),(58,'manage_salary_generate','salary_generate_view','hrm',52,0,1,'2019-06-16 00:00:00'),(59,'purchase_item','index','purchase',0,0,1,'2019-06-16 00:00:00'),(60,'purchase_add','create','purchase',59,0,1,'2019-06-16 00:00:00'),(61,'purchase_return','return_form','purchase',59,0,1,'2019-06-16 00:00:00'),(62,'return_invoice','return_invoice','purchase',59,0,1,'2019-06-16 00:00:00'),(63,'report','report','reports',NULL,0,1,'2019-06-16 00:00:00'),(64,'purchase_report','index','reports',63,0,1,'2019-06-16 00:00:00'),(65,'paymentmethod','','payment_setting',0,0,1,'2019-06-16 00:00:00'),(66,'paymentmethod_list','index','payment_setting',65,0,1,'2019-06-16 00:00:00'),(67,'payment_add','create','payment_setting',66,0,1,'2019-06-16 00:00:00'),(68,'customer','customer_info','customer',0,0,1,'2019-06-16 00:00:00'),(69,'customer_add','create','customer',68,0,1,'2019-06-16 00:00:00'),(70,'booking_report','index','reports',63,0,1,'2019-06-16 00:00:00'),(71,'paymentmethod_setup','paymentsetup','payment_setting',65,0,1,'2019-06-16 00:00:00'),(72,'room_facilities','index','room_facilities',0,0,1,'2019-06-16 00:00:00'),(73,'faciliti_details_list','room_facilitidetails','room_facilities',72,0,1,'2019-06-16 00:00:00'),(74,'roomsize_list','room_size','room_facilities',72,0,1,'2019-06-16 00:00:00'),(75,'room_reservation','room_reservation','room_reservation',0,0,0,'0000-00-00 00:00:00'),(76,'bed_list','index','room_setting',0,0,1,'2019-06-16 00:00:00'),(77,'starclass_list','starclass','room_setting',0,0,1,'2019-06-16 00:00:00'),(78,'bookingtype_list','booking_type','room_setting',0,0,1,'2019-06-16 00:00:00'),(79,'floorplan_list','floorplan','room_setting',0,0,1,'2019-06-16 00:00:00'),(80,'room_list','room_details','room_setting',0,0,1,'2019-06-16 00:00:00'),(81,'room_image','room_images','room_setting',0,0,1,'2019-06-16 00:00:00'),(82,'stock_report','stockreport','reports',63,0,1,'2019-07-04 00:00:00'),(83,'customer_list','index','customer',68,0,0,'0000-00-00 00:00:00'),(84,'units',NULL,'units',0,0,0,'0000-00-00 00:00:00'),(85,'unit_list','index','units',84,0,0,'0000-00-00 00:00:00'),(86,'ingradient_list','index','units',84,0,0,'0000-00-00 00:00:00'),(87,'supplier_list','index','units',84,0,0,'0000-00-00 00:00:00'),(88,'booking_list','index','room_reservation',75,0,1,'2019-06-16 00:00:00'),(89,'faciliti_list',NULL,'room_facilities',72,0,0,'0000-00-00 00:00:00'),(91,'booking_source','b_ty_details','room_setting',0,0,1,'2021-06-06 00:00:00'),(92,'house_keeping','house-keeping','house_keeping',0,0,1,'0000-00-00 00:00:00'),(96,'wakeup_call_list','wakeup_call_list','customer',68,0,1,'2021-06-06 00:00:00'),(97,'categorylist','categorylist','units',84,0,0,'2021-06-14 00:00:00'),(110,'complementary','complementary','room_setting',0,0,1,'2021-07-14 00:00:00'),(113,'guest_list','guestlist','customer',68,0,0,'0000-00-00 00:00:00'),(116,'tax_management','tax-management','tax_management',0,0,1,'2021-08-21 00:00:00'),(117,'tax_list','tax-list','tax_management',116,0,1,'2021-08-21 00:00:00'),(119,'destroyed_list','Destroyed-list','units',84,0,1,'2021-08-23 00:00:00'),(155,'balance_sheet','balance-sheet','accounts',7,0,1,'2021-10-04 00:00:00'),(156,'financial_year','financial-year','accounts',7,0,1,'2021-10-11 00:00:00'),(157,'financial_year_end','financial-year-end','accounts',7,0,1,'2021-10-12 00:00:00'),(158,'opening_balance','opening-balance','accounts',7,0,1,'2021-10-13 00:00:00'),(160,'room_status','room-status','room_reservation',75,0,1,'2021-10-25 00:00:00'),(165,'promocode','promocode','room_setting',0,0,1,'2021-11-07 00:00:00'),(202,'checkin','checkin','room_reservation',75,0,1,'2021-10-25 00:00:00'),(203,'checkout','checkout','room_reservation',75,0,1,'2021-10-25 00:00:00'),(204,'shift_mgt','Shift_management','duty_roster',0,0,1,'2021-07-04 00:00:00'),(205,'shift_list','shift_list','duty_roster',204,0,1,'2021-07-04 00:00:00'),(206,'shift_assign','shift_assign_list','duty_roster',204,0,1,'2021-07-04 00:00:00'),(207,'roster_list','roster_list','duty_roster',204,0,1,'2021-07-04 00:00:00'),(208,'attendance_dashboard','attendance_dashboard','duty_roster',204,0,1,'2021-07-04 00:00:00'),(209,'hall_room','hall-room','hall_room',0,0,1,'2021-12-19 00:00:00'),(210,'hallroom_booking','hallroom-booking','hall_room',209,0,1,'2021-12-19 00:00:00'),(211,'hallroom_status','hallroom-status','hall_room',209,0,1,'2021-12-19 00:00:00'),(212,'hallroom_type','hallroom-type','hall_room',209,0,1,'2021-12-19 00:00:00'),(213,'hallroom_assign','hallroom-assign','hall_room',209,0,1,'2021-12-19 00:00:00'),(214,'hallroom_facility','hallroom-facility','hall_room',209,0,1,'2021-12-19 00:00:00'),(215,'seatplan','seatplan','hall_room',209,0,1,'2021-12-19 00:00:00'),(216,'report','report','hall_room',209,0,1,'2021-12-19 00:00:00'),(217,'room_cleaning','room-cleaning','house_keeping',92,0,1,'2021-11-10 00:00:00'),(218,'assign_room_cleaning','house-keeping','house_keeping',92,0,1,'2021-11-10 00:00:00'),(219,'payment','payment','house_keeping',120,0,1,'2021-11-10 00:00:00'),(220,'records','records','house_keeping',92,0,1,'2021-11-10 00:00:00'),(221,'checklist','checklist','house_keeping',92,0,1,'2021-11-10 00:00:00'),(222,'roomqr_list','roomqr_list','house_keeping',92,0,1,'2021-11-22 00:00:00'),(223,'add_whatsapp','whatsappback','whatsapp',0,0,3,'2020-12-03 00:00:00'),(224,'whatsapp_api','showsetting','whatsapp',223,0,3,'2020-12-03 00:00:00'),(225,'transport_facility','transport_facility','transport_facility',0,0,1,'2021-10-20 00:00:00'),(226,'flight_details_list','flight-list','transport_facility',225,0,1,'2021-10-20 00:00:00'),(227,'vehicle_details_list','vehicle-list','transport_facility',225,0,1,'2021-06-06 00:00:00'),(228,'vehicle_booking_list','vehicle-booking-list','transport_facility',225,0,1,'2021-06-06 00:00:00'),(229,'ordermanage','','ordermanage',0,0,1,'2021-09-06 00:00:00'),(230,'pos_invoice','pos-invoice','ordermanage',229,0,1,'2021-09-06 00:00:00'),(231,'order_list','order-list','ordermanage',229,0,1,'2021-09-06 00:00:00'),(232,'pending_order','pending-order','ordermanage',229,0,1,'2021-09-06 00:00:00'),(233,'complete_order','complete-list','ordermanage',229,0,1,'2021-09-06 00:00:00'),(234,'cancel_order','cancel-list','ordermanage',229,0,1,'2021-09-06 00:00:00'),(235,'kitchen_dashboard','kitchen','ordermanage',229,0,1,'2021-09-06 00:00:00'),(236,'counter_dashboard','counter-board','ordermanage',229,0,1,'2021-09-06 00:00:00'),(237,'counter_list','counter-list','ordermanage',229,0,1,'2021-09-06 00:00:00'),(238,'pos_setting','pos-setting','ordermanage',229,0,1,'2021-09-06 00:00:00'),(239,'sound_setting','sound-setting','ordermanage',229,0,1,'2021-09-06 00:00:00'),(240,'table_manage','restauranttable','ordermanage',0,0,1,'2021-09-06 00:00:00'),(241,'table_list','table-list','ordermanage',240,0,1,'2021-09-06 00:00:00'),(242,'table_setting','table-setting','ordermanage',240,0,1,'2021-09-06 00:00:00'),(243,'customer_type','customertype','ordermanage',0,0,1,'2021-09-06 00:00:00'),(244,'customertype_list','customer-type','ordermanage',243,0,1,'2021-09-06 00:00:00'),(245,'list_of_card_terminal','card-terminal','ordermanage',243,0,1,'2021-09-06 00:00:00'),(246,'manage_category','item_category','ordermanage',0,0,1,'2021-09-06 00:00:00'),(247,'add_category','category-create','ordermanage',246,0,1,'2021-09-06 00:00:00'),(248,'category_list','category-list','ordermanage',246,0,1,'2021-09-06 00:00:00'),(249,'manage_food','item_food','ordermanage',0,0,1,'2021-09-06 00:00:00'),(250,'add_food','food-create','ordermanage',249,0,1,'2021-09-06 00:00:00'),(251,'food_list','food-list','ordermanage',249,0,1,'2021-09-06 00:00:00'),(252,'add_group_item','food-groop-create','ordermanage',249,0,1,'2021-09-06 00:00:00'),(253,'food_varient','food-varient-list','ordermanage',249,0,1,'2021-09-06 00:00:00'),(254,'food_availablity','food-available-list','ordermanage',249,0,1,'2021-09-06 00:00:00'),(255,'menu_type','today-menu-type','ordermanage',249,0,1,'2021-09-06 00:00:00'),(256,'manage_addons','menu_addons','ordermanage',0,0,1,'2021-09-06 00:00:00'),(257,'add_adons','menu-addons-create','ordermanage',256,0,1,'2021-09-06 00:00:00'),(258,'addons_list','menu-addons-list','ordermanage',256,0,1,'2021-09-06 00:00:00'),(259,'assign_adons_list','assign-menu-addons','ordermanage',256,0,1,'2021-09-06 00:00:00');

--
-- Table structure for table `sec_role_permission`
--

CREATE TABLE `sec_role_permission` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `role_id` int NOT NULL,
  `menu_id` int NOT NULL,
  `can_access` tinyint(1) NOT NULL,
  `can_create` tinyint(1) NOT NULL,
  `can_edit` tinyint(1) NOT NULL,
  `can_delete` tinyint(1) NOT NULL,
  `createby` int NOT NULL,
  `createdate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2789 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sec_role_permission`
--

INSERT INTO `sec_role_permission` VALUES (411,12,1,0,0,0,0,1,'2020-11-29 01:12:42'),(412,12,2,0,0,0,0,1,'2020-11-29 01:12:42'),(413,12,3,0,0,0,0,1,'2020-11-29 01:12:42'),(414,12,4,0,0,0,0,1,'2020-11-29 01:12:42'),(415,12,5,0,0,0,0,1,'2020-11-29 01:12:42'),(416,12,6,0,0,0,0,1,'2020-11-29 01:12:42'),(417,12,7,0,0,0,0,1,'2020-11-29 01:12:42'),(418,12,8,0,0,0,0,1,'2020-11-29 01:12:42'),(419,12,9,0,0,0,0,1,'2020-11-29 01:12:42'),(420,12,10,0,0,0,0,1,'2020-11-29 01:12:42'),(421,12,11,0,0,0,0,1,'2020-11-29 01:12:42'),(422,12,12,0,0,0,0,1,'2020-11-29 01:12:42'),(423,12,13,0,0,0,0,1,'2020-11-29 01:12:42'),(424,12,14,0,0,0,0,1,'2020-11-29 01:12:42'),(425,12,15,0,0,0,0,1,'2020-11-29 01:12:42'),(426,12,68,0,0,0,0,1,'2020-11-29 01:12:42'),(427,12,69,0,0,0,0,1,'2020-11-29 01:12:42'),(428,12,16,0,0,0,0,1,'2020-11-29 01:12:42'),(429,12,17,0,0,0,0,1,'2020-11-29 01:12:42'),(430,12,18,0,0,0,0,1,'2020-11-29 01:12:42'),(431,12,19,0,0,0,0,1,'2020-11-29 01:12:42'),(432,12,20,0,0,0,0,1,'2020-11-29 01:12:42'),(433,12,21,0,0,0,0,1,'2020-11-29 01:12:42'),(434,12,22,0,0,0,0,1,'2020-11-29 01:12:42'),(435,12,23,0,0,0,0,1,'2020-11-29 01:12:42'),(436,12,24,0,0,0,0,1,'2020-11-29 01:12:42'),(437,12,25,0,0,0,0,1,'2020-11-29 01:12:42'),(438,12,26,0,0,0,0,1,'2020-11-29 01:12:42'),(439,12,27,0,0,0,0,1,'2020-11-29 01:12:42'),(440,12,28,0,0,0,0,1,'2020-11-29 01:12:42'),(441,12,29,0,0,0,0,1,'2020-11-29 01:12:42'),(442,12,30,0,0,0,0,1,'2020-11-29 01:12:42'),(443,12,31,0,0,0,0,1,'2020-11-29 01:12:42'),(444,12,32,0,0,0,0,1,'2020-11-29 01:12:42'),(445,12,33,0,0,0,0,1,'2020-11-29 01:12:42'),(446,12,34,0,0,0,0,1,'2020-11-29 01:12:42'),(447,12,35,0,0,0,0,1,'2020-11-29 01:12:42'),(448,12,36,0,0,0,0,1,'2020-11-29 01:12:42'),(449,12,37,0,0,0,0,1,'2020-11-29 01:12:42'),(450,12,38,0,0,0,0,1,'2020-11-29 01:12:42'),(451,12,39,0,0,0,0,1,'2020-11-29 01:12:42'),(452,12,40,0,0,0,0,1,'2020-11-29 01:12:42'),(453,12,41,0,0,0,0,1,'2020-11-29 01:12:42'),(454,12,42,0,0,0,0,1,'2020-11-29 01:12:42'),(455,12,43,0,0,0,0,1,'2020-11-29 01:12:42'),(456,12,44,0,0,0,0,1,'2020-11-29 01:12:42'),(457,12,45,0,0,0,0,1,'2020-11-29 01:12:42'),(458,12,46,0,0,0,0,1,'2020-11-29 01:12:42'),(459,12,47,0,0,0,0,1,'2020-11-29 01:12:42'),(460,12,48,0,0,0,0,1,'2020-11-29 01:12:42'),(461,12,49,0,0,0,0,1,'2020-11-29 01:12:42'),(462,12,50,0,0,0,0,1,'2020-11-29 01:12:42'),(463,12,51,0,0,0,0,1,'2020-11-29 01:12:42'),(464,12,52,0,0,0,0,1,'2020-11-29 01:12:42'),(465,12,53,0,0,0,0,1,'2020-11-29 01:12:42'),(466,12,54,0,0,0,0,1,'2020-11-29 01:12:42'),(467,12,55,0,0,0,0,1,'2020-11-29 01:12:42'),(468,12,56,0,0,0,0,1,'2020-11-29 01:12:42'),(469,12,57,0,0,0,0,1,'2020-11-29 01:12:42'),(470,12,58,0,0,0,0,1,'2020-11-29 01:12:42'),(471,12,65,0,0,0,0,1,'2020-11-29 01:12:42'),(472,12,66,0,0,0,0,1,'2020-11-29 01:12:42'),(473,12,67,0,0,0,0,1,'2020-11-29 01:12:42'),(474,12,71,0,0,0,0,1,'2020-11-29 01:12:42'),(475,12,59,0,0,0,0,1,'2020-11-29 01:12:42'),(476,12,60,0,0,0,0,1,'2020-11-29 01:12:42'),(477,12,61,0,0,0,0,1,'2020-11-29 01:12:42'),(478,12,62,0,0,0,0,1,'2020-11-29 01:12:42'),(479,12,63,0,0,0,0,1,'2020-11-29 01:12:42'),(480,12,64,0,0,0,0,1,'2020-11-29 01:12:42'),(481,12,70,0,0,0,0,1,'2020-11-29 01:12:42'),(482,12,82,0,0,0,0,1,'2020-11-29 01:12:42'),(483,12,72,0,0,0,0,1,'2020-11-29 01:12:42'),(484,12,73,0,0,0,0,1,'2020-11-29 01:12:42'),(485,12,74,0,0,0,0,1,'2020-11-29 01:12:42'),(486,12,75,0,0,0,0,1,'2020-11-29 01:12:42'),(487,12,76,0,0,0,0,1,'2020-11-29 01:12:42'),(488,12,77,0,0,0,0,1,'2020-11-29 01:12:42'),(489,12,78,0,0,0,0,1,'2020-11-29 01:12:42'),(490,12,79,0,0,0,0,1,'2020-11-29 01:12:42'),(491,12,80,0,0,0,0,1,'2020-11-29 01:12:42'),(492,12,81,0,0,0,0,1,'2020-11-29 01:12:42'),(493,7,1,1,1,1,1,1,'2020-12-21 07:01:16'),(494,7,2,1,1,1,1,1,'2020-12-21 07:01:16'),(495,7,3,1,1,1,1,1,'2020-12-21 07:01:16'),(496,7,4,1,1,1,1,1,'2020-12-21 07:01:16'),(497,7,5,1,1,1,1,1,'2020-12-21 07:01:16'),(498,7,6,1,1,1,1,1,'2020-12-21 07:01:16'),(499,7,7,1,1,1,1,1,'2020-12-21 07:01:16'),(500,7,8,1,1,1,1,1,'2020-12-21 07:01:16'),(501,7,9,1,1,1,1,1,'2020-12-21 07:01:16'),(502,7,10,1,1,1,1,1,'2020-12-21 07:01:16'),(503,7,11,1,1,1,1,1,'2020-12-21 07:01:16'),(504,7,12,1,1,1,1,1,'2020-12-21 07:01:16'),(505,7,13,1,1,1,1,1,'2020-12-21 07:01:16'),(506,7,14,1,1,1,1,1,'2020-12-21 07:01:16'),(507,7,15,1,1,1,1,1,'2020-12-21 07:01:16'),(508,7,68,1,1,1,1,1,'2020-12-21 07:01:16'),(509,7,69,1,1,1,1,1,'2020-12-21 07:01:16'),(510,7,16,0,0,0,0,1,'2020-12-21 07:01:16'),(511,7,17,0,0,0,0,1,'2020-12-21 07:01:16'),(512,7,18,0,0,0,0,1,'2020-12-21 07:01:16'),(513,7,19,0,0,0,0,1,'2020-12-21 07:01:16'),(514,7,20,0,0,0,0,1,'2020-12-21 07:01:16'),(515,7,21,0,0,0,0,1,'2020-12-21 07:01:16'),(516,7,22,0,0,0,0,1,'2020-12-21 07:01:16'),(517,7,23,0,0,0,0,1,'2020-12-21 07:01:16'),(518,7,24,0,0,0,0,1,'2020-12-21 07:01:16'),(519,7,25,0,0,0,0,1,'2020-12-21 07:01:16'),(520,7,26,0,0,0,0,1,'2020-12-21 07:01:16'),(521,7,27,0,0,0,0,1,'2020-12-21 07:01:16'),(522,7,28,0,0,0,0,1,'2020-12-21 07:01:16'),(523,7,29,0,0,0,0,1,'2020-12-21 07:01:16'),(524,7,30,0,0,0,0,1,'2020-12-21 07:01:16'),(525,7,31,0,0,0,0,1,'2020-12-21 07:01:16'),(526,7,32,0,0,0,0,1,'2020-12-21 07:01:16'),(527,7,33,0,0,0,0,1,'2020-12-21 07:01:16'),(528,7,34,0,0,0,0,1,'2020-12-21 07:01:16'),(529,7,35,0,0,0,0,1,'2020-12-21 07:01:16'),(530,7,36,0,0,0,0,1,'2020-12-21 07:01:16'),(531,7,37,0,0,0,0,1,'2020-12-21 07:01:16'),(532,7,38,0,0,0,0,1,'2020-12-21 07:01:16'),(533,7,39,0,0,0,0,1,'2020-12-21 07:01:16'),(534,7,40,0,0,0,0,1,'2020-12-21 07:01:16'),(535,7,41,0,0,0,0,1,'2020-12-21 07:01:16'),(536,7,42,0,0,0,0,1,'2020-12-21 07:01:16'),(537,7,43,0,0,0,0,1,'2020-12-21 07:01:16'),(538,7,44,0,0,0,0,1,'2020-12-21 07:01:16'),(539,7,45,0,0,0,0,1,'2020-12-21 07:01:16'),(540,7,46,0,0,0,0,1,'2020-12-21 07:01:16'),(541,7,47,0,0,0,0,1,'2020-12-21 07:01:16'),(542,7,48,0,0,0,0,1,'2020-12-21 07:01:16'),(543,7,49,0,0,0,0,1,'2020-12-21 07:01:16'),(544,7,50,0,0,0,0,1,'2020-12-21 07:01:16'),(545,7,51,0,0,0,0,1,'2020-12-21 07:01:16'),(546,7,52,0,0,0,0,1,'2020-12-21 07:01:16'),(547,7,53,0,0,0,0,1,'2020-12-21 07:01:16'),(548,7,54,0,0,0,0,1,'2020-12-21 07:01:16'),(549,7,55,0,0,0,0,1,'2020-12-21 07:01:16'),(550,7,56,0,0,0,0,1,'2020-12-21 07:01:16'),(551,7,57,0,0,0,0,1,'2020-12-21 07:01:16'),(552,7,58,0,0,0,0,1,'2020-12-21 07:01:16'),(553,7,65,1,1,1,1,1,'2020-12-21 07:01:16'),(554,7,66,1,1,1,1,1,'2020-12-21 07:01:16'),(555,7,67,1,1,1,1,1,'2020-12-21 07:01:16'),(556,7,71,1,1,1,1,1,'2020-12-21 07:01:16'),(557,7,59,1,1,1,1,1,'2020-12-21 07:01:16'),(558,7,60,1,1,1,1,1,'2020-12-21 07:01:16'),(559,7,61,1,1,1,1,1,'2020-12-21 07:01:16'),(560,7,62,1,1,1,1,1,'2020-12-21 07:01:16'),(561,7,63,1,1,1,1,1,'2020-12-21 07:01:16'),(562,7,64,1,1,1,1,1,'2020-12-21 07:01:16'),(563,7,70,1,1,1,1,1,'2020-12-21 07:01:16'),(564,7,82,1,1,1,1,1,'2020-12-21 07:01:16'),(565,7,72,1,1,1,1,1,'2020-12-21 07:01:16'),(566,7,73,1,1,1,1,1,'2020-12-21 07:01:16'),(567,7,74,1,1,1,1,1,'2020-12-21 07:01:16'),(568,7,75,1,1,1,1,1,'2020-12-21 07:01:16'),(569,7,76,1,1,1,1,1,'2020-12-21 07:01:16'),(570,7,77,1,1,1,1,1,'2020-12-21 07:01:16'),(571,7,78,1,1,1,1,1,'2020-12-21 07:01:16'),(572,7,79,1,1,1,1,1,'2020-12-21 07:01:16'),(573,7,80,1,1,1,1,1,'2020-12-21 07:01:16'),(574,7,81,1,1,1,1,1,'2020-12-21 07:01:16'),(2458,15,1,0,0,0,0,1,'2021-02-08 05:06:37'),(2459,15,2,0,0,0,0,1,'2021-02-08 05:06:37'),(2460,15,3,0,0,0,0,1,'2021-02-08 05:06:37'),(2461,15,4,0,0,0,0,1,'2021-02-08 05:06:37'),(2462,15,5,0,0,0,0,1,'2021-02-08 05:06:37'),(2463,15,6,0,0,0,0,1,'2021-02-08 05:06:37'),(2464,15,7,0,0,0,0,1,'2021-02-08 05:06:37'),(2465,15,8,0,0,0,0,1,'2021-02-08 05:06:37'),(2466,15,9,0,0,0,0,1,'2021-02-08 05:06:37'),(2467,15,10,0,0,0,0,1,'2021-02-08 05:06:37'),(2468,15,11,0,0,0,0,1,'2021-02-08 05:06:37'),(2469,15,12,0,0,0,0,1,'2021-02-08 05:06:37'),(2470,15,13,0,0,0,0,1,'2021-02-08 05:06:37'),(2471,15,14,0,0,0,0,1,'2021-02-08 05:06:37'),(2472,15,15,0,0,0,0,1,'2021-02-08 05:06:37'),(2473,15,68,0,0,0,0,1,'2021-02-08 05:06:37'),(2474,15,69,0,0,0,0,1,'2021-02-08 05:06:37'),(2475,15,83,0,0,0,0,1,'2021-02-08 05:06:37'),(2476,15,16,0,0,0,0,1,'2021-02-08 05:06:37'),(2477,15,17,0,0,0,0,1,'2021-02-08 05:06:37'),(2478,15,18,0,0,0,0,1,'2021-02-08 05:06:37'),(2479,15,19,0,0,0,0,1,'2021-02-08 05:06:37'),(2480,15,20,0,0,0,0,1,'2021-02-08 05:06:37'),(2481,15,21,0,0,0,0,1,'2021-02-08 05:06:37'),(2482,15,22,0,0,0,0,1,'2021-02-08 05:06:37'),(2483,15,23,0,0,0,0,1,'2021-02-08 05:06:37'),(2484,15,24,0,0,0,0,1,'2021-02-08 05:06:37'),(2485,15,25,0,0,0,0,1,'2021-02-08 05:06:37'),(2486,15,26,0,0,0,0,1,'2021-02-08 05:06:37'),(2487,15,27,0,0,0,0,1,'2021-02-08 05:06:37'),(2488,15,28,0,0,0,0,1,'2021-02-08 05:06:37'),(2489,15,29,0,0,0,0,1,'2021-02-08 05:06:37'),(2490,15,30,0,0,0,0,1,'2021-02-08 05:06:37'),(2491,15,31,0,0,0,0,1,'2021-02-08 05:06:37'),(2492,15,32,0,0,0,0,1,'2021-02-08 05:06:37'),(2493,15,33,0,0,0,0,1,'2021-02-08 05:06:37'),(2494,15,34,0,0,0,0,1,'2021-02-08 05:06:37'),(2495,15,35,0,0,0,0,1,'2021-02-08 05:06:37'),(2496,15,36,0,0,0,0,1,'2021-02-08 05:06:37'),(2497,15,37,0,0,0,0,1,'2021-02-08 05:06:37'),(2498,15,38,0,0,0,0,1,'2021-02-08 05:06:37'),(2499,15,39,0,0,0,0,1,'2021-02-08 05:06:37'),(2500,15,40,0,0,0,0,1,'2021-02-08 05:06:37'),(2501,15,41,0,0,0,0,1,'2021-02-08 05:06:37'),(2502,15,42,0,0,0,0,1,'2021-02-08 05:06:37'),(2503,15,43,0,0,0,0,1,'2021-02-08 05:06:37'),(2504,15,44,0,0,0,0,1,'2021-02-08 05:06:37'),(2505,15,45,0,0,0,0,1,'2021-02-08 05:06:37'),(2506,15,46,0,0,0,0,1,'2021-02-08 05:06:37'),(2507,15,47,0,0,0,0,1,'2021-02-08 05:06:37'),(2508,15,48,0,0,0,0,1,'2021-02-08 05:06:37'),(2509,15,49,0,0,0,0,1,'2021-02-08 05:06:37'),(2510,15,50,0,0,0,0,1,'2021-02-08 05:06:37'),(2511,15,51,0,0,0,0,1,'2021-02-08 05:06:37'),(2512,15,52,0,0,0,0,1,'2021-02-08 05:06:37'),(2513,15,53,0,0,0,0,1,'2021-02-08 05:06:37'),(2514,15,54,0,0,0,0,1,'2021-02-08 05:06:37'),(2515,15,55,0,0,0,0,1,'2021-02-08 05:06:37'),(2516,15,56,0,0,0,0,1,'2021-02-08 05:06:37'),(2517,15,57,0,0,0,0,1,'2021-02-08 05:06:37'),(2518,15,58,0,0,0,0,1,'2021-02-08 05:06:37'),(2519,15,65,0,0,0,0,1,'2021-02-08 05:06:37'),(2520,15,66,0,0,0,0,1,'2021-02-08 05:06:37'),(2521,15,67,0,0,0,0,1,'2021-02-08 05:06:37'),(2522,15,71,0,0,0,0,1,'2021-02-08 05:06:37'),(2523,15,59,0,0,0,0,1,'2021-02-08 05:06:37'),(2524,15,60,0,0,0,0,1,'2021-02-08 05:06:37'),(2525,15,61,0,0,0,0,1,'2021-02-08 05:06:37'),(2526,15,62,0,0,0,0,1,'2021-02-08 05:06:37'),(2527,15,63,0,0,0,0,1,'2021-02-08 05:06:37'),(2528,15,64,0,0,0,0,1,'2021-02-08 05:06:37'),(2529,15,70,0,0,0,0,1,'2021-02-08 05:06:37'),(2530,15,82,0,0,0,0,1,'2021-02-08 05:06:37'),(2531,15,72,0,0,0,0,1,'2021-02-08 05:06:37'),(2532,15,73,0,0,0,0,1,'2021-02-08 05:06:37'),(2533,15,74,0,0,0,0,1,'2021-02-08 05:06:37'),(2534,15,89,0,0,0,0,1,'2021-02-08 05:06:37'),(2535,15,75,1,1,1,0,1,'2021-02-08 05:06:37'),(2536,15,88,1,1,1,0,1,'2021-02-08 05:06:37'),(2537,15,76,0,0,0,0,1,'2021-02-08 05:06:37'),(2538,15,77,0,0,0,0,1,'2021-02-08 05:06:37'),(2539,15,78,0,0,0,0,1,'2021-02-08 05:06:37'),(2540,15,79,0,0,0,0,1,'2021-02-08 05:06:37'),(2541,15,80,0,0,0,0,1,'2021-02-08 05:06:37'),(2542,15,81,0,0,0,0,1,'2021-02-08 05:06:37'),(2543,15,84,0,0,0,0,1,'2021-02-08 05:06:37'),(2544,15,85,0,0,0,0,1,'2021-02-08 05:06:37'),(2545,15,86,0,0,0,0,1,'2021-02-08 05:06:37'),(2546,15,87,0,0,0,0,1,'2021-02-08 05:06:37'),(2547,14,1,0,0,0,0,1,'2021-02-08 05:13:35'),(2548,14,2,0,0,0,0,1,'2021-02-08 05:13:35'),(2549,14,3,0,0,0,0,1,'2021-02-08 05:13:35'),(2550,14,4,0,0,0,0,1,'2021-02-08 05:13:35'),(2551,14,5,0,0,0,0,1,'2021-02-08 05:13:35'),(2552,14,6,0,0,0,0,1,'2021-02-08 05:13:35'),(2553,14,7,0,0,0,0,1,'2021-02-08 05:13:35'),(2554,14,8,0,0,0,0,1,'2021-02-08 05:13:35'),(2555,14,9,0,0,0,0,1,'2021-02-08 05:13:35'),(2556,14,10,0,0,0,0,1,'2021-02-08 05:13:35'),(2557,14,11,0,0,0,0,1,'2021-02-08 05:13:35'),(2558,14,12,0,0,0,0,1,'2021-02-08 05:13:35'),(2559,14,13,0,0,0,0,1,'2021-02-08 05:13:35'),(2560,14,14,0,0,0,0,1,'2021-02-08 05:13:35'),(2561,14,15,0,0,0,0,1,'2021-02-08 05:13:35'),(2562,14,68,1,1,0,0,1,'2021-02-08 05:13:35'),(2563,14,69,1,1,0,0,1,'2021-02-08 05:13:35'),(2564,14,83,1,1,0,0,1,'2021-02-08 05:13:35'),(2565,14,16,1,1,1,0,1,'2021-02-08 05:13:35'),(2566,14,17,1,1,1,0,1,'2021-02-08 05:13:35'),(2567,14,18,1,1,1,0,1,'2021-02-08 05:13:35'),(2568,14,19,1,1,1,0,1,'2021-02-08 05:13:35'),(2569,14,20,0,0,0,0,1,'2021-02-08 05:13:35'),(2570,14,21,0,0,0,0,1,'2021-02-08 05:13:35'),(2571,14,22,0,0,0,0,1,'2021-02-08 05:13:35'),(2572,14,23,0,0,0,0,1,'2021-02-08 05:13:35'),(2573,14,24,0,0,0,0,1,'2021-02-08 05:13:35'),(2574,14,25,0,0,0,0,1,'2021-02-08 05:13:35'),(2575,14,26,0,0,0,0,1,'2021-02-08 05:13:35'),(2576,14,27,0,0,0,0,1,'2021-02-08 05:13:35'),(2577,14,28,0,0,0,0,1,'2021-02-08 05:13:35'),(2578,14,29,0,0,0,0,1,'2021-02-08 05:13:35'),(2579,14,30,0,0,0,0,1,'2021-02-08 05:13:35'),(2580,14,31,0,0,0,0,1,'2021-02-08 05:13:35'),(2581,14,32,0,0,0,0,1,'2021-02-08 05:13:35'),(2582,14,33,0,0,0,0,1,'2021-02-08 05:13:35'),(2583,14,34,0,0,0,0,1,'2021-02-08 05:13:35'),(2584,14,35,0,0,0,0,1,'2021-02-08 05:13:35'),(2585,14,36,0,0,0,0,1,'2021-02-08 05:13:35'),(2586,14,37,0,0,0,0,1,'2021-02-08 05:13:35'),(2587,14,38,0,0,0,0,1,'2021-02-08 05:13:35'),(2588,14,39,0,0,0,0,1,'2021-02-08 05:13:35'),(2589,14,40,0,0,0,0,1,'2021-02-08 05:13:35'),(2590,14,41,0,0,0,0,1,'2021-02-08 05:13:35'),(2591,14,42,0,0,0,0,1,'2021-02-08 05:13:35'),(2592,14,43,0,0,0,0,1,'2021-02-08 05:13:35'),(2593,14,44,0,0,0,0,1,'2021-02-08 05:13:35'),(2594,14,45,0,0,0,0,1,'2021-02-08 05:13:35'),(2595,14,46,0,0,0,0,1,'2021-02-08 05:13:35'),(2596,14,47,0,0,0,0,1,'2021-02-08 05:13:35'),(2597,14,48,0,0,0,0,1,'2021-02-08 05:13:35'),(2598,14,49,0,0,0,0,1,'2021-02-08 05:13:35'),(2599,14,50,0,0,0,0,1,'2021-02-08 05:13:35'),(2600,14,51,0,0,0,0,1,'2021-02-08 05:13:35'),(2601,14,52,0,0,0,0,1,'2021-02-08 05:13:35'),(2602,14,53,0,0,0,0,1,'2021-02-08 05:13:35'),(2603,14,54,0,0,0,0,1,'2021-02-08 05:13:35'),(2604,14,55,0,0,0,0,1,'2021-02-08 05:13:35'),(2605,14,56,0,0,0,0,1,'2021-02-08 05:13:35'),(2606,14,57,0,0,0,0,1,'2021-02-08 05:13:35'),(2607,14,58,0,0,0,0,1,'2021-02-08 05:13:35'),(2608,14,65,0,0,0,0,1,'2021-02-08 05:13:35'),(2609,14,66,0,0,0,0,1,'2021-02-08 05:13:35'),(2610,14,67,0,0,0,0,1,'2021-02-08 05:13:35'),(2611,14,71,0,0,0,0,1,'2021-02-08 05:13:35'),(2612,14,59,0,0,0,0,1,'2021-02-08 05:13:35'),(2613,14,60,0,0,0,0,1,'2021-02-08 05:13:35'),(2614,14,61,0,0,0,0,1,'2021-02-08 05:13:35'),(2615,14,62,0,0,0,0,1,'2021-02-08 05:13:35'),(2616,14,63,1,1,1,0,1,'2021-02-08 05:13:35'),(2617,14,64,1,1,1,0,1,'2021-02-08 05:13:35'),(2618,14,70,1,1,1,0,1,'2021-02-08 05:13:35'),(2619,14,82,1,1,1,0,1,'2021-02-08 05:13:35'),(2620,14,72,1,1,1,0,1,'2021-02-08 05:13:35'),(2621,14,73,1,1,1,0,1,'2021-02-08 05:13:35'),(2622,14,74,1,1,1,0,1,'2021-02-08 05:13:35'),(2623,14,89,1,1,1,0,1,'2021-02-08 05:13:35'),(2624,14,75,1,1,1,0,1,'2021-02-08 05:13:35'),(2625,14,88,1,1,1,0,1,'2021-02-08 05:13:35'),(2626,14,76,0,0,0,0,1,'2021-02-08 05:13:35'),(2627,14,77,0,0,0,0,1,'2021-02-08 05:13:35'),(2628,14,78,0,0,0,0,1,'2021-02-08 05:13:35'),(2629,14,79,0,0,0,0,1,'2021-02-08 05:13:35'),(2630,14,80,0,0,0,0,1,'2021-02-08 05:13:35'),(2631,14,81,0,0,0,0,1,'2021-02-08 05:13:35'),(2632,14,84,1,1,1,0,1,'2021-02-08 05:13:35'),(2633,14,85,1,1,1,0,1,'2021-02-08 05:13:35'),(2634,14,86,1,1,1,0,1,'2021-02-08 05:13:35'),(2635,14,87,1,1,1,0,1,'2021-02-08 05:13:35'),(2636,16,1,0,0,0,0,1,'2021-09-13 02:19:50'),(2637,16,2,0,0,0,0,1,'2021-09-13 02:19:50'),(2638,16,3,0,0,0,0,1,'2021-09-13 02:19:50'),(2639,16,4,0,0,0,0,1,'2021-09-13 02:19:50'),(2640,16,5,0,0,0,0,1,'2021-09-13 02:19:50'),(2641,16,6,0,0,0,0,1,'2021-09-13 02:19:50'),(2642,16,7,0,0,0,0,1,'2021-09-13 02:19:50'),(2643,16,8,0,0,0,0,1,'2021-09-13 02:19:50'),(2644,16,9,0,0,0,0,1,'2021-09-13 02:19:50'),(2645,16,10,0,0,0,0,1,'2021-09-13 02:19:50'),(2646,16,11,0,0,0,0,1,'2021-09-13 02:19:50'),(2647,16,12,0,0,0,0,1,'2021-09-13 02:19:50'),(2648,16,13,0,0,0,0,1,'2021-09-13 02:19:50'),(2649,16,14,0,0,0,0,1,'2021-09-13 02:19:50'),(2650,16,15,0,0,0,0,1,'2021-09-13 02:19:50'),(2651,16,68,1,1,0,0,1,'2021-09-13 02:19:50'),(2652,16,69,1,1,0,0,1,'2021-09-13 02:19:50'),(2653,16,83,1,1,0,0,1,'2021-09-13 02:19:50'),(2654,16,96,1,1,0,0,1,'2021-09-13 02:19:50'),(2655,16,113,1,1,0,0,1,'2021-09-13 02:19:50'),(2656,16,119,1,0,0,0,1,'2021-09-13 02:19:50'),(2657,16,108,1,0,0,0,1,'2021-09-13 02:19:50'),(2658,16,109,1,0,0,0,1,'2021-09-13 02:19:50'),(2659,16,111,1,0,0,0,1,'2021-09-13 02:19:50'),(2660,16,112,1,0,0,0,1,'2021-09-13 02:19:50'),(2661,16,92,1,0,0,0,1,'2021-09-13 02:19:50'),(2662,16,93,1,0,0,0,1,'2021-09-13 02:19:50'),(2663,16,94,1,0,0,0,1,'2021-09-13 02:19:50'),(2664,16,95,1,0,0,0,1,'2021-09-13 02:19:50'),(2665,16,114,1,0,0,0,1,'2021-09-13 02:19:50'),(2666,16,115,1,0,0,0,1,'2021-09-13 02:19:50'),(2667,16,118,1,0,0,0,1,'2021-09-13 02:19:50'),(2668,16,120,1,0,0,0,1,'2021-09-13 02:19:50'),(2669,16,121,1,0,0,0,1,'2021-09-13 02:19:50'),(2670,16,122,1,0,0,0,1,'2021-09-13 02:19:50'),(2671,16,16,1,0,0,0,1,'2021-09-13 02:19:50'),(2672,16,17,1,0,0,0,1,'2021-09-13 02:19:50'),(2673,16,18,1,0,0,0,1,'2021-09-13 02:19:50'),(2674,16,19,1,0,0,0,1,'2021-09-13 02:19:50'),(2675,16,20,1,0,0,0,1,'2021-09-13 02:19:50'),(2676,16,21,1,0,0,0,1,'2021-09-13 02:19:50'),(2677,16,22,1,0,0,0,1,'2021-09-13 02:19:50'),(2678,16,23,1,0,0,0,1,'2021-09-13 02:19:50'),(2679,16,24,1,0,0,0,1,'2021-09-13 02:19:50'),(2680,16,25,1,0,0,0,1,'2021-09-13 02:19:50'),(2681,16,26,1,0,0,0,1,'2021-09-13 02:19:50'),(2682,16,27,1,0,0,0,1,'2021-09-13 02:19:50'),(2683,16,28,1,0,0,0,1,'2021-09-13 02:19:50'),(2684,16,29,1,0,0,0,1,'2021-09-13 02:19:50'),(2685,16,30,1,0,0,0,1,'2021-09-13 02:19:50'),(2686,16,31,1,0,0,0,1,'2021-09-13 02:19:50'),(2687,16,32,1,0,0,0,1,'2021-09-13 02:19:50'),(2688,16,33,1,0,0,0,1,'2021-09-13 02:19:50'),(2689,16,34,1,0,0,0,1,'2021-09-13 02:19:50'),(2690,16,35,1,0,0,0,1,'2021-09-13 02:19:50'),(2691,16,36,1,0,0,0,1,'2021-09-13 02:19:50'),(2692,16,37,1,0,0,0,1,'2021-09-13 02:19:50'),(2693,16,38,1,0,0,0,1,'2021-09-13 02:19:50'),(2694,16,39,1,0,0,0,1,'2021-09-13 02:19:50'),(2695,16,40,1,0,0,0,1,'2021-09-13 02:19:50'),(2696,16,41,1,0,0,0,1,'2021-09-13 02:19:50'),(2697,16,42,1,0,0,0,1,'2021-09-13 02:19:50'),(2698,16,43,1,0,0,0,1,'2021-09-13 02:19:50'),(2699,16,44,1,0,0,0,1,'2021-09-13 02:19:50'),(2700,16,45,1,0,0,0,1,'2021-09-13 02:19:50'),(2701,16,46,1,0,0,0,1,'2021-09-13 02:19:50'),(2702,16,47,1,0,0,0,1,'2021-09-13 02:19:50'),(2703,16,48,1,0,0,0,1,'2021-09-13 02:19:50'),(2704,16,49,1,0,0,0,1,'2021-09-13 02:19:50'),(2705,16,50,1,0,0,0,1,'2021-09-13 02:19:50'),(2706,16,51,1,0,0,0,1,'2021-09-13 02:19:50'),(2707,16,52,1,0,0,0,1,'2021-09-13 02:19:50'),(2708,16,53,1,0,0,0,1,'2021-09-13 02:19:50'),(2709,16,54,1,0,0,0,1,'2021-09-13 02:19:50'),(2710,16,55,1,0,0,0,1,'2021-09-13 02:19:50'),(2711,16,56,1,0,0,0,1,'2021-09-13 02:19:50'),(2712,16,57,1,0,0,0,1,'2021-09-13 02:19:50'),(2713,16,58,1,0,0,0,1,'2021-09-13 02:19:50'),(2714,16,105,1,0,0,0,1,'2021-09-13 02:19:50'),(2715,16,106,1,0,0,0,1,'2021-09-13 02:19:50'),(2716,16,107,1,0,0,0,1,'2021-09-13 02:19:50'),(2717,16,140,1,1,1,1,1,'2021-09-13 02:19:50'),(2718,16,141,1,1,1,1,1,'2021-09-13 02:19:50'),(2719,16,142,1,1,1,1,1,'2021-09-13 02:19:50'),(2720,16,143,1,1,1,1,1,'2021-09-13 02:19:50'),(2721,16,144,1,1,1,1,1,'2021-09-13 02:19:50'),(2722,16,145,1,1,1,1,1,'2021-09-13 02:19:50'),(2723,16,146,1,1,1,1,1,'2021-09-13 02:19:50'),(2724,16,147,1,1,1,1,1,'2021-09-13 02:19:50'),(2725,16,148,1,1,1,1,1,'2021-09-13 02:19:50'),(2726,16,149,1,1,1,1,1,'2021-09-13 02:19:50'),(2727,16,150,1,1,1,1,1,'2021-09-13 02:19:50'),(2728,16,151,1,1,1,1,1,'2021-09-13 02:19:50'),(2729,16,152,1,1,1,1,1,'2021-09-13 02:19:50'),(2730,16,153,1,1,1,1,1,'2021-09-13 02:19:50'),(2731,16,154,1,1,1,1,1,'2021-09-13 02:19:50'),(2732,16,123,1,0,1,0,1,'2021-09-13 02:19:50'),(2733,16,124,1,0,1,0,1,'2021-09-13 02:19:50'),(2734,16,125,1,0,1,0,1,'2021-09-13 02:19:50'),(2735,16,126,1,0,1,0,1,'2021-09-13 02:19:50'),(2736,16,127,1,0,1,0,1,'2021-09-13 02:19:50'),(2737,16,128,1,0,1,0,1,'2021-09-13 02:19:50'),(2738,16,129,1,0,1,0,1,'2021-09-13 02:19:50'),(2739,16,130,1,0,1,0,1,'2021-09-13 02:19:50'),(2740,16,131,1,0,1,0,1,'2021-09-13 02:19:50'),(2741,16,132,1,0,1,0,1,'2021-09-13 02:19:50'),(2742,16,133,1,0,1,0,1,'2021-09-13 02:19:50'),(2743,16,134,1,0,1,0,1,'2021-09-13 02:19:50'),(2744,16,135,1,0,1,0,1,'2021-09-13 02:19:50'),(2745,16,136,1,0,1,0,1,'2021-09-13 02:19:50'),(2746,16,137,1,0,1,0,1,'2021-09-13 02:19:50'),(2747,16,138,1,0,1,0,1,'2021-09-13 02:19:50'),(2748,16,139,1,0,1,0,1,'2021-09-13 02:19:50'),(2749,16,65,0,0,0,0,1,'2021-09-13 02:19:50'),(2750,16,66,0,0,0,0,1,'2021-09-13 02:19:50'),(2751,16,67,0,0,0,0,1,'2021-09-13 02:19:50'),(2752,16,71,0,0,0,0,1,'2021-09-13 02:19:50'),(2753,16,98,1,0,0,0,1,'2021-09-13 02:19:50'),(2754,16,99,1,0,0,0,1,'2021-09-13 02:19:50'),(2755,16,100,1,0,0,0,1,'2021-09-13 02:19:50'),(2756,16,101,1,0,0,0,1,'2021-09-13 02:19:50'),(2757,16,102,1,0,0,0,1,'2021-09-13 02:19:50'),(2758,16,104,1,0,0,0,1,'2021-09-13 02:19:50'),(2759,16,59,1,0,0,0,1,'2021-09-13 02:19:50'),(2760,16,60,1,0,0,0,1,'2021-09-13 02:19:50'),(2761,16,61,1,0,0,0,1,'2021-09-13 02:19:50'),(2762,16,62,1,0,0,0,1,'2021-09-13 02:19:50'),(2763,16,63,1,0,0,0,1,'2021-09-13 02:19:50'),(2764,16,64,1,0,0,0,1,'2021-09-13 02:19:50'),(2765,16,70,1,0,0,0,1,'2021-09-13 02:19:50'),(2766,16,82,1,0,0,0,1,'2021-09-13 02:19:50'),(2767,16,72,1,0,0,0,1,'2021-09-13 02:19:50'),(2768,16,73,1,0,0,0,1,'2021-09-13 02:19:50'),(2769,16,74,1,0,0,0,1,'2021-09-13 02:19:50'),(2770,16,89,1,0,0,0,1,'2021-09-13 02:19:50'),(2771,16,75,1,0,0,0,1,'2021-09-13 02:19:50'),(2772,16,88,1,0,0,0,1,'2021-09-13 02:19:50'),(2773,16,76,0,0,0,0,1,'2021-09-13 02:19:50'),(2774,16,77,0,0,0,0,1,'2021-09-13 02:19:50'),(2775,16,78,0,0,0,0,1,'2021-09-13 02:19:50'),(2776,16,79,0,0,0,0,1,'2021-09-13 02:19:50'),(2777,16,80,0,0,0,0,1,'2021-09-13 02:19:50'),(2778,16,81,0,0,0,0,1,'2021-09-13 02:19:50'),(2779,16,91,0,0,0,0,1,'2021-09-13 02:19:50'),(2780,16,103,0,0,0,0,1,'2021-09-13 02:19:50'),(2781,16,110,0,0,0,0,1,'2021-09-13 02:19:50'),(2782,16,117,1,1,1,0,1,'2021-09-13 02:19:50'),(2783,16,116,1,1,1,0,1,'2021-09-13 02:19:50'),(2784,16,84,1,0,0,0,1,'2021-09-13 02:19:50'),(2785,16,85,1,0,0,0,1,'2021-09-13 02:19:50'),(2786,16,86,1,0,0,0,1,'2021-09-13 02:19:50'),(2787,16,87,1,0,0,0,1,'2021-09-13 02:19:50'),(2788,16,97,1,0,0,0,1,'2021-09-13 02:19:50');

--
-- Table structure for table `sec_role_tbl`
--

CREATE TABLE `sec_role_tbl` (
  `role_id` int NOT NULL AUTO_INCREMENT,
  `role_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `role_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `create_by` int DEFAULT NULL,
  `date_time` datetime DEFAULT NULL,
  `role_status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sec_role_tbl`
--

INSERT INTO `sec_role_tbl` VALUES (7,'Manager ','Manager Role list.',1,'2019-11-17 11:46:11',1),(12,'Cashier','Cashier',1,'2020-11-29 01:12:42',1),(14,'Moderator','New Role Permission',1,'2021-01-10 06:31:46',1),(15,'Booking','Hotel booking',1,'2021-01-10 09:23:15',1),(16,'Manager In-Charge','Should get access to all operation',1,'2021-09-13 02:19:50',1);

--
-- Table structure for table `sec_user_access_tbl`
--

CREATE TABLE `sec_user_access_tbl` (
  `role_acc_id` int NOT NULL AUTO_INCREMENT,
  `fk_role_id` int NOT NULL,
  `fk_user_id` int NOT NULL,
  PRIMARY KEY (`role_acc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sec_user_access_tbl`
--

INSERT INTO `sec_user_access_tbl` VALUES (7,7,4),(9,1,177),(10,1,3),(11,8,3),(12,1,3),(13,1,3),(14,1,3),(19,7,180),(24,14,193),(28,15,194),(30,14,2),(32,15,197),(33,16,19);

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `storename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `logo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `splash_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `favicon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `vat` int NOT NULL DEFAULT '0',
  `isvatnumshow` int DEFAULT '0',
  `vattinno` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `servicecharge` int NOT NULL DEFAULT '0',
  `discount_type` int NOT NULL DEFAULT '0' COMMENT '0=amount,1=percent',
  `service_chargeType` int NOT NULL DEFAULT '0' COMMENT '0=amount,1=percent',
  `discountrate` decimal(19,3) NOT NULL DEFAULT '0.000',
  `country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `map_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `latitude` double(10,4) DEFAULT NULL,
  `longitude` double(10,4) DEFAULT NULL,
  `currency` int DEFAULT '0',
  `language` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `timezone` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `checkintime` time NOT NULL,
  `checkouttime` time NOT NULL,
  `dateformat` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `site_align` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pricetxt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `powerbytxt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `footer_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `whatsapp_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` VALUES (2,'Hotel Paraiso','Hospedagem de Qualidade','Brasil','hotel@hotelparaiso.com.br','61983057104','assets/img/icons/2025-01-25/U.png','assets/img/icons/2025-01-25/h3.png','assets/img/icons/2025-01-25/U1.png',2,1,NULL,7,1,1,0.000,'Brasil','AIzaSyDlPVswfe6JqjyAMKZorELrNC1rD1Px_so',-16.0867,-47.9853,4,'portuguesbr','Asia/Dhaka','12:00:00','10:00:00','','LTR','Os preços riscados que você vê são baseados nos preços atualmente cotados pela propriedade para uma janela de 30 dias em torno da sua data ','Desenvolvido por: IlloStarUp','Todos os direitos reservados Hotel Paraíso2024©Copyright',NULL);

--
-- Table structure for table `sms_template`
--

CREATE TABLE `sms_template` (
  `id` int NOT NULL AUTO_INCREMENT,
  `template_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `default_status` tinyint NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sms_template`
--

INSERT INTO `sms_template` VALUES (1,'one','your Order {id} is cancel for some reason.','Cancel',0,0,'2021-10-24 10:57:48','0000-00-00 00:00:00'),(2,'two','your order {id} is completed','CompleteOrder',0,1,'2019-01-02 13:58:19','0000-00-00 00:00:00'),(3,'three','your order {id} is processing','Processing',0,1,'2020-03-07 19:48:29','0000-00-00 00:00:00'),(8,'four','Your Order Has been Placed Successfully.','Neworder',1,1,'2020-03-07 19:48:33','0000-00-00 00:00:00');

--
-- Table structure for table `starclass`
--

CREATE TABLE `starclass` (
  `starcalssid` int NOT NULL AUTO_INCREMENT,
  `starclassname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`starcalssid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `starclass`
--


--
-- Table structure for table `sub_order`
--

CREATE TABLE `sub_order` (
  `sub_id` int NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL,
  `customer_id` int DEFAULT NULL,
  `vat` float DEFAULT NULL,
  `discount` decimal(10,2) DEFAULT '0.00',
  `s_charge` float DEFAULT NULL,
  `total_price` float DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0' COMMENT '0=unpaid,1=paid',
  `order_menu_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `adons_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `adons_qty` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`sub_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sub_order`
--


--
-- Table structure for table `subscribe_emaillist`
--

CREATE TABLE `subscribe_emaillist` (
  `emailid` int NOT NULL AUTO_INCREMENT,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dateinsert` datetime NOT NULL,
  PRIMARY KEY (`emailid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subscribe_emaillist`
--


--
-- Table structure for table `supplier`
--

CREATE TABLE `supplier` (
  `supid` int NOT NULL AUTO_INCREMENT,
  `suplier_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `supName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `supEmail` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `supMobile` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `supAddress` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `total_amount` decimal(15,2) DEFAULT '0.00',
  `paid_amount` decimal(15,2) DEFAULT '0.00',
  `due_amount` decimal(15,2) DEFAULT '0.00',
  PRIMARY KEY (`supid`),
  KEY `suplier_code` (`suplier_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `supplier`
--


--
-- Table structure for table `synchronizer_setting`
--

CREATE TABLE `synchronizer_setting` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hostname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `port` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `debug` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `project_root` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `synchronizer_setting`
--


--
-- Table structure for table `table_details`
--

CREATE TABLE `table_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `table_id` int NOT NULL,
  `customer_id` int DEFAULT NULL,
  `order_id` int NOT NULL,
  `time_enter` time NOT NULL,
  `total_people` int NOT NULL,
  `delete_at` int NOT NULL DEFAULT '0',
  `created_at` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `table_details`
--


--
-- Table structure for table `table_setting`
--

CREATE TABLE `table_setting` (
  `settingid` int NOT NULL AUTO_INCREMENT,
  `tableid` int NOT NULL,
  `iconpos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`settingid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `table_setting`
--

INSERT INTO `table_setting` VALUES (1,1,'');

--
-- Table structure for table `tax_settings`
--

CREATE TABLE `tax_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `default_value` float NOT NULL,
  `tax_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `nt` int NOT NULL,
  `reg_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `is_show` tinyint NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tax_settings`
--


--
-- Table structure for table `tbl_assign_kitchen`
--

CREATE TABLE `tbl_assign_kitchen` (
  `assignid` int NOT NULL AUTO_INCREMENT,
  `kitchen_id` int NOT NULL,
  `userid` int NOT NULL,
  PRIMARY KEY (`assignid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_assign_kitchen`
--


--
-- Table structure for table `tbl_bank`
--

CREATE TABLE `tbl_bank` (
  `bankid` int NOT NULL AUTO_INCREMENT,
  `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ac_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ac_number` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `branch` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `signature_pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`bankid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_bank`
--

INSERT INTO `tbl_bank` VALUES (2,'City Bank','Kamal Hassan','3869583','Uttara','./application/modules/hrm/assets/images/2020-01-18/e.jpg');

--
-- Table structure for table `tbl_booking_type_info`
--

CREATE TABLE `tbl_booking_type_info` (
  `btypeinfoid` int NOT NULL AUTO_INCREMENT,
  `booking_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `booking_sourse` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `commissionrate` decimal(10,0) NOT NULL DEFAULT '2',
  `balance` float NOT NULL DEFAULT '0',
  `paid_amount` decimal(10,0) NOT NULL DEFAULT '0',
  `due_amount` decimal(10,0) NOT NULL DEFAULT '0',
  PRIMARY KEY (`btypeinfoid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_booking_type_info`
--


--
-- Table structure for table `tbl_cancelitem`
--

CREATE TABLE `tbl_cancelitem` (
  `cancelid` int NOT NULL AUTO_INCREMENT,
  `orderid` int NOT NULL,
  `foodid` int NOT NULL,
  `varientid` int NOT NULL,
  `quantity` decimal(19,3) NOT NULL DEFAULT '0.000',
  PRIMARY KEY (`cancelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_cancelitem`
--


--
-- Table structure for table `tbl_card_terminal`
--

CREATE TABLE `tbl_card_terminal` (
  `card_terminalid` int NOT NULL AUTO_INCREMENT,
  `terminal_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`card_terminalid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_card_terminal`
--

INSERT INTO `tbl_card_terminal` VALUES (1,'Nexus Terminal');

--
-- Table structure for table `tbl_category`
--

CREATE TABLE `tbl_category` (
  `category_id` int NOT NULL AUTO_INCREMENT,
  `categoryname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `status` int DEFAULT NULL COMMENT '0=inactive,1=active',
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_category`
--

INSERT INTO `tbl_category` VALUES (1,'Beauty Items',1),(3,'Glass Items',1),(4,'Tasty Items',1);

--
-- Table structure for table `tbl_checklist`
--

CREATE TABLE `tbl_checklist` (
  `checklist_id` int NOT NULL AUTO_INCREMENT,
  `taskname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `type` int NOT NULL DEFAULT '1' COMMENT '1=housekeepr,2=laundry',
  `status` int NOT NULL DEFAULT '1' COMMENT '0=inactive,1=active',
  PRIMARY KEY (`checklist_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_checklist`
--


--
-- Table structure for table `tbl_complementary`
--

CREATE TABLE `tbl_complementary` (
  `complementary_id` int NOT NULL AUTO_INCREMENT,
  `roomtype` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `complementaryname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `rate` decimal(10,2) DEFAULT NULL,
  `status` int NOT NULL COMMENT '0=inactive,1=active',
  PRIMARY KEY (`complementary_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_complementary`
--


--
-- Table structure for table `tbl_country`
--

CREATE TABLE `tbl_country` (
  `countryid` int NOT NULL AUTO_INCREMENT,
  `countryname` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`countryid`)
) ENGINE=InnoDB AUTO_INCREMENT=253 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_country`
--

INSERT INTO `tbl_country` VALUES (1,'Afghanistan',1),(2,'Aland Islands',1),(3,'Albania',1),(4,'Algeria',1),(5,'American Samoa',1),(6,'Andorra',1),(7,'Angola',1),(8,'Anguilla',1),(9,'Antarctica',1),(10,'Antigua and Barbuda',1),(11,'Argentina',1),(12,'Armenia',1),(13,'Aruba',1),(14,'Australia',1),(15,'Austria',1),(16,'Azerbaijan',1),(17,'Bahamas',1),(18,'Bahrain',1),(19,'Bangladesh',1),(20,'Barbados',1),(21,'Belarus',1),(22,'Belgium',1),(23,'Belize',1),(24,'Benin',1),(25,'Bermuda',1),(26,'Bhutan',1),(27,'Bolivia',1),(28,'Bonaire, Sint Eustatius and Saba',1),(29,'Bosnia and Herzegovina',1),(30,'Botswana',1),(31,'Bouvet Island',1),(32,'Brazil',1),(33,'British Indian Ocean Territory',1),(34,'Brunei Darussalam',1),(35,'Bulgaria',1),(36,'Burkina Faso',1),(37,'Burundi',1),(38,'Cambodia',1),(39,'Cameroon',1),(40,'Canada',1),(41,'Cape Verde',1),(42,'Cayman Islands',1),(43,'Central African Republic',1),(44,'Chad',1),(45,'Chile',1),(46,'China',1),(47,'Christmas Island',1),(48,'Cocos (Keeling) Islands',1),(49,'Colombia',1),(50,'Comoros',1),(51,'Congo',1),(52,'Congo, Democratic Republic of the Congo',1),(53,'Cook Islands',1),(54,'Costa Rica',1),(55,'Cote D\'Ivoire',1),(56,'Croatia',1),(57,'Cuba',1),(58,'Curacao',1),(59,'Cyprus',1),(60,'Czech Republic',1),(61,'Denmark',1),(62,'Djibouti',1),(63,'Dominica',1),(64,'Dominican Republic',1),(65,'Ecuador',1),(66,'Egypt',1),(67,'El Salvador',1),(68,'Equatorial Guinea',1),(69,'Eritrea',1),(70,'Estonia',1),(71,'Ethiopia',1),(72,'Falkland Islands (Malvinas)',1),(73,'Faroe Islands',1),(74,'Fiji',1),(75,'Finland',1),(76,'France',1),(77,'French Guiana',1),(78,'French Polynesia',1),(79,'French Southern Territories',1),(80,'Gabon',1),(81,'Gambia',1),(82,'Georgia',1),(83,'Germany',1),(84,'Ghana',1),(85,'Gibraltar',1),(86,'Greece',1),(87,'Greenland',1),(88,'Grenada',1),(89,'Guadeloupe',1),(90,'Guam',1),(91,'Guatemala',1),(92,'Guernsey',1),(93,'Guinea',1),(94,'Guinea-Bissau',1),(95,'Guyana',1),(96,'Haiti',1),(97,'Heard Island and Mcdonald Islands',1),(98,'Holy See (Vatican City State)',1),(99,'Honduras',1),(100,'Hong Kong',1),(101,'Hungary',1),(102,'Iceland',1),(103,'India',1),(104,'Indonesia',1),(105,'Iran, Islamic Republic of',1),(106,'Iraq',1),(107,'Ireland',1),(108,'Isle of Man',1),(109,'Israel',1),(110,'Italy',1),(111,'Jamaica',1),(112,'Japan',1),(113,'Jersey',1),(114,'Jordan',1),(115,'Kazakhstan',1),(116,'Kenya',1),(117,'Kiribati',1),(118,'Korea, Democratic People\'s Republic of',1),(119,'Korea, Republic of',1),(120,'Kosovo',1),(121,'Kuwait',1),(122,'Kyrgyzstan',1),(123,'Lao People\'s Democratic Republic',1),(124,'Latvia',1),(125,'Lebanon',1),(126,'Lesotho',1),(127,'Liberia',1),(128,'Libyan Arab Jamahiriya',1),(129,'Liechtenstein',1),(130,'Lithuania',1),(131,'Luxembourg',1),(132,'Macao',1),(133,'Macedonia, the Former Yugoslav Republic of',1),(134,'Madagascar',1),(135,'Malawi',1),(136,'Malaysia',1),(137,'Maldives',1),(138,'Mali',1),(139,'Malta',1),(140,'Marshall Islands',1),(141,'Martinique',1),(142,'Mauritania',1),(143,'Mauritius',1),(144,'Mayotte',1),(145,'Mexico',1),(146,'Micronesia, Federated States of',1),(147,'Moldova, Republic of',1),(148,'Monaco',1),(149,'Mongolia',1),(150,'Montenegro',1),(151,'Montserrat',1),(152,'Morocco',1),(153,'Mozambique',1),(154,'Myanmar',1),(155,'Namibia',1),(156,'Nauru',1),(157,'Nepal',1),(158,'Netherlands',1),(159,'Netherlands Antilles',1),(160,'New Caledonia',1),(161,'New Zealand',1),(162,'Nicaragua',1),(163,'Niger',1),(164,'Nigeria',1),(165,'Niue',1),(166,'Norfolk Island',1),(167,'Northern Mariana Islands',1),(168,'Norway',1),(169,'Oman',1),(170,'Pakistan',1),(171,'Palau',1),(172,'Palestinian Territory, Occupied',1),(173,'Panama',1),(174,'Papua New Guinea',1),(175,'Paraguay',1),(176,'Peru',1),(177,'Philippines',1),(178,'Pitcairn',1),(179,'Poland',1),(180,'Portugal',1),(181,'Puerto Rico',1),(182,'Qatar',1),(183,'Reunion',1),(184,'Romania',1),(185,'Russian Federation',1),(186,'Rwanda',1),(187,'Saint Barthelemy',1),(188,'Saint Helena',1),(189,'Saint Kitts and Nevis',1),(190,'Saint Lucia',1),(191,'Saint Martin',1),(192,'Saint Pierre and Miquelon',1),(193,'Saint Vincent and the Grenadines',1),(194,'Samoa',1),(195,'San Marino',1),(196,'Sao Tome and Principe',1),(197,'Saudi Arabia',1),(198,'Senegal',1),(199,'Serbia',1),(200,'Serbia and Montenegro',1),(201,'Seychelles',1),(202,'Sierra Leone',1),(203,'Singapore',1),(204,'Sint Maarten',1),(205,'Slovakia',1),(206,'Slovenia',1),(207,'Solomon Islands',1),(208,'Somalia',1),(209,'South Africa',1),(210,'South Georgia and the South Sandwich Islands',1),(211,'South Sudan',1),(212,'Spain',1),(213,'Sri Lanka',1),(214,'Sudan',1),(215,'Suriname',1),(216,'Svalbard and Jan Mayen',1),(217,'Swaziland',1),(218,'Sweden',1),(219,'Switzerland',1),(220,'Syrian Arab Republic',1),(221,'Taiwan, Province of China',1),(222,'Tajikistan',1),(223,'Tanzania, United Republic of',1),(224,'Thailand',1),(225,'Timor-Leste',1),(226,'Togo',1),(227,'Tokelau',1),(228,'Tonga',1),(229,'Trinidad and Tobago',1),(230,'Tunisia',1),(231,'Turkey',1),(232,'Turkmenistan',1),(233,'Turks and Caicos Islands',1),(234,'Tuvalu',1),(235,'Uganda',1),(236,'Ukraine',1),(237,'United Arab Emirates',1),(238,'United Kingdom',1),(239,'United States',1),(240,'United States Minor Outlying Islands',1),(241,'Uruguay',1),(242,'Uzbekistan',1),(243,'Vanuatu',1),(244,'Venezuela',1),(245,'Viet Nam',1),(246,'Virgin Islands, British',1),(247,'Virgin Islands, U.s.',1),(248,'Wallis and Futuna',1),(249,'Western Sahara',1),(250,'Yemen',1),(251,'Zambia',1),(252,'Zimbabwe',1);

--
-- Table structure for table `tbl_destroyedproduct`
--

CREATE TABLE `tbl_destroyedproduct` (
  `destroy_id` int NOT NULL AUTO_INCREMENT,
  `product_id` int NOT NULL,
  `quantity` int DEFAULT '0',
  `rec_date` datetime DEFAULT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`destroy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_destroyedproduct`
--


--
-- Table structure for table `tbl_duty_roster`
--

CREATE TABLE `tbl_duty_roster` (
  `roster_id` int NOT NULL AUTO_INCREMENT,
  `rostentry_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `shift_id` int NOT NULL,
  `roster_start` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `roster_end` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `roster_dsys` int NOT NULL,
  PRIMARY KEY (`roster_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_duty_roster`
--


--
-- Table structure for table `tbl_email_permission`
--

CREATE TABLE `tbl_email_permission` (
  `permission_id` int NOT NULL AUTO_INCREMENT,
  `permission` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `status` int DEFAULT '0' COMMENT '0=no,1=yes',
  PRIMARY KEY (`permission_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_email_permission`
--

INSERT INTO `tbl_email_permission` VALUES (1,'booking',0),(2,'checkin',0),(3,'checkout',0);

--
-- Table structure for table `tbl_emproster_assign`
--

CREATE TABLE `tbl_emproster_assign` (
  `sftasnid` int NOT NULL AUTO_INCREMENT,
  `roster_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `emp_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `emp_startroster_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `emp_endroster_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `emp_startroster_time` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `emp_endroster_time` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `is_complete` int NOT NULL DEFAULT '0' COMMENT '1 = attend, 2 = leave, 3=absent',
  `is_edited` int DEFAULT '0' COMMENT '1 = Edited 0 = not edited',
  `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`sftasnid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_emproster_assign`
--


--
-- Table structure for table `tbl_empwork_shift`
--

CREATE TABLE `tbl_empwork_shift` (
  `shiftid` int NOT NULL AUTO_INCREMENT,
  `shift_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `shift_start` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `shift_end` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `shift_duration` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`shiftid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_empwork_shift`
--


--
-- Table structure for table `tbl_financialyear`
--

CREATE TABLE `tbl_financialyear` (
  `fiyear_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `date_time` datetime DEFAULT NULL,
  `is_active` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '1=ended,0=inactive,2=active',
  `create_by` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`fiyear_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_financialyear`
--

INSERT INTO `tbl_financialyear` VALUES (1,'2024-2025','2024-07-13','2025-07-13','2024-07-13 10:32:22','2','1');

--
-- Table structure for table `tbl_flight_details`
--

CREATE TABLE `tbl_flight_details` (
  `flyid` int NOT NULL AUTO_INCREMENT,
  `flight_num` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `airlience_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `departure` datetime NOT NULL,
  `arrival` datetime NOT NULL,
  `fly_from` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fly_to` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`flyid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_flight_details`
--


--
-- Table structure for table `tbl_floor`
--

CREATE TABLE `tbl_floor` (
  `floorid` int NOT NULL AUTO_INCREMENT,
  `floorname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`floorid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_floor`
--

INSERT INTO `tbl_floor` VALUES (1,'first floor',1),(2,'Ground floor',1);

--
-- Table structure for table `tbl_floorplan`
--

CREATE TABLE `tbl_floorplan` (
  `floorplanid` int NOT NULL AUTO_INCREMENT,
  `floorName` int NOT NULL,
  `noofroom` int NOT NULL,
  `startno` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `roomno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`floorplanid`),
  KEY `floorName` (`floorName`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_floorplan`
--

INSERT INTO `tbl_floorplan` VALUES (1,1,10,'1','1'),(2,1,10,'1','2'),(3,1,10,'1','3'),(4,1,10,'1','4'),(5,1,10,'1','5'),(6,1,10,'1','6'),(7,1,10,'1','7'),(8,1,10,'1','8'),(9,1,10,'1','9'),(10,1,10,'1','10');

--
-- Table structure for table `tbl_groupitems`
--

CREATE TABLE `tbl_groupitems` (
  `groupid` int NOT NULL AUTO_INCREMENT,
  `gitemid` int NOT NULL,
  `items` int NOT NULL,
  `item_qty` decimal(10,2) NOT NULL DEFAULT '0.00',
  `varientid` int NOT NULL,
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`groupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_groupitems`
--


--
-- Table structure for table `tbl_guestpayments`
--

CREATE TABLE `tbl_guestpayments` (
  `payid` int NOT NULL AUTO_INCREMENT,
  `bookedid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `invoice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `paydate` datetime NOT NULL,
  `paymenttype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `paymentamount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `details` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `book_type` int DEFAULT '0' COMMENT '0=room, 1=hall room',
  PRIMARY KEY (`payid`),
  KEY `bookedid` (`bookedid`,`invoice`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_guestpayments`
--

INSERT INTO `tbl_guestpayments` VALUES (1,'1','000001','2024-07-13 10:45:36','Cash Payment',100.00,'Advance in Card/Account No:  Bank Name: ',0);

--
-- Table structure for table `tbl_hallroom_booking`
--

CREATE TABLE `tbl_hallroom_booking` (
  `hbid` int NOT NULL AUTO_INCREMENT,
  `customerid` int NOT NULL,
  `invoice_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `booked_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `event_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `event_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `hall_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `hall_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `total_room` int DEFAULT '1',
  `rent` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `totalamount` decimal(10,2) DEFAULT '0.00',
  `paid_amount` decimal(10,2) DEFAULT '0.00',
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `date_time` datetime DEFAULT NULL,
  `people` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1=booked, 2=completed, 3=cancelled',
  `payment_status` int NOT NULL DEFAULT '0' COMMENT '1=paid, 2=partialy paid, 0=unpaid, 3=refunded',
  `seatplan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `remarks` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `advance_remarks` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`hbid`),
  KEY `customerid` (`customerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_hallroom_booking`
--


--
-- Table structure for table `tbl_hallroom_info`
--

CREATE TABLE `tbl_hallroom_info` (
  `hid` int NOT NULL AUTO_INCREMENT,
  `hall_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `person_limit` int DEFAULT NULL,
  `rate` decimal(10,2) DEFAULT '0.00',
  `size` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mesurement` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `seatplan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`hid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_hallroom_info`
--


--
-- Table structure for table `tbl_hallroom_postbill`
--

CREATE TABLE `tbl_hallroom_postbill` (
  `hpbid` int NOT NULL AUTO_INCREMENT,
  `hrbooking` int NOT NULL,
  `taxname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `taxrate` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `scharge` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `refund_charge` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `remarks` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`hpbid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_hallroom_postbill`
--


--
-- Table structure for table `tbl_hallroom_seatplan`
--

CREATE TABLE `tbl_hallroom_seatplan` (
  `hsid` int NOT NULL AUTO_INCREMENT,
  `plan_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`hsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_hallroom_seatplan`
--


--
-- Table structure for table `tbl_hkitem`
--

CREATE TABLE `tbl_hkitem` (
  `item_id` int NOT NULL AUTO_INCREMENT,
  `product_id` int NOT NULL,
  `checklist` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `price` decimal(8,2) NOT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_hkitem`
--


--
-- Table structure for table `tbl_housekeepingrecord`
--

CREATE TABLE `tbl_housekeepingrecord` (
  `hkeeper_id` int NOT NULL AUTO_INCREMENT,
  `assignby` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1',
  `employee_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `roomno` int NOT NULL,
  `date_start` datetime DEFAULT NULL,
  `date_end` datetime DEFAULT NULL,
  `createDate` datetime NOT NULL,
  `all_checklist` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `all_productlist` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `allproductqty` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` int NOT NULL COMMENT '0=pending,1=completed,2=under process',
  PRIMARY KEY (`hkeeper_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_housekeepingrecord`
--


--
-- Table structure for table `tbl_itemaccepted`
--

CREATE TABLE `tbl_itemaccepted` (
  `acid` int NOT NULL AUTO_INCREMENT,
  `orderid` int NOT NULL,
  `menuid` int NOT NULL,
  `varient` int NOT NULL,
  `accepttime` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
  PRIMARY KEY (`acid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_itemaccepted`
--


--
-- Table structure for table `tbl_kitchen`
--

CREATE TABLE `tbl_kitchen` (
  `kitchenid` int NOT NULL AUTO_INCREMENT,
  `kitchen_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `port` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`kitchenid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_kitchen`
--


--
-- Table structure for table `tbl_kitchen_order`
--

CREATE TABLE `tbl_kitchen_order` (
  `ktid` int NOT NULL AUTO_INCREMENT,
  `kitchenid` int NOT NULL,
  `orderid` int NOT NULL,
  `itemid` int NOT NULL,
  `varient` int DEFAULT NULL,
  `addonsuid` int DEFAULT NULL,
  PRIMARY KEY (`ktid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_kitchen_order`
--


--
-- Table structure for table `tbl_laundry`
--

CREATE TABLE `tbl_laundry` (
  `laundry_id` int NOT NULL AUTO_INCREMENT,
  `invoice_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `product_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `checklist` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `operate_by` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `quantity` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
  `item_cost` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `total_cost` decimal(10,0) NOT NULL DEFAULT '0',
  `rec_date` datetime DEFAULT NULL,
  `document` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `status` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '1=paid,0=unpaid',
  PRIMARY KEY (`laundry_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_laundry`
--


--
-- Table structure for table `tbl_laundry_payment`
--

CREATE TABLE `tbl_laundry_payment` (
  `landry_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `total_amount` decimal(10,2) DEFAULT NULL,
  `paid_amount` decimal(10,2) DEFAULT NULL,
  `due_amount` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`landry_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_laundry_payment`
--


--
-- Table structure for table `tbl_menutype`
--

CREATE TABLE `tbl_menutype` (
  `menutypeid` int NOT NULL AUTO_INCREMENT,
  `menutype` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `menu_icon` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`menutypeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_menutype`
--


--
-- Table structure for table `tbl_module_purchasekey`
--

CREATE TABLE `tbl_module_purchasekey` (
  `mpid` int NOT NULL AUTO_INCREMENT,
  `module` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `purchasekey` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `downloaddate` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
  `updatedate` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
  PRIMARY KEY (`mpid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_module_purchasekey`
--


--
-- Table structure for table `tbl_note`
--

CREATE TABLE `tbl_note` (
  `note_id` int NOT NULL AUTO_INCREMENT,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `roomno` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `bookedid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `status` int DEFAULT '0' COMMENT '0=pending,1=solved',
  PRIMARY KEY (`note_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_note`
--


--
-- Table structure for table `tbl_openingbalance`
--

CREATE TABLE `tbl_openingbalance` (
  `opbalance_id` int NOT NULL AUTO_INCREMENT,
  `fiyear_id` int NOT NULL,
  `headcode` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `opening_balance` decimal(10,2) DEFAULT NULL,
  `current_balance` decimal(10,2) DEFAULT NULL,
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`opbalance_id`),
  KEY `fiyear_id` (`fiyear_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_openingbalance`
--

INSERT INTO `tbl_openingbalance` VALUES (1,1,'1020101',0.00,100.00,'Auto inserted while transaction'),(2,1,'30301',0.00,-100.00,'Auto inserted while transaction'),(3,1,'102030101',0.00,0.00,'Auto inserted while transaction');

--
-- Table structure for table `tbl_orderprepare`
--

CREATE TABLE `tbl_orderprepare` (
  `opid` int NOT NULL AUTO_INCREMENT,
  `orderid` int NOT NULL,
  `menuid` int NOT NULL,
  `varient` int NOT NULL,
  `preparetime` datetime NOT NULL DEFAULT '1970-01-01 01:01:01',
  PRIMARY KEY (`opid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_orderprepare`
--


--
-- Table structure for table `tbl_otherguest`
--

CREATE TABLE `tbl_otherguest` (
  `otherguest_id` int NOT NULL AUTO_INCREMENT,
  `bookedid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `customerid` int DEFAULT NULL,
  `guestname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `gender` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `mobile` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `email` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `photo_id_type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `photo_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `front_image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `back_image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `occupant_image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `type` int DEFAULT '0' COMMENT '0=room, 1=hall room',
  PRIMARY KEY (`otherguest_id`),
  KEY `customerid` (`customerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_otherguest`
--


--
-- Table structure for table `tbl_posetting`
--

CREATE TABLE `tbl_posetting` (
  `possettingid` int NOT NULL AUTO_INCREMENT,
  `waiter` int NOT NULL DEFAULT '0' COMMENT '1=show,0=hide',
  `tableid` int NOT NULL DEFAULT '0' COMMENT '1=show,0=hide',
  `cooktime` int NOT NULL DEFAULT '0' COMMENT '1=enable,0=disable',
  `productionsetting` tinyint NOT NULL DEFAULT '0' COMMENT '0=manual,1=auto',
  `tablemaping` int NOT NULL DEFAULT '0' COMMENT '1=enable,0=disable',
  `soundenable` int DEFAULT NULL COMMENT '1=enable,0=disable',
  PRIMARY KEY (`possettingid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_posetting`
--

INSERT INTO `tbl_posetting` VALUES (1,1,1,1,0,1,1);

--
-- Table structure for table `tbl_postedbills`
--

CREATE TABLE `tbl_postedbills` (
  `bill_id` int NOT NULL AUTO_INCREMENT,
  `bookedid` int NOT NULL,
  `taskname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `rate` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `scharge` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `complementary` decimal(10,2) DEFAULT '0.00',
  `credit` decimal(8,2) DEFAULT NULL,
  `additional_charges` decimal(10,2) DEFAULT '0.00',
  `extrabpc` decimal(10,2) DEFAULT '0.00',
  `ex_discount` decimal(10,2) DEFAULT '0.00',
  `swimming_pool` decimal(10,2) DEFAULT '0.00',
  `restaurant` decimal(10,2) NOT NULL DEFAULT '0.00',
  `hallroom` decimal(10,2) NOT NULL DEFAULT '0.00',
  `car_parking` decimal(10,2) NOT NULL DEFAULT '0.00',
  `special_discount` decimal(10,2) DEFAULT '0.00',
  `checkoutdate` datetime DEFAULT NULL,
  `days` int DEFAULT NULL,
  `amount` decimal(11,0) DEFAULT NULL,
  `charge` decimal(10,2) DEFAULT NULL,
  `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`bill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_postedbills`
--


--
-- Table structure for table `tbl_quickordersetting`
--

CREATE TABLE `tbl_quickordersetting` (
  `quickordid` int NOT NULL AUTO_INCREMENT,
  `waiter` int NOT NULL DEFAULT '1' COMMENT '1=show,0=hide',
  `tableid` int NOT NULL DEFAULT '1' COMMENT '1=show,0=hide',
  `cooktime` int NOT NULL DEFAULT '1' COMMENT '1=show,0=hide',
  `soundenable` int NOT NULL DEFAULT '1' COMMENT '1=enable,0=disable',
  `tablemaping` int NOT NULL DEFAULT '1' COMMENT '1=enable,0=disable',
  PRIMARY KEY (`quickordid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_quickordersetting`
--

INSERT INTO `tbl_quickordersetting` VALUES (1,1,1,1,1,1);

--
-- Table structure for table `tbl_razorpay`
--

CREATE TABLE `tbl_razorpay` (
  `id` int NOT NULL AUTO_INCREMENT,
  `status` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_razorpay`
--


--
-- Table structure for table `tbl_reuseableproduct`
--

CREATE TABLE `tbl_reuseableproduct` (
  `reuse_id` int NOT NULL AUTO_INCREMENT,
  `product_id` int DEFAULT NULL,
  `in_use` int DEFAULT '0',
  `in_laundry` int DEFAULT '0',
  `ready` int DEFAULT '0',
  PRIMARY KEY (`reuse_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_reuseableproduct`
--


--
-- Table structure for table `tbl_room_offer`
--

CREATE TABLE `tbl_room_offer` (
  `offerid` int NOT NULL AUTO_INCREMENT,
  `roomid` int NOT NULL,
  `offer` int NOT NULL,
  `offertitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `offertext` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `offer_date` date NOT NULL,
  PRIMARY KEY (`offerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_room_offer`
--


--
-- Table structure for table `tbl_roomnofloorassign`
--

CREATE TABLE `tbl_roomnofloorassign` (
  `roomassignid` int NOT NULL AUTO_INCREMENT,
  `roomid` int DEFAULT NULL,
  `hallid` int DEFAULT NULL,
  `floorid` int NOT NULL,
  `roomno` int NOT NULL,
  `status` int DEFAULT '1' COMMENT '1=ready,2=booked,3=assigned to clean,4=booked and assigned to clean, 5=under maintenance,6=dirty,7=blocked,8=do not reserve',
  PRIMARY KEY (`roomassignid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_roomnofloorassign`
--

INSERT INTO `tbl_roomnofloorassign` VALUES (1,1,NULL,1,1,1),(2,1,NULL,1,5,1),(3,1,NULL,1,9,1);

--
-- Table structure for table `tbl_shippingaddress`
--

CREATE TABLE `tbl_shippingaddress` (
  `shipaddressid` int NOT NULL AUTO_INCREMENT,
  `orderid` int NOT NULL,
  `firstname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lastname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `companyname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `city` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `district` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `country` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `zip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `address2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `DateInserted` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`shipaddressid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_shippingaddress`
--


--
-- Table structure for table `tbl_slider`
--

CREATE TABLE `tbl_slider` (
  `slid` int NOT NULL AUTO_INCREMENT,
  `Sltypeid` int NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `link1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `link2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `link3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `slink` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `status` int NOT NULL DEFAULT '1',
  `delation_status` int NOT NULL DEFAULT '0',
  `width` int NOT NULL DEFAULT '0',
  `height` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`slid`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_slider`
--

INSERT INTO `tbl_slider` VALUES (2,1,'Enjoy Your Stay in CoxsToday','It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.','assets/img/banner/2025-01-30/.jpeg',NULL,NULL,NULL,'#',1,0,1920,1000),(3,1,'Enjoy Your Vacation','It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.','assets/img/banner/2025-01-28/9.jpeg',NULL,NULL,NULL,'#',1,0,1920,1000),(4,2,'home About','test','assets/img/banner/2025-01-28/16.jpeg',NULL,NULL,NULL,'#',1,0,445,408),(6,3,'Aproveite sua estadia com muita qualidade e bom gosto','','',NULL,NULL,NULL,'#',1,0,375,211),(7,3,'Lorem Ipsum  since the 1500  Usd offer','','',NULL,NULL,NULL,'#',1,0,375,211),(8,3,'Credit card that\'s right for you. 200 usd','','',NULL,NULL,NULL,'#',1,0,375,211),(9,3,'In some form, by injected humor','','',NULL,NULL,NULL,'#',1,0,375,211),(10,3,'Many desktop publishing 50 USD','','',NULL,NULL,NULL,'#',1,0,375,211),(11,3,'The point of using 400 USD','','',NULL,NULL,NULL,'#',1,0,660,372),(12,4,'It uses a dictionary of over 200 Latin words','Scenic Travel','assets/img/banner/2025-01-28/17.jpeg',NULL,NULL,NULL,'#',1,0,280,498),(13,4,'Many desktop publishing packages and web page','Southern Travel','assets/img/banner/2025-01-28/18.jpeg',NULL,NULL,NULL,'#',1,0,280,498),(14,4,'Contrary to popular belief, Lorem Ipsum is','Scenic Travel','assets/img/banner/2025-01-28/19.jpeg',NULL,NULL,NULL,'#',1,0,280,498),(15,4,'Various versions have evolved over the years','Scenic Travel','assets/img/banner/2025-01-28/20.jpeg',NULL,NULL,NULL,'#',1,0,280,498),(16,5,'Lauren Cox','Creative Director a','','https://www.facebook.com','https://www.facebook.com','https://www.facebook.com','It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.',1,0,400,490),(17,5,'Jessie Barnett','UI/UX Designer','','https://www.facebook.com','https://www.facebook.com','https://www.facebook.com','Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from',1,0,400,490),(18,5,'Terry Fletcher','Web Developer','','https://www.facebook.com','https://www.facebook.com','https://www.facebook.com','Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from',1,0,400,490),(19,5,'Terry Fletcher','Web Developer','','https://www.facebook.com','https://www.facebook.com','https://www.facebook.com','Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from',1,0,400,490),(20,6,'About tio','','',NULL,NULL,NULL,'#',1,0,640,790),(21,6,'about','','',NULL,NULL,NULL,'#',1,0,470,424),(22,6,'about','','',NULL,NULL,NULL,'#',1,0,470,318),(23,6,'about','','',NULL,NULL,NULL,'#',1,0,314,284),(24,6,'about','','',NULL,NULL,NULL,'#',1,0,454,284),(25,6,'about','','',NULL,NULL,NULL,'#',1,0,810,460),(26,8,'Suite','','assets/img/banner/2025-01-28/.jpeg',NULL,NULL,NULL,'#',1,0,700,700),(27,8,'Jardim','','assets/img/banner/2025-01-28/1.jpeg',NULL,NULL,NULL,'#',1,0,700,700),(29,8,'Auditório','','assets/img/banner/2025-01-28/2.jpeg',NULL,NULL,NULL,'#',1,0,700,700),(30,8,'Escritório','','assets/img/banner/2025-01-28/3.jpeg',NULL,NULL,NULL,'#',1,0,700,700),(32,8,'Quartos','','assets/img/banner/2025-01-28/4.jpeg',NULL,NULL,NULL,'#',1,0,700,700),(33,8,'Recepção','','assets/img/banner/2025-01-28/5.jpeg',NULL,NULL,NULL,'#',1,0,700,700),(34,8,'Entrada do Hotel','','assets/img/banner/2025-01-28/6.jpeg',NULL,NULL,NULL,'#',1,0,700,700),(38,4,'Find the credit card that\'s right for you.','Scenic Travel','assets/img/banner/2025-01-28/21.jpeg',NULL,NULL,NULL,'#',1,0,280,498),(39,1,'Hotel','Baraar ','assets/img/banner/2025-01-28/10.jpeg',NULL,NULL,NULL,'',1,0,1920,1000),(41,9,'Alphabet logo','','',NULL,NULL,NULL,'#',1,0,104,35),(42,9,'Amazon','','',NULL,NULL,NULL,'#',1,0,104,35),(43,9,'Fitbit','','',NULL,NULL,NULL,'#',1,0,104,35),(44,9,'Google','','',NULL,NULL,NULL,'#',1,0,104,35),(45,9,'Paypal','','',NULL,NULL,NULL,'#',1,0,104,35),(46,9,'Samsung','','',NULL,NULL,NULL,'#',1,0,104,35),(47,9,'Shopify','','',NULL,NULL,NULL,'#',1,0,104,35),(48,9,'Slack','','',NULL,NULL,NULL,'#',1,0,104,35),(49,9,'Stripe','','',NULL,NULL,NULL,'',1,0,104,35),(50,10,'É quase seu','Precisamos apenas de mais alguns detalhes para confirmar sua reserva no Hotel Paraíso','',NULL,NULL,NULL,'#',1,0,50,50),(51,10,' Sem surpresas','Pague o preço que você vê – sem taxas de reserva!','',NULL,NULL,NULL,'#',1,0,50,50),(52,10,'Sua reserva é segura','Seus dados são protegidos por uma conexão segura.','',NULL,NULL,NULL,'#',1,0,50,50),(53,11,'Bed','','',NULL,NULL,NULL,'#',1,0,22,22),(54,11,'Free WiFi','','',NULL,NULL,NULL,'#',1,0,22,25),(55,11,'Balcony, City / Landmark / Garden view','','',NULL,NULL,NULL,'#',1,0,22,25),(56,11,'Flat-screen TV','','',NULL,NULL,NULL,'#',1,0,22,25),(57,11,'Facilities for guests with disabilities','','',NULL,NULL,NULL,'#',1,0,22,25),(58,12,'Save up to 10%','','assets/img/banner/2025-01-28/d.png',NULL,NULL,NULL,'#',1,0,40,40),(59,12,'Best Rate Guarantee','','assets/img/banner/2025-01-28/h.png',NULL,NULL,NULL,'#',1,0,40,40),(60,12,'Free Wi-Fi','','assets/img/banner/2025-01-28/w.png',NULL,NULL,NULL,'#',1,0,40,40),(61,12,'Enjoy Free Nights','','assets/img/banner/2025-01-28/m.png',NULL,NULL,NULL,'#',1,0,40,40),(62,3,'Printer simply dummy 500 USD','','',NULL,NULL,NULL,'#',1,0,375,211),(63,3,'Lorem Ipsum is simply dummy 100 usd','','',NULL,NULL,NULL,'#',1,0,375,211),(68,13,'1000','Usuários ativos mensais','','10',NULL,NULL,NULL,1,0,0,0),(69,13,'15','\r\nMembros da equipe','','1',NULL,NULL,NULL,1,0,0,0),(70,13,'300','Comentários Positivos','','10',NULL,NULL,NULL,1,0,0,0),(71,13,'4590','Tempo de atividade ','','10',NULL,NULL,NULL,1,0,0,0),(72,14,'Endereço','Endereço: Q. 16, 13 - Valparaizo I, Valparaíso de Goiás - GO Cep: 72876-580','',NULL,NULL,NULL,NULL,1,0,0,0),(73,14,'WhatsApp','61983057103','',NULL,NULL,NULL,NULL,1,0,0,0),(74,14,'Email','hotelparaisogo@gmail.com','',NULL,NULL,NULL,NULL,1,0,0,0),(75,14,'Instagram','@hotelparaisogo','',NULL,NULL,NULL,NULL,1,0,0,0),(81,15,'Instragram',NULL,'','https://www.instagram.com/hotelparaisogo',NULL,NULL,NULL,1,0,0,0),(82,15,'Twitter',NULL,'','https://twitter.com/',NULL,NULL,NULL,1,0,0,0),(83,15,'Dribble',NULL,'','https://dribbble.com/',NULL,NULL,NULL,1,0,0,0),(84,15,'Facebook',NULL,'','https://www.facebook.com/',NULL,NULL,NULL,1,0,0,0),(85,1,NULL,NULL,'assets/img/banner/2025-01-28/14.jpeg',NULL,NULL,NULL,NULL,1,0,500,1000),(91,8,'Hidromassagem',NULL,'assets/img/banner/2025-01-28/7.jpeg',NULL,NULL,NULL,NULL,1,0,700,700);

--
-- Table structure for table `tbl_slider_type`
--

CREATE TABLE `tbl_slider_type` (
  `stype_id` int NOT NULL AUTO_INCREMENT,
  `STypeName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `delation_status` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`stype_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_slider_type`
--

INSERT INTO `tbl_slider_type` VALUES (1,'Home Slider',0),(2,'Home Middle',0),(3,'Top Offers',0),(4,'Explore Destination',0),(5,'About Team',0),(6,'About Top',0),(7,'About Brand',0),(8,'gallery',0),(9,'Company',0),(10,'Booking Conditions',0),(11,'Facility',0),(12,'Home below slider',0);

--
-- Table structure for table `tbl_soundsetting`
--

CREATE TABLE `tbl_soundsetting` (
  `soundid` int NOT NULL AUTO_INCREMENT,
  `nofitysound` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `addtocartsound` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`soundid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_soundsetting`
--

INSERT INTO `tbl_soundsetting` VALUES (1,'assets/2021-03-21/b1.mp3','h');

--
-- Table structure for table `tbl_state`
--

CREATE TABLE `tbl_state` (
  `stateid` int NOT NULL AUTO_INCREMENT,
  `countryid` int NOT NULL,
  `statename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`stateid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_state`
--


--
-- Table structure for table `tbl_stripe`
--

CREATE TABLE `tbl_stripe` (
  `id` int NOT NULL AUTO_INCREMENT,
  `status` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_stripe`
--


--
-- Table structure for table `tbl_tablefloor`
--

CREATE TABLE `tbl_tablefloor` (
  `tbfloorid` int NOT NULL AUTO_INCREMENT,
  `floorName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`tbfloorid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_tablefloor`
--

INSERT INTO `tbl_tablefloor` VALUES (1,'ground floor');

--
-- Table structure for table `tbl_tax`
--

CREATE TABLE `tbl_tax` (
  `taxsettings` int NOT NULL AUTO_INCREMENT,
  `tax` int NOT NULL DEFAULT '0' COMMENT '1=show,0=hide',
  PRIMARY KEY (`taxsettings`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_tax`
--

INSERT INTO `tbl_tax` VALUES (1,0);

--
-- Table structure for table `tbl_taxmgt`
--

CREATE TABLE `tbl_taxmgt` (
  `tax_id` int NOT NULL AUTO_INCREMENT,
  `taxname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `rate` decimal(8,2) DEFAULT '2.00',
  `reg_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `isactive` int DEFAULT '1',
  PRIMARY KEY (`tax_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_taxmgt`
--


--
-- Table structure for table `tbl_thirdparty_customer`
--

CREATE TABLE `tbl_thirdparty_customer` (
  `companyId` int NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `commision` decimal(10,2) DEFAULT '0.00',
  PRIMARY KEY (`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_thirdparty_customer`
--


--
-- Table structure for table `tbl_updateitems`
--

CREATE TABLE `tbl_updateitems` (
  `updateid` int NOT NULL AUTO_INCREMENT,
  `ordid` int NOT NULL,
  `menuid` int NOT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `adonsqty` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `addonsid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `varientid` int NOT NULL,
  `addonsuid` int DEFAULT NULL,
  `isupdate` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `insertdate` date DEFAULT '0000-00-00',
  PRIMARY KEY (`updateid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_updateitems`
--


--
-- Table structure for table `tbl_vehicle_booking`
--

CREATE TABLE `tbl_vehicle_booking` (
  `vbkid` int NOT NULL AUTO_INCREMENT,
  `cust_id` int NOT NULL,
  `vehicle_id` int NOT NULL,
  `flight_id` int NOT NULL,
  `transportation_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `transportation_time` datetime NOT NULL,
  `driver_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`vbkid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_vehicle_booking`
--


--
-- Table structure for table `tbl_vehicle_details`
--

CREATE TABLE `tbl_vehicle_details` (
  `vdsid` int NOT NULL AUTO_INCREMENT,
  `vehicle_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `vehicle_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `fuel_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `seat_capacity` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`vdsid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_vehicle_details`
--


--
-- Table structure for table `tbl_version_checker`
--

CREATE TABLE `tbl_version_checker` (
  `vid` int NOT NULL AUTO_INCREMENT,
  `version` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `disable` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`vid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_version_checker`
--

INSERT INTO `tbl_version_checker` VALUES (1,'0',0);

--
-- Table structure for table `tbl_wakeup_call`
--

CREATE TABLE `tbl_wakeup_call` (
  `wapupid` int NOT NULL AUTO_INCREMENT,
  `custid` int NOT NULL,
  `wakeupcall_time` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`wapupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_wakeup_call`
--


--
-- Table structure for table `tbl_widget`
--

CREATE TABLE `tbl_widget` (
  `widgetid` int NOT NULL AUTO_INCREMENT,
  `widget_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `widget_title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `widget_desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`widgetid`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_widget`
--

INSERT INTO `tbl_widget` VALUES (1,'Qualidade','Excelência em hospedagem','Tenha uma experiência única conosco'),(2,'Booking Conditions','Booking Conditions','<h6 class=\"font-weight-bold\">Cancellation Policy</h6>\r\n<p>You\'ll be charged the total price if you cancel your booking.</p>\r\n<h6 class=\"font-weight-bold\">Prepayment policy</h6>\r\n<p>No prepayment is needed.</p>\r\n<h6 class=\"font-weight-bold\">Meal plan</h6>\r\n<p class=\"mb-0\">Continental breakfast costs BDT 502 per person per night.</p>\r\n<p class=\"mb-0\">Lunch costs BDT 1,180 per person per night.</p>\r\n<p>Dinner costs BDT 1,180 per person per night.</p>'),(3,'','O conforto está perfeitamente combinado aqui','Se hospedar no Hotel Paraíso é uma experiência única! Aqui, você encontra conforto, atendimento de excelência e uma estrutura perfeita para relaxar ou se divertir. Com acomodações aconchegante, cada momento no Hotel Paraíso se torna inesquecível. Descubra o verdadeiro significado de descansar com estilo'),(4,'Top Offer','As melhores ofertas desta semana','Um Hotel é um destino independente que pode atender a todas as suas necessidades de hospedagem em um só lugar.'),(5,' Seu Destino',' Explore destinos e experiências','Nossos hóspedes sempre com estilo. Mencione @hotelparaisogo no Instagram para ter uma chance de aparecer!'),(6,'','24 horas ','Para atender os mais exigentes públicos '),(7,'',' Economize até 10%','Os membros têm acesso a descontos exclusivos no Hotel Paraíso Ainda não é membro? Corra'),(8,'','Garantia do Melhor serviço','Se você encontrar uma tarifa on-line mais baixa com mesmo nível de qualidade, nós a igualaremos e lhe daremos um desconto adicional de 15% na sua estadia.'),(9,'',' Wi-Fi Grátis','Conexão Rápida e segura'),(10,'','Aproveite noites agradáveis','Serviço de qualidade sem cobrar a mais por isso'),(11,'ourteam',' Nossa equipe','\r\nConheça as pessoas que fazem coisas incríveis\r\n'),(12,'small team',' Equipe pequena Grandes corações.','Nosso foco é sempre encontrar as melhores pessoas para trabalhar. Nosso nível é alto'),(13,'about Middle',' Confiável por milhares de usuários','Nossos hóspedes sempre  com estilo. Mencione @hotelparaisogo no Instagram para ter uma chance de aparecer!'),(14,'call number','CALL ANYTIME','0741236589'),(15,'contact Email','EMAIL US','<div class=\"wrapper\"><footer class=\"dark\">\r\n<div class=\"subfooter\">\r\n<div class=\"container\">\r\n<div class=\"row\">\r\n<div class=\"col-md-6\">\r\n<div class=\"social-media\">reservation@xainhotel.comÂ  Â </div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</footer></div>'),(16,'address','Address','<p>Plot-7, Road-02, Hotel Motel Zone, Francisco Road,Â United States</p>\r\n<p>info@hotelthecoxtoday.com</p>'),(17,'phone','Phone & WhatsApp Number','0892 555 98 449'),(18,'Email','Email','<p>info@hotelthecoxtoday.com</p>'),(19,'let us',' Deixe-nos ouvir de você diretamente!','Nossos hóspedes sempre com estilo. Mencione @hotelparaisogo no Instagram para ter uma chance de aparecer!'),(20,'Privacy','Privacy At a glance ','What is Lorem Ipsum Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.\n\nContacting us: If you have any questions about this Privacy Policy, the practices of this site, or your dealings with this site, please contact us'),(21,'Terms','Terms & Conditions','Terms of Use\nOur Site may use \"cookies\" to enhance User experience. User\'s web browser places cookies on their hard drive for record-keeping purposes and sometimes to track information about them. User may choose to set their web browser to refuse cookies, or to alert you when cookies are being sent. If they do so, note that some parts of the Site may not function properly\n'),(22,'footer','footer left','<p>Plot-7, Road-02, Hotel Motel Zone, Francisco Road,Â United States</p>\r\n<p>info@hotelthecoxtoday.com</p>'),(23,'Footer first','Pages','<ul class=\"footer-link list-unstyled menu mb-0\">\r\n<li class=\"mb-2\"><a class=\"link d-block font-weight-500\" href=\"hotel\">Home</a></li>\r\n<li class=\"mb-2\"><a class=\"link d-block font-weight-500\" href=\"about\">About</a></li>\r\n<li class=\"mb-2\"><a class=\"link d-block font-weight-500\" href=\"contact\">Contact Us</a></li>\r\n<li class=\"mb-2\"><a class=\"link d-block font-weight-500\" href=\"gallery\">Gallery</a></li>\r\n</ul>'),(24,'footer second','Social Links','<ul class=\"list-unstyled social-icon\">\r\n<li><a href=\"https://instragram.com/\" target=\"_blank\" rel=\"noopener noreferrer\"> <i class=\"fab fa-instagram icon-wrap\"></i> <span>Instagram </span> </a></li>\r\n<li><a href=\"https://twitter.com/\" target=\"_blank\" rel=\"noopener noreferrer\"> <i class=\"fab fa-twitter icon-wrap\"></i> <span>Twitter</span> </a></li>\r\n<li><a href=\"https://dribble.com/\" target=\"_blank\" rel=\"noopener noreferrer\"> <i class=\"fab fa-dribbble icon-wrap\"></i> <span>Dribbble</span> </a></li>\r\n<li><a href=\"https://facebook.com/\" target=\"_blank\" rel=\"noopener noreferrer\"> <i class=\"fab fa-facebook-f icon-wrap\"></i> <span>Facebook</span> </a></li>\r\n</ul>'),(25,'footer 3rd','About spacial','<ul class=\"footer-link list-unstyled menu mb-0\">\r\n<li class=\"mb-2\"><a class=\"link d-block font-weight-500\" href=\"#\">Home Pages</a></li>\r\n<li class=\"mb-2\"><a class=\"link d-block font-weight-500\" href=\"#\">Theme Features</a></li>\r\n<li class=\"mb-2\"><a class=\"link d-block font-weight-500\" href=\"#\">Services</a></li>\r\n<li class=\"mb-2\"><a class=\"link d-block font-weight-500\" href=\"#\">StoreFront</a></li>\r\n<li class=\"mb-2\"><a class=\"link d-block font-weight-500\" href=\"#\">Portfolio</a></li>\r\n</ul>'),(26,'widget four','Company Policy','<ul class=\"footer-link list-unstyled menu mb-0\">\r\n<li class=\"mb-2\"><a class=\"link d-block font-weight-500\" href=\"privacy\">Privacy</a></li>\r\n<li class=\"mb-2\"><a class=\"link d-block font-weight-500\" href=\"terms\">Terms & Conditions</a></li>\r\n</ul>'),(27,'Overview','','<div class=\"col-6 mb-3 col-lg-3 mb-lg-0\"><span class=\"numscroller display-4 text-primary d-block\" data-min=\"1\" data-max=\"52147\" data-delay=\"5\" data-increment=\"100\">52147</span> <span class=\"h6\">Monthly Active Users</span></div>\r\n<div class=\"col-6 mb-3 col-lg-3 mb-lg-0\"><span class=\"numscroller display-4 text-primary d-block\" data-min=\"1\" data-max=\"130\" data-delay=\"5\" data-increment=\"10\">130</span> <span class=\"h6\">Team Members</span></div>\r\n<div class=\"col-6 mb-3 col-lg-3 mb-lg-0\"><span class=\"numscroller display-4 text-primary d-block\" data-min=\"1\" data-max=\"1235\" data-delay=\"5\" data-increment=\"10\">1235</span> <span class=\"h6\">User Projects Published</span></div>\r\n<div class=\"col-6 mb-3 col-lg-3 mb-lg-0\"><span class=\"numscroller display-4 text-primary d-block\" data-min=\"1\" data-max=\"4591\" data-delay=\"5\" data-increment=\"10\">4591</span> <span class=\"h6\">Server Uptime</span></div>'),(28,'Social Icons','Lorem ipsum dolor sit amet, consectetur adipisicing elit. Recusandae asperiores.',''),(29,' Receba atualizações e ofertas exclusivas','Inscreva-se em nossa newsletter para ser o primeiro a saber sobre','novas vagas, ofertas e muito mais.'),(30,'','Free cancellation',NULL),(31,'',NULL,'www.facebook.com'),(32,'',NULL,'www.facebook.com'),(33,'',NULL,'www.facebook.com'),(34,'',NULL,'www.facebook.com'),(35,'','Política de Cancelamento','You\'ll be charged the total price if you cancel your booking.'),(36,'',' Política de pré-pagamento','\r\nNão é necessário pré-pagamento.'),(37,'',' Plano de refeições','Não há refeição no momento');

--
-- Table structure for table `timezone`
--

CREATE TABLE `timezone` (
  `id` int NOT NULL AUTO_INCREMENT,
  `convention` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `zone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=425 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `timezone`
--

INSERT INTO `timezone` VALUES (1,'AD','Europe/Andorra'),(2,'AE','Asia/Dubai'),(3,'AF','Asia/Kabul'),(4,'AG','America/Antigua'),(5,'AI','America/Anguilla'),(6,'AL','Europe/Tirane'),(7,'AM','Asia/Yerevan'),(8,'AO','Africa/Luanda'),(9,'AQ','Antarctica/McMurdo'),(10,'AQ','Antarctica/Casey'),(11,'AQ','Antarctica/Davis'),(12,'AQ','Antarctica/DumontDUrville'),(13,'AQ','Antarctica/Mawson'),(14,'AQ','Antarctica/Palmer'),(15,'AQ','Antarctica/Rothera'),(16,'AQ','Antarctica/Syowa'),(17,'AQ','Antarctica/Troll'),(18,'AQ','Antarctica/Vostok'),(19,'AR','America/Argentina/Buenos_Aires'),(20,'AR','America/Argentina/Cordoba'),(21,'AR','America/Argentina/Salta'),(22,'AR','America/Argentina/Jujuy'),(23,'AR','America/Argentina/Tucuman'),(24,'AR','America/Argentina/Catamarca'),(25,'AR','America/Argentina/La_Rioja'),(26,'AR','America/Argentina/San_Juan'),(27,'AR','America/Argentina/Mendoza'),(28,'AR','America/Argentina/San_Luis'),(29,'AR','America/Argentina/Rio_Gallegos'),(30,'AR','America/Argentina/Ushuaia'),(31,'AS','Pacific/Pago_Pago'),(32,'AT','Europe/Vienna'),(33,'AU','Australia/Lord_Howe'),(34,'AU','Antarctica/Macquarie'),(35,'AU','Australia/Hobart'),(36,'AU','Australia/Melbourne'),(37,'AU','Australia/Sydney'),(38,'AU','Australia/Broken_Hill'),(39,'AU','Australia/Brisbane'),(40,'AU','Australia/Lindeman'),(41,'AU','Australia/Adelaide'),(42,'AU','Australia/Darwin'),(43,'AU','Australia/Perth'),(44,'AU','Australia/Eucla'),(45,'AW','America/Aruba'),(46,'AX','Europe/Mariehamn'),(47,'AZ','Asia/Baku'),(48,'BA','Europe/Sarajevo'),(49,'BB','America/Barbados'),(50,'BD','Asia/Dhaka'),(51,'BE','Europe/Brussels'),(52,'BF','Africa/Ouagadougou'),(53,'BG','Europe/Sofia'),(54,'BH','Asia/Bahrain'),(55,'BI','Africa/Bujumbura'),(56,'BJ','Africa/Porto-Novo'),(57,'BL','America/St_Barthelemy'),(58,'BM','Atlantic/Bermuda'),(59,'BN','Asia/Brunei'),(60,'BO','America/La_Paz'),(61,'BQ','America/Kralendijk'),(62,'BR','America/Noronha'),(63,'BR','America/Belem'),(64,'BR','America/Fortaleza'),(65,'BR','America/Recife'),(66,'BR','America/Araguaina'),(67,'BR','America/Maceio'),(68,'BR','America/Bahia'),(69,'BR','America/Sao_Paulo'),(70,'BR','America/Campo_Grande'),(71,'BR','America/Cuiaba'),(72,'BR','America/Santarem'),(73,'BR','America/Porto_Velho'),(74,'BR','America/Boa_Vista'),(75,'BR','America/Manaus'),(76,'BR','America/Eirunepe'),(77,'BR','America/Rio_Branco'),(78,'BS','America/Nassau'),(79,'BT','Asia/Thimphu'),(80,'BW','Africa/Gaborone'),(81,'BY','Europe/Minsk'),(82,'BZ','America/Belize'),(83,'CA','America/St_Johns'),(84,'CA','America/Halifax'),(85,'CA','America/Glace_Bay'),(86,'CA','America/Moncton'),(87,'CA','America/Goose_Bay'),(88,'CA','America/Blanc-Sablon'),(89,'CA','America/Toronto'),(90,'CA','America/Nipigon'),(91,'CA','America/Thunder_Bay'),(92,'CA','America/Iqaluit'),(93,'CA','America/Pangnirtung'),(94,'CA','America/Atikokan'),(95,'CA','America/Winnipeg'),(96,'CA','America/Rainy_River'),(97,'CA','America/Resolute'),(98,'CA','America/Rankin_Inlet'),(99,'CA','America/Regina'),(100,'CA','America/Swift_Current'),(101,'CA','America/Edmonton'),(102,'CA','America/Cambridge_Bay'),(103,'CA','America/Yellowknife'),(104,'CA','America/Inuvik'),(105,'CA','America/Creston'),(106,'CA','America/Dawson_Creek'),(107,'CA','America/Fort_Nelson'),(108,'CA','America/Whitehorse'),(109,'CA','America/Dawson'),(110,'CA','America/Vancouver'),(111,'CC','Indian/Cocos'),(112,'CD','Africa/Kinshasa'),(113,'CD','Africa/Lubumbashi'),(114,'CF','Africa/Bangui'),(115,'CG','Africa/Brazzaville'),(116,'CH','Europe/Zurich'),(117,'CI','Africa/Abidjan'),(118,'CK','Pacific/Rarotonga'),(119,'CL','America/Santiago'),(120,'CL','America/Punta_Arenas'),(121,'CL','Pacific/Easter'),(122,'CM','Africa/Douala'),(123,'CN','Asia/Shanghai'),(124,'CN','Asia/Urumqi'),(125,'CO','America/Bogota'),(126,'CR','America/Costa_Rica'),(127,'CU','America/Havana'),(128,'CV','Atlantic/Cape_Verde'),(129,'CW','America/Curacao'),(130,'CX','Indian/Christmas'),(131,'CY','Asia/Nicosia'),(132,'CY','Asia/Famagusta'),(133,'CZ','Europe/Prague'),(134,'DE','Europe/Berlin'),(135,'DE','Europe/Busingen'),(136,'DJ','Africa/Djibouti'),(137,'DK','Europe/Copenhagen'),(138,'DM','America/Dominica'),(139,'DO','America/Santo_Domingo'),(140,'DZ','Africa/Algiers'),(141,'EC','America/Guayaquil'),(142,'EC','Pacific/Galapagos'),(143,'EE','Europe/Tallinn'),(144,'EG','Africa/Cairo'),(145,'EH','Africa/El_Aaiun'),(146,'ER','Africa/Asmara'),(147,'ES','Europe/Madrid'),(148,'ES','Africa/Ceuta'),(149,'ES','Atlantic/Canary'),(150,'ET','Africa/Addis_Ababa'),(151,'FI','Europe/Helsinki'),(152,'FJ','Pacific/Fiji'),(153,'FK','Atlantic/Stanley'),(154,'FM','Pacific/Chuuk'),(155,'FM','Pacific/Pohnpei'),(156,'FM','Pacific/Kosrae'),(157,'FO','Atlantic/Faroe'),(158,'FR','Europe/Paris'),(159,'GA','Africa/Libreville'),(160,'GB','Europe/London'),(161,'GD','America/Grenada'),(162,'GE','Asia/Tbilisi'),(163,'GF','America/Cayenne'),(164,'GG','Europe/Guernsey'),(165,'GH','Africa/Accra'),(166,'GI','Europe/Gibraltar'),(167,'GL','America/Nuuk'),(168,'GL','America/Danmarkshavn'),(169,'GL','America/Scoresbysund'),(170,'GL','America/Thule'),(171,'GM','Africa/Banjul'),(172,'GN','Africa/Conakry'),(173,'GP','America/Guadeloupe'),(174,'GQ','Africa/Malabo'),(175,'GR','Europe/Athens'),(176,'GS','Atlantic/South_Georgia'),(177,'GT','America/Guatemala'),(178,'GU','Pacific/Guam'),(179,'GW','Africa/Bissau'),(180,'GY','America/Guyana'),(181,'HK','Asia/Hong_Kong'),(182,'HN','America/Tegucigalpa'),(183,'HR','Europe/Zagreb'),(184,'HT','America/Port-au-Prince'),(185,'HU','Europe/Budapest'),(186,'ID','Asia/Jakarta'),(187,'ID','Asia/Pontianak'),(188,'ID','Asia/Makassar'),(189,'ID','Asia/Jayapura'),(190,'IE','Europe/Dublin'),(191,'IL','Asia/Jerusalem'),(192,'IM','Europe/Isle_of_Man'),(193,'IN','Asia/Kolkata'),(194,'IO','Indian/Chagos'),(195,'IQ','Asia/Baghdad'),(196,'IR','Asia/Tehran'),(197,'IS','Atlantic/Reykjavik'),(198,'IT','Europe/Rome'),(199,'JE','Europe/Jersey'),(200,'JM','America/Jamaica'),(201,'JO','Asia/Amman'),(202,'JP','Asia/Tokyo'),(203,'KE','Africa/Nairobi'),(204,'KG','Asia/Bishkek'),(205,'KH','Asia/Phnom_Penh'),(206,'KI','Pacific/Tarawa'),(207,'KI','Pacific/Kanton'),(208,'KI','Pacific/Kiritimati'),(209,'KM','Indian/Comoro'),(210,'KN','America/St_Kitts'),(211,'KP','Asia/Pyongyang'),(212,'KR','Asia/Seoul'),(213,'KW','Asia/Kuwait'),(214,'KY','America/Cayman'),(215,'KZ','Asia/Almaty'),(216,'KZ','Asia/Qyzylorda'),(217,'KZ','Asia/Qostanay'),(218,'KZ','Asia/Aqtobe'),(219,'KZ','Asia/Aqtau'),(220,'KZ','Asia/Atyrau'),(221,'KZ','Asia/Oral'),(222,'LA','Asia/Vientiane'),(223,'LB','Asia/Beirut'),(224,'LC','America/St_Lucia'),(225,'LI','Europe/Vaduz'),(226,'LK','Asia/Colombo'),(227,'LR','Africa/Monrovia'),(228,'LS','Africa/Maseru'),(229,'LT','Europe/Vilnius'),(230,'LU','Europe/Luxembourg'),(231,'LV','Europe/Riga'),(232,'LY','Africa/Tripoli'),(233,'MA','Africa/Casablanca'),(234,'MC','Europe/Monaco'),(235,'MD','Europe/Chisinau'),(236,'ME','Europe/Podgorica'),(237,'MF','America/Marigot'),(238,'MG','Indian/Antananarivo'),(239,'MH','Pacific/Majuro'),(240,'MH','Pacific/Kwajalein'),(241,'MK','Europe/Skopje'),(242,'ML','Africa/Bamako'),(243,'MM','Asia/Yangon'),(244,'MN','Asia/Ulaanbaatar'),(245,'MN','Asia/Hovd'),(246,'MN','Asia/Choibalsan'),(247,'MO','Asia/Macau'),(248,'MP','Pacific/Saipan'),(249,'MQ','America/Martinique'),(250,'MR','Africa/Nouakchott'),(251,'MS','America/Montserrat'),(252,'MT','Europe/Malta'),(253,'MU','Indian/Mauritius'),(254,'MV','Indian/Maldives'),(255,'MW','Africa/Blantyre'),(256,'MX','America/Mexico_City'),(257,'MX','America/Cancun'),(258,'MX','America/Merida'),(259,'MX','America/Monterrey'),(260,'MX','America/Matamoros'),(261,'MX','America/Mazatlan'),(262,'MX','America/Chihuahua'),(263,'MX','America/Ojinaga'),(264,'MX','America/Hermosillo'),(265,'MX','America/Tijuana'),(266,'MX','America/Bahia_Banderas'),(267,'MY','Asia/Kuala_Lumpur'),(268,'MY','Asia/Kuching'),(269,'MZ','Africa/Maputo'),(270,'NA','Africa/Windhoek'),(271,'NC','Pacific/Noumea'),(272,'NE','Africa/Niamey'),(273,'NF','Pacific/Norfolk'),(274,'NG','Africa/Lagos'),(275,'NI','America/Managua'),(276,'NL','Europe/Amsterdam'),(277,'NO','Europe/Oslo'),(278,'NP','Asia/Kathmandu'),(279,'NR','Pacific/Nauru'),(280,'NU','Pacific/Niue'),(281,'NZ','Pacific/Auckland'),(282,'NZ','Pacific/Chatham'),(283,'OM','Asia/Muscat'),(284,'PA','America/Panama'),(285,'PE','America/Lima'),(286,'PF','Pacific/Tahiti'),(287,'PF','Pacific/Marquesas'),(288,'PF','Pacific/Gambier'),(289,'PG','Pacific/Port_Moresby'),(290,'PG','Pacific/Bougainville'),(291,'PH','Asia/Manila'),(292,'PK','Asia/Karachi'),(293,'PL','Europe/Warsaw'),(294,'PM','America/Miquelon'),(295,'PN','Pacific/Pitcairn'),(296,'PR','America/Puerto_Rico'),(297,'PS','Asia/Gaza'),(298,'PS','Asia/Hebron'),(299,'PT','Europe/Lisbon'),(300,'PT','Atlantic/Madeira'),(301,'PT','Atlantic/Azores'),(302,'PW','Pacific/Palau'),(303,'PY','America/Asuncion'),(304,'QA','Asia/Qatar'),(305,'RE','Indian/Reunion'),(306,'RO','Europe/Bucharest'),(307,'RS','Europe/Belgrade'),(308,'RU','Europe/Kaliningrad'),(309,'RU','Europe/Moscow'),(310,'UA','Europe/Simferopol'),(311,'RU','Europe/Kirov'),(312,'RU','Europe/Volgograd'),(313,'RU','Europe/Astrakhan'),(314,'RU','Europe/Saratov'),(315,'RU','Europe/Ulyanovsk'),(316,'RU','Europe/Samara'),(317,'RU','Asia/Yekaterinburg'),(318,'RU','Asia/Omsk'),(319,'RU','Asia/Novosibirsk'),(320,'RU','Asia/Barnaul'),(321,'RU','Asia/Tomsk'),(322,'RU','Asia/Novokuznetsk'),(323,'RU','Asia/Krasnoyarsk'),(324,'RU','Asia/Irkutsk'),(325,'RU','Asia/Chita'),(326,'RU','Asia/Yakutsk'),(327,'RU','Asia/Khandyga'),(328,'RU','Asia/Vladivostok'),(329,'RU','Asia/Ust-Nera'),(330,'RU','Asia/Magadan'),(331,'RU','Asia/Sakhalin'),(332,'RU','Asia/Srednekolymsk'),(333,'RU','Asia/Kamchatka'),(334,'RU','Asia/Anadyr'),(335,'RW','Africa/Kigali'),(336,'SA','Asia/Riyadh'),(337,'SB','Pacific/Guadalcanal'),(338,'SC','Indian/Mahe'),(339,'SD','Africa/Khartoum'),(340,'SE','Europe/Stockholm'),(341,'SG','Asia/Singapore'),(342,'SH','Atlantic/St_Helena'),(343,'SI','Europe/Ljubljana'),(344,'SJ','Arctic/Longyearbyen'),(345,'SK','Europe/Bratislava'),(346,'SL','Africa/Freetown'),(347,'SM','Europe/San_Marino'),(348,'SN','Africa/Dakar'),(349,'SO','Africa/Mogadishu'),(350,'SR','America/Paramaribo'),(351,'SS','Africa/Juba'),(352,'ST','Africa/Sao_Tome'),(353,'SV','America/El_Salvador'),(354,'SX','America/Lower_Princes'),(355,'SY','Asia/Damascus'),(356,'SZ','Africa/Mbabane'),(357,'TC','America/Grand_Turk'),(358,'TD','Africa/Ndjamena'),(359,'TF','Indian/Kerguelen'),(360,'TG','Africa/Lome'),(361,'TH','Asia/Bangkok'),(362,'TJ','Asia/Dushanbe'),(363,'TK','Pacific/Fakaofo'),(364,'TL','Asia/Dili'),(365,'TM','Asia/Ashgabat'),(366,'TN','Africa/Tunis'),(367,'TO','Pacific/Tongatapu'),(368,'TR','Europe/Istanbul'),(369,'TT','America/Port_of_Spain'),(370,'TV','Pacific/Funafuti'),(371,'TW','Asia/Taipei'),(372,'TZ','Africa/Dar_es_Salaam'),(373,'UA','Europe/Kiev'),(374,'UA','Europe/Uzhgorod'),(375,'UA','Europe/Zaporozhye'),(376,'UG','Africa/Kampala'),(377,'UM','Pacific/Midway'),(378,'UM','Pacific/Wake'),(379,'US','America/New_York'),(380,'US','America/Detroit'),(381,'US','America/Kentucky/Louisville'),(382,'US','America/Kentucky/Monticello'),(383,'US','America/Indiana/Indianapolis'),(384,'US','America/Indiana/Vincennes'),(385,'US','America/Indiana/Winamac'),(386,'US','America/Indiana/Marengo'),(387,'US','America/Indiana/Petersburg'),(388,'US','America/Indiana/Vevay'),(389,'US','America/Chicago'),(390,'US','America/Indiana/Tell_City'),(391,'US','America/Indiana/Knox'),(392,'US','America/Menominee'),(393,'US','America/North_Dakota/Center'),(394,'US','America/North_Dakota/New_Salem'),(395,'US','America/North_Dakota/Beulah'),(396,'US','America/Denver'),(397,'US','America/Boise'),(398,'US','America/Phoenix'),(399,'US','America/Los_Angeles'),(400,'US','America/Anchorage'),(401,'US','America/Juneau'),(402,'US','America/Sitka'),(403,'US','America/Metlakatla'),(404,'US','America/Yakutat'),(405,'US','America/Nome'),(406,'US','America/Adak'),(407,'US','Pacific/Honolulu'),(408,'UY','America/Montevideo'),(409,'UZ','Asia/Samarkand'),(410,'UZ','Asia/Tashkent'),(411,'VA','Europe/Vatican'),(412,'VC','America/St_Vincent'),(413,'VE','America/Caracas'),(414,'VG','America/Tortola'),(415,'VI','America/St_Thomas'),(416,'VN','Asia/Ho_Chi_Minh'),(417,'VU','Pacific/Efate'),(418,'WF','Pacific/Wallis'),(419,'WS','Pacific/Apia'),(420,'YE','Asia/Aden'),(421,'YT','Indian/Mayotte'),(422,'ZA','Africa/Johannesburg'),(423,'ZM','Africa/Lusaka'),(424,'ZW','Africa/Harare');

--
-- Table structure for table `top_menu`
--

CREATE TABLE `top_menu` (
  `menuid` int NOT NULL AUTO_INCREMENT,
  `menu_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `menu_slug` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `parentid` int NOT NULL,
  `entrydate` date NOT NULL,
  `isactive` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`menuid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `top_menu`
--

INSERT INTO `top_menu` VALUES (1,'Home','hotel',0,'2021-09-13',1),(2,'Sobre nós','about',0,'2025-01-25',1),(3,'Contate-nos','contact',0,'2025-01-25',1),(4,'Galeria','gallery',0,'2025-01-25',1),(5,'Meu Perfil','my-profile',0,'2025-01-25',1);

--
-- Table structure for table `unit_of_measurement`
--

CREATE TABLE `unit_of_measurement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uom_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `uom_short_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `unit_of_measurement`
--

INSERT INTO `unit_of_measurement` VALUES (1,'Kilogram','kg.',1),(2,'Liter','ltr.',1),(3,'Gram','grm.',1),(4,'tonne','tn.',1),(5,'milligram','mg.',1),(6,'carat','carat',1),(7,'Per Pieces','pcs',1),(8,'Per Cup','cup',1),(9,'Pound','pnd.',1);

--
-- Table structure for table `variant`
--

CREATE TABLE `variant` (
  `variantid` int NOT NULL AUTO_INCREMENT,
  `menuid` int NOT NULL,
  `variantName` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`variantid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `variant`
--

INSERT INTO `variant` VALUES (10,1,'regular',50.00);

--
-- Table structure for table `weekly_holiday`
--

CREATE TABLE `weekly_holiday` (
  `wk_id` int NOT NULL AUTO_INCREMENT,
  `dayname` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`wk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `weekly_holiday`
--

INSERT INTO `weekly_holiday` VALUES (22,'Friday');

--
-- Table structure for table `whatsapp_settings`
--

CREATE TABLE `whatsapp_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `whatsapp_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `chatenable` int DEFAULT '0',
  `orderenable` int DEFAULT '0',
  `status` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `whatsapp_settings`
--



