MessageTable

-- Table: message

-- DROP TABLE message;

CREATE TABLE message
(
  id BIGINT NOT NULL,
  content CHARACTER VARYING(255)
  state INTEGER NOT NULL,
  "timestamp" TIMESTAMP WITHOUT TIME zone NOT NULL,
  "type" SMALLINT NOT NULL,
  "value" INTEGER NOT NULL,
  "version" BIGINT,
  CONSTRAINT message_pkey PRIMARY KEY (id),
  CONSTRAINT fk4fd9df62c03634dc FOREIGN KEY (box_id)
      REFERENCES box (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
)
WITH (
  OIDS=FALSE
);
ALTER TABLE message OWNER TO "sa";
GRANT ALL ON TABLE message TO public;
GRANT ALL ON TABLE message TO "sa";

-- Index: "message_box_Idx"

-- DROP INDEX "message_box_Idx";

CREATE INDEX "message_box_Idx"
  ON message
  USING btree
  (box_id);