SQL

CREATE TABLE `system_setting`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `setting_key` TEXT NULL,
  `setting_value` TEXT NULL,
  `version` INTEGER NULL,
  `created` INTEGER NULL,
  `updated` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
setting_key TEXT ✓ Rename | Drop
setting_value TEXT ✓ Rename | Drop
version INTEGER ✓ Rename | Drop
created INTEGER ✓ Rename | Drop
updated INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
UQE_system_setting_setting_key setting_key ✓ SQL 
CREATE UNIQUE INDEX `UQE_system_setting_setting_key`
ON `system_setting` (`setting_key`)
Drop