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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
|
-- $Horde: horde/scripts/upgrades/3.1_to_3.2.sql,v 1.2.2.16 2008/06/11 08:06:12 jan Exp $
CREATE TABLE horde_syncml_map (
syncml_syncpartner VARCHAR(255) NOT NULL,
syncml_db VARCHAR(255) NOT NULL,
syncml_uid VARCHAR(255) NOT NULL,
syncml_cuid VARCHAR(255),
syncml_suid VARCHAR(255),
syncml_timestamp BIGINT
);
CREATE INDEX syncml_syncpartner_idx ON horde_syncml_map (syncml_syncpartner);
CREATE INDEX syncml_db_idx ON horde_syncml_map (syncml_db);
CREATE INDEX syncml_uid_idx ON horde_syncml_map (syncml_uid);
CREATE INDEX syncml_cuid_idx ON horde_syncml_map (syncml_cuid);
CREATE INDEX syncml_suid_idx ON horde_syncml_map (syncml_suid);
CREATE TABLE horde_syncml_anchors(
syncml_syncpartner VARCHAR(255) NOT NULL,
syncml_db VARCHAR(255) NOT NULL,
syncml_uid VARCHAR(255) NOT NULL,
syncml_clientanchor VARCHAR(255),
syncml_serveranchor VARCHAR(255)
);
CREATE INDEX syncml_anchors_syncpartner_idx ON horde_syncml_anchors (syncml_syncpartner);
CREATE INDEX syncml_anchors_db_idx ON horde_syncml_anchors (syncml_db);
CREATE INDEX syncml_anchors_uid_idx ON horde_syncml_anchors (syncml_uid);
DELETE FROM horde_datatree WHERE group_uid = 'syncml';
CREATE TABLE horde_alarms (
alarm_id VARCHAR(255) NOT NULL,
alarm_uid VARCHAR(255),
alarm_start DATETIME NOT NULL,
alarm_end DATETIME,
alarm_methods VARCHAR(255),
alarm_params TEXT,
alarm_title VARCHAR(255) NOT NULL,
alarm_text TEXT,
alarm_snooze DATETIME,
alarm_dismissed SMALLINT DEFAULT 0 NOT NULL,
alarm_internal TEXT
);
CREATE INDEX alarm_id_idx ON horde_alarms (alarm_id);
CREATE INDEX alarm_user_idx ON horde_alarms (alarm_uid);
CREATE INDEX alarm_start_idx ON horde_alarms (alarm_start);
CREATE INDEX alarm_end_idx ON horde_alarms (alarm_end);
CREATE INDEX alarm_snooze_idx ON horde_alarms (alarm_snooze);
CREATE INDEX alarm_dismissed_idx ON horde_alarms (alarm_dismissed);
CREATE TABLE horde_cache (
cache_id VARCHAR(32) NOT NULL,
cache_timestamp BIGINT NOT NULL,
cache_expiration BIGINT NOT NULL,
cache_data LONGBLOB,
-- Or on some other DBMS systems:
-- cache_data IMAGE,
PRIMARY KEY (cache_id)
);
CREATE TABLE horde_groups (
group_uid INTEGER NOT NULL,
group_name VARCHAR(255) NOT NULL,
group_parents VARCHAR(255) NOT NULL,
group_email VARCHAR(255),
PRIMARY KEY (group_uid)
);
CREATE TABLE horde_groups_members (
group_uid INTEGER NOT NULL,
user_uid VARCHAR(255) NOT NULL
);
CREATE INDEX group_uid_idx ON horde_groups_members (group_uid);
CREATE INDEX user_uid_idx ON horde_groups_members (user_uid);
CREATE TABLE horde_perms (
perm_id INTEGER NOT NULL,
perm_name VARCHAR(255) NOT NULL,
perm_parents VARCHAR(255) NOT NULL,
perm_data TEXT,
PRIMARY KEY (perm_id)
);
CREATE INDEX datatree_attribute_value_idx ON horde_datatree_attributes (attribute_value);
CREATE TABLE horde_locks (
lock_id VARCHAR(36) NOT NULL,
lock_owner VARCHAR(32) NOT NULL,
lock_scope VARCHAR(32) NOT NULL,
lock_principal VARCHAR(255) NOT NULL,
lock_origin_timestamp BIGINT NOT NULL,
lock_update_timestamp BIGINT NOT NULL,
lock_expiry_timestamp BIGINT NOT NULL,
lock_type SMALLINT NOT NULL,
PRIMARY KEY (lock_id)
);
|
