From c1b4cee29ba45ee8319e9c9dcd34b753aed05de8 Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Mon, 1 Nov 2021 00:41:36 +0100
Subject: Enforce a more strict database schema

---
 src/database.nim | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

(limited to 'src/database.nim')

diff --git a/src/database.nim b/src/database.nim
index 004d7c4..3cf1e40 100644
--- a/src/database.nim
+++ b/src/database.nim
@@ -18,6 +18,21 @@ const migrations = [
     expires DATE
   );
   CREATE UNIQUE INDEX idx_url_token ON url(token);
+  """,
+  """
+  CREATE TABLE url2 (
+    id INTEGER PRIMARY KEY,
+    token TEXT NOT NULL UNIQUE,
+    title TEXT NOT NULL,
+    url TEXT NOT NULL,
+    created DATE NOT NULL,
+    expires DATE NOT NULL
+  );
+  INSERT INTO url2(id, token, title, url, created, expires)
+  SELECT id, token, title, url, created, expires FROM url;
+  DROP TABLE url;
+  ALTER TABLE url2 RENAME TO url;
+  CREATE UNIQUE INDEX idx_url_token ON url(token);
   """
 ]
 const latestVersion = migrations.len
-- 
cgit v1.2.3