• last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
fixing typos -- missing semicolons

fixing typos -- missing semicolons in acs_event__get_html_p and acs_event__get_status_summary

Initual attempt at correct daylight savings time handling. When calculating

intervals for copy, recurring events treat dates in calculations as timestamp

without timezone.

    • -207
    • +208
    ./postgresql/timespan-create.sql
typo fix, add a missing comma

    • -1
    • +1
    ./oracle/upgrade/upgrade-0.5d2-0.5d3.sql
Rearranging definition order to fix compilation bugs. Now the all of the package definitions come first, the bodies second.

    • -388
    • +387
    ./oracle/upgrade/upgrade-0.3d-0.4d.sql
  1. … 1 more file in changeset.
Rearranging definition order to fix compilation bugs. Now the all of the package definitions come first, the bodies second.

    • -388
    • +387
    ./oracle/upgrade/upgrade-0.3d-0.4d.sql
  1. … 1 more file in changeset.
fix pacakge -> package typo

    • -1
    • +1
    ./oracle/upgrade/upgrade-0.5d2-0.5d3.sql
  1. … 9 more files in changeset.
fix the bkwd compat acs_event__new function resolves bug 2383

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
    • +737
    ./oracle/upgrade/upgrade-0.5d2-0.5d3.sql
    • -0
    • +161
    ./postgresql/upgrade/upgrade-0.5d2-0.5d3.sql
  1. … 1 more file in changeset.
make functions create or replace. fix inputs to a get_status_summary and get_html_p, bump version, upgrade

    • -26
    • +26
    ./postgresql/acs-events-create.sql
    • -0
    • +57
    ./postgresql/upgrade/upgrade-0.5d1-0.5d2.sql
  1. … 1 more file in changeset.
Remerge Timo's changes for tip 42,43, cf tip 53

    • -0
    • +631
    ./oracle/upgrade/upgrade-0.4d-0.4d1.sql
  1. … 92 more files in changeset.
rollback of Timo's name, package_id commit; see TIP 53

    • -631
    • +0
    ./oracle/upgrade/upgrade-0.4d-0.4d1.sql
  1. … 91 more files in changeset.
TIP#42,43: adding package_id and title to acs_objects table

    • -0
    • +631
    ./oracle/upgrade/upgrade-0.4d-0.4d1.sql
    • -0
    • +204
    ./postgresql/upgrade/upgrade-0.4d-0.4d1.sql
  1. … 91 more files in changeset.
fixing bug 957: adding recurring events broken in PG. Adding ::INT casts to arguments of add_months() and to_interval() calls

Added upgrade to upgrade to changes made for Oracle 9i support

    • -0
    • +1732
    ./oracle/upgrade/upgrade-0.3d-0.4d.sql
  1. … 23 more files in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

  1. … 270 more files in changeset.
added upgrade script for index creation on start_date (see bug #634)

    • -0
    • +1
    ./oracle/upgrade/upgrade-0.2d-0.3d.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-0.2d-0.3d.sql
1. removed some errant log statemets previously inserted when debugging

2. sql/common/*sql files weren't being displayed by the APM, are now

3. added index on start_date in timespan-create after user reported

very slow calendar queries in .LRN

  1. … 6 more files in changeset.
merge of 4.6.3b1 to HEAD

    • -14
    • +14
    ./postgresql/acs-events-create.sql
    • -25
    • +25
    ./postgresql/timespan-create.sql
    • -44
    • +44
    ./postgresql/test/acs-events-test.sql
    • -51
    • +51
    ./postgresql/test/time_intervals-test.sql
    • -19
    • +19
    ./postgresql/test/timespan-test.sql
  1. … 33 more files in changeset.
I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

    • -44
    • +44
    ./postgresql/test/acs-events-test.sql
    • -51
    • +51
    ./postgresql/test/time_intervals-test.sql
    • -19
    • +19
    ./postgresql/test/timespan-test.sql
  1. … 50 more files in changeset.
Partial conversion from timestamp to timestamptz for PG 7.3 (need to keep

time zone timestamps so dumps from PG 7.2 installs will still work)

    • -14
    • +14
    ./postgresql/acs-events-create.sql
    • -25
    • +25
    ./postgresql/timespan-create.sql
  1. … 13 more files in changeset.
merge bartt PG 7.3 fixes from HEAD

    • -2
    • +2
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
  1. … 51 more files in changeset.
Patches to make OpenACS PG 7.3 compatible.

    • -2
    • +2
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
  1. … 51 more files in changeset.
merge from oacs-4-6

    • -15
    • +9
    ./oracle/upgrade/upgrade-0.1d-0.2d.sql
    • -0
    • +31
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
  1. … 109 more files in changeset.
- Upgrade scripts for acs-content-repository, acs-events, acs-kernel, acs-mail, acs-service-contract, bookmarks, faq, file-storage, news and search

- Bumped version of above packages to 4.6

- Fixed the view/sequence hack in apm-create so that APM package edit UI works in PG 7.2

    • -15
    • +9
    ./oracle/upgrade/upgrade-0.1d-0.2d.sql
    • -3
    • +32
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
  1. … 29 more files in changeset.
- Converted inneficient query to INNER JOINs.

- Added Oracle upgrade script.

    • -0
    • +740
    ./oracle/upgrade/upgrade-0.1d-0.2d.sql
    • -11
    • +18
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
adding upgrade file for acs_event__recurrence_timespan_edit fuction fix

    • -0
    • +47
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
fix acs_event__recurrence_timespan_edit thanks to deds@infiniteinfo.com

    • -12
    • +24
    ./postgresql/acs-events-create.sql
fixed calendar for PG

  1. … 10 more files in changeset.
added support for editing time intervals