From 0e8ee9973a550a3ab0a2069d9a12b683651b7d9b Mon Sep 17 00:00:00 2001
From: Aaron Parecki <aaron@parecki.com>
Date: Tue, 17 Jan 2017 09:24:41 -0800
Subject: use `mp-syndicate-to` by default, add setting

* adds setting to choose the property to use for the syndication targets
* all existing users default to the old value `syndicate-to`
* new users default to `mp-syndicate-to`

closes #66
---
 schema/migrations/0004.sql | 5 +++++
 schema/mysql.sql           | 1 +
 schema/sqlite.sql          | 1 +
 3 files changed, 7 insertions(+)
 create mode 100644 schema/migrations/0004.sql

(limited to 'schema')

diff --git a/schema/migrations/0004.sql b/schema/migrations/0004.sql
new file mode 100644
index 0000000..8b74018
--- /dev/null
+++ b/schema/migrations/0004.sql
@@ -0,0 +1,5 @@
+ALTER TABLE users
+ADD COLUMN `micropub_syndicate_field` VARCHAR(255) NOT NULL DEFAULT 'mp-syndicate-to' AFTER `micropub_slug_field`;
+
+UPDATE users
+SET micropub_syndicate_field = 'syndicate-to';
diff --git a/schema/mysql.sql b/schema/mysql.sql
index 31f10fd..9796b5d 100644
--- a/schema/mysql.sql
+++ b/schema/mysql.sql
@@ -9,6 +9,7 @@ CREATE TABLE `users` (
   `micropub_scope` varchar(255) DEFAULT NULL,
   `micropub_response` text,
   `micropub_slug_field` varchar(255) NOT NULL DEFAULT 'mp-slug',
+  `micropub_syndicate_field` varchar(255) NOT NULL DEFAULT 'mp-syndicate-to',
   `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 1dced77..00e5f1c 100644
--- a/schema/sqlite.sql
+++ b/schema/sqlite.sql
@@ -9,6 +9,7 @@ CREATE TABLE users (
   micropub_scope TEXT,
   micropub_response TEXT,
   micropub_slug_field TEXT default 'mp-slug',
+  micropub_syndicate_field TEXT default 'mp-syndicate-to',
   micropub_success INTEGER default 0,
   date_created datetime,
   last_login datetime,
-- 
cgit v1.2.3