SQL

CREATE TABLE `user_blocking`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `blocker_id` INTEGER NULL,
  `blockee_id` INTEGER NULL,
  `note` TEXT NULL,
  `created_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
blocker_id INTEGER ✓ Rename | Drop
blockee_id INTEGER ✓ Rename | Drop
note TEXT ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_user_blocking_created_unix created_unix SQL 
CREATE INDEX `IDX_user_blocking_created_unix`
ON `user_blocking` (`created_unix`)
Drop
UQE_user_blocking_block
  • blocker_id
  • blockee_id
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_user_blocking_block`
ON `user_blocking` (`blocker_id`,`blockee_id`)
Drop