Index: openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql	21 Dec 2002 22:27:47 -0000	1.9
+++ openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql	25 Feb 2003 10:09:13 -0000	1.10
@@ -101,9 +101,6 @@
 -- Notification Types Package
 select define_function_args ('notification_type__new','type_id,sc_impl_id,short_name,pretty_name,description,creation_date,creation_user,creation_ip,context_id');
 
-select define_function_args ('notification_type__delete','type_id');
-
-
 -- implementation
 
 create function notification_type__new (integer,integer,varchar,varchar,varchar,timestamp with time zone,integer,varchar,integer)
@@ -148,10 +145,23 @@
 end;
 ' language 'plpgsql';
 
-select define_function_args ('notification_request__new','request_id,object_type;notification_request,type_id,user_id,object_id,interval_id,delivery_method_id,format,creation_date,creation_user,creation_ip,context_id');
+select define_function_args ('notification_request__new','request_id,object_type;notification_request,type_id,user_id,object_id,interval_id,delivery_method_id,format,dynamic_p;f,creation_date,creation_user,creation_ip,context_id');
 
-create function notification_request__new (integer,varchar,integer,integer,integer,integer,integer,varchar,timestamp with time zone,integer,varchar,integer)
-returns integer as '
+create function notification_request__new (
+       integer,                       -- request_id
+       varchar,                       -- object_type
+       integer,                       -- type_id
+       integer,                       -- user_id
+       integer,                       -- object_id
+       integer,                       -- interval_id
+       integer,                       -- delivery_method_id
+       varchar,                       -- format
+       bool,                          -- dynamic_p
+       timestamp with time zone,      -- creation_date
+       integer,                       -- creation_user
+       varchar,                       -- creation_ip
+       integer                        -- context_id
+) returns integer as '
 DECLARE
         p_request_id                            alias for $1;
         p_object_type                           alias for $2;
@@ -161,10 +171,11 @@
         p_interval_id                           alias for $6;
         p_delivery_method_id                    alias for $7;
         p_format                                alias for $8;
-        p_creation_date                         alias for $9;
-        p_creation_user                         alias for $10;
-        p_creation_ip                           alias for $11;
-        p_context_id                            alias for $12;
+        p_dynamic_p                             alias for $9;
+        p_creation_date                         alias for $10;
+        p_creation_user                         alias for $11;
+        p_creation_ip                           alias for $12;
+        p_context_id                            alias for $13;
         v_request_id                            integer;
 BEGIN
         v_request_id:= acs_object__new (
@@ -176,8 +187,8 @@
                                        p_context_id);
 
       insert into notification_requests
-      (request_id, type_id, user_id, object_id, interval_id, delivery_method_id, format) values
-      (v_request_id, p_type_id, p_user_id, p_object_id, p_interval_id, p_delivery_method_id, p_format);
+      (request_id, type_id, user_id, object_id, interval_id, delivery_method_id, format, dynamic_p) values
+      (v_request_id, p_type_id, p_user_id, p_object_id, p_interval_id, p_delivery_method_id, p_format, p_dynamic_p);
 
       return v_request_id;