Cacher is the code snippet organizer for pro developers

INSERT INTO VOUCHER
(SITE, FULFILLMENT_CTR_ID, TYPE, NAME, STARTDATE, ENDDATE, THRESHOLD, DISCOUNT, DESCRIPTION, INVALID_DESCRIPTION, POSTAGEDISCOUNT, SINGLE_REDEMPTION, DDC_ACCOUNT_ONLY, MAXVOUCHERS) VALUES
('EUKDDC', 5, 'SPENDX', 'NPD781', '18/11/2013 00:00:00', '20/12/2013 00:00:00', 60.00, 10.00, 'Spend over £60 ex vat get £10 off', 'This voucher is not valid for this basket. You need to select a minimum of £60', 0.00, 'N', 'N', NULL)