INSERT INTO t_electric_field (C_STATION_CODE, C_STATION_STATUS_ENUM, C_NAME, C_SIGN, C_NET_SUBSTATION_NAME, C_CAPACITY, C_GRIDCE, C_LONGITUDE, C_LATITUDE, C_ELECTRIC_FIELD_TYPE_ENUM, C_PROVINCE_ENUM, C_INTERVAL, C_BACKUPA, C_BACKUPB, C_BACKUPC, C_BACKUPD, C_BACKUPE, C_BACKUPF, C_CREATOR, C_CREATE_TIME, C_LAST_MODIFIER, C_LAST_MODIFY_TIME, C_ALTITUDE, C_COMPANY, C_LOCATION, C_AREA) select 'T00001', 'E1', '沈阳嘉越光伏场站', 'T00001', 'T00001', 30.00, 30, 118.55, 44.15, 'E1', 'E15', 60, NULL, NULL, NULL, NULL, NULL, NULL, 'admin', '2020-11-12 13:23:04', NULL, NULL, 123.00, '测试', '测试', 123.00 from dual where not exists (select C_STATION_CODE from t_electric_field) ;
ALTER table t_electric_field MODIFY C_LATITUDE DECIMAL(10,6);
ALTER table t_electric_field MODIFY C_LONGITUDE DECIMAL(10,6);
ALTER table t_wind_turbine_info MODIFY C_LATITUDE DECIMAL(10,6);
ALTER table t_wind_turbine_info MODIFY C_LONGITUDE DECIMAL(10,6);
