diff options
Diffstat (limited to 'migrations/20210322015732_user_registration.up.sql')
| -rw-r--r-- | migrations/20210322015732_user_registration.up.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/migrations/20210322015732_user_registration.up.sql b/migrations/20210322015732_user_registration.up.sql new file mode 100644 index 0000000..6a76e9b --- /dev/null +++ b/migrations/20210322015732_user_registration.up.sql @@ -0,0 +1,12 @@ +CREATE TABLE user_registration ( + user_name_lower TEXT NOT NULL, + user_name TEXT NOT NULL, + 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 +) |