diff options
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/migrations/0011.sql | 2 | ||||
| -rw-r--r-- | schema/mysql.sql | 1 | ||||
| -rw-r--r-- | schema/sqlite.sql | 3 |
3 files changed, 5 insertions, 1 deletions
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' ); |