Query

sqlite.db — user

SQL

CREATE TABLE `user`  (
  `id` text PRIMARY KEY,
  `name` text DEFAULT '' NOT NULL,
  `email` text DEFAULT '' NOT NULL UNIQUE,
  `email_verified` integer DEFAULT false NOT NULL,
  `image` text,
  `created_at` integer NOT NULL,
  `updated_at` integer NOT NULL,
  `is_anonymous` integer DEFAULT true,
  `birthdate` integer,
  `sex` text,
  `exercise_level` integer
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
name TEXT Rename | Drop
email TEXT Rename | Drop
email_verified INTEGER Rename | Drop
image TEXT ✓ Rename | Drop
created_at INTEGER Rename | Drop
updated_at INTEGER Rename | Drop
is_anonymous INTEGER ✓ Rename | Drop
birthdate INTEGER ✓ Rename | Drop
sex TEXT ✓ Rename | Drop
exercise_level INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_user_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_user_2 email ✓ SQL
-- no sql found --
 Drop