Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
lab4 [2018-11-23 14:18]
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 '0', 
 +  `Admin` tinyint(1) NOT NULL DEFAULT '0' 
 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
 ALTER TABLE `Users` ALTER TABLE `Users`
   ADD PRIMARY KEY (`UserID`),   ADD PRIMARY KEY (`UserID`),