-- table for all category variables
CREATE TABLE category (category_type TEXT, category_id INT, parent_category_id INT REFERENCES category (category_id),  
category_name_en TEXT, category_name_de TEXT, 
category_name_fr TEXT, category_name_sp TEXT, category_name_pt TEXT, category_name_ja TEXT, 
category_name_ru TEXT, category_name_nl TEXT, category_name_fi TEXT,
PRIMARY KEY (category_type, category_id) );

-- INSERT INTO category (category_type, category_id, category_name_en) VALUES ('null', 0, 'category');