maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_insert_default_config_colombia()
Parameters
Name
Type
Mode
Definition
INSERT INTO gnx.gnx_config_customer_specific (idclient,idparameter,value) SELECT idclient,29,'192.168.30.19.4.45' FROM client WHERE idbranch = 2 AND idclient NOT IN (SELECT DISTINCT idclient FROM gnx.gnx_config_customer_specific WHERE idparameter = 29) ; INSERT INTO gnx.gnx_config_customer_specific (idclient,idparameter,value) SELECT idclient,64,30 FROM client WHERE idbranch = 2 AND idclient NOT IN (SELECT DISTINCT idclient FROM gnx.gnx_config_customer_specific WHERE idparameter = 64) ;