github.com/jgbaldwinbrown/perf@v0.1.1/storage/db/schema.sql (about) 1 -- The intended production Cloud SQL schema. Committed here only as a 2 -- form of notes (see the actual current schema in 3 -- db.go:createTables). 4 5 CREATE TABLE Uploads ( 6 UploadId SERIAL PRIMARY KEY AUTO_INCREMENT 7 ); 8 CREATE TABLE Records ( 9 UploadId BIGINT UNSIGNED, 10 RecordId BIGINT UNSIGNED, 11 Contents BLOB, 12 PRIMARY KEY (UploadId, RecordId), 13 FOREIGN KEY (UploadId) REFERENCES Uploads(UploadId) 14 ); 15 CREATE TABLE RecordLabels ( 16 UploadId BIGINT UNSIGNED, 17 RecordId BIGINT UNSIGNED, 18 Name VARCHAR(255), 19 Value VARCHAR(8192), 20 INDEX (Name(100), Value(100)), 21 FOREIGN KEY (UploadId, RecordId) REFERENCES Records(UploadId, RecordId) 22 );