|
Elgg
Version master
|
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.