db schema change to add tags to content sources

4 files changed, 14 insertions, 3 deletions

diff --git a/boot.php b/boot.php
index bb78db44f..95f41dfda 100755
--- a/boot.php
+++ b/boot.php
@@ -49,7 +49,7 @@ define ( 'PLATFORM_NAME',           'hubzilla' );
 define ( 'STD_VERSION',             '1.4.4' );
 define ( 'ZOT_REVISION',            1     );
 
-define ( 'DB_UPDATE_VERSION',       1166  );
+define ( 'DB_UPDATE_VERSION',       1167  );
 
 
 /**
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index c36bfaa57..2305d4a0b 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -1181,6 +1181,7 @@ CREATE TABLE IF NOT EXISTS `source` (
   `src_channel_xchan` char(255) NOT NULL DEFAULT '',
   `src_xchan` char(255) NOT NULL DEFAULT '',
   `src_patt` mediumtext NOT NULL,
+  `src_tag` mediumtext NOT NULL,
   PRIMARY KEY (`src_id`),
   KEY `src_channel_id` (`src_channel_id`),
   KEY `src_channel_xchan` (`src_channel_xchan`),
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");
diff --git a/install/update.php b/install/update.php
index 2dc4a6db3..b8e20786c 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1166 );
+define( 'UPDATE_VERSION' , 1167 );
 
 /**
  *
@@ -2071,3 +2071,12 @@ function update_r1165() {
     return UPDATE_FAILED;
 }
 
+function update_r1166() {
+
+	$r = q("alter table source add src_tag text not null default '' ");
+    if($r)
+        return UPDATE_SUCCESS;
+    return UPDATE_FAILED;
+}
+
+