CORE-POS/IS4C

use is4c_op;

INSERT INTO `subdepts` VALUES (101,'Baking Ingredients & mixes',1),(102,'bars-nutritional',1),(103,'bars-chocolate',1),(104,'candy & snacks',1),(105,'cereal',1),(106,'Chips',1),(107,'Condiments',1),(108,'Cookies',1),(109,'Crackers',1),(110,'Dried Fruit & vegetables',1),(111,'Ethnic Foods',1),(112,'Fruit Spreads',1),(116,'Herbs & Spices',1),(117,'Nut & Seed Butters',1),(118,'Oils',1),(119,'Vinegars',1),(120,'Packaged Grains, Beens, Seeds',1),(121,'Packaged Grocery',1),(122,'Pasta',1),(123,'Pasta & Tomato Sauce',1),(124,'Salad Dressing',1),(125,'Salsas & Dips',1),(126,'Seafood & Meat (non-frozen)',1),(128,'Soups/Ramens',1),(129,'Raw Foods (shelf-stable)',1),(130,'Juices (non-perishable)',1),(131,'Non-dairy Milks',1),(132,'Sodas',1),(133,'Waters',1),(134,'Teas',1),(135,'Coffee Drinks',1),(136,'Baby Food',1),(201,'Baking',2),(202,'Beans',2),(203,'Candy',2),(204,'Cereal',2),(205,'Coffee',2),(206,'Condiments',2),(207,'Dried fruit',2),(208,'Flour',2),(209,'Grains',2),(210,'Misc.',2),(211,'Nuts + seeds',2),(212,'Pasta',2),(213,'Rice',2),(214,'Seaweed',2),(215,'Snacks',2),(216,'Sweeteners',2),(218,'Non-food',2),(301,'Pkgd meat',3),(304,'Bread, bagels',3),(305,'Treats',3),(306,'Refridgerated grocery',3),(307,'Perishable - Misc.',3),(401,'Dairy Misc.',4),(402,'Egg - Chicken',4),(403,'Egg - Other',4),(404,'Butter',4),(405,'Milk - Cow',4),(406,'Milk - Other',4),(501,'Columbia',5),(502,'Mitchell',5),(503,'Henry',5),(504,'Mountain Peoples',5),(505,'Mount Hood',5),(506,'Klickitat Canyon',5),(507,'General',5),(508,'Gatti',5),(509,'Mountain Meadows',5),(510,'Gravel Road',5),(511,'Wine Seller',5),(512,'DVine',5),(612,'Frozen breads',6),(613,'Dessert items',6),(614,'Frozen grocery',6),(615,'Meats + alternatives',6),(701,'Cheese Misc.',7),(801,'Produce Misc.',8),(802,'Fruit – Apples',8),(803,'Fruit - Citrus',8),(804,'Vegetable – Root',8),(805,'Greens',8),(806,'Alliums',8),(807,'Fruit – Tropical',8),(808,'Fruit – Berries',8),(809,'Seeds',8),(810,'Herbs',8),(811,'Legumes',8),(812,'Fruit - Melon',8),(813,'Fruit - Misc.',8),(814,'Vegetable - Misc.',8),(815,'Fungi',8),(816,'Fruit - Stone',8),(817,'Vegetable - Peppers',8),(818,'Vegetable - Tomatoes',8),(901,'Herbs',9),(902,'Teas',9),(903,'Henna',9),(904,'Sprouting',9),(905,'Supplements',9),(1001,'Housewares',10),(1002,'Cleaning Supplies',10),(1003,'Paper Products',10),(1004,'Magazines',10),(1005,'Books',10),(1006,'Cards',10),(1101,'Hair Care',11),(1102,'Skin & Facial Care',11),(1103,'Oral Care',11),(1104,'Lip Balm',11),(1105,'Deodorant & Shaving Stuff',11),(1106,'Moon Time Supplies, Condoms, E',11),(1107,'Topicals: Salve, pain relief, ',11),(1108,'Soap, Bath, Essential Oils',11),(1109,'Local, handmade goodies',11),(1110,'Bulk: Soaps, Lotion, Oil, Bath',11),(1111,'Miscellaneous, Accessories',11),(1201,'Supps Misc.',12),(1208,'Packaged Teas',12),(1301,'Pet Misc.',13),(1302,'Dog Food',13),(1303,'Cat Food',13),(1401,'Columbia',14),(1402,'Mountain Peoples',14),(1403,'Mount Hood',14),(1404,'General',14),(1405,'Point Blank',14),(1501,'Deli Misc.',15),(1601,'Bread',16),(1602,'Juice',16),(4001,'Trimet Passes',40),(4002,'Trimet Tix',40),(1007,'NF - Misc.',10),(113,'Grocery - Misc.',1),(217,'Bulk - Misc.',2),(601,'Frozen - Misc.',6),(1701,'Floral - Misc.',17);
UNLOCK TABLES;