forked from QGEP/datamodel
-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathgenerate_ro_columns.sql
163 lines (163 loc) · 17.9 KB
/
generate_ro_columns.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
ALTER TABLE qgep.vl_access_aid_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_backflow_prevention_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_benching_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_catchment_area_direct_discharge_current ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_catchment_area_direct_discharge_planned ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_catchment_area_drainage_system_current ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_catchment_area_drainage_system_planned ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_catchment_area_infiltration_current ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_catchment_area_infiltration_planned ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_catchment_area_retention_current ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_catchment_area_retention_planned ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_catchment_area_text_plantype ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_catchment_area_text_texthali ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_catchment_area_text_textvali ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_channel_bedding_encasement ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_channel_connection_type ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_channel_function_hierarchic ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_channel_function_hydraulic ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_channel_usage_current ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_channel_usage_planned ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_chute_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_chute_material ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_cover_cover_shape ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_cover_fastening ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_cover_material ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_cover_positional_accuracy ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_cover_sludge_bucket ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_cover_venting ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_damage_channel_channel_damage_code ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_damage_connection ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_damage_manhole_manhole_damage_code ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_damage_manhole_manhole_shaft_area ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_damage_single_damage_class ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_dam_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_data_media_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_discharge_point_relevance ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_drainage_system_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_dryweather_flume_material ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_electric_equipment_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_electromechanical_equipment_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_examination_recording_type ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_examination_weather ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_file_class ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_file_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_groundwater_protection_zone_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_hydraulic_characteristic_data_is_overflowing ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_hydraulic_characteristic_data_main_weir_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_hydraulic_characteristic_data_pump_characteristics ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_hydraulic_characteristic_data_pump_usage_current ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_hydraulic_characteristic_data_status ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_individual_surface_function ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_individual_surface_pavement ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_infiltration_installation_defects ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_infiltration_installation_emergency_spillway ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_infiltration_installation_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_infiltration_installation_labeling ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_infiltration_installation_seepage_utilization ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_infiltration_installation_vehicle_access ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_infiltration_installation_watertightness ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_infiltration_zone_infiltration_capacity ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_leapingweir_opening_shape ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_maintenance_event_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_maintenance_event_status ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_manhole_function ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_manhole_material ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_manhole_surface_inflow ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_measurement_result_measurement_type ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_measurement_series_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_measuring_device_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_measuring_point_damming_device ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_measuring_point_purpose ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_mechanical_pretreatment_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_mutation_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_overflow_actuation ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_overflow_adjustability ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_overflow_characteristic_kind_overflow_characteristic ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_overflow_characteristic_overflow_characteristic_digital ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_overflow_control ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_overflow_function ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_overflow_signal_transmission ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_pipe_profile_profile_type ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_planning_zone_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_prank_weir_weir_edge ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_prank_weir_weir_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_pump_contruction_type ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_pump_placement_of_actuation ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_pump_placement_of_pump ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_pump_usage_current ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_reach_elevation_determination ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_reach_horizontal_positioning ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_reach_inside_coating ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_reach_material ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_reach_point_elevation_accuracy ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_reach_point_outlet_shape ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_reach_reliner_material ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_reach_relining_construction ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_reach_relining_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_reach_text_plantype ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_reach_text_texthali ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_reach_text_textvali ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_retention_body_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_river_bank_control_grade_of_river ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_river_bank_river_control_type ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_river_bank_shores ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_river_bank_side ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_river_bank_utilisation_of_shore_surroundings ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_river_bank_vegetation ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_river_bed_control_grade_of_river ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_river_bed_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_river_bed_river_control_type ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_river_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_rock_ramp_stabilisation ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_sector_water_body_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_sludge_treatment_stabilisation ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_solids_retention_type ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_special_structure_bypass ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_special_structure_emergency_spillway ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_special_structure_function ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_special_structure_stormwater_tank_arrangement ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_structure_part_renovation_demand ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_symbol_plantype ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_symbol_symbolhali ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_symbol_symbolvali ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_tank_cleaning_type ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_tank_emptying_type ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_text_plantype ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_text_texthali ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_text_textvali ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_throttle_shut_off_unit_actuation ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_throttle_shut_off_unit_adjustability ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_throttle_shut_off_unit_control ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_throttle_shut_off_unit_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_throttle_shut_off_unit_signal_transmission ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_wastewater_structure_accessibility ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_wastewater_structure_financing ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_wastewater_structure_renovation_necessity ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_wastewater_structure_rv_construction_type ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_wastewater_structure_status ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_wastewater_structure_structure_condition ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_wastewater_structure_symbol_plantype ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_wastewater_structure_symbol_symbolhali ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_wastewater_structure_symbol_symbolvali ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_wastewater_structure_text_plantype ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_wastewater_structure_text_texthali ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_wastewater_structure_text_textvali ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_waste_water_treatment_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_body_protection_sector_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_catchment_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_course_segment_algae_growth ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_course_segment_altitudinal_zone ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_course_segment_dead_wood ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_course_segment_depth_variability ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_course_segment_discharge_regime ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_course_segment_ecom_classification ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_course_segment_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_course_segment_length_profile ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_course_segment_macrophyte_coverage ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_course_segment_section_morphology ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_course_segment_slope ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_course_segment_utilisation ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_course_segment_water_hardness ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_water_course_segment_width_variability ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);
ALTER TABLE qgep.vl_wwtp_structure_kind ADD COLUMN value_ro varchar(50), ADD COLUMN abbr_ro varchar(3);