10 lines
453 B
SQL
10 lines
453 B
SQL
-- DB version: 3.8 -> 3.8.1
|
|
|
|
ALTER TABLE EXECUTION_DEPOSIT ALTER COLUMN MARKET TYPE varchar(8);
|
|
ALTER TABLE EXECUTION_DEPOSIT_HISTORY ALTER COLUMN MARKET TYPE varchar(8);
|
|
|
|
ALTER TABLE S_DF53 ADD COLUMN IF NOT EXISTS DATE varchar(8);
|
|
COMMENT ON COLUMN S_DF53.DATE IS 'Дата изменения состояния счета';
|
|
|
|
|
|
INSERT INTO DB_VERSION(ID, VERSION) values (1, '3.8.1') ON CONFLICT (ID) DO UPDATE SET VERSION = EXCLUDED.VERSION
|