a:1:{s:7:"content";a:12:{i:0;O:8:"stdClass":13:{s:4:"name";s:4:"OXID";s:4:"type";s:4:"char";s:8:"not_null";b:1;s:11:"primary_key";b:1;s:14:"auto_increment";b:0;s:6:"binary";b:0;s:8:"unsigned";b:0;s:11:"has_default";b:0;s:10:"max_length";s:2:"32";s:5:"scale";N;s:7:"comment";s:15:"Subscription id";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:1;O:8:"stdClass":13:{s:4:"name";s:8:"OXUSERID";s:4:"type";s:4:"char";s:8:"not_null";b:1;s:11:"primary_key";b:0;s:14:"auto_increment";b:0;s:6:"binary";b:0;s:8:"unsigned";b:0;s:11:"has_default";b:0;s:10:"max_length";s:2:"32";s:5:"scale";N;s:7:"comment";s:16:"User id (oxuser)";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:2;O:8:"stdClass":13:{s:4:"name";s:5:"OXSAL";s:4:"type";s:7:"varchar";s:8:"not_null";b:1;s:11:"primary_key";b:0;s:14:"auto_increment";b:0;s:6:"binary";b:0;s:8:"unsigned";b:0;s:11:"has_default";b:0;s:10:"max_length";s:2:"64";s:5:"scale";N;s:7:"comment";s:26:"User title prefix (Mr/Mrs)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:3;O:8:"stdClass":13:{s:4:"name";s:7:"OXFNAME";s:4:"type";s:4:"char";s:8:"not_null";b:1;s:11:"primary_key";b:0;s:14:"auto_increment";b:0;s:6:"binary";b:0;s:8:"unsigned";b:0;s:11:"has_default";b:0;s:10:"max_length";s:3:"128";s:5:"scale";N;s:7:"comment";s:10:"First name";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:4;O:8:"stdClass":13:{s:4:"name";s:7:"OXLNAME";s:4:"type";s:4:"char";s:8:"not_null";b:1;s:11:"primary_key";b:0;s:14:"auto_increment";b:0;s:6:"binary";b:0;s:8:"unsigned";b:0;s:11:"has_default";b:0;s:10:"max_length";s:3:"128";s:5:"scale";N;s:7:"comment";s:9:"Last name";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:5;O:8:"stdClass":13:{s:4:"name";s:7:"OXEMAIL";s:4:"type";s:4:"char";s:8:"not_null";b:1;s:11:"primary_key";b:0;s:14:"auto_increment";b:0;s:6:"binary";b:0;s:8:"unsigned";b:0;s:11:"has_default";b:0;s:10:"max_length";s:3:"128";s:5:"scale";N;s:7:"comment";s:5:"Email";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:6;O:8:"stdClass":14:{s:4:"name";s:9:"OXDBOPTIN";s:4:"type";s:7:"tinyint";s:8:"not_null";b:1;s:11:"primary_key";b:0;s:14:"auto_increment";b:0;s:6:"binary";b:0;s:8:"unsigned";b:0;s:11:"has_default";b:1;s:13:"default_value";s:1:"0";s:10:"max_length";s:1:"1";s:5:"scale";N;s:7:"comment";s:74:"Subscription status: 0 - not subscribed, 1 - subscribed, 2 - not confirmed";s:12:"characterSet";N;s:9:"collation";N;}i:7;O:8:"stdClass":14:{s:4:"name";s:13:"OXEMAILFAILED";s:4:"type";s:7:"tinyint";s:8:"not_null";b:1;s:11:"primary_key";b:0;s:14:"auto_increment";b:0;s:6:"binary";b:0;s:8:"unsigned";b:0;s:11:"has_default";b:1;s:13:"default_value";s:1:"0";s:10:"max_length";s:1:"1";s:5:"scale";N;s:7:"comment";s:33:"Subscription email sending status";s:12:"characterSet";N;s:9:"collation";N;}i:8;O:8:"stdClass":14:{s:4:"name";s:12:"OXSUBSCRIBED";s:4:"type";s:8:"datetime";s:8:"not_null";b:1;s:11:"primary_key";b:0;s:14:"auto_increment";b:0;s:6:"binary";b:0;s:8:"unsigned";b:0;s:11:"has_default";b:1;s:13:"default_value";s:19:"0000-00-00 00:00:00";s:10:"max_length";i:20;s:5:"scale";N;s:7:"comment";s:17:"Subscription date";s:12:"characterSet";N;s:9:"collation";N;}i:9;O:8:"stdClass":14:{s:4:"name";s:14:"OXUNSUBSCRIBED";s:4:"type";s:8:"datetime";s:8:"not_null";b:1;s:11:"primary_key";b:0;s:14:"auto_increment";b:0;s:6:"binary";b:0;s:8:"unsigned";b:0;s:11:"has_default";b:1;s:13:"default_value";s:19:"0000-00-00 00:00:00";s:10:"max_length";i:20;s:5:"scale";N;s:7:"comment";s:19:"Unsubscription date";s:12:"characterSet";N;s:9:"collation";N;}i:10;O:8:"stdClass":14:{s:4:"name";s:11:"OXTIMESTAMP";s:4:"type";s:9:"timestamp";s:8:"not_null";b:1;s:11:"primary_key";b:0;s:14:"auto_increment";b:0;s:6:"binary";b:0;s:8:"unsigned";b:0;s:11:"has_default";b:1;s:13:"default_value";s:19:"current_timestamp()";s:10:"max_length";i:10;s:5:"scale";N;s:7:"comment";s:9:"Timestamp";s:12:"characterSet";N;s:9:"collation";N;}i:11;O:8:"stdClass":14:{s:4:"name";s:8:"OXSHOPID";s:4:"type";s:3:"int";s:8:"not_null";b:1;s:11:"primary_key";b:0;s:14:"auto_increment";b:0;s:6:"binary";b:0;s:8:"unsigned";b:0;s:11:"has_default";b:1;s:13:"default_value";s:1:"1";s:10:"max_length";s:2:"11";s:5:"scale";N;s:7:"comment";s:17:"Shop id (oxshops)";s:12:"characterSet";N;s:9:"collation";N;}}}