aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
Diffstat (limited to 'install')
-rw-r--r--install/schema_mysql.sql1
-rw-r--r--install/schema_postgres.sql3
-rw-r--r--install/update.php11
3 files changed, 13 insertions, 2 deletions
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;
+}
+
+