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.12 -r1.1.2.13 --- openacs-4/packages/acs-core-docs/www/tutorial-database.adp 23 Jun 2016 08:32:46 -0000 1.1.2.12 +++ openacs-4/packages/acs-core-docs/www/tutorial-database.adp 19 Nov 2016 09:21:55 -0000 1.1.2.13 @@ -1,5 +1,5 @@ -{/doc/acs-core-docs {Documentation}} {Setting Up Database Objects} +{/doc/acs-core-docs {ACS Core Documentation}} {Setting Up Database Objects} Setting Up Database Objects

-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.10 2016/06/21 -07:44:36 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
 --