tC5yAUGD

1CREATE TABLE firmware_image
2(
3  device_type TINYINT UNSIGNED NOT NULL,
4  firmware_id VARCHAR(100) NOT NULL,
5  FirmwareImage BLOB NOT NULL, 
6  uploader INT UNSIGNED NOT NULL,
7  CONSTRAINT PK_firmware_image PRIMARY KEY (device_type, firmware_id), 
8  CONSTRAINT FK_fwi_dvt FOREIGN KEY (device_type) REFERENCES device_type(device_type_id),
9  CONSTRAINT FK_fwi_usr FOREIGN KEY (uploader) REFERENCES users(user_id)
10);
11	
12CREATE TABLE users
13(
14  user_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
15 CONSTRAINT PK PRIMARY KEY CLUSTERED (user_id ASC)
16);
17CREATE TABLE IF NOT EXISTS device_type
18(
19 device_type_id  TINYINT UNSIGNED AUTO_INCREMENT NOT NULL,
20 Name        VARCHAR(200) NOT NULL,
21
22 PRIMARY KEY (device_type_id)
23);