SQL

CREATE TABLE profile_modules  (
  profile_id INTEGER NOT NULL REFERENCES user_profiles(id) ON DELETE CASCADE,
  module_key TEXT NOT NULL,
  can_write INTEGER NOT NULL DEFAULT 0,
  PRIMARY KEY (profile_id, module_key)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
profile_id INTEGER ✓ Rename | Drop
module_key TEXT ✓ Rename | Drop
can_write INTEGER Rename | Drop

Foreign Keys

Column Destination
profile_id user_profiles.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_profile_modules_1
  • profile_id
  • module_key
 ✓ SQL
-- no sql found --
 Drop