SQL

CREATE TABLE `user_setting`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `user_id` INTEGER NULL,
  `setting_key` TEXT NULL,
  `setting_value` TEXT NULL
)

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_user_setting_setting_key setting_key SQL 
CREATE INDEX `IDX_user_setting_setting_key`
ON `user_setting` (`setting_key`)
Drop
IDX_user_setting_user_id user_id SQL 
CREATE INDEX `IDX_user_setting_user_id`
ON `user_setting` (`user_id`)
Drop
UQE_user_setting_key_userid
  • user_id
  • setting_key
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_user_setting_key_userid`
ON `user_setting` (`user_id`,`setting_key`)
Drop