-- -------------------------------------------------------- -- Host: 185.194.168.202 -- Server version: 5.5.65-MariaDB - MariaDB Server -- Server OS: Linux -- HeidiSQL Version: 10.1.0.5464 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- Dumping structure for table logcabinkits.products CREATE TABLE IF NOT EXISTS `products` ( `id` int(5) NOT NULL AUTO_INCREMENT, `id_sub` int(3) NOT NULL DEFAULT '0', `euroName` varchar(50) DEFAULT NULL, `standard` tinyint(4) DEFAULT '0', `name` varchar(60) DEFAULT NULL, `subcat` varchar(30) DEFAULT NULL, `deliverysize` int(2) DEFAULT NULL, `costPrice` decimal(10,2) DEFAULT '0.00', `tempPrice` int(6) DEFAULT NULL, `priceAdjust` decimal(10,1) DEFAULT NULL, `price` decimal(10,2) DEFAULT '0.00', `priceSALE` decimal(10,2) DEFAULT '0.00', `priceUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `description` text, `descNew` text, `attr` varchar(20) DEFAULT NULL, `showproduct` tinyint(1) NOT NULL DEFAULT '1', `dotd` tinyint(1) NOT NULL DEFAULT '0', `xtr1` varchar(60) DEFAULT NULL, `xtr2` int(11) DEFAULT NULL, `xtr3` varchar(20) DEFAULT NULL, `xtr4` int(6) DEFAULT NULL, `xtr5` int(6) DEFAULT NULL, `xtr6` int(6) DEFAULT NULL, `xtr7` int(6) DEFAULT NULL, `xtr8` int(6) DEFAULT NULL, `xtr9` int(6) DEFAULT NULL, `xtr10` int(6) DEFAULT '0', `roofType` tinyint(2) DEFAULT '0', `stock` tinyint(2) DEFAULT '0', `googleCat` varchar(100) DEFAULT NULL, `googleProType` varchar(100) DEFAULT NULL, `googleLink` varchar(100) DEFAULT NULL, `image` varchar(200) DEFAULT 'http://logcabinkits.co.uk/_images/products/lge/', `gogleCondition` varchar(100) DEFAULT 'new', PRIMARY KEY (`id`), KEY `id_sub` (`id_sub`), KEY `subcat` (`subcat`), KEY `attr` (`attr`), KEY `showproduct` (`showproduct`), KEY `products_idx_subcat_price_showpro_xtr1` (`subcat`,`price`,`showproduct`,`xtr1`), KEY `products_idx_subcat_sub_showpro_xtr1` (`subcat`,`id_sub`,`showproduct`,`xtr1`) ) ENGINE=MyISAM AUTO_INCREMENT=3020 DEFAULT CHARSET=utf8; -- Dumping data for table logcabinkits.products: 166 rows /*!40000 ALTER TABLE `products` DISABLE KEYS */; INSERT INTO `products` (`id`, `id_sub`, `euroName`, `standard`, `name`, `subcat`, `deliverysize`, `costPrice`, `tempPrice`, `priceAdjust`, `price`, `priceSALE`, `priceUpdated`, `description`, `descNew`, `attr`, `showproduct`, `dotd`, `xtr1`, `xtr2`, `xtr3`, `xtr4`, `xtr5`, `xtr6`, `xtr7`, `xtr8`, `xtr9`, `xtr10`, `roofType`, `stock`, `googleCat`, `googleProType`, `googleLink`, `image`, `gogleCondition`) VALUES (2149, 2174, 'Oslo', 1, 'Selva 6x4', 'cabin', 2, 2195.00, 2722, NULL, 3590.00, 3390.00, '2020-05-28 08:13:40', '

Our popular Selva 6x4 log cabin in 44mm wall logs. Great value

', NULL, 'Gdn-Off', 1, 1, '44', 6000, '4000', 2090, 2450, 200, 2, 3, 0, 0, 2, 0, '720', 'Home & Garden > Lawn & Garden > Outdoor Living > Outdoor Structures > Sheds, Garages & Carports', 'https://logcabinkits.co.uk/selva-6x4-log-cabin-2149', 'https://logcabinkits.co.uk/_images/products/lge/2149.jpg', 'new'); /*!40000 ALTER TABLE `products` ENABLE KEYS */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;