質問編集履歴
2
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -7,7 +7,7 @@
|
|
|
7
7
|
Name varchar(256),
|
|
8
8
|
Brand varchar(32),
|
|
9
9
|
Category varchar(32),
|
|
10
|
-
Status
|
|
10
|
+
Status boolean,
|
|
11
11
|
PRIMARY KEY(ID),
|
|
12
12
|
INDEX(Name, Brand, Category)
|
|
13
13
|
)
|
1
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -3,11 +3,13 @@
|
|
|
3
3
|
```SQL
|
|
4
4
|
CREATE TABLE tb_items
|
|
5
5
|
(
|
|
6
|
-
ID int,
|
|
6
|
+
ID int NOT NULL,
|
|
7
7
|
Name varchar(256),
|
|
8
8
|
Brand varchar(32),
|
|
9
9
|
Category varchar(32),
|
|
10
|
-
Status smallint
|
|
10
|
+
Status smallint,
|
|
11
|
+
PRIMARY KEY(ID),
|
|
12
|
+
INDEX(Name, Brand, Category)
|
|
11
13
|
)
|
|
12
14
|
```
|
|
13
15
|
|
|
@@ -19,8 +21,11 @@
|
|
|
19
21
|
```SQL
|
|
20
22
|
CREATE TABLE tb_filter_keyword
|
|
21
23
|
(
|
|
24
|
+
ID int NOT NULL auto_increment,
|
|
22
25
|
Keyword varchar(24),
|
|
23
|
-
Type varchar(8)
|
|
26
|
+
Type varchar(8),
|
|
27
|
+
PRIMARY KEY(ID),
|
|
28
|
+
INDEX(Keyword)
|
|
24
29
|
)
|
|
25
30
|
```
|
|
26
31
|
|