diff options
| author | redmatrix <git@macgirvin.com> | 2016-05-01 21:00:02 -0700 |
|---|---|---|
| committer | redmatrix <git@macgirvin.com> | 2016-05-01 21:00:02 -0700 |
| commit | bd2f11ed8b0be4fb611c33e85b568048f79b7090 (patch) | |
| tree | b0bb7e430d6c0a21b5601368b825f6cefc4f181c /install | |
| parent | 5e458491f1e0fce5ec9e4855dac13340af627ded (diff) | |
| download | volse-hubzilla-bd2f11ed8b0be4fb611c33e85b568048f79b7090.tar.gz volse-hubzilla-bd2f11ed8b0be4fb611c33e85b568048f79b7090.tar.bz2 volse-hubzilla-bd2f11ed8b0be4fb611c33e85b568048f79b7090.zip | |
db schema change to add tags to content sources
Diffstat (limited to 'install')
| -rw-r--r-- | install/schema_mysql.sql | 1 | ||||
| -rw-r--r-- | install/schema_postgres.sql | 3 | ||||
| -rw-r--r-- | install/update.php | 11 |
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; +} + + |