Restore win32 dir from Branch-5.2 and update it

[bacula/bacula] / bacula / src / win32 / cats / drop_mysql_tables.sql

diff --git a/bacula/src/win32/cats/drop_mysql_tables.sql b/bacula/src/win32/cats/drop_mysql_tables.sql
new file mode 100644 (file)
index 0000000..b57d7e5
--- /dev/null
+++ b/bacula/src/win32/cats/drop_mysql_tables.sql
@@ -0,0 +1,26 @@
+USE bacula;\r
+DROP TABLE IF EXISTS Filename;\r
+DROP TABLE IF EXISTS Path;\r
+DROP TABLE IF EXISTS LongName;\r
+DROP TABLE IF EXISTS Device;\r
+DROP TABLE IF EXISTS Storage;\r
+DROP TABLE IF EXISTS MediaType;\r
+DROP TABLE IF EXISTS File;\r
+DROP TABLE IF EXISTS Client;\r
+DROP TABLE IF EXISTS Job;\r
+DROP TABLE IF EXISTS Media;\r
+DROP TABLE IF EXISTS JobMedia;\r
+DROP TABLE IF EXISTS Pool;\r
+DROP TABLE IF EXISTS MultiVolume;\r
+DROP TABLE IF EXISTS FileSave;  \r
+DROP TABLE IF EXISTS FileSet;  \r
+DROP TABLE IF EXISTS Version;\r
+DROP TABLE IF EXISTS Counters;\r
+DROP TABLE IF EXISTS BaseFiles;\r
+DROP TABLE IF EXISTS UnsavedFiles;\r
+DROP TABLE IF EXISTS CDImages;\r
+DROP TABLE IF EXISTS Status;\r
+DROP TABLE IF EXISTS MAC;\r
+DROP TABLE IF EXISTS Log;\r
+DROP TABLE IF EXISTS Location;\r
+DROP TABLE IF EXISTS LocationLog;\r