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.sql119
1 files changed, 0 insertions, 119 deletions
diff --git a/scripts/minimaws/schema.sql b/scripts/minimaws/schema.sql
deleted file mode 100644
index 63e13c6c364..00000000000
--- a/scripts/minimaws/schema.sql
+++ /dev/null
@@ -1,119 +0,0 @@
-PRAGMA page_size = 4096;
-PRAGMA foreign_keys = ON;
-
-CREATE TABLE featuretype (
- id INTEGER PRIMARY KEY,
- name TEXT NOT NULL,
- UNIQUE (name ASC));
-
-CREATE TABLE sourcefile (
- id INTEGER PRIMARY KEY,
- filename TEXT NOT NULL,
- UNIQUE (filename ASC));
-
-CREATE TABLE machine (
- id INTEGER PRIMARY KEY,
- shortname TEXT NOT NULL,
- description TEXT NOT NULL,
- sourcefile INTEGER NOT NULL,
- isdevice INTEGER NOT NULL,
- runnable INTEGER NOT NULL,
- UNIQUE (shortname ASC),
- UNIQUE (description ASC),
- FOREIGN KEY (sourcefile) REFERENCES sourcefile (id));
-
-CREATE TABLE system (
- id INTEGER PRIMARY KEY,
- year TEXT NOT NULL,
- manufacturer TEXT NOT NULL,
- FOREIGN KEY (id) REFERENCES machine (id));
-
-CREATE TABLE cloneof (
- id INTEGER PRIMARY KEY,
- parent TEXT NOT NULL,
- FOREIGN KEY (id) REFERENCES machine (id));
-
-CREATE TABLE romof (
- id INTEGER PRIMARY KEY,
- 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,
- device INTEGER NOT NULL,
- UNIQUE (machine ASC, device ASC),
- FOREIGN KEY (machine) REFERENCES machine (id),
- FOREIGN KEY (device) REFERENCES machine (id));
-
-CREATE TABLE dipswitch (
- id INTEGER PRIMARY KEY,
- machine INTEGER NOT NULL,
- isconfig INTEGER NOT NULL,
- name TEXT NOT NULL,
- tag TEXT NOT NULL,
- mask INTEGER NOT NULL,
- --UNIQUE (machine ASC, tag ASC, mask ASC), not necessarily true, need to expose port conditions
- FOREIGN KEY (machine) REFERENCES machine (id));
-
-CREATE TABLE diplocation (
- id INTEGER PRIMARY KEY,
- dipswitch INTEGER NOT NULL,
- bit INTEGER NOT NULL,
- name TEXT NOT NULL,
- num INTEGER NOT NULL,
- inverted INTEGER NOT NULL,
- UNIQUE (dipswitch ASC, bit ASC),
- FOREIGN KEY (dipswitch) REFERENCES dipswitch (id));
-
-CREATE TABLE dipvalue (
- id INTEGER PRIMARY KEY,
- dipswitch INTEGER NOT NULL,
- name TEXT NOT NULL,
- value INTEGER NOT NULL,
- isdefault INTEGER NOT NULL,
- FOREIGN KEY (dipswitch) REFERENCES dipswitch (id));
-
-CREATE TABLE feature (
- id INTEGER PRIMARY KEY,
- machine INTEGER NOT NULL,
- featuretype INTEGER NOT NULL,
- status INTEGER NOT NULL,
- overall INTEGER NOT NULL,
- UNIQUE (machine ASC, featuretype ASC),
- FOREIGN KEY (machine) REFERENCES machine (id),
- FOREIGN KEY (featuretype) REFERENCES featuretype (id));
-
-CREATE TABLE slot (
- id INTEGER PRIMARY KEY,
- machine INTEGER NOT NULL,
- name TEXT NOT NULL,
- UNIQUE (machine ASC, name ASC),
- FOREIGN KEY (machine) REFERENCES machine (id));
-
-CREATE TABLE slotoption (
- id INTEGER PRIMARY KEY,
- slot INTEGER NOT NULL,
- device INTEGER NOT NULL,
- name TEXT NOT NULL,
- UNIQUE (slot ASC, name ASC),
- FOREIGN KEY (slot) REFERENCES slot (id),
- FOREIGN KEY (device) REFERENCES machine (id));
-
-CREATE TABLE slotdefault (
- id INTEGER PRIMARY KEY,
- slotoption INTEGER NOT NULL,
- FOREIGN KEY (id) REFERENCES slot (id),
- FOREIGN KEY (slotoption) REFERENCES slotoption (id));