a:1:{s:7:"content";a:40:{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:11:"Category id";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:1;O:8:"stdClass":14:{s:4:"name";s:10:"OXPARENTID";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:1;s:13:"default_value";s:8:"oxrootid";s:10:"max_length";s:2:"32";s:5:"scale";N;s:7:"comment";s:18:"Parent category id";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:2;O:8:"stdClass":14:{s:4:"name";s:6:"OXLEFT";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:"0";s:10:"max_length";s:2:"11";s:5:"scale";N;s:7:"comment";s:31:"Used for building category tree";s:12:"characterSet";N;s:9:"collation";N;}i:3;O:8:"stdClass":14:{s:4:"name";s:7:"OXRIGHT";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:"0";s:10:"max_length";s:2:"11";s:5:"scale";N;s:7:"comment";s:31:"Used for building category tree";s:12:"characterSet";N;s:9:"collation";N;}i:4;O:8:"stdClass":13:{s:4:"name";s:8:"OXROOTID";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:"Root category id";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:5;O:8:"stdClass":14:{s:4:"name";s:6:"OXSORT";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:4:"9999";s:10:"max_length";s:2:"11";s:5:"scale";N;s:7:"comment";s:7:"Sorting";s:12:"characterSet";N;s:9:"collation";N;}i:6;O:8:"stdClass":14:{s:4:"name";s:8:"OXACTIVE";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:"1";s:10:"max_length";s:1:"1";s:5:"scale";N;s:7:"comment";s:22:"Active (multilanguage)";s:12:"characterSet";N;s:9:"collation";N;}i:7;O:8:"stdClass":14:{s:4:"name";s:8:"OXHIDDEN";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:77:"Hidden (Can be accessed by direct link, but is not visible in lists and menu)";s:12:"characterSet";N;s:9:"collation";N;}i:8;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;}i:9;O:8:"stdClass":13:{s:4:"name";s:7:"OXTITLE";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:3:"254";s:5:"scale";N;s:7:"comment";s:21:"Title (multilanguage)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:10;O:8:"stdClass":13:{s:4:"name";s:6:"OXDESC";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:3:"255";s:5:"scale";N;s:7:"comment";s:27:"Description (multilanguage)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:11;O:8:"stdClass":13:{s:4:"name";s:10:"OXLONGDESC";s:4:"type";s:4:"text";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";i:10;s:5:"scale";N;s:7:"comment";s:32:"Long description (multilanguage)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:12;O:8:"stdClass":13:{s:4:"name";s:7:"OXTHUMB";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:3:"128";s:5:"scale";N;s:7:"comment";s:34:"Thumbnail filename (multilanguage)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:13;O:8:"stdClass":13:{s:4:"name";s:9:"OXTHUMB_1";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:3:"128";s:5:"scale";N;s:7:"comment";s:0:"";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:14;O:8:"stdClass":13:{s:4:"name";s:9:"OXTHUMB_2";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:3:"128";s:5:"scale";N;s:7:"comment";s:0:"";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:15;O:8:"stdClass":13:{s:4:"name";s:9:"OXTHUMB_3";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:3:"128";s:5:"scale";N;s:7:"comment";s:0:"";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:16;O:8:"stdClass":13:{s:4:"name";s:9:"OXEXTLINK";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:3:"255";s:5:"scale";N;s:7:"comment";s:70:"External link, that if specified is opened instead of category content";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:17;O:8:"stdClass":13:{s:4:"name";s:10:"OXTEMPLATE";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:3:"128";s:5:"scale";N;s:7:"comment";s:57:"Alternative template filename (if empty, default is used)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:18;O:8:"stdClass":13:{s:4:"name";s:9:"OXDEFSORT";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:82:"Default field for sorting of articles in this category (most of oxarticles fields)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:19;O:8:"stdClass":14:{s:4:"name";s:13:"OXDEFSORTMODE";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:72:"Default mode of sorting of articles in this category (0 - asc, 1 - desc)";s:12:"characterSet";N;s:9:"collation";N;}i:20;O:8:"stdClass":14:{s:4:"name";s:11:"OXPRICEFROM";s:4:"type";s:6:"double";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";i:10;s:5:"scale";N;s:7:"comment";s:92:"If specified, all articles, with price higher than specified, will be shown in this category";s:12:"characterSet";N;s:9:"collation";N;}i:21;O:8:"stdClass":14:{s:4:"name";s:9:"OXPRICETO";s:4:"type";s:6:"double";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";i:10;s:5:"scale";N;s:7:"comment";s:91:"If specified, all articles, with price lower than specified, will be shown in this category";s:12:"characterSet";N;s:9:"collation";N;}i:22;O:8:"stdClass":14:{s:4:"name";s:10:"OXACTIVE_1";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:0:"";s:12:"characterSet";N;s:9:"collation";N;}i:23;O:8:"stdClass":13:{s:4:"name";s:9:"OXTITLE_1";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:3:"255";s:5:"scale";N;s:7:"comment";s:0:"";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:24;O:8:"stdClass":13:{s:4:"name";s:8:"OXDESC_1";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:3:"255";s:5:"scale";N;s:7:"comment";s:0:"";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:25;O:8:"stdClass":13:{s:4:"name";s:12:"OXLONGDESC_1";s:4:"type";s:4:"text";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";i:10;s:5:"scale";N;s:7:"comment";s:0:"";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:26;O:8:"stdClass":14:{s:4:"name";s:10:"OXACTIVE_2";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:0:"";s:12:"characterSet";N;s:9:"collation";N;}i:27;O:8:"stdClass":13:{s:4:"name";s:9:"OXTITLE_2";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:3:"255";s:5:"scale";N;s:7:"comment";s:0:"";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:28;O:8:"stdClass":13:{s:4:"name";s:8:"OXDESC_2";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:3:"255";s:5:"scale";N;s:7:"comment";s:0:"";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:29;O:8:"stdClass":13:{s:4:"name";s:12:"OXLONGDESC_2";s:4:"type";s:4:"text";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";i:10;s:5:"scale";N;s:7:"comment";s:0:"";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:30;O:8:"stdClass":14:{s:4:"name";s:10:"OXACTIVE_3";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:0:"";s:12:"characterSet";N;s:9:"collation";N;}i:31;O:8:"stdClass":13:{s:4:"name";s:9:"OXTITLE_3";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:3:"255";s:5:"scale";N;s:7:"comment";s:0:"";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:32;O:8:"stdClass":13:{s:4:"name";s:8:"OXDESC_3";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:3:"255";s:5:"scale";N;s:7:"comment";s:0:"";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:33;O:8:"stdClass":13:{s:4:"name";s:12:"OXLONGDESC_3";s:4:"type";s:4:"text";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";i:10;s:5:"scale";N;s:7:"comment";s:0:"";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:34;O:8:"stdClass":13:{s:4:"name";s:6:"OXICON";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:3:"128";s:5:"scale";N;s:7:"comment";s:13:"Icon filename";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:35;O:8:"stdClass":13:{s:4:"name";s:11:"OXPROMOICON";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:3:"128";s:5:"scale";N;s:7:"comment";s:23:"Promotion icon filename";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:36;O:8:"stdClass":14:{s:4:"name";s:5:"OXVAT";s:4:"type";s:5:"float";s:8:"not_null";b:0;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:4:"NULL";s:10:"max_length";i:10;s:5:"scale";N;s:7:"comment";s:77:"VAT, used for articles in this category (only if oxarticles.oxvat is not set)";s:12:"characterSet";N;s:9:"collation";N;}i:37;O:8:"stdClass":14:{s:4:"name";s:15:"OXSKIPDISCOUNTS";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:94:"Skip all negative Discounts for articles in this category (Discounts, Vouchers, Delivery ...) ";s:12:"characterSet";N;s:9:"collation";N;}i:38;O:8:"stdClass":14:{s:4:"name";s:12:"OXSHOWSUFFIX";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:"1";s:10:"max_length";s:1:"1";s:5:"scale";N;s:7:"comment";s:27:"Show SEO Suffix in Category";s:12:"characterSet";N;s:9:"collation";N;}i:39;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;}}}