summaryrefslogtreecommitdiff
path: root/maintenance/ibm_db2/patch-user_properties.sql
blob: 72dcd7926c791cbfc81f8d9dcc6e223bf79afcd5 (plain)
1
2
3
4
5
6
7
8
9
10
CREATE TABLE user_properties (
  -- Foreign key to user.user_id
  up_user BIGINT NOT NULL,
  
  -- Name of the option being saved. This is indexed for bulk lookup.
  up_property VARCHAR(32) FOR BIT DATA NOT NULL,
  
  -- Property value as a string.
  up_value CLOB(64K) INLINE LENGTH 4096
);