schema: add support for new objects

Signed-off-by: Asbjørn Sloth Tønnesen <ast@a5n.dk>

1 files changed, 35 insertions, 0 deletions

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)
+);