From d96933356cda8f865a80245f17dd79a527d267b2 Mon Sep 17 00:00:00 2001
From: Vas Crabb <vas@vastheman.com>
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

