summaryrefslogtreecommitdiff
path: root/libmysqlpp/unittests/mysqlschema.sql
diff options
context:
space:
mode:
authorDan Goodliffe <dan@randomdan.homeip.net>2015-09-24 03:03:25 +0100
committerDan Goodliffe <dan@randomdan.homeip.net>2015-09-24 03:06:07 +0100
commit3cf494c3896f903d9e0179c12897ffb6c7cbf4d5 (patch)
tree3e36d5011da0b11277de4f416285bcb9c7880968 /libmysqlpp/unittests/mysqlschema.sql
parentConnector compatibility fix (diff)
downloadlibdbpp-mysql-3cf494c3896f903d9e0179c12897ffb6c7cbf4d5.tar.bz2
libdbpp-mysql-3cf494c3896f903d9e0179c12897ffb6c7cbf4d5.tar.xz
libdbpp-mysql-3cf494c3896f903d9e0179c12897ffb6c7cbf4d5.zip
MySQL mocking and tests from Project2
Diffstat (limited to 'libmysqlpp/unittests/mysqlschema.sql')
-rw-r--r--libmysqlpp/unittests/mysqlschema.sql14
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));
+