aboutsummaryrefslogtreecommitdiff
path: root/migrations/2021-05-03-213030_create_user_registration/up.sql
blob: dc6d9dbf59910804e35fb6514ddc23a5e4a3074f (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
CREATE TABLE user_registration (
  user_name_lower TEXT NOT NULL,
  user_name TEXT NOT NULL PRIMARY KEY,
  serial_number TEXT NOT NULL,
  password TEXT NOT NULL,
  client_version TEXT NOT NULL,
  account_status INTEGER NOT NULL,
  registration_date TEXT NOT NULL,
  times_on INTEGER NOT NULL,
  total_minutes INTEGER NOT NULL,
  user_privileges INTEGER NOT NULL
)