summaryrefslogtreecommitdiff
path: root/project2/sql/unittests/pqschema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'project2/sql/unittests/pqschema.sql')
-rw-r--r--project2/sql/unittests/pqschema.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/project2/sql/unittests/pqschema.sql b/project2/sql/unittests/pqschema.sql
new file mode 100644
index 0000000..b51a279
--- /dev/null
+++ b/project2/sql/unittests/pqschema.sql
@@ -0,0 +1,8 @@
+CREATE TABLE test(
+ id int,
+ fl numeric(5,2),
+ string text,
+ dt timestamp without time zone,
+ tf boolean,
+ ts interval);
+INSERT INTO test VALUES(4, 123.45, 'some text', '2015-04-27 23:06:03', true, '1 day 14:13:12');