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

  1. … 1 more file 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
    ./upgrade-0.6.2d4-0.6.2d5.sql
  1. … 6 more files in changeset.
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
    ./upgrade-0.6.2d3-0.6.2d4.sql
  1. … 3 more files in changeset.
Change declared acs_attribute datatype to boolean for boolean columns

    • -0
    • +19
    ./upgrade-0.6.2d2-0.6.2d3.sql
  1. … 3 more files 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
    • +139
    ./upgrade-0.6.2d1-0.6.2d2.sql
  1. … 5 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
    • +180
    ./upgrade-0.6.2d0-0.6.2d1.sql
  1. … 4 more files in changeset.
Added missing index creation statment; Fixed typo in index name

    • -0
    • +5
    ./upgrade-0.6-0.6.1.sql
  1. … 2 more files in changeset.
- add function args missed by earlier upgrades

- bump version numbers

    • -0
    • +48
    ./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
    ./upgrade-0.6d6-0.6d7.sql
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

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

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

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

- add missing function_args

  1. … 10 more files in changeset.
PG 9.0 compatibility. Changes regarding usage of sequences. Deleting unused views and sequences.

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

  1. … 2 more files 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
    ./upgrade-0.6d2-0.6d3.sql
  1. … 1 more file in changeset.
Merged changes to HEAD ...

  1. … 1556 more files in changeset.
Make sure "this event" is updated when editing a reucrrence and applying

to this event and all future events

  1. … 3 more files in changeset.
All editing only future events of a recurrence

  1. … 3 more files in changeset.
Fix handling of recurring events over DST. Add upgrade script. NOTE:

only needed on postgresql since Oracle doesn't store timezones.

  1. … 1 more file in changeset.
file upgrade-0.6d1-0.6d2.sql was initially added on branch oacs-5-3.

    • -0
    • +0
    ./upgrade-0.6d1-0.6d2.sql
First shot at merging oacs-5-2 apps used in .LRN to HEAD.

  1. … 2478 more files in changeset.
fixing typos -- missing semicolons

fix the bkwd compat acs_event__new function resolves bug 2383

  1. … 1 more file in changeset.
propigate package_id to acs_objects, make __new a 14 param function and add backwards compatible version, bump package version, upgrades for oracle and pg, oracle untested

    • -0
    • +161
    ./upgrade-0.5d2-0.5d3.sql
  1. … 4 more files in changeset.
make functions create or replace. fix inputs to a get_status_summary and get_html_p, bump version, upgrade

    • -0
    • +57
    ./upgrade-0.5d1-0.5d2.sql
  1. … 2 more files in changeset.
Remerge Timo's changes for tip 42,43, cf tip 53

  1. … 97 more files in changeset.
rollback of Timo's name, package_id commit; see TIP 53

  1. … 96 more files in changeset.