質問編集履歴
2
test
CHANGED
File without changes
|
test
CHANGED
@@ -16,7 +16,7 @@
|
|
16
16
|
|
17
17
|
Category varchar(32),
|
18
18
|
|
19
|
-
Status
|
19
|
+
Status boolean,
|
20
20
|
|
21
21
|
PRIMARY KEY(ID),
|
22
22
|
|
1
test
CHANGED
File without changes
|
test
CHANGED
@@ -8,7 +8,7 @@
|
|
8
8
|
|
9
9
|
(
|
10
10
|
|
11
|
-
ID int,
|
11
|
+
ID int NOT NULL,
|
12
12
|
|
13
13
|
Name varchar(256),
|
14
14
|
|
@@ -16,7 +16,11 @@
|
|
16
16
|
|
17
17
|
Category varchar(32),
|
18
18
|
|
19
|
-
Status smallint
|
19
|
+
Status smallint,
|
20
|
+
|
21
|
+
PRIMARY KEY(ID),
|
22
|
+
|
23
|
+
INDEX(Name, Brand, Category)
|
20
24
|
|
21
25
|
)
|
22
26
|
|
@@ -40,9 +44,15 @@
|
|
40
44
|
|
41
45
|
(
|
42
46
|
|
47
|
+
ID int NOT NULL auto_increment,
|
48
|
+
|
43
49
|
Keyword varchar(24),
|
44
50
|
|
45
|
-
Type varchar(8)
|
51
|
+
Type varchar(8),
|
52
|
+
|
53
|
+
PRIMARY KEY(ID),
|
54
|
+
|
55
|
+
INDEX(Keyword)
|
46
56
|
|
47
57
|
)
|
48
58
|
|