6798604398f1407c3f20df3cc584198473207bea
1 CREATE TABLE user_properties (
2 -- Foreign key to user.user_id
3 up_user
BIGINT NOT NULL,
5 -- Name of the option being saved. This is indexed for bulk lookup.
6 up_property
VARCHAR(32) FOR BIT DATA NOT NULL,
8 -- Property value as a string.
9 up_value
CLOB(64K
) INLINE LENGTH 4096