Guest User

Bacula Database

a guest
Nov 20th, 2013
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 20.41 KB | None | 0 0
  1. -- MySQL dump 10.13  Distrib 5.5.23, for Linux (x86_64)
  2. --
  3. -- Host: localhost    Database: bacula
  4. -- ------------------------------------------------------
  5. -- Server version   5.5.23-log
  6.  
  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10. /*!40101 SET NAMES utf8 */;
  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12. /*!40103 SET TIME_ZONE='+00:00' */;
  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17.  
  18. --
  19. -- Table structure for table `BaseFiles`
  20. --
  21.  
  22. DROP TABLE IF EXISTS `BaseFiles`;
  23. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  24. /*!40101 SET character_set_client = utf8 */;
  25. CREATE TABLE `BaseFiles` (
  26.   `BaseId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  27.   `BaseJobId` INT(10) UNSIGNED NOT NULL,
  28.   `JobId` INT(10) UNSIGNED NOT NULL,
  29.   `FileId` BIGINT(20) UNSIGNED NOT NULL,
  30.   `FileIndex` INT(10) UNSIGNED DEFAULT NULL,
  31.   PRIMARY KEY (`BaseId`),
  32.   KEY `basefiles_jobid_idx` (`JobId`)
  33. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  34. /*!40101 SET character_set_client = @saved_cs_client */;
  35.  
  36. --
  37. -- Table structure for table `CDImages`
  38. --
  39.  
  40. DROP TABLE IF EXISTS `CDImages`;
  41. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  42. /*!40101 SET character_set_client = utf8 */;
  43. CREATE TABLE `CDImages` (
  44.   `MediaId` INT(10) UNSIGNED NOT NULL,
  45.   `LastBurn` datetime NOT NULL,
  46.   PRIMARY KEY (`MediaId`)
  47. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  48. /*!40101 SET character_set_client = @saved_cs_client */;
  49.  
  50. --
  51. -- Table structure for table `Client`
  52. --
  53.  
  54. DROP TABLE IF EXISTS `Client`;
  55. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  56. /*!40101 SET character_set_client = utf8 */;
  57. CREATE TABLE `Client` (
  58.   `ClientId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  59.   `Name` tinyblob NOT NULL,
  60.   `Uname` tinyblob NOT NULL,
  61.   `AutoPrune` tinyint(4) DEFAULT '0',
  62.   `FileRetention` BIGINT(20) UNSIGNED DEFAULT '0',
  63.   `JobRetention` BIGINT(20) UNSIGNED DEFAULT '0',
  64.   PRIMARY KEY (`ClientId`),
  65.   UNIQUE KEY `Name` (`Name`(128))
  66. ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
  67. /*!40101 SET character_set_client = @saved_cs_client */;
  68.  
  69. --
  70. -- Table structure for table `Counters`
  71. --
  72.  
  73. DROP TABLE IF EXISTS `Counters`;
  74. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  75. /*!40101 SET character_set_client = utf8 */;
  76. CREATE TABLE `Counters` (
  77.   `Counter` tinyblob NOT NULL,
  78.   `MinValue` INT(11) DEFAULT '0',
  79.   `MaxValue` INT(11) DEFAULT '0',
  80.   `CurrentValue` INT(11) DEFAULT '0',
  81.   `WrapCounter` tinyblob NOT NULL,
  82.   PRIMARY KEY (`Counter`(128))
  83. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  84. /*!40101 SET character_set_client = @saved_cs_client */;
  85.  
  86. --
  87. -- Table structure for table `Device`
  88. --
  89.  
  90. DROP TABLE IF EXISTS `Device`;
  91. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  92. /*!40101 SET character_set_client = utf8 */;
  93. CREATE TABLE `Device` (
  94.   `DeviceId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  95.   `Name` tinyblob NOT NULL,
  96.   `MediaTypeId` INT(10) UNSIGNED DEFAULT '0',
  97.   `StorageId` INT(10) UNSIGNED DEFAULT '0',
  98.   `DevMounts` INT(10) UNSIGNED DEFAULT '0',
  99.   `DevReadBytes` BIGINT(20) UNSIGNED DEFAULT '0',
  100.   `DevWriteBytes` BIGINT(20) UNSIGNED DEFAULT '0',
  101.   `DevReadBytesSinceCleaning` BIGINT(20) UNSIGNED DEFAULT '0',
  102.   `DevWriteBytesSinceCleaning` BIGINT(20) UNSIGNED DEFAULT '0',
  103.   `DevReadTime` BIGINT(20) UNSIGNED DEFAULT '0',
  104.   `DevWriteTime` BIGINT(20) UNSIGNED DEFAULT '0',
  105.   `DevReadTimeSinceCleaning` BIGINT(20) UNSIGNED DEFAULT '0',
  106.   `DevWriteTimeSinceCleaning` BIGINT(20) UNSIGNED DEFAULT '0',
  107.   `CleaningDate` datetime DEFAULT '0000-00-00 00:00:00',
  108.   `CleaningPeriod` BIGINT(20) UNSIGNED DEFAULT '0',
  109.   PRIMARY KEY (`DeviceId`)
  110. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  111. /*!40101 SET character_set_client = @saved_cs_client */;
  112.  
  113. --
  114. -- Table structure for table `File`
  115. --
  116.  
  117. DROP TABLE IF EXISTS `File`;
  118. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  119. /*!40101 SET character_set_client = utf8 */;
  120. CREATE TABLE `File` (
  121.   `FileId` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  122.   `FileIndex` INT(10) UNSIGNED DEFAULT '0',
  123.   `JobId` INT(10) UNSIGNED NOT NULL,
  124.   `PathId` INT(10) UNSIGNED NOT NULL,
  125.   `FilenameId` INT(10) UNSIGNED NOT NULL,
  126.   `DeltaSeq` SMALLINT(5) UNSIGNED DEFAULT '0',
  127.   `MarkId` INT(10) UNSIGNED DEFAULT '0',
  128.   `LStat` tinyblob NOT NULL,
  129.   `MD5` tinyblob,
  130.   PRIMARY KEY (`FileId`),
  131.   KEY `file_jobid_idx` (`JobId`),
  132.   KEY `file_jpf_idx` (`JobId`,`PathId`,`FilenameId`)
  133. ) ENGINE=InnoDB AUTO_INCREMENT=9704306 DEFAULT CHARSET=latin1;
  134. /*!40101 SET character_set_client = @saved_cs_client */;
  135.  
  136. --
  137. -- Table structure for table `FileSet`
  138. --
  139.  
  140. DROP TABLE IF EXISTS `FileSet`;
  141. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  142. /*!40101 SET character_set_client = utf8 */;
  143. CREATE TABLE `FileSet` (
  144.   `FileSetId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  145.   `FileSet` tinyblob NOT NULL,
  146.   `MD5` tinyblob,
  147.   `CreateTime` datetime DEFAULT '0000-00-00 00:00:00',
  148.   PRIMARY KEY (`FileSetId`)
  149. ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
  150. /*!40101 SET character_set_client = @saved_cs_client */;
  151.  
  152. --
  153. -- Table structure for table `Filename`
  154. --
  155.  
  156. DROP TABLE IF EXISTS `Filename`;
  157. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  158. /*!40101 SET character_set_client = utf8 */;
  159. CREATE TABLE `Filename` (
  160.   `FilenameId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  161.   `Name` BLOB NOT NULL,
  162.   PRIMARY KEY (`FilenameId`),
  163.   KEY `Name` (`Name`(255))
  164. ) ENGINE=InnoDB AUTO_INCREMENT=1315292 DEFAULT CHARSET=latin1;
  165. /*!40101 SET character_set_client = @saved_cs_client */;
  166.  
  167. --
  168. -- Table structure for table `Job`
  169. --
  170.  
  171. DROP TABLE IF EXISTS `Job`;
  172. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  173. /*!40101 SET character_set_client = utf8 */;
  174. CREATE TABLE `Job` (
  175.   `JobId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  176.   `Job` tinyblob NOT NULL,
  177.   `Name` tinyblob NOT NULL,
  178.   `Type` BINARY(1) NOT NULL,
  179.   `Level` BINARY(1) NOT NULL,
  180.   `ClientId` INT(11) DEFAULT '0',
  181.   `JobStatus` BINARY(1) NOT NULL,
  182.   `SchedTime` datetime DEFAULT '0000-00-00 00:00:00',
  183.   `StartTime` datetime DEFAULT '0000-00-00 00:00:00',
  184.   `EndTime` datetime DEFAULT '0000-00-00 00:00:00',
  185.   `RealEndTime` datetime DEFAULT '0000-00-00 00:00:00',
  186.   `JobTDate` BIGINT(20) UNSIGNED DEFAULT '0',
  187.   `VolSessionId` INT(10) UNSIGNED DEFAULT '0',
  188.   `VolSessionTime` INT(10) UNSIGNED DEFAULT '0',
  189.   `JobFiles` INT(10) UNSIGNED DEFAULT '0',
  190.   `JobBytes` BIGINT(20) UNSIGNED DEFAULT '0',
  191.   `ReadBytes` BIGINT(20) UNSIGNED DEFAULT '0',
  192.   `JobErrors` INT(10) UNSIGNED DEFAULT '0',
  193.   `JobMissingFiles` INT(10) UNSIGNED DEFAULT '0',
  194.   `PoolId` INT(10) UNSIGNED DEFAULT '0',
  195.   `FileSetId` INT(10) UNSIGNED DEFAULT '0',
  196.   `PriorJobId` INT(10) UNSIGNED DEFAULT '0',
  197.   `PurgedFiles` tinyint(4) DEFAULT '0',
  198.   `HasBase` tinyint(4) DEFAULT '0',
  199.   `HasCache` tinyint(4) DEFAULT '0',
  200.   `Reviewed` tinyint(4) DEFAULT '0',
  201.   `Comment` BLOB,
  202.   PRIMARY KEY (`JobId`),
  203.   KEY `Name` (`Name`(128))
  204. ) ENGINE=InnoDB AUTO_INCREMENT=970 DEFAULT CHARSET=latin1;
  205. /*!40101 SET character_set_client = @saved_cs_client */;
  206.  
  207. --
  208. -- Table structure for table `JobHisto`
  209. --
  210.  
  211. DROP TABLE IF EXISTS `JobHisto`;
  212. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  213. /*!40101 SET character_set_client = utf8 */;
  214. CREATE TABLE `JobHisto` (
  215.   `JobId` INT(10) UNSIGNED NOT NULL,
  216.   `Job` tinyblob NOT NULL,
  217.   `Name` tinyblob NOT NULL,
  218.   `Type` BINARY(1) NOT NULL,
  219.   `Level` BINARY(1) NOT NULL,
  220.   `ClientId` INT(11) DEFAULT '0',
  221.   `JobStatus` BINARY(1) NOT NULL,
  222.   `SchedTime` datetime DEFAULT '0000-00-00 00:00:00',
  223.   `StartTime` datetime DEFAULT '0000-00-00 00:00:00',
  224.   `EndTime` datetime DEFAULT '0000-00-00 00:00:00',
  225.   `RealEndTime` datetime DEFAULT '0000-00-00 00:00:00',
  226.   `JobTDate` BIGINT(20) UNSIGNED DEFAULT '0',
  227.   `VolSessionId` INT(10) UNSIGNED DEFAULT '0',
  228.   `VolSessionTime` INT(10) UNSIGNED DEFAULT '0',
  229.   `JobFiles` INT(10) UNSIGNED DEFAULT '0',
  230.   `JobBytes` BIGINT(20) UNSIGNED DEFAULT '0',
  231.   `ReadBytes` BIGINT(20) UNSIGNED DEFAULT '0',
  232.   `JobErrors` INT(10) UNSIGNED DEFAULT '0',
  233.   `JobMissingFiles` INT(10) UNSIGNED DEFAULT '0',
  234.   `PoolId` INT(10) UNSIGNED DEFAULT '0',
  235.   `FileSetId` INT(10) UNSIGNED DEFAULT '0',
  236.   `PriorJobId` INT(10) UNSIGNED DEFAULT '0',
  237.   `PurgedFiles` tinyint(4) DEFAULT '0',
  238.   `HasBase` tinyint(4) DEFAULT '0',
  239.   `HasCache` tinyint(4) DEFAULT '0',
  240.   `Reviewed` tinyint(4) DEFAULT '0',
  241.   `Comment` BLOB,
  242.   KEY `JobId` (`JobId`),
  243.   KEY `StartTime` (`StartTime`)
  244. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  245. /*!40101 SET character_set_client = @saved_cs_client */;
  246.  
  247. --
  248. -- Table structure for table `JobMedia`
  249. --
  250.  
  251. DROP TABLE IF EXISTS `JobMedia`;
  252. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  253. /*!40101 SET character_set_client = utf8 */;
  254. CREATE TABLE `JobMedia` (
  255.   `JobMediaId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  256.   `JobId` INT(10) UNSIGNED NOT NULL,
  257.   `MediaId` INT(10) UNSIGNED NOT NULL,
  258.   `FirstIndex` INT(10) UNSIGNED DEFAULT '0',
  259.   `LastIndex` INT(10) UNSIGNED DEFAULT '0',
  260.   `StartFile` INT(10) UNSIGNED DEFAULT '0',
  261.   `EndFile` INT(10) UNSIGNED DEFAULT '0',
  262.   `StartBlock` INT(10) UNSIGNED DEFAULT '0',
  263.   `EndBlock` INT(10) UNSIGNED DEFAULT '0',
  264.   `VolIndex` INT(10) UNSIGNED DEFAULT '0',
  265.   PRIMARY KEY (`JobMediaId`),
  266.   KEY `JobId` (`JobId`,`MediaId`)
  267. ) ENGINE=InnoDB AUTO_INCREMENT=10446 DEFAULT CHARSET=latin1;
  268. /*!40101 SET character_set_client = @saved_cs_client */;
  269.  
  270. --
  271. -- Table structure for table `Location`
  272. --
  273.  
  274. DROP TABLE IF EXISTS `Location`;
  275. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  276. /*!40101 SET character_set_client = utf8 */;
  277. CREATE TABLE `Location` (
  278.   `LocationId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  279.   `Location` tinyblob NOT NULL,
  280.   `Cost` INT(11) DEFAULT '0',
  281.   `Enabled` tinyint(4) DEFAULT NULL,
  282.   PRIMARY KEY (`LocationId`)
  283. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  284. /*!40101 SET character_set_client = @saved_cs_client */;
  285.  
  286. --
  287. -- Table structure for table `LocationLog`
  288. --
  289.  
  290. DROP TABLE IF EXISTS `LocationLog`;
  291. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  292. /*!40101 SET character_set_client = utf8 */;
  293. CREATE TABLE `LocationLog` (
  294.   `LocLogId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  295.   `Date` datetime DEFAULT '0000-00-00 00:00:00',
  296.   `Comment` BLOB NOT NULL,
  297.   `MediaId` INT(10) UNSIGNED DEFAULT '0',
  298.   `LocationId` INT(10) UNSIGNED DEFAULT '0',
  299.   `NewVolStatus` enum('Full','Archive','Append','Recycle','Purged','Read-Only','Disabled','Error','Busy','Used','Cleaning') NOT NULL,
  300.   `NewEnabled` tinyint(4) DEFAULT NULL,
  301.   PRIMARY KEY (`LocLogId`)
  302. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  303. /*!40101 SET character_set_client = @saved_cs_client */;
  304.  
  305. --
  306. -- Table structure for table `Log`
  307. --
  308.  
  309. DROP TABLE IF EXISTS `Log`;
  310. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  311. /*!40101 SET character_set_client = utf8 */;
  312. CREATE TABLE `Log` (
  313.   `LogId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  314.   `JobId` INT(10) UNSIGNED DEFAULT '0',
  315.   `Time` datetime DEFAULT '0000-00-00 00:00:00',
  316.   `LogText` BLOB NOT NULL,
  317.   PRIMARY KEY (`LogId`),
  318.   KEY `JobId` (`JobId`)
  319. ) ENGINE=InnoDB AUTO_INCREMENT=74519883 DEFAULT CHARSET=latin1;
  320. /*!40101 SET character_set_client = @saved_cs_client */;
  321.  
  322. --
  323. -- Table structure for table `Media`
  324. --
  325.  
  326. DROP TABLE IF EXISTS `Media`;
  327. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  328. /*!40101 SET character_set_client = utf8 */;
  329. CREATE TABLE `Media` (
  330.   `MediaId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  331.   `VolumeName` tinyblob NOT NULL,
  332.   `Slot` INT(11) DEFAULT '0',
  333.   `PoolId` INT(10) UNSIGNED DEFAULT '0',
  334.   `MediaType` tinyblob NOT NULL,
  335.   `MediaTypeId` INT(10) UNSIGNED DEFAULT '0',
  336.   `LabelType` tinyint(4) DEFAULT '0',
  337.   `FirstWritten` datetime DEFAULT '0000-00-00 00:00:00',
  338.   `LastWritten` datetime DEFAULT '0000-00-00 00:00:00',
  339.   `LabelDate` datetime DEFAULT '0000-00-00 00:00:00',
  340.   `VolJobs` INT(10) UNSIGNED DEFAULT '0',
  341.   `VolFiles` INT(10) UNSIGNED DEFAULT '0',
  342.   `VolBlocks` INT(10) UNSIGNED DEFAULT '0',
  343.   `VolMounts` INT(10) UNSIGNED DEFAULT '0',
  344.   `VolBytes` BIGINT(20) UNSIGNED DEFAULT '0',
  345.   `VolParts` INT(10) UNSIGNED DEFAULT '0',
  346.   `VolErrors` INT(10) UNSIGNED DEFAULT '0',
  347.   `VolWrites` INT(10) UNSIGNED DEFAULT '0',
  348.   `VolCapacityBytes` BIGINT(20) UNSIGNED DEFAULT '0',
  349.   `VolStatus` enum('Full','Archive','Append','Recycle','Purged','Read-Only','Disabled','Error','Busy','Used','Cleaning') NOT NULL,
  350.   `Enabled` tinyint(4) DEFAULT '1',
  351.   `Recycle` tinyint(4) DEFAULT '0',
  352.   `ActionOnPurge` tinyint(4) DEFAULT '0',
  353.   `VolRetention` BIGINT(20) UNSIGNED DEFAULT '0',
  354.   `VolUseDuration` BIGINT(20) UNSIGNED DEFAULT '0',
  355.   `MaxVolJobs` INT(10) UNSIGNED DEFAULT '0',
  356.   `MaxVolFiles` INT(10) UNSIGNED DEFAULT '0',
  357.   `MaxVolBytes` BIGINT(20) UNSIGNED DEFAULT '0',
  358.   `InChanger` tinyint(4) DEFAULT '0',
  359.   `StorageId` INT(10) UNSIGNED DEFAULT '0',
  360.   `DeviceId` INT(10) UNSIGNED DEFAULT '0',
  361.   `MediaAddressing` tinyint(4) DEFAULT '0',
  362.   `VolReadTime` BIGINT(20) UNSIGNED DEFAULT '0',
  363.   `VolWriteTime` BIGINT(20) UNSIGNED DEFAULT '0',
  364.   `EndFile` INT(10) UNSIGNED DEFAULT '0',
  365.   `EndBlock` INT(10) UNSIGNED DEFAULT '0',
  366.   `LocationId` INT(10) UNSIGNED DEFAULT '0',
  367.   `RecycleCount` INT(10) UNSIGNED DEFAULT '0',
  368.   `InitialWrite` datetime DEFAULT '0000-00-00 00:00:00',
  369.   `ScratchPoolId` INT(10) UNSIGNED DEFAULT '0',
  370.   `RecyclePoolId` INT(10) UNSIGNED DEFAULT '0',
  371.   `Comment` BLOB,
  372.   PRIMARY KEY (`MediaId`),
  373.   UNIQUE KEY `VolumeName` (`VolumeName`(128)),
  374.   KEY `PoolId` (`PoolId`)
  375. ) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=latin1;
  376. /*!40101 SET character_set_client = @saved_cs_client */;
  377.  
  378. --
  379. -- Table structure for table `MediaType`
  380. --
  381.  
  382. DROP TABLE IF EXISTS `MediaType`;
  383. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  384. /*!40101 SET character_set_client = utf8 */;
  385. CREATE TABLE `MediaType` (
  386.   `MediaTypeId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  387.   `MediaType` tinyblob NOT NULL,
  388.   `ReadOnly` tinyint(4) DEFAULT '0',
  389.   PRIMARY KEY (`MediaTypeId`)
  390. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  391. /*!40101 SET character_set_client = @saved_cs_client */;
  392.  
  393. --
  394. -- Table structure for table `Path`
  395. --
  396.  
  397. DROP TABLE IF EXISTS `Path`;
  398. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  399. /*!40101 SET character_set_client = utf8 */;
  400. CREATE TABLE `Path` (
  401.   `PathId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  402.   `Path` BLOB NOT NULL,
  403.   PRIMARY KEY (`PathId`),
  404.   KEY `Path` (`Path`(255))
  405. ) ENGINE=InnoDB AUTO_INCREMENT=168299 DEFAULT CHARSET=latin1;
  406. /*!40101 SET character_set_client = @saved_cs_client */;
  407.  
  408. --
  409. -- Table structure for table `PathHierarchy`
  410. --
  411.  
  412. DROP TABLE IF EXISTS `PathHierarchy`;
  413. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  414. /*!40101 SET character_set_client = utf8 */;
  415. CREATE TABLE `PathHierarchy` (
  416.   `PathId` INT(11) NOT NULL,
  417.   `PPathId` INT(11) NOT NULL,
  418.   PRIMARY KEY (`PathId`),
  419.   KEY `pathhierarchy_ppathid` (`PPathId`)
  420. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  421. /*!40101 SET character_set_client = @saved_cs_client */;
  422.  
  423. --
  424. -- Table structure for table `PathVisibility`
  425. --
  426.  
  427. DROP TABLE IF EXISTS `PathVisibility`;
  428. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  429. /*!40101 SET character_set_client = utf8 */;
  430. CREATE TABLE `PathVisibility` (
  431.   `PathId` INT(11) NOT NULL,
  432.   `JobId` INT(11) NOT NULL,
  433.   `Size` BIGINT(20) DEFAULT '0',
  434.   `Files` INT(11) DEFAULT '0',
  435.   PRIMARY KEY (`JobId`,`PathId`),
  436.   KEY `pathvisibility_jobid` (`JobId`)
  437. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  438. /*!40101 SET character_set_client = @saved_cs_client */;
  439.  
  440. --
  441. -- Table structure for table `Pool`
  442. --
  443.  
  444. DROP TABLE IF EXISTS `Pool`;
  445. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  446. /*!40101 SET character_set_client = utf8 */;
  447. CREATE TABLE `Pool` (
  448.   `PoolId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  449.   `Name` tinyblob NOT NULL,
  450.   `NumVols` INT(10) UNSIGNED DEFAULT '0',
  451.   `MaxVols` INT(10) UNSIGNED DEFAULT '0',
  452.   `UseOnce` tinyint(4) DEFAULT '0',
  453.   `UseCatalog` tinyint(4) DEFAULT '0',
  454.   `AcceptAnyVolume` tinyint(4) DEFAULT '0',
  455.   `VolRetention` BIGINT(20) UNSIGNED DEFAULT '0',
  456.   `VolUseDuration` BIGINT(20) UNSIGNED DEFAULT '0',
  457.   `MaxVolJobs` INT(10) UNSIGNED DEFAULT '0',
  458.   `MaxVolFiles` INT(10) UNSIGNED DEFAULT '0',
  459.   `MaxVolBytes` BIGINT(20) UNSIGNED DEFAULT '0',
  460.   `AutoPrune` tinyint(4) DEFAULT '0',
  461.   `Recycle` tinyint(4) DEFAULT '0',
  462.   `ActionOnPurge` tinyint(4) DEFAULT '0',
  463.   `PoolType` enum('Backup','Copy','Cloned','Archive','Migration','Scratch') NOT NULL,
  464.   `LabelType` tinyint(4) DEFAULT '0',
  465.   `LabelFormat` tinyblob,
  466.   `Enabled` tinyint(4) DEFAULT '1',
  467.   `ScratchPoolId` INT(10) UNSIGNED DEFAULT '0',
  468.   `RecyclePoolId` INT(10) UNSIGNED DEFAULT '0',
  469.   `NextPoolId` INT(10) UNSIGNED DEFAULT '0',
  470.   `MigrationHighBytes` BIGINT(20) UNSIGNED DEFAULT '0',
  471.   `MigrationLowBytes` BIGINT(20) UNSIGNED DEFAULT '0',
  472.   `MigrationTime` BIGINT(20) UNSIGNED DEFAULT '0',
  473.   PRIMARY KEY (`PoolId`),
  474.   UNIQUE KEY `Name` (`Name`(128))
  475. ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
  476. /*!40101 SET character_set_client = @saved_cs_client */;
  477.  
  478. --
  479. -- Table structure for table `RestoreObject`
  480. --
  481.  
  482. DROP TABLE IF EXISTS `RestoreObject`;
  483. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  484. /*!40101 SET character_set_client = utf8 */;
  485. CREATE TABLE `RestoreObject` (
  486.   `RestoreObjectId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  487.   `ObjectName` BLOB NOT NULL,
  488.   `RestoreObject` longblob NOT NULL,
  489.   `PluginName` tinyblob NOT NULL,
  490.   `ObjectLength` INT(11) DEFAULT '0',
  491.   `ObjectFullLength` INT(11) DEFAULT '0',
  492.   `ObjectIndex` INT(11) DEFAULT '0',
  493.   `ObjectType` INT(11) DEFAULT '0',
  494.   `FileIndex` INT(10) UNSIGNED DEFAULT '0',
  495.   `JobId` INT(10) UNSIGNED NOT NULL,
  496.   `ObjectCompression` INT(11) DEFAULT '0',
  497.   PRIMARY KEY (`RestoreObjectId`),
  498.   KEY `JobId` (`JobId`)
  499. ) ENGINE=InnoDB AUTO_INCREMENT=265 DEFAULT CHARSET=latin1;
  500. /*!40101 SET character_set_client = @saved_cs_client */;
  501.  
  502. --
  503. -- Table structure for table `Status`
  504. --
  505.  
  506. DROP TABLE IF EXISTS `Status`;
  507. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  508. /*!40101 SET character_set_client = utf8 */;
  509. CREATE TABLE `Status` (
  510.   `JobStatus` CHAR(1) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  511.   `JobStatusLong` BLOB,
  512.   `Severity` INT(11) DEFAULT NULL,
  513.   PRIMARY KEY (`JobStatus`)
  514. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  515. /*!40101 SET character_set_client = @saved_cs_client */;
  516.  
  517. --
  518. -- Table structure for table `Storage`
  519. --
  520.  
  521. DROP TABLE IF EXISTS `Storage`;
  522. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  523. /*!40101 SET character_set_client = utf8 */;
  524. CREATE TABLE `Storage` (
  525.   `StorageId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  526.   `Name` tinyblob NOT NULL,
  527.   `AutoChanger` tinyint(4) DEFAULT '0',
  528.   PRIMARY KEY (`StorageId`)
  529. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  530. /*!40101 SET character_set_client = @saved_cs_client */;
  531.  
  532. --
  533. -- Table structure for table `UnsavedFiles`
  534. --
  535.  
  536. DROP TABLE IF EXISTS `UnsavedFiles`;
  537. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  538. /*!40101 SET character_set_client = utf8 */;
  539. CREATE TABLE `UnsavedFiles` (
  540.   `UnsavedId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  541.   `JobId` INT(10) UNSIGNED NOT NULL,
  542.   `PathId` INT(10) UNSIGNED NOT NULL,
  543.   `FilenameId` INT(10) UNSIGNED NOT NULL,
  544.   PRIMARY KEY (`UnsavedId`)
  545. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  546. /*!40101 SET character_set_client = @saved_cs_client */;
  547.  
  548. --
  549. -- Table structure for table `Version`
  550. --
  551.  
  552. DROP TABLE IF EXISTS `Version`;
  553. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  554. /*!40101 SET character_set_client = utf8 */;
  555. CREATE TABLE `Version` (
  556.   `VersionId` INT(10) UNSIGNED NOT NULL
  557. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  558. /*!40101 SET character_set_client = @saved_cs_client */;
  559. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  560.  
  561. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  562. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  563. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  564. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  565. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  566. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  567. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  568.  
  569. -- Dump completed on 2013-11-20 13:46:03
Advertisement
Add Comment
Please, Sign In to add comment