Index: openacs-4/packages/calendar/www/admin/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/admin/index-oracle.xql,v
diff -u -N
--- openacs-4/packages/calendar/www/admin/index-oracle.xql 5 Sep 2001 05:48:18 -0000 1.1
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,24 +0,0 @@
-
-
-
- oracle8.1.6
-
-
-
-
- select calendar_id,
- calendar_name
- from calendars
- where owner_id = :user_id
- and acs_permission.permission_p(
- calendar_id,
- :user_id,
- 'calendar_admin'
- ) = 't'
- order by calendar_name
-
-
-
-
-
-
Index: openacs-4/packages/calendar/www/admin/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/admin/index-postgresql.xql,v
diff -u -N
--- openacs-4/packages/calendar/www/admin/index-postgresql.xql 5 Sep 2001 05:48:18 -0000 1.1
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,24 +0,0 @@
-
-
-
- postgresql7.1
-
-
-
-
- select calendar_id,
- calendar_name
- from calendars
- where owner_id = :user_id
- and acs_permission__permission_p(
- calendar_id,
- :user_id,
- 'calendar_admin'
- ) = 't'
- order by calendar_name
-
-
-
-
-
-
Index: openacs-4/packages/calendar/www/cal-options-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/cal-options-oracle.xql,v
diff -u -N
--- openacs-4/packages/calendar/www/cal-options-oracle.xql 10 Jan 2004 18:59:50 -0000 1.2
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,35 +0,0 @@
-
-
-
- oracle8.1.6
-
-
-
-
-
- select calendar_id,
- calendar_name,
- ' ' as checked_p
- from calendars
- where acs_permission.permission_p(calendar_id, :user_id, 'calendar_read') = 't'
- and acs_permission.permission_p(calendar_id, :user_id, 'calendar_show') = 't'
- and private_p = 'f'
-
- union
-
- select calendar_id,
- calendar_name,
- ' ' as checked_p
- from cal_items, calendars
- where acs_permission.permission_p(cal_item_id, :user_id, 'cal_item_read') = 't'
- and calendar.private_p(on_which_calendar) = 'f'
- and calendars.private_p = 'f'
- and cal_items.on_which_calendar = calendars.calendar_id
-
-
-
-
-
-
-
-
Index: openacs-4/packages/calendar/www/cal-options-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/cal-options-postgresql.xql,v
diff -u -N
--- openacs-4/packages/calendar/www/cal-options-postgresql.xql 10 Jan 2004 18:59:50 -0000 1.4
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,34 +0,0 @@
-
-
-
- postgresql7.1
-
-
-
-
-
- select distinct(calendar_id) as calendar_id,
- calendar_name,
- ' '::varchar as checked_p
- from calendars
- where acs_permission__permission_p(calendar_id, :user_id, 'calendar_read') = 't'
- and acs_permission__permission_p(calendar_id, :user_id, 'calendar_show') = 't'
- and private_p = 'f'
-
- union
-
- select on_which_calendar as calendar_id,
- calendar_name,
- ' '::varchar as checked_p
- from cal_items, calendars
- where acs_permission__permission_p(cal_item_id, :user_id, 'cal_item_read') = 't'
- and calendars.private_p = 'f'
- and cal_items.on_which_calendar = calendars.calendar_id
-
-
-
-
-
-
-
-