 
 
 --
+-- Name: eu_4890_listing_changes_mview; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+--
+
+CREATE TABLE eu_4890_listing_changes_mview (
+    taxon_concept_id integer,
+    id integer,
+    original_taxon_concept_id integer,
+    effective_at timestamp without time zone,
+    species_listing_id integer,
+    species_listing_name character varying(255),
+    change_type_id integer,
+    change_type_name character varying(255),
+    designation_id integer,
+    designation_name character varying(255),
+    parent_id integer,
+    nomenclature_note_en text,
+    nomenclature_note_fr text,
+    nomenclature_note_es text,
+    party_id integer,
+    party_iso_code character varying(255),
+    party_full_name_en character varying(255),
+    party_full_name_es character varying(255),
+    party_full_name_fr character varying(255),
+    ann_symbol character varying(255),
+    full_note_en text,
+    full_note_es text,
+    full_note_fr text,
+    short_note_en text,
+    short_note_es text,
+    short_note_fr text,
+    display_in_index boolean,
+    display_in_footnote boolean,
+    hash_ann_symbol character varying(255),
+    hash_ann_parent_symbol character varying(255),
+    hash_full_note_en text,
+    hash_full_note_es text,
+    hash_full_note_fr text,
+    inclusion_taxon_concept_id integer,
+    inherited_short_note_en text,
+    inherited_full_note_en text,
+    inherited_short_note_es text,
+    inherited_full_note_es text,
+    inherited_short_note_fr text,
+    inherited_full_note_fr text,
+    auto_note_en text,
+    auto_note_es text,
+    auto_note_fr text,
+    is_current boolean,
+    explicit_change boolean,
+    updated_at timestamp without time zone,
+    show_in_history boolean,
+    show_in_downloads boolean,
+    show_in_timeline boolean,
+    listed_geo_entities_ids integer[],
+    excluded_geo_entities_ids integer[],
+    excluded_taxon_concept_ids integer[],
+    dirty boolean,
+    expiry timestamp with time zone
+);
+
+
+--
 -- Name: eu_decision_confirmations; Type: TABLE; Schema: public; Owner: -; Tablespace: 
 --
 


INSERT INTO schema_migrations (version) VALUES ('20141215134420');

INSERT INTO schema_migrations (version) VALUES ('20141222103221');

INSERT INTO schema_migrations (version) VALUES ('20141222121945');

INSERT INTO schema_migrations (version) VALUES ('20141222133058');

INSERT INTO schema_migrations (version) VALUES ('20141223141124');

INSERT INTO schema_migrations (version) VALUES ('20141223141125');

INSERT INTO schema_migrations (version) VALUES ('20141223160054');

INSERT INTO schema_migrations (version) VALUES ('20141223164041');

INSERT INTO schema_migrations (version) VALUES ('20141223171143');

INSERT INTO schema_migrations (version) VALUES ('20141223171144');

INSERT INTO schema_migrations (version) VALUES ('20141228094935');

INSERT INTO schema_migrations (version) VALUES ('20141228101341');

INSERT INTO schema_migrations (version) VALUES ('20141228224334');

INSERT INTO schema_migrations (version) VALUES ('20141230193843');

INSERT INTO schema_migrations (version) VALUES ('20141230193844');

INSERT INTO schema_migrations (version) VALUES ('20150106100040');


      PERFORM drop_eu_lc_mviews();
      FOR eu_interval IN (SELECT * FROM eu_regulations_applicability_view) LOOP
        SELECT ARRAY_APPEND(mviews, 'SELECT * FROM ' ||
          listing_changes_mview_name(NULL, designation.name, eu_interval.events_ids)
        ) INTO mviews;
        PERFORM rebuild_designation_all_listing_changes_mview(
          taxonomy, designation, eu_interval.events_ids
