OpenACS / openacs-4 / packages / acs-kernel

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 44
Last Commit: 03 Apr
Commits this week: 0
Total Lines of Code (LoC): 85,961
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Dec 2024
9:51 am

antoniop

Fix possible typo

See https://openacs.org/forums/message-view?message_id=7236544

Options
    • -2
    • +2
    ./oracle/groups-body-create.sql
Wednesday 11 Sep 2024
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./oracle/acs-objects-create.sql
    • -0
    • +0
    ./oracle/acs-permissions-create.sql
    • -0
    • +0
    ./oracle/acs-relationships-create.sql
    • -0
    • +0
    ./oracle/apm-create.sql
    • -0
    • +0
    ./oracle/community-core-create.sql
    • -0
    • +0
    ./oracle/groups-body-create.sql
    • -0
    • +0
    ./oracle/groups-create.sql
    • -0
    • +0
    ./oracle/rel-constraints-create.sql
    • -0
    • +0
    ./oracle/site-nodes-create.sql
    • -0
    • +0
    ./oracle/upgrade/upgrade-4.0.1-4.1b.sql
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.0d2-5.0d3.sql
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.0d9-5.0d13.sql
    • -0
    • +0
    ./postgresql/acs-objects-create.sql
    • -0
    • +0
    ./postgresql/acs-objects-drop.sql
    • -0
    • +0
    ./postgresql/acs-permissions-create.sql
  16. … 1450 more files in changeset.
Tuesday 03 Sep 2024
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -2
    • +2
    ./oracle/acs-create.sql
    • -2
    • +10
    ./oracle/acs-objects-create.sql
    • -2
    • +2
    ./oracle/acs-permissions-create.sql
    • -6
    • +10
    ./oracle/acs-relationships-create.sql
    • -3
    • +19
    ./oracle/apm-create.sql
    • -28
    • +4
    ./oracle/community-core-create.sql
    • -4
    • +15
    ./oracle/groups-body-create.sql
    • -6
    • +11
    ./oracle/groups-create.sql
    • -3
    • +3
    ./oracle/rel-constraints-create.sql
    • -2
    • +11
    ./oracle/site-nodes-create.sql
    • -197
    • +150
    ./oracle/utilities-create.sql
    • -4
    • +6
    ./oracle/upgrade/upgrade--5.9.1d15-5.9.1d16.sql
    • -7
    • +7
    ./oracle/upgrade/upgrade-4.0.1-4.1b.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-4.1.1-4.2.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.2.1-4.2.2.sql
  16. … 8085 more files in changeset.
Tuesday 20 Aug 2024
3:38 pm

gustafn

More function_args cleanup

- removed one more definition referring to a deleted function

- make sure we always get argument names via PostgreSQL

- aligned argument names with stubs (apm__set_value and apm__get_value)

- bumped version number to 5.10.1b7

