Index: openacs-4/packages/acs-core-docs/www/tutorial-database.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/tutorial-database.html,v diff -u -r1.5 -r1.6 --- openacs-4/packages/acs-core-docs/www/tutorial-database.html 14 Oct 2003 11:02:59 -0000 1.5 +++ openacs-4/packages/acs-core-docs/www/tutorial-database.html 21 Oct 2003 10:04:48 -0000 1.6 @@ -2,7 +2,7 @@ by Joel Aufrecht
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 +

Code the data model

We create all database objects with scripts in the samplenote/sql/ directory. All database scripts are database-specific and are thus in either the samplenote/sql/oracle or @@ -39,7 +39,7 @@ @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.

[service0@yourserver postgresql]$ emacs samplenote-create.sql

Paste this into the file and save and close.

Figure�10.2.�Database Creation Script - master create file

--
+      expanded when the file is checked in to cvs.

[service0@yourserver postgresql]$ emacs samplenote-create.sql

Paste this into the file and save and close.

Figure�10.2.�Database Creation Script - master create file

--
 -- packages/samplenote/sql/postgresql/samplenote-create.sql
 --
 -- @author rhs@mit.edu
@@ -49,7 +49,7 @@
 --
 
 \i samplenote-table-create.sql
-\i samplenote-functions-create.sql

Create the file to create the database table.

[service0@yourserver postgresql]$ emacs samplenote-table-create.sql

Paste this into the file and save and close.

Figure�10.3.�Database Creation Script - table

--
+\i samplenote-functions-create.sql

Create the file to create the database table.

[service0@yourserver postgresql]$ emacs samplenote-table-create.sql

Paste this into the file and save and close.

Figure�10.3.�Database Creation Script - table

--
 -- packages/samplenote/sql/postgresql/samplenote-table-create.sql
 --
 -- @author rhs@mit.edu
@@ -92,7 +92,7 @@
 	null,				        -- type_extension_table
 	''samplenote__name'' 			-- name_method
 	);
-

Create the file to create the functions used to manipulate records.

[service0@yourserver postgresql]$ emacs samplenote-functions-create.sql

Paste this into the file and save and close.

Figure�10.4.�Database Creation Script - functions

--
+

Create the file to create the functions used to manipulate records.

[service0@yourserver postgresql]$ emacs samplenote-functions-create.sql

Paste this into the file and save and close.

Figure�10.4.�Database Creation Script - functions

--
 -- packages/samplenote/sql/postgresql/samplenote-functions-create.sql
 --
 -- @author rhs@mit.edu
@@ -187,7 +187,7 @@
 end;
 ' language 'plpgsql';
 

Create a database file to drop everything if the package - is uninstalled.

[service0@yourserver postgresql]$ emacs samplenote-drop.sql

Figure�10.5.�Database deletion script

-- packages/samplenote/sql/samplenote-drop.sql
+        is uninstalled.

[service0@yourserver postgresql]$ emacs samplenote-drop.sql

Figure�10.5.�Database deletion script

-- packages/samplenote/sql/samplenote-drop.sql
 -- drop script
 --
 -- @author rhs@mit.edu