forms/migrations/20220909135248_forms_submissions.sql
realaravinth 68d50b69dd
Some checks failed
ci/woodpecker/push/woodpecker Pipeline failed
feat: update sqlx and store form data
2022-09-09 19:51:54 +05:30

7 lines
253 B
SQL

CREATE TABLE IF NOT EXISTS forms_submissions (
ID SERIAL PRIMARY KEY NOT NULL,
website_path VARCHAR(2500) NOT NULL,
value JSONB,
time timestamptz NOT NULL DEFAULT now(),
website_id INTEGER NOT NULL references forms_websites(ID) ON DELETE CASCADE
)