Index: openacs-4/packages/acs-core-docs/www/tutorial-database.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/tutorial-database.html,v diff -u -r1.11 -r1.12 --- openacs-4/packages/acs-core-docs/www/tutorial-database.html 5 Nov 2003 11:48:10 -0000 1.11 +++ openacs-4/packages/acs-core-docs/www/tutorial-database.html 5 Nov 2003 14:46:52 -0000 1.12 @@ -2,7 +2,7 @@ by Joel Aufrecht
OpenACS docs are written by the named authors, and may be edited by OpenACS documentation staff. -

Code the data model

We create all database objects with scripts in the +

Code the data model

We create all database objects with scripts in the myfirstpackage/sql/ directory. All database scripts are database-specific and are thus in either the myfirstpackage/sql/oracle or @@ -37,7 +37,7 @@ @author which will be picked up by the API browser. The string $Id$ will automatically be - expanded when the file is checked in to cvs.

[service0@yourserver postgresql]$ emacs myfirstpackage-create.sql

Paste this into the file and save and close.

Figure�7.2.�Database Creation Script - master create file

--
+      expanded when the file is checked in to cvs.

[service0@yourserver postgresql]$ emacs myfirstpackage-create.sql

Paste this into the file and save and close.

Figure�7.2.�Database Creation Script - master create file

--
 -- @author rhs@mit.edu
 -- @cvs-id $Id$
 --
@@ -57,7 +57,7 @@
     object.  Notice the use of "mfp."  This token, derived from "My
     First Package," ensures that our object is unlikely to conflict
     with objects from other packages.

Create a database file to drop everything if the package - is uninstalled.

[service0@yourserver postgresql]$ emacs myfirstpackage-drop.sql

Figure�7.3.�Database deletion script

-- packages/myfirstpackage/sql/myfirstpackage-drop.sql
+        is uninstalled.

[service0@yourserver postgresql]$ emacs myfirstpackage-drop.sql

Figure�7.3.�Database deletion script

-- packages/myfirstpackage/sql/myfirstpackage-drop.sql
 -- drop script
 --
 -- @author joel@aufrecht.org