From d03885bc30bac41293b9648dd43ad6b6e9c61740 Mon Sep 17 00:00:00 2001
From: Jonathan Bauer
Date: Thu, 8 Nov 2018 13:21:00 +0100
Subject: update database schema dump

---
 extras/database.sql | 48 ++++++++++++++++++++++++------------------------
 1 file changed, 24 insertions(+), 24 deletions(-)

(limited to 'extras/database.sql')

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 */;
@@ -47,6 +47,25 @@ CREATE TABLE `imagebase` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!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
-- 
cgit v1.2.3-55-g7522

