4.2.0.txt 430 Bytes
Newer Older
1
2
3
4
5
6
7
8
9
10
11
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);
----
Lukas Fleischer's avatar
Lukas Fleischer committed
12
13
14
15
16
17

2. Resize the email address field:

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