CREATE TABLE `Vtd360Sales` ( `ID` INT NOT NULL AUTO_INCREMENT , `Stnumber` TINYTEXT NOT NULL , `Stname` TINYTEXT NOT NULL , `Suite` TINYTEXT NOT NULL , `City` TINYTEXT NOT NULL , `State` TINYTEXT NOT NULL , `Zip` TINYTEXT NOT NULL , `Salesagent` TINYTEXT NOT NULL , `Salesmgr` TINYTEXT NOT NULL , `Regmgr` TINYTEXT NOT NULL , `Unit` TINYTEXT NOT NULL , `Order` TINYTEXT NOT NULL , `Notes` TINYTEXT NOT NULL , `Maplink` TINYTEXT NOT NULL , `Lat` TINYTEXT NOT NULL , `Long` TINYTEXT NOT NULL , `Date` DATE NOT NULL , `Status` TINYTEXT NOT NULL , `Contact` TINYTEXT NOT NULL , `Email` TINYTEXT NOT NULL , `Phone` TINYTEXT NOT NULL , `Fax` TINYTEXT NOT NULL , `Website` TINYTEXT NOT NULL , `Bookinglink` TINYTEXT NOT NULL , `Agency` TINYTEXT NOT NULL , `Folder` TINYTEXT NOT NULL , `Bg` TINYTEXT NOT NULL , `Floor1` TINYTEXT NOT NULL , `Floorplan1` TINYTEXT NOT NULL , `Floor2` TINYTEXT NOT NULL , `Floorplan2` TINYTEXT NOT NULL , `Floor3` TINYTEXT NOT NULL , `Floorplan3` TINYTEXT NOT NULL , `Video` TINYTEXT NOT NULL , `Living` TINYTEXT NOT NULL , `Livingsp` TINYTEXT NOT NULL , `Livingvt` TINYTEXT NOT NULL , `Living2` TINYTEXT NOT NULL , `Living2sp` TINYTEXT NOT NULL , `Living2vt` TINYTEXT NOT NULL , `Dining` TINYTEXT NOT NULL , `Diningsp` TINYTEXT NOT NULL , `Diningvt` TINYTEXT NOT NULL , `Dining2` TINYTEXT NOT NULL , `Dining2sp` TINYTEXT NOT NULL , `Dining2vt` TINYTEXT NOT NULL , `Family` TINYTEXT NOT NULL , `Familysp` TINYTEXT NOT NULL , `Familyvt` TINYTEXT NOT NULL , `Great` TINYTEXT NOT NULL , `Greatsp` TINYTEXT NOT NULL , `Greatvt` TINYTEXT NOT NULL , `Den` TINYTEXT NOT NULL , `Densp` TINYTEXT NOT NULL , `Denvt` TINYTEXT NOT NULL , `Sun` TINYTEXT NOT NULL , `Sunsp` TINYTEXT NOT NULL , `Sunvt` TINYTEXT NOT NULL , `Study` TINYTEXT NOT NULL , `Studysp` TINYTEXT NOT NULL , `Studyvt` TINYTEXT NOT NULL , `Media` TINYTEXT NOT NULL , `Mediasp` TINYTEXT NOT NULL , `Mediavt` TINYTEXT NOT NULL , `Game` TINYTEXT NOT NULL , `Gamesp` TINYTEXT NOT NULL , `Gamevt` TINYTEXT NOT NULL , `Kitchen` TINYTEXT NOT NULL , `Kitchensp` TINYTEXT NOT NULL , `Kitchenvt` TINYTEXT NOT NULL , `Kitchen2` TINYTEXT NOT NULL , `Kitchen2sp` TINYTEXT NOT NULL , `Kitchen2vt` TINYTEXT NOT NULL , `Br1` TINYTEXT NOT NULL , `Br1sp` TINYTEXT NOT NULL , `Br1vt` TINYTEXT NOT NULL , `Br2` TINYTEXT NOT NULL , `Br2sp` TINYTEXT NOT NULL , `Br2vt` TINYTEXT NOT NULL , `Br3` TINYTEXT NOT NULL , `Br3sp` TINYTEXT NOT NULL , `Br3vt` TINYTEXT NOT NULL , `Br4` TINYTEXT NOT NULL , `Br4sp` TINYTEXT NOT NULL , `Br4vt` TINYTEXT NOT NULL , `Br5` TINYTEXT NOT NULL , `Br5sp` TINYTEXT NOT NULL , `Br5vt` TINYTEXT NOT NULL , `Br6` TINYTEXT NOT NULL , `Br6sp` TINYTEXT NOT NULL , `Br6vt` TINYTEXT NOT NULL , `Br7` TINYTEXT NOT NULL , `Br7sp` TINYTEXT NOT NULL , `Br7vt` TINYTEXT NOT NULL , `Br8` TINYTEXT NOT NULL , `Br8sp` TINYTEXT NOT NULL , `Br8vt` TINYTEXT NOT NULL , `Br9` TINYTEXT NOT NULL , `Br9sp` TINYTEXT NOT NULL , `Br9vt` TINYTEXT NOT NULL , `Br10` TINYTEXT NOT NULL , `Br10sp` TINYTEXT NOT NULL , `Br10vt` TINYTEXT NOT NULL , `Br11` TINYTEXT NOT NULL , `Br11sp` TINYTEXT NOT NULL , `Br11vt` TINYTEXT NOT NULL , `Br12` TINYTEXT NOT NULL , `Br12sp` TINYTEXT NOT NULL , `Br12vt` TINYTEXT NOT NULL , `Ba1` TINYTEXT NOT NULL , `Ba1sp` TINYTEXT NOT NULL , `Ba1vt` TINYTEXT NOT NULL , `Ba2` TINYTEXT NOT NULL , `Ba2sp` TINYTEXT NOT NULL , `Ba2vt` TINYTEXT NOT NULL , `Ba3` TINYTEXT NOT NULL , `Ba3sp` TINYTEXT NOT NULL , `Ba3vt` TINYTEXT NOT NULL , `Ba4` TINYTEXT NOT NULL , `Ba4sp` TINYTEXT NOT NULL , `Ba4vt` TINYTEXT NOT NULL , `V1` TINYTEXT NOT NULL , `V1sp` TINYTEXT NOT NULL , `V1vt` TINYTEXT NOT NULL , `V2` TINYTEXT NOT NULL , `V2sp` TINYTEXT NOT NULL , `V2vt` TINYTEXT NOT NULL , `V3` TINYTEXT NOT NULL , `V3sp` TINYTEXT NOT NULL , `V3vt` TINYTEXT NOT NULL , `V4` TINYTEXT NOT NULL , `V4sp` TINYTEXT NOT NULL , `V4vt` TINYTEXT NOT NULL , `V5` TINYTEXT NOT NULL , `V5sp` TINYTEXT NOT NULL , `V5vt` TINYTEXT NOT NULL , `V6` TINYTEXT NOT NULL , `V6sp` TINYTEXT NOT NULL , `V6vt` TINYTEXT NOT NULL , `V7` TINYTEXT NOT NULL , `V7sp` TINYTEXT NOT NULL , `V7vt` TINYTEXT NOT NULL , `V8` TINYTEXT NOT NULL , `V8sp` TINYTEXT NOT NULL , `V8vt` TINYTEXT NOT NULL , `V9` TINYTEXT NOT NULL , `V9sp` TINYTEXT NOT NULL , `V9vt` TINYTEXT NOT NULL , `V10` TINYTEXT NOT NULL , `V10sp` TINYTEXT NOT NULL , `V10vt` TINYTEXT NOT NULL , `V11` TINYTEXT NOT NULL , `V11sp` TINYTEXT NOT NULL , `V11vt` TINYTEXT NOT NULL , `V12` TINYTEXT NOT NULL , `V12sp` TINYTEXT NOT NULL , `V12vt` TINYTEXT NOT NULL , `V13` TINYTEXT NOT NULL , `V13sp` TINYTEXT NOT NULL , `V13vt` TINYTEXT NOT NULL , `V14` TINYTEXT NOT NULL , `V14sp` TINYTEXT NOT NULL , `V14vt` TINYTEXT NOT NULL , `V15` TINYTEXT NOT NULL , `V15sp` TINYTEXT NOT NULL , `V15vt` TINYTEXT NOT NULL , `V16` TINYTEXT NOT NULL , `V16sp` TINYTEXT NOT NULL , `V16vt` TINYTEXT NOT NULL , `Cmt01` TINYTEXT NOT NULL , `Cmt02` TINYTEXT NOT NULL , `Cmt03` TINYTEXT NOT NULL , `Cmt04` TINYTEXT NOT NULL , `Cmt05` TINYTEXT NOT NULL , `Cmt06` TINYTEXT NOT NULL , `Cmt07` TINYTEXT NOT NULL , `Cmt08` TINYTEXT NOT NULL , `Cmt09` TINYTEXT NOT NULL , `Cmt10` TINYTEXT NOT NULL , `Cmt11` TINYTEXT NOT NULL , `Cmt12` TINYTEXT NOT NULL , `Cmt13` TINYTEXT NOT NULL , `Cmt14` TINYTEXT NOT NULL , `Cmt15` TINYTEXT NOT NULL , PRIMARY KEY (`ID`) ); INSERT INTO `Vtd360Sales` (`Stnumber`, `Stname`, `Suite`, `City`, `State`, `Zip`, `Salesagent`, `Salesmgr`, `Regmgr`, `Unit`, `Order`, `Notes`, `Maplink`, `Lat`, `Long`, `Date`, `Status`, `Contact`, `Email`, `Phone`, `Fax`, `Website`, `Bookinglink`, `Agency`, `Folder`, `Bg`, `Floor1`, `Floorplan1`, `Floor2`, `Floorplan2`, `Floor3`, `Floorplan3`, `Video`, `Living`, `Livingsp`, `Livingvt`, `Living2`, `Living2sp`, `Living2vt`, `Dining`, `Diningsp`, `Diningvt`, `Dining2`, `Dining2sp`, `Dining2vt`, `Family`, `Familysp`, `Familyvt`, `Great`, `Greatsp`, `Greatvt`, `Den`, `Densp`, `Denvt`, `Sun`, `Sunsp`, `Sunvt`, `Study`, `Studysp`, `Studyvt`, `Media`, `Mediasp`, `Mediavt`, `Game`, `Gamesp`, `Gamevt`, `Kitchen`, `Kitchensp`, `Kitchenvt`, `Kitchen2`, `Kitchen2sp`, `Kitchen2vt`, `Br1`, `Br1sp`, `Br1vt`, `Br2`, `Br2sp`, `Br2vt`, `Br3`, `Br3sp`, `Br3vt`, `Br4`, `Br4sp`, `Br4vt`, `Br5`, `Br5sp`, `Br5vt`, `Br6`, `Br6sp`, `Br6vt`, `Br7`, `Br7sp`, `Br7vt`, `Br8`, `Br8sp`, `Br8vt`, `Br9`, `Br9sp`, `Br9vt`, `Br10`, `Br10sp`, `Br10vt`, `Br11`, `Br11sp`, `Br11vt`, `Br12`, `Br12sp`, `Br12vt`, `Ba1`, `Ba1sp`, `Ba1vt`, `Ba2`, `Ba2sp`, `Ba2vt`, `Ba3`, `Ba3sp`, `Ba3vt`, `Ba4`, `Ba4sp`, `Ba4vt`, `V1`, `V1sp`, `V1vt`, `V2`, `V2sp`, `V2vt`, `V3`, `V3sp`, `V3vt`, `V4`, `V4sp`, `V4vt`, `V5`, `V5sp`, `V5vt`, `V6`, `V6sp`, `V6vt`, `V7`, `V7sp`, `V7vt`, `V8`, `V8sp`, `V8vt`, `V9`, `V9sp`, `V9vt`, `V10`, `V10sp`, `V10vt`, `V11`, `V11sp`, `V11vt`, `V12`, `V12sp`, `V12vt`, `V13`, `V13sp`, `V13vt`, `V14`, `V14sp`, `V14vt`, `V15`, `V15sp`, `V15vt`, `V16`, `V16sp`, `V16vt`, `Cmt01`, `Cmt02`, `Cmt03`, `Cmt04`, `Cmt05`, `Cmt06`, `Cmt07`, `Cmt08`, `Cmt09`, `Cmt10`, `Cmt11`, `Cmt12`, `Cmt13`, `Cmt14`, `Cmt15`) VALUES ('581', 'McCrystal Cir', '', 'Moncks Corner', 'SC', '29461', '', '', '', 'McCrystalCir_581', '', '', 'http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=581+MCCRYSTAL+CIR++%09MONCKS+CORNER,+SC+29461&sll=37.0625,-95.677068&sspn=48.822589,65.566406&ie=UTF8&ll=33.093975,-80.099033&spn=0.001589,0.002001&t=h&z=19&iwloc=A', '33.094', '-80.099', '2147-11-05 00:00:00', 'A', 'Curtis Renfro', 'renfroreal@aol.com', '843.572.0004', '', '', '', 'Agentowned Premiere Group', 'vtd360Sales', '99CCFF', '', '', '', '', '', '', '', 'Living', '2794_0905', '', 'Living', '2795_0905', '2812_0905', 'Living', '2805_0905', '', 'Dining', '2793_0905', '2813_0905', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Laundry', '2798_0905', '', 'Kitchen', '2791_0905', '2814_0905', 'Kitchen', '2792_0905', '', 'Bedroom 1', '2799_0905', '2809_0905', 'Bedroom 1', '2800_0905', '', 'BR 1 Loft', '2802_0905', '2811_0905', 'Bedroom 2', '2796_0905', '2808_0905', 'Bedroom 3', '2797_0905', '2807_0905', 'Bedroom 4', '2804_0905', '2806_0905', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Bath 1', '2801_0905', '2810_0905', '', '', '', '', '', '', '', '', '', 'Front', '2777_0905', '2822_0905', 'Front', '2774_0905', '', 'Right side', '2776_0905', '', 'Back', '2781_0905', '', 'Back', '2782_0905', '', 'Yard', '2785_0905', '2823_0905', 'Yard', '2784_0905', '2824_0905', 'Front Porch', '2790_0905', '2819_0905', 'Back Porch', '2787_0905', '2816_0905', 'Back Porch', '2788_0905', '', 'Porch View', '2789_0905', '', 'Garage', '2780_0905', '', 'Gazebo', '', '2821_0905', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `Vtd360Sales` (`Stnumber`, `Stname`, `Suite`, `City`, `State`, `Zip`, `Salesagent`, `Salesmgr`, `Regmgr`, `Unit`, `Order`, `Notes`, `Maplink`, `Lat`, `Long`, `Date`, `Status`, `Contact`, `Email`, `Phone`, `Fax`, `Website`, `Bookinglink`, `Agency`, `Folder`, `Bg`, `Floor1`, `Floorplan1`, `Floor2`, `Floorplan2`, `Floor3`, `Floorplan3`, `Video`, `Living`, `Livingsp`, `Livingvt`, `Living2`, `Living2sp`, `Living2vt`, `Dining`, `Diningsp`, `Diningvt`, `Dining2`, `Dining2sp`, `Dining2vt`, `Family`, `Familysp`, `Familyvt`, `Great`, `Greatsp`, `Greatvt`, `Den`, `Densp`, `Denvt`, `Sun`, `Sunsp`, `Sunvt`, `Study`, `Studysp`, `Studyvt`, `Media`, `Mediasp`, `Mediavt`, `Game`, `Gamesp`, `Gamevt`, `Kitchen`, `Kitchensp`, `Kitchenvt`, `Kitchen2`, `Kitchen2sp`, `Kitchen2vt`, `Br1`, `Br1sp`, `Br1vt`, `Br2`, `Br2sp`, `Br2vt`, `Br3`, `Br3sp`, `Br3vt`, `Br4`, `Br4sp`, `Br4vt`, `Br5`, `Br5sp`, `Br5vt`, `Br6`, `Br6sp`, `Br6vt`, `Br7`, `Br7sp`, `Br7vt`, `Br8`, `Br8sp`, `Br8vt`, `Br9`, `Br9sp`, `Br9vt`, `Br10`, `Br10sp`, `Br10vt`, `Br11`, `Br11sp`, `Br11vt`, `Br12`, `Br12sp`, `Br12vt`, `Ba1`, `Ba1sp`, `Ba1vt`, `Ba2`, `Ba2sp`, `Ba2vt`, `Ba3`, `Ba3sp`, `Ba3vt`, `Ba4`, `Ba4sp`, `Ba4vt`, `V1`, `V1sp`, `V1vt`, `V2`, `V2sp`, `V2vt`, `V3`, `V3sp`, `V3vt`, `V4`, `V4sp`, `V4vt`, `V5`, `V5sp`, `V5vt`, `V6`, `V6sp`, `V6vt`, `V7`, `V7sp`, `V7vt`, `V8`, `V8sp`, `V8vt`, `V9`, `V9sp`, `V9vt`, `V10`, `V10sp`, `V10vt`, `V11`, `V11sp`, `V11vt`, `V12`, `V12sp`, `V12vt`, `V13`, `V13sp`, `V13vt`, `V14`, `V14sp`, `V14vt`, `V15`, `V15sp`, `V15vt`, `V16`, `V16sp`, `V16vt`, `Cmt01`, `Cmt02`, `Cmt03`, `Cmt04`, `Cmt05`, `Cmt06`, `Cmt07`, `Cmt08`, `Cmt09`, `Cmt10`, `Cmt11`, `Cmt12`, `Cmt13`, `Cmt14`, `Cmt15`) VALUES ('110', 'Sycamore Drive', '', 'Summerville', 'SC', '29485', '', '', '', 'SycamoreDr_110', '', '', '', '33.0029', '-80.1802', '2148-01-20 00:00:00', 'A', 'Loren Bethea', 'lbethea@kwchsnorth.com', '843.696.1156', '', 'http://lorenbethea.yourkwagent.com/', '', 'Keller Williams Realty-North', 'vtd360Sales', '99CCFF', '', '', '', '', '', '', '', 'Living', '2924a_090601', '2908_090601', '', '', '', 'Dining', '2922_090601', '2907a_090601', 'Eat-in', '2918_090601', '2913_090601', '', '', '', '', '', '', 'Den', '2916_090601', '2912_090601', 'Den', '2917_090601', '', '', '', '', '', '', '', 'Sun/Game', '2915_090601', '2914_090601', 'Kitchen', '2920_090601', '2904_090601', 'Kitchen', '2921_090601', '', 'Bedroom 1', '2927_090601', '2909_090601', 'Bedroom 2', '2926_090601', '2911_090601', 'Bedroom 3', '2930_090601', '2910_090601', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Bath 1', '2928_090601', '', 'Bath 2', '2925_090601', '', '', '', '', '', '', '', 'Front', '2932_090601', '2903a_090601', 'Front', '2886_090601', '', 'Front', '2888_090601', '', 'Front Porch', '2931_090601', '', 'Back', '2896a_090601', '', 'Back', '2893a_090601', '', 'Back Porch', '2897_090601', '2899_090601', 'Back Porch', '2898_090601', '', 'Back Yard', '2891a_090601', '2901_090601', 'Back Yard', '2889_090601', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');