OpenACS / openacs-4 / packages / faq

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 14
Last Commit: 20 Dec
Commits this week: 0
Total Lines of Code (LoC): 1,564
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 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./oracle/faq-create.sql
    • -0
    • +0
    ./postgresql/faq-create.sql
    • -0
    • +0
    ./postgresql/faq-package-create.sql
    • -0
    • +0
    ./postgresql/faq-sc-create.sql
  5. … 1461 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -1
    • +1
    ./oracle/faq-create.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-5.10.0d5-5.10.0d6.sql
    • -3
    • +3
    ./postgresql/faq-create.sql
    • -27
    • +29
    ./postgresql/faq-package-create.sql
    • -1
    • +1
    ./postgresql/faq-sc-create.sql
    • -0
    • +156
    ./postgresql/upgrade/upgrade-5.10.0d7-5.10.0d8.sql
  7. … 8094 more files in changeset.
Sunday 25 Oct 2020
7:57 pm

gustafn

make packages in principle installable under PG 13+

Options
    • -4
    • +4
    ./postgresql/faq-sc-create.sql
  2. … 19 more files in changeset.
Friday 20 Mar 2020
12:55 pm

antoniop

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

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d7-5.10.0d8.sql
Thursday 31 Jan 2019
12:42 pm

antoniop

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

Options
    • -1
    • +15
    ./postgresql/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
12:28 pm

antoniop

Add again double quotes in the add constraint as well

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d5-5.10.0d6.sql
12:21 pm

antoniop

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

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d5-5.10.0d6.sql
Wednesday 30 Jan 2019
1:13 pm

antoniop

Put on delete cascade defined in previous upgrades in creation sql as well

Options
    • -2
    • +2
    ./oracle/faq-create.sql
    • -2
    • +2
    ./postgresql/faq-create.sql
12:59 pm

antoniop

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.

Options
    • -2
    • +21
    ./postgresql/faq-sc-create.sql
    • -0
    • +24
    ./postgresql/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
  3. … 3 more files in changeset.
Tuesday 29 Jan 2019
6:10 pm

antoniop

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)

Options
    • -2
    • +4
    ./oracle/faq-create.sql
    • -0
    • +64
    ./oracle/upgrade/upgrade-5.10.0d5-5.10.0d6.sql
    • -1
    • +3
    ./postgresql/faq-create.sql
    • -0
    • +62
    ./postgresql/upgrade/upgrade-5.10.0d5-5.10.0d6.sql
  5. … 1 more file in changeset.
Wednesday 15 Aug 2018
6:49 pm

gustafn

Removed obsolete @arch-tag

Options
    • -2
    • +1
    ./postgresql/faq-sc-create.sql
    • -2
    • +1
    ./postgresql/upgrade/upgrade-5.2.0d4-5.2.0d5.sql
  3. … 25 more files in changeset.
Thursday 12 Jul 2018
10:51 am

antoniop

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.

Options
    • -5
    • +5
    ./postgresql/faq-create.sql
    • -0
    • +9
    ./postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
  3. … 1 more file in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -3
    • +3
    ./postgresql/faq-create.sql
    • -3
    • +3
    ./postgresql/faq-drop.sql
    • -0
    • +16
    ./postgresql/upgrade/upgrade-5.9.0-5.9.1d1.sql
  4. … 7832 more files in changeset.
Saturday 14 May 2016
8:03 pm

gustafn

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

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.0-5.9.1d1.sql
Monday 27 Oct 2014
5:38 pm

victorg

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

Options
    • -18
    • +19
    ./postgresql/faq-package-create.sql
    • -18
    • +16
    ./postgresql/faq-sc-create.sql
    • -9
    • +17
    ./postgresql/upgrade/upgrade-4.0-4.6.sql
    • -0
    • +3
    ./postgresql/upgrade/upgrade-5.8.1d2-5.8.1d3.sql
  5. … 2544 more files in changeset.
Tuesday 09 Sep 2014
10:30 am

gustafn

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

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.8.1d2-5.8.1d3.sql
Wednesday 18 Sep 2013
5:00 pm

victorg

missing ';'.

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
Tuesday 17 Sep 2013
1:25 pm

victorg

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

Options
    • -0
    • +11
    ./postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  2. … 1 more file in changeset.
Monday 12 Aug 2013
11:34 am

gustafn

- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

Options
    • -34
    • +41
    ./postgresql/faq-create.sql
    • -42
    • +49
    ./postgresql/faq-drop.sql
    • -45
    • +92
    ./postgresql/faq-package-create.sql
  4. … 21 more files in changeset.
Monday 08 Oct 2007
12:36 am

donb

Merged oacs-5-3 branch to HEAD

Options
    • -7
    • +2
    ./postgresql/faq-create.sql
    • -0
    • +9
    ./postgresql/faq-drop.sql
    • -0
    • +38
    ./postgresql/faq-sc-create.sql
    • -0
    • +10
    ./postgresql/upgrade/upgrade-5.2.0d4-5.2.0d5.sql
  5. … 184 more files in changeset.
Wednesday 11 Jul 2007
11:56 am

emmar

file faq-sc-create.sql was initially added on branch oacs-5-3.

Options
    • -0
    • +0
    ./postgresql/faq-sc-create.sql
11:56 am

emmar

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

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.2.0d4-5.2.0d5.sql
Tuesday 08 Aug 2006
11:26 pm

donb

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

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  2. … 2478 more files in changeset.
Friday 18 Mar 2005
7:48 pm

andrewg

Renamed a mis-named variable.

Options
    • -2
    • +2
    ./oracle/faq-package-create.sql
Friday 02 Apr 2004
12:52 am

jeffd

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

Options
    • -206
    • +8
    ./oracle/faq-create.sql
    • -0
    • +217
    ./oracle/faq-package-create.sql
    • -0
    • +1
    ./oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
    • -165
    • +9
    ./postgresql/faq-create.sql
    • -0
    • +171
    ./postgresql/faq-package-create.sql
    • -0
    • +5
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  7. … 3 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

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)

Options
    • -4
    • +4
    ./oracle/faq-create.sql
  2. … 275 more files in changeset.
Saturday 17 May 2003
12:26 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -2
    • +2
    ./postgresql/faq-create.sql
    • -2
    • +2
    ./postgresql/faq-drop.sql
    • -0
    • +45
    ./postgresql/upgrade/upgrade-4.0-4.6.sql
  4. … 33 more files in changeset.
Wednesday 19 Mar 2003
10:45 am

jeffd

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

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.0-4.6.sql
Saturday 30 Nov 2002
6:32 pm

jeffd

merge from oacs-4-6

Options
    • -1
    • +2
    ./oracle/faq-create.sql
    • -0
    • +212
    ./oracle/upgrade/upgrade-4.0-4.6.sql
    • -1
    • +2
    ./postgresql/faq-create.sql
  4. … 101 more files in changeset.
Tuesday 29 Oct 2002
2:52 am

vinodk

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

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-4.0-4.6.sql