18 lines
612 B
SQL
18 lines
612 B
SQL
DROP INDEX if EXISTS idx_unique_tokens_yclients;
|
|
DROP TABLE IF EXISTS YclientsTokens;
|
|
|
|
ALTER TABLE YclientsAccounts
|
|
DROP COLUMN IF EXISTS ShortDecription,
|
|
DROP COLUMN IF EXISTS Country;
|
|
|
|
ALTER TABLE YclientsTimeSlots
|
|
ALTER COLUMN DatesSettings SET DEFAULT '[]'::jsonb;
|
|
|
|
UPDATE YclientsTimeSlots
|
|
SET DatesSettings = '[]'::jsonb
|
|
WHERE DatesSettings = '{}'::jsonb;
|
|
|
|
ALTER TABLE YclientsServices
|
|
ALTER COLUMN PriceMin TYPE FLOAT USING NULLIF(PriceMin, '')::FLOAT,
|
|
ALTER COLUMN PriceMax TYPE FLOAT USING NULLIF(PriceMax, '')::FLOAT,
|
|
ALTER COLUMN Discount TYPE INT USING NULLIF(Discount, '')::INT; |