Elgg
Version 6.1
|
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... | |
Definition at line 6 of file 20170728075337_create_users_entity_table.php.
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.