matsuu
diff --git a/‎home/isucon/webapp/sql/1-schema.sql‎
Lines changed: 1 addition & 1 deletion b/‎home/isucon/webapp/sql/1-schema.sql‎
Lines changed: 1 addition & 1 deletion
@@ -145,7 +145,7 @@ CREATE TABLE coupons
 )
   COMMENT 'クーポンテーブル';
 ALTER TABLE coupons ADD INDEX (used_by);
-ALTER TABLE coupons ADD INDEX (user_id, code, used_by);
+ALTER TABLE coupons ADD INDEX (code, user_id, used_by);
 ALTER TABLE coupons ADD INDEX (user_id, used_by, created_at);
 
 ALTER TABLE chairs ADD COLUMN total_distance INTEGER NOT NULL DEFAULT 0 INVISIBLE;
Original file line number	Diff line number	Diff line change
`@@ -145,7 +145,7 @@ CREATE TABLE coupons`
`145`	`145`	`)`
`146`	`146`	`COMMENT 'クーポンテーブル';`
`147`	`147`	`ALTER TABLE coupons ADD INDEX (used_by);`
`148`		`-ALTER TABLE coupons ADD INDEX (user_id, code, used_by);`
	`148`	`+ALTER TABLE coupons ADD INDEX (code, user_id, used_by);`
`149`	`149`	`ALTER TABLE coupons ADD INDEX (user_id, used_by, created_at);`
`150`	`150`
`151`	`151`	`ALTER TABLE chairs ADD COLUMN total_distance INTEGER NOT NULL DEFAULT 0 INVISIBLE;`