58 lines
4.7 KiB
Plaintext
58 lines
4.7 KiB
Plaintext
INSERT INTO `varfielddef` (`Oid`, `Tid`, `IsActive`, `Notice`, `InsTs`, `InsUser`, `Version`, `UdpUser`, `SystemEntryID`, `GroupString`, `XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`) VALUES (1, 56, '1', NULL, '2010-05-06 00:00:00', 'sys', 2, 'Christian Wirth', NULL, 'Gruppe1', 1, 1, 'Abschluss', 1, '', 0, 1);
|
|
INSERT INTO `varfielddef` (`Oid`, `Tid`, `IsActive`, `Notice`, `InsTs`, `InsUser`, `Version`, `UdpUser`, `SystemEntryID`, `GroupString`, `XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`) VALUES (2, 56, '1', NULL, '2010-05-06 00:00:00', 'sys', 2, 'Christian Wirth', NULL, 'Gruppe1', 1, 2, 'Ist Kunde netter Kerl', 0, '', 0, 1);
|
|
INSERT INTO `varfielddef` (`Oid`, `Tid`, `IsActive`, `Notice`, `InsTs`, `InsUser`, `Version`, `UdpUser`, `SystemEntryID`, `GroupString`, `XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`) VALUES (3, 56, '1', NULL, '2010-05-06 00:00:00', 'sys', 2, 'Christian Wirth', NULL, 'Gruppe2', 1, 1, 'Test Memo', 6, '', 0, 1);
|
|
INSERT INTO `varfielddef` (`Oid`, `Tid`, `IsActive`, `Notice`, `InsTs`, `InsUser`, `Version`, `UdpUser`, `SystemEntryID`, `GroupString`, `XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`) VALUES (4, 56, '1', NULL, '2010-05-06 00:00:00', 'sys', 2, 'Christian Wirth', NULL, 'Gruppe2', 1, 2, 'Geburt', 3, '', 0, 1);
|
|
INSERT INTO `varfielddef` (`Oid`, `Tid`, `IsActive`, `Notice`, `InsTs`, `InsUser`, `Version`, `UdpUser`, `SystemEntryID`, `GroupString`, `XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`) VALUES (6, 56, '1', NULL, '2010-05-10 00:00:00', 'sys', 1, 'sys', NULL, 'Gruppe3', 1, 2, 'Verwandte', 5, 'Onkel;Tante;Oma;Opa;Bruder;Schwester;Vater;Mutter', NULL, 1);
|
|
INSERT INTO `varfielddef` (`Oid`, `Tid`, `IsActive`, `Notice`, `InsTs`, `InsUser`, `Version`, `UdpUser`, `SystemEntryID`, `GroupString`, `XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`) VALUES (5, 56, '1', NULL, '2010-05-06 00:00:00', 'sys', 2, 'Christian Wirth', NULL, 'Gruppe3', 1, 1, 'Haustier', 4, 'Hund;Katze;Maus', 0, 1);
|
|
INSERT INTO `varfielddef` (`Oid`, `Tid`, `IsActive`, `Notice`, `InsTs`, `InsUser`, `Version`, `UdpUser`, `SystemEntryID`, `GroupString`, `XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`) VALUES (7, 56, '1', NULL, '2010-05-10 00:00:00', NULL, NULL, NULL, NULL, 'Gruppe2', 1, 3, 'Number', 2, '', 2, 1);
|
|
COMMIT;
|
|
|
|
INSERT INTO `varfielddef`
|
|
(`Tid`, `IsActive`, `Version`, `GroupString`,
|
|
`XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`)
|
|
VALUES
|
|
(56, '1', 1, 'Weitere Eigenschaften', 1, 1, 'Memo', 6, '', 0, 1);
|
|
|
|
|
|
INSERT INTO `varfielddef`
|
|
(`Tid`, `IsActive`, `Version`, `GroupString`,
|
|
`XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`)
|
|
VALUES
|
|
(56, '1', 1, 'Aktenzeichen KR', 1, 1, 'Klient', 0, '', 0, 1);
|
|
INSERT INTO `varfielddef`
|
|
(`Tid`, `IsActive`, `Version`, `GroupString`,
|
|
`XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`)
|
|
VALUES
|
|
(56, '1', 1, 'Aktenzeichen KR', 1, 1, 'Abteilung', 0, '', 0, 1);
|
|
INSERT INTO `varfielddef`
|
|
(`Tid`, `IsActive`, `Version`, `GroupString`,
|
|
`XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`)
|
|
VALUES
|
|
(56, '1', 1, 'Aktenzeichen KR', 1, 1, 'Wohnort', 0, '', 0, 1);
|
|
INSERT INTO `varfielddef`
|
|
(`Tid`, `IsActive`, `Version`, `GroupString`,
|
|
`XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`)
|
|
VALUES
|
|
(56, '1', 1, 'Aktenzeichen KR', 1, 1, 'Status /stat./amb.', 0, '', 0, 1);
|
|
INSERT INTO `varfielddef`
|
|
(`Tid`, `IsActive`, `Version`, `GroupString`,
|
|
`XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`)
|
|
VALUES
|
|
(56, '1', 1, 'Aktenzeichen KR', 1, 1, 'Kostenträger', 0, '', 0, 1);
|
|
|
|
INSERT INTO `varfielddef`
|
|
(`Oid`, `Tid`, `IsActive`, `Notice`, `InsTs`, `InsUser`, `Version`, `UdpUser`, `SystemEntryID`,
|
|
`GroupString`, `XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`)
|
|
VALUES (2, 56, '1', NULL, '2010-05-06 00:00:00', 'sys', 2, 'Christian Wirth', NULL, 'Gruppe1', 1, 2, 'Ist Kunde netter Kerl', 0, '', 0, 1);
|
|
|
|
|
|
|
|
|
|
|
|
//Integra:
|
|
|
|
INSERT INTO `varfielddef`
|
|
(`Tid`, `IsActive`, `Version`, `GroupString`,
|
|
`XCoordinate`, `YCoordinate`, `Label`, `ControlType`, `PossibleItems`, `DecimalPlaces`, `ObjectTid`)
|
|
VALUES
|
|
(56, '1', 1, 'Allgemeine Eigenschaften', 1, 1, 'Körperlicher Zustand / Unfälle/ frühere Krankheiten / Suizidversuche', 0, '', 0, 1); |