X-Git-Url: http://git.pjr.cc/?p=php-bacula-disk-changer.git;a=blobdiff_plain;f=db%2Fdb.sql;h=c5a8a705ad8ed5d10a0afd723c0947df18a662e5;hp=7c8d722d2093e8d9addf92087bb5937ee27ad0dc;hb=95682a89442421c2ae8bfbf729c255c993874d7c;hpb=0f654013ad6f1ce818f875cbe70a8f0e802abbc4 diff --git a/db/db.sql b/db/db.sql index 7c8d722..c5a8a70 100644 --- a/db/db.sql +++ b/db/db.sql @@ -7,3 +7,10 @@ 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