Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.4.0d3-5.4.0d4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.4.0d3-5.4.0d4.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.4.0d3-5.4.0d4.sql	17 Mar 2008 10:43:52 -0000	1.2
+++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.4.0d3-5.4.0d4.sql	7 Jun 2008 20:28:52 -0000	1.3
@@ -1,4 +1,11 @@
+-- checking if the privilege annotate is created, if not then just create it
+
+declare v_result integer;
 begin
+ select count(*) into v_result from acs_privileges where privilege = 'annotate';
+ if v_result < 1 then
+     acs_privilege.create_privilege('annotate');
+ end if;
  acs_privilege.add_child('admin', 'annotate');
  commit;
 end;