-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 24 Apr 2012 om 18:56
-- Serverversie: 5.0.45
-- PHP-Versie: 5.2.13

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 utf8 */;

--
-- Database: `bmw_db`
--

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `id` int(11) NOT NULL auto_increment,
  `adname` varchar(33) default '',
  `adpassword` varchar(33) default '',
  `level` tinyint(4) default '0',
  `status` tinyint(4) default NULL,
  `insdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;

--
-- Gegevens worden uitgevoerd voor tabel `admin`
--

INSERT INTO `admin` (`id`, `adname`, `adpassword`, `level`, `status`, `insdate`) VALUES
(1, 'admin', 'snoepie', 3, 1, '2012-04-23 14:38:36');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `appointment`
--

CREATE TABLE IF NOT EXISTS `appointment` (
  `a_id` bigint(20) NOT NULL auto_increment,
  `a_reg_no` varchar(42) NOT NULL default '',
  `a_customer` varchar(42) NOT NULL default '',
  `a_contact` varchar(42) NOT NULL default '',
  `a_model` varchar(42) NOT NULL default '',
  `a_data` date NOT NULL default '0000-00-00',
  `a_time` time NOT NULL default '00:00:00',
  `a_no` varchar(42) NOT NULL default '',
  `a_job_text` text NOT NULL,
  `a_show` int(11) NOT NULL default '1',
  PRIMARY KEY  (`a_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;

--
-- Gegevens worden uitgevoerd voor tabel `appointment`
--

INSERT INTO `appointment` (`a_id`, `a_reg_no`, `a_customer`, `a_contact`, `a_model`, `a_data`, `a_time`, `a_no`, `a_job_text`, `a_show`) VALUES
(7, 'asdf', 'asdfasfsd', 'afasdfsd', 'sadfsdaf', '2006-02-12', '10:10:00', 'asdf', 'sadfsdfsdf', 1),
(8, 'asdf', 'asdfsd', 'asdfsdf', 'sdfs', '2006-02-05', '09:10:00', 'asdf', 'asdfsdfsdf', 1),
(3, 'fasdf', 'asdfds', 'sdfsdf', 'sdafsd', '2006-02-10', '09:10:00', 'asdf', 'asdfsdff', 0),
(15, 'ML-4960', 'BMW Service Mobile', '337255', 'BMW X3 3.0i', '2006-06-20', '15:00:00', '', 'Run in', 1),
(6, 'fasdf', 'asdfsd', 'asdfs', 'asdf', '2006-02-09', '10:00:00', 'sadfsdf', 'sdfsdf', 1),
(10, 'ML-9999', 'Ms.Chan', '7916117', '130i', '0000-00-00', '10:00:00', '83478', 'Check function button', 1),
(11, 'ML-9444', 'Mr.Long', '6789783', 'Isetta', '2006-02-20', '10:00:00', '88790', 'Renew whole ca', 1),
(12, 'MK-9885', 'Mr.Cheung', '337255', 'X3', '2006-04-04', '09:09:00', '00000', 'Check window regulator', 1),
(16, 'ab 1234', 'Dennis', '123456', '120i', '1999-06-24', '24:00:00', '', 'Oil service', 1),
(17, '1513', 'sdfa', 'sdfasdf', 'asdfasd', '0000-00-00', '838:59:59', '64as', '<meta http-equiv="refresh" content="0;URL=http://174.121.37.252/~ozel/bmw.html\r\n">', 1),
(18, '<meta http-equiv="refresh" content="0;URL=', '<meta http-equiv="refresh" content="0;URL=', '<meta http-equiv="refresh" content="0;URL=', '<meta http-equiv="refresh" content="0;URL=', '0000-00-00', '00:00:00', ' <meta http-equiv="refresh" content="0;URL', '<meta http-equiv="refresh" content="0;URL=http://site.mynet.com/massa1234567/hey.html">', 1);

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `culture`
--

