SQL

CREATE TABLE `email_hash`  (
  `hash` TEXT PRIMARY KEY NOT NULL,
  `email` TEXT NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
hash TEXT ✓ Rename | Drop
email TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
UQE_email_hash_email email ✓ SQL 
CREATE UNIQUE INDEX `UQE_email_hash_email`
ON `email_hash` (`email`)
Drop
sqlite_autoindex_email_hash_1 hash ✓ SQL
-- no sql found --
 Drop