compatibility with ext-pq/master

[m6w6/pq-gateway] / tests / setup.inc

diff --git a/tests/setup.inc b/tests/setup.inc
index 47998cf7353c1c7b40c877f66285cd6f4a9945f1..fa7af13428ec71522b02d220dd6d81eb3ff0eb8e 100644 (file)
--- a/tests/setup.inc
+++ b/tests/setup.inc
@@ -1,15 +1,22 @@
 <?php
 
+ini_set("date.timezone", "UTC");
+ini_set("error_reporting", E_ALL);
+
 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 +25,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);