aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
authorredmatrix <mike@macgirvin.com>2016-09-22 17:00:32 -0700
committerredmatrix <mike@macgirvin.com>2016-09-22 17:00:32 -0700
commit24ddc8e026472368eb57cfa0abc522eb4a568e71 (patch)
tree139c3e9715b86bd61470bb4c6769530acaf3b2c7 /install
parent9981cbb72c223873987b75e890a3e6297e5983dc (diff)
downloadvolse-hubzilla-24ddc8e026472368eb57cfa0abc522eb4a568e71.tar.gz
volse-hubzilla-24ddc8e026472368eb57cfa0abc522eb4a568e71.tar.bz2
volse-hubzilla-24ddc8e026472368eb57cfa0abc522eb4a568e71.zip
issue #523
Diffstat (limited to 'install')
-rw-r--r--install/schema_postgres.sql2
-rw-r--r--install/update.php2
2 files changed, 2 insertions, 2 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index caa182b14..ab9a5cff4 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -396,7 +396,7 @@ create index "conv_created_idx" on conv ("created");
create index "conv_updated_idx" on conv ("updated");
CREATE TABLE IF NOT EXISTS "dreport" (
- "dreport_id" int NOT NULL,
+ "dreport_id" serial NOT NULL,
"dreport_channel" int NOT NULL DEFAULT '0',
"dreport_mid" char(255) NOT NULL DEFAULT '',
"dreport_site" char(255) NOT NULL DEFAULT '',
diff --git a/install/update.php b/install/update.php
index 9fd362fff..5e5a25966 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1810,7 +1810,7 @@ function update_r1152() {
if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
$r1 = q("CREATE TABLE IF NOT EXISTS \"dreport\" (
- \"dreport_id\" int(11) NOT NULL,
+ \"dreport_id\" serial NOT NULL,
\"dreport_channel\" int(11) NOT NULL DEFAULT '0',
\"dreport_mid\" char(255) NOT NULL DEFAULT '',
\"dreport_site\" char(255) NOT NULL DEFAULT '',