Activity OpenACS/openacs-4/packages/faq/sql/postgresql/upgrade

Tree
Accordion

Stats

Commits this week: 0

Total Committers:	8
Last Commit:	23 Dec
Commits this week:	0
Total Lines of Code (LoC):	362
Net change in LoC this week:	0

Commit Activity

last updated 11 hours ago

Constraints

Constraints: committers

Committer:

Log Comment:

Constraints: files

File Extension:

File Name:

Constraints: dates

Start Date:

End Date:

Tuesday 03 Sep

5:37 pm

gustafn

More
MAIN:gustafn:20240903153723
changed 8100 files
MAIN

merge from oacs-5-10

- -0
- +156
./upgrade-5.10.0d7-5.10.0d8.sql
- History
- Source
- Diff
./upgrade-5.10.0d7-5.10.0d8.sql
… 8099 more files in changeset.

Friday 20 Mar 2020

12:55 pm

antoniop

Redefine faq questions and answers as text, the same as downstream, then redefine all database function api so that argument types are taken from table definition

- -0
- +156
./upgrade-5.10.0d7-5.10.0d8.sql
- History
- Source
- Diff
./upgrade-5.10.0d7-5.10.0d8.sql
… 3 more files in changeset.

12:55 pm

antoniop

More
MAIN:antoniop:20200320115547
deleted 1 file
MAIN

file upgrade-5.10.0d7-5.10.0d8.sql was initially added on branch oacs-5-10.

- -0
- +0
./upgrade-5.10.0d7-5.10.0d8.sql
- History
- Source
./upgrade-5.10.0d7-5.10.0d8.sql

Thursday 31 Jan 2019

12:42 pm

antoniop

More
MAIN:antoniop:20190131114244
changed 1 file
MAIN

Don't rely on the delete trigger being named consistently on different installations

- -1
- +15
./upgrade-5.10.0d6-5.10.0d7.sql
- History
- Source
- Diff
./upgrade-5.10.0d6-5.10.0d7.sql

12:28 pm

antoniop

More
MAIN:antoniop:20190131112811
changed 1 file
MAIN

Add again double quotes in the add constraint as well

- -1
- +1
./upgrade-5.10.0d5-5.10.0d6.sql
- History
- Source
- Diff
./upgrade-5.10.0d5-5.10.0d6.sql

12:21 pm

antoniop

More
MAIN:antoniop:20190131112153
changed 1 file
MAIN

Add double quotes in case constraints were defined using e.g. $ in the old days

- -1
- +1
./upgrade-5.10.0d5-5.10.0d6.sql
- History
- Source
- Diff
./upgrade-5.10.0d5-5.10.0d6.sql

Wednesday 30 Jan 2019

12:59 pm

antoniop

More
MAIN:antoniop:20190130115949
changed 5 files
MAIN

Faq vs Search trigger reform: turns out after delete trigger on faq_q_and_as is quite pointless and makes it more complicated for faq package instances to properly uninstantiated. More details in the comments.

- -0
- +24
./upgrade-5.10.0d6-5.10.0d7.sql
- History
- Source
./upgrade-5.10.0d6-5.10.0d7.sql
… 4 more files in changeset.

Tuesday 29 Jan 2019

6:10 pm

antoniop

More
MAIN:antoniop:20190129171034
changed 5 files
MAIN

Introduce ON DELETE CASCADE on faq main datamodel tables, so generic acs_object db api can be used to e.g. delete a faq (fixes downstream errors when deleting FAQ package)

- -0
- +62
./upgrade-5.10.0d5-5.10.0d6.sql
- History
- Source
./upgrade-5.10.0d5-5.10.0d6.sql
… 4 more files in changeset.

Wednesday 15 Aug 2018

6:49 pm

gustafn

More
MAIN:gustafn:20180815164920
changed 27 files
MAIN

Removed obsolete @arch-tag

- -2
- +1
./upgrade-5.2.0d4-5.2.0d5.sql
- History
- Source
- Diff
./upgrade-5.2.0d4-5.2.0d5.sql
… 26 more files in changeset.

