diff options
author | 2017-08-04 17:13:34 +1000 | |
---|---|---|
committer | 2017-08-04 17:13:34 +1000 | |
commit | d96933356cda8f865a80245f17dd79a527d267b2 (patch) | |
tree | a500720df7ed9a0f413ed0e5633fec78ad28a179 /scripts/minimaws/schema.sql | |
parent | 0bdd1df2e33555ef9779c4a2106d3d8fea16c410 (diff) |
minimaws: demonstrate slot card BIOS selection, requires exposing device BIOS sets in XML output
Diffstat (limited to 'scripts/minimaws/schema.sql')
-rw-r--r-- | scripts/minimaws/schema.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/scripts/minimaws/schema.sql b/scripts/minimaws/schema.sql index 86cec49cbcb..63e13c6c364 100644 --- a/scripts/minimaws/schema.sql +++ b/scripts/minimaws/schema.sql @@ -38,6 +38,18 @@ CREATE TABLE romof ( parent TEXT NOT NULL, FOREIGN KEY (id) REFERENCES machine (id)); +CREATE TABLE biosset ( + id INTEGER PRIMARY KEY, + machine INTEGER NOT NULL, + name TEXT NOT NULL, + description TEXT NOT NULL, + UNIQUE (machine ASC, name ASC), + FOREIGN KEY (machine) REFERENCES machine (id)); + +CREATE TABLE biossetdefault ( + id INTEGER PRIMARY KEY, + FOREIGN KEY (id) REFERENCES biosset (id)); + CREATE TABLE devicereference ( id INTEGER PRIMARY KEY, machine INTEGER NOT NULL, |