diff options
Diffstat (limited to 'dozentenmodulserver/setup/sat-01-testdata.sql')
-rw-r--r-- | dozentenmodulserver/setup/sat-01-testdata.sql | 14 |
1 files changed, 12 insertions, 2 deletions
diff --git a/dozentenmodulserver/setup/sat-01-testdata.sql b/dozentenmodulserver/setup/sat-01-testdata.sql index 4817f401..f01c7024 100644 --- a/dozentenmodulserver/setup/sat-01-testdata.sql +++ b/dozentenmodulserver/setup/sat-01-testdata.sql @@ -8,8 +8,18 @@ SET time_zone = "+00:00"; USE `sat`; -INSERT INTO `operatingsystem` (`osid`, `displayname`, `architecture`) VALUES -(1,'Windows 7 (64 Bit)','AMD64'),(2,'Windows 8 (32 Bit)','x86'),(3,'Windows 8 (64 Bit)','AMD64'),(4,'Ubuntu (32 Bit)','x86'),(5,'Ubuntu (64 Bit)','AMD64'),(6,'OpenSUSE (32 Bit)','x86'),(7,'OpenSUSE (64 Bit)','AMD64'),(8,'Other Linux (32 Bit)','x86'),(9,'Other Linux (64 Bit)','AMD64'),(10,'Windows 7 (32 Bit)','x86'); +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'); |