| | |
|---|
| | | } |
|---|
| | | private function defineFavouriteTable():void |
|---|
| | | { |
|---|
| | | $table = CustomTable::for('favourites'); |
|---|
| | | $table = CustomTable::for('favourites', true); |
|---|
| | | |
|---|
| | | $table->setColumns([ |
|---|
| | | 'id' => 'bigint(20) unsigned NOT NULL AUTO_INCREMENT', |
|---|
| | |
|---|
| | | $table->setKeys([ |
|---|
| | | ['key' => 'PRIMARY', 'value' => '(`id`)'], |
|---|
| | | ['key' => 'UNIQUE', 'value' => '`unique_share_user` (`list_id`, `user_id`)'], |
|---|
| | | ['key'=> 'UNIQUE', 'value' => '`unique_share_email` (`list_id`, `email`'], |
|---|
| | | ['key'=> 'UNIQUE', 'value' => '`unique_share_email` (`list_id`, `email`)'], |
|---|
| | | '`list_shares` (`list_id`)', |
|---|
| | | '`list_user` (`list_id`, `user_id`)', |
|---|
| | | '`status_index` (`status`)' |
|---|
