Query

cards.db — cards

SQL

CREATE TABLE cards  (
  slug TEXT NOT NULL,
  user_id TEXT NOT NULL,
  short_code TEXT NOT NULL,
  data TEXT NOT NULL,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (slug, user_id),
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
slug TEXT ✓ Rename | Drop
user_id TEXT ✓ Rename | Drop
short_code TEXT Rename | Drop
data TEXT Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
user_id users.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_cards_short_code short_code ✓ SQL 
CREATE UNIQUE INDEX idx_cards_short_code
ON cards(short_code)
Drop
idx_cards_slug slug SQL 
CREATE INDEX idx_cards_slug
ON cards(slug)
Drop
idx_cards_user_id user_id SQL 
CREATE INDEX idx_cards_user_id
ON cards(user_id)
Drop
sqlite_autoindex_cards_1
  • slug
  • user_id
 ✓ SQL
-- no sql found --
 Drop