SQL

CREATE TABLE `repo_topic`  (
  `repo_id` INTEGER NOT NULL,
  `topic_id` INTEGER NOT NULL,
  PRIMARY KEY (`repo_id`,`topic_id`)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
repo_id INTEGER Rename | Drop
topic_id INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_repo_topic_1
  • repo_id
  • topic_id
SQL
-- no sql found --
Drop