17 lines
374 B
PL/PgSQL
17 lines
374 B
PL/PgSQL
BEGIN;
|
|
|
|
INSERT INTO payment_method (code, label)
|
|
VALUES
|
|
('card', 'Kredit-/Debitkarten'),
|
|
('twint', 'TWINT'),
|
|
('bank_transfer', 'Bankueberweisung')
|
|
ON CONFLICT (code) DO NOTHING;
|
|
|
|
INSERT INTO shipping_method (code, label)
|
|
VALUES
|
|
('post_standard', 'Versand mit Die Schweizerische Post (1-3 Werktage)'),
|
|
('pickup', 'Abholung')
|
|
ON CONFLICT (code) DO NOTHING;
|
|
|
|
COMMIT;
|