From 4b5693d3c6781a5ca4ef32f43f3994a65020c933 Mon Sep 17 00:00:00 2001
From: Jokler <jokler.contact@gmail.com>
Date: Sat, 16 Dec 2017 18:13:02 +0100
Subject: Add more info to factoids and save old versions

---
 migrations/.gitkeep                                 | 0
 migrations/2017-11-03-164322_create_factoids/up.sql | 8 ++++++--
 2 files changed, 6 insertions(+), 2 deletions(-)
 delete mode 100644 migrations/.gitkeep

(limited to 'migrations')

diff --git a/migrations/.gitkeep b/migrations/.gitkeep
deleted file mode 100644
index e69de29..0000000
diff --git a/migrations/2017-11-03-164322_create_factoids/up.sql b/migrations/2017-11-03-164322_create_factoids/up.sql
index 84e9f9d..784a3f4 100644
--- a/migrations/2017-11-03-164322_create_factoids/up.sql
+++ b/migrations/2017-11-03-164322_create_factoids/up.sql
@@ -1,4 +1,8 @@
 CREATE TABLE factoids (
-    name VARCHAR(32) PRIMARY KEY,
-    content VARCHAR(5000) NOT NULL
+    name VARCHAR(32) NOT NULL,
+    idx INTEGER NOT NULL,
+    content TEXT NOT NULL,
+    author VARCHAR(32) NOT NULL,
+    created TIMESTAMP NOT NULL,
+    PRIMARY KEY (name, idx)
 )
-- 
cgit v1.2.3-70-g09d2