1---
2-
3  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)"
4  schema: friend
5-
6  data: "CREATE TABLE friend_counter (\n  counter INTEGER NOT NULL DEFAULT 0\n)"
7  schema: friend_counter
8-
9  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)"
10  schema: people
11-
12  data: "CREATE TABLE people_counter (\n  counter INTEGER NOT NULL DEFAULT 0\n)"
13  schema: people_counter
14-
15  data: "CREATE TRIGGER on_after_delete_people AFTER DELETE ON people\nFOR EACH ROW BEGIN\n  UPDATE people_counter SET counter = counter - 1;\nEND"
16  refer: people
17  trigger: on_after_delete_people
18-
19  data: "CREATE TRIGGER on_after_insert_people AFTER INSERT ON people\nFOR EACH ROW BEGIN\n  UPDATE people_counter SET counter = counter + 1;\nEND"
20  refer: people
21  trigger: on_after_insert_people
22-
23  data: "CREATE TRIGGER on_after_delete_friend AFTER DELETE ON friend\nFOR EACH ROW BEGIN\n  UPDATE friend_counter SET counter = counter - 1;\nEND"
24  refer: friend
25  trigger: on_after_delete_friend
26-
27  data: "CREATE TRIGGER on_after_insert_friend AFTER INSERT ON friend\nFOR EACH ROW BEGIN\n  UPDATE friend_counter SET counter = counter + 1;\nEND"
28  refer: friend
29  trigger: on_after_insert_friend
30-
31  data: CREATE INDEX idx_people_on_id_and_created_on ON people (id, created_on)
32  index: idx_people_on_id_and_created_on
33  refer: people
34-
35  data: CREATE INDEX idx_people_on_id_and_updated_on ON people (id, updated_on)
36  index: idx_people_on_id_and_updated_on
37  refer: people
38-
39  data: CREATE INDEX idx_people_on_nickname ON people (nickname)
40  index: idx_people_on_nickname
41  refer: people
42