diff options
| author | Simon Rettberg | 2015-09-04 15:50:33 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2015-09-04 15:50:33 +0200 |
| commit | cf5c2c886f65e61870b951546258949e3a4030f8 (patch) | |
| tree | 7ac4dfeb26c60a3213e9e4fa4c69f515a42e2e16 /dozentenmodulserver/setup/sat-01-schema.sql | |
| parent | [*] OS now has mem and cpu info (diff) | |
| download | tutor-module-cf5c2c886f65e61870b951546258949e3a4030f8.tar.gz tutor-module-cf5c2c886f65e61870b951546258949e3a4030f8.tar.xz tutor-module-cf5c2c886f65e61870b951546258949e3a4030f8.zip | |
[server] mailtest RPC methods, bugfixes to nanohttpd
Diffstat (limited to 'dozentenmodulserver/setup/sat-01-schema.sql')
| -rw-r--r-- | dozentenmodulserver/setup/sat-01-schema.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/dozentenmodulserver/setup/sat-01-schema.sql b/dozentenmodulserver/setup/sat-01-schema.sql index b0966e73..d44b0ed2 100644 --- a/dozentenmodulserver/setup/sat-01-schema.sql +++ b/dozentenmodulserver/setup/sat-01-schema.sql @@ -136,8 +136,10 @@ CREATE TABLE IF NOT EXISTS `lecturepermission` ( CREATE TABLE IF NOT EXISTS `operatingsystem` ( `osid` int(11) NOT NULL COMMENT 'Defined on the master server, so no auto_increment!', - `displayname` varchar(100) NOT NULL, - `architecture` varchar(14) NOT NULL, + `displayname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, + `architecture` varchar(14) COLLATE utf8mb4_unicode_ci NOT NULL, + `maxmem` int(11) NOT NULL, + `maxcpu` int(11) NOT NULL, PRIMARY KEY (`osid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |