diff options
| -rw-r--r-- | extras/database.sql | 48 |
1 files changed, 24 insertions, 24 deletions
diff --git a/extras/database.sql b/extras/database.sql index 54d582b..538de95 100644 --- a/extras/database.sql +++ b/extras/database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 5.5.47, for debian-linux-gnu (i686) +-- MySQL dump 10.16 Distrib 10.1.35-MariaDB, for debian-linux-gnu (i686) -- -- Host: localhost Database: bwlp -- ------------------------------------------------------ --- Server version 5.5.47-0+deb7u1 +-- Server version 10.1.35-MariaDB-1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -48,6 +48,25 @@ CREATE TABLE `imagebase` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `imageblock` +-- + +DROP TABLE IF EXISTS `imageblock`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `imageblock` ( + `imageversionid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, + `startbyte` bigint(20) NOT NULL, + `blocksize` int(11) NOT NULL, + `blocksha1` binary(20) DEFAULT NULL, + `ismissing` tinyint(1) NOT NULL COMMENT 'true if this block is missing from the file, either because it was not transferred to the server yet, or because it failed an integrity check.', + PRIMARY KEY (`imageversionid`,`startbyte`,`blocksize`), + KEY `checksums` (`blocksha1`,`blocksize`), + CONSTRAINT `fk_imageblocksha1_1` FOREIGN KEY (`imageversionid`) REFERENCES `imageversion` (`imageversionid`) ON DELETE CASCADE ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `imageversion` -- @@ -89,7 +108,7 @@ CREATE TABLE `operatingsystem` ( `maxmem` int(11) NOT NULL DEFAULT '0', `maxcpu` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`osid`) -) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -163,7 +182,7 @@ CREATE TABLE `satellite` ( UNIQUE KEY `organizationid` (`organizationid`,`satellitename`), KEY `dateline` (`dateline`), CONSTRAINT `satellite_ibfk_1` FOREIGN KEY (`organizationid`) REFERENCES `organization` (`organizationid`) -) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -217,25 +236,6 @@ CREATE TABLE `websession` ( PRIMARY KEY (`sid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `imageblock` --- - -CREATE TABLE `imageblock` ( - `imageversionid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, - `startbyte` bigint(20) NOT NULL, - `blocksize` int(11) NOT NULL, - `blocksha1` binary(20) DEFAULT NULL, - `ismissing` tinyint(1) NOT NULL COMMENT 'true if this block is missing from the file, either because it was not transferred to the server yet, or because it failed an integrity check.', - PRIMARY KEY (`imageversionid`,`startbyte`,`blocksize`), - KEY `checksums` (`blocksha1`,`blocksize`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; - -ALTER TABLE `imageblock` - ADD CONSTRAINT `fk_imageblocksha1_1` FOREIGN KEY (`imageversionid`) REFERENCES `imageversion` (`imageversionid`) ON DELETE CASCADE ON UPDATE CASCADE; - - /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; @@ -246,4 +246,4 @@ ALTER TABLE `imageblock` /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2016-04-04 11:35:20 +-- Dump completed on 2018-10-15 13:36:27 |