Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
lab4 [2018-11-23 14:15] Joakim Forsgren |
lab4 [2018-11-23 14:22] Joakim Forsgren |
||
|---|---|---|---|
| Line 11: | Line 11: | ||
| Från {{ :login.zip |lektion}} | Från {{ :login.zip |lektion}} | ||
| <code mysql> | <code mysql> | ||
| - | # Detta kom inte med... | + | # Dump av struktur från lektion. |
| + | CREATE TABLE `Users` ( | ||
| + | `UserID` int(11) NOT NULL, | ||
| + | `FirstName` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | ||
| + | `LastName` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | ||
| + | `EMail` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | ||
| + | `Password` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | ||
| + | `Deleted` tinyint(1) NOT NULL DEFAULT ' | ||
| + | `Admin` tinyint(1) NOT NULL DEFAULT ' | ||
| + | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | ||
| ALTER TABLE `Users` | ALTER TABLE `Users` | ||
| ADD PRIMARY KEY (`UserID`), | ADD PRIMARY KEY (`UserID`), | ||
| ADD UNIQUE KEY `EMail` (`EMail`); | ADD UNIQUE KEY `EMail` (`EMail`); | ||
| + | | ||
| + | ALTER TABLE `Users` | ||
| + | MODIFY `UserID` int(11) NOT NULL AUTO_INCREMENT; | ||
| + | COMMIT; | ||
| </ | </ | ||