| | |
|---|
| | | 'name' => 'varchar(255) NOT NULL', |
|---|
| | | 'email' => 'varchar(255) NOT NULL', |
|---|
| | | 'invitation_token' => 'varchar(255) NOT NULL', |
|---|
| | | 'invited_role' => 'varchar(50) NOT NULL COMMENT \'Role being invited to\'', |
|---|
| | | 'status' => 'ENUM(\'pending\',\'accepted\',\'rejected\',\'expired\',\'revoked\') DEFAULT \'pending\'', |
|---|
| | | 'inviters' => 'JSON NOT NULL COMMENT \'Array of {user_id, invited_at}\'', |
|---|
| | | 'invited_role' => 'varchar(50) NOT NULL', //Role being invited to |
|---|
| | | 'status' => "ENUM('pending','accepted','rejected','expired','revoked') DEFAULT 'pending'", |
|---|
| | | 'inviters' => 'JSON NOT NULL', // Array of {user_id, invited_at} |
|---|
| | | 'new_user_id' => $table->getUserIDType().' DEFAULT NULL', |
|---|
| | | 'expires_at' => 'datetime NOT NULL', |
|---|
| | | 'accepted_at' => 'datetime DEFAULT NULL', |
|---|
| | |
|---|
| | | |
|---|
| | | $table->setKeys([ |
|---|
| | | ['key' => 'PRIMARY', 'value' => '(`id`)'], |
|---|
| | | ['key' => 'UNIQUE KEY', 'value' => '`unique_email_role` (`email`, `invited_role`)'], |
|---|
| | | ['key' => 'UNIQUE', 'value' => '`unique_email_role` (`email`, `invited_role`)'], |
|---|
| | | '`token_lookup` (`invitation_token`)', |
|---|
| | | '`status_expiry` (`status`, `expires_at`)', |
|---|
| | | '`role_status` (`invited_role`, `status`)', |
|---|
