a:1:{s:7:"content";a:76:{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:8:"Order 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: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:3;O:8:"stdClass":14:{s:4:"name";s:11:"OXORDERDATE";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:-1;s:5:"scale";N;s:7:"comment";s:10:"Order date";s:12:"characterSet";N;s:9:"collation";N;}i:4;O:8:"stdClass":14:{s:4:"name";s:9:"OXORDERNR";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:1;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:12:"Order number";s:12:"characterSet";N;s:9:"collation";N;}i:5;O:8:"stdClass":13:{s:4:"name";s:13:"OXBILLCOMPANY";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:26:"Billing info: Company name";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:6;O:8:"stdClass":13:{s:4:"name";s:11:"OXBILLEMAIL";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:"Billing info: Email";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:7;O:8:"stdClass":13:{s:4:"name";s:11:"OXBILLFNAME";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:24:"Billing info: First name";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:8;O:8:"stdClass":13:{s:4:"name";s:11:"OXBILLLNAME";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:23:"Billing info: Last name";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:9;O:8:"stdClass":13:{s:4:"name";s:12:"OXBILLSTREET";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:25:"Billing info: Street name";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:10;O:8:"stdClass":13:{s:4:"name";s:14:"OXBILLSTREETNR";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:"16";s:5:"scale";N;s:7:"comment";s:26:"Billing info: House number";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:11;O:8:"stdClass":13:{s:4:"name";s:13:"OXBILLADDINFO";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:29:"Billing info: Additional info";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:"OXBILLUSTID";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:24:"Billing info: VAT ID No.";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:13;O:8:"stdClass":13:{s:4:"name";s:10:"OXBILLCITY";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:18:"Billing info: City";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:14;O:8:"stdClass":13:{s:4:"name";s:15:"OXBILLCOUNTRYID";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:36:"Billing info: Country id (oxcountry)";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:15;O:8:"stdClass":13:{s:4:"name";s:13:"OXBILLSTATEID";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:36:"Billing info: US State id (oxstates)";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:16;O:8:"stdClass":13:{s:4:"name";s:9:"OXBILLZIP";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:"16";s:5:"scale";N;s:7:"comment";s:22:"Billing info: Zip code";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:17;O:8:"stdClass":13:{s:4:"name";s:9:"OXBILLFON";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:26:"Billing info: Phone number";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:"OXBILLFAX";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:24:"Billing info: Fax number";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:19;O:8:"stdClass":13:{s:4:"name";s:9:"OXBILLSAL";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:40:"Billing info: User title prefix (Mr/Mrs)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:20;O:8:"stdClass":13:{s:4:"name";s:12:"OXDELCOMPANY";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:"Shipping info: Company name";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:21;O:8:"stdClass":13:{s:4:"name";s:10:"OXDELFNAME";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:25:"Shipping info: First name";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:22;O:8:"stdClass":13:{s:4:"name";s:10:"OXDELLNAME";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:24:"Shipping info: Last name";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:23;O:8:"stdClass":13:{s:4:"name";s:11:"OXDELSTREET";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:26:"Shipping info: Street name";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:24;O:8:"stdClass":13:{s:4:"name";s:13:"OXDELSTREETNR";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:"16";s:5:"scale";N;s:7:"comment";s:27:"Shipping info: House number";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:"OXDELADDINFO";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:30:"Shipping info: Additional info";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:26;O:8:"stdClass":13:{s:4:"name";s:9:"OXDELCITY";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:"Shipping info: City";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:27;O:8:"stdClass":13:{s:4:"name";s:14:"OXDELCOUNTRYID";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:37:"Shipping info: Country id (oxcountry)";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:28;O:8:"stdClass":13:{s:4:"name";s:12:"OXDELSTATEID";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:37:"Shipping info: US State id (oxstates)";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:29;O:8:"stdClass":13:{s:4:"name";s:8:"OXDELZIP";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:"16";s:5:"scale";N;s:7:"comment";s:23:"Shipping info: Zip code";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:30;O:8:"stdClass":13:{s:4:"name";s:8:"OXDELFON";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:27:"Shipping info: Phone number";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:31;O:8:"stdClass":13:{s:4:"name";s:8:"OXDELFAX";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:25:"Shipping info: Fax number";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:"OXDELSAL";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:41:"Shipping info: User title prefix (Mr/Mrs)";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:33;O:8:"stdClass":13:{s:4:"name";s:11:"OXPAYMENTID";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:32:"User payment id (oxuserpayments)";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:34;O:8:"stdClass":13:{s:4:"name";s:13:"OXPAYMENTTYPE";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:23:"Payment id (oxpayments)";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:35;O:8:"stdClass":14:{s:4:"name";s:13:"OXTOTALNETSUM";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:-1;s:5:"scale";N;s:7:"comment";s:13:"Total net sum";s:12:"characterSet";N;s:9:"collation";N;}i:36;O:8:"stdClass":14:{s:4:"name";s:14:"OXTOTALBRUTSUM";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:-1;s:5:"scale";N;s:7:"comment";s:14:"Total brut sum";s:12:"characterSet";N;s:9:"collation";N;}i:37;O:8:"stdClass":14:{s:4:"name";s:15:"OXTOTALORDERSUM";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:-1;s:5:"scale";N;s:7:"comment";s:15:"Total order sum";s:12:"characterSet";N;s:9:"collation";N;}i:38;O:8:"stdClass":14:{s:4:"name";s:9:"OXARTVAT1";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:-1;s:5:"scale";N;s:7:"comment";s:9:"First VAT";s:12:"characterSet";N;s:9:"collation";N;}i:39;O:8:"stdClass":14:{s:4:"name";s:14:"OXARTVATPRICE1";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:-1;s:5:"scale";N;s:7:"comment";s:26:"First calculated VAT price";s:12:"characterSet";N;s:9:"collation";N;}i:40;O:8:"stdClass":14:{s:4:"name";s:9:"OXARTVAT2";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:-1;s:5:"scale";N;s:7:"comment";s:10:"Second VAT";s:12:"characterSet";N;s:9:"collation";N;}i:41;O:8:"stdClass":14:{s:4:"name";s:14:"OXARTVATPRICE2";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:-1;s:5:"scale";N;s:7:"comment";s:27:"Second calculated VAT price";s:12:"characterSet";N;s:9:"collation";N;}i:42;O:8:"stdClass":14:{s:4:"name";s:9:"OXDELCOST";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:-1;s:5:"scale";N;s:7:"comment";s:14:"Delivery price";s:12:"characterSet";N;s:9:"collation";N;}i:43;O:8:"stdClass":14:{s:4:"name";s:8:"OXDELVAT";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:-1;s:5:"scale";N;s:7:"comment";s:12:"Delivery VAT";s:12:"characterSet";N;s:9:"collation";N;}i:44;O:8:"stdClass":14:{s:4:"name";s:9:"OXPAYCOST";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:-1;s:5:"scale";N;s:7:"comment";s:12:"Payment cost";s:12:"characterSet";N;s:9:"collation";N;}i:45;O:8:"stdClass":14:{s:4:"name";s:8:"OXPAYVAT";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:-1;s:5:"scale";N;s:7:"comment";s:11:"Payment VAT";s:12:"characterSet";N;s:9:"collation";N;}i:46;O:8:"stdClass":14:{s:4:"name";s:10:"OXWRAPCOST";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:-1;s:5:"scale";N;s:7:"comment";s:13:"Wrapping cost";s:12:"characterSet";N;s:9:"collation";N;}i:47;O:8:"stdClass":14:{s:4:"name";s:9:"OXWRAPVAT";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:-1;s:5:"scale";N;s:7:"comment";s:12:"Wrapping VAT";s:12:"characterSet";N;s:9:"collation";N;}i:48;O:8:"stdClass":14:{s:4:"name";s:14:"OXGIFTCARDCOST";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:-1;s:5:"scale";N;s:7:"comment";s:13:"Giftcard cost";s:12:"characterSet";N;s:9:"collation";N;}i:49;O:8:"stdClass":14:{s:4:"name";s:13:"OXGIFTCARDVAT";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:-1;s:5:"scale";N;s:7:"comment";s:12:"Giftcard VAT";s:12:"characterSet";N;s:9:"collation";N;}i:50;O:8:"stdClass":13:{s:4:"name";s:8:"OXCARDID";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:25:"Gift card id (oxwrapping)";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:51;O:8:"stdClass":13:{s:4:"name";s:10:"OXCARDTEXT";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:-1;s:5:"scale";N;s:7:"comment";s:14:"Gift card text";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:52;O:8:"stdClass":14:{s:4:"name";s:10:"OXDISCOUNT";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:-1;s:5:"scale";N;s:7:"comment";s:35:"Additional discount for order (abs)";s:12:"characterSet";N;s:9:"collation";N;}i:53;O:8:"stdClass":14:{s:4:"name";s:8:"OXEXPORT";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:11:"Is exported";s:12:"characterSet";N;s:9:"collation";N;}i:54;O:8:"stdClass":13:{s:4:"name";s:8:"OXBILLNR";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:11:"Invoice No.";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:"OXBILLDATE";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:-1;s:5:"scale";N;s:7:"comment";s:17:"Invoice sent date";s:12:"characterSet";N;s:9:"collation";N;}i:56;O:8:"stdClass":13:{s:4:"name";s:11:"OXTRACKCODE";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:"Tracking code";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:57;O:8:"stdClass":14:{s:4:"name";s:10:"OXSENDDATE";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:-1;s:5:"scale";N;s:7:"comment";s:19:"Order shipping date";s:12:"characterSet";N;s:9:"collation";N;}i:58;O:8:"stdClass":13:{s:4:"name";s:8:"OXREMARK";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:-1;s:5:"scale";N;s:7:"comment";s:12:"User remarks";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:59;O:8:"stdClass":14:{s:4:"name";s:17:"OXVOUCHERDISCOUNT";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:-1;s:5:"scale";N;s:7:"comment";s:31:"Coupon (voucher) discount price";s:12:"characterSet";N;s:9:"collation";N;}i:60;O:8:"stdClass":13:{s:4:"name";s:10:"OXCURRENCY";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:"Currency";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:61;O:8:"stdClass":14:{s:4:"name";s:9:"OXCURRATE";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:-1;s:5:"scale";N;s:7:"comment";s:13:"Currency rate";s:12:"characterSet";N;s:9:"collation";N;}i:62;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:67:"Folder: ORDERFOLDER_FINISHED, ORDERFOLDER_NEW, ORDERFOLDER_PROBLEMS";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:63;O:8:"stdClass":13:{s:4:"name";s:9:"OXTRANSID";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:22:"Paypal: Transaction id";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:64;O:8:"stdClass":13:{s:4:"name";s:7:"OXPAYID";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:0:"";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:65;O:8:"stdClass":13:{s:4:"name";s:5:"OXXID";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:0:"";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:66;O:8:"stdClass":14:{s:4:"name";s:6:"OXPAID";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:-1;s:5:"scale";N;s:7:"comment";s:25:"Time, when order was paid";s:12:"characterSet";N;s:9:"collation";N;}i:67;O:8:"stdClass":14:{s:4:"name";s:8:"OXSTORNO";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:15:"Order cancelled";s:12:"characterSet";N;s:9:"collation";N;}i:68;O:8:"stdClass":13:{s:4:"name";s:4:"OXIP";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:"39";s:5:"scale";N;s:7:"comment";s:15:"User ip address";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:69;O:8:"stdClass":13:{s:4:"name";s:13:"OXTRANSSTATUS";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:"30";s:5:"scale";N;s:7:"comment";s:37:"Order status: NOT_FINISHED, OK, ERROR";s:12:"characterSet";s:7:"utf8mb3";s:9:"collation";s:18:"utf8mb3_general_ci";}i:70;O:8:"stdClass":14:{s:4:"name";s:6:"OXLANG";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:"2";s:5:"scale";N;s:7:"comment";s:11:"Language id";s:12:"characterSet";N;s:9:"collation";N;}i:71;O:8:"stdClass":14:{s:4:"name";s:11:"OXINVOICENR";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:14:"Invoice number";s:12:"characterSet";N;s:9:"collation";N;}i:72;O:8:"stdClass":13:{s:4:"name";s:9:"OXDELTYPE";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:27:"Delivery id (oxdeliveryset)";s:12:"characterSet";s:6:"latin1";s:9:"collation";s:17:"latin1_general_ci";}i:73;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:-1;s:5:"scale";N;s:7:"comment";s:9:"Timestamp";s:12:"characterSet";N;s:9:"collation";N;}i:74;O:8:"stdClass":14:{s:4:"name";s:13:"OXISNETTOMODE";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:27:"Order created in netto mode";s:12:"characterSet";N;s:9:"collation";N;}i:75;O:8:"stdClass":14:{s:4:"name";s:21:"VIOREVIEWREMINDERSENT";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:0:"";s:12:"characterSet";N;s:9:"collation";N;}}}