diff options
| author | Fuwn <[email protected]> | 2021-03-21 19:29:50 -0700 |
|---|---|---|
| committer | Fuwn <[email protected]> | 2021-03-21 19:29:50 -0700 |
| commit | 0808ac04da45fcfdd85bcb7b2001fd0fa159e11f (patch) | |
| tree | b7b9ffef5aa522cfac62483231f64f926e72ceb1 /migrations | |
| parent | feature: Use sqlx instead of rustqlite (diff) | |
| download | whirl-0808ac04da45fcfdd85bcb7b2001fd0fa159e11f.tar.xz whirl-0808ac04da45fcfdd85bcb7b2001fd0fa159e11f.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 +); |