text: SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  CREATE TABLE IF NOT EXISTS `sellsy_orders` (
    `id` int (11) NOT NULL AUTO_INCREMENT,
    `sellsy_id` int (11),
    `corpname` text,
    `ownerFullName` text,
    `status` text,
    `filename` text,
    `fileid` int(11),
    `nbpages` int(11),
    `ident` text,
    `thirdident` text,
    `thirdname` text,
    `thirdid` int(11),
    `thirdvatnum` text,
    `contactId` int(11),
    `contactName` text,
    `displayedDate` text,
    `currencysymbol` text,
    `subject` text,
    `docspeakerText` text,
    `docspeakerStaffId` int(11),
    `docspeakerStaffFullName` text,
    `corpaddressid` int(11),
    `thirdaddressid` int(11),
    `shipaddressid` int(11),
    `rowsAmount` text,
    `discountPercent` text,
    `discountAmount` text,
    `rowsAmountDiscounted` text,
    `offerAmount` text,
    `rowsAmountAllInc` text,
    `packagingsAmount` text,
    `shippingsAmount` text,
    `totalAmountTaxesFree` text,
    `taxesAmountSum` text,
    `taxesAmountDetails` text,
    `totalAmount` text,
    `useEcotaxe` text,
    `totalEcoTaxFree` text,
    `totalEcoTaxInc` text,
    `ecoTaxId` text,
    `taxBasis` text,
    `payDateText` text,
    `payDateCustom` text,
    `hasDeadlines` text,
    `payMediumsText` text,
    `payCheckOrderText` text,
    `payBankAccountText` text,
    `shippingNbParcels` text,
    `shippingWeight` text,
    `shippingWeightUnit` text,
    `shippingVolume` text,
    `shippingTrackingNumber` text,
    `shippingTrackingUrl` text,
    `shippingDate` text,
    `saveThirdPrefs` text,
    `displayShipAddress` text,
    `analyticsCode` text,
    `recorded` text,
    `recordable` text,
    `rateCategory` text,
    `isTaxesInc` text,
    `hasDoubleVat` text,
    `stockImpact` text,
    `isFromPresta` text,
    `eCommerceShopId` text,
    `signcoords` text,
    `esignID` text,
    `promotionid` text,
    `useServiceDates` text,
    `serviceDateStart` text,
    `serviceDateStop` text,
    `locked` text,
    `reconciledStatus` text,
    `corpid` text,
    `ownerid` text,
    `linkedtype` text,
    `linkedid` text,
    `created` text,
    `prefsid` text,
    `parentid` text,
    `docmapid` text,
    `hasVat` text,
    `doctypeid` text,
    `step` text,
    `doctypestep` text,
    `expireDate` text,
    `showSignAndStamp` text,
    `currencyid` text,
    `currencyposition` text,
    `numberformat` text,
    `numberdecimals` text,
    `numberthousands` text,
    `numberprecision` text,
    `notes` text,
    `bankaccountid` text,
    `thirdRelationType` text,
    `auxCode` text,
    `thirdemail` text,
    `thirdtel` text,
    `thirdmobile` text,
    `lastpayment` text,
    `payDateCustomUnix` text,
    `third_addr_name` text,
    `third_addr_part1` text,
    `third_addr_part2` text,
    `third_addr_part3` text,
    `third_addr_part4` text,
    `third_addr_zip` text,
    `third_addr_town` text,
    `third_addr_countrycode` text,
    `ship_addr_name` text,
    `ship_addr_part1` text,
    `ship_addr_part2` text,
    `ship_addr_part3` text,
    `ship_addr_part4` text,
    `ship_addr_zip` text,
    `ship_addr_town` text,
    `ship_addr_countrycode` text,
    `note` text,
    `step_color` text,
    `step_hex` text,
    `step_label` text,
    `step_css` text,
    `step_banner` text,
    `step_id` text,
    `doctypestep_color` text,
    `doctypestep_hex` text,
    `doctypestep_label` text,
    `doctypestep_css` text,
    `doctypestep_id` text,
    `displayed_payMediumsText` text,
    `formatted_totalAmount` text,
    `formatted_totalAmountTaxesFree` text,
    `formatted_created` text,
    `formatted_displayedDate` text,
    `formatted_payDateCustom` text,
    `formatted_serviceDateStart` text,
    `formatted_serviceDateStop` text,
    `formatted_lastSepaExportDate` text,
    `formatted_lastpayment` text,
    `formatted_expireDate` text,
    `noedit` text,
    `publicLinkShort` text,
    `address` text,
    `shippingAddress` text,
    `weightFormatted` text,
    `weightFormattedDisplayed` text,
    `thirdStatus` text,
     PRIMARY KEY (`id`, `sellsy_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  COMMIT;
  