SQL

CREATE TABLE `unitLocalization`  (
  `id` text PRIMARY KEY,
  `unit_id` text NOT NULL,
  `name_de` text,
  `name_en` text,
  `name_fr` text,
  `name_it` text,
  `name_ru` text,
  `name_ua` text,
  `name_ar` text,
  `name_cs` text,
  `name_es` text,
  `name_hr` text,
  `name_hu` text,
  `name_pl` text,
  `name_pt` text,
  `description_de` text,
  `description_en` text,
  `description_fr` text,
  `description_it` text,
  `description_ru` text,
  `description_ua` text,
  `description_ar` text,
  `description_cs` text,
  `description_es` text,
  `description_hr` text,
  `description_hu` text,
  `description_pl` text,
  `description_pt` text,
  CONSTRAINT `fk_unitLocalization_unit_id_unit_id_fk` FOREIGN KEY (`unit_id`) REFERENCES `unit`(`id`)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT Rename | Drop
unit_id TEXT Rename | Drop
name_de TEXT Rename | Drop
name_en TEXT Rename | Drop
name_fr TEXT Rename | Drop
name_it TEXT Rename | Drop
name_ru TEXT Rename | Drop
name_ua TEXT Rename | Drop
name_ar TEXT Rename | Drop
name_cs TEXT Rename | Drop
name_es TEXT Rename | Drop
name_hr TEXT Rename | Drop
name_hu TEXT Rename | Drop
name_pl TEXT Rename | Drop
name_pt TEXT Rename | Drop
description_de TEXT Rename | Drop
description_en TEXT Rename | Drop
description_fr TEXT Rename | Drop
description_it TEXT Rename | Drop
description_ru TEXT Rename | Drop
description_ua TEXT Rename | Drop
description_ar TEXT Rename | Drop
description_cs TEXT Rename | Drop
description_es TEXT Rename | Drop
description_hr TEXT Rename | Drop
description_hu TEXT Rename | Drop
description_pl TEXT Rename | Drop
description_pt TEXT Rename | Drop

Foreign Keys

Column Destination
unit_id unit.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_unitLocalization_1 id SQL
-- no sql found --
Drop