From bfbab280c8b801ef9cf559815079fd1b41d58dfd Mon Sep 17 00:00:00 2001
From: Eric Bollengier <eric@baculasystems.com>
Date: Tue, 12 May 2020 10:19:19 +0200
Subject: [PATCH] Remove create_test_database

---
 bacula/src/cats/create_test_database |  16 ---
 bacula/src/cats/drop_test_tables     |  26 -----
 bacula/src/cats/make_test_tables     | 152 ---------------------------
 3 files changed, 194 deletions(-)
 delete mode 100644 bacula/src/cats/create_test_database
 delete mode 100755 bacula/src/cats/drop_test_tables
 delete mode 100755 bacula/src/cats/make_test_tables

diff --git a/bacula/src/cats/create_test_database b/bacula/src/cats/create_test_database
deleted file mode 100644
index 643acb5b8c..0000000000
--- a/bacula/src/cats/create_test_database
+++ /dev/null
@@ -1,16 +0,0 @@
-#!/bin/bash
-#
-# shell script to create Bacula database(s)
-#
-
-bindir=~kern/mysql/bin
-
-if $bindir/mysql -f <<END-OF-DATA
-CREATE DATABASE baculatest;
-END-OF-DATA
-then
-   echo "Creation of baculatest database succeeded."
-else
-   echo "Creation of baculatest database failed."
-fi
-exit 0
diff --git a/bacula/src/cats/drop_test_tables b/bacula/src/cats/drop_test_tables
deleted file mode 100755
index 0635563e76..0000000000
--- a/bacula/src/cats/drop_test_tables
+++ /dev/null
@@ -1,26 +0,0 @@
-#!/bin/bash
-#
-# shell script to delete Bacula tables for test database
-
-bindir=~kern/mysql/bin
-
-if $bindir/mysql <<END-OF-DATA
-USE baculatest;
-DROP TABLE IF EXISTS Filename;
-DROP TABLE IF EXISTS Path;
-DROP TABLE IF EXISTS LongName;
-DROP TABLE IF EXISTS File;
-DROP TABLE IF EXISTS Client;
-DROP TABLE IF EXISTS Job;
-DROP TABLE IF EXISTS Media;
-DROP TABLE IF EXISTS JobMedia;
-DROP TABLE IF EXISTS Pool;
-DROP TABLE IF EXISTS MultiVolume;
-DROP TABLE IF EXISTS FileSet;
-END-OF-DATA
-then
-   echo "Deletion of Baculatest tables succeeded."
-else
-   echo "Deletion of Baculatest tables failed."
-fi
-exit 0
diff --git a/bacula/src/cats/make_test_tables b/bacula/src/cats/make_test_tables
deleted file mode 100755
index 9dd0fa59c0..0000000000
--- a/bacula/src/cats/make_test_tables
+++ /dev/null
@@ -1,152 +0,0 @@
-#!/bin/sh
-#
-# shell script to create Bacula Developer Test tables
-
-bindir=$HOME/mysql/bin
-
-if $bindir/mysql -f <<END-OF-DATA
-USE baculatest;
-CREATE TABLE Filename (
-  FilenameId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-  Name VARCHAR(255) NOT NULL,
-  PRIMARY KEY(FilenameId),
-  INDEX (Name(30))
-  );
-
-CREATE TABLE Path (
-   PathId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-   Path VARCHAR(255) NOT NULL,
-   PRIMARY KEY(PathId),
-   INDEX (Path(50))
-   );
-
-
-CREATE TABLE File (
-   FileId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-   FileIndex INTEGER UNSIGNED NOT NULL,
-   JobId INTEGER UNSIGNED NOT NULL REFERENCES Job,
-   PathId INTEGER UNSIGNED NOT NULL REFERENCES Path,
-   FilenameId INTEGER NOT NULL REFERENCES Filename,
-   LStat VARCHAR(255) NOT NULL,
-   MD5 VARCHAR(25) NOT NULL,
-   PRIMARY KEY(FileId),
-   INDEX (FilenameId, PathId)
-   );
-
-
-CREATE TABLE Job (
-   JobId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-   Name VARCHAR(127) NOT NULL,
-   Class CHAR NOT NULL,
-   Type CHAR NOT NULL,
-   Level CHAR NOT NULL,
-   ClientId INTEGER NOT NULL REFERENCES Client,
-   JobStatus CHAR NOT NULL,
-   SchedTime DATETIME NOT NULL,
-   StartTime DATETIME NOT NULL,
-   EndTime DATETIME NOT NULL,
-   VolSessionId INTEGER UNSIGNED NOT NULL,
-   VolSessionTime INTEGER UNSIGNED NOT NULL,
-   JobFiles INTEGER UNSIGNED NOT NULL,
-   JobBytes BIGINT UNSIGNED NOT NULL,
-   JobErrors INTEGER UNSIGNED NOT NULL,
-   JobMissingFiles INTEGER UNSIGNED NOT NULL,
-   PoolId INTEGER UNSIGNED NOT NULL REFERENCES Pool,
-   FileSetId INTEGER UNSIGNED NOT NULL REFERENCES FileSet,
-   PRIMARY KEY(JobId),
-   INDEX (Name)
-   );
-
-# 
-CREATE TABLE FileSet (
-   FileSetId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-   FileSet VARCHAR(127), 
-   MD5 VARCHAR(25),
-   PRIMARY KEY(FileSetId)
-   );
-
-CREATE TABLE JobMedia (
-   JobMediaId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-   JobId INTEGER UNSIGNED NOT NULL REFERENCES Job,
-   MediaId INTEGER UNSIGNED NOT NULL REFERENCES Media,
-   FirstIndex INTEGER UNSIGNED NOT NULL,
-   LastIndex INTEGER UNSIGNED NOT NULL,
-   StartFile INTEGER UNSIGNED NOT NULL,
-   EndFile INTEGER UNSIGNED NOT NULL,
-   StartBlock INTEGER UNSIGNED NOT NULL,
-   EndBlock INTEGER UNSIGNED NOT NULL,
-   PRIMARY KEY(JobMediaId),
-   INDEX (JobId, MediaId)
-   );
-
-
-CREATE TABLE Media (
-   MediaId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-   VolumeName VARCHAR(127) NOT NULL,
-   PoolId INTEGER UNSIGNED NOT NULL REFERENCES Pool,
-   MediaType VARCHAR(127),
-   FirstWritten DATETIME NOT NULL,
-   LastWritten DATETIME NOT NULL,
-   LabelDate DATETIME NOT NULL,
-   VolJobs INTEGER UNSIGNED NOT NULL,
-   VolFiles INTEGER UNSIGNED NOT NULL,
-   VolBlocks INTEGER UNSIGNED NOT NULL,
-   VolMounts INTEGER UNSIGNED NOT NULL,
-   VolBytes BIGINT UNSIGNED NOT NULL,
-   VolErrors INTEGER UNSIGNED NOT NULL,
-   VolWrites INTEGER UNSIGNED NOT NULL,
-   VolMaxBytes BIGINT UNSIGNED NOT NULL,
-   VolCapacityBytes BIGINT UNSIGNED NOT NULL,
-   VolStatus ENUM('Full', 'Archive', 'Append', 'Recycle', 'Read-Only', 'Disabled') NOT NULL,
-   Recycle ENUM('No', 'Yes') Not NULL,
-   PRIMARY KEY(MediaId),
-   INDEX (PoolId)
-   );
-
-CREATE TABLE Pool (
-   PoolId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-   Name VARCHAR(127) NOT NULL,
-   NumVols INTEGER UNSIGNED NOT NULL,
-   MaxVols INTEGER UNSIGNED NOT NULL,
-   UseOnce TINYINT NOT NULL,
-   UseCatalog TINYINT NOT NULL,
-   AcceptAnyVolume TINYINT NOT NULL,
-   PoolType ENUM('Backup', 'Copy', 'Cloned', 'Archive', 'Migration') NOT NULL,
-   LabelFormat VARCHAR(127),
-   UNIQUE (Name),
-   PRIMARY KEY (PoolId)
-   );
-
-
-CREATE TABLE Client (
-   ClientId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-   Name VARCHAR(127) NOT NULL,
-   Uname VARCHAR(255) NOT NULL,       /* full uname -a of client */
-   UNIQUE (Name),
-   PRIMARY KEY(ClientId)
-   );
-
-## Experimental
-#CREATE TABLE FileSave (
-#   FileSaveId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-#   FileIndex INTEGER UNSIGNED NOT NULL,
-#   JobId INTEGER UNSIGNED NOT NULL REFERENCES Job,
-#   FileId INTEGER UNSIGNED NOT NULL REFERENCES File,
-#   VLStat VARCHAR(255) NOT NULL,
-#   PRIMARY KEY(FileSaveId),
-#   );
-
-#CREATE TABLE LongName (
-#   LongNameId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-#   Name TEXT NOT NULL,
-#   PRIMARY KEY (LongNameId)
-#   );
-
-       
-END-OF-DATA
-then
-   echo "Creation of Baculatest tables succeeded."
-else
-   echo "Creation of Baculatest tables failed."
-fi
-exit 0
-- 
2.47.3