SQL

CREATE TABLE `email_address`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `uid` INTEGER NOT NULL,
  `email` TEXT NOT NULL,
  `lower_email` TEXT NOT NULL,
  `is_activated` INTEGER NULL,
  `is_primary` INTEGER DEFAULT 0 NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
uid INTEGER Rename | Drop
email TEXT Rename | Drop
lower_email TEXT Rename | Drop
is_activated INTEGER ✓ Rename | Drop
is_primary INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_email_address_uid uid SQL 
CREATE INDEX `IDX_email_address_uid`
ON `email_address` (`uid`)
Drop
UQE_email_address_email email ✓ SQL 
CREATE UNIQUE INDEX `UQE_email_address_email`
ON `email_address` (`email`)
Drop
UQE_email_address_lower_email lower_email ✓ SQL 
CREATE UNIQUE INDEX `UQE_email_address_lower_email`
ON `email_address` (`lower_email`)
Drop