1 | # frozen_string_literal: true |
||
2 | |||
3 | # Migration to create users table |
||
4 | # Users are linked to Alexa users via Account Linking |
||
5 | View Code Duplication | class CreateUsers < ActiveRecord::Migration[5.1] |
|
0 ignored issues
–
show
Duplication
introduced
by
Loading history...
|
|||
6 | def change |
||
7 | create_table :users, comment: 'Users table' do |t| |
||
8 | t.string :username, null: false |
||
9 | t.string :firstname, null: true |
||
10 | t.string :lastname, null: true |
||
11 | t.text :access_token, null: false, default: '' |
||
12 | t.jsonb :preferences, null: false, default: '{}' |
||
13 | t.timestamps null: false, default: -> { 'CURRENT_TIMESTAMP' } |
||
14 | end |
||
15 | |||
16 | add_indexes_and_keys |
||
17 | end |
||
18 | |||
19 | def add_indexes_and_keys |
||
20 | add_index :users, :preferences, using: :gin, name: 'preferences' |
||
21 | add_index :users, :username, unique: true, name: 'username' |
||
22 | end |
||
23 | end |
||
24 |