質問編集履歴
1
INDEX→UNIQUE
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -8,7 +8,7 @@
|
|
|
8
8
|
`type_id` INT NOT NULL,
|
|
9
9
|
`content_id` INT NOT NULL,
|
|
10
10
|
PRIMARY KEY (ID),
|
|
11
|
-
|
|
11
|
+
UNIQUE unique_students_1 (`class_id`,`type_id`,`content_id`)
|
|
12
12
|
);
|
|
13
13
|
INSERT INTO students (`ID`,`class_id`,`type_id`,`content_id`)
|
|
14
14
|
VALUES (1,10,100,1000),(2,20,200,2000),(3,30,300,3000),(4,40,400,4000);
|