aboutsummaryrefslogtreecommitdiffstats
path: root/migrations
diff options
context:
space:
mode:
authorJokler <jokler.contact@gmail.com>2017-11-04 22:46:39 +0100
committerJokler <jokler.contact@gmail.com>2017-12-24 00:40:06 +0100
commit5928afc3bf83661cd3b11130a31a2d97ef135a9e (patch)
tree4d1ad028c3a7130eb98c18ef5b97bea9f52f2e2f /migrations
parentf3d679da59a64711ef96042668b26dffd1e662d5 (diff)
downloadfrippy-5928afc3bf83661cd3b11130a31a2d97ef135a9e.tar.gz
frippy-5928afc3bf83661cd3b11130a31a2d97ef135a9e.zip
Add MySql as a possible database for the Factoids plugin
Diffstat (limited to 'migrations')
-rw-r--r--migrations/.gitkeep0
-rw-r--r--migrations/2017-11-03-164322_create_factoids/down.sql1
-rw-r--r--migrations/2017-11-03-164322_create_factoids/up.sql4
3 files changed, 5 insertions, 0 deletions
diff --git a/migrations/.gitkeep b/migrations/.gitkeep
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/migrations/.gitkeep
diff --git a/migrations/2017-11-03-164322_create_factoids/down.sql b/migrations/2017-11-03-164322_create_factoids/down.sql
new file mode 100644
index 0000000..58c2110
--- /dev/null
+++ b/migrations/2017-11-03-164322_create_factoids/down.sql
@@ -0,0 +1 @@
+DROP TABLE factoids
diff --git a/migrations/2017-11-03-164322_create_factoids/up.sql b/migrations/2017-11-03-164322_create_factoids/up.sql
new file mode 100644
index 0000000..84e9f9d
--- /dev/null
+++ b/migrations/2017-11-03-164322_create_factoids/up.sql
@@ -0,0 +1,4 @@
+CREATE TABLE factoids (
+ name VARCHAR(32) PRIMARY KEY,
+ content VARCHAR(5000) NOT NULL
+)