coding change, duh

[php-bacula-disk-changer.git] / db / db.sql

diff --git a/db/db.sql b/db/db.sql
index 0a16ca9..7c8d722 100644 (file)
--- a/db/db.sql
+++ b/db/db.sql
@@ -1 +1,9 @@
-# some sql goes here
+CREATE TABLE "disk_list" (
+    "disk_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+    "disk_name" TEXT NOT NULL
+);
+CREATE TABLE sqlite_sequence(name,seq);
+CREATE TABLE "config" (
+    "config_name" TEXT NOT NULL,
+    "config_value" TEXT NOT NULL
+);