Differences

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

--- systems:yii2:basic_user_login_from_database [2018/04/05 08:59]
smayr
+++ systems:yii2:basic_user_login_from_database [2018/04/05 17:49] (current)
smayr
@@ Line 32: / Line 32: @@
   PRIMARY KEY (`id`),
   UNIQUE KEY `username` (`username`),
-  INDEX `FK_contact_external_customer_id` (`external_customer_id`),
-  CONSTRAINT `FK_contact_customer_id` FOREIGN KEY (`customer_id`)
-      REFERENCES `customer` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
 )
 COLLATE='utf8_unicode_ci'
@@ Line 44: / Line 41: @@
 <code sql>
 CREATE TABLE `user` (
-  `id` int(11) NOT NULL,
+  `id` int(11) NOT NULL AUTO_INCREMENT,
   `first_name` varchar(255) NOT NULL,
   `last_name` varchar(255) NOT NULL,
@@ Line 56: / Line 53: @@
   `avatar` varchar(255) NOT NULL,
   `role` enum('Admin','Manager','Editor','Author','PowerUser','Registered') NOT NULL DEFAULT 'Registered'
-) ENGINE=InnoDB DEFAULT COLLATE=utf8_unicode_ci;
+)
+COLLATE='utf8_unicode_ci'
+ENGINE=InnoDB
+AUTO_INCREMENT=1;
 </code>