Changeset:
1d910a13bd26
https://sourceforge.net/p/mrbs/hg-code/ci/1d910a13bd2615d85a98c0548965ae3134426a16
Author:
Campbell Morrison <[email protected]>
Date:
Thu Oct 22 16:36:04 2015 +0100
Log message:
Fixed problem with Upgrade 25 in PostgreSQL (datetime data type)
diffstat:
web/upgrade/25/pgsql.sql | 7 +++----
1 files changed, 3 insertions(+), 4 deletions(-)
diffs (16 lines):
diff -r e4674a64d965 -r 1d910a13bd26 web/upgrade/25/pgsql.sql
--- a/web/upgrade/25/pgsql.sql Thu Oct 22 16:21:38 2015 +0100
+++ b/web/upgrade/25/pgsql.sql Thu Oct 22 16:36:04 2015 +0100
@@ -4,9 +4,8 @@
-- series that has been modified, ie has entry_type=2, then the sequence
number
-- cannot be 0. We will set it to 1.
-ALTER TABLE %DB_TBL_PREFIX%entry ADD COLUMN saved_ts DATETIME;
-UPDATE %DB_TBL_PREFIX%entry SET saved_ts=timestamp;
+-- No need to save the timestamp as timestamps aren't updated in PostgreSQL
+
+
UPDATE %DB_TBL_PREFIX%entry
SET ical_sequence=1 WHERE ical_sequence=0 AND entry_type=2;
-UPDATE %DB_TBL_PREFIX%entry SET timestamp=saved_ts;
-ALTER TABLE %DB_TBL_PREFIX%entry DROP COLUMN saved_ts;
------------------------------------------------------------------------------
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
