-- SQL-Sript zum Anlegen der Tabelle "iq_strom_code_texte"

CREATE TABLE iq_strom_code_texte (ktyp VARCHAR(5));
ALTER TABLE iq_strom_code_texte ADD kennziffer VARCHAR(5);
ALTER TABLE iq_strom_code_texte ADD text_zu_kennziffer VARCHAR(255);

INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','171', 'Sonstige Schaltanlage, Sonstige Isolierung, Sammelschiene');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','173', 'Sonstige Schaltanlage, Sonstige Isolierung, Transformator');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','177', 'Sonstige Schaltanlage, Sonstige Isolierung, KB/FL innerhalb Station');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','179', 'Sonstige Schaltanlage, Sonstige Isolierung, Sonstiges');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','17A', 'Sonstige Schaltanlage, Sonstige Isolierung, Feld Leistungsschalter');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','17B', 'Sonstige Schaltanlage, Sonstige Isolierung, Feld Trenner, abgangss.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','17C', 'Sonstige Schaltanlage, Sonstige Isolierung, Feld Trenner, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','17D', 'Sonstige Schaltanlage, Sonstige Isolierung, Feld Sonstiges, abgangs.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','17E', 'Sonstige Schaltanlage, Sonstige Isolierung, Feld Sonstiges, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','201', 'Freiluftschaltanlage, Luft, Sammelschiene');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','203', 'Freiluftschaltanlage, Luft, Transformator');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','207', 'Freiluftschaltanlage, Luft, KB/FL innerhalb Station');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','209', 'Freiluftschaltanlage, Luft, Sonstiges');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','20A', 'Freiluftschaltanlage, Luft, Feld Leistungsschalter');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','20B', 'Freiluftschaltanlage, Luft, Feld Trenner, abgangss.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','20C', 'Freiluftschaltanlage, Luft, Feld Trenner, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','20D', 'Freiluftschaltanlage, Luft, Feld Sonstiges, abgangs.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','20E', 'Freiluftschaltanlage, Luft, Feld Sonstiges, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','501', 'Innenraumschaltanlage offen, Luft, Sammelschiene');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','503', 'Innenraumschaltanlage offen, Luft, Transformator');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','507', 'Innenraumschaltanlage offen, Luft, KB/FL innerhalb Station');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','509', 'Innenraumschaltanlage offen, Luft, Sonstiges');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','50A', 'Innenraumschaltanlage offen, Luft, Feld Leistungsschalter');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','50B', 'Innenraumschaltanlage offen, Luft, Feld Trenner, abgangss.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','50C', 'Innenraumschaltanlage offen, Luft, Feld Trenner, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','50D', 'Innenraumschaltanlage offen, Luft, Feld Sonstiges, abgangs.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','50E', 'Innenraumschaltanlage offen, Luft, Feld Sonstiges, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','601', 'Innenraumschaltanlage metallgekapselt, Luft, Sammelschiene');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','603', 'Innenraumschaltanlage metallgekapselt, Luft, Transformator');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','607', 'Innenraumschaltanlage metallgekapselt, Luft, KB/FL innerhalb Station');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','609', 'Innenraumschaltanlage metallgekapselt, Luft, Sonstiges');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','60A', 'Innenraumschaltanlage metallgekapselt, Luft, Feld Leistungsschalter');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','60B', 'Innenraumschaltanlage metallgekapselt, Luft, Feld Trenner, abgangss.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','60C', 'Innenraumschaltanlage metallgekapselt, Luft, Feld Trenner, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','60D', 'Innenraumschaltanlage metallgekapselt, Luft, Feld Sonstiges, abgangs.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','60E', 'Innenraumschaltanlage metallgekapselt, Luft, Feld Sonstiges, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','731', 'Gasisolierte Schaltanlage, Gas, Sammelschiene');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','733', 'Gasisolierte Schaltanlage, Gas, Transformator');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','737', 'Gasisolierte Schaltanlage, Gas, KB/FL innerhalb Station');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','739', 'Gasisolierte Schaltanlage, Gas, Sonstiges');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','73A', 'Gasisolierte Schaltanlage, Gas, Feld Leistungsschalter');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','73B', 'Gasisolierte Schaltanlage, Gas, Feld Trenner, abgangss.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','73C', 'Gasisolierte Schaltanlage, Gas, Feld Trenner, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','73D', 'Gasisolierte Schaltanlage, Gas, Feld Sonstiges, abgangs.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','73E', 'Gasisolierte Schaltanlage, Gas, Feld Sonstiges, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E01', 'Einbaustation, Luft, Sammelschiene');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E03', 'Einbaustation, Luft, Transformator');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E07', 'Einbaustation, Luft, KB/FL innerhalb Station');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E09', 'Einbaustation, Luft, Sonstiges');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E0A', 'Einbaustation, Luft, Feld Leistungsschalter');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E0B', 'Einbaustation, Luft, Feld Trenner, abgangss.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E0C', 'Einbaustation, Luft, Feld Trenner, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E0D', 'Einbaustation, Luft, Feld Sonstiges, abgangs.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E0E', 'Einbaustation, Luft, Feld Sonstiges, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E31', 'Einbaustation, Gas, Sammelschiene');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E33', 'Einbaustation, Gas, Transformator');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E37', 'Einbaustation, Gas, KB/FL innerhalb Station');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E39', 'Einbaustation, Gas, Sonstiges');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E3A', 'Einbaustation, Gas, Feld Leistungsschalter');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E3B', 'Einbaustation, Gas, Feld Trenner, abgangss.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E3C', 'Einbaustation, Gas, Feld Trenner, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E3D', 'Einbaustation, Gas, Feld Sonstiges, abgangs.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','E3E', 'Einbaustation, Gas, Feld Sonstiges, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G01', 'Gebäudestation, Luft, Sammelschiene');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G03', 'Gebäudestation, Luft, Transformator');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G07', 'Gebäudestation, Luft, KB/FL innerhalb Station');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G09', 'Gebäudestation, Luft, Sonstiges');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G0A', 'Gebäudestation, Luft, Feld Leistungsschalter');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G0B', 'Gebäudestation, Luft, Feld Trenner, abgangss.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G0C', 'Gebäudestation, Luft, Feld Trenner, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G0D', 'Gebäudestation, Luft, Feld Sonstiges, abgangs.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G0E', 'Gebäudestation, Luft, Feld Sonstiges, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G31', 'Gebäudestation, Gas, Sammelschiene');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G33', 'Gebäudestation, Gas, Transformator');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G37', 'Gebäudestation, Gas, KB/FL innerhalb Station');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G39', 'Gebäudestation, Gas, Sonstiges');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G3A', 'Gebäudestation, Gas, Feld Leistungsschalter');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G3B', 'Gebäudestation, Gas, Feld Trenner, abgangss.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G3C', 'Gebäudestation, Gas, Feld Trenner, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G3D', 'Gebäudestation, Gas, Feld Sonstiges, abgangs.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','G3E', 'Gebäudestation, Gas, Feld Sonstiges, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K01', 'Kompaktstation, Luft, Sammelschiene');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K03', 'Kompaktstation, Luft, Transformator');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K07', 'Kompaktstation, Luft, KB/FL innerhalb Station');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K09', 'Kompaktstation, Luft, Sonstiges');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K0A', 'Kompaktstation, Luft, Feld Leistungsschalter');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K0B', 'Kompaktstation, Luft, Feld Trenner, abgangss.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K0C', 'Kompaktstation, Luft, Feld Trenner, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K0D', 'Kompaktstation, Luft, Feld Sonstiges, abgangs.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K0E', 'Kompaktstation, Luft, Feld Sonstiges, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K31', 'Kompaktstation, Gas, Sammelschiene');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K33', 'Kompaktstation, Gas, Transformator');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K37', 'Kompaktstation, Gas, KB/FL innerhalb Station');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K39', 'Kompaktstation, Gas, Sonstiges');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K3A', 'Kompaktstation, Gas, Feld Leistungsschalter');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K3B', 'Kompaktstation, Gas, Feld Trenner, abgangss.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K3C', 'Kompaktstation, Gas, Feld Trenner, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K3D', 'Kompaktstation, Gas, Feld Sonstiges, abgangs.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','K3E', 'Kompaktstation, Gas, Feld Sonstiges, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','M01', 'Maststation, Luft, Sammelschiene');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','M03', 'Maststation, Luft, Transformator');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','M07', 'Maststation, Luft, KB/FL innerhalb Station');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','M09', 'Maststation, Luft, Sonstiges');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','M0A', 'Maststation, Luft, Feld Leistungsschalter');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','M0B', 'Maststation, Luft, Feld Trenner, abgangss.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','M0C', 'Maststation, Luft, Feld Trenner, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','M0D', 'Maststation, Luft, Feld Sonstiges, abgangs.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','M0E', 'Maststation, Luft, Feld Sonstiges, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','T71', 'Sonstige Ortsnetzstation, Sonstige Isolierung, Sammelschiene');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','T73', 'Sonstige Ortsnetzstation, Sonstige Isolierung, Transformator');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','T77', 'Sonstige Ortsnetzstation, Sonstige Isolierung, KB/FL innerhalb Station');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','T79', 'Sonstige Ortsnetzstation, Sonstige Isolierung, Sonstiges');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','T7A', 'Sonstige Ortsnetzstation, Sonstige Isolierung, Feld Leistungsschalter');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','T7B', 'Sonstige Ortsnetzstation, Sonstige Isolierung, Feld Trenner, abgangss.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','T7C', 'Sonstige Ortsnetzstation, Sonstige Isolierung, Feld Trenner, sammelschienens.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','T7D', 'Sonstige Ortsnetzstation, Sonstige Isolierung, Feld Sonstiges, abgangs.');
INSERT INTO iq_strom_code_texte ( ktyp, kennziffer, text_zu_kennziffer ) VALUES ( 'E','T7E', 'Sonstige Ortsnetzstation, Sonstige Isolierung, Feld Sonstiges, sammelschienens.');

COMMIT;
