diff options
| -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 +); |