From 52685dfaa581e6cfceabaa7b254508d765a06efa Mon Sep 17 00:00:00 2001 From: Fuwn Date: Thu, 20 May 2021 14:37:59 -0700 Subject: style(migrations): fix sql linting errors --- .../2021-05-03-213012_create_serial_numbers/up.sql | 6 +++--- .../up.sql | 20 ++++++++++---------- .../2021-05-03-213037_create_user_properties/up.sql | 12 ++++++------ 3 files changed, 19 insertions(+), 19 deletions(-) (limited to 'migrations') diff --git a/migrations/2021-05-03-213012_create_serial_numbers/up.sql b/migrations/2021-05-03-213012_create_serial_numbers/up.sql index eb626d8..bd3b1b8 100644 --- a/migrations/2021-05-03-213012_create_serial_numbers/up.sql +++ b/migrations/2021-05-03-213012_create_serial_numbers/up.sql @@ -1,5 +1,5 @@ CREATE TABLE serial_numbers ( - serial_number TEXT NOT NULL UNIQUE, - user_name TEXT NOT NULL PRIMARY KEY , - serial_status INTEGER NOT NULL + serial_number TEXT NOT NULL UNIQUE, + user_name TEXT NOT NULL PRIMARY KEY, + serial_status INTEGER NOT NULL ) diff --git a/migrations/2021-05-03-213030_create_user_registration/up.sql b/migrations/2021-05-03-213030_create_user_registration/up.sql index dc6d9db..21076ff 100644 --- a/migrations/2021-05-03-213030_create_user_registration/up.sql +++ b/migrations/2021-05-03-213030_create_user_registration/up.sql @@ -1,12 +1,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 + user_name_lower TEXT NOT NULL, + user_name TEXT NOT NULL PRIMARY KEY, + serial_number TEXT NOT NULL, + pass_wordword 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 ) diff --git a/migrations/2021-05-03-213037_create_user_properties/up.sql b/migrations/2021-05-03-213037_create_user_properties/up.sql index 11b8893..7e93a04 100644 --- a/migrations/2021-05-03-213037_create_user_properties/up.sql +++ b/migrations/2021-05-03-213037_create_user_properties/up.sql @@ -1,8 +1,8 @@ CREATE TABLE user_properties ( - user_name TEXT NOT NULL PRIMARY KEY, - property_id INTEGER NOT NULL, - property_flags INTEGER NOT NULL, - property_access INTEGER NOT NULL, - property_string_value INTEGER NOT NULL, - property_binary_value TEXT + user_name TEXT NOT NULL PRIMARY KEY, + property_id INTEGER NOT NULL, + property_flags INTEGER NOT NULL, + property_access INTEGER NOT NULL, + property_string_value INTEGER NOT NULL, + property_binary_value TEXT ) -- cgit v1.2.3