/dports/net-mgmt/netmagis-detecteq/netmagis-2.3.4/database/lib/sql22/ |
H A D | schema-main.sql | 71 iddom INT -- domain id field 76 PRIMARY KEY (iddom) 210 iddom INT, -- domain id field 215 PRIMARY KEY (idgrp, iddom) 282 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 294 iddom INT, -- domain name of RR field 312 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 316 UNIQUE (name, iddom, idview), 361 iddom INT, -- domain id field 365 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-metro/netmagis-2.3.4/database/lib/sql22/ |
H A D | schema-main.sql | 71 iddom INT -- domain id field 76 PRIMARY KEY (iddom) 210 iddom INT, -- domain id field 215 PRIMARY KEY (idgrp, iddom) 282 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 294 iddom INT, -- domain name of RR field 312 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 316 UNIQUE (name, iddom, idview), 361 iddom INT, -- domain id field 365 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-topo/netmagis-2.3.4/database/lib/sql22/ |
H A D | schema-main.sql | 71 iddom INT -- domain id field 76 PRIMARY KEY (iddom) 210 iddom INT, -- domain id field 215 PRIMARY KEY (idgrp, iddom) 282 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 294 iddom INT, -- domain name of RR field 312 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 316 UNIQUE (name, iddom, idview), 361 iddom INT, -- domain id field 365 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-utils/netmagis-2.3.4/database/lib/sql22/ |
H A D | schema-main.sql | 71 iddom INT -- domain id field 76 PRIMARY KEY (iddom) 210 iddom INT, -- domain id field 215 PRIMARY KEY (idgrp, iddom) 282 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 294 iddom INT, -- domain name of RR field 312 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 316 UNIQUE (name, iddom, idview), 361 iddom INT, -- domain id field 365 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-servers/netmagis-2.3.4/database/lib/sql22/ |
H A D | schema-main.sql | 71 iddom INT -- domain id field 76 PRIMARY KEY (iddom) 210 iddom INT, -- domain id field 215 PRIMARY KEY (idgrp, iddom) 282 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 294 iddom INT, -- domain name of RR field 312 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 316 UNIQUE (name, iddom, idview), 361 iddom INT, -- domain id field 365 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-www/netmagis-2.3.4/database/lib/sql22/ |
H A D | schema-main.sql | 71 iddom INT -- domain id field 76 PRIMARY KEY (iddom) 210 iddom INT, -- domain id field 215 PRIMARY KEY (idgrp, iddom) 282 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 294 iddom INT, -- domain name of RR field 312 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 316 UNIQUE (name, iddom, idview), 361 iddom INT, -- domain id field 365 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-database/netmagis-2.3.4/database/lib/sql22/ |
H A D | schema-main.sql | 71 iddom INT -- domain id field 76 PRIMARY KEY (iddom) 210 iddom INT, -- domain id field 215 PRIMARY KEY (idgrp, iddom) 282 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 294 iddom INT, -- domain name of RR field 312 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 316 UNIQUE (name, iddom, idview), 361 iddom INT, -- domain id field 365 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-common/netmagis-2.3.4/database/lib/sql22/ |
H A D | schema-main.sql | 71 iddom INT -- domain id field 76 PRIMARY KEY (iddom) 210 iddom INT, -- domain id field 215 PRIMARY KEY (idgrp, iddom) 282 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 294 iddom INT, -- domain name of RR field 312 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 316 UNIQUE (name, iddom, idview), 361 iddom INT, -- domain id field 365 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-metro/netmagis-2.3.4/database/lib/sql23/ |
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-topo/netmagis-2.3.4/database/lib/sql23/ |
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-detecteq/netmagis-2.3.4/database/lib/sql23/ |
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-utils/netmagis-2.3.4/database/lib/ |
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-servers/netmagis-2.3.4/database/lib/ |
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-topo/netmagis-2.3.4/database/lib/ |
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-www/netmagis-2.3.4/database/lib/ |
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-servers/netmagis-2.3.4/database/lib/sql23/ |
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-utils/netmagis-2.3.4/database/lib/sql23/ |
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-www/netmagis-2.3.4/database/lib/sql23/ |
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|
/dports/net-mgmt/netmagis-common/netmagis-2.3.4/database/lib/ |
H A D | functions.sql | 138 AND rr.iddom = domain.iddom 270 AND rr.iddom = domain.iddom 285 WHERE domain.iddom = $1 297 WHERE selection = ( SELECT name FROM dns.domain WHERE iddom = $1 ) 420 PERFORM sum (dns.gen_norm_iddom (NEW.iddom, NEW.idview)) 422 PERFORM sum (dns.gen_norm_iddom (OLD.iddom, OLD.idview)) 456 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 461 PERFORM sum (dns.gen_relay (NEW.iddom, NEW.mx)) ; 462 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ; 467 PERFORM sum (dns.gen_relay (OLD.iddom, OLD.mx)) ;
|