From 916becab13907a64a1901d228390cedc79673e7f Mon Sep 17 00:00:00 2001 From: Pierre Chifflier Date: Tue, 6 Jan 2009 23:31:15 +0100 Subject: PostgreSQL schema: drop useless constraints Constraints on TCP/UDP port number validity are useless and only slow down insertions. Signed-off-by: Pierre Chifflier --- doc/pgsql-ulogd2.sql | 5 ----- 1 file changed, 5 deletions(-) (limited to 'doc') diff --git a/doc/pgsql-ulogd2.sql b/doc/pgsql-ulogd2.sql index 73e038d..da66c85 100644 --- a/doc/pgsql-ulogd2.sql +++ b/doc/pgsql-ulogd2.sql @@ -278,11 +278,6 @@ CREATE INDEX ulog2_ct_reply_l4_sport ON ulog2_ct(reply_l4_sport); CREATE INDEX ulog2_ct_reply_l4_dport ON ulog2_ct(reply_l4_dport); CREATE INDEX ulog2_ct_event ON ulog2_ct(ct_event); -ALTER TABLE ulog2_ct ADD CONSTRAINT orig_l4_sport CHECK(orig_l4_sport >= 0 AND orig_l4_sport <= 65536); -ALTER TABLE ulog2_ct ADD CONSTRAINT orig_l4_dport CHECK(orig_l4_dport >= 0 AND orig_l4_dport <= 65536); -ALTER TABLE ulog2_ct ADD CONSTRAINT reply_l4_sport CHECK(reply_l4_sport >= 0 AND reply_l4_sport <= 65536); -ALTER TABLE ulog2_ct ADD CONSTRAINT reply_l4_dport CHECK(reply_l4_dport >= 0 AND reply_l4_dport <= 65536); - -- -- Helper table -- -- cgit v1.2.3