drop table if exists BUDGET_MASTER.KANTON cascade;

create table if not exists
    BUDGET_MASTER.KANTON (ID                   uuid
                            default gen_random_uuid()
                            constraint PK⠒K⠒ID
                              primary key,
                          CODE                 varchar(2)
                            not null
                            constraint UK⠒K⠒CODE
                              unique,
                          NAME                 text
                            not null
                            constraint UK⠒K⠒NAME
                              unique,
                          LADEVORGAENGE⠒ID     uuid
                            constraint FK⠒K⠒LV⠒ID
                              references BUDGET_LOG.LADEVORGAENGE (ID));


insert into BUDGET_MASTER.KANTON (CODE, NAME)
    values ('AG', 'Aargau'),
           ('AI', 'Appenzell Innerrhoden'),
           ('AR', 'Appenzell Ausserrhoden'),
           ('BE', 'Bern'),
           ('BL', 'Basel-Landschaft'),
           ('BS', 'Basel-Stadt'),
           ('FR', 'Freiburg'),
           ('GE', 'Genf'),
           ('GL', 'Glarus'),
           ('GR', 'Graubünden'),
           ('JU', 'Jura'),
           ('LU', 'Luzern'),
           ('NE', 'Neuenburg'),
           ('NW', 'Nidwalden'),
           ('OW', 'Obwalden'),
           ('SG', 'St. Gallen'),
           ('SH', 'Schaffhausen'),
           ('SO', 'Solothurn'),
           ('SZ', 'Schwyz'),
           ('TG', 'Thurgau'),
           ('TI', 'Tessin'),
           ('UR', 'Uri'),
           ('VD', 'Waadt'),
           ('VS', 'Wallis'),
           ('ZG', 'Zug'),
           ('ZH', 'Zürich');
         -- CODE, NAME


comment on column BUDGET_MASTER.KANTON.ID is
  'Künstlicher Schlüssel';

comment on column BUDGET_MASTER.KANTON.CODE is
  'Abkürzung des Kantonsnamen';

comment on column BUDGET_MASTER.KANTON.NAME is
  'in Deutsch';

comment on table BUDGET_MASTER.KANTON is
  'Enthält die Aufzöhlung aller Schweizer Kantone
$Id$';


commit; -- In contrast to Oracle, ddls do not commit implicitly.