SQL

CREATE TABLE `action`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `user_id` INTEGER NULL,
  `op_type` INTEGER NULL,
  `act_user_id` INTEGER NULL,
  `repo_id` INTEGER NULL,
  `comment_id` INTEGER NULL,
  `is_deleted` INTEGER DEFAULT 0 NOT NULL,
  `ref_name` TEXT NULL,
  `is_private` INTEGER DEFAULT 0 NOT NULL,
  `content` TEXT 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
op_type INTEGER ✓ Rename | Drop
act_user_id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
comment_id INTEGER ✓ Rename | Drop
is_deleted INTEGER Rename | Drop
ref_name TEXT ✓ Rename | Drop
is_private INTEGER Rename | Drop
content TEXT ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_action_au_c_u
  • act_user_id
  • created_unix
  • user_id
 SQL 
CREATE INDEX `IDX_action_au_c_u`
ON `action` (`act_user_id`,`created_unix`,`user_id`)
Drop
IDX_action_au_r_c_u_d
  • act_user_id
  • repo_id
  • created_unix
  • user_id
  • is_deleted
 SQL 
CREATE INDEX `IDX_action_au_r_c_u_d`
ON `action` (`act_user_id`,`repo_id`,`created_unix`,`user_id`,`is_deleted`)
Drop
IDX_action_c_u
  • user_id
  • is_deleted
 SQL 
CREATE INDEX `IDX_action_c_u`
ON `action` (`user_id`,`is_deleted`)
Drop
IDX_action_c_u_d
  • created_unix
  • user_id
  • is_deleted
 SQL 
CREATE INDEX `IDX_action_c_u_d`
ON `action` (`created_unix`,`user_id`,`is_deleted`)
Drop
IDX_action_comment_id comment_id SQL 
CREATE INDEX `IDX_action_comment_id`
ON `action` (`comment_id`)
Drop
IDX_action_r_u_d
  • repo_id
  • user_id
  • is_deleted
 SQL 
CREATE INDEX `IDX_action_r_u_d`
ON `action` (`repo_id`,`user_id`,`is_deleted`)
Drop
IDX_action_user_id user_id SQL 
CREATE INDEX `IDX_action_user_id`
ON `action` (`user_id`)
Drop