summaryrefslogtreecommitdiffstats
path: root/upgrading/4.0.0.txt
blob: b1582f2f10b7b9a3c676b9ee3ef9b4b1af560f63 (plain)
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
1. Add a field for the SSH public key to the Users table:

----
ALTER TABLE Users ADD COLUMN SSHPubKey VARCHAR(4096) NULL DEFAULT NULL;
----

2. Create a new user and set up a patched version of the sshd as
described in INSTALL.

3. Create a directory for the package base Git repositories and run
init-repos.py to initialize them.

4. Reset the packager field of all package bases:

----
UPDATE PackageBases SET PackagerUID = NULL;
----

5. Create a new table for package base co-maintainers:

----
CREATE TABLE PackageComaintainers (
	UsersID INTEGER UNSIGNED NOT NULL,
	PackageBaseID INTEGER UNSIGNED NOT NULL,
	INDEX (UsersID),
	INDEX (PackageBaseID),
	FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE,
	FOREIGN KEY (PackageBaseID) REFERENCES PackageBases(ID) ON DELETE CASCADE
) ENGINE = InnoDB;
----

6. (optional) Setup cgit to browse the Git repositories via HTTP.