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.14.2.5 -r1.14.2.6 --- openacs-4/packages/acs-core-docs/www/tutorial-database.html 16 Dec 2003 13:58:42 -0000 1.14.2.5 +++ openacs-4/packages/acs-core-docs/www/tutorial-database.html 18 Dec 2003 10:04:27 -0000 1.14.2.6 @@ -1,7 +1,7 @@ Setting Up Database Objects
Alex logo
Prev Chapter�7.�Development Tutorial Next

Setting Up Database Objects

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 @@ -36,7 +36,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 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 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$
 --
@@ -60,7 +60,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 postgresql]$ emacs myfirstpackage-drop.sql
Figure�7.3.�Database deletion script
-- packages/myfirstpackage/sql/myfirstpackage-drop.sql
+        is uninstalled.
[service0 postgresql]$ emacs myfirstpackage-drop.sql
Figure�7.3.�Database deletion script
-- packages/myfirstpackage/sql/myfirstpackage-drop.sql
 -- drop script
 --
 -- @author joel@aufrecht.org