Elgg  Version 6.1
Public Member Functions | List of all members
CreateUsersEntityTable Class Reference
Inheritance diagram for CreateUsersEntityTable:

Public Member Functions

 change ()
 CREATE TABLE prefix_users_entity ( guid bigint(20) unsigned NOT NULL, name text NOT NULL, username varchar(128) NOT NULL DEFAULT '', – 255 chars is recommended by PHP.net to hold future hash formats password_hash varchar(255) NOT NULL DEFAULT '', email text NOT NULL, language varchar(6) NOT NULL DEFAULT '', banned enum('yes','no') NOT NULL DEFAULT 'no', admin enum('yes','no') NOT NULL DEFAULT 'no', last_action int(11) NOT NULL DEFAULT '0', prev_last_action int(11) NOT NULL DEFAULT '0', last_login int(11) NOT NULL DEFAULT '0', prev_last_login int(11) NOT NULL DEFAULT '0', PRIMARY KEY (guid), UNIQUE KEY username (username), KEY email (email(50)), KEY last_action (last_action), KEY last_login (last_login), KEY admin (admin) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;. More...
 

Detailed Description

Definition at line 6 of file 20170728075337_create_users_entity_table.php.

Member Function Documentation

CreateUsersEntityTable::change ( )

CREATE TABLE prefix_users_entity ( guid bigint(20) unsigned NOT NULL, name text NOT NULL, username varchar(128) NOT NULL DEFAULT '', – 255 chars is recommended by PHP.net to hold future hash formats password_hash varchar(255) NOT NULL DEFAULT '', email text NOT NULL, language varchar(6) NOT NULL DEFAULT '', banned enum('yes','no') NOT NULL DEFAULT 'no', admin enum('yes','no') NOT NULL DEFAULT 'no', last_action int(11) NOT NULL DEFAULT '0', prev_last_action int(11) NOT NULL DEFAULT '0', last_login int(11) NOT NULL DEFAULT '0', prev_last_login int(11) NOT NULL DEFAULT '0', PRIMARY KEY (guid), UNIQUE KEY username (username), KEY email (email(50)), KEY last_action (last_action), KEY last_login (last_login), KEY admin (admin) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;.

Definition at line 30 of file 20170728075337_create_users_entity_table.php.


The documentation for this class was generated from the following file: