Amaly-SQL-Current

Aus INFOKOM-Wiki
Version vom 15. Januar 2007, 16:18 Uhr von Joerg (Diskussion | Beiträge)

(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Wechseln zu: Navigation, Suche

SQL - Update (Testumgebung) von Version 1.20.1 auf aktuellen Teststand

Bitte auf bearbeiten gehen, um die SQL-Statments korrekt zu sehen

insert into 'agebadmin'.kon_meldtxt values(1205,'M','Erzeugte Sollstellungsdatei muss manuell gelöscht werden!' );

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(999, 6, 6, 'zeit', 'Zeitpunkt', 'Zeitpunkt', 'Zeitpunkt der Datenänderung', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO 'agebadmin'.def_fkt(fktnr, fkttyp, prog_txt, fkt_name)

 VALUES(999, 'T', 'Logging-Tabelle', 'Protokoll aller datenverändernden Aktionen');


CREATE TABLE 'agebadmin'.kon_plausi2 (

   tabid     	SMALLINT NOT NULL,
   feldid    	SMALLINT NOT NULL,
   taet_id   	INTEGER,
   aart      	CHAR(4),
   lfdnr     	SMALLINT,
   verg_op   	CHAR(8),
   verg_wert 	CHAR(20),
   verg_tabid	SMALLINT,
   verg_feld 	SMALLINT,
   verg_taet 	INTEGER,
   rech_op   	CHAR(1),
   rech_wert 	INTEGER,
   verkett   	CHAR(8),
   klammer   	CHAR(5),
   meld_id   	INTEGER,
   checklf   	CHAR(1),
   checkur   	CHAR(1) 
   )

CREATE INDEX 'agebadmin'.k_plau2

   ON 'agebadmin'.kon_plausi2(tabid, feldid)

update 'agebadmin'.def_fkt set (prog_txt, fkt_name) = ("Plausi 1","Positivdefinition von Plausibilitäten") where fkttyp = "T" and fktnr = 137; update 'agebadmin'.def_fkt set (prog_txt, fkt_name) = ("Plausi 2","Negativdefinition von Plausibilitäten") where fkttyp = "T" and fktnr = 142;

delete from 'agebadmin'.metatabellen where tabid = 142; delete from 'agebadmin'.metafelder where tabid = 142;

INSERT INTO 'agebadmin'.metatabellen(tabid, m_tabtyp, m_tabname, m_ktabname, m_ltabname, m_hilfe, m_klasse, m_detailtab, m_detaillfd, m_detailflag, logflag, roflag)

 VALUES(142, 'K', 'agebadmin.kon_plausi2       ', 'Plausi 2    ', 'Negativ Plausi           ', 'Wenn Bedingung erfüllt ist, wird ein Fehler gemeldet        ', NULL, NULL, 21, 'n', 'n', 'n');

update 'agebadmin'.metatabellen set (m_ktabname, m_ltabname, m_hilfe, m_detaillfd) = ('Plausi 1', 'Positiv Plausi', 'Bedingungen, die erfüllt sein müssen', 20) where tabid = 137; update 'agebadmin'.metatabellen set (m_detaillfd) = (19) where tabid = 138;

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 1, 1, 'tabid               ', 'tabid     ', 'tabid               ', 'tabid                                                       ', NULL, NULL, 'j', '3', 'j', 'n', 'j', 'j', 'j', 'n', 'n', NULL, 102, 1, '5           ', NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 2, 2, 'feldid              ', 'feldid    ', 'feldid              ', 'feldid                                                      ', NULL, NULL, 'j', '3', 'j', 'n', 'j', 'j', 'j', 'n', 'n', NULL, 101, 2, '6           ', '1              ', 1, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 3, 4, 'taet_id             ', 'taet_id   ', 'taet_id             ', 'taet_id                                                     ', NULL, NULL, 'n', '3', 'j', 'n', 'j', 'j', 'j', 'n', 'n', NULL, 136, 1, '2           ', NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 4, 5, 'aart                ', 'aart      ', 'aart                ', 'aart                                                        ', NULL, NULL, 'n', '3', 'j', 'n', 'j', 'j', 'j', 'n', 'n', NULL, 124, 1, '2           ', NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 5, 3, 'lfdnr               ', 'lfdnr     ', 'lfdnr               ', 'lfdnr                                                       ', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'j', 'j', 'n', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 6, 6, 'verg_op             ', 'verg_op   ', 'verg_op             ', 'verg_op                                                     ', NULL, NULL, 'n', '3', 'n', 'n', 'j', 'j', 'j', 'n', 'n', NULL, 118, 1, '3           ', '#1,5           ', 2, NULL, NULL, NULL, 'n');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 7, 7, 'verg_wert           ', 'verg_wert ', 'verg_wert           ', 'verg_wert                                                   ', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'j', 'j', 'n', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 8, 8, 'verg_tabid          ', 'Verg.Tab  ', 'Vergleichstabelle   ', 'Tabelle des Vergleichs                                      ', NULL, NULL, 'n', '3', 'j', 'n', 'j', 'j', 'j', 'n', 'n', NULL, 102, 1, '5           ', NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 9, 9, 'verg_feld           ', 'verg_feld ', 'verg_feld           ', 'verg_feld                                                   ', NULL, NULL, 'n', '3', 'j', 'n', 'j', 'j', 'j', 'n', 'n', NULL, 101, 2, '6           ', '8              ', 1, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 10, 10, 'verg_taet           ', 'verg_taet ', 'verg_taet           ', 'verg_taet                                                   ', NULL, NULL, 'n', '3', 'j', 'n', 'j', 'j', 'j', 'n', 'n', NULL, 136, 1, '2           ', NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 11, 11, 'verkett             ', 'Verkettung', 'Verkettung          ', 'Verkettungsoperator zur nächsten Bedingung (AND / OR)       ', NULL, NULL, 'n', '3', 'n', 'n', 'j', 'j', 'j', 'n', 'n', NULL, 118, 1, '3           ', '#2             ', 2, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 12, 12, 'klammer             ', 'Klammer   ', 'Klammer             ', 'Öffnende Klammer vor der Bed. oder schliessende nach der Bed', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'j', 'j', 'n', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 13, 13, 'meld_id             ', 'Meld-ID   ', 'Meldungs-ID         ', 'Identnummer der Meldung                                     ', NULL, NULL, 'j', '3', 'j', 'n', 'j', 'j', 'j', 'n', 'n', NULL, 139, 1, '3           ', NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 14, 14, 'rech_op             ', 'Rechen-Op ', 'Rechen-Operator     ', 'Rechen-Operator (+ oder -)                                  ', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'j', 'j', 'n', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 15, 15, 'rech_wert           ', 'Rechenwert', 'Rechen-Wert         ', 'Wert der zum Vergleichsfeld zu addieren bzw. subtraieren ist', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'j', 'j', 'n', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 16, 16, 'checklf             ', 'NachFeld  ', 'Check n. update Feld', 'Feld checken, wenn Feldinhalt verändert wurde               ', 'j                   ', 'L', 'j', '2', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(142, 17, 17, 'checkur             ', 'NachUpd   ', 'Check n. update Tab ', 'Feld checken, wenn Tabellenbereich verändert wird           ', 'n                   ', 'L', 'j', '2', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

insert into 'agebadmin'.def_operator(operator,op_typ,op_bez) values('R','5','regulärer Ausdruck');

update 'agebadmin'.metafelder set m_join2_q = '#1,5' where tabid = 137 and feldid = 6;

insert into 'agebadmin'.kon_meldtxt values(482,'Q','Auftrag wirklich löschen' );

// 10.11.2006 insert into 'agebadmin'.def_fkt(fkttyp,fktnr,prog_txt,fkt_name) values ("P",13,"Neuer Barkassen-Auftrag", "Eingabe eines neuen Barkassen-Auftrages");

// 03.01.2007 alter table 'agebadmin'.def_progf add aktion_gid smallint;

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(117, 5, 1, 'aktion_gid          ', 'Akt.Gruppe', 'Aktions-Gruppe      ', 'Gruppen-ID der Aktion                                       ', NULL, NULL, 'n', '1', 'n', 'n', 'j', 'j', 'j', 'n', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

update 'agebadmin'.def_progf set aktion_gid = aktion_id;

INSERT INTO 'agebadmin'.def_progf(aktion_id, aktionbez, aktionpar, methode, aktion_gid)

 VALUES(9000, 'In Tab. Wert setzen ', 'Ansprechpartner Serienbrief   ', NULL, 9000);

INSERT INTO 'agebadmin'.def_progf(aktion_id, aktionbez, aktionpar, methode, aktion_gid)

 VALUES(9010, 'In Tab. Wert löschen', 'Ansprechpartner Serienbrief   ', NULL, 9010);

INSERT INTO 'agebadmin'.def_schlbez(typ, schl, schlbez)

 VALUES('DA', '0    ', 'Textarea                                          ');

INSERT INTO 'agebadmin'.def_schlbez(typ, schl, schlbez)

 VALUES('Z ', 'P    ', 'Aktion aus Kontekt-Menü (Bearbeitungsbereich)     ');

INSERT INTO 'agebadmin'.def_schlbez(typ, schl, schlbez)

 VALUES('Z ', 'T    ', 'Aktion aus Kontekt-Menü (Tabellenbereich)         ');

INSERT INTO 'agebadmin'.def_fkt(fktnr, fkttyp, prog_txt, fkt_name)

 VALUES(9000, 'P   ', 'Wert in Tabelle setzen             ', 'Alle in der Tabelle selektieren Datensätze einen Wert setzen          ');

INSERT INTO 'agebadmin'.def_fkt(fktnr, fkttyp, prog_txt, fkt_name)

 VALUES(9010, 'P   ', 'Wert in Tabelle löschen            ', 'Alle in der Tabelle selektieren Datensätze einen Wert löschen         ');

// 05.01.2007 Erweiterte Meta-Eigenschaften (Tabellen und Felder) CREATE TABLE 'agebadmin'.metatabparam (

   tabid 	INTEGER NOT NULL,
   key   	VARCHAR(20) NOT NULL,
   value 	VARCHAR(25) NOT NULL 
   );

CREATE TABLE 'agebadmin'.metafieldparam (

   tabid 	INTEGER NOT NULL,
   feldid	INTEGER NOT NULL,
   key   	VARCHAR(20) NOT NULL,
   value 	VARCHAR(25) NOT NULL 
   );

CREATE TABLE 'agebadmin'.def_metaparkey (

   metatyp    	CHAR(2) NOT NULL,
   metakey    	VARCHAR(20) NOT NULL,
   description	VARCHAR(50) 
   )

CREATE UNIQUE INDEX 'agebadmin'.dmp_1

   ON 'agebadmin'.def_metaparkey(metatyp, metakey)

CREATE TABLE 'agebadmin'.def_metaparvalue (

   metatyp    	CHAR(2) NOT NULL,
   metakey    	VARCHAR(20) NOT NULL,
   metavalue  	VARCHAR(25) NOT NULL,
   description	VARCHAR(50) 
   )

INSERT INTO 'agebadmin'.def_metaparkey(metatyp, metakey, description)

 VALUES('F ', 'SORT', 'Spalte sortieren');

INSERT INTO 'agebadmin'.def_metaparkey(metatyp, metakey, description)

 VALUES('F ', 'SORT_PRIO', 'Prio. der Spalte bei der Sortierung');

INSERT INTO 'agebadmin'.def_metaparkey(metatyp, metakey, description)

 VALUES('T ', 'CONTINUES_ADD', 'Kontinuierliches Einfügen eines neuen Datensatzes');

INSERT INTO 'agebadmin'.def_metaparvalue(metatyp, metakey, metavalue, description)

 VALUES('F ', 'SORT', 'ASC', 'Aufsteigende Sortierung');

INSERT INTO 'agebadmin'.def_metaparvalue(metatyp, metakey, metavalue, description)

 VALUES('F ', 'SORT', 'DESC', 'Absteigende Sortierung');

INSERT INTO 'agebadmin'.def_metaparvalue(metatyp, metakey, metavalue, description)

 VALUES('F ', 'SORT_PRIO', '1', 'Priorität der Spalte bei der Sortierung (1 = hoch)');

INSERT INTO 'agebadmin'.def_metaparvalue(metatyp, metakey, metavalue, description)

 VALUES('F ', 'SORT_PRIO', '2', 'Priorität der Spalte bei der Sortierung (1 = hoch)');

INSERT INTO 'agebadmin'.def_metaparvalue(metatyp, metakey, metavalue, description)

 VALUES('F ', 'SORT_PRIO', '3', 'Priorität der Spalte bei der Sortierung (1 = hoch)');

INSERT INTO 'agebadmin'.def_metaparvalue(metatyp, metakey, metavalue, description)

 VALUES('F ', 'SORT_PRIO', '4', 'Priorität der Spalte bei der Sortierung (1 = hoch)');

INSERT INTO 'agebadmin'.def_metaparvalue(metatyp, metakey, metavalue, description)

 VALUES('F ', 'SORT_PRIO', '5', 'Priorität der Spalte bei der Sortierung (1 = hoch)');

INSERT INTO 'agebadmin'.def_metaparvalue(metatyp, metakey, metavalue, description)

 VALUES('F ', 'SORT_PRIO', '6', 'Priorität der Spalte bei der Sortierung (1 = hoch)');

INSERT INTO 'agebadmin'.def_metaparvalue(metatyp, metakey, metavalue, description)

 VALUES('F ', 'SORT_PRIO', '7', 'Priorität der Spalte bei der Sortierung (1 = hoch)');

INSERT INTO 'agebadmin'.def_metaparvalue(metatyp, metakey, metavalue, description)

 VALUES('F ', 'SORT_PRIO', '8', 'Priorität der Spalte bei der Sortierung (1 = hoch)');

INSERT INTO 'agebadmin'.def_metaparvalue(metatyp, metakey, metavalue, description)

 VALUES('F ', 'SORT_PRIO', '9', 'Priorität der Spalte bei der Sortierung (1 = hoch)');

INSERT INTO 'agebadmin'.def_metaparvalue(metatyp, metakey, metavalue, description)

 VALUES('T ', 'CONTINUES_ADD', 'TRUE', 'Nach Aufnahme eines DS wieder neuen DS anbieten');

INSERT INTO 'agebadmin'.def_metaparvalue(metatyp, metakey, metavalue, description)

 VALUES('T ', 'CONTINUES_ADD', 'FALSE', 'Nach Aufnahme eines DS in Fortführungsmodus gehen');

INSERT INTO 'agebadmin'.def_fkt(fktnr, fkttyp, prog_txt, fkt_name)

 VALUES(980, 'T   ', 'Eigenschaftsschlüssel Metadaten    ', 'Schlüssel der Metadaten-Eigenschaften                                 ');

INSERT INTO 'agebadmin'.def_fkt(fktnr, fkttyp, prog_txt, fkt_name)

 VALUES(981, 'T   ', 'Eigenschaften Metadaten            ', 'Erweiterte Eigenschaften der Metadaten                                ');

INSERT INTO 'agebadmin'.def_fkt(fktnr, fkttyp, prog_txt, fkt_name)

 VALUES(996, 'T   ', 'Meta-Tabelleneigenschaften         ', 'Erweiterte Eigenschaften der Tabellen                                 ');

INSERT INTO 'agebadmin'.def_fkt(fktnr, fkttyp, prog_txt, fkt_name)

 VALUES(997, 'T   ', 'Meta-Feldeigenschaften             ', 'Erweiterte Eigenschaften der Tabellenfelder                           ');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(980, 1, 1, 'metatyp             ', 'Meta-Typ  ', 'Parametertyp        ', 'Typ des Paramters (Tabelleneigensch. = T, Feldeigensch. = F)', 'F                   ', NULL, 'j', '1', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(980, 2, 5, 'metakey             ', 'Meta-Key  ', 'Parameterschlüssel  ', 'Schlüssel des Paramters                                     ', NULL, NULL, 'j', '1', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(980, 3, 10, 'description         ', 'Beschreib ', 'Beschreibung        ', 'Beschreibung des Schlüssels                                 ', NULL, NULL, 'j', '1', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(981, 1, 1, 'metatyp             ', 'Meta-Typ  ', 'Parametertyp        ', 'Typ des Paramters (Tabelleneigensch. = T, Feldeigensch. = F)', 'MASTER              ', NULL, 'j', '1', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, 980, 1, '1           ', NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(981, 2, 5, 'metakey             ', 'Meta-Key  ', 'Parameterschlüssel  ', 'Schlüssel des Paramters                                     ', 'MASTER              ', NULL, 'j', '1', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, 980, 2, '2           ', NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(981, 3, 10, 'metavalue           ', 'Wert      ', 'Schlüsselwert       ', 'Wert des Schlüssels                                         ', NULL, NULL, 'j', '1', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(981, 4, 15, 'description         ', 'Beschreib ', 'Beschreibung        ', 'Beschreibung des Schlüsselwertes                            ', NULL, NULL, 'j', '1', 'n', 'n', 'j', 'j', 'j', 'j', 'n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(996, 1, 5, 'tabid               ', 'Tab.ID    ', 'Tabellen-ID         ', 'Ident.-Nummer der Tabelle                                   ', 'MASTER              ', NULL, 'j', '1', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, 102, 1, '1           ', NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(996, 2, 10, 'key                 ', 'Schlüssel ', 'Schlüssel           ', 'Schlüssel-Wort der Tabelleneigenschaft                      ', NULL, NULL, 'j', '3', 'j', 'n', 'j', 'j', 'j', 'j', 'n', NULL, 980, 2, '3           ', '#T             ', 1, NULL, NULL, NULL, 'n');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(996, 3, 15, 'value               ', 'Wert      ', 'Schlüssel-Wert      ', 'Tabelleneigenschaft zum Schlüssel                           ', NULL, NULL, 'j', '3', 'j', 'n', 'j', 'j', 'j', 'j', 'n', NULL, 981, 3, '4           ', '2              ', 2, '#T             ', 1, NULL, 'n');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(997, 1, 5, 'tabid               ', 'Tab.ID    ', 'Tabellen-ID         ', 'Ident.-Nummer der Tabelle                                   ', 'MASTER              ', NULL, 'j', '1', 'n', 'n', 'j', 'n', 'n', 'j', 'n', NULL, 102, 1, '1           ', NULL, NULL, NULL, NULL, NULL, 'n');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(997, 2, 10, 'feldid              ', 'Feld.ID   ', 'Feld-ID             ', 'Ident.-Nummer des Tabellenfeldes                            ', NULL, NULL, 'j', '3', 'j', 'n', 'j', 'j', 'j', 'j', 'n', NULL, 101, 2, '6           ', '1', '1', NULL, NULL, NULL, 'n');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(997, 3, 15, 'key                 ', 'Schlüssel ', 'Schlüssel           ', 'Schlüssel-Wort der Feldeigenschaft                          ', NULL, NULL, 'j', '3', 'j', 'n', 'j', 'j', 'j', 'j', 'n', NULL, 980, 2, '3           ', '#F             ', 1, NULL, NULL, NULL, 'n');

INSERT INTO 'agebadmin'.metafelder(tabid, feldid, m_darstid, m_feldname, m_kurzname, m_langname, m_hilfe, m_default, m_up_down, m_pflicht_jn, m_darstart, m_2spcombo_jn, m_edicombo_jn, m_darst_jn, m_neuein_jn, m_korr_jn, m_suchf_jn, m_join_jn, m_variable, m_reft, m_reff, m_refw, m_join2_q, m_join2_z, m_join3_q, m_join3_z, m_pflbeista, m_langtext)

 VALUES(997, 4, 20, 'value               ', 'Wert      ', 'Schlüssel-Wert      ', 'Feldeigenschaft zum Schlüssel                               ', NULL, NULL, 'j', '3', 'j', 'n', 'j', 'j', 'j', 'j', 'n', NULL, 981, 3, '4           ', '3              ', 2, '#F             ', 1, NULL, 'n');

INSERT INTO 'agebadmin'.metatabellen(tabid, m_tabtyp, m_tabname, m_ktabname, m_ltabname, m_hilfe, m_klasse, m_detailtab, m_detaillfd, m_detailflag, logflag, roflag)

 VALUES(980, 'D', 'agebadmin.def_metaparkey    ', 'Meta-Param  ', 'Def. Meta-Parameter      ', 'Schlüssel von  Metadateneigenschaften                       ', NULL, NULL, NULL, 'n', 'n', 'n');

INSERT INTO 'agebadmin'.metatabellen(tabid, m_tabtyp, m_tabname, m_ktabname, m_ltabname, m_hilfe, m_klasse, m_detailtab, m_detaillfd, m_detailflag, logflag, roflag)

 VALUES(981, 'D', 'agebadmin.def_metaparvalue  ', 'Meta-Value  ', 'Def. Meta-Param.Werte    ', 'Werte  von  Metadateneigenschaften                          ', NULL, 980, 1, 'n', 'n', 'n');

INSERT INTO 'agebadmin'.metatabellen(tabid, m_tabtyp, m_tabname, m_ktabname, m_ltabname, m_hilfe, m_klasse, m_detailtab, m_detaillfd, m_detailflag, logflag, roflag)

 VALUES(996, 'S', 'agebadmin.metatabparam      ', 'Tab-Param   ', 'Tabellen-Parameter       ', 'Definition von weiteren Tabellen-Eigenschaften              ', NULL, 102, 0, 'n', 'n', 'n');

INSERT INTO 'agebadmin'.metatabellen(tabid, m_tabtyp, m_tabname, m_ktabname, m_ltabname, m_hilfe, m_klasse, m_detailtab, m_detaillfd, m_detailflag, logflag, roflag)

 VALUES(997, 'S', 'agebadmin.metafieldparam    ', 'Feld-Param  ', 'Feld-Parameter           ', 'Definition von weiteren Feld-Eigenschaften                  ', NULL, 102, 4, 'n', 'n', 'n');
 

// 12.01.2007 Neue Programm-Funktionen INSERT INTO 'agebadmin'.def_progf(aktion_id, aktionbez, aktionpar, methode, aktion_gid)

 VALUES(1220, 'GebZuO.:Tage setzen', NULL, NULL, 1220);

INSERT INTO 'agebadmin'.def_progf(aktion_id, aktionbez, aktionpar, methode, aktion_gid)

 VALUES(1221, 'GebZuO.:Auft setzen', NULL, NULL, 1221);
Meine Werkzeuge
Namensräume

Varianten
Aktionen
Navigation
Werkzeuge