preferences
===========

OS X defaults and managed preferences.

Platform support
----------------
Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. **Running a query against an unsupported platform will result in the following error:** ``no such table: preferences``

- Mac OSX

Table schema
------------

========  =======  =========================================================
Name      Type     Description                                              
========  =======  =========================================================
domain    TEXT     Application ID usually in com.name.product format        
key       TEXT     Preference top-level key                                 
subkey    TEXT     Intemediate key path, includes lists/dicts               
value     TEXT     String value of most CF types                            
forced    INTEGER  1 if the value is forced/managed, else 0                 
username  TEXT     (optional) read preferences for a specific user          
host      TEXT     'current' or 'any' host, where 'current' takes precedence
========  =======  =========================================================

Query examples
--------------

.. code-block:: sql

   select * from preferences where domain = 'loginwindow'


.. code-block:: sql

   select preferences.* from users join preferences using (username)