Index: openacs-4/packages/calendar/sql/oracle/calendar-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/oracle/calendar-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/calendar/sql/oracle/calendar-create.sql	19 Jan 2002 23:45:46 -0000	1.2
+++ openacs-4/packages/calendar/sql/oracle/calendar-create.sql	16 Mar 2002 21:06:44 -0000	1.3
@@ -221,6 +221,27 @@
 ';
 
 
+----------------------------
+-- Event Types for Calendars
+----------------------------
+
+create sequence cal_item_type_seq;
+
+create table cal_item_types (
+       item_type_id              integer not null
+                                 constraint cal_item_type_id_pk
+                                 primary key,
+       calendar_id               integer not null
+                                 constraint cal_item_type_cal_id_fk     
+                                 references calendars(calendar_id),
+       type                      varchar(100) not null,
+       -- this constraint is obvious given that item_type_id
+       -- is unique, but it's necessary to allow strong
+       -- references to the pair calendar_id, item_type_id (ben)
+       constraint cal_item_types_un
+       unique (calendar_id, item_type_id)
+);
+
 -------------------------------------------------------------
 -- Load cal_item_object
 -------------------------------------------------------------