summaryrefslogtreecommitdiffstatshomepage
path: root/scripts/minimaws/schema.sql
diff options
context:
space:
mode:
author Vas Crabb <vas@vastheman.com>2017-08-04 17:13:34 +1000
committer Vas Crabb <vas@vastheman.com>2017-08-04 17:13:34 +1000
commitd96933356cda8f865a80245f17dd79a527d267b2 (patch)
treea500720df7ed9a0f413ed0e5633fec78ad28a179 /scripts/minimaws/schema.sql
parent0bdd1df2e33555ef9779c4a2106d3d8fea16c410 (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.sql12
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,