register_end_query.md

INSERT INTO user_login_history 
            ( 
                        remote_address, 
                        user_agent, 
                        latitude, 
                        longitude, 
                        login_at, 
                        user_identifier 
            ) 
            VALUES 
            ( 
                        '0:0:0:0:0:0:0:1', 
                        'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36',
                        0.0, 
                        0.0, 
                        2015-10-06 15:49:16.7, 
                        'Ej5LDP2O7v7oobVrhLqYvFNsF2pgCbGJ' 
            )

UPDATE USER 
SET    login_id='watanabe0621+3@gmail.com', 
       login_password='d17f25ecfbcc7857f7bebea469308be0b2580943e96d13a3ad98a13675c4bfc2', 
       email='watanabe0621+3@gmail.com', 
       status=0, 
       last_remote_address='0:0:0:0:0:0:0:1', 
       last_user_agent='Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36',
       last_login_at=2015-10-06 15:49:16.733, 
       latitude=0.0, 
       longitude=0.0, 
       updated_at=2015-10-06 15:49:16.754 
WHERE  user_identifier='Ej5LDP2O7v7oobVrhLqYvFNsF2pgCbGJ'

Issue:

• login historyは使っている？すごい大きなテーブルになりそう。