2 -- (C) 2004 SKYRIX Software AG
5 DROP TABLE SOGo_helge_privcal_quick;
6 DROP TABLE SOGo_helge_privcal;
8 CREATE TABLE SOGo_helge_privcal_quick (
9 c_name VARCHAR(256) NOT NULL PRIMARY KEY, -- the filename
10 uid VARCHAR(256) NOT NULL,
11 startdate INT NOT NULL,
13 cycleenddate INT NULL, -- enddate for cyclic events
14 title VARCHAR(1000) NOT NULL,
15 cycleinfo VARCHAR(1000) NULL, -- property list with cycle infos
16 participants VARCHAR(100000) NOT NULL, -- the CNs of the participants
18 iscycle INT NULL, -- client needs to fetch to resolve
19 ispublic INT NOT NULL,
22 location VARCHAR(256) NULL,
23 orgmail VARCHAR(256) NULL,
24 partmails VARCHAR(100000) NOT NULL, -- the emails of the participants
25 partstates VARCHAR(256) NOT NULL, -- the status of each participant
26 sequence INT NULL -- the iCal sequence
29 CREATE TABLE SOGo_helge_privcal (
30 c_name VARCHAR(256) NOT NULL PRIMARY KEY, -- the filename
31 c_content VARCHAR(100000) NOT NULL, -- the BLOB
32 c_creationdate INT NOT NULL, -- creation date
33 c_lastmodified INT NOT NULL, -- last modification (UPDATE)
34 c_version INT NOT NULL -- version counter