/dports/net-mgmt/netmagis-database/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)) ;
|
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-database/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)) ;
|
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-common/netmagis-2.3.4/database/lib/sql22/ |
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/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)) ;
|
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-detecteq/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)) ;
|
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-metro/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)) ;
|
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-servers/netmagis-2.3.4/database/lib/sql22/ |
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 | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-servers/netmagis-2.3.4/database/lib/ |
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-servers/netmagis-2.3.4/database/lib/sql23/ |
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-detecteq/netmagis-2.3.4/database/lib/sql23/ |
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-metro/netmagis-2.3.4/database/lib/sql23/ |
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-topo/netmagis-2.3.4/database/lib/ |
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-utils/netmagis-2.3.4/database/lib/ |
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-topo/netmagis-2.3.4/database/lib/sql23/ |
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-utils/netmagis-2.3.4/database/lib/sql23/ |
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-www/netmagis-2.3.4/database/lib/ |
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-common/netmagis-2.3.4/database/lib/ |
H A D | schema-main.sql | 115 iddom INT -- domain id field 120 PRIMARY KEY (iddom) 254 iddom INT, -- domain id field 259 PRIMARY KEY (idgrp, iddom) 326 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 338 iddom INT, -- domain name of RR field 356 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), 360 UNIQUE (name, iddom, idview), 405 iddom INT, -- domain id field 409 FOREIGN KEY (iddom) REFERENCES dns.domain (iddom), [all …]
|
/dports/net-mgmt/netmagis-detecteq/netmagis-2.3.4/www/cgi/ |
H A D | admmrel | 99 proc insert-relay {dbfd iddom lrel} { 103 VALUES ($iddom, $prio, $idmx)" 178 set iddom -1 179 set msg [check-domain-relay $dbfd $tabuid(idcor) iddom $domain $idview] 202 WHERE rd.iddom = $iddom 265 set iddom -1 266 set msg [check-domain-relay $dbfd $tabuid(idcor) iddom $domain $idview] 321 AND relay_dom.iddom = $iddom 331 set msg [insert-relay $dbfd $iddom $lrel]
|
/dports/net-mgmt/netmagis-metro/netmagis-2.3.4/www/cgi/ |
H A D | admmrel | 99 proc insert-relay {dbfd iddom lrel} { 103 VALUES ($iddom, $prio, $idmx)" 178 set iddom -1 179 set msg [check-domain-relay $dbfd $tabuid(idcor) iddom $domain $idview] 202 WHERE rd.iddom = $iddom 265 set iddom -1 266 set msg [check-domain-relay $dbfd $tabuid(idcor) iddom $domain $idview] 321 AND relay_dom.iddom = $iddom 331 set msg [insert-relay $dbfd $iddom $lrel]
|