• last updated 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fix acs_activity__edit (TODO: upgrade script)

Fix typos

  1. … 8 more files in changeset.
Rename constraints to follow coding standards (fixes automated test datamodel__named_constraints)

Renaming constraints on Postgres without dropping/rebuilding requires version >= 9.2

    • -0
    • +10
    ./oracle/upgrade/upgrade-0.6.2d4-0.6.2d5.sql
    • -0
    • +10
    ./postgresql/upgrade/upgrade-0.6.2d4-0.6.2d5.sql
  1. … 1 more file in changeset.
Trim whitespace

    • -190
    • +189
    ./oracle/acs-events-create.sql
Whitespace trimming

    • -23
    • +18
    ./postgresql/activity-create.sql
    • -122
    • +121
    ./postgresql/acs-events-create.sql
Align case of acs_object_type with that of the actual table (fixes automated tests)

This change intentionally ingores Oracle, as its behavior with respect to case is not clear to me.

    • -0
    • +8
    ./postgresql/upgrade/upgrade-0.6.2d3-0.6.2d4.sql
  1. … 1 more file in changeset.
Change declared acs_attribute datatype to boolean for boolean columns

    • -0
    • +19
    ./postgresql/upgrade/upgrade-0.6.2d2-0.6.2d3.sql
  1. … 1 more file in changeset.
add forgotton fields related_link_url, related_link_text, redirect_to_rel_link_p to acs_event.new() and friends.

These files are part of the datamodel since many years, but someone forgot to adapt DB API for it.

VS: ----------------------------------------------------------------------

    • -0
    • +237
    ./oracle/upgrade/upgrade-0.6.2d0-0.6.2d1.sql
    • -0
    • +756
    ./oracle/upgrade/upgrade-0.6.2d1-0.6.2d2.sql
    • -16
    • +21
    ./postgresql/acs-events-create.sql
    • -0
    • +139
    ./postgresql/upgrade/upgrade-0.6.2d1-0.6.2d2.sql
  1. … 1 more file in changeset.
fix type reference for oracle

Fix typos

  1. … 11 more files in changeset.
Add field "location" to acs_events: an event has now a place and a time.

This is a prerequisite for adding a "location" to the calendar.

- add location to acs_attributes

- recreate views "acs_events_dates" and "acs_events_activities"

to return location

- extend "acs_event__new()" (pg) and "acs_event.new()" (ora)

to accept location

- let handle "acs_event.new_instance()" the location attribute

- bump version number to 0.6.2d1

    • -0
    • +579
    ./oracle/upgrade/upgrade-0.6.2d0-0.6.2d1.sql
    • -18
    • +41
    ./postgresql/acs-events-create.sql
    • -0
    • +180
    ./postgresql/upgrade/upgrade-0.6.2d0-0.6.2d1.sql
  1. … 1 more file in changeset.
Improve spellinig

improve indentation

    • -14
    • +14
    ./postgresql/oracle-compat-create.sql
Fix typos

    • -2
    • +2
    ./postgresql/test/time_intervals-test.sql
  1. … 61 more files in changeset.
Fix typos

  1. … 12 more files in changeset.
Added missing index creation statment; Fixed typo in index name

    • -0
    • +5
    ./postgresql/upgrade/upgrade-0.6-0.6.1.sql
  1. … 1 more file in changeset.
fix typos

  1. … 3 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7832 more files in changeset.
Fix spelling errors

  1. … 11 more files in changeset.
- add function args missed by earlier upgrades

- bump version numbers

    • -0
    • +48
    ./postgresql/upgrade/upgrade-0.6d7-0.6d8.sql
  1. … 9 more files in changeset.
Merging back to HEAD all changes that happened in branch oacs-5-8 between tags: vg-merge-oacs-5-8-from-20141027 and vg-merge-oacs-5-8-from-20150427

  1. … 520 more files in changeset.
- add missing index (important for large sites)

  1. … 1 more file in changeset.
file upgrade-0.6d6-0.6d7.sql was initially added on branch oacs-5-8.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.6d6-0.6d7.sql
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

  1. … 2546 more files in changeset.
- add still missing function args

  1. … 1 more file in changeset.
file upgrade-0.6d5-0.6d6.sql was initially added on branch oacs-5-8.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.6d5-0.6d6.sql
- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

    • -646
    • +762
    ./postgresql/acs-events-create.sql
    • -192
    • +229
    ./postgresql/activity-create.sql
    • -125
    • +163
    ./postgresql/oracle-compat-create.sql
    • -51
    • +62
    ./postgresql/recurrence-create.sql
    • -638
    • +804
    ./postgresql/timespan-create.sql
    • -299
    • +322
    ./postgresql/test/acs-events-test.sql
    • -225
    • +277
    ./postgresql/test/time_intervals-test.sql
    • -208
    • +291
    ./postgresql/test/timespan-test.sql
    • -403
    • +487
    ./postgresql/test/utest-create.sql
    • -150
    • +157
    ./postgresql/test/utest.sql
    • -26
    • +22
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
    • -127
    • +77
    ./postgresql/upgrade/upgrade-0.4d-0.4d1.sql
    • -22
    • +20
    ./postgresql/upgrade/upgrade-0.5d1-0.5d2.sql
    • -86
    • +54
    ./postgresql/upgrade/upgrade-0.5d2-0.5d3.sql
    • -136
    • +78
    ./postgresql/upgrade/upgrade-0.6d1-0.6d2.sql
    • -89
    • +55
    ./postgresql/upgrade/upgrade-0.6d2-0.6d3.sql
    • -79
    • +59
    ./postgresql/upgrade/upgrade-0.6d3-0.6d4.sql
PG 9.0 compatibility. Changes regarding usage of sequences. Deleting unused views and sequences.

    • -0
    • +149
    ./postgresql/upgrade/upgrade-0.6d3-0.6d4.sql
  1. … 1 more file in changeset.
More fixes to timespan calculaton to handle timezone (DST) spanning recurring events.

  1. … 1 more file in changeset.
Fix problem with Daylight Saving Time when creating recurring

events. This works fine in Oracle because the timestamps don't have

timezones. In Postgresql when calculating the interval between events

for recurring events, we need to ignore the timezone to get the

correct result when the event crosses the Daylight Saving Time boundar.

    • -0
    • +248
    ./postgresql/upgrade/upgrade-0.6d2-0.6d3.sql