From: arjen <arjen>
Date: Thu, 24 Mar 2011 10:24:44 +0000 (+0000)
Subject: Removed line numbers from the SQL scripts output.
X-Git-Url: http://www.andromeda.nl/gitweb/?p=gnucomo.git;a=commitdiff_plain;h=d56d368744fc57855b32a681c3d98c985404ff0d

Removed line numbers from the SQL scripts output.
---

diff --git a/test/t0001.errors b/test/t0001.errors
index cb44b0f..3e040f9 100644
--- a/test/t0001.errors
+++ b/test/t0001.errors
@@ -1,7 +1,7 @@
-psql:src/database/create.sql:419: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
diff --git a/test/t0001.sh b/test/t0001.sh
index c9d42af..257d505 100644
--- a/test/t0001.sh
+++ b/test/t0001.sh
@@ -4,7 +4,7 @@
 
 cd ..
 
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
 then
    psql gnucomo_test -c 'select statuscode from status'
    result=$?
diff --git a/test/t0002a.errors b/test/t0002a.errors
index cb44b0f..3e040f9 100644
--- a/test/t0002a.errors
+++ b/test/t0002a.errors
@@ -1,7 +1,7 @@
-psql:src/database/create.sql:419: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
diff --git a/test/t0002a.sh b/test/t0002a.sh
index 0f43019..4c9e1d5 100644
--- a/test/t0002a.sh
+++ b/test/t0002a.sh
@@ -11,7 +11,7 @@ export LD_LIBRARY_PATH
 
 cd ..
 
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
 then
    psql gnucomo_test -q -c "insert into object (objectname) values ('kithira.andromeda.nl')"
    psql gnucomo_test -c "select * from object"
diff --git a/test/t0003.errors b/test/t0003.errors
index 7aa91be..cb77480 100644
--- a/test/t0003.errors
+++ b/test/t0003.errors
@@ -1,9 +1,9 @@
-psql:src/database/create.sql:419: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
 gcm_input WARNING: Not a valid line: nearly empty line
 gcm_input WARNING: Not a valid line: Jun  5 04:02:16 vd 
diff --git a/test/t0003.sh b/test/t0003.sh
index d25bfa3..bdb2e60 100644
--- a/test/t0003.sh
+++ b/test/t0003.sh
@@ -11,7 +11,7 @@ export LD_LIBRARY_PATH
 
 cd ..
 
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
 then
    psql gnucomo_test -q -c "insert into object (objectname) values ('vd.wt.tno.nl')"
    psql gnucomo_test -c "select * from object"
diff --git a/test/t0004.errors b/test/t0004.errors
index c7abaf4..31272f4 100644
--- a/test/t0004.errors
+++ b/test/t0004.errors
@@ -1,8 +1,8 @@
-psql:src/database/create.sql:419: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
 Can not determine the hostname where the message came from.
diff --git a/test/t0004.sh b/test/t0004.sh
index 4f4e1ca..db09dd2 100644
--- a/test/t0004.sh
+++ b/test/t0004.sh
@@ -7,7 +7,7 @@
 
 cd ..
 
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
 then
    psql gnucomo_test -q -c "insert into object (objectname) values ('kithira.andromeda.nl')"
    psql gnucomo_test -c "select * from object"
diff --git a/test/t0005.errors b/test/t0005.errors
index cb44b0f..3e040f9 100644
--- a/test/t0005.errors
+++ b/test/t0005.errors
@@ -1,7 +1,7 @@
-psql:src/database/create.sql:419: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
diff --git a/test/t0005.sh b/test/t0005.sh
index da7aa3f..a0d34b6 100644
--- a/test/t0005.sh
+++ b/test/t0005.sh
@@ -7,7 +7,7 @@
 
 cd ..
 
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
 then
    psql gnucomo_test -q -c "insert into object (objectname) values ('kithira.andromeda.nl')"
    psql gnucomo_test -c "select * from object"
diff --git a/test/t0008.errors b/test/t0008.errors
index 032baab..fcf3d85 100644
--- a/test/t0008.errors
+++ b/test/t0008.errors
@@ -1,9 +1,9 @@
-psql:test/create_v1.sql:382: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:test/create_v1.sql:417: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:419: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
diff --git a/test/t0008.sh b/test/t0008.sh
index cfb74f9..c54362f 100644
--- a/test/t0008.sh
+++ b/test/t0008.sh
@@ -9,12 +9,12 @@
 
 cd ..
 
