Merge branch 'Zegnat-add-weight-posts'

3 files changed, 5 insertions, 1 deletions

diff --git a/schema/migrations/0012.sql b/schema/migrations/0012.sql
new file mode 100644
index 0000000..763ea58
--- /dev/null
+++ b/schema/migrations/0012.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 0a0accb..d6210d9 100644
--- a/schema/mysql.sql
+++ b/schema/mysql.sql
@@ -25,5 +25,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 dd041b3..310b2ae 100644
--- a/schema/sqlite.sql
+++ b/schema/sqlite.sql
@@ -24,5 +24,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'
 );