--- 
- 
  data: "CREATE TABLE friend (\n  id INTEGER NOT NULL,\n  friend_id INTEGER NOT NULL,\n  status INTEGER NOT NULL DEFAULT 0,\n  created_on TEXT NOT NULL,\n  updated_on TEXT NOT NULL,\n  PRIMARY KEY (id, friend_id)\n)"
  schema: friend
- 
  data: "CREATE TABLE friend_counter (\n  counter INTEGER NOT NULL DEFAULT 0\n)"
  schema: friend_counter
- 
  data: "CREATE TABLE people (\n  id INTEGER PRIMARY KEY NOT NULL,\n  nickname TEXT NOT NULL,\n  status INTEGER NOT NULL DEFAULT 0,\n  created_on TEXT NOT NULL,\n  updated_on TEXT NOT NULL\n)"
  schema: people
- 
  data: "CREATE TABLE people_counter (\n  counter INTEGER NOT NULL DEFAULT 0\n)"
  schema: people_counter
- 
  data: "CREATE TRIGGER on_after_delete_people AFTER DELETE ON people\nFOR EACH ROW BEGIN\n  UPDATE people_counter SET counter = counter - 1;\nEND"
  refer: people
  trigger: on_after_delete_people
- 
  data: "CREATE TRIGGER on_after_insert_people AFTER INSERT ON people\nFOR EACH ROW BEGIN\n  UPDATE people_counter SET counter = counter + 1;\nEND"
  refer: people
  trigger: on_after_insert_people
- 
  data: "CREATE TRIGGER on_after_delete_friend AFTER DELETE ON friend\nFOR EACH ROW BEGIN\n  UPDATE friend_counter SET counter = counter - 1;\nEND"
  refer: friend
  trigger: on_after_delete_friend
- 
  data: "CREATE TRIGGER on_after_insert_friend AFTER INSERT ON friend\nFOR EACH ROW BEGIN\n  UPDATE friend_counter SET counter = counter + 1;\nEND"
  refer: friend
  trigger: on_after_insert_friend
- 
  data: CREATE INDEX idx_people_on_id_and_created_on ON people (id, created_on)
  index: idx_people_on_id_and_created_on
  refer: people
- 
  data: CREATE INDEX idx_people_on_id_and_updated_on ON people (id, updated_on)
  index: idx_people_on_id_and_updated_on
  refer: people
- 
  data: CREATE INDEX idx_people_on_nickname ON people (nickname)
  index: idx_people_on_nickname
  refer: people