Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
lab4 [2018-11-23 14:15] Joakim Forsgren |
lab4 [2018-11-23 14:18] Joakim Forsgren |
||
|---|---|---|---|
| Line 15: | Line 15: | ||
| 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; | ||
| </ | </ | ||