Add monthly, daily, and hourly views in use by CAM

[rod-glover]

These were incorrectly classified as "not in use" and omitted from the early migrations (where they should have been). They should now be added to the database. They are:

• monthly_agg
• daily_agg
• daily_view
• hourly_view

Their removal from CRMP2 so that the migration to revision 879f0efa125f could proceed is documented in a Redmine issue. That issue also contains definitions of all views removed, in case they were removed in error (which they were).

These views have the following dependency relations (dependency indented below dependent):

• monthly_agg (view; dropped)
  • daily_agg (view; dropped)
    • daily_view (view; dropped)
      • meta_vars (table; exists)
      • obs_raw (table; exists)
      • meta_history (table; exists)
      • obs_raw_native_flags (table; exists)
      • meta_native_flag USING (table; exists)
      • obs_raw_pcic_flags (table; exists)
      • meta_pcic_flag (table; exists)
• hourly_view
  • meta_vars (table; exists)
  • obs_raw (table; exists)
  • meta_history (table; exists)
  • obs_raw_native_flags (table; exists)
  • meta_native_flag USING (table; exists)
  • obs_raw_pcic_flags (table; exists)
  • meta_pcic_flag (table; exists)

This analysis indicates that the only objects that need to be restored are the 4 views listed above; all other dependents exist.

The original errors were provoked by a migration step attempting to alter the type of column meta_vars.net_var_name. That alteration has now been performed, so the views can be restored using the same definitions or with slight modifications. All information needed for that is in the Redmine issue.