[sql]
CREATE TABLE "reference_projects"(   id integer NOT NULL,    title_pl character varying(100),    title_en character varying(100),    title_de character varying(100),    title_ru character varying(100),    title_es character varying(100),    country_pl character varying(50),    country_en character varying(50),   country_de character varying(50),    country_ru character varying(50),   country_es character varying(50),    CONSTRAINT reference_projects_pk PRIMARY KEY (id)) WITH (  OIDS = FALSE);
ALTER TABLE "reference_projects" ADD COLUMN city_pl character varying(50);
ALTER TABLE "reference_projects" ADD COLUMN city_en character varying(50);
ALTER TABLE "reference_projects" ADD COLUMN city_de character varying(50);
ALTER TABLE "reference_projects" ADD COLUMN city_ru character varying(50);
ALTER TABLE "reference_projects" ADD COLUMN city_es character varying(50);
ALTER TABLE "reference_projects" ADD COLUMN created_at timestamp without time zone;
ALTER TABLE "reference_projects" ADD COLUMN active_pl boolean DEFAULT true;
ALTER TABLE "reference_projects" ADD COLUMN active_en boolean DEFAULT true;
ALTER TABLE "reference_projects" ADD COLUMN active_de boolean DEFAULT true;
ALTER TABLE "reference_projects" ADD COLUMN active_ru boolean DEFAULT true;
ALTER TABLE "reference_projects" ADD COLUMN active_es boolean DEFAULT true;
CREATE TABLE reference_projects_photo(   id integer NOT NULL,    name character varying(50),    reference_projects_id integer NOT NULL,    sort integer,    CONSTRAINT reference_projects_photo_pk PRIMARY KEY (id),    CONSTRAINT reference_projects_photo_fk FOREIGN KEY (reference_projects_id) REFERENCES "reference_projects" (id) ON UPDATE CASCADE ON DELETE CASCADE) WITH (  OIDS = FALSE);
CREATE SEQUENCE reference_projects_id_seq;
CREATE SEQUENCE reference_projects_photo_id_seq;