15 lines
502 B
SQL
15 lines
502 B
SQL
ALTER TABLE answer
|
|
DROP COLUMN utm;
|
|
|
|
CREATE TABLE IF NOT EXISTS utms (
|
|
ID BIGSERIAL UNIQUE NOT NULL PRIMARY KEY,
|
|
AmoFieldID INT NOT NULL DEFAULT 0, -- id field в амо
|
|
QuizID INT NOT NULL, -- id опроса
|
|
AccountID INT NOT NULL, -- id аккаунта в амо AMOID
|
|
Name VARCHAR(512) NOT NULL DEFAULT '', -- название utm
|
|
Deleted BOOLEAN NOT NULL DEFAULT FALSE,
|
|
CreatedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
ALTER TABLE rules
|
|
ADD COLUMN UTMS INTEGER[]; |