aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--schema.sql35
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)
+);