-- phpMyAdmin SQL Dump -- version 4.9.0.1 -- https://www.phpmyadmin.net/ -- -- Vært: localhost:3306 -- Genereringstid: 06. 11 2019 kl. 11:18:32 -- Serverversion: 10.1.41-MariaDB-0ubuntu0.18.04.1 -- PHP-version: 7.3.5 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `xxxx_` -- -- -------------------------------------------------------- -- -- Struktur-dump for tabellen `gprnt_breezingcommerce_products` -- CREATE TABLE `gprnt_breezingcommerce_products` ( `id` int(11) NOT NULL, `item_number` varchar(255) NOT NULL DEFAULT '', `sku` varchar(255) NOT NULL DEFAULT '', `title` varchar(255) NOT NULL DEFAULT '', `alias` varchar(255) NOT NULL DEFAULT '', `description` longtext NOT NULL, `description_fulltext` longtext NOT NULL, `price` decimal(64,4) NOT NULL DEFAULT '0.0000', `sale_price` decimal(64,4) NOT NULL DEFAULT '0.0000', `stock` int(11) NOT NULL DEFAULT '0', `weight` double NOT NULL DEFAULT '0', `weight_type` tinyint(1) NOT NULL DEFAULT '0', `dimension_type` tinyint(1) NOT NULL DEFAULT '0', `width` double NOT NULL DEFAULT '0', `height` double NOT NULL DEFAULT '0', `length` double NOT NULL DEFAULT '0', `bundles` longtext NOT NULL, `property_id` int(11) NOT NULL DEFAULT '0', `property_readonly_id` int(11) NOT NULL DEFAULT '0', `use_combinations` tinyint(1) NOT NULL DEFAULT '0', `producttaxclass_id` int(11) NOT NULL DEFAULT '0', `virtual_product` tinyint(1) NOT NULL DEFAULT '0', `backorders` varchar(255) NOT NULL DEFAULT '', `limited_address_data` tinyint(1) NOT NULL DEFAULT '0', `attribs` longtext NOT NULL, `metadesc` varchar(1024) NOT NULL DEFAULT '', `metakey` varchar(1024) NOT NULL DEFAULT '', `metadata` varchar(2048) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT '0', `created_by_alias` varchar(255) NOT NULL DEFAULT '', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT '0', `modified_by_alias` varchar(255) NOT NULL DEFAULT '', `published` tinyint(1) NOT NULL DEFAULT '0', `ordering` int(11) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Data dump for tabellen `gprnt_breezingcommerce_products` -- INSERT INTO `gprnt_breezingcommerce_products` (`id`, `item_number`, `sku`, `title`, `alias`, `description`, `description_fulltext`, `price`, `sale_price`, `stock`, `weight`, `weight_type`, `dimension_type`, `width`, `height`, `length`, `bundles`, `property_id`, `property_readonly_id`, `use_combinations`, `producttaxclass_id`, `virtual_product`, `backorders`, `limited_address_data`, `attribs`, `metadesc`, `metakey`, `metadata`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `modified_by_alias`, `published`, `ordering`) VALUES (1732, 'Item 1732', '', 'Sub 3C P1', 'sub-3c-p1', '', '', '100.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, '', 0, '{\"backorders\":\"\",\"minimum_amount\":\"1\",\"maximum_amount\":\"99999\",\"immediate_checkout\":\"0\",\"immediate_checkout_singleton\":\"0\",\"verification_days\":\"0\",\"hide_price\":\"0\",\"robots\":\"\",\"author\":\"\",\"rights\":\"\",\"xreference\":\"\"}', '', '', '{\"backorders\":\"\",\"minimum_amount\":\"1\",\"maximum_amount\":\"99999\",\"immediate_checkout\":\"0\",\"immediate_checkout_singleton\":\"0\",\"verification_days\":\"0\",\"hide_price\":\"0\",\"robots\":\"\",\"author\":\"\",\"rights\":\"\",\"xreference\":\"\"}', '2019-10-30 14:20:28', 242, 'admingrprnt', '2019-10-30 14:20:28', 242, 'admingrprnt', 1, 3), (1733, 'Item 1733', '', 'Sub 3C P2', 'sub-3c-p2', '', '', '200.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, '', 0, '{\"backorders\":\"\",\"minimum_amount\":\"1\",\"maximum_amount\":\"99999\",\"immediate_checkout\":\"0\",\"immediate_checkout_singleton\":\"0\",\"verification_days\":\"0\",\"hide_price\":\"0\",\"robots\":\"\",\"author\":\"\",\"rights\":\"\",\"xreference\":\"\"}', '', '', '{\"backorders\":\"\",\"minimum_amount\":\"1\",\"maximum_amount\":\"99999\",\"immediate_checkout\":\"0\",\"immediate_checkout_singleton\":\"0\",\"verification_days\":\"0\",\"hide_price\":\"0\",\"robots\":\"\",\"author\":\"\",\"rights\":\"\",\"xreference\":\"\"}', '2019-10-30 14:20:46', 242, 'admingrprnt', '2019-10-30 14:20:46', 242, 'admingrprnt', 1, 2), (1734, 'Item 1734', '123456789', 'Sub 3C P3', 'sub-3c-p3', '

