diff options
| author | Fuwn <[email protected]> | 2021-05-03 16:20:45 +0000 |
|---|---|---|
| committer | Fuwn <[email protected]> | 2021-05-03 16:20:45 +0000 |
| commit | 262d59d7b3bcfda94d333d1acc8ed1a505df1c0f (patch) | |
| tree | 4fdcc0ae5df1bf4c0713eeb7d4bf712c812c3ec7 /migrations | |
| parent | docs(readme): add development prerequisites (diff) | |
| download | whirl-262d59d7b3bcfda94d333d1acc8ed1a505df1c0f.tar.xz whirl-262d59d7b3bcfda94d333d1acc8ed1a505df1c0f.zip | |
feat(db): use diesel instead of sqlx, implement database tests
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/.gitkeep | 0 | ||||
| -rw-r--r-- | migrations/2021-05-03-213012_create_serial_numbers/down.sql (renamed from migrations/20210322015725_serial_numbers.down.sql) | 0 | ||||
| -rw-r--r-- | migrations/2021-05-03-213012_create_serial_numbers/up.sql | 5 | ||||
| -rw-r--r-- | migrations/2021-05-03-213030_create_user_registration/down.sql (renamed from migrations/20210322015732_user_registration.down.sql) | 0 | ||||
| -rw-r--r-- | migrations/2021-05-03-213030_create_user_registration/up.sql | 12 | ||||
| -rw-r--r-- | migrations/2021-05-03-213037_create_user_properties/down.sql (renamed from migrations/20210322015737_user_properties.down.sql) | 0 | ||||
| -rw-r--r-- | migrations/2021-05-03-213037_create_user_properties/up.sql | 8 | ||||
| -rw-r--r-- | migrations/20210322015725_serial_numbers.up.sql | 5 | ||||
| -rw-r--r-- | migrations/20210322015732_user_registration.up.sql | 12 | ||||
| -rw-r--r-- | migrations/20210322015737_user_properties.up.sql | 8 |
10 files changed, 25 insertions, 25 deletions
diff --git a/migrations/.gitkeep b/migrations/.gitkeep new file mode 100644 index 0000000..e69de29 --- /dev/null +++ b/migrations/.gitkeep diff --git a/migrations/20210322015725_serial_numbers.down.sql b/migrations/2021-05-03-213012_create_serial_numbers/down.sql index 9b64755..9b64755 100644 --- a/migrations/20210322015725_serial_numbers.down.sql +++ b/migrations/2021-05-03-213012_create_serial_numbers/down.sql diff --git a/migrations/2021-05-03-213012_create_serial_numbers/up.sql b/migrations/2021-05-03-213012_create_serial_numbers/up.sql new file mode 100644 index 0000000..eb626d8 --- /dev/null +++ b/migrations/2021-05-03-213012_create_serial_numbers/up.sql @@ -0,0 +1,5 @@ +CREATE TABLE serial_numbers ( + serial_number TEXT NOT NULL UNIQUE, + user_name TEXT NOT NULL PRIMARY KEY , + serial_status INTEGER NOT NULL +) diff --git a/migrations/20210322015732_user_registration.down.sql b/migrations/2021-05-03-213030_create_user_registration/down.sql index 5bc3c0e..5bc3c0e 100644 --- a/migrations/20210322015732_user_registration.down.sql +++ b/migrations/2021-05-03-213030_create_user_registration/down.sql diff --git a/migrations/2021-05-03-213030_create_user_registration/up.sql b/migrations/2021-05-03-213030_create_user_registration/up.sql new file mode 100644 index 0000000..dc6d9db --- /dev/null +++ b/migrations/2021-05-03-213030_create_user_registration/up.sql @@ -0,0 +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 +) diff --git a/migrations/20210322015737_user_properties.down.sql b/migrations/2021-05-03-213037_create_user_properties/down.sql index 6b03c94..6b03c94 100644 --- a/migrations/20210322015737_user_properties.down.sql +++ b/migrations/2021-05-03-213037_create_user_properties/down.sql diff --git a/migrations/2021-05-03-213037_create_user_properties/up.sql b/migrations/2021-05-03-213037_create_user_properties/up.sql new file mode 100644 index 0000000..11b8893 --- /dev/null +++ b/migrations/2021-05-03-213037_create_user_properties/up.sql @@ -0,0 +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 +) diff --git a/migrations/20210322015725_serial_numbers.up.sql b/migrations/20210322015725_serial_numbers.up.sql deleted file mode 100644 index b0c1895..0000000 --- a/migrations/20210322015725_serial_numbers.up.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE TABLE serial_numbers ( - serial_number TEXT NOT NULL UNIQUE, - user_name TEXT NOT NULL, - serial_status TEXT NOT NULL -) diff --git a/migrations/20210322015732_user_registration.up.sql b/migrations/20210322015732_user_registration.up.sql deleted file mode 100644 index 6a76e9b..0000000 --- a/migrations/20210322015732_user_registration.up.sql +++ /dev/null @@ -1,12 +0,0 @@ -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 -) diff --git a/migrations/20210322015737_user_properties.up.sql b/migrations/20210322015737_user_properties.up.sql deleted file mode 100644 index fe43761..0000000 --- a/migrations/20210322015737_user_properties.up.sql +++ /dev/null @@ -1,8 +0,0 @@ -CREATE TABLE user_properties ( - user_name TEXT NOT NULL, - property_id INTEGER NOT NULL, - property_flags INTEGER NOT NULL, - property_access INTEGER NOT NULL, - property_string_value TEXT, - property_binary_value TEXT -) |