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
SQLite format 3 @ .WJ
� � 4��
�
�
� U
�
� ���LB��( � � U) qindexIndexDocGenJobDocGenJobCREATE INDEX IndexDocGenJob ON DocGenJob (package)�+ �%tableDocGenJobDocGenJobCREATE TABLE DocGenJob (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
package TEXT NOT NULL REFERENCES Package(name),
version TEXT NOT NULL,
target TEXT NOT NULL,
useNative BOOLEAN NOT NULL,
capabilities TEXT NOT NULL,
state INTEGER NOT NULL,
queuedOn TIMESTAMP NOT NULL,
startedOn TIMESTAMP NOT NULL,
finishedOn TIMESTAMP NOT NULL,
lastUpdate TIMESTAMP NOT NULL,
triggerUser INTEGER REFERENCES RegistryUser(id),
triggerEvent INTEGER NOT NULL,
output TEXT NOT NULL
)y;1�indexIndexPackageVersionDocsPackageVersionDocsCREATE INDEX IndexPackageVersionDocs ON PackageVersionDocs(package)�111�
tablePackageVersionDocsPackageVersionDocsCREATE TABLE PackageVersionDocs (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
package TEXT NOT NULL REFERENCES Package(name),
version TEXT NOT NULL,
target TEXT NOT NULL,
isAttempted BOOLEAN NOT NULL,
isPresent BOOLEAN NOT NULL
)i3)�indexIndexPackageVersionPackageVersionCREATE INDEX IndexPackageVersion ON PackageVersion(package)�))�ItablePackageVersionPackageVersionCREATE TABLE PackageVersion (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
package TEXT NOT NULL REFERENCES Package(name),
version TEXT NOT NULL,
description TEXT NOT NULL,
upload TIMESTAMP NOT NULL,
uploadedBy INTEGER NOT NULL REFERENCES RegistryUser(id),
yanked BOOLEAN NOT NULL,
downloadCount INTEGER NOT NULL,
downloads BLOB,
depsLastCheck TIMESTAMP NOT NULL,
depsHasOutdated BOOLEAN NOT NULL,
depsHasCVEs BOOLEAN NOT NULL
)a/%}indexIndexPackageOwnerPackageOwnerCREATE INDEX IndexPackageOwner ON PackageOwner (package)�`%%�tablePackageOwnerPackageOwnerCREATE TABLE PackageOwner (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
package TEXT NOT NULL REFERENCES Package(name),
owner INTEGER NOT NULL REFERENCES RegistryUser(id)
)J
%cindexIndexPackagePackageCREATE INDEX IndexPackage ON Package (name)�r �;tablePackagePackage CREATE TABLE Package (
name TEXT NOT NULL PRIMARY KEY,
lowercase TEXT NOT NULL,
targets TEXT NOT NULL,
nativeTargets TEXT NOT NULL,
capabilities TEXT NOT NULL,
isDeprecated BOOLEAN NOT NULL
)- A indexsqlite_autoindex_Package_1Package
�[
33�]tableRegistryGlobalTokenRegistryGlobalToken CREATE TABLE RegistryGlobalToken (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
token TEXT NOT NULL,
lastUsed TIMESTAMP NOT NULL
)s 9/� indexIndexRegistryUserTokenRegistryUserToken
CREATE INDEX IndexRegistryUserToken ON RegistryUserToken (user)�J//�CtableRegistryUserTokenRegistryUserToken CREATE TABLE RegistryUserToken (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
user INTEGER NOT NULL REFERENCES RegistryUser(id),
name TEXT NOT NULL,
token TEXT NOT NULL,
lastUsed TIMESTAMP NOT NULL,
canWrite BOOLEAN NOT NULL,
canAdmin BOOLEAN NOT NULL
)n=%�indexIndexRegistryUserByLoginRegistryUserCREATE INDEX IndexRegistryUserByLogin ON RegistryUser (login)n=%�indexIndexRegistryUserByEmailRegistryUserCREATE INDEX IndexRegistryUserByEmail ON RegistryUser (email)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�v%%�/tableRegistryUserRegistryUserCREATE TABLE RegistryUser (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
isActive BOOLEAN NOT NULL,
email TEXT NOT NULL,
login TEXT NOT NULL,
name TEXT NOT NULL,
roles TEXT NOT NULL
)e3)}indexSchemaMetadataIndexSchemaMetadataCREATE INDEX SchemaMetadataIndex ON SchemaMetadata(name)�))�CtableSchemaMetadataSchemaMetadataCREATE TABLE SchemaMetadata (
name TEXT NOT NULL PRIMARY KEY,
value TEXT NOT NULL
);O) indexsqlite_autoindex_SchemaMetadata_1SchemaMetadata
� � version1.10.0
� �
version
� �
version