gw_fct_admin_manage_fields - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function to admin fields on tables used on sql file to prevent conflict when field exists

Input example

SELECT gw_fct_admin_manage_fields($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"data":{"action":"ADD","table":"arc", "column":"addvalue", 
"dataType":"varchar(16)", "isUtils":"False"}}$$)

SELECT gw_fct_admin_manage_fields($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"data":{"action":"DROP","table":"inp_tank", "column":"to_arc"}}$$);

Output example