search

CORE-POS / IS4C

Cooperative Operational Retail Environment
http://www.core-pos.com
GNU General Public License v2.0
63 stars 44 forks source link

Attempted correction to departments.sql #289

Closed scannerdarkly closed 10 years ago

scannerdarkly commented 10 years ago

I don’t know if the added column values are correct (I mostly added the value '1' to the dept_see_id column which appears to be the new column), but here’s a version of departments.sql that imports successfully.

('92','HBHBA','1','0',50.00,0.01,'0','1','2005-13-12','1')

('104','HHOMEOPATHIC','1','0',50.00,0.01,'0','1','2005-13-12','1')

('14','BWATER','0','1',50.00,0.01,'0','1','2005-13-12','1')

('191','GSOBEVNOTAX','0','1',50.00,0.01,'0','1','2005-13-12','1')

('246','GMSOGENMERCH','1','0',50.00,0.01,'0','1','2005-13-12','1')

('249','GMSEEDSFLWR','1','0',50.00,0.01,'0','1','2005-13-12','1')

('247','PTRANSFLWR','1','0',50.00,0.01,'0','1','2005-13-12','1')

('248','PTRANSEDIBLE','0','1',50.00,0.01,'0','1','2005-13-12','1')

('250','GMSEEDSEDIBLE','0','1',50.00,0.01,'0','1','2005-13-12','1')

('1','BBAKING','0','1',50.00,0.01,'0','1','1900-01-01','1')

('2','BBEAN','0','1',50.00,0.01,'0','1','1900-01-01','1')

('3','BCEREAL','0','1',50.00,0.01,'0','1','1900-01-01','1')

('4','BDRIEDFRU','0','1',50.00,0.01,'0','1','1900-01-01','1')

('5','BFLOUR','0','1',50.00,0.01,'0','1','1900-01-01','1')

('6','BGRAIN','0','1',50.00,0.01,'0','1','1900-01-01','1')

('7','BMIXES','0','1',50.00,0.01,'0','1','1900-01-01','1')

