From bd2f11ed8b0be4fb611c33e85b568048f79b7090 Mon Sep 17 00:00:00 2001
From: redmatrix <git@macgirvin.com>
Date: Sun, 1 May 2016 21:00:02 -0700
Subject: db schema change to add tags to content sources

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

(limited to 'install/schema_postgres.sql')

diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index d4bb54b1e..2c0847cbf 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -1166,7 +1166,8 @@ CREATE TABLE "source" (
   "src_channel_id" bigint  NOT NULL DEFAULT '0',
   "src_channel_xchan" text NOT NULL DEFAULT '',
   "src_xchan" text NOT NULL DEFAULT '',
-  "src_patt" text NOT NULL,
+  "src_patt" text NOT NULL DEFAULT '',
+  "src_tag" text NOT NULL DEFAULT '',
   PRIMARY KEY ("src_id")
 );
 create index "src_channel_id" on "source" ("src_channel_id");
-- 
cgit v1.2.3