Thursday 12 Jul 2018

10:51 am

antoniop

More
MAIN:antoniop:20180712085104
changed 3 files
MAIN

Align case of acs_object_type with that of the actual table (fixes automated tests)

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

- -0
- +9
./upgrade-5.10.0d2-5.10.0d3.sql
- History
- Source
./upgrade-5.10.0d2-5.10.0d3.sql
… 2 more files in changeset.

Tuesday 08 Aug 2017

1:47 am

gustafn

More
MAIN:gustafn:20170807234743
changed 7835 files
MAIN

merged changes from the oacs-5-9 branch and resolved conflicts

- -0
- +16
./upgrade-5.9.0-5.9.1d1.sql
- History
- Source
- Diff
./upgrade-5.9.0-5.9.1d1.sql
… 7834 more files in changeset.

Wednesday 31 May 2017

2:47 pm

michaela

Add another constraint name variant as it existed in our production system

- -1
- +3
./upgrade-5.9.0-5.9.1d1.sql
- History
- Source
- Diff
./upgrade-5.9.0-5.9.1d1.sql

Sunday 15 May 2016

10:15 pm

gustafn

- provide support for old installations, with other constaint names

- -1
- +3
./upgrade-5.9.0-5.9.1d1.sql
- History
- Source
- Diff
./upgrade-5.9.0-5.9.1d1.sql

Saturday 14 May 2016

8:03 pm

gustafn

Alter caveman style booleans (type character(1)) to real SQL boolean types.

- -0
- +12
./upgrade-5.9.0-5.9.1d1.sql
- History
- Source
- Diff
./upgrade-5.9.0-5.9.1d1.sql
… 5 more files in changeset.

8:03 pm

gustafn

More
MAIN:gustafn:20160514180315
deleted 1 file
MAIN

file upgrade-5.9.0-5.9.1d1.sql was initially added on branch oacs-5-9.

- -0
- +0
./upgrade-5.9.0-5.9.1d1.sql
- History
- Source
./upgrade-5.9.0-5.9.1d1.sql

Monday 27 Oct 2014

5:38 pm

victorg

More
MAIN:victorg:20141027163849
changed 2548 files
MAIN

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

- -9
- +17
./upgrade-4.0-4.6.sql
- History
- Source
- Diff
./upgrade-4.0-4.6.sql
- -0
- +3
./upgrade-5.8.1d2-5.8.1d3.sql
- History
- Source
- Diff
./upgrade-5.8.1d2-5.8.1d3.sql
… 2546 more files in changeset.

Tuesday 09 Sep 2014

10:30 am

gustafn

- add upgrade files

- -0
- +3
./upgrade-5.8.1d2-5.8.1d3.sql
- History
- Source
- Diff
./upgrade-5.8.1d2-5.8.1d3.sql
… 1 more file in changeset.

10:30 am

gustafn

More
MAIN:gustafn:20140909083046:1
deleted 1 file
MAIN

file upgrade-5.8.1d2-5.8.1d3.sql was initially added on branch oacs-5-8.

- -0
- +0
./upgrade-5.8.1d2-5.8.1d3.sql
- History
- Source
./upgrade-5.8.1d2-5.8.1d3.sql

Friday 05 Sep 2014

6:49 pm

gustafn

- modernize SQL

- -9
- +17
./upgrade-4.0-4.6.sql
- History
- Source
- Diff
./upgrade-4.0-4.6.sql
… 2 more files in changeset.

Wednesday 18 Sep 2013

5:00 pm

victorg

More
MAIN:victorg:20130918150030
changed 1 file
MAIN

missing ';'.

- -1
- +1
./upgrade-5.2.0d5-5.2.0d6.sql
- History
- Source
- Diff
./upgrade-5.2.0d5-5.2.0d6.sql

Tuesday 17 Sep 2013

1:25 pm

victorg

More
MAIN:victorg:20130917112523
changed 2 files
MAIN

Fixing null package_id's for faq and faq_q_and_as objects. Patch orignally provided by Gustaf Neumann.

