1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
-- $Horde: turba/scripts/sql/turba_objects.mssql.sql,v 1.1.2.1 2006/01/18 19:59:40 ben Exp $
CREATE TABLE turba_objects (
object_id VARCHAR(32) NOT NULL,
owner_id VARCHAR(255) NOT NULL,
object_type VARCHAR(255) NOT NULL DEFAULT 'Object',
object_uid VARCHAR(255),
object_members BLOB,
object_name VARCHAR(255),
object_alias VARCHAR(32),
object_email VARCHAR(255),
object_homeaddress VARCHAR(255),
object_workaddress VARCHAR(255),
object_homephone VARCHAR(25),
object_workphone VARCHAR(25),
object_cellphone VARCHAR(25),
object_fax VARCHAR(25),
object_title VARCHAR(255),
object_company VARCHAR(255),
object_notes VARCHAR(MAX),
object_pgppublickey VARCHAR(MAX),
object_smimepublickey VARCHAR(MAX),
object_freebusyurl VARCHAR(255),
--
PRIMARY KEY(object_id)
);
CREATE INDEX turba_owner_idx ON turba_objects (owner_id);
GRANT SELECT, INSERT, UPDATE, DELETE ON turba_objects TO horde;
|
