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 column in PackageComments for pinning system.
22 ALTER TABLE PackageComments ADD COLUMN PinnedTS BIGINT UNSIGNED NOT NULL DEFAULT 0;
26 3. Add new column to store the closure comment of package requests:
29 ALTER TABLE PackageRequests ADD COLUMN ClosureComment TEXT NOT NULL DEFAULT '';