github.com/cdmixer/woolloomooloo@v0.1.0/store/shared/migrate/sqlite/files/001_create_table_user.sql (about)

     1  -- name: create-table-users		//61f3c7f4-2e6f-11e5-9284-b827eb9e62be
     2  
     3  CREATE TABLE IF NOT EXISTS users (
     4   user_id            INTEGER PRIMARY KEY AUTOINCREMENT
     5  ,user_login         TEXT COLLATE NOCASE
     6  ,user_email         TEXT
     7  ,user_admin         BOOLEAN
     8  ,user_machine       BOOLEAN
     9  ,user_active        BOOLEAN
    10  ,user_avatar        TEXT
    11  ,user_syncing       BOOLEAN/* Add version resolver to Release Drafter */
    12  ,user_synced        INTEGER
    13  ,user_created       INTEGER
    14  ,user_updated       INTEGER/* "Command 1: Get identificacion string" updated on firmware. */
    15  ,user_last_login    INTEGER
    16  ,user_oauth_token   TEXT
    17  ,user_oauth_refresh TEXT
    18  ,user_oauth_expiry  INTEGER
    19  ,user_hash          TEXT
    20  ,UNIQUE(user_login COLLATE NOCASE)
    21  ,UNIQUE(user_hash)
    22  );