OpenACS / openacs-4 / packages / download / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 7
Last Commit: 14:20
Commits this week: 0
Total Lines of Code (LoC): 695
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 41 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 21 Oct
3:01 pm

antoniop

Move download_* api into a download:: namespace

Fixes naming convention automated test

Options
    • -3
    • +3
    ./download-create.sql
  2. … 32 more files in changeset.
Saturday 30 Apr 2016
11:40 am

gustafn

- drop unused sequence

- use plain sequence for db_nextval

Options
    • -7
    • +2
    ./download-create.sql
    • -5
    • +3
    ./download-drop.sql
    • -0
    • +32
    ./upgrade/upgrade-5.2d6-5.2d7.sql
  4. … 1 more file in changeset.
Saturday 25 Jul 2015
8:12 pm

gustafn

- drop view explicitly and create it in a separate step

Options
    • -2
    • +7
    ./upgrade/upgrade-5.2d3-5.2d4.sql
7:58 pm

gustafn

- Remove dependencies from acs_objects.tree_sortkey and

acs_objects.max_child_sortkey, which are not needed (just part of

the PostgreSql datamodel and not in Oracle) and which will be gone

in OpenACS 5.9

Options
    • -3
    • +3
    ./download-create.sql
    • -0
    • +28
    ./upgrade/upgrade-5.2d3-5.2d4.sql
  3. … 1 more file in changeset.
Thursday 19 Sep 2013
3:10 pm

victorg

Adding missing and.

Options
    • -1
    • +1
    ./upgrade/upgrade-5.2d1-5.2d2.sql
Monday 16 Sep 2013
11:19 am

gustafn

- lifting length contraints that were necessary at openacs.org

Options
    • -3
    • +3
    ./download-create.sql
    • -0
    • +8
    ./upgrade/upgrade-5.2d1-5.2d2.sql
Thursday 12 Sep 2013
12:26 pm

victorg

merging all changes from oacs-5-2 back to HEAD.

Options
    • -9
    • +10
    ./download-create.sql
  2. … 50 more files in changeset.
Wednesday 02 Nov 2005
2:29 am

donb

New datamodel which resulted from fixing bug #2673 with a 5.1 upgrade

Options
    • -9
    • +10
    ./download-create.sql
2:24 am

donb

Argh ... forgot to edit this file for 5.1 to fix bug #2673

Options
    • -9
    • +11
    ./download-create.sql
2:21 am

donb

Upgrade fix for bug #2673

Options
    • -0
    • +138
    ./upgrade/upgrade-5.1d1-5.1d2.sql
2:21 am

donb

file upgrade-5.1d1-5.1d2.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1d1-5.1d2.sql
2:16 am

donb

Fixing bug #2673, by rewriting views to not use the cr-generated input view.

Options
    • -4
    • +4
    ./download-packages.sql
  2. … 1 more file in changeset.
Wednesday 24 Mar 2004
4:18 am

donb

Minor whacks to make this work with Timo's changes to core - untested under

Oracle at the moment ...

Options
    • -4
    • +6
    ./download-packages.sql
  2. … 3 more files in changeset.
Friday 12 Mar 2004
8:19 pm

jeffd

various bug fixes for package_id, title addition to acs_objects

Options
    • -3
    • +7
    ./download-create.sql
  2. … 12 more files in changeset.
Saturday 17 May 2003
12:26 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -4
    • +4
    ./download-create.sql
    • -3
    • +3
    ./download-drop.sql
    • -3
    • +3
    ./download-packages.sql
  4. … 33 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
    • -4
    • +4
    ./download-create.sql
    • -3
    • +3
    ./download-drop.sql
    • -3
    • +3
    ./download-packages.sql
  4. … 37 more files in changeset.
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -3
    • +3
    ./download-packages.sql
  2. … 54 more files in changeset.
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -3
    • +3
    ./download-packages.sql
  2. … 54 more files in changeset.
Saturday 23 Feb 2002
6:15 am

vinodk

1) Cleaned old oracle cruft from postgresql files

2) Fixed bugs in metadata presentation

Options
    • -131
    • +44
    ./download-create.sql
    • -69
    • +9
    ./download-drop.sql
    • -123
    • +9
    ./download-packages.sql
  4. … 3 more files in changeset.
Monday 09 Jul 2001
5:34 pm

vinodk

Cleaned datamodel (number->numeric)

Options
    • -5
    • +5
    ./download-create.sql
Wednesday 23 May 2001
10:00 pm

vinodk

temporarily removed dependencies on acs-messaging

Options
    • -8
    • +5
    ./download-drop.sql
  2. … 3 more files in changeset.
Tuesday 22 May 2001
6:18 am

vinodk

minor cleanup

Options
    • -14
    • +15
    ./download-drop.sql
  2. … 3 more files in changeset.
Wednesday 16 May 2001
11:41 am

vinodk

added file_size to pg datamodel, pg queries. Moved calc (size = bytes/1024) from tcl to sql

Options
    • -1
    • +25
    ./download-create.sql
    • -23
    • +24
    ./download-drop.sql
  3. … 14 more files in changeset.
Monday 14 May 2001
10:31 pm

vinodk

fixed sequences. Updated functions. Improved drop script

Options
    • -1
    • +9
    ./download-create.sql
    • -6
    • +12
    ./download-drop.sql
    • -3
    • +2
    ./download-packages.sql
Friday 11 May 2001
7:20 am

vinodk

more porting to postgres

Options
    • -2
    • +2
    ./download-drop.sql
    • -0
    • +8
    ./download-packages.sql
Thursday 10 May 2001
10:32 pm

vinodk

ported the datamodel

Options
    • -0
    • +418
    ./download-create.sql
    • -0
    • +166
    ./download-drop.sql
    • -0
    • +255
    ./download-packages.sql
  4. … 1 more file in changeset.