diff options
| author | Joris | 2022-04-23 16:27:00 +0200 |
|---|---|---|
| committer | Joris | 2022-04-23 16:27:00 +0200 |
| commit | 6d271b09303d924381cc65e7c0b5eb56833780ed (patch) | |
| tree | 7f6f2899efacab3e444ff80a32ea26da094d5f54 /src/db/migrations/2-categories.sql | |
| parent | 65fd0cb7c8b996cb43b6766feebe8fe84f836919 (diff) | |
| download | calendar-6d271b09303d924381cc65e7c0b5eb56833780ed.tar.gz calendar-6d271b09303d924381cc65e7c0b5eb56833780ed.tar.bz2 calendar-6d271b09303d924381cc65e7c0b5eb56833780ed.zip | |
Create categories table
Diffstat (limited to 'src/db/migrations/2-categories.sql')
| -rw-r--r-- | src/db/migrations/2-categories.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/src/db/migrations/2-categories.sql b/src/db/migrations/2-categories.sql new file mode 100644 index 0000000..27e9699 --- /dev/null +++ b/src/db/migrations/2-categories.sql @@ -0,0 +1,13 @@ +CREATE TABLE IF NOT EXISTS "categories" ( + "id" TEXT PRIMARY KEY, /* UUID */ + "name" TEXT NOT NULL, + "color" TEXT NOT NULL, /* HEXA */ + "created" TEXT NOT NULL, /* DATETIME */ + "updated" TEXT NOT NULL /* DATETIME */ +); + +INSERT INTO + "categories" ("id", "name", "color", "created", "updated") + VALUES ("b2253284-1572-43d5-96ec-bf6ad448f46a", "Perso", "#a8c2e0", datetime(), datetime()); + +ALTER TABLE "events" ADD COLUMN "category" TEXT REFERENCES "categories" ("id"); /* UUID */ |