diff options
Diffstat (limited to 'libmysqlpp/unittests/mysqlschema.sql')
| -rw-r--r-- | libmysqlpp/unittests/mysqlschema.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/libmysqlpp/unittests/mysqlschema.sql b/libmysqlpp/unittests/mysqlschema.sql new file mode 100644 index 0000000..58724c8 --- /dev/null +++ b/libmysqlpp/unittests/mysqlschema.sql @@ -0,0 +1,14 @@ +CREATE TABLE test( + id int, + fl numeric(5,2), + string varchar(30), + boolean bool, + dt timestamp, + ts time); + +INSERT INTO test VALUES(4, 123.45, 'some text', true, '2015-04-27 23:06:03', '38:13:12'); + +CREATE TABLE bulktest( + intcol int, + stringcol varchar(3000)); + |