create table lexfortoy (
  hdlnr integer,
  active integer,
  editor_timestamp datetime year to second,
  editor_code char(2),
  editor_name char(64),
  editor_action char(20),
  ip_backend char(20),
  ip_frontend char(20)
);

create unique index ndx_lexfortoy on lexfortoy(hdlnr);


create table dealer
  (
    hdlnr integer,
    name char(40),
    zusatz char(40),
    strasse char(40),
    plz char(5),
    ort char(40)
  );

create index ndx_dealer on dealer(hdlnr);