diff options
| author | Fuwn <[email protected]> | 2021-05-20 14:37:59 +0000 |
|---|---|---|
| committer | Fuwn <[email protected]> | 2021-05-20 14:37:59 +0000 |
| commit | 7e16a9efbfcf1d0fed108f80ab57b3631610d7e9 (patch) | |
| tree | f597af84b8e14e0d5f99d548854ec473587374f6 /migrations | |
| parent | fix(make): documentation line number (diff) | |
| download | whirl-7e16a9efbfcf1d0fed108f80ab57b3631610d7e9.tar.xz whirl-7e16a9efbfcf1d0fed108f80ab57b3631610d7e9.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 ) |