CREATE TABLE PEACONTAINER(
  ID INTEGER NOT NULL,
  DELETED INTEGER NOT NULL,
  PRIOR INTEGER NOT NULL,
  NEXT INTEGER NOT NULL,
  CAPTION VARCHAR(1024) NOT NULL,
  LINK INTEGER NOT NULL,
  CONSTRAINT PK_PEACONTAINER_ID PRIMARY KEY (ID)
);

CREATE GENERATOR GEN_PEACONTAINER_ID;

CREATE TABLE PEACONTAINER_PEA_VALUE_FIRST(
  PEACONTAINER INTEGER NOT NULL,
  PEAVALUEFIRST INTEGER NOT NULL
);

CREATE INDEX IDX_PEACONTAINER_PEA_VALUE_FIRST_MAIN ON
  PEACONTAINER_PEA_VALUE_FIRST (PEACONTAINER);

CREATE TABLE PEACONTAINER_PEA_VALUE_LAST(
  PEACONTAINER INTEGER NOT NULL,
  PEAVALUELAST INTEGER NOT NULL
);

CREATE INDEX IDX_PEACONTAINER_PEA_VALUE_LAST_MAIN ON
  PEACONTAINER_PEA_VALUE_LAST (PEACONTAINER);


CREATE TABLE PEAVALUE(
  ID INTEGER NOT NULL,
  DELETED INTEGER NOT NULL,
  PRIOR INTEGER NOT NULL,
  NEXT INTEGER NOT NULL,
  CAPTION VARCHAR(1024) NOT NULL,
  INT_VALUE INTEGER NOT NULL,
  CONSTRAINT PK_PEAVALUE_ID PRIMARY KEY (ID)
);

CREATE GENERATOR GEN_PEAVALUE_ID;

CREATE TABLE PEAVALUE_CAPTIONS(
  PEAVALUE INTEGER NOT NULL,
  CAPTION VARCHAR(1024) NOT NULL
);

CREATE INDEX IDX_PEAVALUE_CAPTIONS_MAIN ON PEAVALUE_CAPTIONS (PEAVALUE);

CREATE TABLE PEAVALUE_MY_INT_VALUES(
  PEAVALUE INTEGER NOT NULL,
  MYINTVALUE INTEGER NOT NULL
);

CREATE INDEX IDX_PEAVALUE_MY_INT_VALUES_MAIN ON
  PEAVALUE_MY_INT_VALUES (PEAVALUE);

CREATE TABLE PEACONTAINER_HUGE_PEA_VALUES(
  PEACONTAINER INTEGER NOT NULL,
  PEAVALUE INTEGER NOT NULL,
  SOME_CAPTION VARCHAR(1024) NOT NULL,
  SOME_INT INTEGER NOT NULL
);