· 8 years ago · May 16, 2018, 08:24 PM
1 "CREATE TABLE IF NOT EXISTS `Users` (
2 ID INT(11) NOT NULL AUTO_INCREMENT,
3
4 `Edited` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
5 `Created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
6
7 `Username` VARCHAR(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
8
9 `Password` VARBINARY(120) DEFAULT NULL,
10
11 `Vorname` VARBINARY(120) DEFAULT NULL,
12 `Nachname` VARBINARY(120) DEFAULT NULL,
13 `EMail` VARBINARY(120) DEFAULT NULL,
14 `Rechte` INT(1) DEFAULT 0,
15
16 PRIMARY KEY (ID),
17 UNIQUE (Username)
18 ) ENGINE=InnoDB DEFAULT CHARSET=utf8"