summaryrefslogtreecommitdiffstatshomepage
path: root/scripts/minimaws/schema.sql
diff options
context:
space:
mode:
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,