From 0a4b11805500c09febe327061d8093367d957b1d Mon Sep 17 00:00:00 2001 From: znek Date: Fri, 10 Dec 2004 13:25:57 +0000 Subject: [PATCH] fixes to the scripts git-svn-id: http://svn.opengroupware.org/SOGo/trunk@468 d1b88da0-ebda-0310-925b-ed51d893ca5b --- OGoContentStore/ChangeLog | 4 ++++ OGoContentStore/Version | 2 +- OGoContentStore/sql/foldertablecreate-helge-privcal.psql | 4 ++++ OGoContentStore/sql/generate-folderinfo-sql-for-users.sh | 5 +++-- 4 files changed, 12 insertions(+), 3 deletions(-) diff --git a/OGoContentStore/ChangeLog b/OGoContentStore/ChangeLog index 25d37c9a..4b2cdc35 100644 --- a/OGoContentStore/ChangeLog +++ b/OGoContentStore/ChangeLog @@ -1,3 +1,7 @@ +2004-12-10 Marcus Mueller + + * sql: updated all generation scripts to the latest version (v0.9.15) + 2004-12-09 Marcus Mueller * v0.9.14 diff --git a/OGoContentStore/Version b/OGoContentStore/Version index d6061d93..3b1ed5fd 100644 --- a/OGoContentStore/Version +++ b/OGoContentStore/Version @@ -2,7 +2,7 @@ MAJOR_VERSION=0 MINOR_VERSION=9 -SUBMINOR_VERSION:=14 +SUBMINOR_VERSION:=15 # v0.9.11 requires libFoundation v1.0.63 # v0.9.11 requires libNGExtensions v4.3.125 diff --git a/OGoContentStore/sql/foldertablecreate-helge-privcal.psql b/OGoContentStore/sql/foldertablecreate-helge-privcal.psql index 8195c25e..11334170 100644 --- a/OGoContentStore/sql/foldertablecreate-helge-privcal.psql +++ b/OGoContentStore/sql/foldertablecreate-helge-privcal.psql @@ -15,7 +15,11 @@ CREATE TABLE SOGo_helge_privcal_quick ( participants VARCHAR(100000) NOT NULL, -- the CNs of the participants isallday INT NULL, iscycle INT NULL, -- client needs to fetch to resolve + ispublic INT NOT NULL, + status INT NOT NULL, + isopaque INT NULL, location VARCHAR(256) NULL, + orgmail VARCHAR(256) NULL, partmails VARCHAR(100000) NOT NULL, -- the emails of the participants sequence INT NULL -- the iCal sequence ); diff --git a/OGoContentStore/sql/generate-folderinfo-sql-for-users.sh b/OGoContentStore/sql/generate-folderinfo-sql-for-users.sh index 6eac182c..c483679a 100755 --- a/OGoContentStore/sql/generate-folderinfo-sql-for-users.sh +++ b/OGoContentStore/sql/generate-folderinfo-sql-for-users.sh @@ -77,7 +77,7 @@ CREATE TABLE SOGo_${USER_TABLE}_privcal_quick ( isallday INT NULL, iscycle INT NULL, -- client needs to fetch to resolve ispublic INT NOT NULL, - istentative INT NULL, + status INT NOT NULL, isopaque INT NULL, location VARCHAR(256) NULL, orgmail VARCHAR(256) NULL, @@ -89,7 +89,8 @@ CREATE TABLE SOGo_${USER_TABLE}_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_lastmodified INT NOT NULL, -- last modification (UPDATE) + c_version INT NOT NULL -- version counter ); DROP TABLE SOGo_${USER_TABLE}_contacts_quick; -- 2.39.5