PRODAT PUBLIC

CREATE FUNCTION TSystem.views__all__drop() RETURNS void AS $$

  BEGIN

    RETURN;

  END $$ LANGUAGE plpgsql;

--

--

CREATE FUNCTION TSystem.views__all__create() RETURNS VOID AS $$

  BEGIN

     RETURN;

  END $$ LANGUAGE plpgsql;

--

--

CREATE FUNCTION TSystem.views__Adressen__recreate() RETURNS VOID AS $$

    BEGIN

	  DROP VIEW IF EXISTS adressen_view CASCADE;

	  CREATE OR REPLACE VIEW adressen_view AS

      SELECT

        dbrid,

        ad_krz AS adk_ad_krz,

        ad_krz,

        ad_fa1,

        ad_fa2,

        ad_adrzus,

        ad_anr,

        ad_titel,

        ad_name,

        ad_vorn,

        ad_str,

        ad_plz,

        ad_ort,

        ad_landiso::VARCHAR(5),

        ad_land,

        ad_pfc,

        ad_fax,

        ad_tel1,

        ad_tel2,

        ad_email1,

        ad_email2,

        ad_such,

        ad_ustidnr,

        ad_branche,

        ad_stat,

        ad_bem,

        adk.modified_date,

        ad_auslauf

      FROM adk ;

      RETURN;

    END $$ LANGUAGE plpgsql;

SELECT TSystem.views__Adressen__recreate();

CREATE SCHEMA IF NOT EXISTS tCache;

 CREATE FUNCTION TCache.CachedViews_Clear() RETURNS BOOLEAN AS $$

    DECLARE

        r RECORD;

        e BOOLEAN;

    BEGIN

      RETURN false;

    END $$ LANGUAGE plpgsql;

 /*Delete für alle Tabellen setzen!!!!!*/

 CREATE FUNCTION table_delete() RETURNS TRIGGER AS $$

    BEGIN

      RETURN old;

    END $$ LANGUAGE plpgsql;	

CREATE FUNCTION TSystem.views__ReportingAuftg__recreate() RETURNS VOID AS $$

BEGIN

    DROP VIEW IF EXISTS treporting.auftg_beleg_positionennachtrag;

    DROP VIEW IF EXISTS treporting.auftg_beleg_positionen;

END $$ LANGUAGE plpgsql;	  

--/*

CREATE FUNCTION treporting.recreatereportingauftgviews(	)    RETURNS void AS $$

BEGIN

	RETURN;

END $$ LANGUAGE plpgsql;

--*/

CREATE OR REPLACE FUNCTION  treporting.RecreateViews()    RETURNS void AS $$

BEGIN

	RETURN;

END $$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION  TWawi.RecreateViews()    RETURNS void AS $$

BEGIN

	RETURN;

END $$ LANGUAGE plpgsql;	

CREATE OR REPLACE FUNCTION DropBelegViews() RETURNS VOID AS $$

BEGIN

  DROP VIEW IF EXISTS eingrech;

  DROP VIEW IF EXISTS eingrech_pos;

  DROP VIEW IF EXISTS lieferschein;

  DROP VIEW IF EXISTS lieferschein_pos;

END $$ LANGUAGE plpgsql;	

 CREATE FUNCTION lang_versart(INTEGER, VARCHAR) RETURNS VARCHAR AS $$    -- #7137

   BEGIN

   RETURN null;

  END $$ LANGUAGE plpgsql;