����
One Hat Cyber Team
One Hat Cyber Team
Your IP :
18.191.32.71
Server IP :
192.185.194.254
Server :
Linux raider.websitewelcome.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64
Server Software :
Apache
PHP Version :
7.4.33
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home2
/
glenar
/
ads.glenar.com
/
uploads
/
tmp
/
View File Name :
dump-dbordering-202205160548.sql
-- MySQL dump 10.13 Distrib 5.5.62, for Win64 (AMD64) -- -- Host: localhost Database: dbordering -- ------------------------------------------------------ -- Server version 5.5.5-10.4.22-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `_tblpos_detail` -- DROP TABLE IF EXISTS `_tblpos_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `_tblpos_detail` ( `posDetailID` int(11) NOT NULL AUTO_INCREMENT, `ORNumber` varchar(30) DEFAULT NULL, `MenuMainID` int(11) DEFAULT NULL, `Price` double(15,4) DEFAULT 0.0000, `Quantity` double(15,4) DEFAULT 0.0000, `FinalAmount` double(15,4) DEFAULT 0.0000, PRIMARY KEY (`posDetailID`), KEY `_tblpos_detail_FK` (`MenuMainID`), CONSTRAINT `_tblpos_detail_FK` FOREIGN KEY (`MenuMainID`) REFERENCES `tblmenu_summary` (`MenuMainID`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `_tblpos_detail` -- LOCK TABLES `_tblpos_detail` WRITE; /*!40000 ALTER TABLE `_tblpos_detail` DISABLE KEYS */; INSERT INTO `_tblpos_detail` VALUES (43,'OR20220411065815',20,150.0000,1.0000,150.0000); /*!40000 ALTER TABLE `_tblpos_detail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `_tblpos_summary` -- DROP TABLE IF EXISTS `_tblpos_summary`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `_tblpos_summary` ( `posID` int(11) NOT NULL AUTO_INCREMENT, `ORNumber` varchar(30) DEFAULT NULL, `xTimeStamp` timestamp NULL DEFAULT current_timestamp(), `EmployeeID` int(11) DEFAULT NULL, `InvoiceNumber` varchar(30) DEFAULT NULL, `AmountPaid` double(15,4) DEFAULT 0.0000, `AmountChange` double(15,4) DEFAULT 0.0000, `Remarks` varchar(200) DEFAULT NULL, PRIMARY KEY (`posID`), UNIQUE KEY `_tblpos_summary_un` (`ORNumber`), KEY `_tblpos_summary_FK` (`EmployeeID`) USING BTREE, CONSTRAINT `_tblpos_summary_FK` FOREIGN KEY (`EmployeeID`) REFERENCES `tblemployee` (`EmployeeID`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `_tblpos_summary` -- LOCK TABLES `_tblpos_summary` WRITE; /*!40000 ALTER TABLE `_tblpos_summary` DISABLE KEYS */; INSERT INTO `_tblpos_summary` VALUES (25,'OR20220411065815','2022-04-11 04:58:15',1,'INV2022041106585',150.0000,0.0000,'0'); /*!40000 ALTER TABLE `_tblpos_summary` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fs_inv` -- DROP TABLE IF EXISTS `fs_inv`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fs_inv` ( `EntryID` int(11) NOT NULL AUTO_INCREMENT, `Quantity` double(15,4) DEFAULT 0.0000, `Cost` double(15,4) DEFAULT 0.0000, `FinalAmount` double(15,4) DEFAULT 0.0000, `AccountingType` varchar(30) DEFAULT '-' COMMENT 'GR = Goods Receive; INV = Invoicing;', `EmployeeID` int(11) DEFAULT NULL, `xTimestamp` timestamp NULL DEFAULT current_timestamp(), `MaterialID` int(11) DEFAULT NULL, `ControlNumber` varchar(30) DEFAULT NULL, PRIMARY KEY (`EntryID`), KEY `fs_inv_FK` (`MaterialID`), CONSTRAINT `fs_inv_FK` FOREIGN KEY (`MaterialID`) REFERENCES `tblmaterials` (`MaterialID`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fs_inv` -- LOCK TABLES `fs_inv` WRITE; /*!40000 ALTER TABLE `fs_inv` DISABLE KEYS */; INSERT INTO `fs_inv` VALUES (105,20.0000,25.0000,500.0000,'GR',1,'2022-04-11 04:30:46',18,'GR2022041106301'),(106,50.0000,25.0000,1250.0000,'GR',1,'2022-04-11 04:30:52',20,'GR2022041106302'),(107,3.0000,0.0000,0.0000,'ORD',1,'2022-04-11 04:43:57',20,'ORD20220411064357'),(108,3.0000,0.0000,0.0000,'ORD',1,'2022-04-11 04:43:57',18,'ORD20220411064357'),(109,1.0000,0.0000,0.0000,'INV',1,'2022-04-11 04:58:15',20,'INV2022041106585'),(110,1.0000,0.0000,0.0000,'INV',1,'2022-04-11 04:58:15',18,'INV2022041106585'),(111,2.0000,0.0000,0.0000,'ORD',1,'2022-04-11 05:33:23',20,'ORD20220411073323'),(112,2.0000,0.0000,0.0000,'ORD',1,'2022-04-11 05:33:23',18,'ORD20220411073323'),(113,2.0000,0.0000,0.0000,'ORD',1,'2022-04-11 05:50:34',20,'ORD20220411075034'),(114,2.0000,0.0000,0.0000,'ORD',1,'2022-04-11 05:50:34',18,'ORD20220411075034'),(115,1.0000,0.0000,0.0000,'ORD',1,'2022-04-11 05:54:59',20,'ORD20220411075459'),(116,1.0000,0.0000,0.0000,'ORD',1,'2022-04-11 05:54:59',18,'ORD20220411075459'),(117,1.0000,0.0000,0.0000,'ORD',1,'2022-04-11 05:55:51',20,'ORD20220411075551'),(118,1.0000,0.0000,0.0000,'ORD',1,'2022-04-11 05:55:51',18,'ORD20220411075551'),(119,1.0000,0.0000,0.0000,'ORD',1,'2022-04-11 06:03:10',20,'ORD20220411080310'),(120,1.0000,0.0000,0.0000,'ORD',1,'2022-04-11 06:03:10',18,'ORD20220411080310'),(121,2.0000,0.0000,0.0000,'ORD',1,'2022-05-15 21:03:48',20,'ORD20220515230348'),(122,2.0000,0.0000,0.0000,'ORD',1,'2022-05-15 21:03:49',18,'ORD20220515230348'),(123,2.0000,0.0000,0.0000,'ORD',1,'2022-05-15 21:08:38',20,'ORD20220515230838'),(124,2.0000,0.0000,0.0000,'ORD',1,'2022-05-15 21:08:38',18,'ORD20220515230838'); /*!40000 ALTER TABLE `fs_inv` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_cuopons` -- DROP TABLE IF EXISTS `tbl_cuopons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbl_cuopons` ( `CuoponID` int(11) NOT NULL AUTO_INCREMENT, `CuoponCode` varchar(30) DEFAULT NULL, `Discount` double(15,4) DEFAULT 0.0000, `isActive` tinyint(4) DEFAULT 1, PRIMARY KEY (`CuoponID`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_cuopons` -- LOCK TABLES `tbl_cuopons` WRITE; /*!40000 ALTER TABLE `tbl_cuopons` DISABLE KEYS */; INSERT INTO `tbl_cuopons` VALUES (1,'GO2018',0.1000,1); /*!40000 ALTER TABLE `tbl_cuopons` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblcart` -- DROP TABLE IF EXISTS `tblcart`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblcart` ( `TempCartID` int(11) NOT NULL AUTO_INCREMENT, `InvoiceNumber` varchar(30) DEFAULT NULL, `MenuMainID` int(11) DEFAULT NULL, `Quantity` double(15,4) DEFAULT 0.0000, `Price` double(15,4) DEFAULT 0.0000, `FinalAmount` double(15,4) DEFAULT 0.0000, PRIMARY KEY (`TempCartID`), KEY `tblcart_FK` (`MenuMainID`) USING BTREE, CONSTRAINT `tblcart_FK_1` FOREIGN KEY (`MenuMainID`) REFERENCES `tblmenu_summary` (`MenuMainID`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblcart` -- LOCK TABLES `tblcart` WRITE; /*!40000 ALTER TABLE `tblcart` DISABLE KEYS */; /*!40000 ALTER TABLE `tblcart` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblemployee` -- DROP TABLE IF EXISTS `tblemployee`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblemployee` ( `EmployeeID` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(30) DEFAULT NULL, `Middlename` varchar(30) DEFAULT NULL, `Lastname` varchar(30) DEFAULT NULL, `EmployeeType` varchar(30) DEFAULT NULL, `BasePay` double(15,4) DEFAULT 0.0000, `Birthdate` date DEFAULT NULL, `Address` varchar(100) DEFAULT NULL, PRIMARY KEY (`EmployeeID`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblemployee` -- LOCK TABLES `tblemployee` WRITE; /*!40000 ALTER TABLE `tblemployee` DISABLE KEYS */; INSERT INTO `tblemployee` VALUES (1,'Administrator','Administrator','Administrator','Administrator',500.0000,'1999-04-12','Blk 11-Lot 8, PNR Subdivision, Barra, Opol, Mis Or, Blk 11-Lot 8, PNR Subdivision, Barra, Opol, Mis '),(2,'Waiter','Waiter','Waiter','Helper',40.0000,'1999-04-12','Blk 29 - Lot 12, NHA, Phase 2, Kauswagan, Cagayan de Oro City, Mis Or'),(3,'kitchen','kitchen','kitchen','Helper',60.0000,'1998-04-12','Blk 29 - Lot 12, NHA, Phase 2, Kauswagan, Cagayan de Oro City, Mis Or'),(4,'Cashier','Cashier','Cashier','Cashier',23.0000,'1999-04-12','Blk 29 - Lot 12, NHA, Phase 2, Kauswagan, Cagayan de Oro City, Mis Or'); /*!40000 ALTER TABLE `tblemployee` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblmaterials` -- DROP TABLE IF EXISTS `tblmaterials`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblmaterials` ( `MaterialID` int(11) NOT NULL AUTO_INCREMENT, `MaterialCode` varchar(30) DEFAULT NULL, `MaterialDescription` varchar(100) DEFAULT NULL, `soh` double(15,4) DEFAULT 0.0000, `maxstock` double(15,4) DEFAULT 0.0000, `isActive` tinyint(4) DEFAULT 1, PRIMARY KEY (`MaterialID`) ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblmaterials` -- LOCK TABLES `tblmaterials` WRITE; /*!40000 ALTER TABLE `tblmaterials` DISABLE KEYS */; INSERT INTO `tblmaterials` VALUES (18,'Lettuce','Lettuce',5.0000,200.0000,1),(20,'Beef-Patty','Beef Patty',35.0000,100.0000,1),(21,'Spag-Pasta','Spaghetti Pasta',0.0000,10.0000,1),(22,'Meatballs','Meatballs',0.0000,100.0000,1),(23,'Spag-Sauce','Spaghetti Sauce ',0.0000,10.0000,1); /*!40000 ALTER TABLE `tblmaterials` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblmenu` -- DROP TABLE IF EXISTS `tblmenu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblmenu` ( `MenuID` int(11) NOT NULL AUTO_INCREMENT, `Description` varchar(30) DEFAULT NULL, `action` varchar(30) DEFAULT NULL, `isActive` tinyint(4) DEFAULT 1, `icon` varchar(30) DEFAULT NULL, `sortingValues` int(11) DEFAULT NULL, PRIMARY KEY (`MenuID`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblmenu` -- LOCK TABLES `tblmenu` WRITE; /*!40000 ALTER TABLE `tblmenu` DISABLE KEYS */; INSERT INTO `tblmenu` VALUES (1,'Inventory','load_inventory()',1,'inventory_2',5),(2,'Point of Sales','load_pos()',1,'point_of_sale',4),(3,'Menu','load_menu_registry()',1,'inventory',6),(4,'Ordering','load_ordering()',1,'article',2),(5,'Kitchen','load_kitchen()',1,'soup_kitchen',7),(6,'Admin Settings','load_admin()',1,'admin_panel_settings',8),(8,'Dashboard','load_maindashboard()',1,'dashboard',1),(9,'Dine-In Payment','load_dinein()',1,'request_quote',3),(10,'Reports','load_reports()',1,'table_chart',4); /*!40000 ALTER TABLE `tblmenu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblmenu_category` -- DROP TABLE IF EXISTS `tblmenu_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblmenu_category` ( `MenuCategoryID` int(11) NOT NULL AUTO_INCREMENT, `Description` varchar(30) DEFAULT NULL, `isActive` tinyint(11) DEFAULT 1, PRIMARY KEY (`MenuCategoryID`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblmenu_category` -- LOCK TABLES `tblmenu_category` WRITE; /*!40000 ALTER TABLE `tblmenu_category` DISABLE KEYS */; INSERT INTO `tblmenu_category` VALUES (1,'Burgers',1),(2,'Beverages',1),(4,'Pasta',1),(5,'Combo Meal',1); /*!40000 ALTER TABLE `tblmenu_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblmenu_detail` -- DROP TABLE IF EXISTS `tblmenu_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblmenu_detail` ( `MenuDetailID` int(11) NOT NULL AUTO_INCREMENT, `MenuMainID` int(11) DEFAULT NULL, `MaterialID` int(11) DEFAULT NULL, `Quantity` double(15,4) DEFAULT 0.0000, `xTimestamp` timestamp NULL DEFAULT current_timestamp(), PRIMARY KEY (`MenuDetailID`), KEY `tblmenu_detail_FK` (`MenuMainID`), KEY `tblmenu_detail_FK_1` (`MaterialID`), CONSTRAINT `tblmenu_detail_FK` FOREIGN KEY (`MenuMainID`) REFERENCES `tblmenu_summary` (`MenuMainID`) ON UPDATE CASCADE, CONSTRAINT `tblmenu_detail_FK_1` FOREIGN KEY (`MaterialID`) REFERENCES `tblmaterials` (`MaterialID`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblmenu_detail` -- LOCK TABLES `tblmenu_detail` WRITE; /*!40000 ALTER TABLE `tblmenu_detail` DISABLE KEYS */; INSERT INTO `tblmenu_detail` VALUES (16,20,20,1.0000,'2022-04-11 03:55:41'),(17,20,18,1.0000,'2022-04-11 03:55:46'); /*!40000 ALTER TABLE `tblmenu_detail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblmenu_summary` -- DROP TABLE IF EXISTS `tblmenu_summary`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblmenu_summary` ( `MenuMainID` int(11) NOT NULL AUTO_INCREMENT, `MenuDescription` varchar(50) DEFAULT NULL, `xTimestamp` timestamp NULL DEFAULT current_timestamp(), `Price` double(15,4) DEFAULT NULL, `Tax` double(15,4) DEFAULT NULL, `MenuCategoryID` int(11) DEFAULT NULL, `withIngredient` tinyint(4) DEFAULT NULL, `asset` varchar(100) DEFAULT NULL, PRIMARY KEY (`MenuMainID`), KEY `tblmenu_summary_FK` (`MenuCategoryID`), CONSTRAINT `tblmenu_summary_FK` FOREIGN KEY (`MenuCategoryID`) REFERENCES `tblmenu_category` (`MenuCategoryID`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblmenu_summary` -- LOCK TABLES `tblmenu_summary` WRITE; /*!40000 ALTER TABLE `tblmenu_summary` DISABLE KEYS */; INSERT INTO `tblmenu_summary` VALUES (20,'Burger 1','2022-04-11 03:55:07',150.0000,0.0000,1,1,'imagesrc20220411055507.png'); /*!40000 ALTER TABLE `tblmenu_summary` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblorder_detail` -- DROP TABLE IF EXISTS `tblorder_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblorder_detail` ( `OrderDetailID` int(11) NOT NULL AUTO_INCREMENT, `OrderSummaryID` int(11) DEFAULT NULL, `MenuMainID` int(11) DEFAULT NULL, `Price` double(15,4) DEFAULT 0.0000, `Quantity` double(15,4) DEFAULT 0.0000, `FinalAmount` double(15,4) DEFAULT 0.0000, `Status` varchar(30) DEFAULT 'Submitted to Kitchen', PRIMARY KEY (`OrderDetailID`), KEY `tblorder_detail_FK_1` (`OrderSummaryID`), CONSTRAINT `tblorder_detail_FK` FOREIGN KEY (`OrderSummaryID`) REFERENCES `tblorder_summary` (`OrderSummaryID`) ON UPDATE CASCADE, CONSTRAINT `tblorder_detail_FK_1` FOREIGN KEY (`OrderSummaryID`) REFERENCES `tblorder_summary` (`OrderSummaryID`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblorder_detail` -- LOCK TABLES `tblorder_detail` WRITE; /*!40000 ALTER TABLE `tblorder_detail` DISABLE KEYS */; INSERT INTO `tblorder_detail` VALUES (113,41,20,150.0000,3.0000,450.0000,'Served'),(114,42,20,150.0000,2.0000,300.0000,'Served'),(115,43,20,150.0000,2.0000,300.0000,'Served'),(116,44,20,150.0000,1.0000,150.0000,'Served'),(117,45,20,150.0000,1.0000,150.0000,'Served'),(118,46,20,150.0000,1.0000,150.0000,'Served'),(119,47,20,150.0000,2.0000,300.0000,'Served'),(120,48,20,150.0000,2.0000,300.0000,'Served'); /*!40000 ALTER TABLE `tblorder_detail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tblorder_summary` -- DROP TABLE IF EXISTS `tblorder_summary`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblorder_summary` ( `OrderSummaryID` int(11) NOT NULL AUTO_INCREMENT, `TableNumber` int(11) DEFAULT NULL, `xTimestamp` timestamp NULL DEFAULT current_timestamp(), `Posted` tinyint(4) DEFAULT 0, `EmployeeID` int(11) DEFAULT NULL, `OrderControlNumber` varchar(30) DEFAULT NULL, `isComplete` tinyint(4) DEFAULT 0, `Amount` double(15,4) DEFAULT 0.0000, `Discount` double(15,4) DEFAULT 0.0000, `PaymentType` varchar(30) DEFAULT NULL, `CardHolderName` varchar(100) DEFAULT NULL, PRIMARY KEY (`OrderSummaryID`), KEY `tblorder_summary_FK` (`TableNumber`), KEY `tblorder_summary_FK_1` (`EmployeeID`), CONSTRAINT `tblorder_summary_FK` FOREIGN KEY (`TableNumber`) REFERENCES `tbltable_list` (`TableNumber`) ON UPDATE CASCADE, CONSTRAINT `tblorder_summary_FK_1` FOREIGN KEY (`EmployeeID`) REFERENCES `tblemployee` (`EmployeeID`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tblorder_summary` -- LOCK TABLES `tblorder_summary` WRITE; /*!40000 ALTER TABLE `tblorder_summary` DISABLE KEYS */; INSERT INTO `tblorder_summary` VALUES (41,1,'2022-04-11 04:30:58',1,1,'ORD20220411064357',1,450.0000,123.0000,NULL,NULL),(42,1,'2022-04-11 05:31:01',1,1,'ORD20220411073323',1,250.0000,50.0000,NULL,NULL),(43,1,'2022-04-11 05:35:35',1,1,'ORD20220411075034',1,300.0000,0.0000,NULL,NULL),(44,1,'2022-04-11 05:54:35',1,1,'ORD20220411075459',1,150.0000,0.0000,'Cash',NULL),(45,1,'2022-04-11 05:55:12',1,1,'ORD20220411075551',1,150.0000,0.0000,'Credit Card',NULL),(46,1,'2022-04-11 05:58:12',1,1,'ORD20220411080310',1,150.0000,30.0000,'Cash',NULL),(47,1,'2022-05-12 17:29:03',1,1,'ORD20220515230348',1,240.0000,60.0000,'Credit Card','Jian Jaico Cajita'),(48,1,'2022-05-15 21:04:01',1,1,'ORD20220515230838',1,240.0000,60.0000,'Credit Card','Jian Jaico'); /*!40000 ALTER TABLE `tblorder_summary` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbltable_list` -- DROP TABLE IF EXISTS `tbltable_list`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbltable_list` ( `TableID` int(11) NOT NULL AUTO_INCREMENT, `TableNumber` int(11) DEFAULT NULL, `isActive` tinyint(4) DEFAULT 1, PRIMARY KEY (`TableID`), UNIQUE KEY `tbltable_list_un` (`TableNumber`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbltable_list` -- LOCK TABLES `tbltable_list` WRITE; /*!40000 ALTER TABLE `tbltable_list` DISABLE KEYS */; INSERT INTO `tbltable_list` VALUES (1,1,1),(2,2,1),(7,3,1); /*!40000 ALTER TABLE `tbltable_list` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbluseraccess` -- DROP TABLE IF EXISTS `tbluseraccess`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbluseraccess` ( `UserAccessID` int(11) NOT NULL AUTO_INCREMENT, `EmployeeID` int(11) DEFAULT NULL, `MenuID` int(11) DEFAULT NULL, `xTimestamp` timestamp NULL DEFAULT current_timestamp(), PRIMARY KEY (`UserAccessID`), KEY `tbluseraccess_FK` (`MenuID`) USING BTREE, KEY `tbluseraccess_FK_1` (`EmployeeID`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbluseraccess` -- LOCK TABLES `tbluseraccess` WRITE; /*!40000 ALTER TABLE `tbluseraccess` DISABLE KEYS */; INSERT INTO `tbluseraccess` VALUES (6,1,6,'2022-01-24 00:33:52'),(7,2,4,'2022-01-24 00:35:48'),(8,3,5,'2022-01-24 00:36:37'),(14,1,7,'2022-01-24 07:22:15'),(22,1,1,'2022-01-28 12:26:04'),(23,1,3,'2022-01-28 12:26:05'),(24,1,4,'2022-01-28 12:26:05'),(27,1,9,'2022-03-28 20:55:43'),(28,4,2,'2022-03-28 23:49:52'),(29,4,9,'2022-03-28 23:49:53'),(30,1,2,'2022-03-28 23:50:11'),(31,1,8,'2022-04-01 09:51:40'),(32,1,5,'2022-04-11 04:47:31'),(33,1,10,'2022-04-11 04:52:16'); /*!40000 ALTER TABLE `tbluseraccess` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbluseraccount` -- DROP TABLE IF EXISTS `tbluseraccount`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tbluseraccount` ( `UserID` int(11) NOT NULL AUTO_INCREMENT, `EmployeeID` int(11) DEFAULT NULL, `UserName` varchar(30) DEFAULT NULL, `Password` varchar(30) DEFAULT NULL, `UserType` varchar(30) DEFAULT 'Regular', PRIMARY KEY (`UserID`), UNIQUE KEY `tbluseraccount_un` (`EmployeeID`), CONSTRAINT `tbluseraccount_FK` FOREIGN KEY (`EmployeeID`) REFERENCES `tblemployee` (`EmployeeID`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbluseraccount` -- LOCK TABLES `tbluseraccount` WRITE; /*!40000 ALTER TABLE `tbluseraccount` DISABLE KEYS */; INSERT INTO `tbluseraccount` VALUES (1,1,'jianjaico','jianjaico','Regular'),(2,2,'waiter','waiter','Regular'),(3,3,'chef','chef','Regular'),(4,4,'cashier','cashier','Regular'); /*!40000 ALTER TABLE `tbluseraccount` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'dbordering' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2022-05-16 5:48:32