Query

auth.db — users

SQL

CREATE TABLE `users`  (
  `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  `external_subject` text NOT NULL,
  `email` text,
  `username` text,
  `first_name` text,
  `last_name` text,
  `display_name` text,
  `groups_json` text DEFAULT '[]' NOT NULL,
  `roles_json` text DEFAULT '[]' NOT NULL,
  `created_at` text NOT NULL,
  `updated_at` text NOT NULL,
  `last_login_at` text NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
external_subject TEXT Rename | Drop
email TEXT ✓ Rename | Drop
username TEXT ✓ Rename | Drop
first_name TEXT ✓ Rename | Drop
last_name TEXT ✓ Rename | Drop
display_name TEXT ✓ Rename | Drop
groups_json TEXT Rename | Drop
roles_json TEXT Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop
last_login_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_users_display_name display_name SQL 
CREATE INDEX `idx_users_display_name`
ON `users` (`display_name`)
Drop
idx_users_email email SQL 
CREATE INDEX `idx_users_email`
ON `users` (`email`)
Drop
idx_users_external_subject external_subject SQL 
CREATE INDEX `idx_users_external_subject`
ON `users` (`external_subject`)
Drop
idx_users_first_name first_name SQL 
CREATE INDEX `idx_users_first_name`
ON `users` (`first_name`)
Drop
idx_users_last_name last_name SQL 
CREATE INDEX `idx_users_last_name`
ON `users` (`last_name`)
Drop
idx_users_username username SQL 
CREATE INDEX `idx_users_username`
ON `users` (`username`)
Drop
users_external_subject_unique external_subject ✓ SQL 
CREATE UNIQUE INDEX `users_external_subject_unique`
ON `users` (`external_subject`)
Drop