====== Anhang E "Users“ Datenbank (thesis.sql) ======
[[wiki:angewandte_informatik:kekse_ohne_salz_schmecken_nicht:szenario4:start|zurück zur Seite des Unterrichtsszenarios]]

<file sql thesis.sql>
/*!
 * thesis.sql v4.2.0 (for Thesis Project)
 * Copyright (C) 2016 Simon Marik <simon.marik@univie.ac.at>
 * Licensed under the GNU General Public License v3.0
 */

CREATE TABLE ‘thesis_users‘ (
   ‘id‘ int(5) unsigned NOT NULL,
   ‘username‘ varchar(500) NOT NULL,
   ‘password‘ varchar(500) NOT NULL,
   ‘groups‘ varchar(100) NOT NULL
)

ENGINE=InnoDB AUTO_INCREMENT=1  DEFAULT CHARSET=utf8;
ALTER TABLE ‘thesis_users‘ ADD PRIMARY KEY (‘id‘);
</file>