diff options
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, |