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

apm-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 17
Last Commit: 26 Apr
Commits this week: 0
Total Lines of Code (LoC): 2,777
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 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 26 Apr 2004
8:50 pm

peterm

Adding new package version attributes maturity, license, and license_url. Introducing the concept of dynamic package version attributes so that these can be added easily in the future. The attributes are driven by a metadata spec returned by the proc apm::package_version::attributes::get_spec.The attributes are stored in the skinny table apm_package_version_attr and managed through the Tcl API in namespace apm::package_version::attributes. Changing the parse and generate info XML file procs to use the dynamic attributes. Adding the dynamic attributes to the manifest XML file as well. The attributes are editable in the APM admin UI.

Options
    • -1
    • +17
    ./apm-create.sql
  2. … 10 more files in changeset.
Tuesday 06 Apr 2004
9:50 pm

andrewg

Removing acs_objects_package_id_fk constraint, which was breaking the install. We can put it back in and have things work if we first rearrange the code in apm_package.new to perform the insert into apm_packages before the update on acs_objects. But for now we'll do as the PG version does, which is to not define the constraint at all.

Options
    • -4
    • +1
    ./apm-create.sql
Friday 12 Mar 2004
7:48 pm

jeffd

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

Options
    • -4
    • +28
    ./apm-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
    • -27
    • +3
    ./apm-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
    • -4
    • +28
    ./apm-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
    • -37
    • +37
    ./apm-create.sql
  2. … 275 more files in changeset.
Wednesday 24 Sep 2003
7:25 pm

peterm

when removing the apm_package.enabled_p column I forgot to remove the apm_package.enable/disable functions, so removing those now

Options
    • -31
    • +1
    ./apm-create.sql
  2. … 4 more files in changeset.
2:20 pm

peterm

Upgrading kernel to 5.0d9. Fixing bug 555 - Removing apm_packages.enabled_p column and taking the opportunity to remove obsolete file related datamodel

Options
    • -174
    • +4
    ./apm-create.sql
  2. … 3 more files in changeset.
Friday 15 Aug 2003
4:35 pm

peterm

adding locale and timezone to user_preferences table. Adding default_locale to apm_packages table

Options
    • -2
    • +4
    ./apm-create.sql
  2. … 8 more files in changeset.
Thursday 17 Jul 2003
3:10 am

donb

Decided that assuming SQL data files are CSV-formatted files is a bad idea

after running into a package that embeds comments in its data! Changed

from .csv to .dat and all that implies. Still more testing to do...

Options
    • -2
    • +2
    ./apm-create.sql
  2. … 33 more files in changeset.
Wednesday 16 Jul 2003
2:15 am

donb

Added code to allow loading of data for packages like ref-timezones with

SQL*Loader or PostgreSQL's COPY command.

Options
    • -1
    • +2
    ./apm-create.sql
  2. … 8 more files in changeset.
Tuesday 15 Jul 2003
2:38 am

donb

Added csv_data as a package file type ...

Options
    • -1
    • +2
    ./apm-create.sql
  2. … 3 more files in changeset.
Saturday 17 May 2003
3:46 am

donb

Merged with 4.6 branch

Options
    • -1
    • +1
    ./apm-create.sql
  2. … 30 more files in changeset.
Wednesday 05 Mar 2003
3:37 pm

lars

Upgrade to 4.6.2: APM changes and change in installation procedure

Options
    • -6
    • +48
    ./apm-create.sql
  2. … 6 more files in changeset.
Friday 31 Jan 2003
3:01 pm

peterm

Adding missing piece to the db upgrade of acs-kernel 4.6.1-4.7d - the callbacks were not being copied when upgrading a package through the edit package page. Changing to create or replace syntax for functions in PG (works in 7.2 and 7.1 is deprecated)

Options
    • -1
    • +6
    ./apm-create.sql
  2. … 3 more files in changeset.
Wednesday 29 Jan 2003
10:43 am

peterm

as part of the sql upgrade of acs-kernel from 4.6.1 to 4.7d I forgot to change views and plsql code. Adding these changes now to make the upgrade complete

Options
    • -6
    • +11
    ./apm-create.sql
  2. … 3 more files in changeset.
Monday 27 Jan 2003
11:36 am

peterm

upgrading acs-kernel from 4.6.1 to 4.7d to support APM auto mounting of packages, and Tcl procedure package callbacks such as after-install, after-instantiate, and after-mount. Upgrade scripts supplied to add table apm_package_callbacks and add column auto_mount to table apm_package_versions.

Options
    • -1
    • +8
    ./apm-create.sql
  2. … 4 more files in changeset.
Thursday 23 Jan 2003
6:46 pm

peterm

adding a table to the APM for holding Tcl proc callbacks invoked after installation, instantiation etc. of packages

Options
    • -1
    • +26
    ./apm-create.sql
  2. … 1 more file in changeset.
Thursday 19 Dec 2002
5:11 pm

peterm

adding the Message Catalog APM file type to the datamodel

Options
    • -1
    • +2
    ./apm-create.sql
  2. … 1 more file in changeset.
Monday 23 Sep 2002
1:05 pm

jeffd

avoid collating order problems by padding version strings with 0000.

Options
    • -5
    • +8
    ./apm-create.sql
  2. … 1 more file in changeset.
Saturday 06 Apr 2002
7:34 pm

yon

added parent_id function to apm_package package

Options
    • -1
    • +25
    ./apm-create.sql
  2. … 1 more file in changeset.
Friday 25 Jan 2002
11:56 pm

arjun

Fixing incorrect and confusing error text.

Options
    • -3
    • +2
    ./apm-create.sql
Monday 05 Nov 2001
4:55 am

donb

Copying a version of a package didn't copy the database-supported field for

its files.

Options
    • -3
    • +3
    ./apm-create.sql
  2. … 1 more file in changeset.
Wednesday 29 Aug 2001
11:22 pm

donb

A bunch of "ACS"->"OpenACS" and similar changes

Options
    • -5
    • +5
    ./apm-create.sql
  2. … 28 more files in changeset.
Friday 11 May 2001
2:14 am

donb

1. Polished up the query files for the root www directory

2. Turned a bunch of bitmap indexes into b-tree indexes

3. the developer support .info file had been messed over by an early

version of my APM port to PG.

Options
    • -4
    • +5
    ./apm-create.sql
  2. … 8 more files in changeset.
Thursday 10 May 2001
7:10 am

danw

fixed comment for distribution_tarball attribute that was removed

Options
    • -2
    • +2
    ./apm-create.sql
12:32 am

donb

1. Added a new attribute to the .info file which tells the bootstrap

installer whether or not a package is part of the acs-core. Only

acs-core packages are now installed during the initial bootstrap install

of the system.

2. Fixed a dupe query name problem in a couple of queryfiles. The problem

is not with the dispatcher but with the extractor, and for the moment it

is just easier to kludge the resulting queryfile than fix the extractor.

Options
    • -5
    • +69
    ./apm-create.sql
  2. … 36 more files in changeset.
Saturday 05 May 2001
7:39 pm

danw

converted apm to store tarballs in the content repository

Options
    • -4
    • +8
    ./apm-create.sql
  2. … 7 more files in changeset.
Thursday 05 Apr 2001
8:23 pm

donb

Big 'ole update to implement multi-db aware packages. Don't try this yet,

I can't *possibly* have gotten all the right files added and removed in

one fell swoop!

Options
    • -7
    • +39
    ./apm-create.sql
  2. … 118 more files 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
    • +2624
    ./apm-create.sql
  2. … 113 more files in changeset.