Tag: UNIQUE
-
Post Views: 19 1. The article involving the 1st table, the Penguin number: cpa_qq_article, the field needs to be verified: the uniqueness of the title, the structure of the table is shown in Figure 1 2. The task of the application of the channel involved in the second table, the application task of the channel: CPA_CHANNEL_APP_TASK, field: task_id and the…
-
Post Views: 41 1. In Postman, posthttp://api.github-shuijingwan-yii2-app-advanced.localhost/v1/users201 response, the status value is 1 by default 2. In Postman, deletehttp://api.github-shuijingwan-yii2-app-advanced.localhost/v1/users/1, 200 responses 3. In Postman, posthttp://api.github-shuijingwan-yii2-app-advanced.localhost/v1/users,422 response, not as expected, expected to be 201 response, because “username”: “111111” has been deleted 4. Create a new \console\migrations\m180925_054952_add_is_deleted_and_deleted_at_to_user.php. Update field, status, status, 0: disabled; 1: enabled, default: 1. Added field, is_deleted, whether it…
-
Post Views: 50 1. In the production environment, the data in the skill data table is repeatedly written, as shown in Figure 1 2. However, before writing, it is judged whether the record exists. The combination of GAME_CODE and TEAM_CODE should be the only one, as shown in Figure 2 3. It is recommended to check the website first: https://www.shuijingwanwq.com/2017/04/18/1568/…