27 lines
1.8 KiB
SQL
27 lines
1.8 KiB
SQL
UPDATE LOGS_2023_07
|
|
SET ogc_service = LOWER(ogc_service), ogc_request = LOWER(ogc_request), ogc_crs = LOWER(ogc_crs), ogc_workspace = LOWER(ogc_workspace);
|
|
UPDATE LOGS_2023_08
|
|
SET ogc_service = LOWER(ogc_service), ogc_request = LOWER(ogc_request), ogc_crs = LOWER(ogc_crs), ogc_workspace = LOWER(ogc_workspace);
|
|
UPDATE LOGS_2023_09
|
|
SET ogc_service = LOWER(ogc_service), ogc_request = LOWER(ogc_request), ogc_crs = LOWER(ogc_crs), ogc_workspace = LOWER(ogc_workspace);
|
|
UPDATE LOGS_2023_10
|
|
SET ogc_service = LOWER(ogc_service), ogc_request = LOWER(ogc_request), ogc_crs = LOWER(ogc_crs), ogc_workspace = LOWER(ogc_workspace);
|
|
UPDATE LOGS_2023_11
|
|
SET ogc_service = LOWER(ogc_service), ogc_request = LOWER(ogc_request), ogc_crs = LOWER(ogc_crs), ogc_workspace = LOWER(ogc_workspace);
|
|
UPDATE LOGS_2023_12
|
|
SET ogc_service = LOWER(ogc_service), ogc_request = LOWER(ogc_request), ogc_crs = LOWER(ogc_crs), ogc_workspace = LOWER(ogc_workspace);
|
|
UPDATE LOGS_2023_12
|
|
SET ogc_service = LOWER(ogc_service), ogc_request = LOWER(ogc_request), ogc_crs = LOWER(ogc_crs), ogc_workspace = LOWER(ogc_workspace);
|
|
UPDATE LAYERS_2023_07
|
|
SET service = LOWER(service), request = LOWER(request), crs = LOWER(crs), workspace = LOWER(workspace);
|
|
UPDATE LAYERS_2023_08
|
|
SET service = LOWER(service), request = LOWER(request), crs = LOWER(crs), workspace = LOWER(workspace);
|
|
UPDATE LAYERS_2023_09
|
|
SET service = LOWER(service), request = LOWER(request), crs = LOWER(crs), workspace = LOWER(workspace);
|
|
UPDATE LAYERS_2023_10
|
|
SET service = LOWER(service), request = LOWER(request), crs = LOWER(crs), workspace = LOWER(workspace);
|
|
UPDATE LAYERS_2023_11
|
|
SET service = LOWER(service), request = LOWER(request), crs = LOWER(crs), workspace = LOWER(workspace);
|
|
UPDATE LAYERS_2023_12
|
|
SET service = LOWER(service), request = LOWER(request), crs = LOWER(crs), workspace = LOWER(workspace);
|