X-Git-Url: http://www.andromeda.nl/gitweb/?p=gnucomo.git;a=blobdiff_plain;f=test%2Ft0008.expect;h=dd77564e363d0cac931825cad8c98edc83b23ee6;hp=00a325f575c267473371bfe705cff16419c277d4;hb=be94362cd5511ad727c8ac6a04f83bd465a5cf7f;hpb=7e9c415afeee6059d934703c711ec25f82a2b7ae

diff --git a/test/t0008.expect b/test/t0008.expect
index 00a325f..dd77564 100644
--- a/test/t0008.expect
+++ b/test/t0008.expect
@@ -1,54 +1,77 @@
-X-Powered-By: PHP/4.1.2
 Content-type: text/html
+X-Powered-By: PHP/4.3.4
 
-<br>
-<b>Warning</b>:  PostgreSQL query failed:  ERROR:  parser: parse error at or near ""
- in <b>/src/gnucomo/src/phpclasses/db.postgres.php</b> on line <b>79</b><br>
-Query error in ALTER TABLE log_adv_kernel_network DROP COLUMN hw_address
-<br>
-<b>Warning</b>:  PostgreSQL query failed:  ERROR:  ALTER TABLE: column name "hw_address" already exists in table "log_adv_kernel_network"
- in <b>/src/gnucomo/src/phpclasses/db.postgres.php</b> on line <b>79</b><br>
-Query error in ALTER TABLE log_adv_kernel_network ADD COLUMN hw_address TEXT
-<br>
-<b>Warning</b>:  PostgreSQL query failed:  ERROR:  CREATE GROUP: group name "view" already exists
- in <b>/src/gnucomo/src/phpclasses/db.postgres.php</b> on line <b>79</b><br>
 Query error in CREATE GROUP view
-<br>
-<b>Warning</b>:  PostgreSQL query failed:  ERROR:  CREATE GROUP: group name "ops" already exists
- in <b>/src/gnucomo/src/phpclasses/db.postgres.php</b> on line <b>79</b><br>
 Query error in CREATE GROUP ops
-<br>
-<b>Warning</b>:  PostgreSQL query failed:  ERROR:  CREATE GROUP: group name "admin" already exists
- in <b>/src/gnucomo/src/phpclasses/db.postgres.php</b> on line <b>79</b><br>
 Query error in CREATE GROUP admin
 
-679,681c679,681
-< 	"detailed_table" text
-< 	"device_in" text,
-< 	"device_out" text,
----
-> 	"detailed_table" character varying(75)
-> 	"device_in" character varying(15),
-> 	"device_out" character varying(15),
-802c802
-< 	"hw_address" text,
----
-> 	"hw_address" macaddr,
-826a827
+621a622,624
+> 
+> 
+> 
+697c700
+< 1	manual entry	4	A manual entry of a notification	t	t	1	\N	\N
+---
+> 1	manual entry	4	A manual entry of a notification	t	\N	\N	\N	\N
+701,702c704,705
+< 2	parameter created	3	A new parameter was created	t	t	1	\N	\N
+< 3	property modified	3	The STATIC property of a parameter was modified	t	t	1	\N	\N
+---
+> 2	parameter created	3	A new parameter was created	t	\N	\N	\N	\N
+> 3	property modified	3	The STATIC property of a parameter was modified	t	\N	\N	\N	\N
+704c707
+< 4	parameter removed	3	A parameter was removed	t	t	1	\N	\N
+---
+> 4	parameter removed	3	A parameter was removed	t	\N	\N	\N	\N
+707c710
+< 5	service unknown	5	Service in log entry is unknown	t	t	1	\N	\N
+---
+> 5	service unknown	5	Service in log entry is unknown	t	\N	\N	\N	\N
+709,710c712,713
+< 6	service not used	5	Service in log entry is not used	t	t	1	\N	\N
+< 7	abuses exceeded	5	Abuse treshold exceeded from an IP address	t	t	1	\N	\N
+---
+> 6	service not used	5	Service in log entry is not used	t	\N	\N	\N	\N
+> 7	abuses exceeded	5	Abuse treshold exceeded from an IP address	t	\N	\N	\N	\N
+768c771
+< COPY log_adv_kernel_network (log_advid, logid, detailed_table, device_in, device_out, hw_address, source_ip, destination_ip, packet_length, tos_bit, prec_bit, ttl, header_id, source_port, destination_port, body_length, protocol, body_len, window, urgp, syn, "type", code, sequence_number, res, rst, df) FROM stdin;
+---
+> COPY log_adv_kernel_network (log_advid, logid, detailed_table, device_in, device_out, source_ip, destination_ip, packet_length, tos_bit, prec_bit, ttl, header_id, source_port, destination_port, body_length, protocol, body_len, window, urgp, syn, "type", code, sequence_number, res, rst, df, hw_address) FROM stdin;
+848a852
+> CREATE RULE log_update AS ON UPDATE TO log DO INSTEAD NOTHING;
+937,940c941,944
+<     detailed_table text
+<     device_in text,
+<     device_out text,
+<     df boolean
+---
+>     detailed_table character varying(75)
+>     device_in character varying(15),
+>     device_out character varying(15),
+>     df boolean,
+1045c1049
+<     hw_address text,
+---
+>     hw_address text
+1079a1084
 > log_servicecheck	0
-886c887
-< 	"prec_bit" text,
+1161c1166
+<     prec_bit text,
+---
+>     prec_bit character varying(5),
+1169c1174
+<     protocol text,
 ---
-> 	"prec_bit" character varying(5),
-894c895
-< 	"protocol" text,
+>     protocol character varying(5),
+1182c1187
+<     res text,
 ---
-> 	"protocol" character varying(5),
-907c908
-< 	"res" text,
+>     res character varying(5),
+1231c1236
+< SELECT pg_catalog.setval('type_of_issue_type_of_issue_seq', 6, true);
 ---
-> 	"res" character varying(5),
-997c998
-< 	"tos_bit" text,
+> SELECT pg_catalog.setval('type_of_issue_type_of_issue_seq', 7, true);
+1291c1296
+<     tos_bit text,
 ---
-> 	"tos_bit" character varying(5),
+>     tos_bit character varying(5),