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

acs-metadata-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 13
Last Commit: 17:08
Commits this week: 0
Total Lines of Code (LoC): 1,232
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 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 16 Sep 2002
11:52 pm

jeffd

increase field sizes (from sloan)

Options
    • -3
    • +3
    ./acs-metadata-create.sql
  2. … 3 more files in changeset.
Thursday 07 Mar 2002
8:05 am

vinodk

don't allow null for supertype in acs_object_type__create_type. default to 'acs_object'

Options
    • -1
    • +8
    ./acs-metadata-create.sql
Sunday 09 Dec 2001
5:21 am

donb

Added code to make use of David Walker's wonderfully abusive hack on the

pg_proc table that showed me how to write recursive SQL functions. We now

have good use of the index on tree_sortkey when climbing the tree, woo-hoo!

Options
    • -87
    • +7
    ./acs-metadata-create.sql
  2. … 18 more files in changeset.
Saturday 08 Dec 2001
2:17 am

donb

Changed the representation of tree_sortkeys from "text" to "bit varying".

Options
    • -18
    • +14
    ./acs-metadata-create.sql
  2. … 62 more files in changeset.
Saturday 01 Dec 2001
6:55 pm

donb

1. Replaced more "tree_sortkey like" with "tree_sortkey between" expressions

2. Fixed a bad port of an Oracle query in site-nodes-procs.tcl and removed

a needless outer join from both versions in the process.

Options
    • -9
    • +6
    ./acs-metadata-create.sql
  2. … 11 more files in changeset.
Thursday 15 Nov 2001
2:47 am

donb

1. Fixed permissions bug in the PG version (missing OR clause in a view)

2. Added (untested thus far) site-wide-search to glossary

3. Added centralized support for importing files into the CR (either into

the filesystem or the database).

4. Fixed wp-slim. Fixed it some more. Fixed it again. It still needs

more fixing.

Options
    • -1
    • +7
    ./acs-metadata-create.sql
  2. … 61 more files in changeset.
Tuesday 25 Sep 2001
1:45 am

danw

added name method support for content_revision type

Options
    • -1
    • +1
    ./acs-metadata-create.sql
  2. … 5 more files in changeset.
Saturday 01 Sep 2001
8:30 pm

stevew

Speed up sluggish acs_object_type_supertype_map view

Options
    • -9
    • +6
    ./acs-metadata-create.sql
Saturday 28 Apr 2001
7:35 pm

donb

1. Ripped out the '' vs. NULL string kludge, which was a stupid idea in the

first place (MY stupid idea, for the record).

2. More .xql file porting...

Options
    • -14
    • +14
    ./acs-metadata-create.sql
  2. … 23 more files in changeset.
Wednesday 18 Apr 2001
1:41 am

danw

added comments for default api values

Options
    • -15
    • +15
    ./acs-metadata-create.sql
  2. … 12 more files in changeset.
Saturday 14 Apr 2001
7:12 am

danw

more cleanup of nullable strings in kernel

Options
    • -1
    • +1
    ./acs-metadata-create.sql
  2. … 8 more files in changeset.
Monday 09 Apr 2001
6:55 am

danw

fixed problem with infinite recursion on updates of tables with tree query triggers

Options
    • -1
    • +2
    ./acs-metadata-create.sql
  2. … 4 more files in changeset.
Tuesday 20 Mar 2001
7:02 am

danw

more cleanup

Options
    • -7
    • +11
    ./acs-metadata-create.sql
  2. … 6 more files in changeset.
Wednesday 14 Mar 2001
3:07 pm

danw

fixed up some typos

Options
    • -4
    • +4
    ./acs-metadata-create.sql
  2. … 4 more files in changeset.
5:39 am

danw

initial import of acs kernel data-model ported to postgresql - implementation of tree queries completed for acs_object_types. Still need to finish tree queries for acs_privilege_hierarchy and rel_constraints tables.

Options
    • -0
    • +824
    ./acs-metadata-create.sql
  2. … 37 more files in changeset.