new devel_bacula + fixes to conio/console

[bacula/bacula] / bacula / src / cats / make_postgresql_tables.in

diff --git a/bacula/src/cats/make_postgresql_tables.in b/bacula/src/cats/make_postgresql_tables.in
index 337a74ff4e2286f046874811e98a51f4eaa91c9b..7232c05cee40035e3fbc6f0b2d8d5252d5505c41 100644 (file)
--- a/bacula/src/cats/make_postgresql_tables.in
+++ b/bacula/src/cats/make_postgresql_tables.in
@@ -115,7 +115,7 @@ create table media
     lastwritten       timestamp without time zone not null
         default current_timestamp,
     labeldate         timestamp without time zone not null
-       default current_timestamp,
+        default current_timestamp,
     voljobs           integer               not null
         default 0,
     volfiles          integer               not null
@@ -146,12 +146,14 @@ create table media
         default 0,
     maxvolbytes       bigint                not null
         default 0,
-    drive             integer               not null
-        default 0,
     inchanger         smallint              not null
         default 0,
     mediaaddressing   smallint              not null
         default 0,
+    volreadtime       bigint                not null
+        default 0,
+    volwritetime      bigint                not null
+        default 0,
     primary key (mediaid)
 );
 
@@ -175,7 +177,7 @@ create table job
     volsessiontime    integer               not null
         default 0,
     jobfiles          integer               not null
-       default 0,
+        default 0,
     jobbytes          bigint                not null
         default 0,
     joberrors         integer               not null