XPqcNEbx

1create table `localized_text_values` (
2	`id` int(20) not null auto_increment unique,
3    `lang` varchar(5) not null,
4    `text` varchar(50),
5    primary key(`id`)
6)  ENGINE=InnoDB DEFAULT CHARSET=utf8;
7
8CREATE TABLE localized_texts (
9    `text_link_id` bigint(20) NOT NULL auto_increment,
10    `text_id` int(20) NOT NULL,
11	UNIQUE KEY `text_link_id` (`text_link_id`),
12    UNIQUE KEY `text_id` (`text_id`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8;
14
15alter table localized_texts
16add CONSTRAINT FKr38us2n8g5p9rj0b494sd3392 FOREIGN KEY (`text_id`) REFERENCES `localized_text_values`(`id`);
17
18CREATE TABLE if not exists `tariff_models` (
19  `id` bigint(20) NOT NULL auto_increment,
20  `internal_id` varchar(45) NOT NULL,
21  `description_text_id` bigint(20) NOT NULL ,
22  PRIMARY KEY (`id`),
23  UNIQUE KEY `internal_id_UNIQUE` (`internal_id`),
24  KEY `tm_description_text_k_1` (`description_text_id`),
25  CONSTRAINT FKr38us2n8g5p9rj0b494sd3393 FOREIGN KEY (`description_text_id`) REFERENCES `localized_texts`(`text_link_id`)
26) ENGINE=InnoDB DEFAULT CHARSET=utf8;