('8','BNUTS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('10','BPASTA','0','1',50.00,0.01,'0','1','1900-01-01','1')

('11','BRICE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('12','BSNACK','0','1',50.00,0.01,'0','1','1900-01-01','1')

('13','BOTHER','0','1',50.00,0.01,'0','1','1900-01-01','1')

('15','BOIL','0','1',50.00,0.01,'0','1','1900-01-01','1')

('16','BCANDY','1','1',50.00,0.01,'0','1','1900-01-01','1')

('17','BCHOC','1','1',50.00,0.01,'0','1','1900-01-01','1')

('18','BNONFOOD','1','0',50.00,0.01,'0','1','1900-01-01','1')

('19','BTAXFOOD','1','1',50.00,0.01,'0','1','1900-01-01','1')

('21','BAGREFUN','0','1',50.00,0.01,'0','1','1900-01-01','1')

('22','BSOBULK B','0','1',50.00,0.01,'0','1','1900-01-01','1')

('23','PREPACK','0','1',50.00,0.01,'0','1','1900-01-01','1')

('24','BSOBULK A','0','1',50.00,0.01,'0','1','1900-01-01','1')

('25','BSO NONFOOD','1','0',50.00,0.01,'0','1','1900-01-01','1')

('26','CBUTTER','0','1',50.00,0.01,'0','1','1900-01-01','1')

('27','CDAIRY','0','1',50.00,0.01,'0','1','1900-01-01','1')

('28','CEGGS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('29','CJUICE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('30','CMILK','0','1',50.00,0.01,'0','1','1900-01-01','1')

('31','CSOY','0','1',50.00,0.01,'0','1','1900-01-01','1')

('32','CSOYMILK','0','1',50.00,0.01,'0','1','1900-01-01','1')

('188','GBEVNOTAX','0','1',50.00,0.01,'0','1','1900-01-01','1')

('34','COTHER','0','1',50.00,0.01,'0','1','1900-01-01','1')

('38','FZBAK','0','1',50.00,0.01,'0','1','1900-01-01','1')

('39','FZDEZ','0','1',50.00,0.01,'0','1','1900-01-01','1')

('40','FZENTREE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('41','FZFRUITVE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('42','FZJUICE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('261','MEAT FZ','0','1',50.00,0.01,'0','1','1900-01-01','1')

('44','FZPIZZA','0','1',50.00,0.01,'0','1','1900-01-01','1')

('45','FZSOY','0','1',50.00,0.01,'0','1','1900-01-01','1')

('46','FZOTHER','0','1',50.00,0.01,'0','1','1900-01-01','1')

('189','GBEVTAX','1','1',50.00,0.01,'0','1','1900-01-01','1')

('54','CJUGRETUR','0','1',50.00,0.01,'0','1','1900-01-01','1')

('55','CSO','0','1',50.00,0.01,'0','1','1900-01-01','1')

('56','CSOMILK','0','1',50.00,0.01,'0','1','1900-01-01','1')

('57','FZSO','0','1',50.00,0.01,'0','1','1900-01-01','1')

('190','GSOBEVTAX','1','1',50.00,0.01,'0','1','1900-01-01','1')

('59','CCOUPON','0','1',50.00,0.01,'0','1','1900-01-01','1')

('60','DBAKED','2','0',50.00,0.01,'0','1','1900-01-01','1')

('63','DCASE','2','0',50.00,0.01,'0','1','1900-01-01','1')

('64','DPREPACK','2','0',50.00,0.01,'0','1','1900-01-01','1')

('65','DSANDWICH','2','0',50.00,0.01,'0','1','1900-01-01','1')

('66','DSOUP','0','0',50.00,0.01,'0','1','1900-01-01','1')

('67','DSTEAMTAB','2','0',50.00,0.01,'0','1','1900-01-01','1')

('68','DOTHER','2','0',50.00,0.01,'0','1','1900-01-01','1')

('69','DBEVERAGE','2','0',50.00,0.01,'0','1','1900-01-01','1')

('70','DPREPCHEESE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('71','DPORTCHEESE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('72','DSOCHEESE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('73','DSO','2','0',50.00,0.01,'0','1','1900-01-01','1')

('74','DCOUPON','1','0',50.00,0.01,'0','1','1900-01-01','1')

('150','DOutsideBakery','0','1',50.00,0.01,'0','1','1900-01-01','1')

('151','GTEA','0','1',50.00,0.01,'0','1','1900-01-01','1')

('152','GBABY','0','1',50.00,0.01,'0','1','1900-01-01','1')

('153','GBAK/MIX','0','1',50.00,0.01,'0','1','1900-01-01','1')

('154','GBARS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('155','GCOOK/BKD','0','1',50.00,0.01,'0','1','1900-01-01','1')

('156','GCANBNVEG','0','1',50.00,0.01,'0','1','1900-01-01','1')

('157','GCEREAL','0','1',50.00,0.01,'0','1','1900-01-01','1')

('158','GCHIP','0','1',50.00,0.01,'0','1','1900-01-01','1')

('159','GCRACK/SN','0','1',50.00,0.01,'0','1','1900-01-01','1')

('160','GCOND/VIN','0','1',50.00,0.01,'0','1','1900-01-01','1')

('161','GETHNIC','0','1',50.00,0.01,'0','1','1900-01-01','1')

('162','GCANDYNOT','0','1',50.00,0.01,'0','1','1900-01-01','1')

('163','GGRAIN/RI','0','1',50.00,0.01,'0','1','1900-01-01','1')

('164','GJAM','0','1',50.00,0.01,'0','1','1900-01-01','1')

('165','GJUICE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('166','GMILK/POW','0','1',50.00,0.01,'0','1','1900-01-01','1')

('167','GMIX/PREP','0','1',50.00,0.01,'0','1','1900-01-01','1')

('168','GNUTBUTTE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('169','GOIL','0','1',50.00,0.01,'0','1','1900-01-01','1')

('170','GPASTA','0','1',50.00,0.01,'0','1','1900-01-01','1')

('171','GPICK/OLI','0','1',50.00,0.01,'0','1','1900-01-01','1')

('172','GSEAFOOD','0','1',50.00,0.01,'0','1','1900-01-01','1')

('173','GSALAD/DR','0','1',50.00,0.01,'0','1','1900-01-01','1')

('174','GSOUPCAN','0','1',50.00,0.01,'0','1','1900-01-01','1')

('175','GSOUP/PKG','0','1',50.00,0.01,'0','1','1900-01-01','1')

('176','GSWEETENE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('177','GTOMATO','0','1',50.00,0.01,'0','1','1900-01-01','1')

('178','GSO NOTAX','0','1',50.00,0.01,'0','1','1900-01-01','1')

('179','GCANDY','1','1',50.00,0.01,'0','1','1900-01-01','1')

('180','GCANDYSO','1','1',50.00,0.01,'0','1','1900-01-01','1')

('181','GHHCLEANR','1','0',50.00,0.01,'0','1','1900-01-01','1')

('182','GNFPET','1','0',50.00,0.01,'0','1','1900-01-01','1')

('183','GHHPAPER','1','0',50.00,0.01,'0','1','1900-01-01','1')

('185','GNFOODSO','1','0',50.00,0.01,'0','1','1900-01-01','1')

('186','GOTHER','0','1',50.00,0.01,'0','1','1900-01-01','1')

('251','BCOFFEE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('252','BDRVEGGIE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('253','BHERB','0','1',50.00,0.01,'0','1','1900-01-01','1')

('254','BORGHERB','0','1',50.00,0.01,'0','1','1900-01-01','1')

('255','BTEA','0','1',50.00,0.01,'0','1','1900-01-01','1')

('256','BVIT','1','0',50.00,0.01,'0','1','1900-01-01','1')

('257','BFOOD','0','1',50.00,0.01,'0','1','1900-01-01','1')

('245','BPKGCOFFEE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('239','BPACKNOTAX','0','1',50.00,0.01,'0','1','1900-01-01','1')

('93','HBODYCARE','1','0',50.00,0.01,'0','1','1900-01-01','1')

('94','HFACIAL','1','0',50.00,0.01,'0','1','1900-01-01','1')

('95','HBATH','1','0',50.00,0.01,'0','1','1900-01-01','1')

('96','HHAIR','1','0',50.00,0.01,'0','1','1900-01-01','1')

('97','HLOTION','1','0',50.00,0.01,'0','1','1900-01-01','1')

('98','HSOAP','1','0',50.00,0.01,'0','1','1900-01-01','1')

('99','HTEETH','1','0',50.00,0.01,'0','1','1900-01-01','1')

('100','HNONTAX','0','0',50.00,0.01,'0','1','1900-01-01','1')

('101','HVITSUPPL','1','0',50.00,0.01,'0','1','1900-01-01','1')

('102','HHERB','1','0',50.00,0.01,'0','1','1900-01-01','1')

('103','HOTHER','1','0',50.00,0.01,'0','1','1900-01-01','1')

('244','GMBooks','1','0',50.00,0.01,'0','1','1900-01-01','1')

('258','BSOHERB','0','1',50.00,0.01,'0','1','1900-01-01','1')

('259','BSOCOFFEE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('123','HSOBODYCA','1','0',50.00,0.01,'0','1','1900-01-01','1')

('124','HSOVITHERB','1','0',50.00,0.01,'0','1','1900-01-01','1')

('125','HSOBHBA','1','0',50.00,0.01,'0','1','1900-01-01','1')

('243','GMSOBooks','1','0',50.00,0.01,'0','1','1900-01-01','1')

('127','HSONOTAX','0','0',50.00,0.01,'0','1','1900-01-01','1')

('128','HCOUPON','1','0',50.00,0.01,'0','1','1900-01-01','1')

('600','SUPPLIES','0','0',50.00,0.01,'0','1','1900-01-01','1')

('187','GNONFDNOTAX','0','0',50.00,0.01,'0','1','1900-01-01','1')

('500','FLOWERS','1','0',50.00,0.01,'0','1','1900-01-01','1')

('502','PRODUCE KEY','0','1',50.00,0.01,'0','1','1900-01-01','1')

('604','MISC PO','0','0',50.00,0.01,'0','1','1900-01-01','1')

('503','BASKETS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('505','TRANSEDIBLE','1','1',50.00,0.01,'0','1','1900-01-01','1')

('507','SO TAX','1','0',50.00,0.01,'0','1','1900-01-01','1')

('200','PFLOWERS','1','1',50.00,0.01,'0','1','1900-01-01','1')

('201','PFRUIT','0','1',50.00,0.01,'0','1','1900-01-01','1')

('202','PJUICE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('203','PNONFOOD','1','1',50.00,0.01,'0','1','1900-01-01','1')

('204','POTHER','0','1',50.00,0.01,'0','1','1900-01-01','1')

('205','PREVRACK','1','1',50.00,0.01,'0','1','1900-01-01','1')

('206','PSO','0','1',50.00,0.01,'0','1','1900-01-01','1')

('208','PVEGGIE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('209','PSEEDS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('210','PRODREVN','0','1',50.00,0.01,'0','1','1900-01-01','1')

('220','PCOUPON','0','1',50.00,0.01,'0','1','1900-01-01','1')

('900','GIFTCERT','0','0',50.00,0.01,'0','1','1900-01-01','1')

('990','ARPAYMEN','0','0',50.00,0.01,'0','1','1900-01-01','1')

('991','CLASS B Equity','0','0',80.00,0.01,'0','1','1900-01-01','1')

('700','TOTES','0','0',50.00,0.01,'0','1','1900-01-01','1')

('508','ASIAN','0','1',50.00,0.01,'0','1','1900-01-01','1')

('510','BRASSICA','0','1',50.00,0.01,'0','1','1900-01-01','1')

('703','MISCRECEIPT','0','0',50.00,0.01,'0','1','1900-01-01','1')

('512','ETHNIC','0','1',50.00,0.01,'0','1','1900-01-01','1')

('513','GREENS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('992','CLASS A Equity','0','0',20.00,0.01,'0','1','1900-01-01','1')

('61','DOUTDESSERTS','2','0',50.00,0.01,'0','1','1900-01-01','1')

('62','DCO-OPSHARE','2','0',50.00,0.01,'0','1','1900-01-01','1')

('225','DGGSALADS','2','0',50.00,0.01,'0','1','1900-01-01','1')

('226','DGGSANDWICH','2','0',50.00,0.01,'0','1','1900-01-01','1')

('227','DOLIVES','0','0',50.00,0.01,'0','1','1900-01-01','1')

('228','DDGGENTREE','2','0',50.00,0.01,'0','1','1900-01-01','1')

('229','DDESSERT','0','0',50.00,0.01,'0','1','1900-01-01','1')

('230','DPREPCHEESE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('231','DPORCHEESE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('232','DFAKECHEESE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('233','DSOCHEESE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('37','CBEVERAGE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('35','CYOGURT','0','1',50.00,0.01,'0','1','1900-01-01','1')

('260','MEAT FRESH','0','1',50.00,0.01,'0','1','1900-01-01','1')

('242','GMGENERAL','1','0',50.00,0.01,'0','1','1900-01-01','1')

('902','GIFTCARD','0','0',300.00,0.01,'0','1','1990-01-01','1')

('234','DVENDORS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('235','MARKETING SALES','1','0',50.00,0.01,'0','1','1900-01-01','1')

('501','NON-FOOD','1','0',50.00,0.01,'0','1','1900-01-01','1')

('240','GMMag','1','0',50.00,0.01,'0','1','2005-13-11','1')

('241','GMCards','1','0',50.00,0.01,'0','1','2005-13-11','1')

('262','MeatSOFrsh','0','1',50.00,0.01,'0','1','2005-13-12','1')

('263','MeatSOFrzn','0','1',50.00,0.01,'0','1','2005-13-12','1')

('53','CSOButter','0','1',50.00,0.01,'0','1','2005-13-12','1')

('800','IT Corrections','0','1',9999.00,-9999.00,'0','1','2006-08-01','1001')

('238','POLDFLOWERS','1','0',50.00,0.01,'0','1','2005-28-03','1')

('708','CLASSES','0','0',50.00,0.01,'0','1','2006-06-04','1001')

('75','DSOBAKED','0','0',50.00,0.01,'0','1','2006-11-05','1')

('207','PSOTAX','1','1',50.00,0.01,'0','1','2006-16-06','1')

('610','RRR','0','0',50.00,0.01,'0','1','2006-24-10','1001')

('76','DDELI MEATS','0','0',50.00,0.01,'0','1','1900-01-01','1')

('504','TRAYS','1','0',50.00,0.01,'0','1','1900-01-01','1')

('86','HSEASONAL','1','0',50.00,0.01,'0','1','2008-10-04','1')

('506','TRANSNONEDIBLE','1','0',50.00,0.01,'0','1','1900-01-01','1')

('509','BEAN','0','1',50.00,0.01,'0','1','1900-01-01','1')

('511','CARROTS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('514','HERBS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('515','LETTUCE','0','1',50.00,0.01,'0','1','1900-01-01','1')

('516','MUSHROOMS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('517','ONIONS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('518','PEPPERS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('519','POTATOES','0','1',50.00,0.01,'0','1','1900-01-01','1')

('520','ROOTS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('521','SALADS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('522','SPROUTS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('523','SQUASH','0','1',50.00,0.01,'0','1','1900-01-01','1')

('524','TOMATOES','0','1',50.00,0.01,'0','1','1900-01-01','1')

('525','WSQUASH','0','1',50.00,0.01,'0','1','1900-01-01','1')

('526','YAMS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('527','VEGGMISC','0','1',50.00,0.01,'0','1','1900-01-01','1')

('528','VEGGJAR','0','1',50.00,0.01,'0','1','1900-01-01','1')

('529','VEGGCUTS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('540','APPLEBAG','0','1',50.00,0.01,'0','1','1900-01-01','1')

('541','APPLES','0','1',50.00,0.01,'0','1','1900-01-01','1')

('542','BERRIES','0','1',50.00,0.01,'0','1','1900-01-01','1')

('543','CITRUSBAG','0','1',50.00,0.01,'0','1','1900-01-01','1')

('544','CITRUS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('545','PEARBAG','0','1',50.00,0.01,'0','1','1900-01-01','1')

('546','PEARS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('547','TROPICAL','0','1',50.00,0.01,'0','1','1900-01-01','1')

('548','NUTS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('549','ETHNIC','0','1',50.00,0.01,'0','1','1900-01-01','1')

('550','FIGS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('551','GRAPES','0','1',50.00,0.01,'0','1','1900-01-01','1')

('552','FRUITJAR','0','1',50.00,0.01,'0','1','1900-01-01','1')

('553','FRUITMISC','0','1',50.00,0.01,'0','1','1900-01-01','1')

('554','FRUITCUTS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('555','MELONS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('556','STONEFRUIT','0','1',50.00,0.01,'0','1','1900-01-01','1')

('557','AVOCADOS','0','1',50.00,0.01,'0','1','1900-01-01','1')

('535','PRODUCE CORRECTION','0','1',50.00,0.01,'0','1','2008-02-04','1')

('87','HLIP','1','0',50.00,0.01,'0','1','2008-10-04','1')

('88','HDEOD','1','0',50.00,0.01,'0','1','2008-10-04','1')

('89','HAROMATHERPY','1','0',50.00,0.01,'0','1','2008-10-04','1')

('90','HFIRSTAID','1','0',50.00,0.01,'0','1','2008-10-04','1')

('91','HKIDSBODY','1','0',50.00,0.01,'0','1','2008-10-04','1')

('105','HPROTEIN','1','0',50.00,0.01,'0','1','2008-10-04','1')

('106','HJUICE','1','0',50.00,0.01,'0','1','2008-10-04','1')

('107','HGREENS','1','0',50.00,0.01,'0','1','2008-10-04','1')

('108','HKIDSSUPP','1','0',50.00,0.01,'0','1','2008-10-04','1')

('881','MISC #1','0','0',50.00,0.01,'0','1','2008-12-08','1')

('882','MISC #2','0','0',50.00,0.01,'0','1','2008-12-08','1')

('236','MARKETING PROMO','0','0',50.00,0.01,'0','1','2009-26-01','1')

('77','DSPECIALEVENT','2','0',50.00,0.01,'0','1','2009-10-09','1')

gohanman commented 10 years ago

Zeroes would be more correct. a9b9ee3e151918f052a1a57e03a18e3b8e45cd64

The column was added for age-restricted items - e.g., beer/wine. Most departments shouldn't require the customer to show ID (well, unless there's a co-op liquor store out there or something).

scannerdarkly commented 10 years ago

LOL — thanks!