CREATE TABLE "news"("id" serial  NOT NULL,"title_pl" VARCHAR(255),"title_en" VARCHAR(255),"title_de" VARCHAR(255),"title_ru" VARCHAR(255),"description_pl" TEXT,"description_en" TEXT,"description_de" TEXT,"description_ru" TEXT,"active_pl" BOOLEAN default 't',"active_en" BOOLEAN default 't' ,"active_de" BOOLEAN default 't' ,"active_ru" BOOLEAN default 't' ,"more_url" VARCHAR(255),"start_date" DATE,"end_date" DATE,PRIMARY KEY ("id"));
CREATE TABLE "news_photo"("id" serial  NOT NULL,"news_id" INTEGER  NOT NULL,"photo" VARCHAR(255),"description_pl" TEXT,"description_en" TEXT,"description_de" TEXT,"description_ru" TEXT,"main_photo" BOOLEAN default 'f',"sort" INTEGER default 0,PRIMARY KEY ("id"));
ALTER TABLE "news_photo" ADD CONSTRAINT "news_photo_FK_1" FOREIGN KEY ("news_id") REFERENCES "news" ("id") ON UPDATE CASCADE ON DELETE CASCADE;