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.)
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.