CREATE SCHEMA rr_times; CREATE TABLE rr_times.locales ( language_code VARCHAR(2), country_code VARCHAR(2), name VARCHAR(50) UNIQUE NOT NULL, PRIMARY KEY (language_code, country_code) ); CREATE TABLE rr_times.translated_articles ( id SERIAL PRIMARY KEY, title TEXT NOT NULL, body TEXT NOT NULL );