diff options
| author | redmatrix <mike@macgirvin.com> | 2016-09-22 17:00:32 -0700 |
|---|---|---|
| committer | redmatrix <mike@macgirvin.com> | 2016-09-22 17:00:32 -0700 |
| commit | 24ddc8e026472368eb57cfa0abc522eb4a568e71 (patch) | |
| tree | 139c3e9715b86bd61470bb4c6769530acaf3b2c7 | |
| parent | 9981cbb72c223873987b75e890a3e6297e5983dc (diff) | |
| download | volse-hubzilla-24ddc8e026472368eb57cfa0abc522eb4a568e71.tar.gz volse-hubzilla-24ddc8e026472368eb57cfa0abc522eb4a568e71.tar.bz2 volse-hubzilla-24ddc8e026472368eb57cfa0abc522eb4a568e71.zip | |
issue #523
| -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 '', |