[sql]
ALTER TABLE category ADD COLUMN name_es character varying(128);
ALTER TABLE category ADD COLUMN description_es text;
ALTER TABLE category ADD COLUMN active_es boolean DEFAULT false;
ALTER TABLE category ADD COLUMN mobile_description_es text;
ALTER TABLE news ADD COLUMN title_es character varying(255);
ALTER TABLE news ADD COLUMN description_es text;
ALTER TABLE news ADD COLUMN active_es boolean DEFAULT true;
ALTER TABLE news_photo ADD COLUMN description_es text;
ALTER TABLE past_project_image ADD COLUMN description_es text;
ALTER TABLE product ADD COLUMN dimension_es text;
ALTER TABLE product ADD COLUMN name_es character varying(128);
ALTER TABLE product ADD COLUMN description_es text;
ALTER TABLE product ADD COLUMN short_description_es text;
ALTER TABLE product ADD COLUMN active_es boolean DEFAULT false;
ALTER TABLE product ADD COLUMN mobile_description_es text;
ALTER TABLE product_image ADD COLUMN description_es text;
ALTER TABLE promotion ADD COLUMN name_es character varying(128);
ALTER TABLE promotion ADD COLUMN active_es boolean DEFAULT false;
ALTER TABLE contact ADD COLUMN name_es character varying(50);
ALTER TABLE label_storage ADD COLUMN name_es character varying(250);
UPDATE label_storage SET name_es=name_en;
UPDATE contact SET name_es=name_en;
UPDATE promotion SET name_es=name_en;
UPDATE promotion SET active_es=active_en;
UPDATE product_image SET description_es=description_en;
UPDATE product SET dimension_es=dimension_en;
UPDATE product SET name_es=name_en;
UPDATE product SET description_es=description_en;
UPDATE product SET short_description_es=short_description_en;
UPDATE product SET active_es=active_en;
UPDATE product SET mobile_description_es=mobile_description_en;
UPDATE past_project_image SET description_es=description_en;
UPDATE news_photo SET description_es=description_en;
UPDATE news SET title_es=title_en;
UPDATE news SET description_es=description_en;
UPDATE news SET active_es=active_en;
UPDATE category SET name_es=name_en;
UPDATE category SET description_es=description_en;
UPDATE category SET active_es=active_en;
UPDATE category SET mobile_description_es=mobile_description_en;
INSERT INTO language (id, name, short, code) VALUES (5, 'Spain', 'ES', 'es_ES');
ALTER TABLE static_pages ADD COLUMN name_es character varying(128);
ALTER TABLE static_pages ADD COLUMN description_es text;
UPDATE static_pages SET name_es=name_en;
UPDATE static_pages SET description_es=description_en;