From 34868733882a8fc74b7a4a9c7743b896e6acd3d4 Mon Sep 17 00:00:00 2001
From: Kern Sibbald <kern@sibbald.com>
Date: Wed, 27 Nov 2002 15:11:10 +0000
Subject: [PATCH] Update ReleaseNotes

git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@216 91ce42f0-d328-0410-95d8-f526ca767f89
---
 bacula/ChangeLog          |  2 +-
 bacula/ReleaseNotes       | 30 +++++++++++++++++++++---------
 bacula/src/dird/query.sql |  8 ++++++++
 bacula/src/version.h      |  4 ++--
 4 files changed, 32 insertions(+), 12 deletions(-)

diff --git a/bacula/ChangeLog b/bacula/ChangeLog
index 8cf74cb19a..ecdbe1a66a 100644
--- a/bacula/ChangeLog
+++ b/bacula/ChangeLog
@@ -1,5 +1,5 @@
 
-2002-mm-dd Version 1.27 (25Nov02) not yet released
+2002-mm-dd Version 1.27 (26Nov02) released 28 November 2002
 
 General: from kes25Nov02
 - Mostly Cygwin changes
diff --git a/bacula/ReleaseNotes b/bacula/ReleaseNotes
index bc636c04f7..1d5fa9e2ee 100644
--- a/bacula/ReleaseNotes
+++ b/bacula/ReleaseNotes
@@ -1,6 +1,6 @@
           Release Notes for Bacula 1.27
 
-  Bacula code: Total files = 222 Total lines = 60,396 (*.h *.c *.in)
+  Bacula code: Total files = 222 Total lines = 60,486 (*.h *.c *.in)
 
 Major Changes this Release:
 - Implemented support for Sparse files.
@@ -15,9 +15,8 @@ Major Changes this Release:
   the Pool documentation for the Director for more details.
 - Rework of the Web site.
 - New format for the User's Guide (manual).
-- New bcopy tool.
-- All bxxx tool programs MUST read a Storage daemon configuration
-  file.
+- New bcopy tool (works but not totally complete).
+- All bxxx tool programs MUST read a Storage daemon configuration file.
 - Mount Anonymous Volumes is now dropped from the Storage
   daemon configuration files.
 - Accept Any Volume is by default "Yes" and permits Bacula
@@ -38,12 +37,25 @@ Minor Changes this Release:
   to the director.
 - Fixed mount loop when the autochanger slot is incorrect in 
   the catalog.
-- Updated the bacula script to work on more systems.
+- Updated the bacula start/stop script to work on more systems.
 - Fixed many places prone to buffer overflows.
+- Scripts are now found in <bacula-src>/scripts
+- A mtx-changer script was contributed for the Sony
+  TLS-11000 autochanger.  It is in <bacula-src>/examples
 
 Items to note:
-- The Dir-SD protocol has changed since 1.26, so you must
-  update the Director and Storage daemons.
-- The Dir-FD protocol has changed since 1.26 (and earlier versions
-  of 1.27).
 - You must re-initialize or alter your databases.
+- The inter-daemon protocol has changed so you must
+  upgrade all your daemons (and all Clients).
+
+Altering your database:
+- First make a backup.
+- Configure and build Bacula
+
+- For MySQL
+   cd <bacula-src>/src/cats
+   ./alter_mysql_tables
+
+- For SQLite
+   cd <bacula-src>/src/cats
+   ./alter_sqlite_tables
diff --git a/bacula/src/dird/query.sql b/bacula/src/dird/query.sql
index 1e9db805fa..11b09a2ad7 100644
--- a/bacula/src/dird/query.sql
+++ b/bacula/src/dird/query.sql
@@ -140,3 +140,11 @@ SELECT count(*) AS Jobs, sum(JobFiles) AS Files,
  WHERE JobMedia.JobId=Job.JobId
  AND JobMedia.MediaId=Media.MediaId
  GROUP by VolumeName;  
+#
+:List Files for a selected JobId:
+*Enter JobId:
+SELECT Path.Path,Filename.Name FROM File,
+ Filename,Path WHERE File.JobId=%1 
+ AND Filename.FilenameId=File.FilenameId 
+ AND Path.PathId=File.PathId ORDER BY
+ Path.Path,Filename.Name;
diff --git a/bacula/src/version.h b/bacula/src/version.h
index c401accee0..0564b69fee 100644
--- a/bacula/src/version.h
+++ b/bacula/src/version.h
@@ -1,8 +1,8 @@
 /* */
 #define VERSION "1.27"
 #define VSTRING "1"
-#define DATE    "25 November 2002"
-#define LSMDATE "25Nov02"
+#define DATE    "26 November 2002"
+#define LSMDATE "26Nov02"
 
 /* Debug flags */
 #define DEBUG 1
-- 
2.39.5