delete from category_group_table;
delete from category_table;
delete from menu_table;
delete from follow_table;
delete from spec_group_table;
delete from spec_op_table;
delete from spec_table;

INSERT INTO `category_group_table` (`CategoryGroupID`, `L1`, `L2`, `IsShow`, `Weight`, `Remark`, `CreateTime`, `Type`, `OnlineShowFlag`, `OnlineLang`) VALUES (1,'Menu','Menu',0,999999,NULL,'2018-11-08',0,0,'');

INSERT INTO `spec_group_table` (`SpecGroupID`, `L1`, `L2`, `Weight`, `Remark`, `CreateTime`) VALUES (8,'Taste','Taste',999999,NULL,'2018-11-08'),(9,'Vegetable','Vegetable',999999,NULL,'2018-11-08'),(10,'Meat','Meat',999999,NULL,'2018-11-08'),(11,'Other','Other',999999,NULL,'2018-11-08');

INSERT INTO `spec_op_table` (`ID`, `L1`, `L2`, `Weight`, `Remark`, `CreateTime`) VALUES (1,'No','No',9,NULL,'2018-11-08'),(2,'Less','Less',8,NULL,'2018-11-08'),(3,'With','With',7,NULL,'2018-11-08'),(4,'Only','Only',6,NULL,'2018-11-08'),(5,'Extra','Extra',5,NULL,'2018-11-08'),(6,'On the Side','On the Side',4,NULL,'2018-11-08'),(7,'Free','Free',3,NULL,'2018-11-08'),(12,'First Half','First Half',2,NULL,'2018-11-08'),(13,'Second Half','Second Half',1,NULL,'2018-11-08'),(14,' ',' ',10,NULL,'2019-04-24');

