Index: openacs-4/packages/acs-core-docs/www/tutorial-database.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/tutorial-database.adp,v diff -u -N -r1.1.2.26 -r1.1.2.27 --- openacs-4/packages/acs-core-docs/www/tutorial-database.adp 20 Jun 2017 07:16:41 -0000 1.1.2.26 +++ openacs-4/packages/acs-core-docs/www/tutorial-database.adp 6 Aug 2017 11:31:22 -0000 1.1.2.27 @@ -15,7 +15,7 @@ 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 myfirstpackage/sql/ directory. All database +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 myfirstpackage/sql/postgresql @@ -42,7 +42,7 @@ simplify our database creation. (More information about ACS Objects. More information about the Content Repository.)

-

Figure 9.2. Tutorial Data +

Figure 9.2. Tutorial Data Model

Tutorial Data Model

The top of each sql file has some standard comments, including doc tags such as \@author which @@ -51,7 +51,7 @@ [$OPENACS_SERVICE_NAME ~]$ cd /var/lib/aolserver/$OPENACS_SERVICE_NAME/packages/myfirstpackage/sql/postgresql [$OPENACS_SERVICE_NAME postgresql]$ emacs myfirstpackage-create.sql

Paste the text below into the file, save, and close.

-

Figure 9.3. The +

Figure 9.3. The Database Creation Script

 -- creation script
 --
@@ -81,7 +81,7 @@
 uninstalled.

 [$OPENACS_SERVICE_NAME postgresql]$ emacs myfirstpackage-drop.sql
 
-

Figure 9.4. Database Deletion +

Figure 9.4. Database Deletion Script

 -- drop script
 --