-
Notifications
You must be signed in to change notification settings - Fork 0
/
Schema.plist
executable file
·84 lines (78 loc) · 2.51 KB
/
Schema.plist
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
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<array>
<string>CREATE TABLE sources (
location TEXT,
name TEXT,
maintainer TEXT,
contact TEXT,
url TEXT,
category TEXT,
description TEXT,
isTrusted INTEGER DEFAULT 0,
isUnsafe INTEGER DEFAULT 0,
hasErrors INTEGER DEFAULT 0,
lastrefresh REAL
);
</string>
<string>CREATE INDEX lastrefresh_idx ON sources ( lastrefresh );</string>
<string>CREATE TABLE packages (
source INTEGER,
identifier TEXT,
name TEXT,
moreURL TEXT,
customInfo TEXT,
version TEXT,
location TEXT,
size INTEGER,
hash TEXT,
maintainer TEXT,
contact TEXT,
description TEXT,
url TEXT,
category TEXT,
date REAL,
dependencies BLOB,
icon TEXT,
sponsor TEXT,
sponsorURL TEXT,
uninstallScript BLOB,
isInstalled INTEGER DEFAULT 0
);
</string>
<string>CREATE INDEX source_idx ON packages ( source );</string>
<string>CREATE INDEX date_idx ON packages ( date );</string>
<string>CREATE INDEX identifier_idx ON packages ( identifier );</string>
<string>CREATE INDEX installed_idx ON packages ( isInstalled );</string>
<string>ALTER TABLE sources ADD COLUMN icon TEXT;</string>
<string>DELETE FROM packages WHERE isInstalled <> 1;</string>
<string>CREATE TABLE search (
packageID INTEGER DEFAULT NULL,
sourceName TEXT,
sourceURL TEXT,
identifier TEXT,
name TEXT,
customInfo TEXT,
description TEXT,
version TEXT,
icon TEXT,
date REAL
);
</string>
<string>CREATE TABLE incomplete_downloads (
url TEXT,
path TEXT,
date REAL,
size INTEGER,
mod_date REAL
);
</string>
<string>ALTER TABLE packages ADD COLUMN rating REAL;</string>
<string>ALTER TABLE packages ADD COLUMN myRating REAL;</string>
<string>ALTER TABLE packages ADD COLUMN ratingRefresh REAL;</string>
<string>ALTER TABLE packages ADD COLUMN preflightScript BLOB;</string>
<string>ALTER TABLE packages ADD COLUMN postflightScript BLOB;</string>
<string>ALTER TABLE packages ADD COLUMN screenshots BLOB;</string>
</array>
</plist>