summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJonathan Bauer2018-11-08 13:21:00 +0100
committerJonathan Bauer2018-11-08 13:21:00 +0100
commitd03885bc30bac41293b9648dd43ad6b6e9c61740 (patch)
treea09ca32622e35aaf36c98663446442a17e87815c
parentUpdate IdP Importer (diff)
downloadmasterserver-d03885bc30bac41293b9648dd43ad6b6e9c61740.tar.gz
masterserver-d03885bc30bac41293b9648dd43ad6b6e9c61740.tar.xz
masterserver-d03885bc30bac41293b9648dd43ad6b6e9c61740.zip
update database schema dump
-rw-r--r--extras/database.sql48
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