summaryrefslogtreecommitdiffstats
path: root/upgrading/4.2.0.txt
blob: 0bf9a31991d9b1d1da09f701b60434308da11fda (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
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
1. Add a new table to store providers from official packages:

----
CREATE TABLE OfficialProviders (
	ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
	Name VARCHAR(64) NOT NULL,
	Provides VARCHAR(64) NOT NULL,
	PRIMARY KEY (ID)
) ENGINE = InnoDB;
CREATE UNIQUE INDEX ProviderNameProvides ON OfficialProviders (Name, Provides);
----

2. Resize the email address field:

----
ALTER TABLE Users MODIFY Email VARCHAR(254) NOT NULL;
----

3. Add new columns to the PackageComments table:

----
ALTER TABLE PackageComments
	ADD COLUMN DelTS BIGINT UNSIGNED NULL DEFAULT NULL,
	ADD COLUMN PinnedTS BIGINT UNSIGNED NOT NULL DEFAULT 0;
----

4. Update the deletion time stamp of all deleted comments:

----
UPDATE PackageComments SET DelTS = EditedTS WHERE DelUsersID IS NOT NULL;
----

5. Add new column to store the closure comment of package requests:

----
ALTER TABLE PackageRequests ADD COLUMN ClosureComment TEXT NOT NULL DEFAULT '';
----

6. Change FlaggerComment from VARCHAR to TEXT:

----
ALTER TABLE PackageBases MODIFY COLUMN FlaggerComment TEXT NOT NULL DEFAULT '';
----

7. Rename the CommentNotify table to PackageNotifications:

----
ALTER TABLE CommentNotify RENAME TO PackageNotifications;
----

8. Add new columns to store notification settings:

----
ALTER TABLE Users
	ADD COLUMN CommentNotify TINYINT(1) NOT NULL DEFAULT 1,
	ADD COLUMN UpdateNotify TINYINT(1) NOT NULL DEFAULT 0;
----