SQL

CREATE TABLE `org_user`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `uid` INTEGER NULL,
  `org_id` INTEGER NULL,
  `is_public` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
uid INTEGER ✓ Rename | Drop
org_id INTEGER ✓ Rename | Drop
is_public INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_org_user_is_public is_public SQL 
CREATE INDEX `IDX_org_user_is_public`
ON `org_user` (`is_public`)
Drop
IDX_org_user_org_id org_id SQL 
CREATE INDEX `IDX_org_user_org_id`
ON `org_user` (`org_id`)
Drop
IDX_org_user_uid uid SQL 
CREATE INDEX `IDX_org_user_uid`
ON `org_user` (`uid`)
Drop
UQE_org_user_s
  • uid
  • org_id
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_org_user_s`
ON `org_user` (`uid`,`org_id`)
Drop