summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAaron Parecki <aaron@parecki.com>2017-01-04 15:26:51 -0800
committerAaron Parecki <aaron@parecki.com>2017-01-04 15:26:51 -0800
commitacafb9192a6402a3f3d60d5e6af11cb4576fc96c (patch)
treed70737a0ee528cff04673ff6b66a1667fbd302bf /schema
parente7fe68f73e441778f80683383ddb2ffe7a48f85c (diff)
add tags, slug and status field to quill editor
Diffstat (limited to 'schema')
-rw-r--r--schema/migrations/0002.sql5
-rw-r--r--schema/mysql.sql1
-rw-r--r--schema/sqlite.sql2
3 files changed, 8 insertions, 0 deletions
diff --git a/schema/migrations/0002.sql b/schema/migrations/0002.sql
new file mode 100644
index 0000000..60d591a
--- /dev/null
+++ b/schema/migrations/0002.sql
@@ -0,0 +1,5 @@
+ALTER TABLE users
+ADD COLUMN `micropub_slug_field` VARCHAR(255) NOT NULL DEFAULT 'mp-slug' AFTER `micropub_response`;
+
+UPDATE users
+SET micropub_slug_field = 'slug';
diff --git a/schema/mysql.sql b/schema/mysql.sql
index 8eccb3a..610b01b 100644
--- a/schema/mysql.sql
+++ b/schema/mysql.sql
@@ -8,6 +8,7 @@ CREATE TABLE `users` (
`micropub_access_token` text,
`micropub_scope` varchar(255) DEFAULT NULL,
`micropub_response` text,
+ `micropub_slug_field` varchar(255) NOT NULL DEFAULT 'mp-slug',
`micropub_success` tinyint(4) DEFAULT '0',
`date_created` datetime DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
diff --git a/schema/sqlite.sql b/schema/sqlite.sql
index 9f05c1e..3dc6e91 100644
--- a/schema/sqlite.sql
+++ b/schema/sqlite.sql
@@ -4,9 +4,11 @@ CREATE TABLE users (
authorization_endpoint TEXT,
token_endpoint TEXT,
micropub_endpoint TEXT,
+ micropub_media_endpoint TEXT,
micropub_access_token TEXT,
micropub_scope TEXT,
micropub_response TEXT,
+ micropub_slug_field TEXT default 'mp-slug',
micropub_success INTEGER default 0,
date_created datetime,
last_login datetime,