summaryrefslogtreecommitdiff
path: root/test
diff options
context:
space:
mode:
authorDan Goodliffe <dan@randomdan.homeip.net>2021-08-08 09:08:25 +0100
committerDan Goodliffe <dan@randomdan.homeip.net>2021-08-08 09:08:25 +0100
commit3e3992bbab56da69fc0c39e10a11862dea7a5c43 (patch)
tree8730aefce6c72f51a31380a99335daa793d335af /test
parentPush lots of test logic into a fixture for easier test case creation (diff)
downloadmygrate-3e3992bbab56da69fc0c39e10a11862dea7a5c43.tar.bz2
mygrate-3e3992bbab56da69fc0c39e10a11862dea7a5c43.tar.xz
mygrate-3e3992bbab56da69fc0c39e10a11862dea7a5c43.zip
Create indexes and keys after copying table data
Diffstat (limited to 'test')
-rw-r--r--test/sql/createTestTable.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/test/sql/createTestTable.sql b/test/sql/createTestTable.sql
index fdc1c06..45f4857 100644
--- a/test/sql/createTestTable.sql
+++ b/test/sql/createTestTable.sql
@@ -10,5 +10,6 @@ CREATE TABLE session(
last_action varchar(255) null default null,
constraint `PRIMARY` primary key(id),
+ key created_time(created, modified),
constraint session_id unique(session_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;