CREATE TABLE "TABLENAME1" (
  "ID" number NOT NULL,
  "FIELDN1" number NOT NULL,
  "FIELDN2" number NOT NULL DEFAULT '-1',
  "FIELDN3" number NOT NULL DEFAULT '0',
  "FIELDN4" number NOT NULL
);