summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAaron Parecki <aaron@parecki.com>2017-01-15 08:07:54 -0800
committerAaron Parecki <aaron@parecki.com>2017-01-15 08:07:54 -0800
commit3310a85ac8f276ad270388a4242b623f30abe74d (patch)
tree8e9da2a1861432e361bb5ac2dc5245015b8c11f1 /schema
parentfa06932a9c1bb289cae6cbaa046c6b9c07bf5b1a (diff)
store the user's timezone after their location is found
Diffstat (limited to 'schema')
-rw-r--r--schema/migrations/0003.sql2
-rw-r--r--schema/mysql.sql3
2 files changed, 4 insertions, 1 deletions
diff --git a/schema/migrations/0003.sql b/schema/migrations/0003.sql
new file mode 100644
index 0000000..43b72f7
--- /dev/null
+++ b/schema/migrations/0003.sql
@@ -0,0 +1,2 @@
+ALTER TABLE users
+ADD COLUMN `default_timezone` VARCHAR(255);
diff --git a/schema/mysql.sql b/schema/mysql.sql
index 610b01b..31f10fd 100644
--- a/schema/mysql.sql
+++ b/schema/mysql.sql
@@ -21,6 +21,7 @@ CREATE TABLE `users` (
`twitter_token_secret` text,
`twitter_username` varchar(255) DEFAULT NULL,
`instagram_access_token` text,
- `email_username` varchar(255) DEFAULT NULL,
+ `email_username` vacrchar(255) DEFAULT NULL,
+ `default_timezone` vacrchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;