1 files changed, 83 insertions, 0 deletions
diff --git a/application/configs/db.sql b/application/configs/db.sql
new file mode 100644
index 0000000..48efbe3
--- /dev/null
+++ b/application/configs/db.sql
@@ -0,0 +1,83 @@
+CREATE TABLE pbs (
+    id INTEGER PRIMARY KEY,
+	attribute TEXT,
+	val TEXT
+);
+
+INSERT INTO pbs (attribute, val) VALUES ("version", "0.1");
+INSERT INTO pbs (attribute, val) VALUES ("location", "http://pbs.lan/");
+INSERT INTO pbs (attribute, val) VALUES ("uclibrootfs-version", "1");
+
+CREATE TABLE systems (
+	id INTEGER PRIMARY KEY,
+	external_id TEXT,
+	append TEXT,
+	description TEXT,
+	initrd TEXT,
+	kernel TEXT,
+	name TEXT,
+	source TEXT
+);
+
+CREATE TABLE sources (
+    ip TEXT PRIMARY KEY,
+    version TEXT,
+    lastdemux TEXT,
+    description TEXT
+);
+
+CREATE TABLE kernels (
+	id INTEGER PRIMARY KEY,
+	kernel TEXT,
+    kernel_md5 TEXT,
+    initramfs_md5 TEXT
+);
+
+CREATE TABLE bootmedia (
+	id INTEGER PRIMARY KEY,
+	kernel TEXT,
+	name TEXT,
+	identifier TEXT,
+	description TEXT,
+	created TEXT,
+	theme TEXT,
+	mediatype TEXT
+);
+
+CREATE TABLE menus (
+	id INTEGER PRIMARY KEY,
+	name TEXT,
+	description TEXT,
+	theme TEXT
+);
+
+CREATE TABLE menu_entries (
+    id INTEGER PRIMARY KEY,
+	menu_id INTEGER,
+	entry_order INTEGER,
+	system_id INTEGER,
+	overwrite_caption INTEGER,
+	overwrite_append INTEGER,
+	alternative_caption TEXT,
+	alternative_append TEXT
+);
+
+CREATE TABLE menu_assignments (
+    id INTEGER PRIMARY KEY,
+    name TEXT,
+    menu_id INTEGER
+);
+
+CREATE TABLE menu_assignment_iprules (
+    id INTEGER PRIMARY KEY,
+    menu_assignment_rule INTEGER,
+    ip TEXT,
+    netmask TEXT
+);
+
+CREATE TABLE menu_assignment_bmrules (
+    id INTEGER PRIMARY KEY,
+    menu_assignment_rule INTEGER,
+    bootmedia_id INTEGER
+);
+