SQL

CREATE TABLE `language_stat`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NOT NULL,
  `commit_id` TEXT NULL,
  `is_primary` INTEGER NULL,
  `language` TEXT NOT NULL,
  `size` INTEGER DEFAULT 0 NOT NULL,
  `created_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
repo_id INTEGER Rename | Drop
commit_id TEXT ✓ Rename | Drop
is_primary INTEGER ✓ Rename | Drop
language TEXT Rename | Drop
size INTEGER Rename | Drop
created_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_language_stat_created_unix created_unix SQL 
CREATE INDEX `IDX_language_stat_created_unix`
ON `language_stat` (`created_unix`)
Drop
IDX_language_stat_language language SQL 
CREATE INDEX `IDX_language_stat_language`
ON `language_stat` (`language`)
Drop
IDX_language_stat_repo_id repo_id SQL 
CREATE INDEX `IDX_language_stat_repo_id`
ON `language_stat` (`repo_id`)
Drop
UQE_language_stat_s
  • repo_id
  • language
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_language_stat_s`
ON `language_stat` (`repo_id`,`language`)
Drop