From d96933356cda8f865a80245f17dd79a527d267b2 Mon Sep 17 00:00:00 2001 From: Vas Crabb Date: Fri, 4 Aug 2017 17:13:34 +1000 Subject: minimaws: demonstrate slot card BIOS selection, requires exposing device BIOS sets in XML output --- scripts/minimaws/schema.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'scripts/minimaws/schema.sql') 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, -- cgit v1.2.3-70-g09d2