a:1:{s:7:"content";a:113:{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:10:"Article 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: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:2;O:8:"stdClass":13:{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:0;s:10:"max_length";s:2:"32";s:5:"scale";N;s:7:"comment";s:17:"Parent article id";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:3;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:6:"Active";s:12:"characterSet";N;s:9:"collation";N;}i:4;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:6:"Hidden";s:12:"characterSet";N;s:9:"collation";N;}i:5;O:8:"stdClass":14:{s:4:"name";s:12:"OXACTIVEFROM";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:26:"Active from specified date";s:12:"characterSet";N;s:9:"collation";N;}i:6;O:8:"stdClass":14:{s:4:"name";s:10:"OXACTIVETO";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:24:"Active to specified date";s:12:"characterSet";N;s:9:"collation";N;}i:7;O:8:"stdClass":13:{s:4:"name";s:8:"OXARTNUM";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:14:"Article number";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:8;O:8:"stdClass":13:{s:4:"name";s:5:"OXEAN";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:"International Article Number (EAN)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:9;O:8:"stdClass":13:{s:4:"name";s:9:"OXDISTEAN";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:51:"Manufacture International Article Number (Man. EAN)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:10;O:8:"stdClass":13:{s:4:"name";s:5:"OXMPN";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:"100";s:5:"scale";N;s:7:"comment";s:29:"Manufacture Part Number (MPN)";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:11;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:"255";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:12;O:8:"stdClass":13:{s:4:"name";s:11:"OXSHORTDESC";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:33:"Short description (multilanguage)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:13;O:8:"stdClass":14:{s:4:"name";s:7:"OXPRICE";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:13:"Article Price";s:12:"characterSet";N;s:9:"collation";N;}i:14;O:8:"stdClass":14:{s:4:"name";s:14:"OXBLFIXEDPRICE";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:28:"No Promotions (Price Alert) ";s:12:"characterSet";N;s:9:"collation";N;}i:15;O:8:"stdClass":14:{s:4:"name";s:8:"OXPRICEA";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:7:"Price A";s:12:"characterSet";N;s:9:"collation";N;}i:16;O:8:"stdClass":14:{s:4:"name";s:8:"OXPRICEB";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:7:"Price B";s:12:"characterSet";N;s:9:"collation";N;}i:17;O:8:"stdClass":14:{s:4:"name";s:8:"OXPRICEC";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:7:"Price C";s:12:"characterSet";N;s:9:"collation";N;}i:18;O:8:"stdClass":14:{s:4:"name";s:8:"OXBPRICE";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:14:"Purchase Price";s:12:"characterSet";N;s:9:"collation";N;}i:19;O:8:"stdClass":14:{s:4:"name";s:8:"OXTPRICE";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:30:"Recommended Retail Price (RRP)";s:12:"characterSet";N;s:9:"collation";N;}i:20;O:8:"stdClass":13:{s:4:"name";s:10:"OXUNITNAME";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:"32";s:5:"scale";N;s:7:"comment";s:78:"Unit name (kg,g,l,cm etc), used in setting price per quantity unit calculation";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:21;O:8:"stdClass":14:{s:4:"name";s:14:"OXUNITQUANTITY";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:69:"Article quantity, used in setting price per quantity unit calculation";s:12:"characterSet";N;s:9:"collation";N;}i:22;O:8:"stdClass":13:{s:4:"name";s:8:"OXEXTURL";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:51:"External URL to other information about the article";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:23;O:8:"stdClass":13:{s:4:"name";s:9:"OXURLDESC";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:37:"Text for external URL (multilanguage)";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:"OXURLIMG";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:18:"External URL image";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:25;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:"Value added tax. If specified, used in all calculations instead of global vat";s:12:"characterSet";N;s:9:"collation";N;}i:26;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:18:"Thumbnail filename";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:27;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:28;O:8:"stdClass":13:{s:4:"name";s:6:"OXPIC1";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:19:"1# Picture filename";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:29;O:8:"stdClass":13:{s:4:"name";s:6:"OXPIC2";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:19:"2# Picture filename";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:30;O:8:"stdClass":13:{s:4:"name";s:6:"OXPIC3";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:19:"3# Picture filename";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:31;O:8:"stdClass":13:{s:4:"name";s:6:"OXPIC4";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:19:"4# Picture filename";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:32;O:8:"stdClass":13:{s:4:"name";s:6:"OXPIC5";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:19:"5# Picture filename";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:33;O:8:"stdClass":13:{s:4:"name";s:6:"OXPIC6";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:19:"6# Picture filename";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:"OXPIC7";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:19:"7# Picture 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:6:"OXPIC8";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:19:"8# Picture filename";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:36;O:8:"stdClass":13:{s:4:"name";s:6:"OXPIC9";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:19:"9# Picture filename";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:37;O:8:"stdClass":13:{s:4:"name";s:7:"OXPIC10";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:20:"10# Picture filename";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:38;O:8:"stdClass":13:{s:4:"name";s:7:"OXPIC11";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:20:"11# Picture filename";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:39;O:8:"stdClass":13:{s:4:"name";s:7:"OXPIC12";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:20:"12# Picture filename";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:40;O:8:"stdClass":14:{s:4:"name";s:8:"OXWEIGHT";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:11:"Weight (kg)";s:12:"characterSet";N;s:9:"collation";N;}i:41;O:8:"stdClass":14:{s:4:"name";s:7:"OXSTOCK";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:25:"Article quantity in stock";s:12:"characterSet";N;s:9:"collation";N;}i:42;O:8:"stdClass":14:{s:4:"name";s:11:"OXSTOCKFLAG";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:120:"Delivery Status: 1 - Standard, 2 - If out of Stock, offline, 3 - If out of Stock, not orderable, 4 - External Storehouse";s:12:"characterSet";N;s:9:"collation";N;}i:43;O:8:"stdClass":13:{s:4:"name";s:11:"OXSTOCKTEXT";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:66:"Message, which is shown if the article is in stock (multilanguage)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:44;O:8:"stdClass":13:{s:4:"name";s:13:"OXNOSTOCKTEXT";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:67:"Message, which is shown if the article is off stock (multilanguage)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:45;O:8:"stdClass":14:{s:4:"name";s:10:"OXDELIVERY";s:4:"type";s:4:"date";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:10:"0000-00-00";s:10:"max_length";i:10;s:5:"scale";N;s:7:"comment";s:64:"Date, when the product will be available again if it is sold out";s:12:"characterSet";N;s:9:"collation";N;}i:46;O:8:"stdClass":14:{s:4:"name";s:8:"OXINSERT";s:4:"type";s:4:"date";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:10:"0000-00-00";s:10:"max_length";i:10;s:5:"scale";N;s:7:"comment";s:13:"Creation time";s:12:"characterSet";N;s:9:"collation";N;}i:47;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:48;O:8:"stdClass":14:{s:4:"name";s:8:"OXLENGTH";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:26:"Article dimensions: Length";s:12:"characterSet";N;s:9:"collation";N;}i:49;O:8:"stdClass":14:{s:4:"name";s:7:"OXWIDTH";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:25:"Article dimensions: Width";s:12:"characterSet";N;s:9:"collation";N;}i:50;O:8:"stdClass":14:{s:4:"name";s:8:"OXHEIGHT";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:26:"Article dimensions: Height";s:12:"characterSet";N;s:9:"collation";N;}i:51;O:8:"stdClass":13:{s:4:"name";s:6:"OXFILE";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:33:"File, shown in article media list";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:52;O:8:"stdClass":13:{s:4:"name";s:12:"OXSEARCHKEYS";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:28:"Search terms (multilanguage)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:53;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:54;O:8:"stdClass":13:{s:4:"name";s:15:"OXQUESTIONEMAIL";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:19:"E-mail for question";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:55;O:8:"stdClass":14:{s:4:"name";s:10:"OXISSEARCH";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:33:"Should article be shown in search";s:12:"characterSet";N;s:9:"collation";N;}i:56;O:8:"stdClass":14:{s:4:"name";s:16:"OXISCONFIGURABLE";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:"4";s:5:"scale";N;s:7:"comment";s:25:"Can article be customized";s:12:"characterSet";N;s:9:"collation";N;}i:57;O:8:"stdClass":13:{s:4:"name";s:9:"OXVARNAME";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:86:"Name of variants selection lists (different lists are separated by | ) (multilanguage)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:58;O:8:"stdClass":14:{s:4:"name";s:10:"OXVARSTOCK";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:1:"5";s:5:"scale";N;s:7:"comment";s:45:"Sum of active article variants stock quantity";s:12:"characterSet";N;s:9:"collation";N;}i:59;O:8:"stdClass":14:{s:4:"name";s:10:"OXVARCOUNT";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:1:"1";s:5:"scale";N;s:7:"comment";s:63:"Total number of variants that article has (active and inactive)";s:12:"characterSet";N;s:9:"collation";N;}i:60;O:8:"stdClass":13:{s:4:"name";s:11:"OXVARSELECT";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:60:"Variant article selections (separated by | ) (multilanguage)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:61;O:8:"stdClass":14:{s:4:"name";s:13:"OXVARMINPRICE";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:39:"Lowest price in active article variants";s:12:"characterSet";N;s:9:"collation";N;}i:62;O:8:"stdClass":14:{s:4:"name";s:13:"OXVARMAXPRICE";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:40:"Highest price in active article variants";s:12:"characterSet";N;s:9:"collation";N;}i:63;O:8:"stdClass":13:{s:4:"name";s:11:"OXVARNAME_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:64;O:8:"stdClass":13:{s:4:"name";s:13:"OXVARSELECT_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:65;O:8:"stdClass":13:{s:4:"name";s:11:"OXVARNAME_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:66;O:8:"stdClass":13:{s:4:"name";s:13:"OXVARSELECT_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:67;O:8:"stdClass":13:{s:4:"name";s:11:"OXVARNAME_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:68;O:8:"stdClass":13:{s:4:"name";s:13:"OXVARSELECT_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:69;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:70;O:8:"stdClass":13:{s:4:"name";s:13:"OXSHORTDESC_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:71;O:8:"stdClass":13:{s:4:"name";s:11:"OXURLDESC_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:72;O:8:"stdClass":13:{s:4:"name";s:14:"OXSEARCHKEYS_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:73;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:74;O:8:"stdClass":13:{s:4:"name";s:13:"OXSHORTDESC_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:75;O:8:"stdClass":13:{s:4:"name";s:11:"OXURLDESC_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:76;O:8:"stdClass":13:{s:4:"name";s:14:"OXSEARCHKEYS_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:77;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:78;O:8:"stdClass":13:{s:4:"name";s:13:"OXSHORTDESC_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:79;O:8:"stdClass":13:{s:4:"name";s:11:"OXURLDESC_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:80;O:8:"stdClass":13:{s:4:"name";s:14:"OXSEARCHKEYS_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:81;O:8:"stdClass":13:{s:4:"name";s:10:"OXBUNDLEID";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:"32";s:5:"scale";N;s:7:"comment";s:18:"Bundled article id";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:82;O:8:"stdClass":13:{s:4:"name";s:8:"OXFOLDER";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:"32";s:5:"scale";N;s:7:"comment";s:6:"Folder";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:83;O:8:"stdClass":13:{s:4:"name";s:10:"OXSUBCLASS";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:"32";s:5:"scale";N;s:7:"comment";s:8:"Subclass";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:84;O:8:"stdClass":13:{s:4:"name";s:13:"OXSTOCKTEXT_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:85;O:8:"stdClass":13:{s:4:"name";s:13:"OXSTOCKTEXT_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:86;O:8:"stdClass":13:{s:4:"name";s:13:"OXSTOCKTEXT_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:87;O:8:"stdClass":13:{s:4:"name";s:15:"OXNOSTOCKTEXT_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:88;O:8:"stdClass":13:{s:4:"name";s:15:"OXNOSTOCKTEXT_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:89;O:8:"stdClass":13:{s:4:"name";s:15:"OXNOSTOCKTEXT_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:90;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:1:"0";s:10:"max_length";s:1:"5";s:5:"scale";N;s:7:"comment";s:7:"Sorting";s:12:"characterSet";N;s:9:"collation";N;}i:91;O:8:"stdClass":14:{s:4:"name";s:12:"OXSOLDAMOUNT";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:74:"Amount of sold articles including variants (used only for parent articles)";s:12:"characterSet";N;s:9:"collation";N;}i:92;O:8:"stdClass":14:{s:4:"name";s:13:"OXNONMATERIAL";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:1:"1";s:5:"scale";N;s:7:"comment";s:76:"Intangible article, free shipping is used (variants inherits parent setting)";s:12:"characterSet";N;s:9:"collation";N;}i:93;O:8:"stdClass":14:{s:4:"name";s:14:"OXFREESHIPPING";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:1:"1";s:5:"scale";N;s:7:"comment";s:48:"Free shipping (variants inherits parent setting)";s:12:"characterSet";N;s:9:"collation";N;}i:94;O:8:"stdClass":14:{s:4:"name";s:14:"OXREMINDACTIVE";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:1:"1";s:5:"scale";N;s:7:"comment";s:95:"Enables sending of notification email when oxstock field value falls below oxremindamount value";s:12:"characterSet";N;s:9:"collation";N;}i:95;O:8:"stdClass":14:{s:4:"name";s:14:"OXREMINDAMOUNT";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:93:"Defines the amount, below which notification email will be sent if oxremindactive is set to 1";s:12:"characterSet";N;s:9:"collation";N;}i:96;O:8:"stdClass":13:{s:4:"name";s:10:"OXAMITEMID";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:"32";s:5:"scale";N;s:7:"comment";s:0:"";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:97;O:8:"stdClass":14:{s:4:"name";s:10:"OXAMTASKID";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:1;s:13:"default_value";s:1:"0";s:10:"max_length";s:2:"16";s:5:"scale";N;s:7:"comment";s:0:"";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:98;O:8:"stdClass":13:{s:4:"name";s:10:"OXVENDORID";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:20:"Vendor id (oxvendor)";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:99;O:8:"stdClass":13:{s:4:"name";s:16:"OXMANUFACTURERID";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:33:"Manufacturer id (oxmanufacturers)";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:100;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:64:"Skips all negative Discounts (Discounts, Vouchers, Delivery ...)";s:12:"characterSet";N;s:9:"collation";N;}i:101;O:8:"stdClass":14:{s:4:"name";s:8:"OXRATING";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:14:"Article rating";s:12:"characterSet";N;s:9:"collation";N;}i:102;O:8:"stdClass":14:{s:4:"name";s:11:"OXRATINGCNT";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:18:"Rating votes count";s:12:"characterSet";N;s:9:"collation";N;}i:103;O:8:"stdClass":14:{s:4:"name";s:12:"OXMINDELTIME";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:52:"Minimal delivery time (unit is set in oxdeltimeunit)";s:12:"characterSet";N;s:9:"collation";N;}i:104;O:8:"stdClass":14:{s:4:"name";s:12:"OXMAXDELTIME";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:52:"Maximum delivery time (unit is set in oxdeltimeunit)";s:12:"characterSet";N;s:9:"collation";N;}i:105;O:8:"stdClass":13:{s:4:"name";s:13:"OXDELTIMEUNIT";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:36:"Delivery time unit: DAY, WEEK, MONTH";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:106;O:8:"stdClass":14:{s:4:"name";s:13:"OXUPDATEPRICE";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:73:"If not 0, oxprice will be updated to this value on oxupdatepricetime date";s:12:"characterSet";N;s:9:"collation";N;}i:107;O:8:"stdClass":14:{s:4:"name";s:14:"OXUPDATEPRICEA";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:74:"If not 0, oxpricea will be updated to this value on oxupdatepricetime date";s:12:"characterSet";N;s:9:"collation";N;}i:108;O:8:"stdClass":14:{s:4:"name";s:14:"OXUPDATEPRICEB";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:74:"If not 0, oxpriceb will be updated to this value on oxupdatepricetime date";s:12:"characterSet";N;s:9:"collation";N;}i:109;O:8:"stdClass":14:{s:4:"name";s:14:"OXUPDATEPRICEC";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:74:"If not 0, oxpricec will be updated to this value on oxupdatepricetime date";s:12:"characterSet";N;s:9:"collation";N;}i:110;O:8:"stdClass":13:{s:4:"name";s:17:"OXUPDATEPRICETIME";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:0;s:10:"max_length";i:10;s:5:"scale";N;s:7:"comment";s:74:"Date, when oxprice[a,b,c] should be updated to oxupdateprice[a,b,c] values";s:12:"characterSet";N;s:9:"collation";N;}i:111;O:8:"stdClass":14:{s:4:"name";s:16:"OXISDOWNLOADABLE";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:1;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:41:"Enable download of files for this product";s:12:"characterSet";N;s:9:"collation";N;}i:112;O:8:"stdClass":14:{s:4:"name";s:21:"OXSHOWCUSTOMAGREEMENT";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:1;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:39:"Show custom agreement check in checkout";s:12:"characterSet";N;s:9:"collation";N;}}}