summaryrefslogtreecommitdiffstats
path: root/sse.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sse.sql')
-rw-r--r--sse.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/sse.sql b/sse.sql
index 0b4b8e6..2e48816 100644
--- a/sse.sql
+++ b/sse.sql
@@ -8,7 +8,7 @@ CREATE TABLE word (
file_id INTEGER UNSIGNED NOT NULL,
cnt INTEGER UNSIGNED NOT NULL,
PRIMARY KEY (text, type, file_id)
-);
+) ENGINE=InnoDB;
CREATE TABLE file (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
@@ -16,7 +16,7 @@ CREATE TABLE file (
path VARBINARY(255) NOT NULL,
language_id TINYINT UNSIGNED NOT NULL,
PRIMARY KEY (id)
-);
+) ENGINE=InnoDB;
CREATE TABLE package (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
@@ -26,4 +26,4 @@ CREATE TABLE package (
md CHAR(32) NOT NULL,
PRIMARY KEY(id),
KEY (md)
-);
+) ENGINE=InnoDB;