From fd3f90e9bd96939a35a92d9458b687a6d6075ba2 Mon Sep 17 00:00:00 2001
From: wolfgang <wolfgang@d1b88da0-ebda-0310-925b-ed51d893ca5b>
Date: Mon, 27 Aug 2007 15:55:55 +0000
Subject: [PATCH] git-svn-id:
 http://svn.opengroupware.org/SOGo/inverse/trunk@1157
 d1b88da0-ebda-0310-925b-ed51d893ca5b

---
 UI/MainUI/AgenorProfile-oracle.sql |  9 +++++++++
 UI/MainUI/OCSFolderInfo-oracle.sql | 27 +++++++++++++++++++++++++++
 2 files changed, 36 insertions(+)
 create mode 100644 UI/MainUI/AgenorProfile-oracle.sql
 create mode 100644 UI/MainUI/OCSFolderInfo-oracle.sql

diff --git a/UI/MainUI/AgenorProfile-oracle.sql b/UI/MainUI/AgenorProfile-oracle.sql
new file mode 100644
index 00000000..240af39e
--- /dev/null
+++ b/UI/MainUI/AgenorProfile-oracle.sql
@@ -0,0 +1,9 @@
+--
+-- (C) 2007 Inverse groupe conseil
+--
+
+CREATE TABLE SOGo_user_profile (
+  c_uid      VARCHAR(255) NOT NULL PRIMARY KEY,
+  c_defaults CLOB,
+  c_settings CLOB
+);
diff --git a/UI/MainUI/OCSFolderInfo-oracle.sql b/UI/MainUI/OCSFolderInfo-oracle.sql
new file mode 100644
index 00000000..c019e486
--- /dev/null
+++ b/UI/MainUI/OCSFolderInfo-oracle.sql
@@ -0,0 +1,27 @@
+--
+-- (C) 2007 Inverse groupe conseil
+--
+
+CREATE TABLE SOGo_folder_info (
+  c_folder_id      INTEGER PRIMARY KEY,
+  c_path           VARCHAR(255)  NOT NULL, -- the full path to the folder
+  c_path1          VARCHAR(255)  NOT NULL, -- parts (for fast queries)
+  c_path2          VARCHAR(255)  NULL,     -- parts (for fast queries)
+  c_path3          VARCHAR(255)  NULL,     -- parts (for fast queries)
+  c_path4          VARCHAR(255)  NULL,     -- parts (for fast queries)
+  c_foldername     VARCHAR(255)  NOT NULL, -- last path component
+  c_location       VARCHAR(2048) NOT NULL, -- URL to folder
+  c_quick_location VARCHAR(2048) NULL,     -- URL to quicktable of folder
+  c_acl_location   VARCHAR(2048) NULL,     -- URL to quicktable of folder
+  c_folder_type    VARCHAR(255)  NOT NULL  -- the folder type ...
+);
+
+CREATE SEQUENCE SOGo_folder_info_seq;
+CREATE OR REPLACE TRIGGER SOGo_folder_info_autonumber
+BEFORE INSERT ON SOGo_folder_info FOR EACH ROW
+BEGIN
+    IF :new.c_folder_id IS NULL THEN
+        SELECT SOGO_folder_info_seq.nextval INTO :new.c_folder_id FROM DUAL;
+    END IF;
+END;
+/
-- 
2.39.5