aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
authorredmatrix <mike@macgirvin.com>2016-09-07 17:36:45 -0700
committerredmatrix <mike@macgirvin.com>2016-09-07 17:36:45 -0700
commitc2f83639d49c4ff49acdaa5c6f3dd0a3c1edbdf9 (patch)
treec0c066eb952cb2eca78a0d1cc5e9b6b86ddebe6a /install
parent77e865fc8ef8b41112885390881cf260b5c726ef (diff)
downloadvolse-hubzilla-c2f83639d49c4ff49acdaa5c6f3dd0a3c1edbdf9.tar.gz
volse-hubzilla-c2f83639d49c4ff49acdaa5c6f3dd0a3c1edbdf9.tar.bz2
volse-hubzilla-c2f83639d49c4ff49acdaa5c6f3dd0a3c1edbdf9.zip
provide version info in /pubsites
Diffstat (limited to 'install')
-rw-r--r--install/schema_mysql.sql1
-rw-r--r--install/schema_postgres.sql1
-rw-r--r--install/update.php10
3 files changed, 11 insertions, 1 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 5e5b9d5be..9a4f58880 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -1151,6 +1151,7 @@ CREATE TABLE IF NOT EXISTS `site` (
`site_dead` smallint NOT NULL DEFAULT '0',
`site_type` smallint NOT NULL DEFAULT '0',
`site_project` char(255) NOT NULL DEFAULT '',
+ `site_version` varchar(32) NOT NULL DEFAULT '',
PRIMARY KEY (`site_url`),
KEY `site_flags` (`site_flags`),
KEY `site_update` (`site_update`),
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 44711c190..b190a810a 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -1131,6 +1131,7 @@ CREATE TABLE "site" (
"site_dead" smallint NOT NULL DEFAULT '0',
"site_type" smallint NOT NULL DEFAULT '0',
"site_project" text NOT NULL DEFAULT '',
+ "site_version" text NOT NULL DEFAULT '',
PRIMARY KEY ("site_url")
);
create index "site_flags" on site ("site_flags");
diff --git a/install/update.php b/install/update.php
index 2b3a9b338..9fd362fff 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
<?php
-define( 'UPDATE_VERSION' , 1182 );
+define( 'UPDATE_VERSION' , 1183 );
/**
*
@@ -2436,3 +2436,11 @@ function update_r1181() {
return UPDATE_SUCCESS;
}
+function update_r1182() {
+
+ $r1 = q("alter table site add site_version varchar(32) not null default '' ");
+
+ if($r1)
+ return UPDATE_SUCCESS;
+ return UPDATE_FAILED;
+}