diff options
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/migrations/0002.sql | 5 | ||||
| -rw-r--r-- | schema/mysql.sql | 1 | ||||
| -rw-r--r-- | schema/sqlite.sql | 2 |
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, |