[WIP] Separate schema definitions

[lucernae]

Maintain schemas for tables separately.

Meta tasks

• [x] Make sure it will work if generated from empty database
• [x] Refactor object names according to conventions
• [x] Extract test data from staging
• [x] Make integration tests for travis

Validated db objects

Tables

Initial tables

• [x] layer_styles
• [x] osm_admin
• [x] osm_buildings
• [x] osm_waterways
• [x] osm_roads
• [x] admin_boundaries

Post pbf alters

• [x] osm tables alter
• [x] generic functions

FbF Tables

• [x] building_type
• [x] hazard_class
• [x] district_trigger_status
• [x] hazard_event_buildings
• [x] hazard_map
• [x] hazard_area
• [x] hazard_areas
• [x] hazard_event
• [x] hazard
• [x] hazard_type
• [x] sub_district_trigger_status
• [x] village_trigger_status
• [x] trigger_status
• [x] progress_status
• [x] report_notes
• [x] reporting_point
• [x] road_type_class
• [x] spreadsheet_report
• [x] waterway_type_class

FbF MV

• [x] administrative_mapping
• [x] flood_event_buildings
• [x] flooded_building_summary
• [x] non_flooded_building_summary
• [x] flood_event_district_summary
• [x] flood_event_sub_district_summary
• [x] flood_event_village_summary
• [x] flood_event_roads
• [x] flooded_roads_summary
• [x] non_flooded_roads_summary
• [x] flood_event_roads_district_summary
• [x] flood_event_roads_sub_district_summary
• [x] flood_event_roads_village_summary

FbF View

• [x] district_extent
• [x] sub_district_extent
• [x] village_extent
• [x] hazard_event_areas
• [x] hazard_event_buildings_map
• [x] hazard_event_extent
• [x] hazard_wkt_view

FbF Functions

Sooo many, will document later

FbF Triggers

Sooo many, will document later

[lucernae]

Table now has been ordered accordint to it's dependencies. We now checks functions and triggers.

[lucernae]

Test data import works Forecast script functions works against staging target

We can now merge this when the test passed.