From 336787349480c39475aa048e6362ef57d06c691c Mon Sep 17 00:00:00 2001
From: helge <helge@d1b88da0-ebda-0310-925b-ed51d893ca5b>
Date: Tue, 29 Jun 2004 19:59:16 +0000
Subject: [PATCH] git-svn-id: http://svn.opengroupware.org/SOGo/trunk@82
 d1b88da0-ebda-0310-925b-ed51d893ca5b

---
 .../sql/appointment-hh-create.psql            | 24 +++++++++++++++++++
 1 file changed, 24 insertions(+)
 create mode 100644 OGoContentStore/sql/appointment-hh-create.psql

diff --git a/OGoContentStore/sql/appointment-hh-create.psql b/OGoContentStore/sql/appointment-hh-create.psql
new file mode 100644
index 00000000..747b7910
--- /dev/null
+++ b/OGoContentStore/sql/appointment-hh-create.psql
@@ -0,0 +1,24 @@
+-- $Id$
+--
+-- (C) 2004 SKYRIX Software AG
+--
+
+DROP TABLE SOGo_helge_privcal_quick;
+DROP TABLE SOGo_helge_privcal;
+
+CREATE TABLE SOGo_helge_privcal_quick (
+  c_name       VARCHAR(256)    NOT NULL PRIMARY KEY, -- the filename
+  uid          VARCHAR(256)    NOT NULL,
+  startdate    INT NOT NULL,
+  enddate      INT NOT NULL,
+  title        VARCHAR(1000)   NOT NULL,
+  participants VARCHAR(100000) NOT NULL
+);
+
+CREATE TABLE SOGo_helge_privcal (
+  c_name         VARCHAR(256)    NOT NULL PRIMARY KEY, -- the filename
+  c_content      VARCHAR(100000) NOT NULL, -- the BLOB
+  c_creationdate INT             NOT NULL, -- creation date
+  c_lastmodified INT             NOT NULL, -- last modification (UPDATE)
+  c_version      INT             NOT NULL  -- version counter
+);
-- 
2.39.5