Query

mira.db — events

SQL

CREATE TABLE events  (
  id          TEXT PRIMARY KEY,
  name        TEXT NOT NULL,
  type        TEXT NOT NULL DEFAULT 'training',
  date        TEXT NOT NULL,
  time_start  TEXT NOT NULL,
  time_end    TEXT NOT NULL,
  location    TEXT NOT NULL,
  description TEXT,
  created_at  INTEGER NOT NULL DEFAULT (unixepoch())
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
name TEXT Rename | Drop
type TEXT Rename | Drop
date TEXT Rename | Drop
time_start TEXT Rename | Drop
time_end TEXT Rename | Drop
location TEXT Rename | Drop
description TEXT ✓ Rename | Drop
created_at INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_events_date
  • date
  • time_start
 SQL 
CREATE INDEX idx_events_date
ON events(date, time_start)
Drop
sqlite_autoindex_events_1 id ✓ SQL
-- no sql found --
 Drop