tables.sql

create table product
(
id INTEGER not null
primary key,
price INTEGER not null
);

create table product_translation
(
id INTEGER not null
primary key
autoincrement,
translatable_id INTEGER default NULL,
name VARCHAR(255) not null,
description VARCHAR(255) not null,
locale VARCHAR(255) not null
);

create index IDX_1846DB702C2AC5D3
on product_translation (translatable_id);

create unique index product_translation_unique_translation
on product_translation (translatable_id, locale);