SQL

CREATE TABLE `topic`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `name` TEXT NULL,
  `repo_count` INTEGER NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
name TEXT ✓ Rename | Drop
repo_count INTEGER ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_topic_created_unix created_unix SQL 
CREATE INDEX `IDX_topic_created_unix`
ON `topic` (`created_unix`)
Drop
IDX_topic_updated_unix updated_unix SQL 
CREATE INDEX `IDX_topic_updated_unix`
ON `topic` (`updated_unix`)
Drop
UQE_topic_name name ✓ SQL 
CREATE UNIQUE INDEX `UQE_topic_name`
ON `topic` (`name`)
Drop