SQL

CREATE TABLE `user_open_id`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `uid` INTEGER NOT NULL,
  `uri` TEXT NOT NULL,
  `show` INTEGER DEFAULT 0 NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
uid INTEGER Rename | Drop
uri TEXT Rename | Drop
show INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_user_open_id_uid uid SQL 
CREATE INDEX `IDX_user_open_id_uid`
ON `user_open_id` (`uid`)
Drop
UQE_user_open_id_uri uri ✓ SQL 
CREATE UNIQUE INDEX `UQE_user_open_id_uri`
ON `user_open_id` (`uri`)
Drop