Closed PeoplesFoodCoop closed 10 years ago
It occurred to me that it is all on the other hard drive in the system.
grabbed monday from old trunk disk and rolled them into trans_archive, is4c_log.transarchive, and is4c_log.dlog15
INSERT INTO trans_archive.transArchive201401
(datetime
, register_no
, emp_no
, trans_no
, upc
, description
, trans_type
, trans_subtype
, trans_status
, department
, quantity
, scale
, cost
, unitPrice
, total
, regPrice
, tax
, foodstamp
, discount
, memDiscount
, discountable
, discounttype
, voided
, percentDiscount
, ItemQtty
, volDiscType
, volume
, VolSpecial
, mixMatch
, matched
, memType
, staff
, numflag
, card_no
, trans_id
) SELECT datetime
, register_no
, emp_no
, trans_no
, upc
, description
, trans_type
, trans_subtype
, trans_status
, department
, quantity
, Scale
, cost
, unitPrice
, total
, regPrice
, tax
, foodstamp
, discount
, memDiscount
, discountable
, discounttype
, voided
, percentDiscount
, ItemQtty
, volDiscType
, volume
, VolSpecial
, mixMatch
, matched
, memType
, staff
, props
card_no
, trans_id
FROM monday.dtransactions
INSERT INTO core_log.transarchive
(datetime
, register_no
, emp_no
, trans_no
, upc
, description
, trans_type
, trans_subtype
, trans_status
, department
, quantity
, scale
, cost
, unitPrice
, total
, regPrice
, tax
, foodstamp
, discount
, memDiscount
, discountable
, discounttype
, voided
, percentDiscount
, ItemQtty
, volDiscType
, volume
, VolSpecial
, mixMatch
, matched
, memType
, staff
, numflag
, card_no
, trans_id
) SELECT datetime
, register_no
, emp_no
, trans_no
, upc
, description
, trans_type
, trans_subtype
, trans_status
, department
, quantity
, Scale
, cost
, unitPrice
, total
, regPrice
, tax
, foodstamp
, discount
, memDiscount
, discountable
, discounttype
, voided
, percentDiscount
, ItemQtty
, volDiscType
, volume
, VolSpecial
, mixMatch
, matched
, memType
, staff
, props
card_no
, trans_id
FROM monday.dtransactions
and insert into dlog15 select * from dlog90 WHERE DAY(dtime)=27
Can't find monday anywhere. Joel... any ideas?