schema: a:106:{s:14:"egw_access_log";a:5:{s:2:"fd";a:10:{s:9:"sessionid";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:7:"loginid";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";s:8:"nullable";b:0;}s:2:"ip";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";s:8:"nullable";b:0;}s:2:"li";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:2:"lo";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:10:"account_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:11:"session_dla";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:14:"session_action";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:11:"session_php";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";s:8:"nullable";b:0;}s:22:"notification_heartbeat";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}}s:2:"pk";a:1:{i:0;s:9:"sessionid";}s:2:"fk";a:0:{}s:2:"ix";a:4:{i:0;s:2:"li";i:1;s:2:"lo";i:2;s:11:"session_dla";i:3;s:22:"notification_heartbeat";}s:2:"uc";a:0:{}}s:12:"egw_accounts";a:5:{s:2:"fd";a:12:{s:10:"account_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:11:"account_lid";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";s:8:"nullable";b:0;}s:11:"account_pwd";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";s:8:"nullable";b:0;}s:17:"account_lastlogin";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:21:"account_lastloginfrom";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:22:"account_lastpwd_change";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:14:"account_status";a:4:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"1";s:7:"default";s:1:"A";s:8:"nullable";b:0;}s:15:"account_expires";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:12:"account_type";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"1";}s:21:"account_primary_group";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:17:"account_challenge";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}s:16:"account_response";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}}s:2:"pk";a:1:{i:0;s:10:"account_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:1:{i:0;s:11:"account_lid";}}s:7:"egw_acl";a:5:{s:2:"fd";a:4:{s:11:"acl_appname";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";s:8:"nullable";b:0;}s:12:"acl_location";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:11:"acl_account";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:10:"acl_rights";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}}s:2:"pk";a:3:{i:0;s:11:"acl_appname";i:1;s:12:"acl_location";i:2;s:11:"acl_account";}s:2:"fk";a:0:{}s:2:"ix";a:3:{i:0;s:11:"acl_account";i:1;a:2:{i:0;s:12:"acl_location";i:1;s:11:"acl_account";}i:2;a:2:{i:0;s:11:"acl_appname";i:1;s:11:"acl_account";}}s:2:"uc";a:0:{}}s:15:"egw_addressbook";a:5:{s:2:"fd";a:64:{s:10:"contact_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:11:"contact_tid";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"1";s:7:"default";s:1:"n";}s:13:"contact_owner";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:15:"contact_private";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:1;s:7:"default";s:1:"0";}s:6:"cat_id";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:8:"n_family";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:7:"n_given";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:8:"n_middle";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:8:"n_prefix";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:8:"n_suffix";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:4:"n_fn";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:8:"n_fileas";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:12:"contact_bday";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"12";}s:8:"org_name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:8:"org_unit";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:13:"contact_title";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:12:"contact_role";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:17:"contact_assistent";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:12:"contact_room";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:14:"adr_one_street";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:15:"adr_one_street2";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:16:"adr_one_locality";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:14:"adr_one_region";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:18:"adr_one_postalcode";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:19:"adr_one_countryname";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:13:"contact_label";a:1:{s:4:"type";s:4:"text";}s:14:"adr_two_street";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:15:"adr_two_street2";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:16:"adr_two_locality";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:14:"adr_two_region";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:18:"adr_two_postalcode";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:19:"adr_two_countryname";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:8:"tel_work";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";}s:8:"tel_cell";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";}s:7:"tel_fax";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";}s:13:"tel_assistent";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";}s:7:"tel_car";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";}s:9:"tel_pager";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";}s:8:"tel_home";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";}s:12:"tel_fax_home";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";}s:16:"tel_cell_private";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";}s:9:"tel_other";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";}s:10:"tel_prefer";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"32";}s:13:"contact_email";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:18:"contact_email_home";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:11:"contact_url";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:16:"contact_url_home";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:20:"contact_freebusy_uri";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:20:"contact_calendar_uri";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:12:"contact_note";a:1:{s:4:"type";s:4:"text";}s:10:"contact_tz";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"8";}s:11:"contact_geo";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"32";}s:14:"contact_pubkey";a:1:{s:4:"type";s:4:"text";}s:15:"contact_created";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:15:"contact_creator";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:16:"contact_modified";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:16:"contact_modifier";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:17:"contact_jpegphoto";a:1:{s:4:"type";s:4:"blob";}s:10:"account_id";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:12:"contact_etag";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";}s:11:"contact_uid";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:19:"adr_one_countrycode";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"2";}s:19:"adr_two_countrycode";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"2";}s:12:"carddav_name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}}s:2:"pk";a:1:{i:0;s:10:"contact_id";}s:2:"fk";a:0:{}s:2:"ix";a:9:{i:0;s:13:"contact_owner";i:1;s:6:"cat_id";i:2;s:8:"n_fileas";i:3;s:16:"contact_modified";i:4;s:11:"contact_uid";i:5;s:12:"carddav_name";i:6;a:2:{i:0;s:8:"n_family";i:1;s:7:"n_given";}i:7;a:2:{i:0;s:7:"n_given";i:1;s:8:"n_family";}i:8;a:3:{i:0;s:8:"org_name";i:1;s:8:"n_family";i:2;s:7:"n_given";}}s:2:"uc";a:1:{i:0;s:10:"account_id";}}s:20:"egw_addressbook2list";a:5:{s:2:"fd";a:4:{s:10:"contact_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"list_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:10:"list_added";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:13:"list_added_by";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}}s:2:"pk";a:2:{i:0;s:10:"contact_id";i:1;s:7:"list_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:21:"egw_addressbook_extra";a:5:{s:2:"fd";a:4:{s:10:"contact_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:13:"contact_owner";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:12:"contact_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:13:"contact_value";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:2:{i:0;s:10:"contact_id";i:1;s:12:"contact_name";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:12:"contact_name";}s:2:"uc";a:0:{}}s:21:"egw_addressbook_lists";a:5:{s:2:"fd";a:5:{s:7:"list_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:9:"list_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:10:"list_owner";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:12:"list_created";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:12:"list_creator";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}}s:2:"pk";a:1:{i:0;s:7:"list_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:1:{i:0;a:2:{i:0;s:10:"list_owner";i:1;s:9:"list_name";}}}s:15:"egw_admin_queue";a:5:{s:2:"fd";a:18:{s:6:"cmd_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:7:"cmd_uid";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:11:"cmd_creator";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:17:"cmd_creator_email";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";s:8:"nullable";b:0;}s:11:"cmd_created";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:8:"cmd_type";a:4:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"32";s:7:"default";s:9:"admin_cmd";s:8:"nullable";b:0;}s:10:"cmd_status";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:1;}s:13:"cmd_scheduled";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:12:"cmd_modified";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:12:"cmd_modifier";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:18:"cmd_modifier_email";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:9:"cmd_error";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:9:"cmd_errno";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:13:"cmd_requested";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:19:"cmd_requested_email";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:11:"cmd_comment";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:8:"cmd_data";a:1:{s:4:"type";s:4:"blob";}s:9:"remote_id";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}}s:2:"pk";a:1:{i:0;s:6:"cmd_id";}s:2:"fk";a:0:{}s:2:"ix";a:2:{i:0;s:10:"cmd_status";i:1;s:13:"cmd_scheduled";}s:2:"uc";a:1:{i:0;s:7:"cmd_uid";}}s:16:"egw_admin_remote";a:5:{s:2:"fd";a:5:{s:9:"remote_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:11:"remote_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";s:8:"nullable";b:0;}s:11:"remote_hash";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"32";s:8:"nullable";b:0;}s:10:"remote_url";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";s:8:"nullable";b:0;}s:13:"remote_domain";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:9:"remote_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:1:{i:0;s:11:"remote_name";}}s:23:"egw_api_content_history";a:5:{s:2:"fd";a:7:{s:12:"sync_appname";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"60";s:8:"nullable";b:0;}s:14:"sync_contentid";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"60";s:8:"nullable";b:0;}s:10:"sync_added";a:1:{s:4:"type";s:9:"timestamp";}s:13:"sync_modified";a:1:{s:4:"type";s:9:"timestamp";}s:12:"sync_deleted";a:1:{s:4:"type";s:9:"timestamp";}s:7:"sync_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:14:"sync_changedby";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:7:"sync_id";}s:2:"fk";a:0:{}s:2:"ix";a:5:{i:0;s:10:"sync_added";i:1;s:13:"sync_modified";i:2;s:12:"sync_deleted";i:3;s:14:"sync_changedby";i:4;a:2:{i:0;s:12:"sync_appname";i:1;s:14:"sync_contentid";}}s:2:"uc";a:0:{}}s:16:"egw_applications";a:5:{s:2:"fd";a:9:{s:6:"app_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:8:"app_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"25";s:8:"nullable";b:0;}s:11:"app_enabled";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:9:"app_order";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:10:"app_tables";a:1:{s:4:"type";s:4:"text";}s:11:"app_version";a:4:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"20";s:7:"default";s:3:"0.0";s:8:"nullable";b:0;}s:8:"app_icon";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"32";}s:12:"app_icon_app";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"25";}s:9:"app_index";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}}s:2:"pk";a:1:{i:0;s:6:"app_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;a:2:{i:0;s:11:"app_enabled";i:1;s:9:"app_order";}}s:2:"uc";a:1:{i:0;s:8:"app_name";}}s:9:"egw_async";a:5:{s:2:"fd";a:6:{s:8:"async_id";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:10:"async_next";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:11:"async_times";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:12:"async_method";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:10:"async_data";a:1:{s:4:"type";s:4:"text";}s:16:"async_account_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:8:"async_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:13:"egw_bookmarks";a:5:{s:2:"fd";a:11:{s:5:"bm_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:8:"bm_owner";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:9:"bm_access";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:6:"bm_url";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:7:"bm_name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:7:"bm_desc";a:1:{s:4:"type";s:4:"text";}s:11:"bm_keywords";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:11:"bm_category";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:9:"bm_rating";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:7:"bm_info";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:9:"bm_visits";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}}s:2:"pk";a:1:{i:0;s:5:"bm_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:7:"egw_cal";a:5:{s:2:"fd";a:21:{s:6:"cal_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:7:"cal_uid";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:9:"cal_owner";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:12:"cal_category";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"30";}s:12:"cal_modified";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:12:"cal_priority";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"2";s:8:"nullable";b:0;}s:10:"cal_public";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"1";s:8:"nullable";b:0;}s:9:"cal_title";a:4:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:7:"default";s:1:"1";s:8:"nullable";b:0;}s:15:"cal_description";a:1:{s:4:"type";s:4:"text";}s:12:"cal_location";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:13:"cal_reference";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:12:"cal_modifier";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:16:"cal_non_blocking";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"0";}s:11:"cal_special";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"0";}s:8:"cal_etag";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";}s:11:"cal_creator";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:11:"cal_created";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:14:"cal_recurrence";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:5:"tz_id";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:11:"cal_deleted";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:11:"caldav_name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}}s:2:"pk";a:1:{i:0;s:6:"cal_id";}s:2:"fk";a:0:{}s:2:"ix";a:5:{i:0;s:7:"cal_uid";i:1;s:9:"cal_owner";i:2;s:12:"cal_modified";i:3;s:11:"cal_deleted";i:4;s:11:"caldav_name";}s:2:"uc";a:0:{}}s:13:"egw_cal_dates";a:5:{s:2:"fd";a:3:{s:6:"cal_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:9:"cal_start";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:7:"cal_end";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}}s:2:"pk";a:2:{i:0;s:6:"cal_id";i:1;s:9:"cal_start";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:13:"egw_cal_extra";a:5:{s:2:"fd";a:3:{s:6:"cal_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:14:"cal_extra_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";s:8:"nullable";b:0;}s:15:"cal_extra_value";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}}s:2:"pk";a:2:{i:0;s:6:"cal_id";i:1;s:14:"cal_extra_name";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:16:"egw_cal_holidays";a:5:{s:2:"fd";a:8:{s:6:"hol_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:10:"hol_locale";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"2";s:8:"nullable";b:0;}s:8:"hol_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";s:8:"nullable";b:0;}s:8:"hol_mday";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:13:"hol_month_num";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:13:"hol_occurence";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:7:"hol_dow";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:19:"hol_observance_rule";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:7:"default";s:1:"0";s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:6:"hol_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:10:"hol_locale";}s:2:"uc";a:0:{}}s:15:"egw_cal_repeats";a:5:{s:2:"fd";a:6:{s:6:"cal_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:10:"recur_type";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:8:"nullable";b:0;}s:13:"recur_enddate";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:14:"recur_interval";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"1";}s:10:"recur_data";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"1";}s:15:"recur_exception";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:1:{i:0;s:6:"cal_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:17:"egw_cal_timezones";a:5:{s:2:"fd";a:6:{s:5:"tz_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:7:"tz_tzid";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";s:8:"nullable";b:0;}s:8:"tz_alias";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:11:"tz_latitude";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:12:"tz_longitude";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:12:"tz_component";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:1:{i:0;s:5:"tz_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:8:"tz_alias";}s:2:"uc";a:1:{i:0;s:7:"tz_tzid";}}s:12:"egw_cal_user";a:5:{s:2:"fd";a:8:{s:6:"cal_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:14:"cal_recur_date";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:13:"cal_user_type";a:4:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"1";s:7:"default";s:1:"u";s:8:"nullable";b:0;}s:11:"cal_user_id";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";s:8:"nullable";b:0;}s:10:"cal_status";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"1";s:7:"default";s:1:"A";}s:12:"cal_quantity";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"1";}s:8:"cal_role";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";s:7:"default";s:15:"REQ-PARTICIPANT";}s:17:"cal_user_modified";a:3:{s:4:"type";s:9:"timestamp";s:7:"default";s:17:"current_timestamp";s:8:"nullable";b:0;}}s:2:"pk";a:4:{i:0;s:6:"cal_id";i:1;s:14:"cal_recur_date";i:2;s:13:"cal_user_type";i:3;s:11:"cal_user_id";}s:2:"fk";a:0:{}s:2:"ix";a:2:{i:0;s:17:"cal_user_modified";i:1;a:2:{i:0;s:13:"cal_user_type";i:1;s:11:"cal_user_id";}}s:2:"uc";a:0:{}}s:13:"egw_cat2entry";a:5:{s:2:"fd";a:4:{s:6:"ce_app";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"25";s:8:"nullable";b:0;}s:9:"ce_app_id";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";s:8:"nullable";b:0;}s:6:"cat_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:8:"ce_owner";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}}s:2:"pk";a:3:{i:0;s:6:"ce_app";i:1;s:9:"ce_app_id";i:2;s:6:"cat_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:6:"cat_id";}s:2:"uc";a:0:{}}s:14:"egw_categories";a:5:{s:2:"fd";a:11:{s:6:"cat_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:8:"cat_main";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:10:"cat_parent";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:9:"cat_level";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:9:"cat_owner";a:4:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:10:"cat_access";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"7";}s:11:"cat_appname";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";s:8:"nullable";b:0;}s:8:"cat_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"150";s:8:"nullable";b:0;}s:15:"cat_description";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:8:"cat_data";a:1:{s:4:"type";s:4:"text";}s:8:"last_mod";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:6:"cat_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;a:4:{i:0;s:11:"cat_appname";i:1;s:9:"cat_owner";i:2;s:10:"cat_parent";i:3;s:9:"cat_level";}}s:2:"uc";a:0:{}}s:10:"egw_config";a:5:{s:2:"fd";a:3:{s:10:"config_app";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";s:8:"nullable";b:0;}s:11:"config_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:12:"config_value";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:2:{i:0;s:10:"config_app";i:1;s:11:"config_name";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:14:"egw_contentmap";a:5:{s:2:"fd";a:5:{s:6:"map_id";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";s:8:"nullable";b:0;}s:8:"map_guid";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";s:8:"nullable";b:0;}s:10:"map_locuid";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";s:8:"nullable";b:0;}s:13:"map_timestamp";a:2:{s:4:"type";s:9:"timestamp";s:8:"nullable";b:0;}s:11:"map_expired";a:2:{s:4:"type";s:4:"bool";s:8:"nullable";b:0;}}s:2:"pk";a:3:{i:0;s:6:"map_id";i:1;s:8:"map_guid";i:2;s:10:"map_locuid";}s:2:"fk";a:0:{}s:2:"ix";a:2:{i:0;s:11:"map_expired";i:1;a:2:{i:0;s:6:"map_id";i:1;s:10:"map_locuid";}}s:2:"uc";a:0:{}}s:14:"egw_emailadmin";a:5:{s:2:"fd";a:41:{s:13:"ea_profile_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:14:"ea_smtp_server";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";}s:12:"ea_smtp_type";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:12:"ea_smtp_port";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:12:"ea_smtp_auth";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"3";}s:24:"ea_editforwardingaddress";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"3";}s:19:"ea_smtp_ldap_server";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";}s:19:"ea_smtp_ldap_basedn";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"200";}s:20:"ea_smtp_ldap_admindn";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"200";}s:20:"ea_smtp_ldap_adminpw";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"30";}s:24:"ea_smtp_ldap_use_default";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"3";}s:14:"ea_imap_server";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";}s:12:"ea_imap_type";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:12:"ea_imap_port";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:18:"ea_imap_login_type";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"20";}s:16:"ea_imap_tsl_auth";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"3";}s:22:"ea_imap_tsl_encryption";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"3";}s:20:"ea_imap_enable_cyrus";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"3";}s:18:"ea_imap_admin_user";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";}s:16:"ea_imap_admin_pw";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";}s:20:"ea_imap_enable_sieve";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"3";}s:20:"ea_imap_sieve_server";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";}s:18:"ea_imap_sieve_port";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:14:"ea_description";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"200";}s:17:"ea_default_domain";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}s:20:"ea_organisation_name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}s:26:"ea_user_defined_identities";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"3";}s:24:"ea_user_defined_accounts";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"3";}s:17:"ea_imapoldcclient";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"3";}s:8:"ea_order";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:10:"ea_appname";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";}s:8:"ea_group";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";}s:7:"ea_user";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";}s:9:"ea_active";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:21:"ea_smtp_auth_username";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";}s:21:"ea_smtp_auth_password";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";}s:26:"ea_user_defined_signatures";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"3";}s:20:"ea_default_signature";a:1:{s:4:"type";s:4:"text";}s:21:"ea_imap_auth_username";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";}s:21:"ea_imap_auth_password";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";}s:30:"ea_stationery_active_templates";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:1:{i:0;s:13:"ea_profile_id";}s:2:"fk";a:0:{}s:2:"ix";a:2:{i:0;s:10:"ea_appname";i:1;s:8:"ea_group";}s:2:"uc";a:0:{}}s:13:"egw_etemplate";a:5:{s:2:"fd";a:9:{s:7:"et_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:11:"et_template";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"20";s:8:"nullable";b:0;}s:7:"et_lang";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";s:8:"nullable";b:0;}s:8:"et_group";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:10:"et_version";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"20";s:8:"nullable";b:0;}s:7:"et_data";a:1:{s:4:"type";s:4:"text";}s:7:"et_size";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:8:"et_style";a:1:{s:4:"type";s:4:"text";}s:11:"et_modified";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}}s:2:"pk";a:5:{i:0;s:7:"et_name";i:1;s:11:"et_template";i:2;s:7:"et_lang";i:3;s:8:"et_group";i:4;s:10:"et_version";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:23:"egw_felamimail_accounts";a:5:{s:2:"fd";a:26:{s:8:"fm_owner";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:5:"fm_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:11:"fm_realname";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:15:"fm_organization";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:15:"fm_emailaddress";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";s:8:"nullable";b:0;}s:14:"fm_signatureid";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:14:"fm_ic_hostname";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:10:"fm_ic_port";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:14:"fm_ic_username";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:14:"fm_ic_password";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:16:"fm_ic_encryption";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:14:"fm_og_hostname";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:10:"fm_og_port";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:14:"fm_og_smtpauth";a:1:{s:4:"type";s:4:"bool";}s:14:"fm_og_username";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:14:"fm_og_password";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:9:"fm_active";a:2:{s:4:"type";s:4:"bool";s:8:"nullable";b:0;}s:25:"fm_ic_validatecertificate";a:1:{s:4:"type";s:4:"bool";}s:18:"fm_ic_enable_sieve";a:1:{s:4:"type";s:4:"bool";}s:18:"fm_ic_sieve_server";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:16:"fm_ic_sieve_port";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:25:"fm_ic_folderstoshowinhome";a:1:{s:4:"type";s:4:"text";}s:16:"fm_ic_sentfolder";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:17:"fm_ic_trashfolder";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:17:"fm_ic_draftfolder";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:20:"fm_ic_templatefolder";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}}s:2:"pk";a:1:{i:0;s:5:"fm_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:8:"fm_owner";}s:2:"uc";a:0:{}}s:28:"egw_felamimail_displayfilter";a:5:{s:2:"fd";a:2:{s:22:"fmail_filter_accountid";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:17:"fmail_filter_data";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:1:{i:0;s:22:"fmail_filter_accountid";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:25:"egw_felamimail_signatures";a:5:{s:2:"fd";a:5:{s:14:"fm_signatureid";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:12:"fm_accountid";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:12:"fm_signature";a:1:{s:4:"type";s:4:"text";}s:14:"fm_description";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:19:"fm_defaultsignature";a:1:{s:4:"type";s:4:"bool";}}s:2:"pk";a:1:{i:0;s:14:"fm_signatureid";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:15:"egw_history_log";a:5:{s:2:"fd";a:8:{s:10:"history_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:17:"history_record_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:15:"history_appname";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";s:8:"nullable";b:0;}s:13:"history_owner";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:14:"history_status";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";s:8:"nullable";b:0;}s:17:"history_new_value";a:1:{s:4:"type";s:4:"text";}s:17:"history_timestamp";a:3:{s:4:"type";s:9:"timestamp";s:7:"default";s:17:"current_timestamp";s:8:"nullable";b:0;}s:17:"history_old_value";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:1:{i:0;s:10:"history_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;a:4:{i:0;s:15:"history_appname";i:1;s:17:"history_record_id";i:2;s:14:"history_status";i:3;s:17:"history_timestamp";}}s:2:"uc";a:0:{}}s:9:"egw_hooks";a:5:{s:2:"fd";a:4:{s:7:"hook_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:12:"hook_appname";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:13:"hook_location";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:13:"hook_filename";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}}s:2:"pk";a:1:{i:0;s:7:"hook_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:28:"egw_importexport_definitions";a:5:{s:2:"fd";a:9:{s:13:"definition_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:4:"name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:11:"application";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";}s:6:"plugin";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}s:4:"type";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"20";}s:13:"allowed_users";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:14:"plugin_options";a:1:{s:4:"type";s:4:"text";}s:5:"owner";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:11:"description";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}}s:2:"pk";a:1:{i:0;s:13:"definition_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:1:{i:0;s:4:"name";}}s:9:"egw_index";a:5:{s:2:"fd";a:4:{s:6:"si_app";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"25";s:8:"nullable";b:0;}s:9:"si_app_id";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";s:8:"nullable";b:0;}s:5:"si_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:8:"si_owner";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}}s:2:"pk";a:3:{i:0;s:6:"si_app";i:1;s:9:"si_app_id";i:2;s:5:"si_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:5:"si_id";}s:2:"uc";a:0:{}}s:18:"egw_index_keywords";a:5:{s:2:"fd";a:3:{s:5:"si_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:10:"si_keyword";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";s:8:"nullable";b:0;}s:9:"si_ignore";a:1:{s:4:"type";s:4:"bool";}}s:2:"pk";a:1:{i:0;s:5:"si_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:1:{i:0;s:10:"si_keyword";}}s:11:"egw_infolog";a:5:{s:2:"fd";a:34:{s:7:"info_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:9:"info_type";a:4:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";s:7:"default";s:4:"task";s:8:"nullable";b:0;}s:9:"info_from";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:9:"info_addr";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:12:"info_subject";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:8:"info_des";a:1:{s:4:"type";s:4:"text";}s:10:"info_owner";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:16:"info_responsible";a:4:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:11:"info_access";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"10";s:7:"default";s:6:"public";}s:8:"info_cat";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:17:"info_datemodified";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:14:"info_startdate";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:12:"info_enddate";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:14:"info_id_parent";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:17:"info_planned_time";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:19:"info_replanned_time";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:14:"info_used_time";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:11:"info_status";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";s:7:"default";s:4:"done";}s:12:"info_confirm";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"10";s:7:"default";s:3:"not";}s:13:"info_modifier";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:12:"info_link_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:13:"info_priority";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"1";}s:5:"pl_id";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:10:"info_price";a:2:{s:4:"type";s:5:"float";s:9:"precision";i:-1;}s:12:"info_percent";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"0";}s:18:"info_datecompleted";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:13:"info_location";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:16:"info_custom_from";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:1;}s:8:"info_uid";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:7:"info_cc";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:11:"caldav_name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:9:"info_etag";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";}s:12:"info_created";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:12:"info_creator";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}}s:2:"pk";a:1:{i:0;s:7:"info_id";}s:2:"fk";a:0:{}s:2:"ix";a:3:{i:0;s:11:"caldav_name";i:1;a:4:{i:0;s:10:"info_owner";i:1;s:16:"info_responsible";i:2;s:11:"info_status";i:3;s:14:"info_startdate";}i:2;a:5:{i:0;s:14:"info_id_parent";i:1;s:10:"info_owner";i:2;s:16:"info_responsible";i:3;s:11:"info_status";i:4;s:14:"info_startdate";}}s:2:"uc";a:0:{}}s:17:"egw_infolog_extra";a:5:{s:2:"fd";a:3:{s:7:"info_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:15:"info_extra_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";s:8:"nullable";b:0;}s:16:"info_extra_value";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:2:{i:0;s:7:"info_id";i:1;s:15:"info_extra_name";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:13:"egw_interserv";a:5:{s:2:"fd";a:12:{s:9:"server_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:11:"server_name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:11:"server_host";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:10:"server_url";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:11:"trust_level";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:9:"trust_rel";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:8:"username";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:8:"password";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:10:"admin_name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:11:"admin_email";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:11:"server_mode";a:4:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"16";s:7:"default";s:6:"xmlrpc";s:8:"nullable";b:0;}s:15:"server_security";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"16";}}s:2:"pk";a:1:{i:0;s:9:"server_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:15:"egw_kb_articles";a:5:{s:2:"fd";a:17:{s:6:"art_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:4:"q_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:5:"title";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:5:"topic";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:4:"text";a:1:{s:4:"type";s:4:"text";}s:6:"cat_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:9:"published";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:7:"user_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:5:"views";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:7:"created";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:8:"modified";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:16:"modified_user_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"votes_1";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"votes_2";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"votes_3";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"votes_4";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"votes_5";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:6:"art_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:14:"egw_kb_comment";a:5:{s:2:"fd";a:6:{s:10:"comment_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:7:"user_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:10:"kb_comment";a:1:{s:4:"type";s:4:"text";}s:7:"entered";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:6:"art_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:9:"published";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:10:"comment_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:6:"art_id";}s:2:"uc";a:0:{}}s:16:"egw_kb_questions";a:5:{s:2:"fd";a:7:{s:11:"question_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:7:"user_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"summary";a:1:{s:4:"type";s:4:"text";}s:7:"details";a:1:{s:4:"type";s:4:"text";}s:6:"cat_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:8:"creation";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:9:"published";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:11:"question_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:14:"egw_kb_ratings";a:5:{s:2:"fd";a:2:{s:7:"user_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:6:"art_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}}s:2:"pk";a:2:{i:0;s:7:"user_id";i:1;s:6:"art_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:18:"egw_kb_related_art";a:5:{s:2:"fd";a:2:{s:6:"art_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:14:"related_art_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}}s:2:"pk";a:2:{i:0;s:6:"art_id";i:1;s:14:"related_art_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:13:"egw_kb_search";a:5:{s:2:"fd";a:3:{s:7:"keyword";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"30";s:8:"nullable";b:0;}s:6:"art_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:5:"score";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}}s:2:"pk";a:2:{i:0;s:7:"keyword";i:1;s:6:"art_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:11:"egw_kb_urls";a:5:{s:2:"fd";a:3:{s:6:"art_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"art_url";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:13:"art_url_title";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}}s:2:"pk";a:2:{i:0;s:6:"art_id";i:1;s:7:"art_url";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:8:"egw_lang";a:5:{s:2:"fd";a:4:{s:4:"lang";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";s:8:"nullable";b:0;}s:8:"app_name";a:4:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"32";s:7:"default";s:6:"common";s:8:"nullable";b:0;}s:10:"message_id";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";s:8:"nullable";b:0;}s:7:"content";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:3:{i:0;s:4:"lang";i:1;s:8:"app_name";i:2;s:10:"message_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:13:"egw_languages";a:5:{s:2:"fd";a:2:{s:7:"lang_id";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";s:8:"nullable";b:0;}s:9:"lang_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:7:"lang_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:9:"egw_links";a:5:{s:2:"fd";a:9:{s:7:"link_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:9:"link_app1";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"25";s:8:"nullable";b:0;}s:8:"link_id1";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";s:8:"nullable";b:0;}s:9:"link_app2";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"25";s:8:"nullable";b:0;}s:8:"link_id2";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";s:8:"nullable";b:0;}s:11:"link_remark";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}s:12:"link_lastmod";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:10:"link_owner";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"deleted";a:1:{s:4:"type";s:9:"timestamp";}}s:2:"pk";a:1:{i:0;s:7:"link_id";}s:2:"fk";a:0:{}s:2:"ix";a:3:{i:0;s:7:"deleted";i:1;a:3:{i:0;s:9:"link_app1";i:1;s:8:"link_id1";i:2;s:12:"link_lastmod";}i:2;a:3:{i:0;s:9:"link_app2";i:1;s:8:"link_id2";i:2;s:12:"link_lastmod";}}s:2:"uc";a:0:{}}s:9:"egw_locks";a:5:{s:2:"fd";a:9:{s:10:"lock_token";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:9:"lock_path";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:12:"lock_expires";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:10:"lock_owner";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:14:"lock_recursive";a:3:{s:4:"type";s:4:"bool";s:7:"default";b:0;s:8:"nullable";b:0;}s:10:"lock_write";a:3:{s:4:"type";s:4:"bool";s:7:"default";b:0;s:8:"nullable";b:0;}s:14:"lock_exclusive";a:3:{s:4:"type";s:4:"bool";s:7:"default";b:0;s:8:"nullable";b:0;}s:12:"lock_created";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:7:"default";s:1:"0";}s:13:"lock_modified";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:7:"default";s:1:"0";}}s:2:"pk";a:1:{i:0;s:10:"lock_token";}s:2:"fk";a:0:{}s:2:"ix";a:2:{i:0;s:9:"lock_path";i:1;s:12:"lock_expires";}s:2:"uc";a:0:{}}s:7:"egw_log";a:5:{s:2:"fd";a:5:{s:6:"log_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:8:"log_date";a:2:{s:4:"type";s:9:"timestamp";s:8:"nullable";b:0;}s:8:"log_user";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"log_app";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";s:8:"nullable";b:0;}s:12:"log_severity";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"1";s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:6:"log_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:11:"egw_log_msg";a:5:{s:2:"fd";a:11:{s:14:"log_msg_log_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:14:"log_msg_seq_no";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:12:"log_msg_date";a:2:{s:4:"type";s:9:"timestamp";s:8:"nullable";b:0;}s:14:"log_msg_tx_fid";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"4";}s:13:"log_msg_tx_id";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"4";}s:16:"log_msg_severity";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"1";s:8:"nullable";b:0;}s:12:"log_msg_code";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"30";s:8:"nullable";b:0;}s:11:"log_msg_msg";a:1:{s:4:"type";s:4:"text";}s:13:"log_msg_parms";a:1:{s:4:"type";s:4:"text";}s:12:"log_msg_file";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:12:"log_msg_line";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}}s:2:"pk";a:2:{i:0;s:14:"log_msg_log_id";i:1;s:14:"log_msg_seq_no";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:8:"egw_news";a:5:{s:2:"fd";a:12:{s:7:"news_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:9:"news_date";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:13:"news_headline";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:16:"news_submittedby";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:12:"news_content";a:1:{s:4:"type";s:4:"text";}s:10:"news_begin";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:8:"news_end";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:6:"cat_id";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:11:"news_teaser";a:1:{s:4:"type";s:4:"text";}s:12:"news_is_html";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"1";s:8:"nullable";b:0;}s:14:"news_source_id";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:9:"news_lang";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";}}s:2:"pk";a:1:{i:0;s:7:"news_id";}s:2:"fk";a:0:{}s:2:"ix";a:4:{i:0;s:9:"news_date";i:1;s:13:"news_headline";i:2;s:6:"cat_id";i:3;s:9:"news_lang";}s:2:"uc";a:0:{}}s:15:"egw_news_export";a:5:{s:2:"fd";a:9:{s:6:"cat_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:11:"export_type";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:2;}s:17:"export_itemsyntax";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:2;}s:12:"export_title";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:11:"export_link";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:18:"export_description";a:1:{s:4:"type";s:4:"text";}s:16:"export_img_title";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:14:"export_img_url";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:15:"export_img_link";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}}s:2:"pk";a:1:{i:0;s:6:"cat_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:10:"egw_nextid";a:5:{s:2:"fd";a:2:{s:2:"id";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:7:"appname";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"25";s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:7:"appname";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:21:"egw_notificationpopup";a:5:{s:2:"fd";a:3:{s:10:"account_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:10:"session_id";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:7:"message";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:0:{}s:2:"fk";a:0:{}s:2:"ix";a:2:{i:0;s:10:"account_id";i:1;s:10:"session_id";}s:2:"uc";a:0:{}}s:18:"egw_pm_constraints";a:5:{s:2:"fd";a:4:{s:5:"pm_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:9:"pe_id_end";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:11:"pe_id_start";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:5:"ms_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}}s:2:"pk";a:4:{i:0;s:5:"pm_id";i:1;s:9:"pe_id_end";i:2;s:11:"pe_id_start";i:3;s:5:"ms_id";}s:2:"fk";a:0:{}s:2:"ix";a:2:{i:0;a:2:{i:0;s:5:"pm_id";i:1;s:11:"pe_id_start";}i:1;a:2:{i:0;s:5:"pm_id";i:1;s:5:"ms_id";}}s:2:"uc";a:0:{}}s:15:"egw_pm_elements";a:5:{s:2:"fd";a:27:{s:5:"pm_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:5:"pe_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:8:"pe_title";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:13:"pe_completion";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:2;}s:15:"pe_planned_time";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:17:"pe_replanned_time";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:12:"pe_used_time";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:17:"pe_planned_budget";a:3:{s:4:"type";s:7:"decimal";s:9:"precision";s:2:"20";s:5:"scale";s:1:"2";}s:14:"pe_used_budget";a:3:{s:4:"type";s:7:"decimal";s:9:"precision";s:2:"20";s:5:"scale";s:1:"2";}s:16:"pe_planned_start";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:13:"pe_real_start";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:14:"pe_planned_end";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:11:"pe_real_end";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:12:"pe_overwrite";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:5:"pl_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:9:"pe_synced";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:11:"pe_modified";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:11:"pe_modifier";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:9:"pe_status";a:4:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"8";s:7:"default";s:3:"new";s:8:"nullable";b:0;}s:12:"pe_unitprice";a:3:{s:4:"type";s:7:"decimal";s:9:"precision";s:2:"20";s:5:"scale";s:1:"2";}s:6:"cat_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:8:"pe_share";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:9:"pe_health";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:2;}s:12:"pe_resources";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:10:"pe_details";a:1:{s:4:"type";s:4:"text";}s:19:"pe_planned_quantity";a:2:{s:4:"type";s:5:"float";s:9:"precision";i:-1;}s:16:"pe_used_quantity";a:2:{s:4:"type";s:5:"float";s:9:"precision";i:-1;}}s:2:"pk";a:2:{i:0;s:5:"pm_id";i:1;s:5:"pe_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;a:2:{i:0;s:5:"pm_id";i:1;s:9:"pe_status";}}s:2:"uc";a:0:{}}s:12:"egw_pm_extra";a:5:{s:2:"fd";a:3:{s:5:"pm_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:13:"pm_extra_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";s:8:"nullable";b:0;}s:14:"pm_extra_value";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:2:{i:0;s:5:"pm_id";i:1;s:13:"pm_extra_name";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:14:"egw_pm_members";a:5:{s:2:"fd";a:4:{s:5:"pm_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:10:"member_uid";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"role_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";}s:19:"member_availibility";a:3:{s:4:"type";s:5:"float";s:9:"precision";i:-1;s:7:"default";s:3:"100";}}s:2:"pk";a:2:{i:0;s:5:"pm_id";i:1;s:10:"member_uid";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:17:"egw_pm_milestones";a:5:{s:2:"fd";a:5:{s:5:"ms_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:5:"pm_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"ms_date";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:8:"ms_title";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:14:"ms_description";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:1:{i:0;s:5:"ms_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:5:"pm_id";}s:2:"uc";a:0:{}}s:16:"egw_pm_pricelist";a:5:{s:2:"fd";a:5:{s:5:"pl_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:8:"pl_title";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:14:"pl_description";a:1:{s:4:"type";s:4:"text";}s:6:"cat_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:7:"pl_unit";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"20";s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:5:"pl_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:13:"egw_pm_prices";a:5:{s:2:"fd";a:8:{s:5:"pm_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:5:"pl_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:13:"pl_validsince";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:8:"pl_price";a:2:{s:4:"type";s:5:"float";s:9:"precision";i:-1;}s:11:"pl_modifier";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:11:"pl_modified";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:16:"pl_customertitle";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:11:"pl_billable";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"1";}}s:2:"pk";a:3:{i:0;s:5:"pm_id";i:1;s:5:"pl_id";i:2;s:13:"pl_validsince";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:15:"egw_pm_projects";a:5:{s:2:"fd";a:24:{s:5:"pm_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:9:"pm_number";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";s:8:"nullable";b:0;}s:8:"pm_title";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:14:"pm_description";a:1:{s:4:"type";s:4:"text";}s:10:"pm_creator";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:10:"pm_created";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:11:"pm_modifier";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:11:"pm_modified";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:16:"pm_planned_start";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:14:"pm_planned_end";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:13:"pm_real_start";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:11:"pm_real_end";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:6:"cat_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";}s:9:"pm_access";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"7";s:7:"default";s:6:"public";}s:11:"pm_priority";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"1";}s:9:"pm_status";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"9";s:7:"default";s:6:"active";}s:13:"pm_completion";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"0";}s:12:"pm_used_time";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:15:"pm_planned_time";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:17:"pm_replanned_time";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:14:"pm_used_budget";a:3:{s:4:"type";s:7:"decimal";s:9:"precision";s:2:"20";s:5:"scale";s:1:"2";}s:17:"pm_planned_budget";a:3:{s:4:"type";s:7:"decimal";s:9:"precision";s:2:"20";s:5:"scale";s:1:"2";}s:12:"pm_overwrite";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";}s:18:"pm_accounting_type";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"10";s:7:"default";s:5:"times";}}s:2:"pk";a:1:{i:0;s:5:"pm_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:8:"pm_title";}s:2:"uc";a:1:{i:0;s:9:"pm_number";}}s:12:"egw_pm_roles";a:5:{s:2:"fd";a:5:{s:7:"role_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:5:"pm_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";}s:10:"role_title";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:16:"role_description";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:8:"role_acl";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:7:"role_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:5:"pm_id";}s:2:"uc";a:0:{}}s:9:"egw_polls";a:5:{s:2:"fd";a:5:{s:7:"poll_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:10:"poll_title";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";s:8:"nullable";b:0;}s:14:"poll_timestamp";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:12:"poll_visible";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:12:"poll_votable";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:7:"poll_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:17:"egw_polls_answers";a:5:{s:2:"fd";a:4:{s:9:"answer_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:7:"poll_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:11:"answer_text";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";s:8:"nullable";b:0;}s:12:"answer_votes";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:9:"answer_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:7:"poll_id";}s:2:"uc";a:0:{}}s:15:"egw_polls_votes";a:5:{s:2:"fd";a:5:{s:7:"poll_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:9:"answer_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:8:"vote_uid";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"vote_ip";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";s:8:"nullable";b:0;}s:14:"vote_timestamp";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}}s:2:"pk";a:4:{i:0;s:7:"poll_id";i:1;s:9:"answer_id";i:2;s:8:"vote_uid";i:3;s:7:"vote_ip";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:15:"egw_preferences";a:5:{s:2:"fd";a:3:{s:16:"preference_owner";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:14:"preference_app";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"25";s:8:"nullable";b:0;}s:16:"preference_value";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:2:{i:0;s:16:"preference_owner";i:1;s:14:"preference_app";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:16:"egw_reg_accounts";a:5:{s:2:"fd";a:5:{s:6:"reg_id";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"32";s:8:"nullable";b:0;}s:7:"reg_lid";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:8:"reg_info";a:1:{s:4:"type";s:4:"text";}s:7:"reg_dla";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:10:"reg_status";a:4:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"1";s:7:"default";s:1:"x";s:8:"nullable";b:0;}}s:2:"pk";a:0:{}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:14:"egw_reg_fields";a:5:{s:2:"fd";a:6:{s:10:"field_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:10:"field_text";a:1:{s:4:"type";s:4:"text";}s:10:"field_type";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:12:"field_values";a:1:{s:4:"type";s:4:"text";}s:14:"field_required";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"1";s:8:"nullable";b:0;}s:11:"field_order";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}}s:2:"pk";a:0:{}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:13:"egw_resources";a:5:{s:2:"fd";a:15:{s:6:"res_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:4:"name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}s:17:"short_description";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}s:6:"cat_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:8:"quantity";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"1";}s:7:"useable";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"1";}s:8:"location";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}s:8:"bookable";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"1";}s:7:"buyable";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"1";}s:5:"prize";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"200";}s:16:"long_description";a:1:{s:4:"type";s:4:"text";}s:11:"picture_src";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"20";}s:12:"accessory_of";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:2:"-1";}s:12:"storage_info";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"200";}s:16:"inventory_number";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"20";}}s:2:"pk";a:1:{i:0;s:6:"res_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:19:"egw_resources_extra";a:5:{s:2:"fd";a:4:{s:8:"extra_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:10:"extra_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"40";s:8:"nullable";b:0;}s:11:"extra_owner";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:2:"-1";s:8:"nullable";b:0;}s:11:"extra_value";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}}s:2:"pk";a:3:{i:0;s:8:"extra_id";i:1;s:10:"extra_name";i:2;s:11:"extra_owner";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:26:"egw_sitemgr_active_modules";a:5:{s:2:"fd";a:3:{s:4:"area";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";s:8:"nullable";b:0;}s:6:"cat_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:9:"module_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}}s:2:"pk";a:3:{i:0;s:4:"area";i:1;s:6:"cat_id";i:2;s:9:"module_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:18:"egw_sitemgr_blocks";a:5:{s:2:"fd";a:7:{s:8:"block_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:4:"area";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";}s:6:"cat_id";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:7:"page_id";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:9:"module_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:10:"sort_order";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:8:"viewable";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}}s:2:"pk";a:1:{i:0;s:8:"block_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:23:"egw_sitemgr_blocks_lang";a:5:{s:2:"fd";a:3:{s:8:"block_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:4:"lang";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";s:8:"nullable";b:0;}s:5:"title";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}}s:2:"pk";a:2:{i:0;s:8:"block_id";i:1;s:4:"lang";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:27:"egw_sitemgr_categories_lang";a:5:{s:2:"fd";a:4:{s:6:"cat_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:4:"lang";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";s:8:"nullable";b:0;}s:4:"name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}s:11:"description";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}}s:2:"pk";a:2:{i:0;s:6:"cat_id";i:1;s:4:"lang";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:28:"egw_sitemgr_categories_state";a:5:{s:2:"fd";a:3:{s:6:"cat_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:5:"state";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:2;}s:13:"index_page_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";}}s:2:"pk";a:1:{i:0;s:6:"cat_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;a:2:{i:0;s:6:"cat_id";i:1;s:5:"state";}}s:2:"uc";a:0:{}}s:19:"egw_sitemgr_content";a:5:{s:2:"fd";a:4:{s:10:"version_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:8:"block_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:9:"arguments";a:1:{s:4:"type";s:4:"text";}s:5:"state";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:2;}}s:2:"pk";a:1:{i:0;s:10:"version_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:24:"egw_sitemgr_content_lang";a:5:{s:2:"fd";a:3:{s:10:"version_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:4:"lang";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";s:8:"nullable";b:0;}s:14:"arguments_lang";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:2:{i:0;s:10:"version_id";i:1;s:4:"lang";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:19:"egw_sitemgr_modules";a:5:{s:2:"fd";a:3:{s:9:"module_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:11:"module_name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"25";}s:11:"description";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}}s:2:"pk";a:1:{i:0;s:9:"module_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:25:"egw_sitemgr_notifications";a:5:{s:2:"fd";a:5:{s:15:"notification_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:7:"site_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:13:"site_language";a:4:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";s:7:"default";s:3:"all";s:8:"nullable";b:0;}s:6:"cat_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:5:"email";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:15:"notification_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:5:"email";}s:2:"uc";a:0:{}}s:27:"egw_sitemgr_notify_messages";a:5:{s:2:"fd";a:5:{s:10:"message_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:7:"site_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:8:"language";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";}s:7:"message";a:1:{s:4:"type";s:4:"text";}s:7:"subject";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:1:{i:0;s:10:"message_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:1:{i:0;a:2:{i:0;s:7:"site_id";i:1;s:8:"language";}}}s:17:"egw_sitemgr_pages";a:5:{s:2:"fd";a:6:{s:7:"page_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:6:"cat_id";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:10:"sort_order";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:9:"hide_page";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:4:"name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}s:5:"state";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:2;}}s:2:"pk";a:1:{i:0;s:7:"page_id";}s:2:"fk";a:0:{}s:2:"ix";a:3:{i:0;s:6:"cat_id";i:1;a:3:{i:0;s:5:"state";i:1;s:6:"cat_id";i:2;s:10:"sort_order";}i:2;a:2:{i:0;s:4:"name";i:1;s:6:"cat_id";}}s:2:"uc";a:0:{}}s:22:"egw_sitemgr_pages_lang";a:5:{s:2:"fd";a:4:{s:7:"page_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:4:"lang";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";s:8:"nullable";b:0;}s:5:"title";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:8:"subtitle";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}}s:2:"pk";a:2:{i:0;s:7:"page_id";i:1;s:4:"lang";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:22:"egw_sitemgr_properties";a:5:{s:2:"fd";a:4:{s:4:"area";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";s:8:"nullable";b:0;}s:6:"cat_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:9:"module_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:10:"properties";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:3:{i:0;s:4:"area";i:1;s:6:"cat_id";i:2;s:9:"module_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:17:"egw_sitemgr_sites";a:5:{s:2:"fd";a:11:{s:7:"site_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:9:"site_name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:8:"site_url";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:8:"site_dir";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:8:"themesel";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";}s:14:"site_languages";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";}s:12:"home_page_id";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:14:"anonymous_user";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";}s:16:"anonymous_passwd";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"50";}s:10:"upload_dir";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:10:"upload_url";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}}s:2:"pk";a:1:{i:0;s:7:"site_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:8:"site_url";}s:2:"uc";a:0:{}}s:9:"egw_sqlfs";a:5:{s:2:"fd";a:15:{s:5:"fs_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:6:"fs_dir";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"fs_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"200";s:8:"nullable";b:0;}s:7:"fs_mode";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:8:"nullable";b:0;}s:6:"fs_uid";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:6:"fs_gid";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:10:"fs_created";a:2:{s:4:"type";s:9:"timestamp";s:8:"nullable";b:0;}s:11:"fs_modified";a:2:{s:4:"type";s:9:"timestamp";s:8:"nullable";b:0;}s:7:"fs_mime";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"96";s:8:"nullable";b:0;}s:7:"fs_size";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:10:"fs_creator";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:11:"fs_modifier";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:9:"fs_active";a:3:{s:4:"type";s:4:"bool";s:7:"default";b:1;s:8:"nullable";b:0;}s:10:"fs_content";a:1:{s:4:"type";s:4:"blob";}s:7:"fs_link";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}}s:2:"pk";a:1:{i:0;s:5:"fs_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;a:3:{i:0;s:6:"fs_dir";i:1;s:9:"fs_active";i:2;s:7:"fs_name";}}s:2:"uc";a:0:{}}s:15:"egw_sqlfs_props";a:5:{s:2:"fd";a:4:{s:5:"fs_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:14:"prop_namespace";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";s:8:"nullable";b:0;}s:9:"prop_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";s:8:"nullable";b:0;}s:10:"prop_value";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:3:{i:0;s:5:"fs_id";i:1;s:14:"prop_namespace";i:2;s:9:"prop_name";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:21:"egw_syncmldeviceowner";a:5:{s:2:"fd";a:3:{s:13:"owner_locname";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"200";s:8:"nullable";b:0;}s:11:"owner_devid";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:14:"owner_deviceid";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";s:8:"nullable";b:0;}}s:2:"pk";a:3:{i:0;s:13:"owner_locname";i:1;s:11:"owner_devid";i:2;s:14:"owner_deviceid";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:14:"owner_deviceid";}s:2:"uc";a:0:{}}s:17:"egw_syncmldevinfo";a:5:{s:2:"fd";a:13:{s:14:"dev_dtdversion";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"10";s:8:"nullable";b:0;}s:19:"dev_numberofchanges";a:2:{s:4:"type";s:4:"bool";s:8:"nullable";b:0;}s:13:"dev_largeobjs";a:2:{s:4:"type";s:4:"bool";s:8:"nullable";b:0;}s:13:"dev_swversion";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}s:7:"dev_oem";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}s:9:"dev_model";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";s:8:"nullable";b:0;}s:16:"dev_manufacturer";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";s:8:"nullable";b:0;}s:14:"dev_devicetype";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";s:8:"nullable";b:0;}s:13:"dev_datastore";a:1:{s:4:"type";s:4:"text";}s:6:"dev_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:13:"dev_fwversion";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}s:13:"dev_hwversion";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";}s:7:"dev_utc";a:2:{s:4:"type";s:4:"bool";s:8:"nullable";b:0;}}s:2:"pk";a:1:{i:0;s:6:"dev_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;a:2:{i:0;s:9:"dev_model";i:1;s:16:"dev_manufacturer";}}s:2:"uc";a:0:{}}s:17:"egw_syncmlsummary";a:5:{s:2:"fd";a:4:{s:6:"dev_id";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}s:9:"sync_path";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"100";s:8:"nullable";b:0;}s:13:"sync_serverts";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"20";s:8:"nullable";b:0;}s:13:"sync_clientts";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"20";s:8:"nullable";b:0;}}s:2:"pk";a:0:{}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:13:"egw_timesheet";a:5:{s:2:"fd";a:14:{s:5:"ts_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:10:"ts_project";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";}s:8:"ts_title";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:14:"ts_description";a:1:{s:4:"type";s:4:"text";}s:8:"ts_start";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:11:"ts_duration";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:11:"ts_quantity";a:3:{s:4:"type";s:5:"float";s:9:"precision";i:-1;s:8:"nullable";b:0;}s:12:"ts_unitprice";a:2:{s:4:"type";s:5:"float";s:9:"precision";i:-1;}s:6:"cat_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";}s:8:"ts_owner";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:11:"ts_modified";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:11:"ts_modifier";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:5:"pl_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";}s:9:"ts_status";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}}s:2:"pk";a:1:{i:0;s:5:"ts_id";}s:2:"fk";a:0:{}s:2:"ix";a:3:{i:0;s:10:"ts_project";i:1;s:8:"ts_owner";i:2;s:9:"ts_status";}s:2:"uc";a:0:{}}s:19:"egw_timesheet_extra";a:5:{s:2:"fd";a:3:{s:5:"ts_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:13:"ts_extra_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"32";s:8:"nullable";b:0;}s:14:"ts_extra_value";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}}s:2:"pk";a:2:{i:0;s:5:"ts_id";i:1;s:13:"ts_extra_name";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:11:"egw_tracker";a:5:{s:2:"fd";a:21:{s:5:"tr_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:10:"tr_summary";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:10:"tr_tracker";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:6:"cat_id";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:10:"tr_version";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:9:"tr_status";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:4:"-100";}s:14:"tr_description";a:1:{s:4:"type";s:4:"text";}s:10:"tr_private";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"0";}s:9:"tr_budget";a:3:{s:4:"type";s:7:"decimal";s:9:"precision";s:2:"20";s:5:"scale";s:1:"2";}s:13:"tr_completion";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"0";}s:10:"tr_creator";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:10:"tr_created";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:11:"tr_modifier";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:11:"tr_modified";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:9:"tr_closed";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:11:"tr_priority";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"5";}s:13:"tr_resolution";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"1";s:7:"default";s:1:"n";}s:5:"tr_cc";a:1:{s:4:"type";s:4:"text";}s:8:"tr_group";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:12:"tr_edit_mode";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";s:7:"default";s:5:"ascii";}s:7:"tr_seen";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:1:{i:0;s:5:"tr_id";}s:2:"fk";a:0:{}s:2:"ix";a:6:{i:0;s:10:"tr_summary";i:1;s:10:"tr_tracker";i:2;s:10:"tr_version";i:3;s:9:"tr_status";i:4;s:8:"tr_group";i:5;a:2:{i:0;s:6:"cat_id";i:1;s:9:"tr_status";}}s:2:"uc";a:0:{}}s:20:"egw_tracker_assignee";a:5:{s:2:"fd";a:2:{s:5:"tr_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:11:"tr_assigned";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}}s:2:"pk";a:2:{i:0;s:5:"tr_id";i:1;s:11:"tr_assigned";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:20:"egw_tracker_bounties";a:5:{s:2:"fd";a:11:{s:9:"bounty_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:5:"tr_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:14:"bounty_creator";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:14:"bounty_created";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:13:"bounty_amount";a:4:{s:4:"type";s:7:"decimal";s:9:"precision";s:2:"20";s:5:"scale";s:1:"2";s:8:"nullable";b:0;}s:11:"bounty_name";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";}s:12:"bounty_email";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:16:"bounty_confirmer";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:16:"bounty_confirmed";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}s:14:"bounty_payedto";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";}s:12:"bounty_payed";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:8;}}s:2:"pk";a:1:{i:0;s:9:"bounty_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;s:5:"tr_id";}s:2:"uc";a:0:{}}s:21:"egw_tracker_escalated";a:5:{s:2:"fd";a:3:{s:5:"tr_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:6:"esc_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:11:"esc_created";a:3:{s:4:"type";s:9:"timestamp";s:7:"default";s:17:"current_timestamp";s:8:"nullable";b:0;}}s:2:"pk";a:2:{i:0;s:5:"tr_id";i:1;s:6:"esc_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:23:"egw_tracker_escalations";a:5:{s:2:"fd";a:17:{s:6:"esc_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:10:"tr_tracker";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:6:"cat_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:10:"tr_version";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:9:"tr_status";a:4:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:11:"tr_priority";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:9:"esc_title";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";s:8:"nullable";b:0;}s:8:"esc_time";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:8:"esc_type";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:1;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:15:"esc_tr_assigned";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";}s:16:"esc_add_assigned";a:1:{s:4:"type";s:4:"bool";}s:14:"esc_tr_tracker";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:10:"esc_cat_id";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:14:"esc_tr_version";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:13:"esc_tr_status";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:15:"esc_tr_priority";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:17:"esc_reply_message";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:1:{i:0;s:6:"esc_id";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:1:{i:0;a:7:{i:0;s:10:"tr_tracker";i:1;s:6:"cat_id";i:2;s:10:"tr_version";i:3;s:9:"tr_status";i:4;s:11:"tr_priority";i:5;s:8:"esc_time";i:6;s:8:"esc_type";}}}s:17:"egw_tracker_extra";a:5:{s:2:"fd";a:3:{s:5:"tr_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:13:"tr_extra_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"64";s:8:"nullable";b:0;}s:14:"tr_extra_value";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:2:{i:0;s:5:"tr_id";i:1;s:13:"tr_extra_name";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:19:"egw_tracker_replies";a:5:{s:2:"fd";a:5:{s:8:"reply_id";a:2:{s:4:"type";s:4:"auto";s:8:"nullable";b:0;}s:5:"tr_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:13:"reply_creator";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:13:"reply_created";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}s:13:"reply_message";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:1:{i:0;s:8:"reply_id";}s:2:"fk";a:0:{}s:2:"ix";a:1:{i:0;a:2:{i:0;s:5:"tr_id";i:1;s:13:"reply_created";}}s:2:"uc";a:0:{}}s:17:"egw_tracker_votes";a:5:{s:2:"fd";a:4:{s:5:"tr_id";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:8:"vote_uid";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:8:"nullable";b:0;}s:7:"vote_ip";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"128";s:8:"nullable";b:0;}s:9:"vote_time";a:3:{s:4:"type";s:3:"int";s:9:"precision";i:8;s:8:"nullable";b:0;}}s:2:"pk";a:3:{i:0;s:5:"tr_id";i:1;s:8:"vote_uid";i:2;s:7:"vote_ip";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:18:"egw_wiki_interwiki";a:5:{s:2:"fd";a:5:{s:7:"wiki_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:16:"interwiki_prefix";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:9:"wiki_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:9:"wiki_lang";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";s:8:"nullable";b:0;}s:13:"interwiki_url";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}}s:2:"pk";a:2:{i:0;s:7:"wiki_id";i:1;s:16:"interwiki_prefix";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:14:"egw_wiki_links";a:5:{s:2:"fd";a:5:{s:7:"wiki_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:9:"wiki_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:9:"wiki_lang";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";s:8:"nullable";b:0;}s:9:"wiki_link";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:10:"wiki_count";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}}s:2:"pk";a:4:{i:0;s:7:"wiki_id";i:1;s:9:"wiki_name";i:2;s:9:"wiki_lang";i:3;s:9:"wiki_link";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:14:"egw_wiki_pages";a:5:{s:2:"fd";a:13:{s:7:"wiki_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:2;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:9:"wiki_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:9:"wiki_lang";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";s:8:"nullable";b:0;}s:12:"wiki_version";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"1";s:8:"nullable";b:0;}s:9:"wiki_time";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:14:"wiki_supercede";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:13:"wiki_readable";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:13:"wiki_writable";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:13:"wiki_username";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";}s:13:"wiki_hostname";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:12:"wiki_comment";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:10:"wiki_title";a:2:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";}s:9:"wiki_body";a:1:{s:4:"type";s:4:"text";}}s:2:"pk";a:4:{i:0;s:7:"wiki_id";i:1;s:9:"wiki_name";i:2;s:9:"wiki_lang";i:3;s:12:"wiki_version";}s:2:"fk";a:0:{}s:2:"ix";a:2:{i:0;s:10:"wiki_title";i:1;s:9:"wiki_body";}s:2:"uc";a:0:{}}s:13:"egw_wiki_rate";a:5:{s:2:"fd";a:5:{s:12:"wiki_rate_ip";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"20";s:8:"nullable";b:0;}s:14:"wiki_rate_time";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:4;}s:19:"wiki_rate_viewLimit";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:2;}s:21:"wiki_rate_searchLimit";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:2;}s:19:"wiki_rate_editLimit";a:2:{s:4:"type";s:3:"int";s:9:"precision";i:2;}}s:2:"pk";a:1:{i:0;s:12:"wiki_rate_ip";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:21:"egw_wiki_remote_pages";a:5:{s:2:"fd";a:2:{s:16:"wiki_remote_page";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:16:"wiki_remote_site";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}}s:2:"pk";a:2:{i:0;s:16:"wiki_remote_page";i:1;s:16:"wiki_remote_site";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}s:19:"egw_wiki_sisterwiki";a:5:{s:2:"fd";a:5:{s:7:"wiki_id";a:4:{s:4:"type";s:3:"int";s:9:"precision";i:4;s:7:"default";s:1:"0";s:8:"nullable";b:0;}s:17:"sisterwiki_prefix";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:9:"wiki_name";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:2:"80";s:8:"nullable";b:0;}s:9:"wiki_lang";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:1:"5";s:8:"nullable";b:0;}s:14:"sisterwiki_url";a:3:{s:4:"type";s:7:"varchar";s:9:"precision";s:3:"255";s:8:"nullable";b:0;}}s:2:"pk";a:2:{i:0;s:7:"wiki_id";i:1;s:17:"sisterwiki_prefix";}s:2:"fk";a:0:{}s:2:"ix";a:0:{}s:2:"uc";a:0:{}}}