summaryrefslogtreecommitdiffstats
path: root/doc
diff options
context:
space:
mode:
authorPierre Chifflier <pierre@inl.fr>2008-10-20 14:01:51 +0200
committerPablo Neira Ayuso <pablo@netfilter.org>2008-10-20 14:01:51 +0200
commitbea171e5eb656cd0a46f460396af6c054541b110 (patch)
treecce6d4291d605a46e1e1158405b55a16b1eaa762 /doc
parent13dbe40845eb7aecd15157021b849450c969515a (diff)
pgsql: remove useless checkings
This patch removes useless checkings. Signed-off-by: Pierre Chifflier <chifflier@inl.fr> Signed-off-by: Pablo Neira Ayuso <pablo@netfilter.org>
Diffstat (limited to 'doc')
-rw-r--r--doc/pgsql-ulogd2.sql6
1 files changed, 0 insertions, 6 deletions
diff --git a/doc/pgsql-ulogd2.sql b/doc/pgsql-ulogd2.sql
index 78c06b5..9340801 100644
--- a/doc/pgsql-ulogd2.sql
+++ b/doc/pgsql-ulogd2.sql
@@ -109,9 +109,6 @@ CREATE TABLE tcp (
CREATE INDEX tcp_sport ON tcp(tcp_sport);
CREATE INDEX tcp_dport ON tcp(tcp_dport);
-ALTER TABLE tcp ADD CONSTRAINT tcp_sport_ok CHECK(tcp_sport >= 0 AND tcp_sport <= 65536);
-ALTER TABLE tcp ADD CONSTRAINT tcp_dport_ok CHECK(tcp_dport >= 0 AND tcp_dport <= 65536);
-
CREATE TABLE udp (
_udp_id bigint PRIMARY KEY UNIQUE NOT NULL,
udp_sport integer default NULL,
@@ -122,9 +119,6 @@ CREATE TABLE udp (
CREATE INDEX udp_sport ON udp(udp_sport);
CREATE INDEX udp_dport ON udp(udp_dport);
-ALTER TABLE udp ADD CONSTRAINT udp_sport_ok CHECK(udp_sport >= 0 AND udp_sport <= 65536);
-ALTER TABLE udp ADD CONSTRAINT udp_dport_ok CHECK(udp_dport >= 0 AND udp_dport <= 65536);
-
CREATE TABLE icmp (
_icmp_id bigint PRIMARY KEY UNIQUE NOT NULL,
icmp_type smallint default NULL,