diff options
| author | Fuwn <[email protected]> | 2021-03-21 19:29:50 +0000 |
|---|---|---|
| committer | Fuwn <[email protected]> | 2021-03-21 19:29:50 +0000 |
| commit | 761add819857aa6da7b5c1688f1abda437db5a0d (patch) | |
| tree | e0c8323f461f8512f6e0b2fb2142c4359ce8c9d0 /migrations | |
| parent | feature: Use sqlx instead of rustqlite (diff) | |
| download | whirl-761add819857aa6da7b5c1688f1abda437db5a0d.tar.xz whirl-761add819857aa6da7b5c1688f1abda437db5a0d.zip | |
chore: Create sqlx migrations
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/20210322015725_serial_numbers.sql | 5 | ||||
| -rw-r--r-- | migrations/20210322015732_user_registration.sql | 12 | ||||
| -rw-r--r-- | migrations/20210322015737_user_properties.sql | 8 |
3 files changed, 25 insertions, 0 deletions
diff --git a/migrations/20210322015725_serial_numbers.sql b/migrations/20210322015725_serial_numbers.sql new file mode 100644 index 0000000..9845cb3 --- /dev/null +++ b/migrations/20210322015725_serial_numbers.sql @@ -0,0 +1,5 @@ +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.sql b/migrations/20210322015732_user_registration.sql new file mode 100644 index 0000000..6f00d75 --- /dev/null +++ b/migrations/20210322015732_user_registration.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 +); diff --git a/migrations/20210322015737_user_properties.sql b/migrations/20210322015737_user_properties.sql new file mode 100644 index 0000000..be0ea9e --- /dev/null +++ b/migrations/20210322015737_user_properties.sql @@ -0,0 +1,8 @@ +CREATE TABLE "user_propertyies" ( + "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 +); |