Query

cards.db — users

SQL

CREATE TABLE users  (
  id TEXT PRIMARY KEY,
  email TEXT UNIQUE NOT NULL,
  password_hash TEXT NOT NULL,
  organisation_id TEXT,
  role TEXT DEFAULT 'member',
  email_verified INTEGER DEFAULT 0,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (organisation_id) REFERENCES organisations(id) ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
email TEXT Rename | Drop
password_hash TEXT Rename | Drop
organisation_id TEXT ✓ Rename | Drop
role TEXT ✓ Rename | Drop
email_verified INTEGER ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
organisation_id organisations.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_users_email email SQL 
CREATE INDEX idx_users_email
ON users(email)
Drop
idx_users_organisation_id organisation_id SQL 
CREATE INDEX idx_users_organisation_id
ON users(organisation_id)
Drop
sqlite_autoindex_users_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_users_2 email ✓ SQL
-- no sql found --
 Drop