diff options
| -rw-r--r-- | install/schema_postgres.sql | 2 | ||||
| -rw-r--r-- | 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 '', |