Options
    • -197
    • +150
    ./oracle/utilities-create.sql
    • -4
    • +6
    ./oracle/upgrade/upgrade--5.9.1d15-5.9.1d16.sql
    • -7
    • +7
    ./oracle/upgrade/upgrade-4.0.1-4.1b.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-4.1.1-4.2.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.2.1-4.2.2.sql
  • … 8085 more files in changeset.
    • Tuesday 20 Aug 2024
    3:38 pm

    gustafn

    More function_args cleanup

    - removed one more definition referring to a deleted function

    - make sure we always get argument names via PostgreSQL

    - aligned argument names with stubs (apm__set_value and apm__get_value)

    - bumped version number to 5.10.1b7

    Options
      • -8
      • +1
      ./postgresql/acs-objects-create.sql
      • -505
      • +500
      ./postgresql/apm-create.sql
      • -3
      • +3
      ./postgresql/utilities-create.sql
      • -0
      • +12
      ./postgresql/upgrade/upgrade-5.10.1b6-5.10.1b7.sql
    5. … 1 more file in changeset.
    3:38 pm

    gustafn

    file upgrade-5.10.1b6-5.10.1b7.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1b6-5.10.1b7.sql
    Tuesday 13 Aug 2024
    9:52 am

    gustafn

    Various fixes for "function_args"

    - The default value for "authority_id" in acs_user__new was missing.

    - Removed leftovers from earlier changes in the SQL API. The update

    scripts did not care about function args, so orphaned entries could

    cause confusions.

    - The drop-package SQL function did not care about deleting entries on

    the function args table. The function args deleted here are created

    automatically by the Tcl proc "package_generate_body".

    - bumped verison of acs-kernel to 5.10.1b6

    Options
      • -8
      • +2
      ./postgresql/community-core-create.sql
      • -0
      • +2
      ./postgresql/postgresql.sql
      • -0
      • +54
      ./postgresql/upgrade/upgrade-5.10.1b5-5.10.1b6.sql
    4. … 1 more file in changeset.
    9:52 am

    gustafn

    file upgrade-5.10.1b5-5.10.1b6.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1b5-5.10.1b6.sql
    .org/avatar/j_doe?s=48); padding-left:52px; padding-bottom:16.0px; padding-left: 0' href="/committer/OpenACS/gustafn" title="">

    gustafn

    Various fixes for "function_args"

    - The default value for "authority_id" in acs_user__new was missing.

    - Removed leftovers from earlier changes in the SQL API. The update

    scripts did not care about function args, so orphaned entries could

    cause confusions.

    - The drop-package SQL function did not care about deleting entries on

    the function args table. The function args deleted here are created

    automatically by the Tcl proc "package_generate_body".

    - bumped verison of acs-kernel to 5.10.1b6

    Options
      • -8
      • +2
      ./postgresql/community-core-create.sql
      • -0
      • +2
      ./postgresql/postgresql.sql
      • -0
      • +54
      ./postgresql/upgrade/upgrade-5.10.1b5-5.10.1b6.sql
    4. … 1 more file in changeset.
    9:52 am

    gustafn

    file upgrade-5.10.1b5-5.10.1b6.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1b5-5.10.1b6.sql
    Tuesday 23 Apr 2024
    2:19 pm

    gustafn

    Fixed issue introduced in OpenACS 5.9.0

    The old version did not insert a property value via the

    sec_session_property__upsert() in PostgreSQL on the initial setting

    (later updates were OK). The broken version was just adding a tuple

    and left the "property_value" empty.

    Many thanks to Jonathan Kelley for identifying the issue and reporting it.

    Options
      • -16
      • +16
      ./postgresql/security-create.sql
      • -0
      • +37
      ./postgresql/upgrade/upgrade-5.10.1b4-5.10.1b5.sql
    3. … 1 more file in changeset.
    2:19 pm

    gustafn

    file upgrade-5.10.1b4-5.10.1b5.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1b4-5.10.1b5.sql
    Friday 02 Feb 2024
    1:50 pm
    2:19 pm

    gustafn

    Fixed issue introduced in OpenACS 5.9.0

    The old version did not insert a property value via the

    sec_session_property__upsert() in PostgreSQL on the initial setting

    (later updates were OK). The broken version was just adding a tuple

    and left the "property_value" empty.

    Many thanks to Jonathan Kelley for identifying the issue and reporting it.

    Options
      • -16
      • +16
      ./postgresql/security-create.sql
      • -0
      • +37
      ./postgresql/upgrade/upgrade-5.10.1b4-5.10.1b5.sql
    3. … 1 more file in changeset.
    2:19 pm

    gustafn

    file upgrade-5.10.1b4-5.10.1b5.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1b4-5.10.1b5.sql
    Friday 02 Feb 2024
    1:50 pm

    gustafn

    Silence potentially confusing warning during first installation

    Options
      • -5
      • +5
      ./postgresql/acs-permissions-create.sql
      • -2
      • +2
      ./postgresql/groups-body-create.sql
      • -2
      • +2
      ./postgresql/site-nodes-create.sql
    Monday 04 Dec 2023
    4:32 pm

    gustafn

    Small update for cluster support

    - Improved visualization of cluster nodes that we lost contact to

    - New kernel parameters to reduce hard-coded values and to make purpose more explicit

    * new parameter ClusterHeartbeatInterval (default 20s),

    was hardcoded before to the new default value

    * renamed PreferredLocationRegexp -> ClusterPreferredLocationRegexp

    * renamed EnableLoggingP -> ClusterEnableLoggingP

    - Bumped version numbers:

    * acs-kernel to 5.10.1b3

    * acs-tcl to 5.10.1b2

    * acs-admin to 5.10.1b2

    acs-kernel acs-admin acs-tcl/

    Options
      • -0
      • +24
      ./oracle/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
      Silence potentially confusing warning during first installation

    Options
      • -5
      • +5
      ./postgresql/acs-permissions-create.sql
      • -2
      • +2
      ./postgresql/groups-body-create.sql
      • -2
      • +2
      ./postgresql/site-nodes-create.sql
    Monday 04 Dec 2023
    4:32 pm

    gustafn

    Small update for cluster support

    - Improved visualization of cluster nodes that we lost contact to

    - New kernel parameters to reduce hard-coded values and to make purpose more explicit

    * new parameter ClusterHeartbeatInterval (default 20s),

    was hardcoded before to the new default value

    * renamed PreferredLocationRegexp -> ClusterPreferredLocationRegexp

    * renamed EnableLoggingP -> ClusterEnableLoggingP

    - Bumped version numbers:

    * acs-kernel to 5.10.1b3

    * acs-tcl to 5.10.1b2

    * acs-admin to 5.10.1b2

    acs-kernel acs-admin acs-tcl/

    Options
      • -0
      • +24
      ./oracle/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
      • -0
      • +24
      ./postgresql/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
    3. … 6 more files in changeset.
    4:32 pm

    gustafn

    file upgrade-5.10.1b2-5.10.1b3.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./oracle/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
    Tuesday 29 Aug 2023
    4:10 pm

    gustafn

    fixed typo

    Options
      • -2
      • +2
      ./oracle/acs-permissions-create.sql
      • -0
      • +24
      ./postgresql/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
    3. … 6 more files in changeset.
    4:32 pm

    gustafn

    file upgrade-5.10.1b2-5.10.1b3.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./oracle/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
    Tuesday 29 Aug 2023
    4:10 pm

    gustafn

    fixed typo

    Options
      • -2
      • +2
      ./oracle/acs-permissions-create.sql
      • -2
      • +2
      ./postgresql/acs-permissions-create.sql
      • -3
      • +3
      ./postgresql/rel-constraints-body-create.sql
    4. … 2 more files in changeset.
    Monday 10 Jul 2023
    11:29 am

    gustafn

    file upgrade-5.10.1d10-5.18.1d19.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./oracle/upgrade/upgrade-5.10.1d10-5.18.1d19.sql
    11:29 am

    gustafn

    file upgrade-5.10.1d18-5.10.1d19.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d18-5.10.1d19.sql
      • -2
      • +2
      ./postgresql/acs-permissions-create.sql
      • -3
      • +3
      ./postgresql/rel-constraints-body-create.sql
    4. … 2 more files in changeset.
    Monday 10 Jul 2023
    11:29 am

    gustafn

    file upgrade-5.10.1d10-5.18.1d19.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./oracle/upgrade/upgrade-5.10.1d10-5.18.1d19.sql
    11:29 am

    gustafn

    file upgrade-5.10.1d18-5.10.1d19.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d18-5.10.1d19.sql
    11:29 am

    gustafn

    made names of SQL functions explicit to ease calling directly from the Tcl level

    Options
      • -2
      • +18
      ./oracle/apm-create.sql
      • -0
      • +680
      ./oracle/upgrade/upgrade-5.10.1d10-5.18.1d19.sql
      • -5
      • +17
      ./postgresql/apm-create.sql
      • -0
      • +53
      ./postgresql/upgrade/upgrade-5.10.1d18-5.10.1d19.sql
    5. … 1 more file in changeset.
    Tuesday 28 Mar 2023
    1:20 pm

    antoniop

    History
  • Source
    • 11:29 am

    gustafn

    made names of SQL functions explicit to ease calling directly from the Tcl level

    Options
      • -2
      • +18
      ./oracle/apm-create.sql
      • -0
      • +680
      ./oracle/upgrade/upgrade-5.10.1d10-5.18.1d19.sql
      • -5
      • +17
      ./postgresql/apm-create.sql
      • -0
      • +53
      ./postgresql/upgrade/upgrade-5.10.1d18-5.10.1d19.sql
    5. … 1 more file in changeset.
    Tuesday 28 Mar 2023
    1:20 pm

    antoniop

    Remove no_alarms_until column

    Rationale: the column or the related api is never used in upstream code to check whether notifications should be sent or not or not. The UI to manage the column's value was not linked anywhere. On the instances accessible by me downstream, no tuple was found where this column had a value.

    Options
      • -2
      • +2
      ./oracle/acs-create.sql
      • -27
      • +1
      ./oracle/community-core-create.sql
      • -0
      • +200
      ./oracle/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
      • -37
      • +1
      ./postgresql/community-core-create.sql
      • -0
      • +49
      ./postgresql/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
    6. … 14 more files in changeset.
    1:20 pm

    antoniop

    file upgrade-5.10.1d17-5.10.1d18.sql was initially added on branch oacs-5-10.

    Options
    Options
      • -2
      • +2
      ./oracle/acs-create.sql
      • -27
      • +1
      ./oracle/community-core-create.sql
      • -0
      • +200
      ./oracle/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
      • -37
      • +1
      ./postgresql/community-core-create.sql
      • -0
      • +49
      ./postgresql/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
    6. … 14 more files in changeset.
    1:20 pm

    antoniop

    file upgrade-5.10.1d17-5.10.1d18.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./oracle/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
    Friday 10 Feb 2023
    8:07 pm

    gernst

    Added proc "membership_rel::expire" so that all membership states are now covered. Note: The Oracle part is best effort only!

    Options
      • -1
      • +11
      ./oracle/groups-body-create.sql
    2. Diff
    • -4
    • +15
    ./oracle/groups-body-create.sql
    • -6
    • +11
    ./oracle/groups-create.sql
    • -3
    • +3
    ./oracle/rel-constraints-create.sql
    • -2
    • +11
    ./oracle/site-nodes-create.sql
    • -197
    • +150
    ./oracle/utilities-create.sql
    • -4
    • +6
    ./oracle/upgrade/upgrade--5.9.1d15-5.9.1d16.sql
    • -7
    • +7
    ./oracle/upgrade/upgrade-4.0.1-4.1b.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-4.1.1-4.2.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.2.1-4.2.2.sql
  • … 8085 more files in changeset.
    • Tuesday 20 Aug 2024
    3:38 pm

    gustafn

    More function_args cleanup

    - removed one more definition referring to a deleted function

    - make sure we always get argument names via PostgreSQL

    - aligned argument names with stubs (apm__set_value and apm__get_value)

    - bumped version number to 5.10.1b7

    Options
    • -197
    • +150
    ./oracle/utilities-create.sql
    • -4
    • +6
    ./oracle/upgrade/upgrade--5.9.1d15-5.9.1d16.sql
    • -7
    • +7
    ./oracle/upgrade/upgrade-4.0.1-4.1b.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-4.1.1-4.2.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.2.1-4.2.2.sql
  • … 8085 more files in changeset.
    • Tuesday 20 Aug 2024
    3:38 pm

    gustafn

    More function_args cleanup

    - removed one more definition referring to a deleted function

    - make sure we always get argument names via PostgreSQL

    - aligned argument names with stubs (apm__set_value and apm__get_value)

    - bumped version number to 5.10.1b7

    Options
      • -8
      • +1
      ./postgresql/acs-objects-create.sql
      • -505
      • +500
      ./postgresql/apm-create.sql
      • -3
      • +3
      ./postgresql/utilities-create.sql
      • -0
      • +12
      ./postgresql/upgrade/upgrade-5.10.1b6-5.10.1b7.sql
    5. … 1 more file in changeset.
    3:38 pm

    gustafn

    file upgrade-5.10.1b6-5.10.1b7.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1b6-5.10.1b7.sql
    Tuesday 13 Aug 2024
    9:52 am

    gustafn

    Various fixes for "function_args"

    - The default value for "authority_id" in acs_user__new was missing.

    - Removed leftovers from earlier changes in the SQL API. The update

    scripts did not care about function args, so orphaned entries could

    cause confusions.

    - The drop-package SQL function did not care about deleting entries on

    the function args table. The function args deleted here are created

    automatically by the Tcl proc "package_generate_body".

    - bumped verison of acs-kernel to 5.10.1b6

    Options
      • -8
      • +2
      ./postgresql/community-core-create.sql
      • -0
      • +2
      ./postgresql/postgresql.sql
      • -0
      • +54
      ./postgresql/upgrade/upgrade-5.10.1b5-5.10.1b6.sql
    4. … 1 more file in changeset.
    9:52 am

    gustafn

    file upgrade-5.10.1b5-5.10.1b6.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1b5-5.10.1b6.sql
    .org/avatar/j_doe?s=48); padding-left:52px; padding-bottom:16.0px; padding-left: 0' href="/committer/OpenACS/gustafn" title="">

    gustafn

    Various fixes for "function_args"

    - The default value for "authority_id" in acs_user__new was missing.

    - Removed leftovers from earlier changes in the SQL API. The update

    scripts did not care about function args, so orphaned entries could

    cause confusions.

    - The drop-package SQL function did not care about deleting entries on

    the function args table. The function args deleted here are created

    automatically by the Tcl proc "package_generate_body".

    - bumped verison of acs-kernel to 5.10.1b6

    Options
      • -8
      • +2
      ./postgresql/community-core-create.sql
      • -0
      • +2
      ./postgresql/postgresql.sql
      • -0
      • +54
      ./postgresql/upgrade/upgrade-5.10.1b5-5.10.1b6.sql
    4. … 1 more file in changeset.
    9:52 am

    gustafn

    file upgrade-5.10.1b5-5.10.1b6.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1b5-5.10.1b6.sql
    Tuesday 23 Apr 2024
    2:19 pm

    gustafn

    Fixed issue introduced in OpenACS 5.9.0

    The old version did not insert a property value via the

    sec_session_property__upsert() in PostgreSQL on the initial setting

    (later updates were OK). The broken version was just adding a tuple

    and left the "property_value" empty.

    Many thanks to Jonathan Kelley for identifying the issue and reporting it.

    Options
      • -16
      • +16
      ./postgresql/security-create.sql
      • -0
      • +37
      ./postgresql/upgrade/upgrade-5.10.1b4-5.10.1b5.sql
    3. … 1 more file in changeset.
    2:19 pm

    gustafn

    file upgrade-5.10.1b4-5.10.1b5.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1b4-5.10.1b5.sql
    Friday 02 Feb 2024
    1:50 pm
    2:19 pm

    gustafn

    Fixed issue introduced in OpenACS 5.9.0

    The old version did not insert a property value via the

    sec_session_property__upsert() in PostgreSQL on the initial setting

    (later updates were OK). The broken version was just adding a tuple

    and left the "property_value" empty.

    Many thanks to Jonathan Kelley for identifying the issue and reporting it.

    Options
      • -16
      • +16
      ./postgresql/security-create.sql
      • -0
      • +37
      ./postgresql/upgrade/upgrade-5.10.1b4-5.10.1b5.sql
    3. … 1 more file in changeset.
    2:19 pm

    gustafn

    file upgrade-5.10.1b4-5.10.1b5.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1b4-5.10.1b5.sql
    Friday 02 Feb 2024
    1:50 pm

    gustafn

    Silence potentially confusing warning during first installation

    Options
      • -5
      • +5
      ./postgresql/acs-permissions-create.sql
      • -2
      • +2
      ./postgresql/groups-body-create.sql
      • -2
      • +2
      ./postgresql/site-nodes-create.sql
    Monday 04 Dec 2023
    4:32 pm

    gustafn

    Small update for cluster support

    - Improved visualization of cluster nodes that we lost contact to

    - New kernel parameters to reduce hard-coded values and to make purpose more explicit

    * new parameter ClusterHeartbeatInterval (default 20s),

    was hardcoded before to the new default value

    * renamed PreferredLocationRegexp -> ClusterPreferredLocationRegexp

    * renamed EnableLoggingP -> ClusterEnableLoggingP

    - Bumped version numbers:

    * acs-kernel to 5.10.1b3

    * acs-tcl to 5.10.1b2

    * acs-admin to 5.10.1b2

    acs-kernel acs-admin acs-tcl/

    Options
      • -0
      • +24
      ./oracle/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
      Silence potentially confusing warning during first installation

    Options
      • -5
      • +5
      ./postgresql/acs-permissions-create.sql
      • -2
      • +2
      ./postgresql/groups-body-create.sql
      • -2
      • +2
      ./postgresql/site-nodes-create.sql
    Monday 04 Dec 2023
    4:32 pm

    gustafn

    Small update for cluster support

    - Improved visualization of cluster nodes that we lost contact to

    - New kernel parameters to reduce hard-coded values and to make purpose more explicit

    * new parameter ClusterHeartbeatInterval (default 20s),

    was hardcoded before to the new default value

    * renamed PreferredLocationRegexp -> ClusterPreferredLocationRegexp

    * renamed EnableLoggingP -> ClusterEnableLoggingP

    - Bumped version numbers:

    * acs-kernel to 5.10.1b3

    * acs-tcl to 5.10.1b2

    * acs-admin to 5.10.1b2

    acs-kernel acs-admin acs-tcl/

    Options
      • -0
      • +24
      ./oracle/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
      • -0
      • +24
      ./postgresql/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
    3. … 6 more files in changeset.
    4:32 pm

    gustafn

    file upgrade-5.10.1b2-5.10.1b3.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./oracle/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
    Tuesday 29 Aug 2023
    4:10 pm

    gustafn

    fixed typo

    Options
      • -2
      • +2
      ./oracle/acs-permissions-create.sql
      • -0
      • +24
      ./postgresql/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
    3. … 6 more files in changeset.
    4:32 pm

    gustafn

    file upgrade-5.10.1b2-5.10.1b3.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./oracle/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1b2-5.10.1b3.sql
    Tuesday 29 Aug 2023
    4:10 pm

    gustafn

    fixed typo

    Options
      • -2
      • +2
      ./oracle/acs-permissions-create.sql
      • -2
      • +2
      ./postgresql/acs-permissions-create.sql
      • -3
      • +3
      ./postgresql/rel-constraints-body-create.sql
    4. … 2 more files in changeset.
    Monday 10 Jul 2023
    11:29 am

    gustafn

    file upgrade-5.10.1d10-5.18.1d19.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./oracle/upgrade/upgrade-5.10.1d10-5.18.1d19.sql
    11:29 am

    gustafn

    file upgrade-5.10.1d18-5.10.1d19.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d18-5.10.1d19.sql
      • -2
      • +2
      ./postgresql/acs-permissions-create.sql
      • -3
      • +3
      ./postgresql/rel-constraints-body-create.sql
    4. … 2 more files in changeset.
    Monday 10 Jul 2023
    11:29 am

    gustafn

    file upgrade-5.10.1d10-5.18.1d19.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./oracle/upgrade/upgrade-5.10.1d10-5.18.1d19.sql
    11:29 am

    gustafn

    file upgrade-5.10.1d18-5.10.1d19.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d18-5.10.1d19.sql
    11:29 am

    gustafn

    made names of SQL functions explicit to ease calling directly from the Tcl level

    Options
      • -2
      • +18
      ./oracle/apm-create.sql
      • -0
      • +680
      ./oracle/upgrade/upgrade-5.10.1d10-5.18.1d19.sql
      • -5
      • +17
      ./postgresql/apm-create.sql
      • -0
      • +53
      ./postgresql/upgrade/upgrade-5.10.1d18-5.10.1d19.sql
    5. … 1 more file in changeset.
    Tuesday 28 Mar 2023
    1:20 pm

    antoniop

    History
  • Source
    • 11:29 am

    gustafn

    made names of SQL functions explicit to ease calling directly from the Tcl level

    Options
      • -2
      • +18
      ./oracle/apm-create.sql
      • -0
      • +680
      ./oracle/upgrade/upgrade-5.10.1d10-5.18.1d19.sql
      • -5
      • +17
      ./postgresql/apm-create.sql
      • -0
      • +53
      ./postgresql/upgrade/upgrade-5.10.1d18-5.10.1d19.sql
    5. … 1 more file in changeset.
    Tuesday 28 Mar 2023
    1:20 pm

    antoniop

    Remove no_alarms_until column

    Rationale: the column or the related api is never used in upstream code to check whether notifications should be sent or not or not. The UI to manage the column's value was not linked anywhere. On the instances accessible by me downstream, no tuple was found where this column had a value.

    Options
      • -2
      • +2
      ./oracle/acs-create.sql
      • -27
      • +1
      ./oracle/community-core-create.sql
      • -0
      • +200
      ./oracle/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
      • -37
      • +1
      ./postgresql/community-core-create.sql
      • -0
      • +49
      ./postgresql/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
    6. … 14 more files in changeset.
    1:20 pm

    antoniop

    file upgrade-5.10.1d17-5.10.1d18.sql was initially added on branch oacs-5-10.

    Options
    Options
      • -2
      • +2
      ./oracle/acs-create.sql
      • -27
      • +1
      ./oracle/community-core-create.sql
      • -0
      • +200
      ./oracle/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
      • -37
      • +1
      ./postgresql/community-core-create.sql
      • -0
      • +49
      ./postgresql/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
    6. … 14 more files in changeset.
    1:20 pm

    antoniop

    file upgrade-5.10.1d17-5.10.1d18.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./oracle/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
    Friday 10 Feb 2023
    8:07 pm

    gernst

    Added proc "membership_rel::expire" so that all membership states are now covered. Note: The Oracle part is best effort only!

    Options
      • -1
      • +11
      ./oracle/groups-body-create.sql
      • -1
      • +5
      ./oracle/groups-create.sql
      • -0
      • +249
      ./oracle/upgrade/upgrade-5.10.1d16-5.10.1d17.sql
      • -1
      • +25
      ./postgresql/groups-body-create.sql
      • -0
      • +0
       ./oracle/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d17-5.10.1d18.sql
    Friday 10 Feb 2023
    8:07 pm

    gernst

    Added proc "membership_rel::expire" so that all membership states are now covered. Note: The Oracle part is best effort only!

    Options
      • -1
      • +11
      ./oracle/groups-body-create.sql
      • -1
      • +5
      ./oracle/groups-create.sql
      • -0
      • +249
      ./oracle/upgrade/upgrade-5.10.1d16-5.10.1d17.sql
      • -1
      • +25
      ./postgresql/groups-body-create.sql
      • -0
      • +22
      ./postgresql/upgrade/upgrade-5.10.1d16-5.10.1d17.sql
    6. … 6 more files in changeset.
    8:07 pm

    gernst

    file upgrade-5.10.1d16-5.10.1d17.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./oracle/upgrade/upgrade-5.10.1d16-5.10.1d17.sql
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d16-5.10.1d17.sql
    Thursday 01 Dec 2022
    5:39 pm

    gustafn

    new partial index for a common query

    ... checking for "approved" members

    Options
      • -1
      • +7
      ./postgresql/groups-create.sql
      • -0
      • +22
      ./postgresql/upgrade/upgrade-5.10.1d16-5.10.1d17.sql
    3. … 6 more files in changeset.
    8:07 pm

    gernst

    file upgrade-5.10.1d16-5.10.1d17.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./oracle/upgrade/upgrade-5.10.1d16-5.10.1d17.sql
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d16-5.10.1d17.sql
    Thursday 01 Dec 2022
    5:39 pm

    gustafn

    new partial index for a common query

    ... checking for "approved" members

    Options
      • -1
      • +7
      ./postgresql/groups-create.sql
      • -0
      • +5
      ./postgresql/upgrade/upgrade-5.10.1d13-5.10.1d14.sql
    3. … 1 more file in changeset.
    5:39 pm

    gustafn

    file upgrade-5.10.1d13-5.10.1d14.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d13-5.10.1d14.sql
    Thursday 27 Oct 2022
    11:00 am

    gustafn

    make update script more robust in case the table acs_privilege_descendant_map was already dropped

    The old version worked on pg14, but as it looks, not on earlier pg versions.

    Options
      • -1
      • +22
      ./postgresql/upgrade/upgrade-5.10.1d11-5.10.1d12.sql
    Tuesday 11 Oct 2022
    11:17 am

    antoniop

    Cleanup leftover util user messages, that we won't persist anymore

    Options
      • -0
      • +6
      ./postgresql/upgrade/upgrade-5.10.1d12-5.10.1d13.sql
    2. … 1 more file in changeset.
    11:17 am

    antoniop

    file upgrade-5.10.1d12-5.10.1d13.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d12-5.10.1d13.sql
    Saturday 08 Oct 2022
    10:07 pm

    gustafn

    Cleanup of acs_object_context_index' and friends in creation scripts

    This change completes the commit [1] from 2019, where the cleanup was performed

    acs_object_context_index and its maintenance functions just as an update script.

    This change addresses this also in the creation scripts and in packages, still

    depending on the old functions.

    [1] https://fisheye.openacs.org/changelog/OpenACS?cs=oacs-5-10%3Ahectorr%3A20190708160122

    Tuesday 11 Oct 2022
    11:17 am

    antoniop

    Cleanup leftover util user messages, that we won't persist anymore

    Options
      • -0
      • +6
      ./postgresql/upgrade/upgrade-5.10.1d12-5.10.1d13.sql
    2. … 1 more file in changeset.
    11:17 am

    antoniop

    file upgrade-5.10.1d12-5.10.1d13.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d12-5.10.1d13.sql
    Saturday 08 Oct 2022
    10:07 pm

    gustafn

    Cleanup of acs_object_context_index' and friends in creation scripts

    This change completes the commit [1] from 2019, where the cleanup was performed

    acs_object_context_index and its maintenance functions just as an update script.

    This change addresses this also in the creation scripts and in packages, still

    depending on the old functions.

    [1] https://fisheye.openacs.org/changelog/OpenACS?cs=oacs-5-10%3Ahectorr%3A20190708160122

    Options
      • -308
      • +1
      ./postgresql/acs-objects-create.sql
      • -5
      • +1
      ./postgresql/acs-objects-drop.sql
      • -250
      • +42
      ./postgresql/acs-permissions-create.sql
      • -4
      • +4
      ./postgresql/acs-permissions-drop.sql
      • -0
      • +57
      ./postgresql/upgrade/upgrade-5.10.1d11-5.10.1d12.sql
    6. … 5 more files in changeset.
    10:07 pm

    gustafn

    file upgrade-5.10.1d11-5.10.1d12.sql was initially added on branch oacs-5-10.

    Options
      • -308
      • +1
      ./postgresql/acs-objects-create.sql
      • -5
      • +1
      ./postgresql/acs-objects-drop.sql
      • -250
      • +42
      ./postgresql/acs-permissions-create.sql
      • -4
      • +4
      ./postgresql/acs-permissions-drop.sql
      • -0
      • +57
      ./postgresql/upgrade/upgrade-5.10.1d11-5.10.1d12.sql
    6. … 5 more files in changeset.
    10:07 pm

    gustafn

    file upgrade-5.10.1d11-5.10.1d12.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d11-5.10.1d12.sql
    Saturday 30 Jul 2022
    2:00 pm

    gustafn

    file upgrade-5.10.1d9-5.10.1d10.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d9-5.10.1d10.sql
    2:00 pm

    gustafn

    Adjust legacy data types of acs_object_types.object_type and acs_objects.object_type

    This change addresses the problem mentioned in

    https://cvs.openacs.org/changelog/OpenACS?cs=oacs-5-10%3Agustafn%3A20220729185340

    https://github.com/openacs/openacs-core/commit/be44691f06627678122bd913bc3c95c80e93f403

    which happens in some legacy applications (such as

    e.g. openacs.org) where the data types of the following two

    attributes are different.

    acs_object_types.object_type

    acs_objects.object_type

    On new installations (at least concerning the last 10 years) these

    data types are the same. So, probably an update script was missing

    ages ago.

    Since this change affects the basic object structure, MANY views

    depend on this datatype and have to be dropped and recreate to

    allow the correction of the datatype.

    Therefore, we do not want to run this script on all sites, but

    only on those where it is necessary.

    Options
      • -0
      • +340
      ./postgresql/upgrade/upgrade-5.10.1d9-5.10.1d10.sql
    2. … 1 more file in changeset.
    Friday 22 Jul 2022
    on-loc-diff">
  • -0
  • +0
    • ./postgresql/upgrade/upgrade-5.10.1d11-5.10.1d12.sql
    Saturday 30 Jul 2022
    2:00 pm

    gustafn

    file upgrade-5.10.1d9-5.10.1d10.sql was initially added on branch oacs-5-10.

    Options
      • -0
      • +0
      ./postgresql/upgrade/upgrade-5.10.1d9-5.10.1d10.sql
    2:00 pm

    gustafn

    Adjust legacy data types of acs_object_types.object_type and acs_objects.object_type

    This change addresses the problem mentioned in

    https://cvs.openacs.org/changelog/OpenACS?cs=oacs-5-10%3Agustafn%3A20220729185340

    https://github.com/openacs/openacs-core/commit/be44691f06627678122bd913bc3c95c80e93f403

    which happens in some legacy applications (such as

    e.g. openacs.org) where the data types of the following two

    attributes are different.

    acs_object_types.object_type

    acs_objects.object_type

    On new installations (at least concerning the last 10 years) these

    data types are the same. So, probably an update script was missing

    ages ago.

    Since this change affects the basic object structure, MANY views

    depend on this datatype and have to be dropped and recreate to

    allow the correction of the datatype.

    Therefore, we do not want to run this script on all sites, but

    only on those where it is necessary.

    Options
      • -0
      • +340
      ./postgresql/upgrade/upgrade-5.10.1d9-5.10.1d10.sql
    2. … 1 more file in changeset.
    Friday 22 Jul 2022
    7:37 pm

    gustafn

    Added membership "expired" to membership states. "expired" can be

    used for "dormant" accounts, which are neither "banned" nor "deleted".

    Options
      • -2
      • +2
      ./oracle/groups-create.sql
      • -0
      • +9
      ./oracle/upgrade/upgrade-5.10.1d8-5.10.1d9.sql
      • -2
      • +2
      ./postgresql/groups-create.sql
      • -0
      • +9
      ./postgresql/upgrade/upgrade-5.10.1d8-5.10.1d9.sql
    5. … 1 more file in changeset.
     
    FECRU.ACTIVITY.onScrollToBottom(function() { if(moreActivityToLoad) { loadMoreActivity(); } }); });