diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2021-06-27 18:59:21 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2021-06-27 18:59:21 +0100 |
| commit | d74a7b7aec40d83b940dbfe10850734075aa6c5c (patch) | |
| tree | b1e0050b6265b068956ae7d417e1d5d8baf7a985 /test/sql | |
| parent | Basic type mapper (diff) | |
| download | mygrate-d74a7b7aec40d83b940dbfe10850734075aa6c5c.tar.bz2 mygrate-d74a7b7aec40d83b940dbfe10850734075aa6c5c.tar.xz mygrate-d74a7b7aec40d83b940dbfe10850734075aa6c5c.zip | |
Add an existing table to the config
Diffstat (limited to 'test/sql')
| -rw-r--r-- | test/sql/createTestTable.sql | 14 | ||||
| -rw-r--r-- | test/sql/selectTestTable.sql | 2 |
2 files changed, 16 insertions, 0 deletions
diff --git a/test/sql/createTestTable.sql b/test/sql/createTestTable.sql new file mode 100644 index 0000000..fdc1c06 --- /dev/null +++ b/test/sql/createTestTable.sql @@ -0,0 +1,14 @@ +CREATE TABLE session( + id int(10) unsigned not null auto_increment, + session_id varchar(255) not null, + username varchar(10) not null collate utf8_bin, + user_lvl enum('standard', 'reseller', 'sysadmin', 'groupadm') not null default 'standard', + ip_addr varchar(255) not null, + port varchar(255) not null, + created datetime not null, + modified datetime not null, + last_action varchar(255) null default null, + + constraint `PRIMARY` primary key(id), + constraint session_id unique(session_id) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/test/sql/selectTestTable.sql b/test/sql/selectTestTable.sql new file mode 100644 index 0000000..2543786 --- /dev/null +++ b/test/sql/selectTestTable.sql @@ -0,0 +1,2 @@ +SELECT id, session_id, user_lvl, ip_addr, port, created, modified, last_action +FROM testout.session |