X-Git-Url: http://git.pjr.cc/?p=php-bacula-disk-changer.git;a=blobdiff_plain;f=db%2Fdb.sql;h=7c8d722d2093e8d9addf92087bb5937ee27ad0dc;hp=0a16ca9efa7b3ae7f4bec694c15ca8356065df9f;hb=45477c40560ea3bda92e4c03c7ed564228a92bd8;hpb=754af6334eb9dc27818f355409f5528c714dce83

diff --git a/db/db.sql b/db/db.sql
index 0a16ca9..7c8d722 100644
--- 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
+);