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.1.2.14 -r1.1.2.15 --- openacs-4/packages/acs-core-docs/www/tutorial-database.adp 30 Nov 2016 08:15:11 -0000 1.1.2.14 +++ openacs-4/packages/acs-core-docs/www/tutorial-database.adp 6 Jan 2017 09:18:42 -0000 1.1.2.15 @@ -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,16 @@ 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: tutorial-database.html,v 1.44.2.12 2016/11/19 -09:21:55 gustafn Exp $ will automatically be expanded when +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 +

Figure 9.3. The Database Creation Script

 -- creation script
 --
@@ -82,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
 --