diff options
| author | Fuwn <[email protected]> | 2021-05-20 14:37:59 -0700 |
|---|---|---|
| committer | Fuwn <[email protected]> | 2021-05-20 14:37:59 -0700 |
| commit | 52685dfaa581e6cfceabaa7b254508d765a06efa (patch) | |
| tree | 27cd7950d97760506b0c022bf4226a02b3360c6f /migrations | |
| parent | fix(make): documentation line number (diff) | |
| download | whirl-52685dfaa581e6cfceabaa7b254508d765a06efa.tar.xz whirl-52685dfaa581e6cfceabaa7b254508d765a06efa.zip | |
style(migrations): fix sql linting errors
Diffstat (limited to 'migrations')
3 files changed, 19 insertions, 19 deletions
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 ) |