order

CREATE TABLE `orders` (
  `orders_id` int NOT NULL AUTO_INCREMENT,
  `centre_id` int DEFAULT NULL,
  `order_code` int DEFAULT '0',
  `table_id` int DEFAULT NULL,
  `active` tinyint(1) DEFAULT '1',
  `date_order` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `total_cost` int DEFAULT '0',
  `status` varchar(45) DEFAULT 'PENDING',
  PRIMARY KEY (`orders_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders`
--

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` VALUES (1,1,0,15,1,'2024-07-18 03:00:00',160000,'PAID'),(2,2,0,13,1,'2024-07-18 04:00:00',100000,'PAID'),(3,2,0,14,1,'2024-07-18 05:00:00',300000,'PAID'),(4,3,0,6,1,'2024-07-18 06:00:00',60000,'PAID'),(5,4,0,2,1,'2024-07-18 07:00:00',210000,'PAID'),(6,5,0,3,1,'2024-07-18 07:00:00',490000,'PAID'),(7,1,868076,1,1,'2024-09-24 16:21:11',105000,'PAID'),(8,1,16461,1,1,'2024-09-24 16:23:39',105000,'PAID'),(9,1,232378,1,1,'2024-09-24 16:27:13',105000,'PENDING'),(10,1,565998,1,1,'2024-09-24 16:32:46',105000,'PAID');
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;