17 lines
637 B
SQL
17 lines
637 B
SQL
-- Add migration script here
|
|
CREATE TABLE IF NOT EXISTS security_notice (
|
|
id BIGSERIAL PRIMARY KEY,
|
|
key TEXT NOT NULL UNIQUE,
|
|
title TEXT NOT NULL DEFAULT '',
|
|
product_name TEXT NOT NULL DEFAULT '',
|
|
risk_level TEXT NOT NULL DEFAULT '',
|
|
source TEXT NOT NULL DEFAULT '',
|
|
source_name TEXT NOT NULL DEFAULT '',
|
|
is_zero_day BOOLEAN NOT NULL DEFAULT FALSE,
|
|
publish_time TEXT NOT NULL DEFAULT '',
|
|
detail_link TEXT NOT NULL DEFAULT '',
|
|
pushed BOOLEAN NOT NULL DEFAULT FALSE,
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP
|
|
);
|