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 -r1.4.2.2 -r1.4.2.3 --- openacs-4/packages/acs-core-docs/www/tutorial-database.adp 10 Mar 2019 21:47:15 -0000 1.4.2.2 +++ openacs-4/packages/acs-core-docs/www/tutorial-database.adp 27 Jun 2019 18:22:22 -0000 1.4.2.3 @@ -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,15 +42,15 @@ 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 will be picked up by the API browser. The string $‌Id:$ will automatically be expanded when the file is checked in to cvs.

[$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 Database +

Figure 9.3. The Database Creation Script

-- creation script
 --
 -- \@author joel\@aufrecht.org
@@ -79,7 +79,7 @@
 uninstalled.

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

Figure 9.4. Database Deletion +

Figure 9.4. Database Deletion Script

-- drop script
 --
 -- \@author joel\@aufrecht.org