aboutsummaryrefslogtreecommitdiff
path: root/migrations/20210322015737_user_properties.up.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/20210322015737_user_properties.up.sql')
-rw-r--r--migrations/20210322015737_user_properties.up.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/migrations/20210322015737_user_properties.up.sql b/migrations/20210322015737_user_properties.up.sql
new file mode 100644
index 0000000..fe43761
--- /dev/null
+++ b/migrations/20210322015737_user_properties.up.sql
@@ -0,0 +1,8 @@
+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
+)