diff options
author | Pierre Chifflier <chifflier@inl.fr> | 2009-01-06 23:31:15 +0100 |
---|---|---|
committer | Eric Leblond <eric@inl.fr> | 2009-01-07 00:10:41 +0100 |
commit | 916becab13907a64a1901d228390cedc79673e7f (patch) | |
tree | 5477895a1d5d34b0537364a9559729bf90ae9a91 /doc | |
parent | 6bcbe0e967b1339c308d4e14d027b562ff179f7d (diff) |
PostgreSQL schema: drop useless constraints
Constraints on TCP/UDP port number validity are useless and only slow
down insertions.
Signed-off-by: Pierre Chifflier <chifflier@inl.fr>
Diffstat (limited to 'doc')
-rw-r--r-- | doc/pgsql-ulogd2.sql | 5 |
1 files changed, 0 insertions, 5 deletions
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 -- |