migrations/2021-05-03-213037_create_user_properties/up.sql


1
2
3
4
5
6
7
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
)