stuff

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

diff --git a/db/db.sql b/db/db.sql
index 0a16ca9..c5a8a70 100644 (file)
--- a/db/db.sql
+++ b/db/db.sql
@@ -1 +1,16 @@
-# 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
+);
+
+create table "slots" (
+       "slots_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+       "slot_no" INTEGER,
+       "disk_id" INTEGER,
+       "tape_name" TEXT
+);
\ No newline at end of file