<commit_before>create table fed_state_map(
    ID NUMBER PRIMARY KEY,
    ADM1_CODE VARCHAR2(8) NOT NULL,
    STATE_NAME VARCHAR2(30) NOT NULL,
    PREFERRED_SPELLING VARCHAR2(1) DEFAULT 'Y' NOT NULL
);
/

alter table fed_state_map
add constraint "FED_STATE_MAP_UK1" UNIQUE ("ADM1_CODE", "STATE_NAME", "PREFERRED_SPELLING");
/

alter table fed_state_map
add constraint "FED_STATE_MAP_CHK1" CHECK (PREFERRED_SPELLING IN ('Y', 'N'));
/

create sequence fed_state_map_seq;
/

create or replace trigger BI_FED_STATE_MAP
before insert on FED_STATE_MAP
for each row
begin
    :NEW.ID := fed_state_map_seq.nextval;
end BI_FED_STATE_MAP;
/

insert into fed_state_map (adm1_code, state_name, preferred_spelling) values ('DEU-1573', 'BadenWürttemberg', 'N');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1591', 'Bayern');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1599', 'Berlin');
insert into fed_state_map (adm1_code, state_name) values ('DEU-3487', 'Brandenburg');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1575', 'Bremen');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1578', 'Hamburg');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1574', 'Hessen');
insert into fed_state_map (adm1_code, state_name, preferred_spelling) values ('DEU-3488', 'MecklenburgVorpommern', 'N');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1576', 'Niedersachsen');
insert into fed_state_map (adm1_code, state_name, preferred_spelling) values ('DEU-1572', 'NordrheinWestfalen', 'N');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1580', 'RheinlandPfalz', 'N');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1581', 'Saarland');
insert into fed_state_map (adm1_code, state_name, preferred_spelling) values ('DEU-1600', 'SachsenAnhalt', 'N');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1601', 'Sachsen');
insert into fed_state_map (adm1_code, state_name, preferred_spelling) values ('DEU-1579', 'SchleswigHolstein', 'N');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1577', 'Thüringen');

insert into fed_state_map (adm1_code, state_name) values ('DEU-1573', 'Baden-Württemberg');<commit_msg>Add missing column to list on insert<commit_after>create table fed_state_map(
    ID NUMBER PRIMARY KEY,
    ADM1_CODE VARCHAR2(8) NOT NULL,
    STATE_NAME VARCHAR2(30) NOT NULL,
    PREFERRED_SPELLING VARCHAR2(1) DEFAULT 'Y' NOT NULL
);
/

alter table fed_state_map
add constraint "FED_STATE_MAP_UK1" UNIQUE ("ADM1_CODE", "STATE_NAME", "PREFERRED_SPELLING");
/

alter table fed_state_map
add constraint "FED_STATE_MAP_CHK1" CHECK (PREFERRED_SPELLING IN ('Y', 'N'));
/

create sequence fed_state_map_seq;
/

create or replace trigger BI_FED_STATE_MAP
before insert on FED_STATE_MAP
for each row
begin
    :NEW.ID := fed_state_map_seq.nextval;
end BI_FED_STATE_MAP;
/

insert into fed_state_map (adm1_code, state_name, preferred_spelling) values ('DEU-1573', 'BadenWürttemberg', 'N');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1591', 'Bayern');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1599', 'Berlin');
insert into fed_state_map (adm1_code, state_name) values ('DEU-3487', 'Brandenburg');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1575', 'Bremen');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1578', 'Hamburg');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1574', 'Hessen');
insert into fed_state_map (adm1_code, state_name, preferred_spelling) values ('DEU-3488', 'MecklenburgVorpommern', 'N');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1576', 'Niedersachsen');
insert into fed_state_map (adm1_code, state_name, preferred_spelling) values ('DEU-1572', 'NordrheinWestfalen', 'N');
insert into fed_state_map (adm1_code, state_name, preferred_spelling) values ('DEU-1580', 'RheinlandPfalz', 'N');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1581', 'Saarland');
insert into fed_state_map (adm1_code, state_name, preferred_spelling) values ('DEU-1600', 'SachsenAnhalt', 'N');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1601', 'Sachsen');
insert into fed_state_map (adm1_code, state_name, preferred_spelling) values ('DEU-1579', 'SchleswigHolstein', 'N');
insert into fed_state_map (adm1_code, state_name) values ('DEU-1577', 'Thüringen');

insert into fed_state_map (adm1_code, state_name) values ('DEU-1573', 'Baden-Württemberg');
{'fraction_non_alphanumeric': 0.12508272667107875, 'fraction_numerical': 0.042356055592322965, 'mean_word_length': 7.396296296296296, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1123825', 'n_tokens_mistral': 1822, 'n_tokens_neox': 1703, 'n_words': 424}