SQL

CREATE TABLE `user_badge`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `badge_id` INTEGER NULL,
  `user_id` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
badge_id INTEGER ✓ Rename | Drop
user_id INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_user_badge_user_id user_id SQL 
CREATE INDEX `IDX_user_badge_user_id`
ON `user_badge` (`user_id`)
Drop