Index: openacs-4/packages/logger/sql/oracle/logger-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/logger/sql/oracle/logger-tables-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/logger/sql/oracle/logger-tables-create.sql	6 Apr 2003 08:02:45 -0000	1.3
+++ openacs-4/packages/logger/sql/oracle/logger-tables-create.sql	22 Apr 2003 09:24:47 -0000	1.4
@@ -82,7 +82,10 @@
                         constraint logger_variables_type_nn
                         not null
                         constraint logger_variables_type_ck
-                        check (type in ('additive', 'non-additive'))
+                        check (type in ('additive', 'non-additive')),
+  package_id            integer
+                        constraint logger_project_var_map_pi_fk
+                        references apm_packages(package_id)
 );
 
 comment on column logger_variables.type is '
@@ -91,6 +94,10 @@
   a project. A non-additive variable would be the amount of money in a bank account.
 ';
 
+comment on column logger_variables.package_id is '
+  The id of the package that the variable was created in.
+';
+
 create sequence logger_variables_seq;
 
 create table logger_project_var_map (
