Differences

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

--- systems:yii2:basic_user_login_from_database [2018/04/03 08:54]
smayr
+++ systems:yii2:basic_user_login_from_database [2018/04/05 17:49] (current)
smayr
@@ Line 7: / Line 7: @@
     //...
 }</code>
-  * Now in ''LoginForm'' model (''[app]/models/LoginForm.php''), define: <code php>LoginForm extends Model
+  * Now in ''LoginForm'' model (''[app]/models/LoginForm.php''), define: <code php>class LoginForm extends Model
 {
     public $username;
@@ 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`)
+COLLATE='utf8_unicode_ci'
-      REFERENCES `customer` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
+ENGINE=InnoDB
+AUTO_INCREMENT=1;
+</code>
+Or:
+<code sql>
+CREATE TABLE `user` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `first_name` varchar(255) NOT NULL,
+  `last_name` varchar(255) NOT NULL,
+  `username` varchar(255) NOT NULL,
+  `phone` varchar(255) NOT NULL,
+  `email` varchar(255) NOT NULL,
+  `password` varchar(255) NOT NULL,
+  `password_hash` varchar(255) NOT NULL,
+  `auth_key` varchar(255) NOT NULL,
+  `password_reset_token` varchar(250) NOT NULL,
+  `avatar` varchar(255) NOT NULL,
+  `role` enum('Admin','Manager','Editor','Author','PowerUser','Registered') NOT NULL DEFAULT 'Registered'
 )
 COLLATE='utf8_unicode_ci'