From edbcba6f113a5c8b709cdbfca892e845b5096ede Mon Sep 17 00:00:00 2001
From: redmatrix <redmatrix@redmatrix.me>
Date: Mon, 28 Sep 2015 04:15:21 -0700
Subject: schema support for additional site types

---
 install/schema_postgres.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'install/schema_postgres.sql')

diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 6145e9ccb..f378a3e3d 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -1122,6 +1122,7 @@ CREATE TABLE "site" (
   "site_realm" text NOT NULL DEFAULT '',
   "site_valid" smallint NOT NULL DEFAULT '0',
   "site_dead" smallint NOT NULL DEFAULT '0',
+  "site_type" smallint NOT NULL DEFAULT '0',
   PRIMARY KEY ("site_url")
 );
 create index "site_flags" on site ("site_flags");
@@ -1133,6 +1134,7 @@ create index "site_sellpage" on site ("site_sellpage");
 create index "site_realm" on site ("site_realm");
 create index "site_valid" on site ("site_valid");
 create index "site_dead" on site ("site_dead");
+create index "site_type" on site ("site_type");
 
 CREATE TABLE "source" (
   "src_id" serial  NOT NULL,
-- 
cgit v1.2.3

