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.7 -r1.1.2.8 --- openacs-4/packages/acs-core-docs/www/tutorial-database.adp 9 Jun 2016 08:44:50 -0000 1.1.2.7 +++ openacs-4/packages/acs-core-docs/www/tutorial-database.adp 9 Jun 2016 13:03:11 -0000 1.1.2.8 @@ -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,17 +42,17 @@ simplify our database creation. (More information about ACS Objects. More information about the Content Repository.)

-

Figure 9.2. Tutorial -Data Model

Tutorial Data Model
+

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 Creation Script

+

Figure 9.3. The +Database Creation Script

 -- creation script
 --
 -- \@author joel\@aufrecht.org
@@ -81,8 +81,8 @@
 uninstalled.

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

Figure 9.4. Database -Deletion Script

+

Figure 9.4. Database +Deletion Script

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