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
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
|
--
-- Created by SQL::Translator::Producer::SQLite
-- Created on Fri Jan 25 14:12:02 2013
--
BEGIN TRANSACTION;
--
-- Table: acl_history
--
DROP TABLE IF EXISTS acl_history;
CREATE TABLE acl_history (
ah_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
ah_acl integer NOT NULL,
ah_action varchar(16) NOT NULL,
ah_scheme varchar(32),
ah_identifier varchar(255),
ah_by varchar(255) NOT NULL,
ah_from varchar(255) NOT NULL,
ah_on datetime NOT NULL
);
--
-- Table: acl_schemes
--
DROP TABLE IF EXISTS acl_schemes;
CREATE TABLE acl_schemes (
as_name varchar(32) NOT NULL,
as_class varchar(64),
PRIMARY KEY (as_name)
);
--
-- Table: acls
--
DROP TABLE IF EXISTS acls;
CREATE TABLE acls (
ac_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
ac_name varchar(255) NOT NULL
);
CREATE UNIQUE INDEX ac_name ON acls (ac_name);
--
-- Table: enctypes
--
DROP TABLE IF EXISTS enctypes;
CREATE TABLE enctypes (
en_name varchar(255) NOT NULL,
PRIMARY KEY (en_name)
);
--
-- Table: flags
--
DROP TABLE IF EXISTS flag_names;
CREATE TABLE flag_names (
fn_name varchar(32) NOT NULL,
PRIMARY KEY (fn_name)
);
--
-- Table: flags
--
DROP TABLE IF EXISTS flags;
CREATE TABLE flags (
fl_type varchar(16) NOT NULL,
fl_name varchar(255) NOT NULL,
fl_flag varchar(32) NOT NULL,
PRIMARY KEY (fl_type, fl_name, fl_flag)
);
--
-- Table: keytab_enctypes
--
DROP TABLE IF EXISTS keytab_enctypes;
CREATE TABLE keytab_enctypes (
ke_name varchar(255) NOT NULL,
ke_enctype varchar(255) NOT NULL,
PRIMARY KEY (ke_name, ke_enctype)
);
--
-- Table: keytab_sync
--
DROP TABLE IF EXISTS keytab_sync;
CREATE TABLE keytab_sync (
ks_name varchar(255) NOT NULL,
ks_target varchar(255) NOT NULL,
PRIMARY KEY (ks_name, ks_target)
);
--
-- Table: metadata
--
DROP TABLE IF EXISTS metadata;
CREATE TABLE metadata (
md_version integer
);
--
-- Table: sync_targets
--
DROP TABLE IF EXISTS sync_targets;
CREATE TABLE sync_targets (
st_name varchar(255) NOT NULL,
PRIMARY KEY (st_name)
);
--
-- Table: types
--
DROP TABLE IF EXISTS types;
CREATE TABLE types (
ty_name varchar(16) NOT NULL,
ty_class varchar(64),
PRIMARY KEY (ty_name)
);
--
-- Table: acl_entries
--
DROP TABLE IF EXISTS acl_entries;
CREATE TABLE acl_entries (
ae_id integer NOT NULL,
ae_scheme varchar(32) NOT NULL,
ae_identifier varchar(255) NOT NULL,
PRIMARY KEY (ae_id, ae_scheme, ae_identifier),
FOREIGN KEY(ae_scheme) REFERENCES acl_schemes(as_name),
FOREIGN KEY(ae_id) REFERENCES acls(ac_id)
);
CREATE INDEX acl_entries_idx_ae_scheme ON acl_entries (ae_scheme);
CREATE INDEX acl_entries_idx_ae_id ON acl_entries (ae_id);
--
-- Table: objects
--
DROP TABLE IF EXISTS objects;
CREATE TABLE objects (
ob_type varchar(16) NOT NULL,
ob_name varchar(255) NOT NULL,
ob_owner integer,
ob_acl_get integer,
ob_acl_store integer,
ob_acl_show integer,
ob_acl_destroy integer,
ob_acl_flags integer,
ob_expires datetime,
ob_created_by varchar(255) NOT NULL,
ob_created_from varchar(255) NOT NULL,
ob_created_on datetime NOT NULL,
ob_stored_by varchar(255),
ob_stored_from varchar(255),
ob_stored_on datetime,
ob_downloaded_by varchar(255),
ob_downloaded_from varchar(255),
ob_downloaded_on datetime,
PRIMARY KEY (ob_name, ob_type),
FOREIGN KEY(ob_acl_destroy) REFERENCES acls(ac_id),
FOREIGN KEY(ob_acl_flags) REFERENCES acls(ac_id),
FOREIGN KEY(ob_acl_get) REFERENCES acls(ac_id),
FOREIGN KEY(ob_owner) REFERENCES acls(ac_id),
FOREIGN KEY(ob_acl_show) REFERENCES acls(ac_id),
FOREIGN KEY(ob_acl_store) REFERENCES acls(ac_id),
FOREIGN KEY(ob_type) REFERENCES types(ty_name)
);
CREATE INDEX objects_idx_ob_acl_destroy ON objects (ob_acl_destroy);
CREATE INDEX objects_idx_ob_acl_flags ON objects (ob_acl_flags);
CREATE INDEX objects_idx_ob_acl_get ON objects (ob_acl_get);
CREATE INDEX objects_idx_ob_owner ON objects (ob_owner);
CREATE INDEX objects_idx_ob_acl_show ON objects (ob_acl_show);
CREATE INDEX objects_idx_ob_acl_store ON objects (ob_acl_store);
CREATE INDEX objects_idx_ob_type ON objects (ob_type);
--
-- Table: object_history
--
DROP TABLE IF EXISTS object_history;
CREATE TABLE object_history (
oh_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
oh_type varchar(16) NOT NULL,
oh_name varchar(255) NOT NULL,
oh_action varchar(16) NOT NULL,
oh_field varchar(16),
oh_type_field varchar(255),
oh_old varchar(255),
oh_new varchar(255),
oh_by varchar(255) NOT NULL,
oh_from varchar(255) NOT NULL,
oh_on datetime NOT NULL,
FOREIGN KEY(oh_type) REFERENCES objects(ob_type)
);
CREATE INDEX object_history_idx_oh_type_oh_name ON object_history (oh_type, oh_name);
COMMIT;
|
