CORE-POS/IS4C

use is4c_op;

INSERT INTO `departments` VALUES (1,'GROCERY',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(2,'BULK',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(3,'PERISHABLE',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(4,'DAIRY',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(5,'WINE',0,0,100,0.01,1,'2007-01-27 22:42:01',0),(6,'FROZEN',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(7,'CHEESE',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(8,'PRODUCE',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(9,'BULK HERBS',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(10,'NONFOODS-GROCERY',0,0,100,0.01,1,'2007-01-27 22:42:01',0),(11,'PERSONAL CARE',0,0,100,0.01,1,'2007-01-27 22:42:01',0),(12,'SUPPLEMENTS',0,0,100,0.01,1,'2007-01-27 22:42:01',0),(13,'PET SUPPLY',0,0,100,0.01,1,'2007-01-27 22:42:01',0),(14,'BEER',0,0,100,0.01,1,'2007-01-27 22:42:01',0),(15,'DELI',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(16,'BREAD AND JUICE',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(17,'FLORAL',0,0,100,0.01,1,'2007-01-27 22:42:01',0),(18,'',0,0,100,0.01,1,'2007-01-27 22:42:01',0),(19,'',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(20,'',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(21,'',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(22,'',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(23,'',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(24,'',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(25,'',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(26,'',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(27,'',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(28,'',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(29,'',0,1,100,0.01,1,'2007-01-27 22:42:01',0),(30,'WHOLESALE GROCERY',0,1,100,0.01,0,'2007-01-27 22:42:01',0),(31,'WHOLESALE BULK',0,1,100,0.01,0,'2007-01-27 22:42:01',0),(32,'WHOLESALE DAIRY',0,1,100,0.01,0,'2007-01-27 22:42:01',0),(33,'WHOLESALE PRODUCE',0,1,100,0.01,0,'2007-01-27 22:42:01',0),(34,'WHOLESALE NONFOODS',0,0,100,0.01,0,'2007-01-27 22:42:01',0),(35,'WHOLESALE SUPPLEMENTS',0,0,100,0.01,0,'2007-01-27 22:42:01',0),(37,'WHOLESALE BEER/WINE',0,0,100,0.01,0,'2007-01-27 22:42:01',0),(36,'',0,0,100,0.01,0,'2007-01-27 22:42:01',0),(38,'',0,0,100,0.01,0,'2007-01-27 22:42:01',0),(39,'',0,0,100,0.01,0,'2007-01-27 22:42:01',0),(40,'TRI-MET',0,0,100,0.01,0,'2007-01-27 22:42:01',0),(41,'BOTTLE RETURN',0,0,-0.01,-100,0,'2007-01-27 22:42:01',0),(42,'BOTTLE DEPOSIT',0,0,100,0.01,0,'2007-01-27 22:42:01',0),(43,'FS BOTTLE DEPOSIT',0,1,100,0.01,0,'2007-01-27 22:42:01',0),(44,'GIFT CERTIFICATE',0,0,100,0.01,0,'2007-01-27 22:42:01',0),(45,'MEMBERSHIP EQUITY',0,0,180,0.01,0,'2007-01-27 22:42:01',0);
UNLOCK TABLES;