aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-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 '',