blob: 37cbeae105f8aefd4bbd86d0cbb89d4d571b8458 (
plain)
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);
----
|