SQL

CREATE TABLE `follow`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `user_id` INTEGER NULL,
  `follow_id` INTEGER NULL,
  `created_unix` INTEGER NULL
)

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_follow_created_unix created_unix SQL 
CREATE INDEX `IDX_follow_created_unix`
ON `follow` (`created_unix`)
Drop
UQE_follow_follow
  • user_id
  • follow_id
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_follow_follow`
ON `follow` (`user_id`,`follow_id`)
Drop