S0pCW5Gn

1PRAGMA foreign_keys = ON;
2
3DROP TABLE IF EXISTS category;
4CREATE TABLE category (
5  id INTEGER PRIMARY KEY,
6  name TEXT NOT NULL,
7  favorite BOOLEAN DEFAULT 0 NOT NULL,
8  parent_category INTEGER,
9  path TEXT NOT NULL,
10  FOREIGN KEY (parent_category) REFERENCES category(id) ON UPDATE CASCADE ON DELETE CASCADE,
11  CHECK(favorite in (0, 1))
12);
13
14DROP TABLE IF EXISTS item;
15CREATE TABLE item (
16  id INTEGER PRIMARY KEY,
17  name TEXT NOT NULL,
18  description TEXT,
19  favorite BOOLEAN DEFAULT 0 NOT NULL,
20  parent_category INTEGER,
21  FOREIGN KEY (parent_category) REFERENCES category(id) ON UPDATE CASCADE ON DELETE CASCADE,
22  CHECK(favorite in (0, 1))
23);
24
25DROP TABLE IF EXISTS config;
26CREATE TABLE config (
27  k TEXT PRIMARY KEY,
28  v TEXT NOT NULL
29);
30
31INSERT INTO category (id, name, path) VALUES (1,'Respostas rápidas', '1');
32INSERT INTO category (id, name, path) VALUES (2,'Necessidades', '2');
33INSERT INTO category (id, name, path) VALUES (3,'Dores e Sintomas', '3');
34INSERT INTO category (id, name, path) VALUES (4,'Sentimentos', '4');
35INSERT INTO category (id, name, path) VALUES (5,'Pessoas', '5');
36INSERT INTO category (id, name, path) VALUES (6,'Objetos', '6');
37
38INSERT INTO item (name, description, favorite, parent_category) VALUES ('Sim', 'Sim', 0, 1);
39INSERT INTO item (name, description, favorite, parent_category) VALUES ('Não', 'Não', 0, 1);
40INSERT INTO item (name, description, favorite, parent_category) VALUES ('Talvez', 'Talvez', 0, 1);
41INSERT INTO item (name, description, favorite, parent_category) VALUES ('Não sei', 'Não sei', 0, 1);
42
43INSERT INTO item (name, description, favorite, parent_category) VALUES ('Fome', 'Tenho fome', 0, 2);
44INSERT INTO item (name, description, favorite, parent_category) VALUES ('Sede', 'Tenho sede', 0, 2);
45INSERT INTO item (name, description, favorite, parent_category) VALUES ('WC', 'Preciso de ir à casa de banho', 0, 2);
46INSERT INTO item (name, description, favorite, parent_category) VALUES ('Abraço', 'Quero um abraço', 0, 2);
47
48INSERT INTO item (name, description, favorite, parent_category) VALUES ('Dor de costas', 'Doi-me as costas', 0, 3);
49INSERT INTO item (name, description, favorite, parent_category) VALUES ('Dor de cabeça', 'Doi-me a cabeça', 0, 3);
50INSERT INTO item (name, description, favorite, parent_category) VALUES ('Dor de barriga', 'Doi-me a barriga', 0, 3);
51INSERT INTO item (name, description, favorite, parent_category) VALUES ('Ardor de olhos', 'Estão-me a arder os olhos', 0, 3);
52INSERT INTO item (name, description, favorite, parent_category) VALUES ('Não tenho fome', 'Não tenho fome', 0, 3);
53
54INSERT INTO item (name, description, favorite, parent_category) VALUES ('Contente', 'Estou contente', 0, 4);
55INSERT INTO item (name, description, favorite, parent_category) VALUES ('Triste', 'Estou triste', 0, 4);
56INSERT INTO item (name, description, favorite, parent_category) VALUES ('Medo', 'Estou com medo', 0, 4);
57INSERT INTO item (name, description, favorite, parent_category) VALUES ('Zangado', 'Estou zangado', 0, 4);
58INSERT INTO item (name, description, favorite, parent_category) VALUES ('Surpreendido', 'Estou surpreendido', 0, 4);
59INSERT INTO item (name, description, favorite, parent_category) VALUES ('Vergonha', 'Estou com vergonha', 0, 4);
60INSERT INTO item (name, description, favorite, parent_category) VALUES ('Inveja', 'Estou com inveja', 0, 4);
61
62INSERT INTO item (name, description, favorite, parent_category) VALUES ('Pai', 'Pai', 0, 5);
63INSERT INTO item (name, description, favorite, parent_category) VALUES ('Mae', 'Mae', 0, 5);
64INSERT INTO item (name, description, favorite, parent_category) VALUES ('Avó', 'Avó', 0, 5);
65INSERT INTO item (name, description, favorite, parent_category) VALUES ('Avô', 'Avô', 0, 5);
66INSERT INTO item (name, description, favorite, parent_category) VALUES ('Irmã', 'Irmã', 0, 5);
67INSERT INTO item (name, description, favorite, parent_category) VALUES ('Irmão', 'Irmão', 0, 5);
68
69INSERT INTO item (name, description, favorite, parent_category) VALUES ('Bola', 'Bola', 0, 6);
70INSERT INTO item (name, description, favorite, parent_category) VALUES ('Urso de peluche', 'Urso de peluche', 0, 6);
71INSERT INTO item (name, description, favorite, parent_category) VALUES ('Boneca', 'Boneca', 0, 6);
72
73
74INSERT INTO config(k, v) VALUES ("showCardText", "false");
75INSERT INTO config(k, v) VALUES ("firstStart", "true");