Rikard BartholfandGitHub
9f54d2fc0d
* Create type discount_usage * Add discount_codes.discount_usage_type * Fix SQL * Make query idempotent * Bump revision
15 lines
325 B
SQL
15 lines
325 B
SQL
ALTER TABLE discount_codes
|
|
DROP COLUMN IF EXISTS discount_usage_type;
|
|
|
|
DROP TYPE IF EXISTS discount_usage;
|
|
|
|
CREATE TYPE discount_usage AS ENUM (
|
|
'default',
|
|
'influencer',
|
|
'customer service',
|
|
'internal'
|
|
);
|
|
|
|
ALTER TABLE discount_codes
|
|
ADD COLUMN discount_usage_type discount_usage NOT NULL DEFAULT 'default';
|