From 7221633ee80c0d300803351fda0ab86d5893200c Mon Sep 17 00:00:00 2001
From: Jonathan Bauer
Date: Thu, 8 Nov 2018 14:44:27 +0100
Subject: added initial data for operatingsystem, virtualizer and os_x_virt

---
 extras/content.sql | 57 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 57 insertions(+)
 create mode 100644 extras/content.sql

diff --git a/extras/content.sql b/extras/content.sql
new file mode 100644
index 0000000..40db734
--- /dev/null
+++ b/extras/content.sql
@@ -0,0 +1,57 @@
+-- MySQL dump 10.16  Distrib 10.1.35-MariaDB, for debian-linux-gnu (i686)
+--
+-- Host: localhost    Database: bwlp
+-- ------------------------------------------------------
+-- 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 */;
+/*!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 */;
+
+--
+-- Dumping data for table `os_x_virt`
+--
+
+LOCK TABLES `os_x_virt` WRITE;
+/*!40000 ALTER TABLE `os_x_virt` DISABLE KEYS */;
+INSERT INTO `os_x_virt` VALUES (13,'virtualbox','Debian'),(14,'virtualbox','Debian_64'),(13,'vmware','debian8'),(14,'vmware','debian8-64'),(15,'virtualbox','DOS'),(15,'vmware','dos'),(8,'virtualbox','Linux'),(9,'virtualbox','Linux_64'),(6,'virtualbox','OpenSUSE'),(6,'vmware','opensuse'),(7,'virtualbox','OpenSUSE_64'),(7,'vmware','opensuse-64'),(16,'virtualbox','Other'),(16,'vmware','other'),(17,'virtualbox','Other_64'),(17,'vmware','other-64'),(8,'vmware','other3xlinux'),(9,'vmware','other3xlinux-64'),(4,'virtualbox','Ubuntu'),(4,'vmware','ubuntu'),(5,'virtualbox','Ubuntu_64'),(5,'vmware','ubuntu-64'),(11,'vmware','win2000pro'),(18,'virtualbox','Windows10_64'),(11,'virtualbox','Windows2000'),(10,'virtualbox','Windows7'),(10,'vmware','windows7'),(1,'virtualbox','Windows7_64'),(1,'vmware','windows7-64'),(2,'virtualbox','Windows8'),(2,'vmware','windows8'),(3,'virtualbox','Windows8_64'),(3,'vmware','windows8-64'),(18,'vmware','windows9-64'),(19,'virtualbox','WindowsNT'),(12,'virtualbox','WindowsXP'),(19,'vmware','winnt'),(12,'vmware','winxppro');
+/*!40000 ALTER TABLE `os_x_virt` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Dumping data for table `virtualizer`
+--
+
+LOCK TABLES `virtualizer` WRITE;
+/*!40000 ALTER TABLE `virtualizer` DISABLE KEYS */;
+INSERT INTO `virtualizer` VALUES ('qemukvm','QEMU-KVM'),('virtualbox','VirtualBox'),('vmware','VMware');
+/*!40000 ALTER TABLE `virtualizer` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Dumping data for table `operatingsystem`
+--
+
+LOCK TABLES `operatingsystem` WRITE;
+/*!40000 ALTER TABLE `operatingsystem` DISABLE KEYS */;
+INSERT INTO `operatingsystem` 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),(12,'Windows XP (32 Bit)','x86',4096,8),(13,'Debian (32Bit)','x86',0,0),(14,'Debian (64Bit)','AMD64',0,0),(15,'DOS','x86',32,1),(16,'Anderes (32 Bit)','x86',0,0),(17,'Anderes (64 Bit)','AMD64',0,0),(18,'Windows 10 (64 Bit)','AMD64',131072,256),(19,'Windows NT 4','x86',4096,4);
+/*!40000 ALTER TABLE `operatingsystem` ENABLE KEYS */;
+UNLOCK TABLES;
+/*!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 2018-10-16 11:55:16
-- 
cgit v1.2.3-55-g7522