1 1. Add a new table to store providers from official packages:
4 CREATE TABLE OfficialProviders (
5 ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
6 Name VARCHAR(64) NOT NULL,
7 Provides VARCHAR(64) NOT NULL,
10 CREATE UNIQUE INDEX ProviderNameProvides ON OfficialProviders (Name, Provides);
13 2. Resize the email address field:
16 ALTER TABLE Users MODIFY Email VARCHAR(254) NOT NULL;
19 3. Add new columns to the PackageComments table:
22 ALTER TABLE PackageComments
23 ADD COLUMN DelTS BIGINT UNSIGNED NULL DEFAULT NULL,
24 ADD COLUMN PinnedTS BIGINT UNSIGNED NOT NULL DEFAULT 0;
27 4. Update the deletion time stamp of all deleted comments:
30 UPDATE PackageComments SET DelTS = EditedTS WHERE DelUsersID IS NOT NULL;
33 5. Add new column to store the closure comment of package requests:
36 ALTER TABLE PackageRequests ADD COLUMN ClosureComment TEXT NOT NULL DEFAULT '';
39 6. Change FlaggerComment from VARCHAR to TEXT:
42 ALTER TABLE PackageBases MODIFY COLUMN FlaggerComment TEXT NOT NULL DEFAULT '';
45 7. Rename the CommentNotify table to PackageNotifications:
48 ALTER TABLE CommentNotify RENAME TO PackageNotifications;
51 8. Add new columns to store notification settings:
55 ADD COLUMN CommentNotify TINYINT(1) NOT NULL DEFAULT 1,
56 ADD COLUMN UpdateNotify TINYINT(1) NOT NULL DEFAULT 0;