--
-- Table structure for table `product`
--

DROP TABLE IF EXISTS `product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `tc_prod_name` varchar(15) DEFAULT NULL,
  `prod_num` varchar(6) DEFAULT NULL,
  `description` varchar(200) NOT NULL,
  `saleflag` varchar(10) DEFAULT NULL,
  `price` int(11) NOT NULL,
  `add_on` text DEFAULT NULL,
  `category_id` int(11) NOT NULL,
  `sort_field` int(11) DEFAULT NULL,
  `prod_name` varchar(20) NOT NULL,
  `sc_prod_name` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`product_id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `product_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product`
--

LOCK TABLES `product` WRITE;
/*!40000 ALTER TABLE `product` DISABLE KEYS */;
INSERT INTO `product` (`product_id`, `tc_prod_name`, `prod_num`, `description`, `saleflag`, `price`, `add_on`, `category_id`, `sort_field`, `prod_name`, `sc_prod_name`) VALUES (1,'熱飲','001','','SALLABLE',0,'',5,1,NULL,NULL),(3,'揚州炒飯','101','','SALLABLE',58,'',1,101,NULL,NULL),(4,'西炒飯','103','','SALLABLE',48,'',1,111,NULL,NULL),(5,'雲吞麵','201','','SALLABLE',41,'',2,201,NULL,NULL),(6,'牛腩麵','202','','SALLABLE',42,'',2,206,NULL,NULL),(7,'及第粥','301','','SALLABLE',22,'',4,301,NULL,NULL),(8,'魚片粥','302','','SALLABLE',23,'',4,306,NULL,NULL),(9,'可口可樂','401','','SALLABLE',11,'',3,401,NULL,NULL),(10,'百事可樂','403','','SALLABLE',10,'',3,411,NULL,NULL),(11,'少甜','003','','SALLABLE',0,'',5,11,NULL,NULL),(12,'凍飲','002','','SALLABLE',2,'',5,6,NULL,NULL),(13,'加飯','004','','SALLABLE',3,'',5,16,NULL,NULL),(14,'HK RICE222','10999','','SOLD',509,'',8,141,NULL,NULL),(15,'福建炒飯','102','','SALLABLE',48,'',1,106,NULL,NULL),(16,'鴛鴦炒飯','104','','SALLABLE',49,'',1,116,NULL,NULL),(17,'日式炒飯','105','','SALLABLE',50,'',1,121,NULL,NULL),(18,'荷葉飯','106','','SALLABLE',51,'',1,126,NULL,NULL),(19,'芙蓉蛋飯','107','','SALLABLE',52,'',1,131,NULL,NULL),(20,'菜遠牛腩飯','108','','SALLABLE',58,'',1,137,NULL,NULL),(21,'水餃麵','203','','SALLABLE',32,'',2,211,NULL,NULL),(22,'牛肉湯麵','204','','SALLABLE',32,'',2,216,NULL,NULL),(23,'牛腩撈麵','205','','SALLABLE',33,'',2,222,NULL,NULL),(24,'魚蛋河粉','206','','SALLABLE',34,'',2,226,NULL,NULL),(25,'玉泉忌廉','402','','SALLABLE',11,'',3,406,NULL,NULL),(26,'芬達橙汁','404','','SALLABLE',9,'',3,416,NULL,NULL),(27,'玉泉羌啤','405','','SALLABLE',12,'',3,421,NULL,NULL),(28,'加紫菜','005','','SALLABLE',5,'',5,21,NULL,NULL),(40,'DUMMY801 RICE','801','','SALLABLE',108,'',1,841,NULL,NULL),(43,'FLOAT','006','','SALLABLE',5,'',5,26,NULL,NULL);
/*!40000 ALTER TABLE `product` ENABLE KEYS */;
UNLOCK TABLES;

