4 files changed, 7 insertions, 2 deletions
diff --git a/schema/migrations/0012.sql b/schema/migrations/0012.sql
index 9b1cc90..763ea58 100644
--- a/schema/migrations/0012.sql
+++ b/schema/migrations/0012.sql
@@ -1,2 +1,2 @@
 ALTER TABLE users
-ADD COLUMN `micropub_optin_html_content` tinyint(4) DEFAULT '1';
+ADD COLUMN `weight_unit` VARCHAR(255) DEFAULT 'kg';
diff --git a/schema/migrations/0014.sql b/schema/migrations/0014.sql
new file mode 100644
index 0000000..40b97c1
--- /dev/null
+++ b/schema/migrations/0014.sql
@@ -0,0 +1,3 @@
+ALTER TABLE users
+ADD COLUMN `micropub_optin_html_content` tinyint(4) DEFAULT '1';
+
diff --git a/schema/mysql.sql b/schema/mysql.sql
index d262c77..3d2b45e 100644
--- a/schema/mysql.sql
+++ b/schema/mysql.sql
@@ -26,5 +26,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 107c9a9..3283960 100644
--- a/schema/sqlite.sql
+++ b/schema/sqlite.sql
@@ -25,5 +25,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'
 );