From a314f3ff2eff4e7fa62f67dfd1b6ebc7b619740b Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Asbj=C3=B8rn=20Sloth=20T=C3=B8nnesen?= Date: Thu, 7 Nov 2024 21:50:31 +0000 Subject: schema: add support for new objects MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: Asbjørn Sloth Tønnesen --- schema.sql | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) diff --git a/schema.sql b/schema.sql index 7c48bc8..6b4d30f 100644 --- a/schema.sql +++ b/schema.sql @@ -36,6 +36,7 @@ CREATE TABLE IF NOT EXISTS peeringdb.ix ( CREATE TABLE IF NOT EXISTS peeringdb.fac ( id int not null, org_id int not null, + campus_id int, status text not null, data jsonb not null, created timestamptz not null, @@ -113,3 +114,37 @@ CREATE TABLE IF NOT EXISTS peeringdb.netixlan ( deleted timestamptz, primary key (id) ); + +CREATE TABLE IF NOT EXISTS peeringdb.carrier ( + id int not null, + org_id int not null, + status text not null, + data jsonb not null, + created timestamptz not null, + updated timestamptz not null, + deleted timestamptz, + primary key (id) +); + +CREATE TABLE IF NOT EXISTS peeringdb.carrierfac ( + id int not null, + carrier_id int not null, + fac_id int not null, + status text not null, + data jsonb not null, + created timestamptz not null, + updated timestamptz not null, + deleted timestamptz, + primary key (id) +); + +CREATE TABLE IF NOT EXISTS peeringdb.campus ( + id int not null, + org_id int not null, + status text not null, + data jsonb not null, + created timestamptz not null, + updated timestamptz not null, + deleted timestamptz, + primary key (id) +); -- cgit v1.2.1