From a314f3ff2eff4e7fa62f67dfd1b6ebc7b619740b Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Asbj=C3=B8rn=20Sloth=20T=C3=B8nnesen?= <ast@a5n.dk>
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 <ast@a5n.dk>
---
 schema.sql | 35 +++++++++++++++++++++++++++++++++++
 1 file changed, 35 insertions(+)

(limited to 'schema.sql')

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

