diff options
| author | Aaron Parecki <aaron@parecki.com> | 2017-01-17 09:24:41 -0800 |
|---|---|---|
| committer | Aaron Parecki <aaron@parecki.com> | 2017-01-17 09:24:41 -0800 |
| commit | 0e8ee9973a550a3ab0a2069d9a12b683651b7d9b (patch) | |
| tree | a6f5449d8dd09e815ad659396a1aaa350354215e /schema | |
| parent | 3bdcd009c8817df5275041d5c4d72c716d660456 (diff) | |
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
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/migrations/0004.sql | 5 | ||||
| -rw-r--r-- | schema/mysql.sql | 1 | ||||
| -rw-r--r-- | schema/sqlite.sql | 1 |
3 files changed, 7 insertions, 0 deletions
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, |