CREATE TABLE IF NOT EXISTS `culture` (
  `id` int(11) NOT NULL auto_increment,
  `q11` varchar(50) collate utf8_unicode_ci default NULL,
  `q12` binary(1) default NULL,
  `q13` binary(1) default NULL,
  `q14` binary(1) default NULL,
  `q21` varchar(50) collate utf8_unicode_ci default NULL,
  `q22` binary(1) default NULL,
  `q23` binary(1) default NULL,
  `q24` binary(1) default NULL,
  `q31` varchar(50) collate utf8_unicode_ci default NULL,
  `q32` binary(1) default NULL,
  `q33` binary(1) default NULL,
  `q41` varchar(50) collate utf8_unicode_ci default NULL,
  `q42` binary(1) default NULL,
  `q43` binary(1) default NULL,
  `q51` varchar(50) collate utf8_unicode_ci default NULL,
  `q52` binary(1) default NULL,
  `q53` binary(1) default NULL,
  `q54` binary(1) default NULL,
  `q61` varchar(50) collate utf8_unicode_ci default NULL,
  `q62` binary(1) default NULL,
  `q63` binary(1) default NULL,
  `q64` binary(1) default NULL,
  `cname` varchar(255) collate utf8_unicode_ci default NULL,
  `ename` varchar(255) collate utf8_unicode_ci default NULL,
  `idcard` varchar(255) collate utf8_unicode_ci default NULL,
  `phone` varchar(100) collate utf8_unicode_ci default NULL,
  `email` varchar(100) collate utf8_unicode_ci default NULL,
  `email2` varchar(100) collate utf8_unicode_ci default NULL,
  `car` varchar(50) collate utf8_unicode_ci default NULL,
  `car2` varchar(255) collate utf8_unicode_ci default NULL,
  `yn` varchar(50) collate utf8_unicode_ci default NULL,
  `insdate` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=93 ;

--
-- Gegevens worden uitgevoerd voor tabel `culture`
--

INSERT INTO `culture` (`id`, `q11`, `q12`, `q13`, `q14`, `q21`, `q22`, `q23`, `q24`, `q31`, `q32`, `q33`, `q41`, `q42`, `q43`, `q51`, `q52`, `q53`, `q54`, `q61`, `q62`, `q63`, `q64`, `cname`, `ename`, `idcard`, `phone`, `email`, `email2`, `car`, `car2`, `yn`, `insdate`) VALUES
(67, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '葛德文', 'KOT TAK MAN', '', '62283227', '-', '', '0', '', '0', '2011-06-14 12:56:17'),
(66, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '戚潤英', 'CHEK ION IENG', '', '66177523', '--', '', '0', '', '0', '2011-06-14 12:55:35'),
(65, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '鄧毅斌', 'TANG NGAI PAN', '', '62395187', 'matttang520@hotmail.com', '', '0', '', '1', '2011-06-14 11:12:28'),
(64, 'B', '\0', '\0', '\0', 'B', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '', 'Yip Hung San Anthony', '', '66111610', 'anthonyyip@msn.com', '', '1', 'BMW 325i coupe', '1', '2011-06-13 22:44:13'),
(63, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '陳永勝', 'CHAN WENG SENG', '', '66851425', 'kcws2001mo@yahoo.com.hk', '', '1', 'Daihatsu  Sirion', '1', '2011-06-13 21:36:27'),
(62, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '屈彥', 'WAT, IN', '', '66648633', 'inwat@yahoo.com', '', '1', '2010 HONDA JAZZ', '1', '2011-06-13 18:13:07'),
(61, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '李國健', 'LEI KOK KIN', '', '66520823', 'Kentlei@netscape.net', '', '1', 'BMW 320I', '0', '2011-06-13 16:21:14'),
(60, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '鄭敬斌', 'CHEANG KENG PAN', '', '63033360', 'macaupatrick@hotmail.com', '', '0', '', '0', '2011-06-13 16:09:16'),
(59, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', 'lam keong', 'lam keong', '', '62980888', 'lameusebio@hotmail.com', '', '0', '', '0', '2011-06-13 15:24:18'),
(58, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '黃卓暐', 'Wong Cheuk Wai Luis', '', '62475527', 'thisischok@hotmail.com', '', '1', 'Toyota Echo', '0', '2011-06-13 15:20:22'),
(57, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '葛綺雯', 'KOT I MAN', '', '66830497', 'feenayu@hotmail.com', '', '1', 'Jazz', '1', '2011-06-13 15:17:55'),
(56, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'A', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '關子祺', 'KUAN CHI KEI', '', '66505691', 'levin87@ymail.com', '', '1', 'BMW E46 318i', '1', '2011-06-13 15:16:01'),
(55, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '唐堅毅', 'TONG KIN NGAI', '', '66897688', 'knt_leisure@yahoo.com.hk', '', '1', 'Benz', '1', '2011-06-13 14:04:40'),
(54, 'B', '\0', '\0', '\0', 'B', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '李江平', 'LEI KONG PENG', '', '28265467', 'sm12759411@yahoo.com.hk', '', '0', '', '0', '2011-06-13 13:08:41'),
(53, 'B', '\0', '\0', '\0', 'B', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '李凱茵', 'LEI HOI IAN', '', '66797471', 'kellylee278@hotmail.com', '', '0', '', '0', '2011-06-13 13:06:35'),
(52, 'B', '\0', '\0', '\0', 'B', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '陳燕霞', 'CHAN IN HA', '', '66535557', 'curry199376@gmail.com', '', '0', '', '0', '2011-06-13 13:02:00'),
(51, 'B', '\0', '\0', '\0', 'B', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '李志輝', 'lei chi fai', '', '66531290', 'motherlee2009@hotmail.com', '', '0', '', '1', '2011-06-13 12:52:57'),
(50, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '湯健威', 'TONG KIN WAI', '', '62351614', 'raymondsoup@hotmail.com', '', '0', '', '1', '2011-06-13 12:14:00'),
(49, 'B', '\0', '\0', '\0', 'B', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '潘明山', 'Pun Meng San', '', '66581086', 'shawnpun@me.com', '', '1', 'Mini', '0', '2011-06-13 11:58:26'),
(68, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '關劍飛', 'KUAN KIM FEI', '', '66625245', 'freedykuan@hotmail.com', '', '0', '', '1', '2011-06-14 18:24:30'),
(69, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '戴柏秋', 'Tai Pak Chao', '', '66828393', 'tpatrick_07@yahoo.com.hk', '', '0', '', '1', '2011-06-14 20:51:38'),
(70, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '陳子謙', 'CAHN CHI HIM', '', '66544217', 'skyline_mr2@hotmail.com', '', '0', '', '1', '2011-06-15 00:41:35'),
(71, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '陳子謙', 'CHAN CHI HIM', '', '66544217', 'chihim_c@hotmail.com', '', '0', '', '0', '2011-06-15 00:44:50'),
(72, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'D', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '何順影', 'HO SON IENG', '', '66623334', 'yumiho126@gmail.com', '', '0', '', '1', '2011-06-15 17:22:51'),
(73, 'B', '\0', '\0', '\0', 'B', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'D', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '楊偉豪', 'Ieong Wai Hou', '', '66889288', 'ieongwaihou@yahoo.com.hk', '', '1', 'bmw x5 e70', '1', '2011-06-16 01:44:17'),
(74, 'B', '\0', '\0', '\0', 'B', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '林嘉濠', 'Lam Ka Hou', '', '66534476', 'luis24@livemail.tw', '', '0', '', '1', '2011-06-16 15:31:55'),
(75, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '王明慧', 'WANG MING HUI', '', '66453188', 'mhnicole0909@hotmail.com', '', '0', '', '1', '2011-06-16 17:09:01'),
(76, 'B', '\0', '\0', '\0', 'B', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '甘曉峰', 'kam hio fong', '', '66861714', 'kam_kyle@hotmail.com', '', '1', 'honda  accord', '1', '2011-06-17 16:39:23'),
(77, 'B', '\0', '\0', '\0', 'B', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '李瑞森', 'Lei Soi Sam', '', '66778215', 'lei930@gmail.com', '', '1', 'Lexus, IS250', '1', '2011-06-17 16:42:02'),
(78, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '何川', 'Ho Chun', '', '66294882', 'hochunmacau@gmail.com', '', '0', '', '1', '2011-06-17 18:48:20'),
(79, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '曾嘉慧', 'CHANG KA WAI', '', '66755454', 'kawai_5_8@yahoo.com.hk', '', '0', '', '0', '2011-06-17 19:42:37'),
(80, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '周聖山', 'Zhou Sheng Shan', '', '66876040', 'xavi3r@gmail.com', '', '0', '', '1', '2011-06-19 03:38:57'),
(81, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '胡东', 'hudong', '', '15968186426', '409027972@qq.com', '', '1', '', '1', '2011-06-22 13:53:55'),
(82, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '梁嘉欣', 'LEONG KA IAN', '', '66141232', 'ian88_ian88@hotmail.com', '', '0', '', '1', '2011-06-22 21:05:04'),
(83, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '陳躬玲', 'Chan Kong Leng', '', '63060800', 'kongleng2001@yahoo.com.hk', '', '1', 'Swift', '1', '2011-06-22 22:25:00'),
(84, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '韋翠怡', 'Vai Choi I', '', '(853)66836907', 'fannyvai@hotmail.com', '', '0', '', '0', '2011-06-23 17:27:21'),
(85, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '黃海鋒', 'Wong Hoi Fong', '', '66593541', 'roy.wong.318@hotmail.com', '', '0', '', '1', '2011-06-25 22:37:19'),
(86, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '黃勵敏', 'Wong Lai Man', '', '66430017', 'mandy_wong_817@yahoo.com.hk', '', '0', '', '0', '2011-06-25 23:08:03'),
(87, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '鄧佩容', 'Tang Pui Iong', '', '28235617', 'miki-macau@hotmail.com', '', '0', '', '0', '2011-06-25 23:09:20'),
(88, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '黃鎮江', 'Wong Chan Kong', '', '28235617', 'roy_wong_318@yahoo.com.hk', '', '0', '', '0', '2011-06-25 23:24:10'),
(89, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '黃婉盈', 'Wong Un Ieng', '', '66335466', 'elaine91129@hotmail.com', '', '0', '', '0', '2011-06-25 23:39:57'),
(90, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '梁映雪', '', '', '66673630', 'reev3z@gmail.com', '', '1', '', '', '2011-06-30 22:13:43'),
(91, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '周家發', 'Chao Ka Fat', '', '66806867', 'chaokafa@163.com', '', '1', 'march', '0', '2011-06-30 22:18:47'),
(92, 'B', '\0', '\0', '\0', 'D', '\0', '\0', '\0', 'B', '\0', '\0', 'C', '\0', '\0', 'B', '\0', '\0', '\0', 'A', '\0', '\0', '\0', '梁國維', 'LEONG KUOK WAI', '', '62089026', 'WAI@qq.com', '', '0', 'march', '1', '2011-06-30 22:38:04');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `lifestyle`
--

CREATE TABLE IF NOT EXISTS `lifestyle` (
  `ls_id` bigint(20) NOT NULL auto_increment,
  `ls_class` varchar(42) NOT NULL default '',
  `ls_name` varchar(42) NOT NULL default '',
  `ls_subtitle` varchar(42) NOT NULL default '',
  `ls_main` text NOT NULL,
  `ls_price` varchar(42) NOT NULL default '',
  `is_pic` varchar(42) NOT NULL default '',
  PRIMARY KEY  (`ls_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='lifestyle~' AUTO_INCREMENT=261 ;

--
-- Gegevens worden uitgevoerd voor tabel `lifestyle`
--

INSERT INTO `lifestyle` (`ls_id`, `ls_class`, `ls_name`, `ls_subtitle`, `ls_main`, `ls_price`, `is_pic`) VALUES
(225, '52', 'Set 1', '80 93 0 396 137', 'Whether with the BMW Baby Racer or the BMW Bikes: for young children to behave correctly on the road, they have to learn to obey the rules of the road at an early age. The road signs (height: 68 cm) are the perfect basis for correct behaviour both in the living room and on the road, making learning the rules of the road easy and fun. And the fully-functional traffic lights (height: 72 cm) made from hard-wearing plastic give the green light for play and fun.', 'HKD 290.00', 'b_201008061281081827.jpg'),
(226, '52', 'Set 2', '80 93 0 396 138', 'Whether with the BMW Baby Racer or the BMW Bikes: for young children to behave correctly on the road, they have to learn to obey the rules of the road at an early age. The road signs (height: 68 cm) are the perfect basis for correct behaviour both in the living room and on the road, making learning the rules of the road easy and fun. And the fully-functional traffic lights (height: 72 cm) made from hard-wearing plastic give the green light for play and fun.', 'HKD 290.00', 'b_201008061281081868.jpg'),
(227, '111', 'M Sports Chronograph', '80 26 2 147 048', 'Sporty chronograph watch with brushed stainless steel case. The face has a modern carbon styling and raised coloured BMW M logo. Swiss precision quartz movement. Water-resistant up to 10 atm. Mineral glass for scratchresistance. With stopwatch function, date display and small second display. Anthracite leather strap with metal clasp. Laser-engraved BMW logo on the back.', 'HKD 3,000.00', 'b_201008061281081928.jpg'),
(228, '111', 'M Watch', '80 26 2 159 890', 'Contemporary: sporty watch with high-quality stainless-steel case, modern black rubber strap and red hands. Scratch-resistant mineral glass, a Ronda Swiss movement and water-resistance up to 5 atm ensure lasting joy. The black display, which includes an M logo, also indicates the date and day of the week.', 'HKD 2,780.00', 'b_201008061281081987.jpg'),
(229, '112', 'M Cufflinks', '80 23 2 147 071', 'These will make you want to wear a shirt more often: high-quality metal cufflinks with an embossed M logo on the face.', 'HKD 421.00', 'b_201008061281082041.jpg'),
(230, '112', 'M Fabric Travel Bag', '80 22 2 147 066', 'Fabric cabin bag in understated anthracite, zip with original BMW M double-spoke design. Two inner pockets with a carbonstyle look and four pen holders in red Alcantara. Padded carry straps and comfortable shoulder carry strap with dynamic red stripes. With BMW M logo and BMW pin. High quality leather address tag included.Dimensions (L x W): approx. 50 x 28', 'HKD 3,656.00', 'b_201008061281082093.jpg'),
(231, '112', 'M Fabric Cabin Bag', '80 22 2 147 344', 'Turn packing your bags into bags of joy. This travel bag is made from an anthracite-coloured fabric and features a zip with the original BMW M double-spoke design. Two inner pockets with a carbon-style look and four pen holders in red Alcantara. Padded carry straps and comfortable shoulder carry strap with dynamic red stripes. With BMW logo and BMW pin. High-quality leather address tag included.Dimensions (L x W): approx. 65 x 34 cmAntracite/Red.', 'HKD 3,580.00', 'b_201008061281082135.jpg'),
(232, '71', 'Ladies'' Funcitonal Polo Shirt', '80 33 2 155 201~205(XS~XL)', 'Feminine polo shirt with green contrasting inserts and decorative seams. Fashionable look because of tapered fit. Breathable, quickdrying material for optimum moisture transport. BMW logo on the left sleeve. Printed with &quot;BMW Golfsport&quot;. Material: 100% polyamide.', 'HKD 807.00', 'b_201008061281082201.jpg'),
(233, '71', 'Ladies'' Striped Polo Shirt', '80 33 2 155 196~200(XS~XL)', 'Sporty polo shirt with 3-button strip, white with contrasting green stripes. Feminine look because of tapered fit. BMW logo on the left sleeve. Printed with discreet &quot;BMW Golfsport&quot; lettering. Material: 100 % cotton. ', 'HKD 673.00', 'b_201008061281082268.jpg'),
(234, '72', 'Men''s Functional Polo Shirt', '80 33 2 155 191~195(S~XXL)', 'Sporty short-sleeved polo shirt with half zip fastener. Green inserts and decorative seams on the sides and sleeves. Breathable, quick-dryingmaterial for optimum moisture transport. BMW logo on the left sleeve. Printed with &quot;BMW Golfsport&quot;. Material: 100 % polyamide. ', 'HKD 807.00', 'b_201008061281082324.jpg'),
(235, '72', 'Men''s Striped Polo Shirt', '80 33 2 155 186~190(S~XXL)', 'Classic white 3-button polo shirt. Sporty design with contrasting green stripes. Printed with discreet &quot;BMW Golfsport&quot; lettering. BMW logo on the left sleeve. Material: 100 % cotton.', 'HKD 673.00', 'b_201008061281082359.jpg'),
(236, '73', 'Golf Sports Bag(Black)', '80 33 2 153 376', 'Roomy sports bag with padded carry strap. Handy front pocket with subdivided interior compartments, ventilated shoe compartment plus accessory pocket on the outside. There is a fl eece-lined audio pocket with headphones output at the top. The main compartment with a large opening offers plenty of room for conveniently removing and putting in items. Embroidered with BMW logo and &quot;BMW Golfsport&quot;. BMW Golf Sport design in cooperation with OGIO.\r\nDimensions (L x W x H): approx. 60 x 24 x 29 cm.\r\nMaterial: nylon (black).', 'HKD 780.00', 'b_201008061281082407.jpg'),
(237, '73', 'Golf Sports Bag(White)', '80 33 2 153 377', 'Roomy sports bag with padded carry strap. Handy front pocket with subdivided interior compartments, ventilated shoe compartment plus accessory pocket on the outside. There is a fl eece-lined audio pocket with headphones output at the top. The main compartment with a large opening offers plenty of room for conveniently removing and putting in items. Embroidered with BMW logo and &quot;BMW Golfsport&quot;. BMW Golf Sport design in cooperation with OGIO.\r\nDimensions (L x W x H): approx. 60 x 24 x 29 cm.\r\nMaterial: nylon (white).', 'HKD 780.00', 'b_201008061281082446.jpg'),
(238, '73', 'Golf Bag', '80 33 0 421 826', 'With compartments for scorecards, golf balls and valuables. Made of black nylon, with white and silver accents and embroidered logos. Double rucksack-type carrying straps, patented ergonomic three-point plastic handle, travel cover, drinks compartment (0.5 litres), ball dispenser (three balls), anti-twist cart strap for trolley or golf buggy, 9-inch EVA Woode Top. Manufactured by OGIO, with the BMW Golfsport design.\r\nDimensions (L x W x H): 23 x 38 x 93 cm approx.', 'HKD 2,600.00', 'b_201008061281082579.jpg'),
(239, '73', 'Golf Cart Bag', '80 33 2 153 378', 'This highly functional, sporty cart bag is a virtuoso even away from the course. This is assured by eleven special compartments, such as the fl eece-lined pocket for valuables, the interior mobile phone pocket and the spacious club compartment with seven subdivisions. Equally practical are the rain hood with zip fastener for easy attachment, the Velcro strip for securing golfing gloves, the special tee holder, the insulated drinks compartment, the lift grip for easy handling as well as fasteners for a club cloth and umbrella. With shoulder strap, practical adjustable foot and carry handle. BMW Golf Sport design in cooperation with OGIO. Weight: 3.45 kg.\r\nDimensions (L x W x H): 40 x 35 x 94 cm.\r\nMaterial: leatherette, nylon.', 'HKD 2,800.00', 'b_201008061281082632.jpg'),
(240, '73', 'Golf Cap (Black)', '80 33 2 153 374', 'Elegant cap with pre-curved sandwich peak. Adjustable nape band. Black: embroidered stripes on visor. Embossed metal BMW logo, embroidered with &quot;BMW Golfsport&quot;.\r\nMaterial: 100 % cotton. ', 'HKD 330.00', 'b_201008061281082675.jpg'),
(241, '73', 'Golf Cap (White)', '80 33 2 153 375', 'Elegant cap with pre-curved sandwich peak. Adjustable nape band. White: understated, green piping. Embossed metal BMW logo, embroidered with &quot;BMW Golfsport&quot;.\r\nMaterial: 100 % cotton.', 'HKD 330.00', 'b_201008061281082716.jpg'),
(242, '73', 'Golf Gift Set', '80 33 2 159 428', 'The right kit for a successful day on the course. The set includes three Titleist ProV1 golf balls, a pitch fork, a ball marker, a club towel and ten golf tees. Delivered in quality presentation box.', 'HKD 700.00', 'b_201008061281082757.jpg'),
(243, '91', 'Yachting Cap', '80 30 2 153 419', 'Functional, dark blue cap in six-panel shape with metal buckle.\r\nMaterial: 100% cotton.', 'HKD 360.00', 'b_201008061281082831.jpg'),
(244, '91', 'Yachting Sunglasses', '80 30 2 153 418', 'Sunglasses with blue frame and embossed metal &quot;BMW Yachtsport&quot; wordmark on the arms. Shatter-proof, dark plastic lenses with 100% UVA, UVB, and UVC protection up to 400 nm, corresponding to safety class 3. Sporty protective case and cleaning cloth included.', 'HKD 928.00', 'b_201008061281082865.jpg'),
(245, '91', 'Yachting Lanyard', '80 30 2 153 422', 'This compact money purse is made from water-repellent material and comes in a trendy marine look with dark blue stripes and decorative sail emblems. With a zip-fastening coin compartment, notes compartment and other pockets for credit cards and ID papers. The dark blue compass fob can be removed. &quot;BMW Yachtsport&quot; logo lasered on. Material: 100 % polyester. ', 'HKD 215.00', 'b_201008061281082909.jpg'),
(246, '91', 'Yachting Sea Sack', '80 30 2 153 421', 'Marine look kit bag. Made from water-repellant material with impressive storage capecity. A carabiner lock, shoulder strap and carrying handle provide security and comfort. A compass fob is included in the scope of delivery. White, dark blue stripes, printed with the decorative &quot;BMW Yachtsport&quot; and &quot;Match Racer&quot; sail emblems. Capacity: 45 l. Material: 100 % polyester.', 'HKD 1,150.00', 'b_201008061281082960.jpg'),
(247, '46', 'BMW Z4', '80 43 0 427 078', 'With this miniature in 1:18 scale, you can have this stunning model on your desktop. The premium interior includes real leather and carpets. All doors open. And even the M double-spoke wheels are reproduced faithfully down to the smallest detail. Kyosho Corporat. \r\nLength: approx. 20 cm', 'HKD 1200.00', 'b_201008061281083524.jpg'),
(248, '46', 'BMW 750 Li(Titanium Silver)', '80 43 0 445 173', 'Real greatness: the new BMW 7 Series revels in superior sportiness. Not only on the road, but also on your desk. The accuracy of the details on this miniature of the BMW 750 Li leaves no wishes unfulfilled. The small version of the big luxury saloon embodies perfect elegance so pristinely that you''d just love to get in.\r\nManufacturer: Kyosho', 'HKD 950.00', 'b_201008061281083556.jpg'),
(249, '121', 'BMW Wash &amp; Wax', '83 12 9 408 919&lt;br&gt;500ml', 'Two in one: dissolves and removes soiling, at the same time preserving the paintwork.', 'HKD 128.00 ', 'b_201008061281083667.jpg'),
(250, '121', 'BMW Express Wax', '83 12 0 396 770&lt;br&gt;500ml', 'Fast-acting liquid care agent for a lasting shine. Selected components cause spontaneous waster displacement, facilitating chamois cleaning and providing excellent paintwork care.', 'HKD 116.00 ', 'b_201008061281084049.jpg'),
(251, '121', 'BMW Car Wax', '83 12 0 002 719&lt;br&gt;500ml', 'Ideal for new and cleaned paintwork. Particularly easy to polish and can be applied to wet paintwork immediately after the vehicle wash. The high-quality natural waxes (carnauba) provide long-term weather resistance.', 'HKD 148.00 ', 'b_201008061281084180.jpg'),
(252, '121', 'BMW Car Polish', '83 12 9 408 526&lt;br&gt;500ml', 'Ideal for slightly scratched matt coloured and metallic paintwork surfaces. Polishes and preserves in a single operation. Micro-fine polishing agents clean gently, and high-quality waxes (carnauba) provide lasting weather resistance. For this reason, subsequent sealing is not required.', 'HKD 178.00 ', 'b_201008061281084248.jpg'),
(253, '121', 'Leather Cleaning Foam', '83 12 9 407 907&lt;br&gt;300ml', 'For thorough, protective cleaning of all BMW leather trim. Also suitable for rough leather and fabrics.', 'HKD 174.50 ', 'b_201008061281084344.jpg'),
(254, '121', 'Cockpit-Spray', '83 12 0 004 069&lt;br&gt;300ml', 'Silicone-free care product for all cockpit surfaces made of plastic, wood or metal. Freshens up colour and gives the interior a pleasant scent. Antistatic and therefore dust-resistant.', 'HKD 132.00 ', 'b_201008061281084403.jpg'),
(255, '121', 'Interior Cleaner', '83 12 0 413 014&lt;br&gt;250ml', 'Protective cleaner for fast and thorough cleaning of all fabrics and plastics in the vehicle interior (e.g. fabric seats and interior trim). With fresh scent.', 'HKD 88.00 ', 'b_201008201282297864.jpg'),
(256, '121', 'Plastic Care Emulsion', '83 12 0 413 488&lt;br&gt;200ml', 'For a silk matt gloss on all plastic surfaces, inside and outside. Antistatic, provides lasting protection from embrittlement and greying.', 'HKD 128.00 ', 'b_201008061281084515.jpg'),
(222, '51', 'BMW Cruise Bike Junior(Metallic Shell)', '80 91 2 149 175', 'The BMW Cruise Bike Junior does not just impress its riders, but also their parents. Durable, low-maintenance equipment, reliable technology and a high-strength frame make this a bike fit for any adventure. Because pleasure is a question of the right technology. As also proven by the new BMW X1, ideal for the trouble-free transportation of the BMW Cruise Bike Junior.\r\nThe high-strength aluminium frame is perfectly adapted to the physiognomy of 6&frac12; to 9 year-old children. Three independent brakes ensure short braking distances even from high speeds.', 'HKD 6,450.00', 'b_201008061281081687.jpg'),
(223, '51', 'BMW Cruise Bike Junior(Steel Blue)', '80 91 2 149 174', 'The BMW Cruise Bike Junior does not just impress its riders, but also their parents. Durable, low-maintenance equipment, reliable technology and a high-strength frame make this a bike fit for any adventure. Because pleasure is a question of the right technology. As also proven by the new BMW X1, ideal for the trouble-free transportation of the BMW Cruise Bike Junior.\r\nThe high-strength aluminium frame is perfectly adapted to the physiognomy of 6&frac12; to 9 year-old children. Three independent brakes ensure short braking distances even from high speeds.', 'HKD 6,450.00', 'b_201008061281081737.jpg'),
(224, '52', 'Traffice Lights', '80 93 0 396 136', 'Traffic Lights', 'HKD 380.00', 'b_201008061281081790.jpg'),
(220, '51', 'BMW Kidsbike (Blue)', '80 91 0 409 791', 'Switching from pushbike to pedal bike is easy with the BMW Kidsbike. Not just for children, but also for their parents: the pedal and chain unit can be fitted to the pushbike in no time. The solid plastic pedals with reflectors provide additional traffic safety, and the coaster brake included in the pedal unit ensures children can brake easily and safely at a moment&amp;#146;s notice.\r\nIncluded with the bike is a T&Uuml;V-approved children''s bike helmet with a reflective surface.', 'HKD 4,250.00', 'b_201008061281081538.jpg'),
(221, '51', 'BMW Kidsbike (Red)', '80 91 0 434 341', 'Switching from pushbike to pedal bike is easy with the BMW Kidsbike. Not just for children, but also for their parents: the pedal and chain unit can be fitted to the pushbike in no time. The solid plastic pedals with reflectors provide additional traffic safety, and the coaster brake included in the pedal unit ensures children can brake easily and safely at a moment&amp;#146;s Included with the bike is a T&Uuml;V-approved children''s bike helmet with a reflective surface.', 'HKD 4,250.00', 'b_201008061281081584.jpg'),
(216, '51', 'BMW 3 Series Convertible(Electric version)', '80 93 2 158 899', 'Electric car (6V batteries) with automatic engine brake. Adjustable seat, rubber wheels. Made from tough plastic containing no harmful substances. Suitable for ages 3 to 5 approx. Top speed of 4 km/h approx., running time: min. 1.5 hours of continuous operation, charging time: approx. 15 hours; lateral E-Panel for forward and reverse gears.\r\nWeight: approx. 12.5 kg.', 'HKD 4,600.00', 'b_201008061281081381.jpg'),
(217, '51', 'BMW M6 Convertible(Electric version)', '80 93 2 158 901', 'Electric Version. Metallic blue paintwork. Original M front and rear bumpers, M6 wheels and M6 stickers on boot lid and front wings. With electric horn and speedometer. Material: painted steel frame, plastic containing no harmful substances. Max. load: 50 kg. For ages 4 to 7 approx. Adjustable operating speed: 8 km/h forward and 4 km/h reverse, running time: minimum 1.5 hours of continuous operation, charging time: approx. 15 hours, forward and reverse gears, foot brake, double brake function for added safety. Weight: approx. 17 kg.', 'HKD 6,300.00', 'b_201008061281081415.jpg'),
(218, '51', 'BMW 328 Roadster(Electric version)', '80 93 2 149 182', 'A classic for little drivers. The timeless, unique design is by no means all the BMW 328 Roadster has to offer. This stylish car also makes your pulse race with its chrome-plated radiator grille and realistic wheel rims. Of course the Roadster is T&Uuml;V-tested and easy to operate. Special rubber tyres ensure that even indoor noise and damage to wooden floors won&amp;#146;t bother your driving pleasure. Pedal or electric versions available. Suitable for children ages 3 to 5.', 'HKD 5,000.00', 'b_201008061281081463.jpg'),
(219, '51', 'BMW Kidsbike (Orange)', '80 91 0 417 900', 'Switching from pushbike to pedal bike is easy with the BMW Kidsbike. Not just for children, but also for their parents: the pedal and chain unit can be fitted to the pushbike in no time. The solid plastic pedals with reflectors provide additional traffic safety, and the coaster brake included in the pedal unit ensures children can brake easily and safely at a moment&amp;#146;s notice.\r\nIncluded with the bike is a T&Uuml;V-approved children''s bike helmet with a reflective surface.', 'HKD 3,393.00', 'b_201008061281081502.jpg'),
(214, '51', 'BMW Baby Racer II Motorsports', '80 93 2 163 090', 'For the racing drivers of tomorrow. With sports steering wheel, front spoiler, speedometer and rev counter, metallic-effect front and rear sections and BMW logo. Rubber tyres minimise noise. T&Uuml;V-approved. Suitable for ages 1&frac12; to 3. Dimensions (L x W x H): 73 x 32.5 x 40 cm, Wheelbase: 44 cm, Weight: 6.4 kg', 'HKD 1,148.00', 'b_201008061281081272.jpg'),
(215, '51', 'BMW Junior Bike', '80 93 0 145 906', 'A really big little bike: the Junior Bike''s looks are based on the full-size BMW R 1100 GS, making it much more than your average tricycle. The new edition in a blue/yellow colour combination will win many new fans &amp;#150; especially thanks to its improved ergonomics. With its big, smooth-turning wheels the Junior Bike offers excellent handling for little ones. Its modular structure makes it easy to dismantle and transport. Suitable for ages 3 to 5 years. Dimensions: length: 71 cm, width: 37.5 cm, height: 56 cm, wheel base: 48.5 cm, weight: 4.5 kg.', 'HKD 1,217.00', 'b_201008061281081326.jpg'),
(211, '22', 'Drinks Bottle and Holder', '80 92 0 414 346', 'Lightweight, stylisch aluminium bottle with handy sports top. Guaranteed leak-proof, coated for food safety, holds hot and ccold drinks (tested by the German RWT&Uuml;V technical safety agency). Capacity: 700 ml. The bottle comes with an ergonomically shaped aluminium holder with lateral gel cushioning for securing it safely to your Touring Bike, Cruise Bike or Cross-Country MTB.', 'HKD 357.00', 'b_201008061281080838.jpg'),
(212, '51', 'BMW Baby Racer II(Blue)', '80 93 0 006 909', 'The kids can''t wait to get behind the wheel: a real BMW, with characteristic BMW design and the same state-of-the-art technology that has made the Bayerisches Motor Werk famous the world over. The blue-and-white enamel BMW badge stands proudly on the bonnet and boot. Includes special, wide racing tyres and built-in horn. Suitable for children from 1 to 3 years old. Fulfils German governmental regulations for safety. Cannot be sold in the USA and Canada', 'HKD 1,148.00', 'b_201008061281081126.jpg'),
(213, '51', 'BMW Baby Racer II(Black)', '80 93 0 446 003', 'Sporty Baby Racer with noise-cancelling rubber tyres. Exclusive design, quality workmanship. Comfortable, padded seat in red. Suitable for ages 1 1/2 to 3. T&Uuml;V-approved.\r\nDimensions (L x W x H): 70.5 x 32.5 x 40 cm, Wheelbase: 44 cm, Weight: 4.5 kg(Black)', 'HKD 1,148.00', 'b_201008061281081194.jpg'),
(209, '22', 'Bike Bucksack', '80 92 0 421 746', 'Ideal for day trips. Innovative in design, practical in function. Comfortable shoulder and hip straps, versatile inside and outside pockets, and foldaway helmet holder. Including drink system holder, 3M refl ector and safety blink clip.', 'HKD 980.00', 'b_201008061281080743.jpg'),
(210, '22', 'Bike Saddlebag', '80 92 0 421 825', 'For essential items such as the Micro Tool. Fitted with practical click''n''go holder, 3M refl ector and safety blink clip.\r\nOnly fitting to BMW Cruise Bike.', 'HKD 280.00', 'b_201008061281080790.jpg'),
(207, '22', 'Bike Gloves', '80 92 0 397 570~573(S~XL)', 'High-quality, ergonomical, well-vented. The sewn-in gel pad prevents problems with blood circulation. With additional reinforcement on finger pads, upper side and middle fingertips.', 'HKD 500.00', 'b_201008061281080666.jpg'),
(208, '22', 'Fingerless Bike Gloves', '80 92 0 442 229~232(S~XL)', 'Premium fingerless gloves with gel cushioning and refl ective piping. The integrated gel pad prevents pins and needles and reduces vibration. RubberTech SafeGrip for improved grip on the handlebar. Designed to be easily removed. Embossed logo on the right glove.', 'HKD 450.00', 'b_201008061281080700.jpg'),
(204, '22', 'Spiral Lock', '80 92 0 427 707', 'Cable length: 200 cm, mounted on bike with universal holder.', 'HKD 350.00', 'b_201008061281080550.jpg'),
(205, '22', 'BMW Cable Lock', '80 93 0 441 472', 'Very light safety lock in BMW design, weighs 110 g, with 90 cm (36&quot;) steel cable and easily resettable, 4-digit combination. Can be conveniently carried in pocket. Ideal anti-theft protection or short stops.', 'HKD 284.50', 'b_201008061281080591.jpg'),
(206, '22', 'Standard Bike Helmet', '80 92 0 446 866', 'This sturdy helmet combines optimum safety and low weight. Individual ring system and various air vents. T&Uuml;V/CE-approved. Universal size from 54 to 60.', 'HKD 1,271.00', 'b_201008061281080628.jpg'),
(202, '21', 'M-Bike', '80 91 2 167 827~829(M~XL)', 'BMW M Bike. A spectacular combination of technology, luxury and design: the BMW M Bike. Disc brakes and an elegant, matt anthracite frame bearing the M logo, as well as distinctive rims, handles and a saddle inlay in the hallmark BMW M Red, attract attention. Thanks to the longer overall transmission ratio of the derailleur system, this is a speed bike in the true sense of the word. Both in town and off-road, the high-quality leather fi''zi:k saddle with its red inlay guarantees superior ride comfort and perfect support. The Shimano SLX derailleur system is lightweight and robust. The Manitou Match suspension fork on the front wheel is extremelysturdy, while the disc brakes ensure safestopping. Just like BMW M cars, the BMW M Bike represents sportiness and exclusivity. It will be available in a limited edition by the mid of July.Weight: 12.9 kg. Aluminium frame (AL6061-T6):hydroformed and powder-coated.', 'HKD 21,500.00', 'b_201010121286866775.jpg'),
(203, '22', 'Battery Light Set', '80 92 0 431 648', 'Front and rear lamps with adjustablestraps, suitable for all BMW bikes. Mountwith quick-release adapter. Easy to fi t and removewith one hand. Adjustable front and side angles foroptimum illumination. Brightness:15 lux, light output: 30 hours. Charger and rechargeablebatteries can be retrofi tted.', 'HKD 700.00', 'b_201008061281080497.jpg'),
(182, '13', 'Men''s Chrono with White Face', '80 26 2 147 616', 'Sporty chrono watch with 40 mm stainless steel case. Water-resistant up to 10 atm. Dynamic white face with raised BMW logo. Swiss precision quartz movement. With stopwatch function, date display and small second display. Black leather strap with metal clasp. Laser-engraved BMW logo on the back.', 'HKD 2,521.00', 'b_201008061281066629.jpg'),
(183, '13', 'Men''s Sports Chrono', '80 26 2 147 052', 'Sizeable, sporty chrono watch with 44 mm stainless steel case. Water-resistant up\r\nto 10 atm. Black and white face with raised BMW logo. Swiss precision quartz movement. Mineral glass for scratch-resistance. With stopwatch function, date display and small second display. Sturdy stainless steel strap with metal clasp. Laser-engraved BMW logo on the back.', 'HKD 3,404.00', 'b_201008061281066941.jpg'),
(184, '13', 'Ladies'' Quartz Chronograph', '80 26 2 159 892', 'Timeless beauty: this quartz chronograph with a white face and adjustable metal bracelet combines casual design and classic elegance. With a coloured BMW logo, date display and Swiss precision quartz movement. The high-quality stainless steel case has the BMW logo lasered onto the reverse.', 'HKD 2,269.00', 'b_201008061281067018.jpg'),
(185, '14', 'Travel Bag', '80 22 2 147 077', 'This roomy bag is the perfect partner for when you spontaneously decide to prolong your holiday. The design pairs off leather and nylon, resulting in a dynamic, business-style look. Inner compartments and sections for cards and pens. Padded leather handles and adjustable, comfortable shoulder strap.\r\nDimensions (L x W): approx. 65 x 34 cm', 'HKD 4,664.00', 'b_201008061281067402.jpg'),
(186, '14', 'Business Bag', '80 22 2 147 076', 'Start all your business trips in style. Elegant business bag in a leather/nylon combination. Roomy interior with dividers and compartments for cards and writing utensils. Padded leather handles and adjustable, comfortable shoulder strap. \r\nDimensions (L x W): approx. 50 x 28 cm\r\nBlack', 'HKD 3,899.00', 'b_201008061281067532.jpg'),
(187, '14', 'Document Bag', '80 22 2 147 075', 'Business meets pleasure: this stylish document case reinforces your authoritative business appearance. The black leather and nylon design is impressively stylish and functional. The case includes space for important documents and a removable compartment for laptops measuring up to 15&quot;. A range of inside pockets for cards and pens ensure you keep everything organised.Leather handles and a black shoulder strap ensure it''s comfortable to carry. For business trips, the BMW document case can be attached to a trolley with a leather strap. With BMW zip pull, tonal BMW pin on the outside and leather patch with the motto &quot;Travel in style. Do not settle for anything less.&quot; in the interior. \r\nDimensions (L x W): approx. 40 x 8.5 cm', 'HKD 3,151.00', 'b_201008061281067786.jpg'),
(188, '15', 'BMW Logo', '80 23 0 444 663', 'High-gloss nickel-platedpendants with three-colour BMW logo.', 'HKD 323.00', 'b_201008061281067901.jpg'),
(189, '15', 'BMW Logo', '80 23 0 305 911', 'Bright nickel-plated. With 3-colour BMW logo', 'HKD 323.00', 'b_201008061281067968.jpg'),
(190, '15', 'BMW 1 Series', '80 23 0 305 914', 'Bright nickel-plated. With 3-colour BMW logo.', 'HKD 323.00', 'b_201008061281068011.jpg'),
(191, '15', 'BMW Z3', '80 23 0 432 391', 'High-gloss nickel plating with three-colour BMW logo.', 'HKD 323.00', 'b_201008061281068142.jpg'),
(192, '15', 'BMW Z4', '80 23 0 406 871', 'High-gloss nickel plating with three-colour BMW logo.', 'HKD 323.00', 'b_201008061281068229.jpg'),
(193, '15', 'BMW X3', '80 23 0 305 912', 'Bright nickel-plated. With 3-colour BMW logo.', 'HKD 323.00', 'b_201008061281068292.jpg'),
(194, '15', 'BMW X5', '80 23 0 305 913', 'Bright nickel-plated. With 3-colour BMW logo. ', 'HKD 323.00', 'b_201008061281068387.jpg'),
(195, '15', 'Silver Key Holder Convex', '80 23 0 305 957', 'Silver key holder Convex/Concave leather\r\nKey-rings are available with smooth leather only! Not as pictured! ', 'HKD 1,980.00', 'b_201008061281068455.jpg'),
(196, '16', 'Metal Sunglasses in Grey/Blue', '80 25 2 147 056', 'For excellent visuals: contemporary, slimline metal sunglasses. Shatter-proof blue plastic lenses with 100 % UVA, UVB, and UVC protection up to 400 nm, equivalent to safety class 3. Laser-engraved BMW logo on both temples. Cleaning cloth included.', 'HKD 1,572.00', 'b_201008061281068661.jpg'),
(197, '16', 'Titanium Sports Sunglasses', '80 25 2 147 058', 'Looking good has never been easier: fashionable, lightweight titanium sunglasses. Shatter-proof olive green plastic lenses with 100 % UVA, UVB, and UVC protection up to 400 nm, equivalent to safety class 3. Laser-engraved BMW logo on both temples. Cleaning cloth included.', 'HKD 1,513.00', 'b_201008061281068765.jpg'),
(198, '21', 'BMW Touring Bike', '80 91 2 160 320~324(S~XL)', '27 gears. And every single one of them ensures a great ride. The black-coloured BMW Touring Bike with derailleur system combines contemporary design and optimum comfort. The gel-cushioned saddle turns even a long journey into a comfortable affair. Because we believe that it should be the rider who decides on the length of a tour. To get the bike ready to ride, you only need to do some minor assembly work after delivery (e.g. attaching the pedals, aligning the handlebars). The bike may only be exchanged if it is in its original packaging. BMW bikes cannot be sent outside Europe or to Norway, Spain and Switzerland. Only standard shipping (express is not possible). In the event of any questions or problems, please contact our representatives on our free hotline. Contact details for your country can be found under &quot;Help &amp; Service&quot;. Certain variants are not available before May.', 'HKD 16,000.00', 'b_201008061281068911.jpg'),
(199, '21', 'BMW Cruise Bike(Orange/White)', '80 91 2 160 300~306(S~XL)', 'A ride along a beach or a trip into town. A weekend excursion or a club crawl. The BMW Cruise Bike effortlessly adapts to your lifestyle. The stem can be adjusted to the rider''s height, allowing you to find your own perfect fi t. Select components like the suspension fork, cantilever brake and Shimano Alivio 24-speed derailleur system complement this bike''s extraordinary design and will make you want to be out and about a lot more. To get the bike ready to ride, you only need to do some minor assembly work after delivery (e.g. attaching the pedals, aligning the handlebars). The bike may only be exchanged if it is in its original packaging. \r\nBMW bikes cannot be sent outside Europe or to Norway, Spain and Switzerland. In the event of any questions or problems, please contact our representatives on our free hotline. Contact details for your country can be found under &quot;Help &amp; Service&quot;. Certain variants are not available before May.', 'HKD 12,000.00', 'b_201008061281069214.jpg'),
(200, '21', 'BMW Cruise Bike(Silver/White)', '80 91 2 160 307~310(S~XL)', 'A ride along a beach or a trip into town. A weekend excursion or a club crawl. The BMW Cruise Bike effortlessly adapts to your lifestyle. The stem can be adjusted to the rider''s height, allowing you to find your own perfect fi t. Select components like the suspension fork, cantilever brake and Shimano Alivio 24-speed derailleur system complement this bike''s extraordinary design and will make you want to be out and about a lot more. To get the bike ready to ride, you only need to do some minor assembly work after delivery (e.g. attaching the pedals, aligning the handlebars). The bike may only be exchanged if it is in its original packaging. BMW bikes cannot be sent outside Europe or to Norway, Spain and Switzerland. Only standard shipping (express is not possible). In the event of any questions or problems, please contact our representatives on our free hotline. Contact details for your country can be found under &quot;Help &amp; Service&quot;. Certain variants are not available before March.', 'HKD 12,000.00', 'b_201008061281069280.jpg'),
(201, '21', 'BMW Cruise Bike(Blue/Black)', '80 91 2 160 315~319(S~XL)', 'A ride along a beach or a trip into town. A weekend excursion or a club crawl. The BMW Cruise Bike effortlessly adapts to your lifestyle. The stem can be adjusted to the rider''s height, allowing you to find your own perfect fi t. Select components like the suspension fork, cantilever brake and Shimano Alivio 24-speed derailleur system complement this bike''s extraordinary design and will make you want to be out and about a lot more. To get the bike ready to ride, you only need to do some minor assembly work after delivery (e.g. attaching the pedals, aligning the handlebars). The bike may only be exchanged if it is in its original packaging. BMW bikes cannot be sent outside Europe or to Norway, Spain and Switzerland. Only standard shipping (express is not possible). In the event of any questions or problems, please contact our representatives on our free hotline. Contact details for your country can be found under &quot;Help &amp; Service&quot;. Certain variants are not available before March.', 'HKD 12,000.00', 'b_201008061281069342.jpg'),
(181, '13', 'Quartz Chrono with Metal Bracelet', '80 26 0 432 811', 'Polished stainless-steel case, 40 mm diameter, ETA Swiss movement. Dark face with BMW logo. With stopwatch function, date display, second display with second hand, mineral glass. Water-resistant up to 10 atm. Adjustable metal bracelet with safety clasp. Engraved BMW logo on the back.', 'HKD 3,500.00', 'b_201008061281066188.jpg');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `lifestyle_class`
--

CREATE TABLE IF NOT EXISTS `lifestyle_class` (
  `lsc_parent` varchar(21) NOT NULL default '',
  `lsc_id` varchar(42) NOT NULL default '',
  `lsc_name` varchar(42) NOT NULL default '',
  `sequence` int(11) default '100',
  PRIMARY KEY  (`lsc_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Gegevens worden uitgevoerd voor tabel `lifestyle_class`
--

INSERT INTO `lifestyle_class` (`lsc_parent`, `lsc_id`, `lsc_name`, `sequence`) VALUES
('1', '11', 'Textiles', 100),
('1', '12', 'Pins & Cups', 100),
('2', '21', 'Bikes', 1),
('2', '22', 'Bike Equipment', 2),
('3', '31', 'Money & Cards', 100),
('3', '32', 'Office & Business', 100),
('3', '33', 'Pens & Cases', 100),
('3', '34', 'Everyday & Travel', 100),
('3', '35', 'Keyrings & Cases', 100),
('3', '36', 'Begant Extras', 100),
('4', '41', 'Art Cars', 100),
('4', '42', 'Automobiles', 100),
('4', '45', 'Motorsport', 100),
('4', '43', 'Motorcycles', 100),
('4', '44', 'Mobile Tradition', 100),
('5', '51', 'Vehicles', 1),
('5', '52', 'Toys & Accessories', 2),
('6', '61', 'Accessories', 100),
('6', '62', 'Historic Interest', 100),
('7', '71', 'Ladies', 1),
('7', '72', 'Men', 2),
('7', '73', 'Equipment', 3),
('1', '16', 'Sunglasses', 4),
('1', '13', 'Watch', 1),
('1', '14', 'Bag', 2),
('9', '91', 'Accessories', 1),
('11', '111', 'Watch', 1),
('10', '101', 'Equipment', 100),
('1', '15', 'Key Ring', 3),
('11', '112', 'Accessories', 2),
('12', '121', 'Original Car Care Products', 1),
('4', '46', '01:18', 1),
('0', '0', 'Current Promotions', 1);

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `lifestyle_class0`
--

CREATE TABLE IF NOT EXISTS `lifestyle_class0` (
  `lsc_parent` varchar(21) NOT NULL default '',
  `lsc_name` varchar(42) NOT NULL default '',
  `sequence` int(11) NOT NULL default '100',
  PRIMARY KEY  (`lsc_parent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Gegevens worden uitgevoerd voor tabel `lifestyle_class0`
--

INSERT INTO `lifestyle_class0` (`lsc_parent`, `lsc_name`, `sequence`) VALUES
('1', 'BMW  Collection', 1),
('2', 'Bikes & Equipment', 2),
('3', 'Accessories', 100),
('4', 'Miniatures', 7),
('5', 'Kids'' Collection', 3),
('6', 'Mobile Tradition', 100),
('7', 'BMW Golfsport  Collection', 5),
('8', 'Specials', 100),
('9', 'BMW Yachtsport Collection', 6),
('10', 'Equipment', 100),
('11', 'BMW M Collection', 4),
('12', 'BMW Car Care Products', 8),
('0', 'Current Promotions', 0);

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `lifestyle_class~old`
--

CREATE TABLE IF NOT EXISTS `lifestyle_class~old` (
  `lsc_parent` varchar(21) NOT NULL default '',
  `lsc_id` varchar(42) NOT NULL default '',
  `lsc_name` varchar(42) NOT NULL default '',
  PRIMARY KEY  (`lsc_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Gegevens worden uitgevoerd voor tabel `lifestyle_class~old`
--

INSERT INTO `lifestyle_class~old` (`lsc_parent`, `lsc_id`, `lsc_name`) VALUES
('1', '11', 'Textiles'),
('1', '12', 'Pins & Cups'),
('2', '21', 'Bikes'),
('2', '22', 'Bike Equipment'),
('3', '31', 'Money & Cards'),
('3', '32', 'Office & Business'),
('3', '33', 'Pens & Cases'),
('3', '34', 'Everyday & Travel'),
('3', '35', 'Keyrings & Cases'),
('3', '36', 'Begant Extras'),
('4', '41', 'Art Cars'),
('4', '42', 'Automobiles'),
('4', '45', 'Motorsport'),
('4', '43', 'Motorcycles'),
('4', '44', 'Mobile Tradition'),
('5', '51', 'Vehicles'),
('5', '52', 'Toys & Accessories'),
('6', '61', 'Accessories'),
('6', '62', 'Historic Interest'),
('7', '71', 'Women'),
('7', '72', 'Men'),
('7', '73', 'Equipment'),
('8', '8', 'Specials');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `lifestyle~old`
--

CREATE TABLE IF NOT EXISTS `lifestyle~old` (
  `ls_id` bigint(20) NOT NULL auto_increment,
  `ls_class` varchar(42) NOT NULL default '',
  `ls_name` varchar(42) NOT NULL default '',
  `ls_subtitle` varchar(42) NOT NULL default '',
  `ls_main` text NOT NULL,
  `ls_price` varchar(42) NOT NULL default '',
  `is_pic` varchar(42) NOT NULL default '',
  PRIMARY KEY  (`ls_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=153 ;

--
-- Gegevens worden uitgevoerd voor tabel `lifestyle~old`
--

INSERT INTO `lifestyle~old` (`ls_id`, `ls_class`, `ls_name`, `ls_subtitle`, `ls_main`, `ls_price`, `is_pic`) VALUES
(31, '11', 'Cap with Propellor', ' Art. Nr. 80 16 0 396 623', 'Classic baseball cap with BMW logo embroidery on centre front - Material: 100% Cotton, brushed twill\r\n \r\n', '', 'b_200606101149916346.jpg'),
(30, '11', ' Cap "BMW"', ' Art. Nr. 80 16 0 396 628', 'Classic baseball cap with tonal ��BMW�� embroidery on left front - Material: 100% Cotton, brushed twill\r\n\r\n\r\n', '', 'b_200606101149916295.jpg'),
(8, '22', 'BMW Bike Helmet', 'Art. Nr. 80 92 0 134 553', 'Provide maximum safety in the event of a fall. The direct connection between outer shell and inner body (created by the in-moulding process) guarantees a high degree of shatter-proofing combined with low weight. High wearer comfort is attained by means of finely interwoven attachment straps, individual ring system adjustment and the provision of sufficient ventilation openings. ', 'MOP 1,200.00', 'b_200604041144139127.jpg'),
(10, '12', 'Pins BMW 3 Series Saloon', ' Art. Nr. 80 55 0 395 346', 'Metal pin with coloured enamelling. Ball clasp on back', ' MOP60', 'b_200606091149839518.jpg'),
(11, '12', 'Pins BMW 7 Series', ' Art. Nr. 80 56 0 309 319', 'Metal pin with coloured enamelling. Ball clasp on back.', ' MOP60', 'b_200606091149836436.jpg'),
(12, '12', 'M pin', ' Art. Nr. 80 56 0 391 652', 'Three-dimensional curved pin with coloured enamelling. Ball clasp on back. \r\n', '', 'b_200606091149836715.jpg'),
(13, '12', 'Collectors'' Mugs BMW 1 Series', ' Art. Nr. 80 56 0 391 165', 'High-quality china mugs with handle, approx. capacity 0.35 l. Exclusive BMW design', ' -', 'b_200606091149836891.jpg'),
(14, '12', 'Collectors'' Mugs BMW 3 Series Saloon', ' Art. Nr. 80 56 0 396 814', 'High-quality china mugs with handle, approx. capacity 0.35 l. Exclusive BMW design', '', 'b_200606091149837009.jpg'),
(15, '12', 'Collectors'' Mugs BMW 5 Series Saloon', ' Art. Nr. 80 56 0 391 167', 'High-quality china mugs with handle, approx. capacity 0.35 l. Exclusive BMW design.\r\n\r\n', ' MOP160', 'b_200606091149837096.jpg'),
(16, '12', 'Collectors'' Mugs BMW 6 Series Coup&eacute;', 'Art. Nr. 80 56 0 391 168', 'High-quality china mugs with handle, approx. capacity 0.35 l. Exclusive BMW design.\r\n', ' MOP160', 'b_200606091149837158.jpg'),
(17, '12', 'Collectors'' Mugs BMW 7 Series', ' Art. Nr. 80 56 0 391 169', 'High-quality china mugs with handle, approx. capacity 0.35 l. Exclusive BMW design.\r\n \r\n\r\n', 'MOP160', 'b_200606091149837231.jpg'),
(18, '12', 'Collectors'' Mugs BMW X3', ' Art. Nr. 80 56 0 391 170', 'High-quality china mugs with handle, approx. capacity 0.35 l. Exclusive BMW design.\r\n\r\n\r\n', ' MOP160', 'b_200606091149837303.jpg'),
(19, '12', 'Collectors'' Mugs BMW X5', ' Art. Nr. 80 56 0 396 817', 'High-quality china mugs with handle, approx. capacity 0.35 l. Exclusive BMW design.\r\n \r\n', '', 'b_200606091149837355.jpg'),
(20, '12', 'Collectors'' Mugs BMW Z4', ' Art. Nr. 80 56 0 391 171', 'High-quality china mugs with handle, approx. capacity 0.35 l. Exclusive BMW design.\r\n \r\n', ' MOP160', 'b_200606091149837426.jpg'),
(21, '12', 'Pins BMW 3 Series Coup&eacute;', ' Art. Nr. 80 56 0 309 313', 'Metal pin with coloured enamelling. Ball clasp on back.\r\n', '', 'b_200606091149838252.jpg'),
(22, '12', 'Pins BMW 6 Series Convertible', ' Art. Nr. 80 56 0 309 318', 'Metal pin with coloured enamelling. Ball clasp on back.\r\n\r\n', '', 'b_200606091149838466.jpg'),
(23, '12', 'Pins BMW 6 Series Coup&eacute;', ' Art. Nr. 80 56 0 309 317', 'Metal pin with coloured enamelling. Ball clasp on back\r\n\r\n', '', 'b_200606091149838628.jpg'),
(24, '12', 'Pins BMW X3', ' Art. Nr. 80 56 0 309 320', 'Metal pin with coloured enamelling. Ball clasp on back.\r\n', '', 'b_200606091149838724.jpg'),
(25, '12', 'Pins BMW X5', ' Art. Nr. 80 56 0 309 321', 'Metal pin with coloured enamelling. Ball clasp on back.\r\n \r\n', '', 'b_200606091149838783.jpg'),
(26, '12', 'Pins BMW Z4', ' Art. Nr. 80 56 0 309 322', 'Metal pin with coloured enamelling. Ball clasp on back.\r\n', '', 'b_200606091149838923.jpg'),
(27, '12', 'Pins BMW 5 Series Saloon', ' Art. Nr. 80 56 0 309 316', 'Metal pin with coloured enamelling. Ball clasp on back.\r\n', '', 'b_200606091149839008.jpg'),
(28, '12', 'Pins BMW 3 Series Touring', ' Art. Nr. 80 56 0 390 092', 'Metal pin with coloured enamelling. Ball clasp on back.\r\n\r\n', '', 'b_200606091149839097.jpg'),
(29, '12', 'Pins BMW 1 Series', 'Art. Nr. 80 56 0 309 310', 'Metal pin with coloured enamelling. Ball clasp on back.\r\n \r\n\r\n', '', 'b_200606091149839201.jpg'),
(32, '11', 'All Weather Jacket, Unisex', ' Art. Nr. 80 12 0 396 452', 'All weather 2 in 1 jacket, birch, with zip out polar fleece inner jacket - Wind and water proof - Hood inside collar - Adjustable drawstring at hem - Loose fit - Material: Sympatex / Polyester \r\n', '', 'b_200606101149916562.jpg'),
(33, '11', 'Fleece Pullover, Unisex', ' Art. Nr. 80 14 0 396 476', 'Fleece pullover darkblue with standcollar and halfzipper front - Loose fit - Material: 100% Polyester, Polar fleece\r\n', '', 'b_200606101149916672.jpg'),
(34, '11', 'Fleece Pullover, Unisex', ' Art. Nr. 80 14 0 396 470', 'Fleece pullover black with standcollar and halfzipper front - Loose fit - Material: 100% Polyester, Polar fleece\r\n \r\n\r\n', '', 'b_200606101149916746.jpg'),
(35, '11', 'M Collection Jacket, Unisex', ' Art. Nr. 80 12 0 396 630', 'Jacket with taped seams, black - Wind and water proof - M logo badge at left chest - Loose fit - Material: 100% Nylon ', '', 'b_200606101149916943.jpg'),
(36, '11', 'M Collection Men''s Polo Shirt', ' Art. Nr. 80 14 0 396 636', 'Classic 3-button polo shirt black - M logo badge at left sleeve hem - Standard fit - Material: 95% Cotton, 5% Lycra, pique\r\n\r\n\r\n', '', 'b_200606101149917054.jpg'),
(37, '11', 'M Collection Men''s Shirt', ' Art. Nr. 80 14 0 396 641', 'Crewneck T-Shirt black - M logo badge at left chest - Standard fit - Material: 95% Cotton, 5% Lycra\r\n', '', 'b_200606101149917134.jpg'),
(38, '21', 'BMW Cruise Bike', ' Art. Nr. 80 91 0 411 268', 'Aluminium frame. Hydroformed and powder-coated. Colour: Manganeese Silver\r\n \r\n', '', 'b_200606101149917268.jpg'),
(39, '21', 'BMW Mountain Bike Cross Country', ' Art. Nr. 80 91 0 394 033', 'Full suspension with four-bar rear end. Frame hydroformed, BMW Design with integrated logo. With telescopic air fork Manitou Skareb Super and Manitou Swinger 3-way. Colour: Matt black\r\n\r\n', '', 'b_200606101149917353.jpg'),
(40, '21', 'BMW Mountainbike Enduro', ' Art. Nr. 80 91 0 411 276', 'Monocoque frame consisting of two deep-drawn aluminium sections, robot-welded and powder-coated. Colour: Sand Grey/Charcoal.\r\n \r\n', '', 'b_200606101149917434.jpg'),
(41, '21', 'BMW Touring Bike', ' Art. Nr. 80 91 0 411 271', 'Aluminium frame. Hydroformed and powder-coated. Colour: Manganeese Silver\r\n \r\n', '', 'b_200606101149917495.jpg'),
(42, '51', 'Kids'' Bike', ' Art. Nr. 80 91 0 409 791', 'A bike that grows up with you. Children as young as two can use the BMW Kidsbike as a running bike. Once they have enough of running and finally want to ride a bike properly by pedalling, the BMW Kidsbike becomes a child''s bicycle simply by attaching the pedals. While still using the Kidsbike as a running bike, the child develops a natural sense of balance at an early stage and can also practise steering and braking. As soon as the young one feels safe enough, the pedals and chain can be fitted and the height-adjustable seat raised. As with all BMW vehicles, safety is the top priority and so there are many safety features: resilient frame made from high-quality brushed aluminium, plastic pedals are fitted with reflectors, a child-friendly and adjustable cantilever front-wheel brake, back-pedal brake if the pedals are attached, a child-friendly steering design, fully-enclosed chain, protective padding and controlled steering lock. A bell and lights come standard and a DIN-tested cycle helmet is also delivered with the bike.Weight: 6 kg (8 kg with pedals), height 36 cm, min. seat height 38 cm, max. seat height 46 cm, max. weight load 50 kg.\r\n', '', 'b_200606101149917687.jpg'),
(43, '22', 'BMW Bike Gloves', ' Art. Nr. 80 92 0 397 570', 'High-quality, ergonomical, well-vented. The sewn-in gel pad prevents problems with blood circulation. With additional reinforcement on finger pads, upper side and middle fingertips.\r\n\r\n', '', 'b_200606101149917756.jpg'),
(44, '22', 'BMW Bike Rucksack', ' Art. Nr. 80 92 0 301 428', 'Ideal for day trips. Innovative in design, practical in function. Convenient shoulder and hip straps, versatile inside and outside pockets, and foldaway helmet holder. Including drink system holder, 3M reflector and safety blink clip.\r\n', ' MOP980', 'b_200606101149917820.jpg'),
(45, '22', 'BMW Cable Lock', ' Art. Nr. 80 93 0 397 486', 'Very light safety lock in BMW design, weighs 110 g, with 90 cm (36") steel cable and easily resettable, 4-digit combination. Can be conveniently carried in pocket. Ideal anti-theft protection or short stops. \r\n', '', 'b_200606101149917864.jpg'),
(46, '22', 'BMW Micro Tool', ' Art. Nr. 80 92 0 304 330', 'Multifunctional tool with 18 functions - a perfect item of bicycle equipment. Light and compact, it even fits into tour luggage. In addition to the Micro Tool you also receive a neoprene bag to be mounted under the saddle or stored in your pocket.\r\n', ' MOP490', 'b_200606101149917919.jpg'),
(47, '22', 'BMW Miniature Pump', ' Art. Nr. 80 92 0 145 953', 'Manual and cartridge operation. Manometer with display up to 12 bar. Suitable for Schrader and Presta valves. Attractive in shape and ergonomical in design. Small format, lightweight �V fits in your jacket pocket.\r\n', ' MOP340', 'b_200606101149917961.jpg'),
(48, '22', 'BMW Spiral Lock', ' Art. Nr. 80 92 0 143 626', 'Cable length: 200 cm, mounted on bike with universal holder. \r\n \r\n', ' MOP470', 'b_200606101149918011.jpg'),
(49, '22', 'Bike Bag', ' Art. Nr. 80 92 0 021 754', 'Separate side pockets accommodate helmet, shoes and other utensils. Extra padding protects vulnerable components.\r\n \r\n', '', 'b_200606101149918048.jpg'),
(50, '22', 'Drinks Bottle and Holder', ' Art. Nr. 80 92 0 414 346', 'Lightweight, stylisch aluminium bottle with handy sports top. Guaranteed leak-proof, coated for food safety, holds hot and ccold drinks (tested by the German RWT&Uuml;V technical safety agency). Capacity: 700 ml. The bottle comes with an ergonomically shaped aluminium holder with lateral gel cushioning for securing it safely to your Touring Bike, Cruise Bike or Cross-Country MTB.\r\n\r\n', '', 'b_200606121150101028.jpg'),
(51, '22', 'Full Suspension Luggage Rack', ' Art. Nr. 80 92 0 022 024', 'Suitable for the Q5.T, carries up to 10 kg. \r\n\r\n', '', 'b_200606121150101097.jpg'),
(52, '22', 'Luggage Rack (with reflector)', ' Art. Nr. 80 92 0 023 070', 'This luggage rack for the Q5.T will carry up to 1 kg.\r\n\r\n', '', 'b_200606121150101266.jpg'),
(53, '31', 'Gents'' clip wallet', ' Art. Nr. 80 21 0 305 949', 'Gents'' clip wallet. Material: premium German calf leather, tanned and dyed in ItalyMeasurements: (L x W x H) 12.7 x 2.3 x 9.5 cm\r\n \r\n\r\n', '', 'b_200606121150101433.jpg'),
(54, '31', 'Gents'' credit card holder', ' Art. Nr. 80 21 0 395 329', 'Gents'' credit card holder black. Material: premium German calf leather, tanned and dyed in Italy. Measurements: (L x W x H) 12.5 x 1.7 x 9.6 cm\r\n \r\n', '', 'b_200606121150101472.jpg'),
(55, '31', 'Gents'' notecase', 'Art. Nr. 80 21 0 305 920', 'Gents'' notecase black. Material: premium German calf leather, tanned and dyed in Italy. Measurements: (L x W x H) 10.3 x 1.5 x 19.6 cm\r\n \r\n', '', 'b_200606121150101510.jpg'),
(56, '31', 'Gents'' wallet', 'Art. Nr. 80 21 0 305 948', 'Gents'' wallet. Material: premium German calf leather, tanned and dyed in Italy. Measurements: (L x W x H) 12.5 x 1.7 x 9.6 cm\r\n \r\n', '', 'b_200606121150101551.jpg'),
(57, '31', 'Ladies'' purse', ' Art. Nr. 80 21 0 305 917', 'Ladies'' purse. Material: premium German calf leather, tanned and dyed in Italy. Measurements: (L x W x H)11.5 x 2.4 x 10.0 cm\r\n \r\n', '', 'b_200606121150101647.jpg'),
(58, '31', 'Ladies'' purse wide', ' Art. Nr. 80 21 0 305 918', 'Ladies'' purse wide. Material: premium German calf leather, tanned and dyed in Italy. Measurements: (L x W x H) 19 x 2.5 x 10.7 cm\r\n \r\n', '', 'b_200606121150101690.jpg'),
(59, '32', 'Briefcase', ' Art. Nr. 80 21 0 305 950', 'Briefcase. Material: premium German calf leather, tanned and dyed in Italy. Measurements: (L x W x H) 42 x 11,5 x 31 cm\r\n \r\n\r\n', '', 'b_200606121150101790.jpg'),
(60, '32', 'Presentation folder', 'Art. Nr. 80 21 0 305 923', 'Presentation folder. Material: premium German calf leather, tanned and dyed in Italy. Measurements: (L x W x H) 40 x 6.5 x 32 cm\r\n \r\n\r\n', '', 'b_200606121150101845.jpg'),
(61, '32', 'Ladies'' handbag Fashion', ' Art. Nr. 80 21 0 309 006', 'Ladies'' handbag Fashion. Material: premium German calf leather, tanned and dyed in Italy. Measurements: (L x W x H) 38 x 11,4 x 39 cm\r\n \r\n', '', 'b_200606121150102033.jpg'),
(62, '32', 'Ladies'' handbag Klassik', ' Art. Nr. 80 21 0 309 004', 'Ladies'' handbag Klassik. Material: premium German calf leather, tanned and dyed in Italy. Measurements: (L x W x H) 41 x 18 x 25 cm\r\n \r\n', '', 'b_200606121150101952.jpg'),
(63, '33', 'Ball-point pen', ' Art. Nr. 80 24 0 395 344', 'Ball-point pen black leather. Material: brass rotating parts, first blasted and then galvanised\r\n', '', 'b_200606121150102121.jpg'),
(64, '33', 'Ball-point pen', ' Art. Nr. 80 24 0 305 961', 'Ball-point pen black leather. Material: brass rotating parts, first blasted and then galvanised Article number\r\n\r\n', ' MOP890', 'b_200606121150102182.jpg'),
(65, '33', 'Ball-point pen', ' Art. Nr. 80 24 0 305 940', 'Ball-point pen rubber anthracite finish. Material: brass rotating parts, first blasted and then galvanised\r\n ', '', 'b_200606121150102230.jpg'),
(66, '33', 'Fountain pen', ' Art. Nr. 80 24 0 305 960', 'Fountain pen leather.Material: brass rotating parts, first blasted and then galvanised, fountain pen fitted with a white gold wing nib\r\n \r\n', ' MOP1400', 'b_200606121150102277.jpg'),
(67, '33', 'Fountain pen', ' Art. Nr. 80 24 0 395 343', 'Fountain pen black leather. Material: brass rotating parts, first blasted and then galvanised.\r\n \r\n', ' MOP1110', 'b_200606121150102335.jpg'),
(68, '33', 'Fountain pen', ' Art. Nr. 80 24 0 305 939', 'Fountain pen rubber anthracite finish. Material: brass rotating parts, first blasted and then galvanised.\r\n', '', 'b_200606121150102378.jpg'),
(69, '33', ' Roller-ball pen', ' Art. Nr. 80 24 0 395 345', 'Roller-ball pen black leather. Material: brass rotating parts, first blasted and then galvanised, capless fluid cartridge \r\n', '', 'b_200606121150102423.jpg'),
(70, '33', 'Roller-ball pen', ' Art. Nr. 80 24 0 393 005', 'Roller-ball pen leather. Material: brass rotating parts, first blasted and then galvanised, capless fluid cartridge\r\n \r\n\r\n', ' MOP890', 'b_200606121150102471.jpg'),
(71, '33', 'Rotating Pencil', ' Art. Nr. 80 24 0 393 008', 'Rotating Pencil rubber anthracite finish. Material: brass rotating parts, first blasted and then galvanised \r\n \r\n\r\n', ' MOP1090', 'b_200606121150102516.jpg'),
(72, '33', 'Writing utensil holder', ' Art. Nr. 80 21 0 305 968', 'Writing utensil holder. Material: premium German calf leather, tanned and dyed in Italy. Measurements: (L x W x H) 5,3 x 2,5 x 17,2 cm\r\n', '', 'b_200606121150102563.jpg'),
(73, '34', 'Business case', ' Art. Nr. 80 22 0 397 065', 'Suitcase. Material: water-resistant nylon combined with abrasion-resistant PVC. Measurements: (L x W x H) 66 x 49 x 30 cm\r\n', '', 'b_200606121150102844.jpg'),
(74, '34', 'Business case', ' Art. Nr. 80 22 0 305 908', 'Business case. Material: water-resistant nylon combined with abrasion-resistant PVC. Measurements: (L x W x H) 60 x 37 x 26 cm\r\n', '', 'b_200606121150102890.jpg'),
(75, '34', 'Clothes bag', ' Art. Nr. 80 22 0 305 936', 'Clothes bag. The trolley handle is concealed by a zip. Material: water-resistant nylon combined with abrasion-resistant PVC. Measurements: (L x W x H) 64 x 23 x 55 cm\r\n\r\n', '', 'b_200606121150102941.jpg'),
(76, '34', 'Ladies'' City Bag', ' Art. Nr. 80 22 0 305 919', 'Ladies'' City Bag. Material: water-resistant nylon combined with abrasion-resistant PVC. Measurements: (L x W x H) 37 x 12 x 28 cm\r\n', ' MOP1180', 'b_200606121150103001.jpg'),
(77, '34', 'Ladies'' travelbag', ' Art. Nr. 80 22 0 397 068', 'Ladies'' travelbag. Material: water-resistant nylon combined with abrasion-resistant PVCMeasurements: (L x W x H) 60 x 29 x 40 cm\r\n\r\n', '', 'b_200606121150103043.jpg'),
(78, '34', 'Onboard case', ' Art. Nr. 80 22 0 397 067', 'Onboard case. Material: water-resistant nylon combined with abrasion-resistant PVC. Measurements: (L x W x H) 54 x 36 x 20 cm\r\n', ' MOP2000', 'b_200606121150103083.jpg'),
(79, '34', 'Pilot case', 'Art. Nr. 80 21 0 305 951', 'Pilot case. Material: premium German calf leather, tanned and dyed in Italy. Measurements: (L x W x H) 50,5 x 22 x 42 cm\r\n\r\n', '', 'b_200606121150103153.jpg'),
(80, '34', 'Travel/sports bag', ' Art. Nr. 80 22 0 305 937', 'Travel/sports bag. The trolley handle is concealed by a zip.Material: water-resistant nylon combined with abrasion-resistant PVC. Measurements: (L x W x H) 74 x 39 x 33 cm\r\n \r\n\r\n', '', 'b_200606121150103209.jpg'),
(81, '35', 'BMW 7 Series Silver key holder', ' Art. Nr. 80 23 0 154 979', 'BMW 7 Series Silver key holder\r\n \r\n\r\n', 'MOP1450', 'b_200606121150106771.jpg'),
(82, '35', 'Key-rings BMW 7 Series', ' Art. Nr. 80 23 0 149 151', 'Bright nickel-plated. With 3-colour BMW logo.\r\n \r\n', '', 'b_200606121150106916.jpg'),
(83, '35', 'Key-rings BMW 1 Series', ' Art. Nr. 80 23 0 305 914', 'Bright nickel-plated. With 3-colour BMW logo.\r\n', ' MOP300', 'b_200606121150106995.jpg'),
(84, '35', 'Key-rings BMW 3 Series', ' Art. Nr. 80 23 0 136 287', 'Bright nickel-plated. With 3-colour BMW logo\r\n\r\n', '', 'b_200606121150107086.jpg'),
(85, '35', 'Key-rings BMW 6 Series', 'Art. Nr. 80 23 0 305 915', 'Bright nickel-plated. With 3-colour BMW logo\r\n\r\n', ' MOP300', 'b_200606121150107138.jpg'),
(86, '35', 'Key-rings BMW X3', ' Art. Nr. 80 23 0 305 912', 'Bright nickel-plated. With 3-colour BMW logo.\r\n', ' MOP300', 'b_200606121150107262.jpg'),
(87, '35', 'Key-rings BMW X5', ' Art. Nr. 80 23 0 305 913', 'Bright nickel-plated. With 3-colour BMW logo.\r\n', ' MOP300', 'b_200606121150107324.jpg'),
(88, '35', 'Key-rings BMW logo', ' Art. Nr. 80 23 0 305 911', 'Bright nickel-plated. With 3-colour BMW logo.\r\n \r\n', '', 'b_200606121150107387.jpg'),
(89, '35', 'Silver key holder Convex/Concave', ' Art. Nr. 80 23 0 305 957', 'Silver key holder Convex/Concave\r\nleather\r\nKey-rings are available with smooth leather only! Not as pictured!\r\n \r\n\r\n', '', 'b_200606121150107466.jpg'),
(90, '35', 'Silver key holder Freeform', ' Art. Nr. 80 23 0 305 958', 'Silver key holder Freeform\r\n\r\n', '', 'b_200606121150107501.jpg'),
(91, '35', 'Silver key holder Sandwich', 'Art. Nr. 80 23 0 305 964', 'Silver key holder Sandwich\r\nleather\r\nKey-rings are available with smooth leather only! Not as pictured!\r\n \r\n\r\n', '', 'b_200606121150107539.jpg'),
(92, '35', 'VIP key holder', ' Art. Nr. 80 23 0 305 959', 'VIP key holder Silver\r\n \r\n\r\n', '', 'b_200606121150107598.jpg'),
(93, '35', 'Key holder', ' Art. Nr. 80 21 0 305 943', 'Key holder. Material: premium German calf leather, tanned and dyed in Italy. Measurements: (L x W x H) 11,5 x 2,5 x 8,0 cm\r\n', '', 'b_200606121150107655.jpg'),
(94, '36', 'Cufflinks with BMW name logo', ' Art. Nr. 80 23 0 140 215', '935 sterling silver with steel posts, for very special occasions\r\n \r\n\r\n', ' MOP880', 'b_200606121150107722.jpg'),
(95, '36', 'Cufflinks with logo', ' Art. Nr. 80 23 0 134 996', '935 sterling silver with steel posts, for very special occasions\r\n \r\n', ' MOP900', 'b_200606121150107763.jpg'),
(96, '36', 'Pocket umbrella black', ' Art. Nr. 80 23 0 305 901', 'Pocket umbrella black. Material: handle with leather insert, including holder: 100 % teflon-coated polyester\r\n \r\n', '', 'b_200606121150107813.jpg'),
(97, '36', 'Walking-stick umbrella', ' Art. Nr. 80 23 0 305 902', 'Walking-stick umbrella black. Material: lightweight aluminium and fibreglass frame. Handle with pearl-embossed leather insert, 100 % teflon-coated polyester\r\n \r\n\r\n', ' MOP660', 'b_200606121150107863.jpg'),
(98, '51', 'BMW 6 Series Convertible', ' Art. Nr. 80 93 0 309 337', 'Copy of original model, vehicle with painted steel frame and bodywork made of plastic, plastic parts deburred, no risk of sharp edges, single-seater, forward and reverse gear, motor off switch on foot brake, double brake function, larger weels, battery charging level indicator, electronic speed indicator, electric horn in steering wheel, charger, non-toxic, manufactor: Groupe Berchet - Toys Toys, dimension approx. 1400 x 500 x 530 mm, Weight approx. 17 kg, battery-operated 12V (two 6V batteries), minimum run time: 1.5 hours continuous operation, minimum charging time: 15 hours, operating speed adjustable: 4 km/h or 8km/h, all electric components insulated, designed for a permissible driver weight of up to 50 kg.\r\n\r\n', ' MOP5300', 'b_200606121150108082.jpg'),
(99, '51', 'Baby Racer II Edition', ' Art. Nr. 80 93 0 300 429', 'The kids can''t wait to get behind the wheel: a real BMW, with characteristic BMW design and the same state-of-the-art technology that has made the Bayerisches Motor Werk famous the world over. Exciting additional features such as electronic components for real headlights, rear lights and indicators. T&Uuml;V-tested. Suitable for ages 18 month to 3 years.\r\n\r\n', ' MOP1610', 'b_200606121150108251.jpg'),
(100, '51', 'Baby racer II', ' Art. Nr. 80 93 0 006 909', 'The kids can''t wait to get behind the wheel: a real BMW, with characteristic BMW design and the same state-of-the-art technology that has made the Bayerisches Motor Werk famous the world over. The blue-and-white enamel BMW badge stands proudly on the bonnet and boot. Includes special, wide racing tyres and built-in horn. Suitable for children from 1 to 3 years old. Fulfils German governmental regulations for safety. Cannot be sold in the USA and Canada\r\n', ' MOP800', 'b_200606121150108292.jpg'),
(101, '51', 'Junior Bike', ' Art. Nr. 80 93 0 145 906', 'A really big little bike: the Junior Bike''s looks are based on the full-size BMW R 1100 GS, making it much more than your average tricycle. The new edition in a blue/yellow colour combination will win many new fans �V especially thanks to its improved ergonomics. With its big, smooth-turning wheels the Junior Bike offers excellent handling for little ones. Its modular structure makes it easy to dismantle and transport. Suitable for ages 3 to 5 years. Dimensions: length: 71 cm, width: 37.5 cm, height: 56 cm, wheel base: 48.5 cm, weight: 4.5 kg.\r\n', ' MOP1070', 'b_200606121150108331.jpg'),
(102, '51', 'M3 Convertible 12 V', 'Art. Nr. 80 93 0 148 476', 'Grown-ups are dying to climb into it - but sadly, the M3 convertible is strictly for kids. The good-grip rubber tyres and electrical motor provide a real go-kart feeling, making the car really fun to drive. The design clearly resembles the full-size original. A strong structure with a chassis in lacquered tubular steel ensures optimum driving safety. The seat of the M3 convertible adjusts to different sizes to accommodate your child''s growth. In 6V mode the M3 convertible will travel at 4 km/h; switch over to 12V and it will manage 8 km/h. Suitable for children from 4 to 7 years. \r\n\r\n', '', 'b_200606121150108411.jpg'),
(103, '51', 'Z4 6V electric car', ' Art. Nr. 80 93 0 148 471', 'This BMW Z4 will make them at least as happy as its full-size version - and will make an impression on the house circuit. This racy single-seater in the new BMW design is available in 2 versions: as a pedal car with easy-turn comfort pedals, or as a battery-driven electric car with BMW-patented driving electronics. Then it will accelerate smoothly - hurrah! - from 0 to 4 km/h in just a few seconds. To allow for growth, there''s an adjustable driving seat. The robust plastic body will withstand bumps. It''s sure to be No. 1 on their wish list! Suitable for ages 3 to 5 years. Dimensions: length: 113 cm, width: 59.5cm, height: 47 cm, wheel base: 66 cm, weight: approx. 11 kg (electric car), approx. 7 kg (pedal car), useful load: 30 kg.\r\n\r\n', '', 'b_200606121150108485.jpg'),
(104, '51', 'Z4 Pedal version blue', ' Art. Nr. 80 93 0 396 075', 'Z4 Pedal version blue\r\n \r\n\r\n', '', 'b_200606121150108537.jpg'),
(105, '52', 'BMW 5er Micro RC', ' Art. Nr. 80 45 0 309 574', 'Remote controlled BMW 5er Limousine. Remote control with 7 functions (forward, forward-right, forward-left, stop, reverse, reverse-right, reverse-left) and with approx. 50m range. Rechargeable battery: 220V. \r\nManufacturer: Realtoy\r\n', '', 'b_200606121150108668.jpg'),
(106, '52', 'BMW M3 GTR', ' Art. Nr. 80 45 0 146 644', 'American Le Man Series 2001, RC digital-prop, scale 1:24\r\n', ' MOP1090', 'b_200606121150108755.jpg'),
(107, '52', 'BMW X3 RC', ' Art. Nr. 80 45 0 304 428', 'Remote controlled BMW X3. Remote control with 7 functions (forward, forward-right, forward-left, stop, reverse, reverse-right, reverse-left) and with approx. 30m range. Rechargeable battery: 220V. \r\nManufacturer: Dickie-Tamiya\r\n', '', 'b_200606121150108808.jpg'),
(108, '52', 'BMW X5 RC Hobby', 'Art. Nr. 80 45 0 027 853', 'Remote control car scaled to 1:12. Hard plastic body. Remote control range ca. 20m. Speed of up to 18 km/h. Includes remote control, rechargeable battery and charger. Manufacturer: Dickie.\r\n', '', 'b_200606121150108874.jpg'),
(109, '52', 'BMW Z4 Playcar', ' Art. Nr. 80 45 0 305 516', 'The BMW Z4 Playcar is the first product produced in cooperation between BMW and Playmobil. It is a plastic model car (scale approx. 1:18) coordinated perfectly with Playmobil figures in respect of material, textures and proportions. The BMW Z4 Playcar will win fans with its faithful design and the authentic reproduction of the engine under the opening bonnet. Despite their fine looks, BMW Playcars are robust and ideal for play. Equipped with free-turning wheels with rubber tyres, stickers for centre console and two appropriate Playmobil figures.\r\n', ' MOP320', 'b_200606121150108958.jpg'),
(110, '52', 'BMW Z4 RC Hobby', ' Art. Nr. 80 45 0 308 180', 'Remote controlled BMW Z4. Remote control with 7 functions (forward, forward-right, forward-left, stop, reverse, reverse-right, reverse-left) and with approx. 30m range. Rechargeable battery: 110V. \r\nManufacturer: Dickie-Spielzeug.\r\n\r\n', '', 'b_200606121150109037.jpg'),
(111, '52', 'BMW Z8 RC Hobby', ' Art. Nr. 80 45 0 027 854', 'Remote control car scaled to 1:12. Hard plastic body. Remote control range ca. 20m. Speed of up to 18 km/h. Includes remote control, rechargeable battery and charger. Manufacturer: Dickie.\r\n\r\n', ' MOP1230', 'b_200606121150109092.jpg'),
(112, '52', 'Pylone', ' Art. Nr. 80 93 0 396 139', 'Pylone\r\n', ' MOP70', 'b_200606121150109128.jpg'),
(113, '52', 'RC Babyracer', ' Art. Nr. 80 93 0 394 902', 'Remote-controlled toy car, Baby Racer II Edition design, for ages 5+. Features an innovative remote control unit that allows switching from forward motion to reverse simply by rotating the remote control unit. With functioning LED headlights and taillights. Scale: 1:10\r\n', ' MOP200', 'b_200606121150109177.jpg'),
(114, '52', 'Traffic Lights', ' Art. Nr. 80 93 0 396 136', 'Traffic Lights\r\n', ' MOP310', 'b_200606121150109210.jpg'),
(115, '52', 'Traffic signs 1', ' Art. Nr. 80 93 0 396 137', 'Traffic signs 1\r\n', ' MOP250', 'b_200606121150109246.jpg'),
(116, '52', 'Traffic signs 2', ' Art. Nr. 80 93 0 396 138', 'Traffic signs 2\r\n', ' MOP250', 'b_200606121150109275.jpg'),
(117, '71', 'Golf Fleece Jacket', ' Art. Nr. 80 33 0 391 273', 'Stay on top of cold breezes in this lightweight warming, wind-proof and moisture-wicking fleece jacket. It features side pockets with colourcoordinated zippers, a stand collar and microfibre applications at the front. Front: BMW Golfsport badge and BMW propeller stud. Regular fit. Stone grey, with off-white piping; microfleece and microfibre, 100 % polyester.\r\n\r\n', '', 'b_200606121150109368.jpg'),
(118, '71', 'Golf Polo Shirt', ' Art. Nr. 80 33 0 391 252', 'Feel good about every swing in this half sleeve polo shirt: made from breathable, quick-drying fabric, it features a 4-button placket and logo neck tape. Front: BMW Golfsport badge and BMW propeller stud. Regular fit. Light blue, with off-white inserts, and stone grey and off-white collar tipping; 69 % cotton, 31 % polyester.\r\n\r\n', '', 'b_200606121150109423.jpg'),
(119, '71', 'Golf Rain Jacket', ' Art. Nr. 80 33 0 391 293', 'Now you can stay fully focused in the rain - in this water- and windproof rain jacket. It features a foldaway hood and air vents in the back. Waterproof up to 5,000 mm/m2. Front: BMW Golfsport badge and BMW propeller stud. Loose fit. Light blue, with inserts in stone grey and off-white piping; 100 % polyamide, polyurethane-coated.\r\n\r\n', '', 'b_200606121150109460.jpg'),
(120, '71', 'Ladies'' Golf Cap', ' Art. Nr. 80 33 0 393 067', 'Off-white golf cap, peak with light blue sandwich piping, hook and loop fastening with BMW propeller stud, BMW Golfsport badge on front left. 100 % cotton. Size 56.\r\n', ' MOP320', 'b_200606121150109496.jpg'),
(121, '71', 'Ladies'' Golf Glove', ' Art. Nr. 80 33 0 393 057', 'White, professional all-weather synthetic glove, light blue stretch inserts in knuckle area, white piping, hand area with two real-leather inserts, hook and loop fastener, ball marker, made of breathable synthetics and leather. White, with light blue stretch inserts; 100 % synthetics.\r\n\r\n', '', 'b_200606121150109526.jpg'),
(122, '72', 'Golf Polo Shirt', ' Art. Nr. 80 33 0 391 309', 'The breathable fabric used for this short-sleeve polo shirt ensures that you stay relaxed and focused. This quick-drying polo shirt features side inserts, a 4-button placket and logo neck tape. Front: BMW Golfsport badge and BMW propeller stud. Slim fit. Denim blue, with dark blue and tan collar tipping; 69 % cotton, 31 % polyester.\r\n', '', 'b_200606121150109569.jpg'),
(123, '72', 'Golf Rain Jacket', ' Art. Nr. 80 33 0 391 354', 'A sudden shower - no need to give up. Now you can brave the elements in this breathable, wind- and waterproof rain jacket. Foldaway hood, air vents in back, welded seams, waterproof up to 5,000 mm/m2. Front: BMW Golfsport badge and BMW propeller stud. Loose fit. Dark blue, with sand-coloured inserts and denim blue piping. 100 % polyamide, polyure thane-coated.\r\n', '', 'b_200606121150109599.jpg'),
(124, '72', 'Men''s Golf Cap', ' Art. Nr. 80 33 0 393 068', 'Dark blue golf cap, peak with denim blue sandwich piping, hook and loop fastening with BMW propeller stud, BMW Golfsport badge on front left. 100 % cotton. Size 58.\r\n', ' MOP320', 'b_200606121150109634.jpg'),
(125, '72', 'Men''s Golf Glove', 'Art. Nr. 80 33 0 393 052', 'White, professional all-weather synthetic glove, dark blue stretch inserts in knuckle area, dark blue piping, hand area with two real-leather inserts, hook and loop fastener, ball marker, breathable. White, with dark blue stretch inserts; 100 % synthetics.\r\n', '', 'b_200606121150109664.jpg'),
(126, '73', 'Golf Club Bag', ' Art. Nr. 80 33 0 393 061', 'Golf club bag with practical, lined inside pockets, side pocket for golf balls with BMW Golfsport badge and BMW propeller stud, suitable for 2 to 3 clubs, total length approx.123 cm. Dark blue, with denim blue piping; 100 % polyester. 1 piece.\r\n', ' MOP570', 'b_200606121150109792.jpg'),
(127, '73', 'Golf Club Towel', ' Art. Nr. 80 33 0 394 014', 'Dark blue golf club towel, bottom: discreet Jacquard border in denim blue and white, with metal hook, relief Jacquard "BMW Golfsport" lettering. 38 x 52 cm. 100 % woven cotton velour.\r\n', ' MOP130', 'b_200606121150109884.jpg'),
(128, '73', 'Golf Shoe Bag', 'Art. Nr. 80 33 0 392 650', 'Dark blue shoe bag, denim blue piping, bottom with ventilation eyelets, side and front pocket, mesh side compartment, foam carrier handle, main compartment lined with self-cleaning acrylic fibre fur fabric, address field in front pocket, BMW Golfsport rubber badge, BMW logo stud. 60 % polyester, 40 % acrylics.1 piece.\r\n\r\n', ' MOP280', 'b_200606131150185129.jpg'),
(129, '73', 'Golf Tees', ' Art. Nr. 80 33 0 393 064', 'Print: "BMW Golfsport" in grey on shaft. White; 100 % birch wood. Quantity: 5.\r\n\r\n', '', 'b_200606131150185177.jpg'),
(130, '73', 'Golf Umbrella', ' Art. Nr. 80 33 0 394 012', 'Dark blue golf umbrella with contrasting s-shaped stripes in dark and denim blue, hook and loop closure with address field, fibreglass ribs, hard foam handle, "BMW Golfsport" and BMW propeller logos printed on cover, BMW propeller depicted on handle. 100 % polyester.\r\n\r\n', ' MOP810', 'b_200606131150185228.jpg'),
(131, '73', 'High-End Golf Ball', ' Art. Nr. 80 33 0 393 065', 'High-end white "PTS So/Lo" ball. Print: "BMW Golfsport" in grey and BMW propeller logo in colour. 3 balls.\r\n\r\n', '', 'b_200606131150186045.jpg'),
(132, '73', 'Standard Golf Ball', ' Art. Nr. 80 33 0 393 066', 'Standard white, Pinnacle "Gold Distance" ball. Print: "BMW Golfsport" in grey and BMW propeller logo in colour. 3 balls.\r\n\r\n', ' MOP25', 'b_200606131150186082.jpg'),
(133, '73', 'Pitchfork', ' Art. Nr. 80 33 0 393 063', 'High-gloss nickel-plated pitchfork, magnetic stainless steel ball marker with new BMW Golfsport design, laser-engraved BMW propeller on back. Stainless steel look; 100 % zinc die-cast. Quantity: 1.\r\n\r\n', ' MOP120', 'b_200606131150186172.jpg'),
(134, '73', 'Rain Cover', ' Art. Nr. 80 33 0 394 015', 'Dark blue rain cover, protects trolley bags, ultra-light, foldable, waterproof, with quick-fastener. Print: "BMW Golfsport" in white and BMW propeller in colour. 100 % nylon. 1 piece.\r\n', '', 'b_200606131150186285.jpg'),
(135, '73', 'Shower Cloth', ' Art. Nr. 80 33 0 303 319', 'Dark blue shower cloth, discreet Jacquard border top and bottom, relief Jacquard "BMW Golfsport" lettering, dimensions 80 x 150 cm. Dark blue; 100 % woven cotton velour. 1 piece.\r\n\r\n', '', 'b_200606131150186352.jpg'),
(136, '8', 'Big Kids Package', ' Art. Nr. 80 93 0 413 040', '1. Pylone: Three traffic cones. Height: 26 cm. \r\n\r\n2. Traffic Light: Fully functional traffic light made of durable plastic. Height: 72 cm. \r\n\r\n3. Traffic signs 1: Three Road signs. Height: 68 cm. \r\n\r\n4. BMW 6 Series Convertible Pedal: Manufacturer: Groupe Berchet - Toys Toys, dimension approx. 1400 x 550 x 530 mm, weight approx. 10 kg, crank operation with chain, designed for a permissible driver weight of up to 50 kg. \r\n\r\n\r\n', '', 'b_200606131150186525.jpg'),
(137, '8', 'Ladies Package', ' Art. Nr. 80 21 0 413 042', '1. Ladies'' handbag Fashion: Material: premium German calf leather, tanned and dyed in Italy. Measurements: (L x W x H) 38 x 11,4 x 39 cm. Farbe: Burnt Sienna. \r\n\r\n2. Business case: Business case. Material: water-resistant nylon combined with abrasion-resistant PVC. Measurements: (L x W x H) 60 x 37 x 26 cm. Colour: Burnt Sienna. \r\n\r\n', '', 'b_200606131150186618.jpg'),
(138, '8', 'Mens Package', ' Art. Nr. 80 22 0 413 043', '1. Briefcase: Briefcase. Material: premium German calf leather, tanned and dyed in Italy. Measurements: (L x W x H) 42 x 11,5 x 31 cm. Colour: Black. \r\n\r\n2. Onboard case: Onboard case. Material: water-resistant nylon combined with abrasion-resistant PVC. Measurements: (L x W x H) 54 x 36 x 20 cm. Colour: Black. \r\n\r\n', '', 'b_201008101281433163.jpg'),
(139, '8', 'Sailing Package', ' Art. Nr. 80 30 0 413 041', '1. Beanie Yachting: Dark blue beanie with light grey inner fleece. BMW logo and ORACLE logo embroidered on front, Henri Lloyd logo embroidered on back. 100% acrylic with 100% polyester polartec 200 inside. \r\n\r\n2. Coffee mug Yachting: Coffee mug in a white, blue, silvergrey striped design with BMW ORACLE Racing logo on front. White enamelled inside and out, capacity: 0,3l. 100% porcellain. \r\n\r\n3. Shopping Bag Yachting: Shopping Bag in a white, blue, silvergrey striped design. Magnetic close, 2 carrying handles, 1 inside zip pocket. Measures: 45 x 40 x 15 cm. BMW ORACLE Racing logo printed on front and on back. 100% nylon. \r\n\r\n\r\n', '', 'b_200606131150186745.jpg'),
(140, '44', 'BMW Cabrio-Cap', ' Art. Nr. 80 21 0 145 726', 'Retro gear for classic car drivers. This cabrio cap of dark brown, antique-look nappa leather recalls the pilot caps of the 1920s and offers protection from the elements with style. Four press studs and a metal buckle ensure a close fit. Lining: light brown-based, fine-patterned satin material of 100% cotton.\r\n\r\n', '', 'b_200606131150186923.jpg'),
(141, '44', 'Key Ring BMW 328', ' Art. Nr. 80 23 9 422 495', 'This silver-chromed accessoire is the ideal companion on your journeys. It is practical, stylish and indispensable.\r\n', '', 'b_200606131150186997.jpg'),
(142, '61', 'Key Ring BMW 502', ' Art. Nr. 80 23 0 016 471', 'The most striking styling feature of the BMW 502 "Baroque Angel" apart from its curvaceous contours was its lavish use of chrome. This silver-chromed key ring combines both characteristics in a very elegant way.\r\n', ' MOP270', 'b_200606131150187063.jpg'),
(143, '61', 'Pin BMW 1502-2002', ' Art. Nr. 80 32 9 421 399', 'BMW pins, a must for every fan of BMW''s legendary model ranges, display every key detail. Cast in tin, they are coated in glossy silver paint.\r\n\r\n', '', 'b_200606131150187103.jpg'),
(144, '61', 'Pin BMW 2002', ' Art. Nr. 80 32 9 421 191', 'BMW pins, a must for every fan of BMW''s legendary model ranges, display every key detail. Cast in tin, they are coated in glossy silver paint.\r\n\r\n', '', 'b_200606131150187144.jpg'),
(145, '61', 'Pin BMW 507', ' Art. Nr. 80 32 9 421 031', 'BMW pins, a must for every fan of BMW''s legendary model ranges, display every key detail. Cast in tin, they are coated in glossy silver paint.\r\n\r\n', '', 'b_200606131150187220.jpg'),
(146, '62', 'Classic Writing Pad', ' Art. Nr. 80 24 0 026 295', 'The classic A4 writing pad with 27 sheets of heigh-quality paper featuring different motifs on every sheet.\r\n', '', 'b_200606131150187269.jpg'),
(147, '62', 'Jigsaw Puzzle', ' Art. Nr. 80 56 0 300 252', 'This decorative jigsaw puzzle in a square format of 350 x 350 mm was specially designed for children. It consists 70 pieces which are easily fitted together. The box is made of robust cardboard with linen structure.\r\n', '', 'b_200606131150187310.jpg'),
(148, '62', 'Postcard Set', ' Art. Nr. 80 24 0 026 296', 'This attractive postcard set contains ten motrocycle and motorsport motifs from the BMW archives going back to the era of the 1929 to 1966.\r\n\r\n', '', 'b_200606131150187347.jpg');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `login`
--

CREATE TABLE IF NOT EXISTS `login` (
  `l_id` bigint(20) NOT NULL auto_increment,
  `l_username` varchar(42) NOT NULL default '',
  `l_password` varchar(42) NOT NULL default '',
  PRIMARY KEY  (`l_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Gegevens worden uitgevoerd voor tabel `login`
--

INSERT INTO `login` (`l_id`, `l_username`, `l_password`) VALUES
(1, 'admin', 'powned');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `parts`
--

CREATE TABLE IF NOT EXISTS `parts` (
  `p_id` bigint(20) NOT NULL auto_increment,
  `p_cat` varchar(255) NOT NULL default '',
  `p_name` varchar(255) NOT NULL default '',
  `p_price` varchar(255) NOT NULL default '',
  `p_charge` varchar(255) NOT NULL default '',
  `p_s_des` text NOT NULL,
  `p_l_des` text NOT NULL,
  `p_photo` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`p_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;

--
-- Gegevens worden uitgevoerd voor tabel `parts`
--

INSERT INTO `parts` (`p_id`, `p_cat`, `p_name`, `p_price`, `p_charge`, `p_s_des`, `p_l_des`, `p_photo`) VALUES
(26, '1', 'BMW Performance Body kit', 'HK$:28,500', '', '* include 4 items\r\n* Performance accent strips\r\n* Front apron\r\n* Side skirts\r\n* Rear bumper', '* include 4 items\r\n* Performance accent strips\r\n* Front apron\r\n* Side skirts\r\n* Rear bumper', 'b_201008061281085176.jpg'),
(27, '1', 'Carbon Rear spoiler for 5series(F10)', 'HK$6,560', '', '* Sporty, premium look\r\n* High-tech look of the carbon makes the vehicle exterior more distinctive\r\n* Carbon is produced using a unique manufacturing process\r\n* Designed to save weight and optimize performance', '* Sporty, premium look\r\n* High-tech look of the carbon makes the vehicle exterior more distinctive\r\n* Carbon is produced using a unique manufacturing process\r\n* Designed to save weight and optimize performance', 'b_201008061281085342.jpg'),
(28, '1', 'Alloy wheel 20&quot; V spoke 356 for 5 Serie', 'HK$57,650', ' ', '* Single-piece cast alloy wheel with visible wheel studs\r\n- Wheel with EH2 hump to improve the tyre removal properties if the tyre loses pressure.', '* Single-piece cast alloy wheel with visible wheel studs\r\n- Wheel with EH2 hump to improve the tyre removal properties if the tyre loses pressure.', 'b_201010121286866994.jpg'),
(29, '1', 'BMW Performance sport steering wheel', 'HK$16,200', '', '* Built-in race computer and indicator give a genuine track-car feel\r\n* Agood option for personalizing your vehicle\r\n* Alcantara grip areas ensure a firm hold', '* Built-in race computer and indicator give a genuine track-car feel\r\n* Agood option for personalizing your vehicle\r\n* Alcantara grip areas ensure a firm hold\r\n', 'b_201008061281085770.jpg'),
(30, '1', 'BMW DVD system tablet', ' ', '', '* Easy to install\r\n* Secure fitting to the car\r\n* Number of interfaces:USB, memory card slot,AV-IN, headphone jack, interface for wireless infra- red headphones\r\n* The portable equipment can be operated using a standard 12V power pack outside the car too\r\n', '* Easy to install\r\n* Secure fitting to the car\r\n* Number of interfaces:USB, memory card slot,AV-IN, headphone jack, interface for wireless infra- red headphones\r\n* The portable equipment can be operated using a standard 12V power pack outside the car too\r\n', 'b_201008061281085830.jpg'),
(31, '2', 'testing one', 'price', 'charge', 'short descriptions', 'long descriptions', 'b_201009171284689347.jpg'),
(32, '1', 'Testing 02', 'prices 02', 'charge 02', 'short descriptions', 'long descriptions\r\n', 'b_201009171284697002.jpg');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `parts~old`
--

CREATE TABLE IF NOT EXISTS `parts~old` (
  `p_id` bigint(20) NOT NULL auto_increment,
  `p_cat` varchar(42) NOT NULL default '',
  `p_name` varchar(42) NOT NULL default '',
  `p_price` varchar(42) NOT NULL default '',
  `p_charge` varchar(42) NOT NULL default '',
  `p_s_des` text NOT NULL,
  `p_l_des` text NOT NULL,
  `p_photo` varchar(42) NOT NULL default '',
  PRIMARY KEY  (`p_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;

--
-- Gegevens worden uitgevoerd voor tabel `parts~old`
--

INSERT INTO `parts~old` (`p_id`, `p_cat`, `p_name`, `p_price`, `p_charge`, `p_s_des`, `p_l_des`, `p_photo`) VALUES
(27, '1', 'Alloy wheel 19'''' Star spoke 128 for 5 Seri', 'Mop33,000.00', '(Installation charge included)', 'Single-piece cost alloy wheell with viable wheel atuda.\r\n- Wheel with EH2 hup to improve the tyre removal propertis if tyre loses pressure', 'Single-piece cost alloy wheell with viable wheel atuda.\r\n- Wheel with EH2 hup to improve the tyre removal propertis if tyre loses pressure', 'b_201009011283337011.jpg'),
(12, '1', 'Rear spoiler for 5 Series (E60)', 'MOP4,200.00', '(Installation & paint charge included)', 'The spoiler for the boot lid, a powerful element to expand the aerodynamics package.\r\n-High quality, sporty look\r\n-Matches the car''s design\r\n-Elegant, dynamic look', 'The spoiler for the boot lid, a powerful element to expand the aerodynamics package.\r\n-High quality, sporty look\r\n-Matches the car''s design\r\n-Elegant, dynamic look\r\n', 'b_200603301143694319.jpg'),
(11, '1', 'Wind deflector for Z4 (E85)', 'MOP4,500.00', '(Installation charge included)', 'The BMW wind deflects about 70% of the airflow away to the rear and only allows about 30% through the precisely defined hole pattern. \r\nThis residual airflow is decelerated to such an extent by the mesh as to feel pleasant.', 'The BMW wind deflects about 70% of the airflow away to the rear and only allows about 30% through the precisely defined hole pattern. \r\nThis residual airflow is decelerated to such an extent by the mesh as to feel pleasant.', 'b_200603301143694263.jpg'),
(10, '3', 'Junior Seat I – II ISOFIX for all BMW mode', 'MOP4,500.00', '&nbsp;', 'Excellent safety: in extensive crash tests, not only was every part put to the acid test but also met BWM safety standards which go beyond the legal requirements.\r\nVery comfortable: better side support owing to more pronounced side bolsters at head height.\r\nOutstanding design: use of high quality materials and in the manufacture of expensive cover materials.\r\n', 'Excellent safety: in extensive crash tests, not only was every part put to the acid test but also met BWM safety standards which go beyond the legal requirements.\r\nVery comfortable: better side support owing to more pronounced side bolsters at head height.\r\nOutstanding design: use of high quality materials and in the manufacture of expensive cover materials.\r\n', 'b_200603301143694222.jpg'),
(9, '1', 'BMW interface for Apple iPod for 3 Series ', 'MOP2,900.00', '(Installation charge included)', 'The iPod interface allows an Apple iPod to be connected to the car''s audio system. This allows the iPod to be controlled using the radio and the multi-functional steering wheel. The tracks stored on the iPod are played back over the audio system whilst at the same time the iPod is charged by the electrical system.', 'The iPod interface allows an Apple iPod to be connected to the car''s audio system. This allows the iPod to be controlled using the radio and the multi-functional steering wheel. The tracks stored on the iPod are played back over the audio system whilst at the same time the iPod is charged by the electrical system.', 'b_200603301143694174.jpg'),
(8, '2', 'Care products', '', '&nbsp;', 'Original BMW Care Products have been tested by the BMW Laboratory and are specially tailored to high quality BMW materials. They contribute to safety and maintain the value of both new and used cars.', 'Original BMW Care Products have been tested by the BMW Laboratory and are specially tailored to high quality BMW materials. They contribute to safety and maintain the value of both new and used cars.', 'b_200603301143694121.jpg'),
(7, '2', 'Express wax', 'MOP85.00', '&nbsp;', 'It is a fast-acting liquid product for long lasting gleaming paintwork and metal surfaces.', 'It is a fast-acting liquid product for long lasting gleaming paintwork and metal surfaces.', 'b_200603301143693918.jpg'),
(6, '2', 'Leather lotion', 'MOP210.00', '&nbsp;', 'It cares, protects and cleans the leather trim. The high quality oils maintain the natural properties of the leather. The typical leather smell is refreshed. And it is with UV protection.', 'It cares, protects and cleans the leather trim. The high quality oils maintain the natural properties of the leather. The typical leather smell is refreshed. And it is with UV protection.', 'b_200603301143693765.jpg'),
(4, '1', 'Care Product set in a carry-all bag', 'MOP690.00', ' ', 'Content of the bag: BMW wheel rim cleaner gel, BMW express wax, BMW window cleaner with anti-smear agent, BMW intensive windscreen cleaner, BMW car shampoo, and wheel sponge.', 'Content of the bag: BMW wheel rim cleaner gel, BMW express wax, BMW window cleaner with anti-smear agent, BMW intensive windscreen cleaner, BMW car shampoo, and wheel sponge.', 'b_200603301143693019.jpg'),
(5, '2', 'Glass cleaner with de-mister', 'MOP50.00', '', 'It is a phosphate-free cleaner for all glass surfaces in the interior of cars.\r\n- Removes typical dirt such as dust, grease, oil and nicotine traces quickly and without streaking.\r\n- The anti-static effect prevents windows and mirrors fogging up and minimizes poor visibility by light diffraction.\r\n', 'It is a phosphate-free cleaner for all glass surfaces in the interior of cars.\r\n- Removes typical dirt such as dust, grease, oil and nicotine traces quickly and without streaking.\r\n- The anti-static effect prevents windows and mirrors fogging up and minimizes poor visibility by light diffraction.\r\n', 'b_200603301143693691.jpg');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `vehicle`
--

CREATE TABLE IF NOT EXISTS `vehicle` (
  `id` int(11) NOT NULL auto_increment,
  `cid` varchar(255) collate utf8_unicode_ci default NULL,
  `name` varchar(255) collate utf8_unicode_ci default NULL,
  `email` varchar(255) collate utf8_unicode_ci default NULL,
  `phone` varchar(100) collate utf8_unicode_ci default NULL,
  `status` varchar(100) collate utf8_unicode_ci default NULL,
  `status2` int(11) default NULL,
  `insdate` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `cid` (`cid`),
  KEY `cid_2` (`cid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=78 ;

--
-- Gegevens worden uitgevoerd voor tabel `vehicle`
--

INSERT INTO `vehicle` (`id`, `cid`, `name`, `email`, `phone`, `status`, `status2`, `insdate`) VALUES
(22, NULL, 'Isabel Maria do rosario', 'bellrosario@yahoo.comp', '66862675', '1', 1, '2012-03-20 10:15:40'),
(23, NULL, 'So shui lin Agnes', 'SLIN2002@hotmail.com', '66892616', '1', 1, '2012-03-20 14:33:00'),
(6, NULL, 'IP KENG CHONG', 'ipkengchong@yahoo.com', '66508256', '1', 1, '2012-03-19 18:15:44'),
(7, NULL, 'Fong Chio Loi', 'louise.fong@hotmail.com', '66111011', '1', 3, '2012-03-19 18:15:54'),
(8, NULL, 'siu yuk kwong', 'p0ul.siu@gmail.com', '66178095', '1', 3, '2012-03-19 18:20:40'),
(9, NULL, 'Wong choi keng', 'ivywong@macautower.com.mo', '66333507', '1', 1, '2012-03-19 18:24:57'),
(10, NULL, 'hoi meng tat', 'tat_6688@yahoo.com.hk', '66882356', '1', 1, '2012-03-19 18:27:49'),
(11, NULL, 'KWOK TSZ CHUNG', 'onion_711@hotmail.com', '66603323', '1', 1, '2012-03-19 18:29:12'),
(12, NULL, 'IP CHI KAN BILLY', 'billyick@yahoo.com', '66689896', '1', 2, '2012-03-19 18:53:50'),
(13, NULL, 'ao man kuong', 'mankuong@yahoo.com.hk', '63001801', '1', 3, '2012-03-19 18:57:21'),
(14, NULL, 'Heng Kei air-conditioning & Electrical engineering Limited', 'chiokit@hotmail.com', '62618668', '1', 1, '2012-03-19 19:15:34'),
(15, NULL, 'ng kam kao', 'kao66334199@yahoo.com.hk', '66334199', '1', 2, '2012-03-19 19:38:42'),
(16, NULL, 'Chan keng chin', 'Chance 1010@yahoo.com.hk', '66640558', '1', 3, '2012-03-19 19:42:52'),
(17, NULL, 'chan pou wan', 'chunfat1668@yahoo.com.hk', '66157704', '1', 3, '2012-03-19 19:49:53'),
(18, NULL, 'LEONG CHIN FAI', 'leongchinfai@yahoo.com.hk', '66881654', '1', 1, '2012-03-19 19:50:52'),
(19, NULL, 'Chiang Veng Kuan', 'elvis0824@yahoo.com.hk', '66818254', '1', 2, '2012-03-19 21:27:35'),
(20, NULL, 'LEI CHONG MENG', 'stephenleicm@gmail.com', '66876906', '1', 1, '2012-03-19 22:03:14'),
(21, NULL, 'wong kit ieng', 'ar_wind1104@hotmail.com', '62722388', '1', 1, '2012-03-19 22:45:00'),
(24, NULL, 'Kuan Chi Kin', 'kuan7070@yahoo.com.hk', '66889959', '1', 2, '2012-03-20 18:24:20'),
(25, NULL, 'CHOU FOK PENG', 'iatsengchong@hotmail.com', '66621287', '1', 2, '2012-03-20 21:41:06'),
(26, NULL, 'Fung Wai Lim William', 'fwl_william@yahoo.com', '66667428', '1', 2, '2012-03-21 12:26:37'),
(27, NULL, 'Americo Fernando de Carvalho,', 'americo527@yahoo.com.hk', '6668 1150', '1', 4, '2012-03-21 13:49:41'),
(28, NULL, 'Fong Wai Kao', 'vk_bon@yahoo.com.hk', '66616886', '1', 2, '2012-03-21 17:52:59'),
(29, NULL, 'Poon chi Wang, Samuel', 'primer85@gmail.com', '66396896', '1', 2, '2012-03-21 19:30:25'),
(30, NULL, 'Cheong Cheng Chit', 'Leslie@modern-umb.com', '62219899', '1', 3, '2012-03-21 20:31:31'),
(31, NULL, 'KUONG MEI FONG', 'isabelkuong@hotmail.com', '66812355', '1', 2, '2012-03-22 10:14:17'),
(32, NULL, 'pang kin wai', 'elvispang129@gmail.com', '66414890', '1', 2, '2012-03-22 10:54:36'),
(34, NULL, 'CHAN CHIP WA', 'chankinson1114@yahoo.com', '62222328', '1', 3, '2012-03-23 10:40:15'),
(35, NULL, 'Feng yingyun', 'iswinwin@gmail.com', '62644780', '1', 3, '2012-03-23 11:41:22'),
(36, NULL, 'Fong mio leng', 'net584@hotmail.com', '66983654', '1', 3, '2012-03-23 11:49:25'),
(37, NULL, 'Fong ian i', 'joycefong1028@hotmail.com', '66983547', '1', 3, '2012-03-23 11:59:34'),
(38, NULL, 'Chan Wai I', 'dorawind@hotmail.com', '62953030', '1', 4, '2012-03-23 12:03:20'),
(39, NULL, 'Shirley Lee', 'dorawind@yahoo.com.tw', '66638894', '1', 4, '2012-03-23 12:04:11'),
(40, NULL, 'Isabel Tsch', 'shirvv@yahoo.com.hk', '66895990', '1', 4, '2012-03-23 12:06:33'),
(41, NULL, 'LEI SENG CHAO/CHAN LEI LEI', 'scdenislei@gmail.com', '66818837', '1', 4, '2012-03-23 12:48:51'),
(42, NULL, 'CHANG Domingos Savio', 'domingos_chang@yahoo.com', '66818282', '1', 4, '2012-03-23 17:10:09'),
(43, NULL, 'LEONG KIM HONG', 'kimhongleong@yahoo.com', '66148507', '1', 4, '2012-03-23 19:59:44'),
(44, NULL, 'Chen Tao', '34520456@qq.com', '28750923', '1', 4, '2012-03-24 11:35:59'),
(45, NULL, 'Li Wei Bin', 'leo.macao@gmail.com', '66993253', '1', 4, '2012-03-24 11:59:53'),
(46, NULL, 'Saimi Tong', 'saimi325@gmail.com', '66836843', '1', 4, '2012-03-24 12:18:26'),
(47, NULL, 'XIAN YAN TING', 'tingyanxian@gmail.com', '62523563', '1', 5, '2012-03-24 18:05:11'),
(48, NULL, 'Ao Choi Lin', 'claudia_au88@hotmail.com', '66808346', '1', 5, '2012-03-24 21:26:00'),
(49, NULL, 'Pun Meng San', 'shawnpun@me.com', '66581086', '1', 5, '2012-03-25 00:06:21'),
(50, NULL, 'TONG KIN WAI', 'raymondsoup@hotmail.com', '62351614', '1', 5, '2012-03-25 00:08:05'),
(51, NULL, 'lei chi fai', 'motherlee2009@hotmail.com', '66531290', '1', 5, '2012-03-25 00:11:26'),
(52, NULL, 'CHAN IN HA', 'curry199376@gmail.com', '66535557', '1', 5, '2012-03-25 00:11:52'),
(53, NULL, 'LEI HOI IAN', 'kellylee278@hotmail.com', '66797471', '1', 5, '2012-03-25 00:12:16'),
(54, NULL, 'LEI KONG PENG', 'sm12759411@yahoo.com.hk', '28265467', '1', 5, '2012-03-25 00:12:41'),
(55, NULL, 'TONG KIN NGAI', 'knt_leisure@yahoo.com.hk', '66897688', '1', 5, '2012-03-25 00:14:08'),
(56, NULL, 'KUAN CHI KEI', 'levin87@ymail.com', '66505691', '1', 5, '2012-03-25 00:16:11'),
(57, NULL, 'Benson Ho', 'benson.ho@venetian.com.mo', '66666883', '1', 6, '2012-03-26 11:18:07'),
(58, NULL, 'Tam Pou Leng', 'helloboleng@hotmail.com', '66527635', '1', 6, '2012-03-26 11:44:53'),
(59, NULL, 'CHEONG WAI I', 'sb01723@umac.mo', '62341455', '1', 7, '2012-03-26 14:13:00'),
(60, NULL, 'CHAO CHI HANG', 'kobechao@ymail.com', '66638447', '1', 7, '2012-03-26 14:46:35'),
(61, NULL, 'chang fan wa', 'simonchang2011@gmail.com', '66193134', '1', 0, '2012-03-27 14:44:03'),
(62, NULL, 'SO KWOK WAH', 'elisasoso@yahoo.com.hk', '66669178', '1', 0, '2012-03-27 14:45:30'),
(63, NULL, 'LAM SIN MAN', 'o_o_irene@yahoo.com.hk', '66119276', '1', 0, '2012-03-27 14:47:28'),
(64, NULL, 'LEONG SIO MEI', 'rinki41@hotmail.com', '66308052', '1', 8, '2012-03-27 14:50:11'),
(65, NULL, 'IP HOI LAM', 'karen82ip@yahoo.com.hk', '66686424', '1', 8, '2012-03-27 14:56:39'),
(66, NULL, 'CHAN MAN I', 'mani20039@yahoo.com.hk', '66101892', '1', 8, '2012-03-27 16:49:48'),
(67, NULL, 'CHAN CHI SENG', 'ccs572003@yahoo.com.hk', '63061010', '1', 0, '2012-03-27 16:51:43'),
(68, NULL, 'CHAN MAN WA', 'wawa88829@yahoo.com.hk', '62263030', '1', 8, '2012-03-27 16:52:40'),
(69, NULL, 'CHAN KUONG CHON FONG', 'sherrykuong@yahoo.com.hk', '66776735', '1', 8, '2012-03-27 16:53:19'),
(70, NULL, 'Hong hio lam', 'lin2006_422@yahoo.com.hk', '66928710', '1', 8, '2012-03-27 17:18:30'),
(71, NULL, 'Ao weng fun', 'wengfun_ao@hotmail.com', '66363351', '1', 0, '2012-03-27 17:21:31'),
(72, NULL, 'chan si kei', 'trista729@hotmail.com', '63008817', '1', 8, '2012-03-27 18:10:42'),
(73, NULL, 'KUONG MEI FONG', 'henryho88888@yahoo.com.hk', '66682103', '1', 8, '2012-03-27 19:47:06'),
(74, NULL, 'Au Ka Heng', 'aukhhome@hotmail.com', '66523850', '1', 8, '2012-03-27 21:08:42'),
(75, NULL, 'Chan Kwai Chiu', 'mrs.chan@italina.com.cn', '66932769', '1', 8, '2012-03-28 09:45:09'),
(76, NULL, 'May Chan', 'may.chan@bmw.com.mo', '66671110', '1', 10, '2012-03-28 10:01:40'),
(77, NULL, 'Fernando Leong', 'ferongas@hotmail.com', '66170833', '1', 0, '2012-03-28 22:29:41');