Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL dump 10.13 Distrib 5.5.23, for Linux (x86_64)
- --
- -- Host: localhost Database: bacula
- -- ------------------------------------------------------
- -- Server version 5.5.23-log
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- --
- -- Table structure for table `BaseFiles`
- --
- DROP TABLE IF EXISTS `BaseFiles`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `BaseFiles` (
- `BaseId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `BaseJobId` INT(10) UNSIGNED NOT NULL,
- `JobId` INT(10) UNSIGNED NOT NULL,
- `FileId` BIGINT(20) UNSIGNED NOT NULL,
- `FileIndex` INT(10) UNSIGNED DEFAULT NULL,
- PRIMARY KEY (`BaseId`),
- KEY `basefiles_jobid_idx` (`JobId`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `CDImages`
- --
- DROP TABLE IF EXISTS `CDImages`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `CDImages` (
- `MediaId` INT(10) UNSIGNED NOT NULL,
- `LastBurn` datetime NOT NULL,
- PRIMARY KEY (`MediaId`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `Client`
- --
- DROP TABLE IF EXISTS `Client`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Client` (
- `ClientId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `Name` tinyblob NOT NULL,
- `Uname` tinyblob NOT NULL,
- `AutoPrune` tinyint(4) DEFAULT '0',
- `FileRetention` BIGINT(20) UNSIGNED DEFAULT '0',
- `JobRetention` BIGINT(20) UNSIGNED DEFAULT '0',
- PRIMARY KEY (`ClientId`),
- UNIQUE KEY `Name` (`Name`(128))
- ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `Counters`
- --
- DROP TABLE IF EXISTS `Counters`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Counters` (
- `Counter` tinyblob NOT NULL,
- `MinValue` INT(11) DEFAULT '0',
- `MaxValue` INT(11) DEFAULT '0',
- `CurrentValue` INT(11) DEFAULT '0',
- `WrapCounter` tinyblob NOT NULL,
- PRIMARY KEY (`Counter`(128))
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `Device`
- --
- DROP TABLE IF EXISTS `Device`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Device` (
- `DeviceId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `Name` tinyblob NOT NULL,
- `MediaTypeId` INT(10) UNSIGNED DEFAULT '0',
- `StorageId` INT(10) UNSIGNED DEFAULT '0',
- `DevMounts` INT(10) UNSIGNED DEFAULT '0',
- `DevReadBytes` BIGINT(20) UNSIGNED DEFAULT '0',
- `DevWriteBytes` BIGINT(20) UNSIGNED DEFAULT '0',
- `DevReadBytesSinceCleaning` BIGINT(20) UNSIGNED DEFAULT '0',
- `DevWriteBytesSinceCleaning` BIGINT(20) UNSIGNED DEFAULT '0',
- `DevReadTime` BIGINT(20) UNSIGNED DEFAULT '0',
- `DevWriteTime` BIGINT(20) UNSIGNED DEFAULT '0',
- `DevReadTimeSinceCleaning` BIGINT(20) UNSIGNED DEFAULT '0',
- `DevWriteTimeSinceCleaning` BIGINT(20) UNSIGNED DEFAULT '0',
- `CleaningDate` datetime DEFAULT '0000-00-00 00:00:00',
- `CleaningPeriod` BIGINT(20) UNSIGNED DEFAULT '0',
- PRIMARY KEY (`DeviceId`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `File`
- --
- DROP TABLE IF EXISTS `File`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `File` (
- `FileId` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
- `FileIndex` INT(10) UNSIGNED DEFAULT '0',
- `JobId` INT(10) UNSIGNED NOT NULL,
- `PathId` INT(10) UNSIGNED NOT NULL,
- `FilenameId` INT(10) UNSIGNED NOT NULL,
- `DeltaSeq` SMALLINT(5) UNSIGNED DEFAULT '0',
- `MarkId` INT(10) UNSIGNED DEFAULT '0',
- `LStat` tinyblob NOT NULL,
- `MD5` tinyblob,
- PRIMARY KEY (`FileId`),
- KEY `file_jobid_idx` (`JobId`),
- KEY `file_jpf_idx` (`JobId`,`PathId`,`FilenameId`)
- ) ENGINE=InnoDB AUTO_INCREMENT=9704306 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `FileSet`
- --
- DROP TABLE IF EXISTS `FileSet`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `FileSet` (
- `FileSetId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `FileSet` tinyblob NOT NULL,
- `MD5` tinyblob,
- `CreateTime` datetime DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`FileSetId`)
- ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `Filename`
- --
- DROP TABLE IF EXISTS `Filename`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Filename` (
- `FilenameId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `Name` BLOB NOT NULL,
- PRIMARY KEY (`FilenameId`),
- KEY `Name` (`Name`(255))
- ) ENGINE=InnoDB AUTO_INCREMENT=1315292 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `Job`
- --
- DROP TABLE IF EXISTS `Job`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Job` (
- `JobId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `Job` tinyblob NOT NULL,
- `Name` tinyblob NOT NULL,
- `Type` BINARY(1) NOT NULL,
- `Level` BINARY(1) NOT NULL,
- `ClientId` INT(11) DEFAULT '0',
- `JobStatus` BINARY(1) NOT NULL,
- `SchedTime` datetime DEFAULT '0000-00-00 00:00:00',
- `StartTime` datetime DEFAULT '0000-00-00 00:00:00',
- `EndTime` datetime DEFAULT '0000-00-00 00:00:00',
- `RealEndTime` datetime DEFAULT '0000-00-00 00:00:00',
- `JobTDate` BIGINT(20) UNSIGNED DEFAULT '0',
- `VolSessionId` INT(10) UNSIGNED DEFAULT '0',
- `VolSessionTime` INT(10) UNSIGNED DEFAULT '0',
- `JobFiles` INT(10) UNSIGNED DEFAULT '0',
- `JobBytes` BIGINT(20) UNSIGNED DEFAULT '0',
- `ReadBytes` BIGINT(20) UNSIGNED DEFAULT '0',
- `JobErrors` INT(10) UNSIGNED DEFAULT '0',
- `JobMissingFiles` INT(10) UNSIGNED DEFAULT '0',
- `PoolId` INT(10) UNSIGNED DEFAULT '0',
- `FileSetId` INT(10) UNSIGNED DEFAULT '0',
- `PriorJobId` INT(10) UNSIGNED DEFAULT '0',
- `PurgedFiles` tinyint(4) DEFAULT '0',
- `HasBase` tinyint(4) DEFAULT '0',
- `HasCache` tinyint(4) DEFAULT '0',
- `Reviewed` tinyint(4) DEFAULT '0',
- `Comment` BLOB,
- PRIMARY KEY (`JobId`),
- KEY `Name` (`Name`(128))
- ) ENGINE=InnoDB AUTO_INCREMENT=970 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `JobHisto`
- --
- DROP TABLE IF EXISTS `JobHisto`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `JobHisto` (
- `JobId` INT(10) UNSIGNED NOT NULL,
- `Job` tinyblob NOT NULL,
- `Name` tinyblob NOT NULL,
- `Type` BINARY(1) NOT NULL,
- `Level` BINARY(1) NOT NULL,
- `ClientId` INT(11) DEFAULT '0',
- `JobStatus` BINARY(1) NOT NULL,
- `SchedTime` datetime DEFAULT '0000-00-00 00:00:00',
- `StartTime` datetime DEFAULT '0000-00-00 00:00:00',
- `EndTime` datetime DEFAULT '0000-00-00 00:00:00',
- `RealEndTime` datetime DEFAULT '0000-00-00 00:00:00',
- `JobTDate` BIGINT(20) UNSIGNED DEFAULT '0',
- `VolSessionId` INT(10) UNSIGNED DEFAULT '0',
- `VolSessionTime` INT(10) UNSIGNED DEFAULT '0',
- `JobFiles` INT(10) UNSIGNED DEFAULT '0',
- `JobBytes` BIGINT(20) UNSIGNED DEFAULT '0',
- `ReadBytes` BIGINT(20) UNSIGNED DEFAULT '0',
- `JobErrors` INT(10) UNSIGNED DEFAULT '0',
- `JobMissingFiles` INT(10) UNSIGNED DEFAULT '0',
- `PoolId` INT(10) UNSIGNED DEFAULT '0',
- `FileSetId` INT(10) UNSIGNED DEFAULT '0',
- `PriorJobId` INT(10) UNSIGNED DEFAULT '0',
- `PurgedFiles` tinyint(4) DEFAULT '0',
- `HasBase` tinyint(4) DEFAULT '0',
- `HasCache` tinyint(4) DEFAULT '0',
- `Reviewed` tinyint(4) DEFAULT '0',
- `Comment` BLOB,
- KEY `JobId` (`JobId`),
- KEY `StartTime` (`StartTime`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `JobMedia`
- --
- DROP TABLE IF EXISTS `JobMedia`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `JobMedia` (
- `JobMediaId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `JobId` INT(10) UNSIGNED NOT NULL,
- `MediaId` INT(10) UNSIGNED NOT NULL,
- `FirstIndex` INT(10) UNSIGNED DEFAULT '0',
- `LastIndex` INT(10) UNSIGNED DEFAULT '0',
- `StartFile` INT(10) UNSIGNED DEFAULT '0',
- `EndFile` INT(10) UNSIGNED DEFAULT '0',
- `StartBlock` INT(10) UNSIGNED DEFAULT '0',
- `EndBlock` INT(10) UNSIGNED DEFAULT '0',
- `VolIndex` INT(10) UNSIGNED DEFAULT '0',
- PRIMARY KEY (`JobMediaId`),
- KEY `JobId` (`JobId`,`MediaId`)
- ) ENGINE=InnoDB AUTO_INCREMENT=10446 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `Location`
- --
- DROP TABLE IF EXISTS `Location`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Location` (
- `LocationId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `Location` tinyblob NOT NULL,
- `Cost` INT(11) DEFAULT '0',
- `Enabled` tinyint(4) DEFAULT NULL,
- PRIMARY KEY (`LocationId`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `LocationLog`
- --
- DROP TABLE IF EXISTS `LocationLog`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `LocationLog` (
- `LocLogId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `Date` datetime DEFAULT '0000-00-00 00:00:00',
- `Comment` BLOB NOT NULL,
- `MediaId` INT(10) UNSIGNED DEFAULT '0',
- `LocationId` INT(10) UNSIGNED DEFAULT '0',
- `NewVolStatus` enum('Full','Archive','Append','Recycle','Purged','Read-Only','Disabled','Error','Busy','Used','Cleaning') NOT NULL,
- `NewEnabled` tinyint(4) DEFAULT NULL,
- PRIMARY KEY (`LocLogId`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `Log`
- --
- DROP TABLE IF EXISTS `Log`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Log` (
- `LogId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `JobId` INT(10) UNSIGNED DEFAULT '0',
- `Time` datetime DEFAULT '0000-00-00 00:00:00',
- `LogText` BLOB NOT NULL,
- PRIMARY KEY (`LogId`),
- KEY `JobId` (`JobId`)
- ) ENGINE=InnoDB AUTO_INCREMENT=74519883 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `Media`
- --
- DROP TABLE IF EXISTS `Media`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Media` (
- `MediaId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `VolumeName` tinyblob NOT NULL,
- `Slot` INT(11) DEFAULT '0',
- `PoolId` INT(10) UNSIGNED DEFAULT '0',
- `MediaType` tinyblob NOT NULL,
- `MediaTypeId` INT(10) UNSIGNED DEFAULT '0',
- `LabelType` tinyint(4) DEFAULT '0',
- `FirstWritten` datetime DEFAULT '0000-00-00 00:00:00',
- `LastWritten` datetime DEFAULT '0000-00-00 00:00:00',
- `LabelDate` datetime DEFAULT '0000-00-00 00:00:00',
- `VolJobs` INT(10) UNSIGNED DEFAULT '0',
- `VolFiles` INT(10) UNSIGNED DEFAULT '0',
- `VolBlocks` INT(10) UNSIGNED DEFAULT '0',
- `VolMounts` INT(10) UNSIGNED DEFAULT '0',
- `VolBytes` BIGINT(20) UNSIGNED DEFAULT '0',
- `VolParts` INT(10) UNSIGNED DEFAULT '0',
- `VolErrors` INT(10) UNSIGNED DEFAULT '0',
- `VolWrites` INT(10) UNSIGNED DEFAULT '0',
- `VolCapacityBytes` BIGINT(20) UNSIGNED DEFAULT '0',
- `VolStatus` enum('Full','Archive','Append','Recycle','Purged','Read-Only','Disabled','Error','Busy','Used','Cleaning') NOT NULL,
- `Enabled` tinyint(4) DEFAULT '1',
- `Recycle` tinyint(4) DEFAULT '0',
- `ActionOnPurge` tinyint(4) DEFAULT '0',
- `VolRetention` BIGINT(20) UNSIGNED DEFAULT '0',
- `VolUseDuration` BIGINT(20) UNSIGNED DEFAULT '0',
- `MaxVolJobs` INT(10) UNSIGNED DEFAULT '0',
- `MaxVolFiles` INT(10) UNSIGNED DEFAULT '0',
- `MaxVolBytes` BIGINT(20) UNSIGNED DEFAULT '0',
- `InChanger` tinyint(4) DEFAULT '0',
- `StorageId` INT(10) UNSIGNED DEFAULT '0',
- `DeviceId` INT(10) UNSIGNED DEFAULT '0',
- `MediaAddressing` tinyint(4) DEFAULT '0',
- `VolReadTime` BIGINT(20) UNSIGNED DEFAULT '0',
- `VolWriteTime` BIGINT(20) UNSIGNED DEFAULT '0',
- `EndFile` INT(10) UNSIGNED DEFAULT '0',
- `EndBlock` INT(10) UNSIGNED DEFAULT '0',
- `LocationId` INT(10) UNSIGNED DEFAULT '0',
- `RecycleCount` INT(10) UNSIGNED DEFAULT '0',
- `InitialWrite` datetime DEFAULT '0000-00-00 00:00:00',
- `ScratchPoolId` INT(10) UNSIGNED DEFAULT '0',
- `RecyclePoolId` INT(10) UNSIGNED DEFAULT '0',
- `Comment` BLOB,
- PRIMARY KEY (`MediaId`),
- UNIQUE KEY `VolumeName` (`VolumeName`(128)),
- KEY `PoolId` (`PoolId`)
- ) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `MediaType`
- --
- DROP TABLE IF EXISTS `MediaType`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `MediaType` (
- `MediaTypeId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `MediaType` tinyblob NOT NULL,
- `ReadOnly` tinyint(4) DEFAULT '0',
- PRIMARY KEY (`MediaTypeId`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `Path`
- --
- DROP TABLE IF EXISTS `Path`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Path` (
- `PathId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `Path` BLOB NOT NULL,
- PRIMARY KEY (`PathId`),
- KEY `Path` (`Path`(255))
- ) ENGINE=InnoDB AUTO_INCREMENT=168299 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `PathHierarchy`
- --
- DROP TABLE IF EXISTS `PathHierarchy`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `PathHierarchy` (
- `PathId` INT(11) NOT NULL,
- `PPathId` INT(11) NOT NULL,
- PRIMARY KEY (`PathId`),
- KEY `pathhierarchy_ppathid` (`PPathId`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `PathVisibility`
- --
- DROP TABLE IF EXISTS `PathVisibility`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `PathVisibility` (
- `PathId` INT(11) NOT NULL,
- `JobId` INT(11) NOT NULL,
- `Size` BIGINT(20) DEFAULT '0',
- `Files` INT(11) DEFAULT '0',
- PRIMARY KEY (`JobId`,`PathId`),
- KEY `pathvisibility_jobid` (`JobId`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `Pool`
- --
- DROP TABLE IF EXISTS `Pool`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Pool` (
- `PoolId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `Name` tinyblob NOT NULL,
- `NumVols` INT(10) UNSIGNED DEFAULT '0',
- `MaxVols` INT(10) UNSIGNED DEFAULT '0',
- `UseOnce` tinyint(4) DEFAULT '0',
- `UseCatalog` tinyint(4) DEFAULT '0',
- `AcceptAnyVolume` tinyint(4) DEFAULT '0',
- `VolRetention` BIGINT(20) UNSIGNED DEFAULT '0',
- `VolUseDuration` BIGINT(20) UNSIGNED DEFAULT '0',
- `MaxVolJobs` INT(10) UNSIGNED DEFAULT '0',
- `MaxVolFiles` INT(10) UNSIGNED DEFAULT '0',
- `MaxVolBytes` BIGINT(20) UNSIGNED DEFAULT '0',
- `AutoPrune` tinyint(4) DEFAULT '0',
- `Recycle` tinyint(4) DEFAULT '0',
- `ActionOnPurge` tinyint(4) DEFAULT '0',
- `PoolType` enum('Backup','Copy','Cloned','Archive','Migration','Scratch') NOT NULL,
- `LabelType` tinyint(4) DEFAULT '0',
- `LabelFormat` tinyblob,
- `Enabled` tinyint(4) DEFAULT '1',
- `ScratchPoolId` INT(10) UNSIGNED DEFAULT '0',
- `RecyclePoolId` INT(10) UNSIGNED DEFAULT '0',
- `NextPoolId` INT(10) UNSIGNED DEFAULT '0',
- `MigrationHighBytes` BIGINT(20) UNSIGNED DEFAULT '0',
- `MigrationLowBytes` BIGINT(20) UNSIGNED DEFAULT '0',
- `MigrationTime` BIGINT(20) UNSIGNED DEFAULT '0',
- PRIMARY KEY (`PoolId`),
- UNIQUE KEY `Name` (`Name`(128))
- ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `RestoreObject`
- --
- DROP TABLE IF EXISTS `RestoreObject`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `RestoreObject` (
- `RestoreObjectId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `ObjectName` BLOB NOT NULL,
- `RestoreObject` longblob NOT NULL,
- `PluginName` tinyblob NOT NULL,
- `ObjectLength` INT(11) DEFAULT '0',
- `ObjectFullLength` INT(11) DEFAULT '0',
- `ObjectIndex` INT(11) DEFAULT '0',
- `ObjectType` INT(11) DEFAULT '0',
- `FileIndex` INT(10) UNSIGNED DEFAULT '0',
- `JobId` INT(10) UNSIGNED NOT NULL,
- `ObjectCompression` INT(11) DEFAULT '0',
- PRIMARY KEY (`RestoreObjectId`),
- KEY `JobId` (`JobId`)
- ) ENGINE=InnoDB AUTO_INCREMENT=265 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `Status`
- --
- DROP TABLE IF EXISTS `Status`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Status` (
- `JobStatus` CHAR(1) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
- `JobStatusLong` BLOB,
- `Severity` INT(11) DEFAULT NULL,
- PRIMARY KEY (`JobStatus`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `Storage`
- --
- DROP TABLE IF EXISTS `Storage`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Storage` (
- `StorageId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `Name` tinyblob NOT NULL,
- `AutoChanger` tinyint(4) DEFAULT '0',
- PRIMARY KEY (`StorageId`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `UnsavedFiles`
- --
- DROP TABLE IF EXISTS `UnsavedFiles`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `UnsavedFiles` (
- `UnsavedId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `JobId` INT(10) UNSIGNED NOT NULL,
- `PathId` INT(10) UNSIGNED NOT NULL,
- `FilenameId` INT(10) UNSIGNED NOT NULL,
- PRIMARY KEY (`UnsavedId`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `Version`
- --
- DROP TABLE IF EXISTS `Version`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `Version` (
- `VersionId` INT(10) UNSIGNED NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- -- Dump completed on 2013-11-20 13:46:03
Advertisement
Add Comment
Please, Sign In to add comment