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

site-nodes-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

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

gustafn

merge with missing files

Options
    • -0
    • +0
    ./site-nodes-create.sql
  2. … 1464 more files in changeset.
Tuesday 03 Sep 2024
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -2
    • +11
    ./site-nodes-create.sql
  2. … 8099 more files in changeset.
Wednesday 24 Mar 2021
6:00 pm

gernst

Added constraint site_nodes_parent_id_ck to table "site_nodes" to avoid certain simple loops on parent_ids

Options
    • -1
    • +10
    ./site-nodes-create.sql
  2. … 4 more files in changeset.
Wednesday 14 Aug 2019
9:31 am

gustafn

improve spelling

Options
    • -2
    • +2
    ./site-nodes-create.sql
  2. … 33 more files in changeset.
Tuesday 01 May 2018
12:45 pm

gustafn

imporve spelling

Options
    • -2
    • +2
    ./site-nodes-create.sql
  2. … 6 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -2
    • +2
    ./site-nodes-create.sql
  2. … 7834 more files in changeset.
Friday 03 Mar 2017
9:21 am

gustafn

Fix issue #3300 and #3301: index name breaks Oracle name length limit of 30 chars

Options
    • -2
    • +2
    ./site-nodes-create.sql
  2. … 2 more files in changeset.
Monday 27 Apr 2015
5:28 pm

victorg

Merging back to HEAD all changes that happened in branch oacs-5-8 between tags: vg-merge-oacs-5-8-from-20141027 and vg-merge-oacs-5-8-from-20150427

Options
    • -2
    • +4
    ./site-nodes-create.sql
  2. … 520 more files in changeset.
Sunday 22 Feb 2015
10:56 pm

gustafn

- add missing indices

- bump version number to 5.8.3d2

Options
    • -2
    • +4
    ./site-nodes-create.sql
  2. … 7 more files in changeset.
Wednesday 24 Nov 2010
7:58 pm

victorg

On my previous commit I added a not null constraint for name column on site_nodes, the problem is that main site node on oracle has a NULL name ( given the fact that empty strings are managed as NULL on Oracle ) therefore doesnt make sense to have such constraint.

Options
    • -2
    • +2
    ./site-nodes-create.sql
  2. … 3 more files in changeset.
4:21 pm

victorg

- Avoiding usage of coalesce function on site_nodes table columns in WHERE clause, this was leading to usage of sequencial scans which can be expensive when having a huge amount of site_nodes. Instead we go for isolation of the case when requestion a node with a null parent ( this would be the main site node ) and we use the = operator so the planner goes for a index scan.

- Adding not null constraint to site_nodes(name)

Options
    • -2
    • +2
    ./site-nodes-create.sql
  2. … 4 more files in changeset.
Friday 12 Mar 2004
7:48 pm

jeffd

Remerge Timo's changes for tip 42,43, cf tip 53

Options
    • -1
    • +3
    ./site-nodes-create.sql
  2. … 97 more files in changeset.
Thursday 04 Mar 2004
3:52 pm

jeffd

rollback of Timo's name, package_id commit; see TIP 53

Options
    • -2
    • +0
    ./site-nodes-create.sql
  2. … 96 more files in changeset.
Tuesday 02 Mar 2004
6:00 pm

timoh

TIP#42,43: adding package_id and title to acs_objects table

Options
    • -1
    • +3
    ./site-nodes-create.sql
  2. … 96 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
    • -5
    • +5
    ./site-nodes-create.sql
  2. … 275 more files in changeset.
Friday 07 Jun 2002
6:17 am

arjun

added site_nodes_parent_id_idx based on results from scalability testing

Options
    • -1
    • +2
    ./site-nodes-create.sql
  2. … 1 more file in changeset.
Tuesday 20 Mar 2001
11:51 pm

donb

bootstrapper can now load either the Oracle or PostgreSQL acs-kernel

datamodel. It checks on-the-fly for which db is configured in the OpenNSD

database pools allocated to OpenACS. Only acs-kernel is correctly self-

configured at this point.

Options
    • -0
    • +258
    ./site-nodes-create.sql
  2. … 113 more files in changeset.