You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
99 lines
2.9 KiB
99 lines
2.9 KiB
begin;
|
|
|
|
-- Table und Funktionen um Länder zu verwalten --
|
|
-- [
|
|
drop sequence "land_id_land_seq";
|
|
|
|
drop index "land_ukey1";
|
|
drop index "land_ukey2";
|
|
drop index "land_ukey3";
|
|
|
|
drop function "chk_land" (text,varchar(3),varchar(4));
|
|
drop function "ins_land" (text,varchar(3),varchar(4));
|
|
drop function "get_id_land_by_land" (text);
|
|
drop function "get_id_land_by_lnd_kz" (varchar(3));
|
|
drop function "get_id_land_by_vorwahl_l" (varchar(4));
|
|
|
|
drop table "land";
|
|
-- Ende Länder --
|
|
|
|
-- Table und Funktionen um Orte zu verwalten --
|
|
-- [
|
|
drop sequence "ort_id_ort_seq";
|
|
|
|
drop index "ort_ukey1";
|
|
|
|
drop function "chk_ort" (text,varchar(10),int4);
|
|
drop function "ins_ort" (text,varchar(10),int4);
|
|
drop function "ins_ort" (text,varchar(10),text,varchar(3),varchar(4));
|
|
drop function "get_id_ort_by_ukey1" (varchar(10),int4);
|
|
|
|
drop table "ort";
|
|
-- ]
|
|
-- ende Orte --
|
|
|
|
-- Table und Funktionen um Adressen zu verwalten --
|
|
-- [
|
|
drop sequence "adresse_id_adresse_seq";
|
|
|
|
drop index "adresse_ukey1";
|
|
|
|
drop function "chk_adresse" (text,varchar(5),varchar(10),int4,int4);
|
|
drop function "ins_adresse" (text,varchar(5),varchar(10),int4,int4);
|
|
drop function "ins_adresse" (text,varchar(5),varchar(10),text,
|
|
varchar(5),text,varchar(3),varchar(4));
|
|
drop function "get_adresse_by_ukey1" (text,varchar(5),varchar(10));
|
|
|
|
drop table "adresse";
|
|
-- ]
|
|
-- ende Adressen --
|
|
|
|
-- Tabellen und alles für Personendaten
|
|
-- [
|
|
drop sequence "person_id_person_seq";
|
|
|
|
drop index "person_ukey1";
|
|
|
|
drop function "chk_person" (varchar(10),text,text,text,text,
|
|
varchar(10),varchar(10),varchar(10),varchar(50),
|
|
varchar(50),varchar(100));
|
|
drop function "ins_person" (varchar(10),text,text,text,text,
|
|
varchar(10),varchar(10),varchar(10),varchar(50),
|
|
varchar(50),varchar(100));
|
|
drop function "ins_person" (varchar(10),text,text,text,text,
|
|
varchar(10),varchar(10),varchar(10),varchar(50),
|
|
varchar(50),varchar(100),int4,int4,text,
|
|
text,money);
|
|
drop function "get_id_person_by_ukey1" (text, text, text);
|
|
|
|
drop table "person";
|
|
drop table "wohnt";
|
|
-- ]
|
|
-- ende Personendaten --
|
|
|
|
-- Arbeitsplatz --
|
|
-- [
|
|
drop sequence "firma_id_firma_seq";
|
|
drop sequence "abteilung_id_abteilung_seq";
|
|
|
|
drop index "firma_ukey1";
|
|
drop index "abteilung_ukey1";
|
|
|
|
drop function "chk_arbeit" (text, text, money, int4, int4);
|
|
drop function "ins_arbeit" (text, text, money, int4, int4);
|
|
drop function "chk_firma" (text, text, varchar(10));
|
|
drop function "ins_firma" (text, text, varchar(10));
|
|
drop function "chk_abteilung" (text, text, int4, int4);
|
|
drop function "ins_abteilung" (text, text, int4, int4);
|
|
drop function "ins_abteilung" (text, text, text, text, varchar(10), int4);
|
|
|
|
drop table "firma";
|
|
drop table "abteilung";
|
|
drop table "arbeit";
|
|
-- ]
|
|
-- ende Arbeitsplatz --
|
|
|
|
drop view "adresse_v";
|
|
drop view "person_v";
|
|
|
|
commit;
|