From 5928afc3bf83661cd3b11130a31a2d97ef135a9e Mon Sep 17 00:00:00 2001 From: Jokler Date: Sat, 4 Nov 2017 22:46:39 +0100 Subject: Add MySql as a possible database for the Factoids plugin --- migrations/2017-11-03-164322_create_factoids/down.sql | 1 + migrations/2017-11-03-164322_create_factoids/up.sql | 4 ++++ 2 files changed, 5 insertions(+) create mode 100644 migrations/2017-11-03-164322_create_factoids/down.sql create mode 100644 migrations/2017-11-03-164322_create_factoids/up.sql (limited to 'migrations/2017-11-03-164322_create_factoids') 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 +) -- cgit v1.2.3-70-g09d2