TABLE_(TESTPARTNER)
   SERIAL_  (TESTPARTNER_ID) PRIMARY_KEY
   STRING_  (TESTPARTNER_NAME, 200) INDEX
   STRING_  (TESTPARTNER_ADDRESS, 200)
END_TABLE

TABLE_(TESTPRODUCT)
   SERIAL_  (TESTPRODUCT_ID) PRIMARY_KEY
   STRING_  (TESTPRODUCT_NAME, 200) INDEX
   STRING_  (TESTPRODUCT_UNIT, 20)
END_TABLE

#define SERIAL(x) COLUMN("serial primary key", int64, x, 0, 0)

create table TESTPARTNER (
  TESTPARTNER_ID       serial primary key primary key,
  TESTPARTNER_NAME     varchar(200),
  TESTPARTNER_ADDRESS  varchar(200)
);

create table TESTPRODUCT (
  TESTPRODUCT_ID       serial primary key primary key,
  TESTPRODUCT_NAME     varchar(200),
  TESTPRODUCT_UNIT     varchar(20)
);