6 lines
248 B
MySQL
6 lines
248 B
MySQL
|
ALTER TABLE `CheckIn_Record`
|
||
|
|
ADD UNIQUE KEY `uk_checkin_record_user_date_type_deleted` (`UserId`, `CheckInDate`, `Type`, `IsDeleted`);
|
||
|
|
|
||
|
|
ALTER TABLE `User_Bag`
|
||
|
|
ADD UNIQUE KEY `uk_user_bag_available_item` (`UserId`, `ItemId`, `Status`, `IsDeleted`);
|