zurück zur Seite des Unterrichtsszenarios

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‘);