diff options
| -rw-r--r-- | schema.sql | 35 |
1 files changed, 35 insertions, 0 deletions
@@ -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) +); |