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
|
DROP TABLE package_files;
DROP TABLE package_urls;
CREATE TABLE release_files (
name TEXT,
version TEXT,
python_version TEXT,
packagetype TEXT,
comment_text TEXT,
filename TEXT UNIQUE,
md5_digest TEXT UNIQUE,
FOREIGN KEY (name, version) REFERENCES releases (name, version)
);
CREATE INDEX release_files_name_idx ON release_files(name);
CREATE INDEX release_files_version_idx ON release_files(version);
CREATE INDEX release_files_packagetype_idx ON release_files(packagetype);
CREATE TABLE release_urls (
name TEXT,
version TEXT,
url TEXT,
packagetype TEXT,
FOREIGN KEY (name, version) REFERENCES releases (name, version)
);
CREATE INDEX release_urls_name_idx ON release_urls(name);
CREATE INDEX release_urls_version_idx ON release_urls(version);
CREATE INDEX release_urls_packagetype_idx ON release_urls(packagetype);
ALTER TABLE users DROP COLUMN public_key;
ALTER TABLE USERS ADD COLUMN gpg_keyid TEXT;
|