From d6e03455453e83768b53dc23379680f6ef83abca Mon Sep 17 00:00:00 2001 From: Martijn van der Ven Date: Sun, 20 Oct 2019 09:30:33 +0200 Subject: Add new weight posting interface --- schema/migrations/0011.sql | 2 ++ schema/mysql.sql | 1 + schema/sqlite.sql | 3 ++- 3 files changed, 5 insertions(+), 1 deletion(-) create mode 100644 schema/migrations/0011.sql (limited to 'schema') diff --git a/schema/migrations/0011.sql b/schema/migrations/0011.sql new file mode 100644 index 0000000..763ea58 --- /dev/null +++ b/schema/migrations/0011.sql @@ -0,0 +1,2 @@ +ALTER TABLE users +ADD COLUMN `weight_unit` VARCHAR(255) DEFAULT 'kg'; diff --git a/schema/mysql.sql b/schema/mysql.sql index 5a91e55..4ee94b0 100644 --- a/schema/mysql.sql +++ b/schema/mysql.sql @@ -24,5 +24,6 @@ CREATE TABLE `users` ( `default_timezone` varchar(255) DEFAULT NULL, `supported_post_types` longtext, `supported_visibility` longtext, + `weight_unit` varchar(255) DEFAULT 'kg', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/schema/sqlite.sql b/schema/sqlite.sql index ca495cd..7f73dd8 100644 --- a/schema/sqlite.sql +++ b/schema/sqlite.sql @@ -23,5 +23,6 @@ CREATE TABLE users ( email_username TEXT, default_timezone TEXT, supported_post_types TEXT, - supported_visibility TEXT + supported_visibility TEXT, + weight_unit TEXT default 'kg' ); -- cgit v1.2.3