libmysqlpp/unittests/mysqlschema.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

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));

CREATE TABLE inserts(
		id int auto_increment,
		num int,
		primary key(id));