From 2a15911c472ba58339056485beedbf815a14a3b1 Mon Sep 17 00:00:00 2001
From: wolfgang <wolfgang@d1b88da0-ebda-0310-925b-ed51d893ca5b>
Date: Mon, 6 Aug 2007 19:43:46 +0000
Subject: [PATCH] git-svn-id:
 http://svn.opengroupware.org/SOGo/inverse/trunk@1136
 d1b88da0-ebda-0310-925b-ed51d893ca5b

---
 OGoContentStore/appointment-oracle.ocs | 108 +++++++++++++++++++++++++
 OGoContentStore/contact-oracle.ocs     |  58 +++++++++++++
 2 files changed, 166 insertions(+)
 create mode 100644 OGoContentStore/appointment-oracle.ocs
 create mode 100644 OGoContentStore/contact-oracle.ocs

diff --git a/OGoContentStore/appointment-oracle.ocs b/OGoContentStore/appointment-oracle.ocs
new file mode 100644
index 00000000..96769c60
--- /dev/null
+++ b/OGoContentStore/appointment-oracle.ocs
@@ -0,0 +1,108 @@
+{
+  blobTablePattern = "SOGo_$folderId$_blob";
+  quickTablePattern = "SOGo_$folderId$_quick";
+  extractorClassName = "OCSiCalFieldExtractor";
+
+  fields = (
+    {
+      columnName = c_name;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = NO;
+    },
+    {
+      columnName = c_uid;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = NO;
+    },
+    {
+      columnName = c_startdate;
+      sqlType    = "INTEGER";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_enddate;
+      sqlType    = "INTEGER";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_cycleenddate;
+      sqlType    = "INTEGER";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_title;
+      sqlType    = "VARCHAR2(1000)";
+      allowsNull = NO;
+    },
+    {
+      columnName = c_participants;
+      sqlType    = "CLOB";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_isallday;
+      sqlType    = "INTEGER";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_iscycle;
+      sqlType    = "INTEGER";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_cycleinfo;
+      sqlType    = "VARCHAR2(1000)";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_classification;
+      sqlType    = "INTEGER";
+      allowsNull = NO;
+    },
+    {
+      columnName = c_isopaque;
+      sqlType    = "INTEGER";
+      allowsNull = NO;
+    },
+    {
+      columnName = c_status;
+      sqlType    = "INTEGER";
+      allowsNull = NO;
+    },
+    {
+      columnName = c_priority;
+      sqlType    = "INTEGER";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_location;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_orgmail;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_partmails;
+      sqlType    = "CLOB";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_partstates;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_sequence;
+      sqlType    = "INTEGER";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_component;
+      sqlType    = "VARCHAR2(10)";
+      allowsNull = NO;
+    },
+  );
+}
diff --git a/OGoContentStore/contact-oracle.ocs b/OGoContentStore/contact-oracle.ocs
new file mode 100644
index 00000000..1174d649
--- /dev/null
+++ b/OGoContentStore/contact-oracle.ocs
@@ -0,0 +1,58 @@
+{
+  blobTablePattern  = "SOGo_$folderId$_blob";
+  quickTablePattern = "SOGo_$folderId$_quick";
+  extractorClassName= "OCSContactFieldExtractor";
+
+  fields = (
+    {
+      columnName = c_name;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = NO;
+    },
+    {
+      columnName = c_givenname;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_cn;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_sn;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_screenname;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_l;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_mail;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_o;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_ou;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = YES;
+    },
+    {
+      columnName = c_telephoneNumber;
+      sqlType    = "VARCHAR2(256)";
+      allowsNull = YES;
+    },
+  );
+}
-- 
2.39.5