From 3310a85ac8f276ad270388a4242b623f30abe74d Mon Sep 17 00:00:00 2001 From: Aaron Parecki Date: Sun, 15 Jan 2017 08:07:54 -0800 Subject: store the user's timezone after their location is found --- schema/migrations/0003.sql | 2 ++ schema/mysql.sql | 3 ++- 2 files changed, 4 insertions(+), 1 deletion(-) create mode 100644 schema/migrations/0003.sql (limited to 'schema') 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; -- cgit v1.2.3