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

faq-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 7
Last Commit: 05 Apr
Commits this week: 0
Total Lines of Code (LoC): 154
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 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    • -1
    • +3
    ./faq-create.sql
  2. … 4 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
    ./faq-create.sql
  2. … 2 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -3
    • +3
    ./faq-create.sql
  2. … 7834 more files in changeset.
Tuesday 07 Jun 2016
11:43 am

hectorr

Added missing comma

Options
    • -2
    • +2
    ./faq-create.sql
Saturday 14 May 2016
8:03 pm

gustafn

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

Options
    • -3
    • +3
    ./faq-create.sql
  2. … 5 more files 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
    ./faq-create.sql
  2. … 23 more files in changeset.
Monday 08 Oct 2007
12:36 am

donb

Merged oacs-5-3 branch to HEAD

Options
    • -7
    • +2
    ./faq-create.sql
  2. … 187 more files in changeset.
Wednesday 11 Jul 2007
11:56 am

emmar

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

Options
    • -7
    • +2
    ./faq-create.sql
  2. … 4 more files in changeset.
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
    • -165
    • +9
    ./faq-create.sql
  2. … 8 more files in changeset.
Saturday 17 May 2003
12:26 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -2
    • +2
    ./faq-create.sql
  2. … 35 more files in changeset.
Sunday 02 Mar 2003
11:42 pm

donb

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 ...

Options
    • -2
    • +2
    ./faq-create.sql
  2. … 39 more files in changeset.
Saturday 30 Nov 2002
6:32 pm

jeffd

merge from oacs-4-6

Options
    • -1
    • +2
    ./faq-create.sql
  2. … 103 more files in changeset.
Monday 28 Oct 2002
5:16 pm

jeffd

adds disabled_p to table faqs (used by dotlrn)

Options
    • -1
    • +2
    ./faq-create.sql
  2. … 1 more file in changeset.
Wednesday 17 Jul 2002
10:20 pm

chak

added news and faq dotlrn applets

Options
    • -0
    • +39
    ./faq-create.sql
  2. … 16 more files in changeset.
Wednesday 10 Jul 2002
6:54 pm

chak

pg port of faq

Options
    • -0
    • +266
    ./faq-create.sql
  2. … 1 more file in changeset.