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  );