2 files changed, 113 insertions, 0 deletions
diff --git a/application/configs/application.ini b/application/configs/application.ini
new file mode 100644
index 0000000..3e2230b
--- /dev/null
+++ b/application/configs/application.ini
@@ -0,0 +1,30 @@
+[production]
+phpSettings.display_startup_errors = 0
+phpSettings.display_errors = 0
+includePaths.library = APPLICATION_PATH "/../library"
+bootstrap.path = APPLICATION_PATH "/Bootstrap.php"
+bootstrap.class = "Bootstrap"
+resources.frontController.controllerDirectory = APPLICATION_PATH "/controllers"
+resources.frontController.moduleDirectory = APPLICATION_PATH "/modules"
+resources.frontController.defaultControllerName = "index"
+resources.frontController.defaultAction = "index"
+resources.modules[] = "backend"
+resources.db.adapter = PDO_SQLITE;
+resources.db.params.dbname = APPLICATION_PATH "/../data/db/pbs.db"
+resources.db.isDefaultTableAdapter  = true
+
+resources.layout.layoutpath = APPLICATION_PATH "/layouts"
+
+[staging : production]
+resources.db.params.dbname = APPLICATION_PATH "/../data/db/pbs.db"
+
+
+[testing : production]
+resources.db.params.dbname = APPLICATION_PATH "/../data/db/pbs.testing.db"
+phpSettings.display_startup_errors = 1
+phpSettings.display_errors = 1
+
+[development : production]
+resource.db.params.dbname = APPLICATION_PATH "/../data/db/pbs.development.db"
+phpSettings.display_startup_errors = 1
+phpSettings.display_errors = 1
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
+);
+