diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2021-08-08 09:08:25 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2021-08-08 09:08:25 +0100 |
| commit | 3e3992bbab56da69fc0c39e10a11862dea7a5c43 (patch) | |
| tree | 8730aefce6c72f51a31380a99335daa793d335af /test/sql | |
| parent | Push lots of test logic into a fixture for easier test case creation (diff) | |
| download | mygrate-3e3992bbab56da69fc0c39e10a11862dea7a5c43.tar.bz2 mygrate-3e3992bbab56da69fc0c39e10a11862dea7a5c43.tar.xz mygrate-3e3992bbab56da69fc0c39e10a11862dea7a5c43.zip | |
Create indexes and keys after copying table data
Diffstat (limited to 'test/sql')
| -rw-r--r-- | test/sql/createTestTable.sql | 1 |
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; |