- -0
- +11
./upgrade-5.2.0d5-5.2.0d6.sql
- History
- Source
./upgrade-5.2.0d5-5.2.0d6.sql
… 1 more file in changeset.

Monday 08 Oct 2007

12:36 am

donb

More
MAIN:donb:20071007223653
changed 188 files
MAIN

Merged oacs-5-3 branch to HEAD

- -0
- +10
./upgrade-5.2.0d4-5.2.0d5.sql
- History
- Source
- Diff
./upgrade-5.2.0d4-5.2.0d5.sql
… 187 more files in changeset.

Wednesday 11 Jul 2007

11:56 am

emmar

More
MAIN:emmar:20070711095659:1
deleted 1 file
MAIN

file upgrade-5.2.0d4-5.2.0d5.sql was initially added on branch oacs-5-3.

- -0
- +0
./upgrade-5.2.0d4-5.2.0d5.sql
- History
- Source
./upgrade-5.2.0d4-5.2.0d5.sql

11:56 am

emmar

More
oacs-5-3:emmar:20070711095658
changed 5 files
oacs-5-3

Added triggers to index faq contents for search (thanks to Jorge Couchet)

- -0
- +10
./upgrade-5.2.0d4-5.2.0d5.sql
- History
- Source
- Diff
./upgrade-5.2.0d4-5.2.0d5.sql
… 4 more files in changeset.

Tuesday 08 Aug 2006

11:26 pm

donb

More
MAIN:donb:20060808212611
changed 2479 files
MAIN

First shot at merging oacs-5-2 apps used in .LRN to HEAD.

- -1
- +1
./upgrade-5.2.0d1-5.2.0d2.sql
- History
- Source
- Diff
./upgrade-5.2.0d1-5.2.0d2.sql
… 2478 more files in changeset.

Saturday 16 Jul 2005

11:00 pm

daveb

Update acs_object_types table, not acs_objects.

- -1
- +1
./upgrade-5.2.0d1-5.2.0d2.sql
- History
- Source
- Diff
./upgrade-5.2.0d1-5.2.0d2.sql

Friday 02 Apr 2004

12:52 am

jeffd

More
MAIN:jeffd:20040401225245
changed 9 files
MAIN

split package from datamodel create, add fts contract, update for tip 42,43 fix name_method on pg

- -0
- +5
./upgrade-5.2.0d1-5.2.0d2.sql
- History
- Source
./upgrade-5.2.0d1-5.2.0d2.sql
… 8 more files in changeset.

Saturday 17 May 2003

12:26 pm

jeffd

More
MAIN:jeffd:20030517102650
changed 36 files
MAIN

merge of 4.6.3b1 to HEAD

- -0
- +45
./upgrade-4.0-4.6.sql
- History
- Source
- Diff
./upgrade-4.0-4.6.sql
… 35 more files in changeset.

Wednesday 19 Mar 2003

10:45 am

jeffd

I added an upgrade script for 4.0-4.6, need to do something for people who upgraded before it was there, bump version and have a script that only gets sourced if the column does not exist? bug 215

- -0
- +45
./upgrade-4.0-4.6.sql
- History
- Source
- Diff
./upgrade-4.0-4.6.sql

10:45 am

jeffd

More
MAIN:jeffd:20030319094539
deleted 1 file
MAIN

file upgrade-4.0-4.6.sql was initially added on branch oacs-4-6.

- -0
- +0
./upgrade-4.0-4.6.sql
- History
- Source
./upgrade-4.0-4.6.sql

upgrade

Line History

Stats

Commits this week: 0

Commit Activity

52 week commits volume

Commits by day

Commits by hour

Commit calendar

Most active committers (90 days)

gustafn

antoniop

antoniop

antoniop

antoniop

antoniop

antoniop

antoniop

gustafn

antoniop

gustafn

michaela

gustafn

gustafn

gustafn

victorg

gustafn

gustafn

gustafn

victorg

victorg

donb

emmar

emmar

donb

daveb

jeffd

jeffd

jeffd

jeffd