-if psql gnucomo_test -f test/create_v1.sql -q >/dev/null
+if psql gnucomo_test <test/create_v1.sql -q >/dev/null
 then
    src/gcm_daemon/gcm_daemon.php -c gnucomo_test
    pg_dump gnucomo_test |grep -v '^--' | sort >test/dump.upgraded.sql
    psql gnucomo_test -f src/database/destroy.sql -q
-   psql gnucomo_test -f src/database/create.sql -q >/dev/null
+   psql gnucomo_test <src/database/create.sql -q >/dev/null
    pg_dump gnucomo_test |grep -v '^--' | sort >test/dump.latest.sql
    psql gnucomo_test -f src/database/destroy.sql -q
 
diff --git a/test/t0009.errors b/test/t0009.errors
index 7aa91be..cb77480 100644
--- a/test/t0009.errors
+++ b/test/t0009.errors
@@ -1,9 +1,9 @@
-psql:src/database/create.sql:419: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
 gcm_input WARNING: Not a valid line: nearly empty line
 gcm_input WARNING: Not a valid line: Jun  5 04:02:16 vd 
diff --git a/test/t0009.sh b/test/t0009.sh
index 29ddde0..fb7787f 100644
--- a/test/t0009.sh
+++ b/test/t0009.sh
@@ -13,7 +13,7 @@ export LD_LIBRARY_PATH
 
 cd ..
 
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
 then
    #  Prepare the database
 
diff --git a/test/t0010.errors b/test/t0010.errors
index cb44b0f..3e040f9 100644
--- a/test/t0010.errors
+++ b/test/t0010.errors
@@ -1,7 +1,7 @@
-psql:src/database/create.sql:419: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
diff --git a/test/t0010.expect b/test/t0010.expect
index 37b6801..fafec7a 100644
--- a/test/t0010.expect
+++ b/test/t0010.expect
@@ -1,22 +1,16 @@
 Content-type: text/html
 X-Powered-By: PHP/4.3.4
 
-NOQUEUE abuses:
-
-SPAM abuses:
-
-203.67.201.40 is new.
-193.217.1.16 is new.
-4.65.63.46 is new.
-212.204.216.11 is new.
-212.204.216.11 will get 2 abuse points, Status was 
-HTTP abuses:
-
-Mailing Notification for object id 1
+Processing logs...
+Last processed logid = 0 
+Running service check from log id 0.
 Gathering statistics for object 1
 
  notificationid | objectid | type_of_issueid 
 ----------------+----------+-----------------
-              1 |        1 |               6
-(1 row)
+              1 |        1 |               8
+              2 |        1 |              10
+              3 |        1 |              11
+              4 |        1 |               6
+(4 rows)
 
diff --git a/test/t0010.sh b/test/t0010.sh
index e701cd4..2f357b9 100644
--- a/test/t0010.sh
+++ b/test/t0010.sh
@@ -11,7 +11,7 @@ export LD_LIBRARY_PATH
 
 cd ..
 
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
 then
    #  Prepare the database
 
diff --git a/test/t0011.errors b/test/t0011.errors
index cb44b0f..3e040f9 100644
--- a/test/t0011.errors
+++ b/test/t0011.errors
@@ -1,7 +1,7 @@
-psql:src/database/create.sql:419: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
-psql:src/database/create.sql:493: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
-psql:src/database/create.sql:529: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
-psql:src/database/create.sql:549: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
-psql:src/database/create.sql:578: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
-psql:src/database/create.sql:609: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
-psql:src/database/create.sql:657: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_abuse_pkey" for table "object_abuse"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "object_statistics_pkey" for table "object_statistics"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_pkey" for table "parameter"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_class_pkey" for table "parameter_class"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parameter_notification_pkey" for table "parameter_notification"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "property_pkey" for table "property"
+NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "service_pattern_pkey" for table "service_pattern"
diff --git a/test/t0011.sh b/test/t0011.sh
index 1257d72..ed6c0bf 100644
--- a/test/t0011.sh
+++ b/test/t0011.sh
@@ -10,7 +10,7 @@ export LD_LIBRARY_PATH
 
 cd ..
 
-if psql gnucomo_test -f src/database/create.sql -q >/dev/null
+if psql gnucomo_test -q <src/database/create.sql >/dev/null
 then
    psql gnucomo_test -q -c "insert into object (objectname) values ('vd.wt.tno.nl')"
    psql gnucomo_test -c "select * from object"