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 column in PackageComments for pinning system.

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


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

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