text: SELECT id, list_gallery, reader_gallery FROM tl_iso_producttype ORDER BY id
  CREATE TABLE `tl_iso_price_tiers` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `min` int(10) unsigned NOT NULL DEFAULT '0', `price` decimal(12,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  SELECT * FROM tl_nc_gateway
  SELECT id, billing_fields, shipping_fields FROM tl_iso_config
  CREATE TABLE `tl_iso_labels` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `language` varchar(2) NOT NULL DEFAULT '', `label` varchar(255) NOT NULL DEFAULT '', `replacement` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `language` (`language`))
  CREATE TABLE `tl_iso_prices` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `tax_class` int(10) unsigned NOT NULL DEFAULT '0', `config_id` int(10) unsigned NOT NULL DEFAULT '0', `member_group` int(10) unsigned NOT NULL DEFAULT '0', `start` varchar(10) NOT NULL DEFAULT '', `stop` varchar(10) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  CREATE TABLE `tl_iso_related_products` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `sorting` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `category` int(10) unsigned NOT NULL DEFAULT '0', `products` blob, PRIMARY KEY (`id`), KEY `pid` (`pid`))
  SELECT * FROM tl_iso_mail WHERE id IN (?)
  SELECT uuid FROM tl_files WHERE path=:path
  SELECT * FROM tl_iso_mail WHERE id=?
  CREATE TABLE `tl_iso_related_categories` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `jumpTo` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`))
  SELECT id, billing_address_id, shipping_address_id FROM tl_iso_product_collection
  SELECT id, name, imageSizes FROM tl_iso_config
  CREATE TABLE `tl_iso_cart` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `session` varchar(64) NOT NULL DEFAULT '', `store_id` int(2) unsigned NOT NULL DEFAULT '0', `settings` blob, `coupons` blob, PRIMARY KEY (`id`), KEY `pid` (`pid`,`store_id`), KEY `session` (`session`,`store_id`))
  CREATE TABLE `tl_iso_downloads` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `singleSRC` varchar(255) NOT NULL DEFAULT '', `title` varchar(255) NOT NULL DEFAULT '', `description` text, `downloads_allowed` int(5) unsigned NOT NULL DEFAULT '0', `sorting` int(10) unsigned NOT NULL DEFAULT '0', `type` varchar(8) NOT NULL DEFAULT 'file', `expires` varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  UPDATE tl_iso_download SET published=1 WHERE title!= OR
  CREATE TABLE `tl_iso_related_products` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `sorting` int(10) unsigned NOT NULL DEFAULT '0', `category` int(10) unsigned NOT NULL DEFAULT '0', `products` blob, PRIMARY KEY (`id`), KEY `pid` (`pid`))
  CREATE TABLE `tl_iso_tax_rate` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `label` varchar(255) NOT NULL DEFAULT '', `postalCodes` text, `config` int(10) unsigned NOT NULL DEFAULT '0', `rate` varchar(255) NOT NULL DEFAULT '', `address` blob, `amount` varchar(255) NOT NULL DEFAULT '', `stop` char(1) NOT NULL DEFAULT '', `countries` text, `subdivisions` text, `guests` char(1) NOT NULL DEFAULT '', `protected` char(1) NOT NULL DEFAULT '', `groups` blob, PRIMARY KEY (`id`))
  UPDATE tl_iso_producttype SET class=standard  WHERE class=regular
  CREATE TABLE `tl_iso_cart_items` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `product_id` int(10) unsigned NOT NULL DEFAULT '0', `price` decimal(12,2) NOT NULL DEFAULT '0.00', `href_reader` varchar(255) NOT NULL DEFAULT '', `product_sku` varchar(128) NOT NULL DEFAULT '', `product_name` varchar(255) NOT NULL DEFAULT '', `product_options` blob, `product_quantity` int(10) unsigned NOT NULL DEFAULT '0', `tax_id` varchar(32) NOT NULL DEFAULT '', `tax_free_price` decimal(12,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  CREATE TABLE `tl_iso_price_tiers` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `min` int(10) unsigned NOT NULL DEFAULT '0', `price` decimal(12,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  CREATE TABLE `tl_user_group` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `modules` blob, `themes` blob, `pagemounts` blob, `alpty` blob, `filemounts` blob, `fop` blob, `forms` blob, `formp` blob, `alexf` blob, `disable` char(1) NOT NULL DEFAULT '', `start` varchar(10) NOT NULL DEFAULT '', `stop` varchar(10) NOT NULL DEFAULT '', `calendars` blob, `calendarp` blob, `news` blob, `newp` blob, `newsletters` blob, `newsletterp` blob, `faqs` blob, `faqp` blob, `iso_modules` blob, `iso_product_types` blob, `iso_product_typep` blob, `iso_payment_modules` blob, `iso_payment_modulep` blob, `iso_shipping_modules` blob, `iso_shipping_modulep` blob, `iso_tax_classes` blob, `iso_tax_classp` blob, `iso_tax_rates` blob, `iso_tax_ratep` blob, `iso_mails` blob, `iso_mailp` blob, `iso_configs` blob, `iso_configp` blob, `iso_groups` blob, `iso_groupp` blob, PRIMARY KEY (`id`))
  SELECT id, title, type FROM tl_nc_gateway
  SELECT COUNT(*) FROM tl_nc_gateway
  SELECT * FROM tl_iso_shipping WHERE type='order_total' OR type='weight_total'
  SELECT id, name, type, label, minimum_total, maximum_total, price, enabled, group_methods, group_calculation FROM tl_iso_shipping
  CREATE TABLE `tl_iso_mail_content` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `language` varchar(255) NOT NULL DEFAULT '', `fallback` char(1) NOT NULL DEFAULT '', `subject` varchar(255) NOT NULL DEFAULT '', `text` text, `textOnly` char(1) NOT NULL DEFAULT '', `html` text, `attachments` blob, PRIMARY KEY (`id`), KEY `pid` (`pid`))
  CREATE TABLE `tl_iso_groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `sorting` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `product_type` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  SELECT id, ptable, pid, store_id, salutation, company, firstname, lastname, street_1, street_2, street_3, postal, city, subdivision, country, phone, email, isDefaultShipping, isDefaultBilling FROM tl_iso_address
  CREATE TABLE `tl_iso_product_categories` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `sorting` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `page_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  CREATE TABLE `tl_iso_rule_restrictions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `type` varchar(32) NOT NULL DEFAULT '', `object_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `type` (`type`,`object_id`,`pid`), KEY `pid` (`pid`,`type`))
  CREATE TABLE `tl_iso_cart_items` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `product_id` int(10) unsigned NOT NULL DEFAULT '0', `product_sku` varchar(128) NOT NULL DEFAULT '', `product_name` varchar(255) NOT NULL DEFAULT '', `product_options` blob, `product_quantity` int(10) unsigned NOT NULL DEFAULT '0', `price` decimal(12,2) NOT NULL DEFAULT '0.00', `tax_id` varchar(32) NOT NULL DEFAULT '', `href_reader` varchar(255) NOT NULL DEFAULT '', `tax_free_price` decimal(12,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  SELECT id, name FROM tl_iso_producttypes
  SELECT COUNT(*) FROM $tableName
  CREATE TABLE `tl_iso_tax_class` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `label` varchar(255) NOT NULL DEFAULT '', `includes` int(10) unsigned NOT NULL DEFAULT '0', `rates` blob, `fallback` char(1) NOT NULL DEFAULT '', `applyRoundingIncrement` char(1) NOT NULL DEFAULT '', `notNegative` char(1) NOT NULL DEFAULT '', PRIMARY KEY (`id`))
  CREATE TABLE `tl_iso_rule_usage` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `order_id` int(10) unsigned NOT NULL DEFAULT '0', `config_id` int(10) unsigned NOT NULL DEFAULT '0', `member_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  CREATE TABLE `tl_iso_product_categories` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `sorting` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `page_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  CREATE TABLE `tl_iso_downloads` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `singleSRC` varchar(255) NOT NULL DEFAULT '', `title` varchar(255) NOT NULL DEFAULT '', `description` text, `downloads_allowed` int(5) unsigned NOT NULL DEFAULT '0', `sorting` int(10) unsigned NOT NULL DEFAULT '0', `type` varchar(8) NOT NULL DEFAULT 'file', `expires` varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  SELECT id, tstamp, surcharges FROM $tableName WHERE surcharges!=''
  SELECT * FROM tl_iso_mail_content WHERE pid=?
  CREATE TABLE `tl_iso_shipping_options` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `description` text, `rate` decimal(12,2) NOT NULL DEFAULT '0.00', `minimum_total` decimal(12,2) NOT NULL DEFAULT '0.00', `maximum_total` decimal(12,2) NOT NULL DEFAULT '0.00', `weight_from` varchar(32) NOT NULL DEFAULT '0', `weight_to` varchar(32) NOT NULL DEFAULT '0', `enabled` char(1) NOT NULL DEFAULT '', PRIMARY KEY (`id`))
  SELECT pid, tax_class, config_id, member_group, start, stop FROM tl_iso_product_price
  CREATE TABLE `tl_iso_orderstatus` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `sorting` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `paid` char(1) NOT NULL DEFAULT '', `welcomescreen` char(1) NOT NULL DEFAULT '', `mail_customer` int(10) unsigned NOT NULL DEFAULT '0', `mail_admin` int(10) unsigned NOT NULL DEFAULT '0', `sales_email` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  SELECT table_name FROM information_schema.tables WHERE table_schema=:db');
  SELECT id, pid, sorting, type, label, price, total_price, tax_free_total_price, tax_class, tax_id, before_tax, addToTotal, products FROM tl_iso_product_collection_surcharge
  CREATE TABLE `tl_iso_order_downloads` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `download_id` int(10) unsigned NOT NULL DEFAULT '0', `downloads_remaining` varchar(255) NOT NULL DEFAULT '', `expires` varchar(10) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  SELECT id, name, sku, quantity, configuration, type FROM tl_iso_product_collection_item
  CREATE TABLE `tl_iso_mail` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `senderName` varchar(255) NOT NULL DEFAULT '', `sender` varchar(255) NOT NULL DEFAULT '', `cc` varchar(255) NOT NULL DEFAULT '', `bcc` varchar(255) NOT NULL DEFAULT '', `template` varchar(255) NOT NULL DEFAULT '', `attachDocument` char(1) NOT NULL DEFAULT '', `documentTemplate` varchar(255) NOT NULL DEFAULT '', `documentTitle` varchar(255) NOT NULL DEFAULT '', `priority` int(1) unsigned NOT NULL DEFAULT '3', PRIMARY KEY (`id`))
  SELECT id, products FROM tl_iso_related_product WHERE products!=''
  SELECT id FROM tl_iso_product WHERE type=?
  SELECT id, attributes, variants, variant_attributes FROM tl_iso_producttype WHERE prices=''
  SELECT * FROM tl_iso_shipping_options WHERE pid=? ORDER BY minimum_total ASC, maximum_total ASC
  CREATE TABLE `tl_iso_prices` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `tax_class` int(10) unsigned NOT NULL DEFAULT '0', `config_id` int(10) unsigned NOT NULL DEFAULT '0', `member_group` int(10) unsigned NOT NULL DEFAULT '0', `start` varchar(10) NOT NULL DEFAULT '', `stop` varchar(10) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  CREATE TABLE `tl_iso_groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `sorting` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `product_type` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  CREATE TABLE `tl_iso_related_categories` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `jumpTo` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`))
  SELECT id, iso_config, iso_store_id FROM tl_page WHERE type='root' ORDER BY id
  CREATE TABLE `tl_files` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` binary(16) DEFAULT NULL, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `uuid` binary(16) DEFAULT NULL, `type` varchar(16) NOT NULL DEFAULT '', `path` varchar(1022) NOT NULL DEFAULT '', `extension` varchar(16) NOT NULL DEFAULT '', `hash` varchar(32) NOT NULL DEFAULT '', `found` char(1) NOT NULL DEFAULT '1', `name` varchar(255) NOT NULL DEFAULT '', `meta` blob, PRIMARY KEY (`id`), UNIQUE KEY `uuid` (`uuid`), KEY `pid` (`pid`), KEY `extension` (`extension`))
  SELECT id, name, field_name FROM tl_iso_attributes WHERE type='mediaManager' AND gallery!=''
  CREATE TABLE `tl_iso_orderstatus` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `sorting` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `paid` char(1) NOT NULL DEFAULT '', `welcomescreen` char(1) NOT NULL DEFAULT '', `mail_customer` int(10) unsigned NOT NULL DEFAULT '0', `mail_admin` int(10) unsigned NOT NULL DEFAULT '0', `sales_email` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  CREATE TABLE `tl_iso_requestcache` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `store_id` int(10) unsigned NOT NULL DEFAULT '0', `filters` blob, `sorting` blob, `limits` blob, PRIMARY KEY (`id`))
  CREATE TABLE `tl_iso_cart` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `session` varchar(64) NOT NULL DEFAULT '', `store_id` int(2) unsigned NOT NULL DEFAULT '0', `coupons` blob, `settings` blob, PRIMARY KEY (`id`), KEY `session` (`session`,`store_id`), KEY `pid` (`pid`,`store_id`))
  SELECT id, member, source_collection_id, locked, order_status, subtotal, total, document_number FROM tl_iso_product_collection
  SELECT id, pid, gateway_type, language, fallback, recipients, email_sender_name, email_sender_address, email_recipient_cc, email_recipient_bcc, email_subject, email_text, email_html, email_mode FROM tl_nc_language
  SELECT id, attributes, variant_attributes FROM tl_iso_producttype
  CREATE TABLE `tl_iso_productcache` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `page_id` int(10) unsigned NOT NULL DEFAULT '0', `module_id` int(10) unsigned NOT NULL DEFAULT '0', `requestcache_id` int(10) unsigned NOT NULL DEFAULT '0', `keywords` varchar(255) NOT NULL DEFAULT '', `products` blob, `expires` int(10) unsigned NOT NULL DEFAULT '0', `groups` blob, PRIMARY KEY (`id`), KEY `page_id` (`page_id`,`module_id`,`requestcache_id`,`keywords`,`expires`))
  SELECT billing_address, shipping_address FROM tl_iso_orders
  CREATE TABLE `tl_iso_mail` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `senderName` varchar(255) NOT NULL DEFAULT '', `sender` varchar(255) NOT NULL DEFAULT '', `cc` varchar(255) NOT NULL DEFAULT '', `bcc` varchar(255) NOT NULL DEFAULT '', `template` varchar(255) NOT NULL DEFAULT '', `attachDocument` char(1) NOT NULL DEFAULT '', `documentTemplate` varchar(255) NOT NULL DEFAULT '', `documentTitle` varchar(255) NOT NULL DEFAULT '', `priority` int(1) unsigned NOT NULL DEFAULT '3', PRIMARY KEY (`id`))
  CREATE TABLE `tl_iso_rule_restrictions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `type` varchar(32) NOT NULL DEFAULT '', `object_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `pid` (`pid`,`type`), KEY `type` (`type`,`object_id`,`pid`))
  CREATE TABLE `tl_iso_mail_content` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `language` varchar(255) NOT NULL DEFAULT '', `fallback` char(1) NOT NULL DEFAULT '', `subject` varchar(255) NOT NULL DEFAULT '', `text` text, `textOnly` char(1) NOT NULL DEFAULT '', `html` text, `attachments` blob, PRIMARY KEY (`id`), KEY `pid` (`pid`))
  CREATE TABLE `tl_iso_order_items` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `product_id` int(10) unsigned NOT NULL DEFAULT '0', `product_sku` varchar(128) NOT NULL DEFAULT '', `product_name` varchar(255) NOT NULL DEFAULT '', `product_options` blob, `product_quantity` int(10) unsigned NOT NULL DEFAULT '0', `price` decimal(12,2) NOT NULL DEFAULT '0.00', `tax_id` varchar(32) NOT NULL DEFAULT '', `tax_free_price` decimal(12,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  SELECT id, name FROM tl_layout WHERE doctype!='html5'
  CREATE TABLE `tl_iso_producttypes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `description` text, `attributes` blob, `downloads` char(1) NOT NULL DEFAULT '', `variant_attributes` blob, `class` varchar(32) NOT NULL DEFAULT 'regular', `list_template` varchar(255) NOT NULL DEFAULT '', `reader_template` varchar(255) NOT NULL DEFAULT '', `variants` char(1) NOT NULL DEFAULT '', `fallback` char(1) NOT NULL DEFAULT '', `prices` char(1) NOT NULL DEFAULT '', `force_variant_options` char(1) NOT NULL DEFAULT '', `show_price_tiers` char(1) NOT NULL DEFAULT '', `shipping_exempt` char(1) NOT NULL DEFAULT '', PRIMARY KEY (`id`))
  CREATE TABLE `tl_iso_order_items` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `product_id` int(10) unsigned NOT NULL DEFAULT '0', `price` decimal(12,2) NOT NULL DEFAULT '0.00', `product_sku` varchar(128) NOT NULL DEFAULT '', `product_name` varchar(255) NOT NULL DEFAULT '', `product_options` blob, `product_quantity` int(10) unsigned NOT NULL DEFAULT '0', `tax_id` varchar(32) NOT NULL DEFAULT '', `tax_free_price` decimal(12,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`id`), KEY `pid` (`pid`))
  SELECT * FROM tl_iso_shipping_options WHERE pid=? ORDER BY weight_from ASC, weight_to ASC
  CREATE TABLE `tl_iso_tax_class` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `label` varchar(255) NOT NULL DEFAULT '', `fallback` char(1) NOT NULL DEFAULT '', `applyRoundingIncrement` char(1) NOT NULL DEFAULT '', `includes` int(10) unsigned NOT NULL DEFAULT '0', `rates` blob, `notNegative` char(1) NOT NULL DEFAULT '', `germanize_price` varchar(5) NOT NULL DEFAULT '', `germanize_rate` decimal(12,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`id`))
  SELECT id FROM tl_nc_gateway WHERE id=?
  CREATE TABLE `tl_iso_productcache` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `page_id` int(10) unsigned NOT NULL DEFAULT '0', `module_id` int(10) unsigned NOT NULL DEFAULT '0', `requestcache_id` int(10) unsigned NOT NULL DEFAULT '0', `keywords` varchar(255) NOT NULL DEFAULT '', `products` blob, `expires` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `page_id` (`page_id`,`module_id`,`requestcache_id`,`keywords`,`expires`))
  CREATE TABLE `tl_files` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` binary(16) DEFAULT NULL, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `uuid` binary(16) DEFAULT NULL, `type` varchar(16) NOT NULL DEFAULT '', `path` varchar(1022) NOT NULL DEFAULT '', `extension` varchar(16) NOT NULL DEFAULT '', `hash` varchar(32) NOT NULL DEFAULT '', `found` char(1) NOT NULL DEFAULT '1', `name` varchar(255) NOT NULL DEFAULT '', `meta` blob, PRIMARY KEY (`id`), UNIQUE KEY `uuid` (`uuid`), KEY `pid` (`pid`), KEY `extension` (`extension`))
  CREATE TABLE `tl_iso_producttypes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `description` text, `attributes` blob, `downloads` char(1) NOT NULL DEFAULT '', `variant_attributes` blob, `class` varchar(32) NOT NULL DEFAULT 'regular', `list_template` varchar(255) NOT NULL DEFAULT '', `reader_template` varchar(255) NOT NULL DEFAULT '', `variants` char(1) NOT NULL DEFAULT '', `fallback` char(1) NOT NULL DEFAULT '', `prices` char(1) NOT NULL DEFAULT '', `force_variant_options` char(1) NOT NULL DEFAULT '', `show_price_tiers` char(1) NOT NULL DEFAULT '', `shipping_exempt` char(1) NOT NULL DEFAULT '', PRIMARY KEY (`id`))
  SELECT * FROM tl_iso_config WHERE id=? LIMIT 1
  SELECT id, pid, title, gateway, gateway_type, email_priority, email_template, published FROM tl_nc_message
  SELECT pid, min, price FROM tl_iso_product_pricetier
  CREATE TABLE `tl_iso_tax_rate` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `label` varchar(255) NOT NULL DEFAULT '', `countries` text, `subdivisions` text, `rate` varchar(255) NOT NULL DEFAULT '', `address` blob, `amount` varchar(255) NOT NULL DEFAULT '', `stop` char(1) NOT NULL DEFAULT '', `config` int(10) unsigned NOT NULL DEFAULT '0', `postalCodes` text, `guests` char(1) NOT NULL DEFAULT '', `protected` char(1) NOT NULL DEFAULT '', `groups` blob, PRIMARY KEY (`id`))
  CREATE TABLE `tl_iso_baseprice` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `amount` varchar(32) NOT NULL DEFAULT '', `label` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`))
  SELECT field_name FROM tl_iso_attribute WHERE variant_option='1'
  CREATE TABLE `tl_iso_producttypes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `class` varchar(32) NOT NULL DEFAULT 'regular', `fallback` char(1) NOT NULL DEFAULT '', `description` text, `prices` char(1) NOT NULL DEFAULT '', `list_template` varchar(255) NOT NULL DEFAULT '', `reader_template` varchar(255) NOT NULL DEFAULT '', `attributes` blob, `variants` char(1) NOT NULL DEFAULT '', `variant_attributes` blob, `force_variant_options` char(1) NOT NULL DEFAULT '', `downloads` char(1) NOT NULL DEFAULT '', `show_price_tiers` char(1) NOT NULL DEFAULT '', `shipping_exempt` char(1) NOT NULL DEFAULT '', PRIMARY KEY (`id`))
  SELECT id, type, title FROM tl_nc_notification
  CREATE TABLE `tl_iso_shipping_options` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0', `tstamp` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `description` text, `rate` decimal(12,2) NOT NULL DEFAULT '0.00', `minimum_total` decimal(12,2) NOT NULL DEFAULT '0.00', `maximum_total` decimal(12,2) NOT NULL DEFAULT '0.00', `weight_from` varchar(32) NOT NULL DEFAULT '0', `weight_to` varchar(32) NOT NULL DEFAULT '0', `enabled` char(1) NOT NULL DEFAULT '', PRIMARY KEY (`id`))
  