CREATE TABLE site.lang (
	id serial4 NOT NULL,
	title varchar(50) NOT NULL,
	"key" varchar(2) NOT NULL,
	CONSTRAINT lang_pk PRIMARY KEY (id)
);

CREATE TABLE site.feedback_theme (
	id serial4 NOT NULL,
	state int4 NOT NULL DEFAULT 1,
	title varchar(255) NOT NULL,
	priority int4 NULL,
	CONSTRAINT feedback_theme_pk PRIMARY KEY (id)
);

CREATE TABLE site.feedback_theme_lang (
	id serial4 NOT NULL,
	lang_id int4 NOT NULL,
	theme_id int4 NOT NULL,
	"translate" varchar NOT NULL,
	CONSTRAINT feedback_theme_lang_pk PRIMARY KEY (id),
	CONSTRAINT feedback_theme_lang_uk UNIQUE (lang_id, theme_id)
);


-- site.feedback_theme_lang foreign keys

ALTER TABLE site.feedback_theme_lang ADD CONSTRAINT feedback_theme_lang_fk FOREIGN KEY (lang_id) REFERENCES site.lang(id);
ALTER TABLE site.feedback_theme_lang ADD CONSTRAINT feedback_theme_lang_fk2 FOREIGN KEY (theme_id) REFERENCES site.feedback_theme(id);

SELECT ft.id, ft.title, l.KEY
FROM site.feedback_theme ft 
CROSS JOIN site.lang l
;