INSERT INTO `spec_table` (`FollowID`, `SpecGroupID`, `ItemNo`, `L1`, `L2`, `Price`, `isMain`, `PriceMode`, `Printer`, `IsNoTax`, `IsDiscount`, `Weight`, `Remark`, `CreateTime`) VALUES (1,'10','M4','Chicken','',0.00,0,0,'9',0,0,9,NULL,'2018-11-08'),(2,'10','M03','Ham','',0.00,0,0,'9',0,0,1,NULL,'2018-11-08'),(3,'10','M8','Shrimp','',0.00,0,0,'9',0,0,8,NULL,'2018-11-08'),(4,'10','M5','Steak','',0.00,0,0,'9',0,0,7,NULL,'2018-11-08'),(5,'10','M9','Bacon','',0.00,0,0,'9',0,0,6,NULL,'2018-11-08'),(6,'10','M6','Meatballs','',0.00,0,0,'9',0,0,5,NULL,'2018-11-08'),(7,'10','M10','Salami','',0.00,0,0,'9',0,0,10,NULL,'2018-11-08'),(8,'10','M11','Anchovies','',0.00,0,0,'9',0,0,4,NULL,'2018-11-08'),(9,'10','M3','Sausage','',0.00,0,0,'9',0,0,11,NULL,'2018-11-08'),(11,'8','T11','Parmesan Cheese','',0.00,0,0,'9',0,0,23,NULL,'2018-11-08'),(12,'8','T28','Red Sauce','',0.00,0,0,'9',0,0,14,NULL,'2018-11-08'),(13,'8','T15','Sauce','',0.00,0,0,'9',0,0,21,NULL,'2018-11-08'),(14,'8','T18','Garlic ','',0.00,0,0,'9',0,0,13,NULL,'2018-11-08'),(15,'8','T25','Hot Sauce','',0.00,0,0,'9',0,0,20,NULL,'2018-11-08'),(16,'8','T13','Mild','',0.00,0,0,'9',0,0,12,NULL,'2018-11-08'),(17,'8','T16','BBQ','',0.00,0,0,'9',0,0,11,NULL,'2018-11-08'),(18,'8','T20','Celery & Blue Cheese','',0.00,0,0,'9',0,0,10,NULL,'2018-11-08'),(19,'8','T17','Italian','',0.00,0,0,'9',0,0,9,NULL,'2018-11-08'),(20,'8','T7','Blue Cheese','',0.00,0,0,'9',0,0,8,NULL,'2018-11-08'),(21,'8','T21','Honey Mustard','',0.00,0,0,'9',0,0,7,NULL,'2018-11-08'),(22,'8','T23','Ranch','',0.00,0,0,'9',0,0,6,NULL,'2018-11-08'),(23,'8','T29','French','',0.00,0,0,'9',0,0,5,NULL,'2018-11-08'),(24,'8','T3','Thousand Island','',0.00,0,0,'9',0,0,4,NULL,'2018-11-08'),(25,'8','T19','Oil & Vinegar','',0.00,0,0,'9',0,0,3,NULL,'2018-11-08'),(26,'8','T4','Light Italian','',0.00,0,0,'9',0,0,2,NULL,'2018-11-08'),(27,'8','T04','Balsamic Vinaigrette','',0.00,0,0,'9',0,0,1,NULL,'2018-11-08'),(34,'9','V06','Broccoli','',0.00,0,0,'9',0,0,0,NULL,'2018-11-08'),(35,'9','V14','Tomato','',0.00,0,0,'9',0,0,11,NULL,'2018-11-08'),(36,'9','V20','Green Pepper','',0.00,0,0,'9',0,0,7,NULL,'2018-11-08'),(37,'9','V17','Mushroom','',0.00,0,0,'9',0,0,6,NULL,'2018-11-08'),(38,'9','V23','Spinach','',0.00,0,0,'9',0,0,5,NULL,'2018-11-08'),(39,'9','V191','Black Olives','',0.00,0,0,'9',0,0,4,NULL,'2018-11-08'),(40,'9','V08','Onion','',0.00,0,0,'9',0,0,10,NULL,'2018-11-08'),(41,'9','V09','Pepper','',0.00,0,0,'9',0,0,0,NULL,'2018-11-08'),(42,'9','V02','Pineapple','',0.00,0,0,'9',0,0,3,NULL,'2018-11-08'),(43,'9','V03','Garlic','',0.00,0,0,'9',0,0,1,NULL,'2018-11-08'),(44,'9','V24','Romano','',0.00,0,0,'9',0,0,0,NULL,'2018-11-08'),(45,'9','V10','Ricotta','',0.00,0,0,'9',0,0,0,NULL,'2018-11-08'),(46,'9','V04','Sweet Pepper','',0.00,0,0,'9',0,0,9,NULL,'2018-11-08'),(47,'9','V18','Lettuce','',0.00,0,0,'9',0,0,12,NULL,'2018-11-08'),(49,'9','V21','Eggplant','',0.00,0,0,'9',0,0,0,NULL,'2018-11-08'),(57,'11','O03','Fork','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(58,'11','O04','Spoon','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(60,'11','O01','Plate','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(61,'11','O05','Napkin','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(69,'10','M13','Ricotta','',0.00,0,0,'9',0,0,3,NULL,'2018-11-08'),(102,'8',NULL,'Mozzarella Cheese','',0.00,0,0,'9',0,0,22,NULL,'2021-02-22'),(103,'8',NULL,'Cheddar Cheese','',0.00,0,0,'9',0,0,24,NULL,'2021-02-22'),(104,'10',NULL,'Ground Beef','',0.00,0,0,'9',0,0,2,NULL,'2021-02-22'),(105,'9',NULL,'Hot Pepper','',0.00,0,0,'9',0,0,8,NULL,'2021-02-22'),(106,'8',NULL,'Ricotta Cheese','',0.00,0,0,'9',0,0,25,NULL,'2021-02-22'),(107,'8',NULL,'America Cheese','',0.00,0,0,'9',0,0,28,NULL,'2021-02-22'),(108,'8',NULL,'Mayo','',0.00,0,0,'9',0,0,19,NULL,'2021-02-22'),(112,'10',NULL,'Pepperoni','',0.00,0,0,'9',0,0,12,NULL,'2021-03-03'),(113,'',NULL,'Extra Cheese.0','',0.00,0,0,'9',0,0,0,NULL,'2021-03-04'),(114,'8',NULL,'Extra Cheese','',0.00,0,0,'9',0,0,27,NULL,'2021-03-04'),(115,'8',NULL,'Sauce','',0.00,0,0,'9',0,0,18,NULL,'2021-03-07'),(116,'10',NULL,'Turkey','',0.00,0,0,'9',0,0,0,NULL,'2021-03-12'),(117,'10',NULL,'Roast Beef','',0.00,0,0,'9',0,0,0,NULL,'2021-03-12'),(118,'9',NULL,'Fried Onions','',0.00,0,0,'9',0,0,0,NULL,'2021-03-13'),(119,'8',NULL,'Provolone Cheese','',0.00,0,0,'9',0,0,26,NULL,'2021-03-13'),(120,'8',NULL,'SWEET SAUCE.','',0.00,0,0,'9',0,0,17,NULL,'2021-03-19'),(121,'11',NULL,'Scoop Roll','',0.00,0,0,'9',0,0,0,NULL,'2021-03-20'),(122,'11',NULL,'Utensils','',0.00,0,0,'9',0,0,0,NULL,'2021-03-20'),(123,'8',NULL,'Ketchup','',0.00,0,0,'9',0,0,16,NULL,'2021-03-20'),(124,'11',NULL,'Crispy','',0.00,0,0,'9',0,0,0,NULL,'2021-03-20'),(125,'11',NULL,'Well Done','',0.00,0,0,'9',0,0,0,NULL,'2021-03-20'),(126,'11',NULL,'Lightly Toasted','',0.00,0,0,'9',0,0,0,NULL,'2021-03-20'),(127,'8',NULL,'OIL','',0.00,0,0,'9',0,0,15,NULL,'2021-03-20'),(128,'9',NULL,'Banana Peper','',0.00,0,0,'9',0,0,0,NULL,'2021-03-21'),(129,'11',NULL,' Black Pepper','',0.00,0,0,'9',0,0,0,NULL,'2021-03-28'),(130,'11',NULL,'Oregano','',0.00,0,0,'9',0,0,0,NULL,'2021-03-28'),(131,'11',NULL,'Salt','',0.00,0,0,'9',0,0,0,NULL,'2021-03-28'),(132,'9',NULL,'Pickles','',0.45,0,0,'9',0,0,0,NULL,'2021-04-03');