Activity OpenACS/openacs-4/packages/acs-kernel/sql/postgresql/upgrade

Tree
Accordion

Stats

Commits this week: 0

Total Committers:	26
Last Commit:	05 Apr
Commits this week:	0
Total Lines of Code (LoC):	12,722
Net change in LoC this week:	0

Commit Activity

last updated 3 hours ago

Constraints

Constraints: committers

Committer:

Log Comment:

Constraints: files

File Extension:

File Name:

Constraints: dates

Start Date:

End Date:

Thursday 04 Apr 2019

1:01 pm

gustafn

More
MAIN:gustafn:20190404110153
deleted 1 file
MAIN

file upgrade-5.10.0d14-5.10.0d15.sql was initially added on branch oacs-5-10.

- -0
- +0
./upgrade-5.10.0d14-5.10.0d15.sql
- History
- Source
./upgrade-5.10.0d14-5.10.0d15.sql

1:01 pm

gustafn

Modernize SQL existence test: make these more readable and faster

- -0
- +92
./upgrade-5.10.0d14-5.10.0d15.sql
- History
- Source
- Diff
./upgrade-5.10.0d14-5.10.0d15.sql
… 2 more files in changeset.

Thursday 21 Mar 2019

4:04 pm

antoniop

Reparent portraits coming from the old good days, which were saved with -100 as parent_id (since at least 6 years portraits are saved as children of the user object)

- -0
- +27
./upgrade-5.10.0d13-5.10.0d14.sql
- History
- Source
- Diff
./upgrade-5.10.0d13-5.10.0d14.sql
… 2 more files in changeset.

4:04 pm

antoniop

More
MAIN:antoniop:20190321150418
deleted 2 files
MAIN

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

- -0
- +0
./upgrade-5.10.0d13-5.10.0d14.sql
- History
- Source
./upgrade-5.10.0d13-5.10.0d14.sql
… 1 more file in changeset.

Monday 25 Feb 2019

1:29 pm

gustafn

site nodes reform part 2: change from tree_sortkeys to recursive queries

-- This upgrade script completes the commits "change queries on

-- site-node tree from tree_sortkey to recursive queries" from Oct 21,

-- 2018, 4 months ago. This upgrade has the purpose to drop the now

-- obsolete triggers and indices.

-- Delaying the 2nd part had the purpose to make upgrades more smooth,

-- at least for upgrades via .apm files. Without site nodes working,

-- users cannot navigate on their server unless it is restarted.

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181021173623

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181021175135

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181022074137

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181022085126

-- http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20181022081230

- -0
- +31
./upgrade-5.10.0d12-5.10.0d13.sql
- History
- Source
- Diff
./upgrade-5.10.0d12-5.10.0d13.sql
… 2 more files in changeset.

Saturday 23 Feb 2019

2:03 pm

gustafn

revert premature commit affecting all sites

- -10
- +0
./upgrade-5.10.0d12-5.10.0d13.sql
- History
- Source
- Diff
./upgrade-5.10.0d12-5.10.0d13.sql
… 6 more files in changeset.

Friday 22 Feb 2019

7:21 pm

Add new column 'public_avatar_p' to the 'user_preferences' table, in order to allow the user to decide wheter to make the avatar (profile picture) public to other users or not, with a conservative default, false. Add also a simple API to get/set that value and bump acs-kernel version number.

- -0
- +10
./upgrade-5.10.0d12-5.10.0d13.sql
- History
- Source
- Diff
./upgrade-5.10.0d12-5.10.0d13.sql
… 6 more files in changeset.

Friday 15 Feb 2019

6:32 pm

hectorr

Rollback of 'boolean' parameter datatype, as oracle does not see necessary to have 'boolean' datatypes, and they do not even provide with a proper alternative on what to use instead. Great. See: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6263249199595#876972400346931526