[sql]
ALTER TABLE product ADD COLUMN image_name character varying(200);
ALTER TABLE product ADD COLUMN warranty_pl text;
ALTER TABLE product ADD COLUMN warranty_en text;
ALTER TABLE product ADD COLUMN warranty_de text;
ALTER TABLE product ADD COLUMN warranty_ru text;
ALTER TABLE product ADD COLUMN warranty_es text;
ALTER TABLE product ADD COLUMN show_warranty_pl boolean DEFAULT false;
ALTER TABLE product ADD COLUMN show_warranty_en boolean DEFAULT false;
ALTER TABLE product ADD COLUMN show_warranty_de boolean DEFAULT false;
ALTER TABLE product ADD COLUMN show_warranty_ru boolean DEFAULT false;
ALTER TABLE product ADD COLUMN show_warranty_es boolean DEFAULT false;
ALTER TABLE product ADD COLUMN main_features_pl text;
ALTER TABLE product ADD COLUMN main_features_en text;
ALTER TABLE product ADD COLUMN main_features_de text;
ALTER TABLE product ADD COLUMN main_features_ru text;
ALTER TABLE product ADD COLUMN main_features_es text;
ALTER TABLE product ADD COLUMN measurement_height real;
ALTER TABLE product ADD COLUMN measurement_wide real;
ALTER TABLE product ADD COLUMN measurement_long real;
ALTER TABLE product ADD COLUMN measurement_weight real;
ALTER TABLE product ADD COLUMN show_measurement boolean DEFAULT false;
CREATE TABLE icon (  icon_id serial,   icon_name character varying(200),   CONSTRAINT icon_pkey PRIMARY KEY (icon_id)) WITH (  OIDS = FALSE );
CREATE TABLE icon_product(  ip_icon_id integer NOT NULL,  ip_product_id integer NOT NULL,  CONSTRAINT icon_product_id_icon_id_key PRIMARY KEY (ip_icon_id, ip_product_id),  CONSTRAINT icon_product_ip_icon_id_fkey FOREIGN KEY (ip_icon_id)      REFERENCES icon (icon_id) MATCH SIMPLE      ON UPDATE CASCADE ON DELETE RESTRICT,  CONSTRAINT icon_product_ip_product_id_fkey FOREIGN KEY (ip_product_id)      REFERENCES product (id) MATCH SIMPLE      ON UPDATE CASCADE ON DELETE RESTRICT ) WITH ( OIDS=FALSE );
UPDATE product SET image_name=(SELECT photo FROM product_image  WHERE product_id=product.id ORDER BY rank ASC LIMIT 1);