+----------+----------------------------+------+------------+-------------+
| username | domain                     | type | prefA      | prefB       |
+----------+----------------------------+------+------------+-------------+
| NULL     | example.com                | 1    | 0          | 0           |
| NULL     | NULL                       | 1    | 1          | 1           |
| dood     | example.com                | 1    | 0          | 0           |
+----------+----------------------------+------+------------+-------------+