3 -- (C) 2004 SKYRIX Software AG
6 CREATE TABLE %s_quick (
7 c_name VARCHAR(256) NOT NULL PRIMARY KEY, -- the filename
8 uid VARCHAR(256) NOT NULL,
9 startdate INT NOT NULL,
11 title VARCHAR(1000) NOT NULL,
12 participants VARCHAR(100000) NOT NULL, -- the CNs of the participants
14 iscycle INT NULL, -- client needs to fetch to resolve
15 ispublic INT NOT NULL,
18 location VARCHAR(256) NULL,
19 orgmail VARCHAR(256) NULL,
20 partmails VARCHAR(100000) NOT NULL, -- the emails of the participants
21 partstates VARCHAR(256) NOT NULL, -- the status of each participant
22 sequence INT NULL -- the iCal sequence
25 CREATE TABLE %s_blob (
26 c_name VARCHAR(256) NOT NULL PRIMARY KEY, -- the filename
27 c_content VARCHAR(100000) NOT NULL, -- the BLOB
28 c_creationdate INT NOT NULL, -- creation date
29 c_lastmodified INT NOT NULL, -- last modification (UPDATE)
30 c_version INT NOT NULL, -- version counter