SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!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 */;

USE `sat`;

INSERT INTO `operatingsystem` (`osid`, `displayname`, `architecture`, `maxmem`, `maxcpu`) VALUES
(1, 'Windows 7 (64 Bit)', 'AMD64', 196608, 256),
(2, 'Windows 8 (32 Bit)', 'x86', 4096, 32),
(3, 'Windows 8 (64 Bit)', 'AMD64', 131072, 256),
(4, 'Ubuntu (32 Bit)', 'x86', 0, 0),
(5, 'Ubuntu (64 Bit)', 'AMD64', 0, 0),
(6, 'OpenSUSE (32 Bit)', 'x86', 0, 0),
(7, 'OpenSUSE (64 Bit)', 'AMD64', 0, 0),
(8, 'Other Linux (32 Bit)', 'x86', 0, 0),
(9, 'Other Linux (64 Bit)', 'AMD64', 0, 0),
(10, 'Windows 7 (32 Bit)', 'x86', 4096, 32),
(11, 'Windows 2000 Professional', 'x86', 4096, 4);

INSERT INTO `virtualizer` (`virtid`, `virtname`) VALUES
('vmware', 'VMware'),('virtualbox', 'VirtualBox'),('qemukvm', 'QEMU'),('docker', 'Docker');

INSERT INTO `os_x_virt` VALUES
(6,'vmware','opensuse'),(7,'vmware','opensuse-64'),(8,'vmware','other3xlinux'),(9,'vmware','other3xlinux-64'),(4,'vmware','ubuntu'),(5,'vmware','ubuntu-64'),(10,'vmware','windows7'),(1,'vmware','windows7-64'),(2,'vmware','windows8'),(3,'vmware','windows8-64');

INSERT INTO `organization` (`organizationid`, `displayname`, `canlogin`) VALUES
('blblogin.blb-karlsruhe.de', 'Badische Landesbibliothek', 0),
('bsz-bw.de', 'Bibliotheksservice-Zentrum Baden-Württemberg', 0),
('demo', 'Demo-Satellit', 0),
('dhbw-karlsruhe.de', 'DHBW Karlsruhe', 0),
('dhbw-loerrach.de', 'DHBW Lörrach', 0),
('dhbw-mannheim.de', 'DHBW Mannheim', 0),
('dhbw-stuttgart.de', 'DHBW Stuttgart', 0),
('dhbw-vs.de', 'DHBW Villingen-Schwenningen', 0),
('fr-test.de', 'Uni Freiburg TEST', 0),
('hft-stuttgart.de', 'Hochschule für Technik Stuttgart', 0),
('hs-albsig.de', 'Hochschule Albstadt-Sigmaringen', 0),
('hs-esslingen.de', 'Hochschule Esslingen', 0),
('hs-furtwangen.de', 'Hochschule Furtwangen University', 0),
('hs-heilbronn.de', 'Hochschule Heilbronn', 0),
('hs-karlsruhe.de', 'Hochschule Karlsruhe - Technik und Wirtschaft', 0),
('hs-mannheim.de', 'Hochschule Mannheim', 0),
('hs-offenburg.de', 'Hochschule Offenburg', 0),
('hs-rottenburg.de', 'Hochschule für Forstwirtschaft Rottenburg (HFR)', 0),
('htw-aalen.de', 'Hochschule Aalen - Technik und Wirtschaft', 0),
('htwg-konstanz.de', 'HTWG Konstanz', 0),
('kit.edu', 'Karlsruher Institut für Technologie (KIT)', 0),
('lb.ph-ludwigsburg.de', 'PH Ludwigsburg', 0),
('ph-freiburg.de', 'PH Freiburg', 0),
('ph-gmuend.de', 'PH Schwäbisch Gmünd', 0),
('ph-karlsruhe.de', 'PH Karlsruhe', 0),
('ph-weingarten.de', 'PH Weingarten', 0),
('reutlingen-university-test.de', 'Reutlingen TEST', 0),
('reutlingen-university.de', 'Reutlingen University / Hochschule Reutlingen', 0),
('test-hs-offenburg.de', 'HS Offenburg test', 0),
('test-uni-ulm.de', 'Universität Ulm Test', 0),
('testscope.aai.dfn.de', 'DFN Test IdP 3', 0),
('uni-freiburg.de', 'Albert-Ludwigs-Universität Freiburg', 0),
('uni-heidelberg.de', 'Universität Heidelberg', 0),
('uni-hohenheim.de', 'Universität Hohenheim', 0),
('uni-konstanz.de', 'Universität Konstanz', 0),
('uni-mannheim.de', 'Universität Mannheim', 0),
('uni-stuttgart.de', 'Universität Stuttgart', 0),
('uni-tuebingen.de', 'Universität Tübingen', 0),
('uni-ulm.de', 'Universität Ulm', 0);

INSERT INTO `user` (`userid`, `firstname`, `lastname`, `email`, `organizationid`, `lastlogin`, `canlogin`, `issuperuser`) VALUES
('2f2a7203-1035-11e5-97f5-001999f89615', 'Max', 'Mustermann', 'spam@aol.com', 'fr-test.de', 1434025631, 1, 1);

INSERT INTO `imagebase` (`imagebaseid`, `latestversionid`, `displayname`, `description`, `osid`, `virtid`, `createtime`, `updatetime`, `ownerid`, `updaterid`, `sharemode`, `istemplate`, `canlinkdefault`, `candownloaddefault`, `caneditdefault`, `canadmindefault`) VALUES
('ba9e1f3a-1035-11e5-97f5-001999f89615', NULL, 'Test Image', 'Bla bla bla', 1, 'vmware', 1434025865, 1434025865, '2f2a7203-1035-11e5-97f5-001999f89615', '2f2a7203-1035-11e5-97f5-001999f89615', 'LOCAL', 0, 1, 1, 0, 0);

INSERT INTO `imagepermission` (`imagebaseid`, `userid`, `canlink`, `candownload`, `canedit`, `canadmin`) VALUES
('ba9e1f3a-1035-11e5-97f5-001999f89615', '2f2a7203-1035-11e5-97f5-001999f89615', 1, 1, 1, 1);

INSERT INTO `imageversion` (`imageversionid`, `imagebaseid`, `createtime`, `expiretime`, `filesize`, `filepath`, `uploaderid`, `isrestricted`, `isvalid`, `isprocessed`, `mastersha1`, `virtualizerconfig`) VALUES
('37613571-1036-11e5-97f5-001999f89615', 'ba9e1f3a-1035-11e5-97f5-001999f89615', 1434026074, 1434026074, 1234, 'y', '2f2a7203-1035-11e5-97f5-001999f89615', 1, 1, 1, NULL, NULL),
('721ab892-103e-11e5-97f5-001999f89615', 'ba9e1f3a-1035-11e5-97f5-001999f89615', 1434029609, 1434029609, 23452345, 'a', '2f2a7203-1035-11e5-97f5-001999f89615', 1, 1, 1, NULL, NULL);

/*!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 */;
