create.txt

CREATE TABLE OLD_SYS_USER (
	USERID serial NOT NULL,
	NAME varchar(20) NOT NULL,
	LASTNAME varchar(20) NOT NULL,
	EMAIL varchar(40) NOT NULL,
	PHONE varchar(15) NOT NULL,
	NICK varchar(20) NOT NULL,
	PASSWORD varchar(20) NOT NULL,
	CONSTRAINT USER_PKEY PRIMARY KEY (USERID),
	CONSTRAINT "UNIQUE(NAME)" UNIQUE(NICK)
);

CREATE TABLE OLD_PUBLICATION (
	PUBLICATIONID serial NOT NULL,
	userId int NOT NULL,
	type int NOT NULL,
	operation_type int NOT NULL,
	address varchar(50) NOT NULL,
	city varchar(30) NOT NULL,
	price float NOT NULL,
	environments int NOT NULL,
	covered float NOT NULL,
	uncovered float NOT NULL,
	age int NOT NULL,
	cable boolean NOT NULL,
	phone boolean NOT NULL,
	pool boolean NOT NULL,
	living boolean NOT NULL,
	paddle boolean NOT NULL,
	barbecue boolean NOT NULL,
	description varchar(1000),
	active boolean NOT NULL,
	CONSTRAINT "PUBLICATION_PRIMARY_KEY" PRIMARY KEY(PUBLICATIONID),
	CONSTRAINT "PUBLICATION_FK_USER" FOREIGN KEY(userId)
      REFERENCES OLD_SYS_USER (USERID) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
);

CREATE TABLE OLD_PHOTO (
	PHOTOID serial NOT NULL,
	PUBLICATIONID int NOT NULL,
	PHOTO bytea NOT NULL,
	CONSTRAINT "PHOTO_PRIMARY_KEY" PRIMARY KEY(PHOTOID),
	CONSTRAINT "PHOTO_FK_PUBLI" FOREIGN KEY(PUBLICATIONID)
      REFERENCES OLD_PUBLICATION (PUBLICATIONID) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
);


CREATE TABLE OLD_property_type
(
  id integer NOT NULL,
  description character varying(10),
  CONSTRAINT property_type_pkey PRIMARY KEY (id)
);

CREATE TABLE OLD_operation_type
(
  id integer NOT NULL,
  description character varying(10),
  CONSTRAINT operation_type_pkey PRIMARY KEY (id)
);

INSERT INTO OLD_PROPERTY_TYPE(id, description) VALUES('1', 'Casa');
INSERT INTO OLD_PROPERTY_TYPE(id, description) VALUES('2', 'Depto.');
INSERT INTO OLD_OPERATION_TYPE(id, description) VALUES('1', 'Venta');
INSERT INTO OLD_OPERATION_TYPE(id, description) VALUES('2', 'Alquiler');