X-Git-Url: https://git.m6w6.name/?p=m6w6%2Fpq-gateway;a=blobdiff_plain;f=tests%2Fsetup.inc;fp=tests%2Fsetup.inc;h=6f1b70501be8c91f2ba96a9fb5a88ea41338723d;hp=47998cf7353c1c7b40c877f66285cd6f4a9945f1;hb=409fca54acfee2db6c62540a8f67b1adfa695a38;hpb=0b0830c9c6254d596808d461755309200582825a

diff --git a/tests/setup.inc b/tests/setup.inc
index 47998cf..6f1b705 100644
--- a/tests/setup.inc
+++ b/tests/setup.inc
@@ -3,13 +3,17 @@
 const PQ_TEST_DSN = "";
 
 const PQ_TEST_SETUP_SQL = <<<SQL
+	create extension if not exists hstore;
+	
 	drop table if exists test cascade;
 	create table test (
 		id serial primary key, 
 		created timestamp, 
 		counter int, 
 		number decimal, 
-		data text
+		data text,
+		list int[],
+		prop hstore
 	);
 	
 	drop table if exists reftest cascade;
@@ -18,9 +22,9 @@ const PQ_TEST_SETUP_SQL = <<<SQL
 		another_test_id integer not null references test on delete cascade
 	);
 	
-	insert into test values (default, 'yesterday', -1, -1.1, 'yesterday');
-	insert into test values (default, 'today', 0, 0, 'today');
-	insert into test values (default, 'tomorrow', 1, 1.1, 'tomorrow');
+	insert into test values (default, 'yesterday', -1, -1.1, 'yesterday', '{-1,0,1}');
+	insert into test values (default, 'today', 0, 0, 'today', '{0,1,2}');
+	insert into test values (default, 'tomorrow', 1, 1.1, 'tomorrow', '{1,2,3}');
 	
 	insert into reftest values (1,3);
 	insert into reftest values (2,2);