From 24ddc8e026472368eb57cfa0abc522eb4a568e71 Mon Sep 17 00:00:00 2001 From: redmatrix Date: Thu, 22 Sep 2016 17:00:32 -0700 Subject: issue #523 --- install/schema_postgres.sql | 2 +- install/update.php | 2 +- 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 '', -- cgit v1.2.3