DhqYVSXb

1CREATE TABLE IF NOT EXISTS settings(
2    id SERIAL PRIMARY KEY,
3    namespace character varying,
4    code character varying NOT NULL,
5    value character varying NOT NULL,
6		signame character varying NOT NULL	-- добавил имя для сигналов
7);
8
9CREATE TABLE IF NOT EXISTS device_settings(
10    device_id integer NOT NULL,
11    setting_id smallint NOT NULL,
12    CONSTRAINT device_settings_pk PRIMARY KEY (device_id, setting_id),
13    CONSTRAINT device_settings_to_settings_fk FOREIGN KEY (setting_id) REFERENCES settings (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION
14);