Desc.

', ' Desc. ', '300.0000', '0.0000', 0, 1, 0, 0, 10, 10, 10, '', 0, 0, 0, 0, 0, '', 0, '{\"backorders\":\"\",\"minimum_amount\":\"1\",\"maximum_amount\":\"99999\",\"immediate_checkout\":\"1\",\"immediate_checkout_singleton\":\"0\",\"verification_days\":\"0\",\"hide_price\":\"0\",\"robots\":\"robots\",\"author\":\"author\",\"rights\":\"rights\",\"xreference\":\"XREF\"}', 'meta desc', 'Meta key', '{\"backorders\":\"\",\"minimum_amount\":\"1\",\"maximum_amount\":\"99999\",\"immediate_checkout\":\"1\",\"immediate_checkout_singleton\":\"0\",\"verification_days\":\"0\",\"hide_price\":\"0\",\"robots\":\"robots\",\"author\":\"author\",\"rights\":\"rights\",\"xreference\":\"XREF\"}', '2019-10-30 14:21:04', 242, 'admingrprnt', '2019-11-01 14:21:00', 242, 'admingrprnt', 1, 1); -- -- Begrænsninger for dumpede tabeller -- -- -- Indeks for tabel `gprnt_breezingcommerce_products` -- ALTER TABLE `gprnt_breezingcommerce_products` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `item_number` (`item_number`), ADD KEY `producttaxclass_id` (`producttaxclass_id`), ADD KEY `property_id` (`property_id`), ADD KEY `published` (`published`), ADD KEY `weight_type` (`weight_type`), ADD KEY `dimension_type` (`dimension_type`), ADD KEY `alias` (`alias`), ADD KEY `stock` (`stock`), ADD KEY `sku` (`sku`), ADD KEY `price` (`price`), ADD KEY `sale_price` (`sale_price`), ADD KEY `created` (`created`), ADD KEY `modified` (`modified`), ADD KEY `limited_address_data` (`limited_address_data`), ADD KEY `backorders` (`backorders`), ADD KEY `property_readonly_id` (`property_readonly_id`); ALTER TABLE `gprnt_breezingcommerce_products` ADD FULLTEXT KEY `title` (`title`); ALTER TABLE `gprnt_breezingcommerce_products` ADD FULLTEXT KEY `description_fulltext` (`description_fulltext`); -- -- Brug ikke AUTO_INCREMENT for slettede tabeller -- -- -- Tilføj AUTO_INCREMENT i tabel `gprnt_breezingcommerce_products` -- ALTER TABLE `gprnt_breezingcommerce_products` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1735; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;