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;