--
-- Host: localhost    Database: h47dk5js8
-- ------------------------------------------------------


--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `clientid` int(11) NOT NULL auto_increment,
  `clientname` varchar(50) NOT NULL,
  `contact` varchar(50) NOT NULL,
  `address` varchar(50) NOT NULL,
  `town` varchar(50) NOT NULL,
  `province` varchar(2) NOT NULL,
  `zipcode` varchar(8) NOT NULL,
  `office` varchar(15) NOT NULL,
  `fax` varchar(15) NOT NULL,
  `home` varchar(15) NOT NULL,
  `cell` varchar(15) NOT NULL,
  `email` varchar(50) NOT NULL,
  PRIMARY KEY  (`clientid`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` VALUES (7,'Fitting Solutions','Nadien Wiebe','3301 Coldstream Av','Vernon','BC','VIT 1Y1','250 260 1104','250 545 1484','250 260 3996','250 307 4719','nadien-fittingsolutions@shaw.ca'),(10,'Callahan Property Group','Bob Callahan','218-1626 Richter Street','Kelowna','BC','V1Y 2M3','250-717-3000','','','','bob@callahanpg.ca'),(5,'Triboda Printing Company LTD','Stephen Trites','Unit #2 - 2706 45th Avenue','Vernon','BC','V1T 3N4','250 549 2900','250 549 2928','','250 938 4680','stephen@triboda.com'),(6,'Little Ceasers Kelowna','Alison Hart','1155 KLO Road','Kelowna','BC','V1X 6A8','','','','','alisonhart@shaw.ca'),(8,'Burger King','Valley King Foods Inc','Louie Drive','Westbank','BC','','','','','','valleyking@shaw.ca'),(9,'Anchor Plumbing','Robin Stott','Maes yr Haf','Trefin, Pembrokeshire','','SA62 5AX','','','1348 837 130','','stottyno1@hotmail.com'),(1,'Jade Design','Jade Stott','4347 deroo roaddd','kelowna','bc','v1t30w','250 938 4549','250 938 4548','250 938 4547','250 938 4546','jade@itwiz.ca'),(11,'John Howard Society','Franco Marolla','2307 43rd St','Vernon','BC','V1T 6K7','250 542 4041','','','',''),(14,'Thomas Fletcher','','9007 Cherry Lane','Coldstream','BC','','','','250 542 2670','','tbfletcher@shaw.ca'),(15,'Priest Valley Physiotherapy','Jaime McGregor','2815 35 Street','Vernon','BC','V1T 6B6','250-260-3463','','','','pvmtc@shaw.ca'),(16,'Great West Wash Systems','','2640 Bewlay Road','Kelowna','BC','','','','250 868 3484','','carlim@telus.net'),(17,'John & Marion Schell','Marion','3250 East Kelowna Road','Kelowna','BC','V1W 4H3','','','250 860 2628','','jmschell@shaw.ca'),(18,'T.L. Callahan','Lloyd','4850 Frost Rd','Kelowna','BC','V1W 4M3','250 717 3000','250 717 3400','250 764 8349','250 212 5400','lloyd@callahanpg.ca'),(19,'Affordable Web Design','','Box 28197 East Kelowna Post Office','Kelowna','BC','V1W 4A6','250 762 5987','','','','doris@affordablewebdesign.ca'),(20,'All American Forest Products','Lisa','6822 Camio Drive North','Vernon','BC','V1H 1N9','250 545 8858','','','','lisa@aaforest.com'),(21,'Focus Training Institute Ltd.','Tammy Henry','206 - 1470 St.Paul Street','Kelowna','BC','V1Y 2E6','250 861 5808','250 861 5846','','','tammy@focustraininginstitute.com'),(22,'Anita Suess','Anita Suess','','Vernon','','','250.549.3466','','','','anitasuess@shaw.ca'),(23,'Nata Farm','Bev Henderson','5385 Back Enderby Road','Armstrong','BC','V0E 1B8','250 838 9885','','','250 503 7438','jbifano@gmail.com'),(24,'Bev Henderson','Bev Henderson','1308 Phoenix Drive','Vernon','BC','','250 275 3065','','','250 307 3559','bev_vernon@hotmail.com'),(25,'Vernon Museum & Archives','Ron Candy','3009 - 32nd Avenue','Vernon','BC','V1T 2LB','250-542-3142','250-542-5358','','','rcandy@vernonmuseum.ca'),(26,'Creekside Animal Clinic','Murray','5001 24 Street','Vernon','BC','V1T 8X7','250 549-3533','','','',''),(27,'Jaime McGregor','','2815 35 Street','Vernon','BC','V1T 6B6','','','','250 718 8432','okanaganhandtherapy@gmail.com'),(28,'Rocky Mountain Snow Cats','Eddy','Unit #1 - 669 Longridge Dr','Kelowna','BC','V1V 2R9','','','','',''),(29,'The Corporation of the City of Vernon','Michelle Jefferson','3400 30th Street','Vernon','BC','V1T 5E6','250 545 5493','','','250 540 0497','MJefferson@vernon.ca'),(30,'Tudor Equestrian','','9780 - 51 Avenue','Edmonton','AB','T6E 0A6','780 469 9529','','','','tudortack@telus.net'),(31,'Okeefe Ranch','','Box 955, 9380 Hwy 97N','Vernon','BC','V1T 6M8','250 542 7868','','','','info@okeeferanch.ca'),(32,'Marion & Peter Blundell','Marion','7655 Century Delta Road','Fintry, Kelowna','BC','V1Z 3V2','250 542 4540','','','','petersbee@hotmail.com'),(33,'Thelma Christian','','106 - 3405 39th Av','Vernon','BC','V1T 3E3','','','','',''),(34,'Lianne Lacroix','','1605 Gordon Drive','Kelowna','BC','V1Y 3G8','250 861 3120','','','',''),(35,'Stuart Gray','Stuart Gray','980 Skeena Drive','Kelowna','BC','V1V 2B2','250 860 5101','','','','stuart.gray@shaw.ca'),(36,'Fenders Autobody','Norm Cross','#5 - 1340 Stevens Rd','Kelowna','BC','V1Z 1G2','250 769 1099','250 769 6697','','250 212 8881','norm.cross@fenders.ca'),(37,'Pat Simmons','','#29 ~ 3906 Pleasant Valley Road','Vernon','BC','V1T 4L9','','','','',''),(38,'Vernon Winter Carnival','Brittany','3401 35th Av','Vernon','BC','V1T 2T5','250 545 2236','250 545 0006','','','info@vernonwintercarnival.com'),(39,'AKA Room Service','Sandi & Lettie','3105 28 Avenue Vernon','Vernon','BC','V1T 8Y4','250 545 4571','','','','lettie@akaroomservices.com'),(40,'Maureen McEwan','','185 Whitevale Rd','Lumby','BC','V0E 2G7','','','250 547 8910','','mmcewan@telus.net'),(41,'Wendy Klein','Wendy Klein','101-5484-25 Ave','Vernon','BC','V1B 3N2','','','','','lwklein@shaw.ca');

--
-- Table structure for table `danygraigcal`
--

CREATE TABLE `danygraigcal` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `start` date NOT NULL,
  `end` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `danygraigcal`
--

INSERT INTO `danygraigcal` VALUES (1,'test','2009-09-05','2009-09-11'),(2,'test2','2009-10-24','2009-10-30'),(5,'again','2009-11-14','2009-11-20'),(6,'dec','2009-12-12','2009-12-18'),(7,'Rob Miles','2010-01-02','2010-01-08');

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `event_id` int(6) NOT NULL auto_increment,
  `event_name` varchar(100) NOT NULL,
  `event_date` date NOT NULL,
  PRIMARY KEY  (`event_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `events`
--

INSERT INTO `events` VALUES (1,'Funtastic','2010-05-12'),(2,'Farmers Market','2010-05-12');

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `expid` int(4) NOT NULL auto_increment,
  `expdate` date NOT NULL,
  `expstore` varchar(50) NOT NULL,
  `expdesc` varchar(50) NOT NULL,
  `expacct` varchar(20) NOT NULL,
  `exptotal` decimal(10,2) NOT NULL,
  `expgst` decimal(10,2) NOT NULL,
  `exphst` decimal(10,2) NOT NULL,
  PRIMARY KEY  (`expid`)
) ENGINE=MyISAM AUTO_INCREMENT=98 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `expenses`
--

INSERT INTO `expenses` VALUES (28,'2010-05-31','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(2,'2009-08-03','Futureshop','Router','equip','50.00','2.50','0.00'),(4,'2009-08-01','Staples','Office 2007','equip','99.00','4.71','0.00'),(7,'2010-09-08','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(6,'2010-03-16','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(8,'2010-09-07','Husky','Gas','auto','50.02','2.38','0.00'),(9,'2010-06-12','Presidents Choice','Gas','auto','20.00','0.95','0.00'),(10,'2010-06-24','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(11,'2010-07-05','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(12,'2010-06-30','Presidents Choice','Gas','auto','20.00','0.95','0.00'),(13,'2010-07-01','Presidents Choice','Gas','auto','30.00','1.43','0.00'),(14,'2010-06-29','Presidents Choice','Gas','auto','20.00','0.95','0.00'),(15,'2010-07-03','Presidents Choice','Gas','auto','20.00','0.95','0.00'),(16,'2010-07-01','Shell Canada','Gas','auto','20.00','0.95','0.00'),(17,'2010-06-14','Presidents Choice','Gas','auto','30.00','1.43','0.00'),(18,'2010-06-17','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(19,'2010-06-22','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(20,'2010-06-10','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(21,'2010-06-08','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(22,'2010-05-27','Presidents Choice','Gas','auto','20.00','0.95','0.00'),(23,'2010-06-03','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(24,'2010-05-29','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(25,'2010-04-03','Presidents Choice','Gas','auto','30.00','1.43','0.00'),(26,'2010-04-03','Futureshop','Surge Protector','equip','25.75','1.15','0.00'),(27,'2010-04-09','Canadian Tire','Power Steering Fluid','auto','6.18','0.28','0.00'),(29,'2010-06-11','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(30,'2010-05-13','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(31,'2010-05-19','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(32,'2010-05-01','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(33,'2010-04-19','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(34,'2010-04-06','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(35,'2010-04-22','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(36,'2010-04-21','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(37,'2010-04-25','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(38,'2010-05-04','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(39,'2010-04-23','Presidents Choice','Gas','auto','30.00','1.43','0.00'),(40,'2010-04-09','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(41,'2010-04-14','Home Depot','30m Cat5e Cable','pos','27.98','1.25','0.00'),(42,'2010-04-24','Presidents Choice','Gas','auto','20.00','0.95','0.00'),(43,'2010-05-11','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(44,'2010-05-16','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(45,'2010-04-26','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(46,'2010-04-27','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(47,'2010-04-05','Canadian Tire','Oil','auto','5.19','0.23','0.00'),(48,'2010-04-07','Home Depot','10m Cat3 Cable','equip','3.03','0.14','0.00'),(49,'2010-08-04','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(50,'2010-05-19','Staples','Dust Air Canaster','equip','12.23','0.55','0.00'),(51,'2010-04-28','Kal Lake Auto','Car Maintainance','auto','488.84','21.82','0.00'),(52,'2010-04-13','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(53,'2010-04-15','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(54,'2010-03-30','Presidents Choice','Gas','auto','30.00','1.43','0.00'),(55,'2010-04-29','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(56,'2010-05-07','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(57,'2010-08-10','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(58,'2010-08-05','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(59,'2010-03-25','Presidents Choice','Gas','auto','40.11','1.91','0.00'),(60,'2010-08-07','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(61,'2010-07-28','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(62,'2010-07-31','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(63,'2010-07-10','Presidents Choice','Gas','pos','40.00','1.90','0.00'),(64,'2010-07-21','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(65,'2010-03-19','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(66,'2010-03-23','Presidents Choice','Gas','auto','40.11','1.91','0.00'),(67,'2010-04-01','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(68,'2010-03-28','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(69,'2010-05-25','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(70,'2010-07-08','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(71,'2010-07-14','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(72,'2010-07-18','Presidents Choice','Gas','auto','50.00','2.38','0.00'),(73,'2010-07-25','Presidents Choice','Gas','auto','60.00','2.86','0.00'),(74,'2010-07-15','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(75,'2010-11-19','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(76,'2010-11-09','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(77,'2010-11-24','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(78,'2010-11-18','Presidents Choice','Gas','auto','20.00','0.95','0.00'),(79,'2010-12-11','Presidents Choice','Gas','auto','30.00','1.43','0.00'),(80,'2010-12-08','Presidents Choice','Gas','auto','20.00','0.95','0.00'),(81,'2010-12-02','Presidents Choice','Gas','auto','20.00','0.95','0.00'),(82,'2010-11-26','BCAA','BCAA Breakdown Cover','auto','148.84','15.84','0.00'),(83,'2010-12-15','Presidents Choice','Gas','auto','50.00','2.38','0.00'),(84,'2010-12-13','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(85,'2010-11-22','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(86,'2010-11-29','Presidents Choice','Gas','auto','20.00','0.95','0.00'),(87,'2010-12-06','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(88,'2010-11-26','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(89,'2010-12-17','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(90,'2010-11-17','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(91,'2010-12-13','The City of Vernon','Parking Fine','auto','5.00','0.57','0.00'),(92,'2010-12-03','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(93,'2010-11-15','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(94,'2010-12-10','Staples','Network Card','pos','33.55','3.60','0.00'),(95,'2010-12-08','Futureshop','Graphics Card','pos','83.99','9.00','0.00'),(96,'2010-12-10','Presidents Choice','Gas','auto','40.00','1.90','0.00'),(97,'2010-11-09','Service BC','Renew Drivers Licence','auto','75.00','8.57','0.00');

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `invoiceid` int(11) NOT NULL auto_increment,
  `invoiceno` int(11) NOT NULL,
  `logid` int(11) NOT NULL,
  `invoicedate` date NOT NULL,
  `datepaid` date NOT NULL,
  `totalhours` float(10,2) NOT NULL default '0.00',
  `totalstock` float(10,2) NOT NULL default '0.00',
  `gst` float(10,2) NOT NULL default '0.00',
  `pst` float(10,2) NOT NULL default '0.00',
  `hst` float(10,2) NOT NULL default '0.00',
  `total` float(10,2) NOT NULL default '0.00',
  PRIMARY KEY  (`invoiceid`)
) ENGINE=MyISAM AUTO_INCREMENT=216 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `invoices`
--

INSERT INTO `invoices` VALUES (39,9111,26,'2009-05-06','2009-05-26',60.00,0.00,3.00,0.00,0.00,63.00),(41,9113,28,'2009-05-29','2009-06-02',60.00,0.00,3.00,0.00,0.00,63.00),(37,9109,25,'2009-04-20','2009-04-27',120.00,0.00,6.00,0.00,0.00,126.00),(33,9106,6,'2009-01-25','2009-03-12',200.00,0.00,10.00,0.00,0.00,210.00),(32,9102,10,'2009-03-04','2009-03-09',350.00,0.00,17.50,0.00,0.00,367.50),(22,9107,22,'2009-03-16','2009-04-01',240.00,0.00,12.00,0.00,0.00,252.00),(23,9108,21,'2009-03-27','2009-03-13',60.00,0.00,3.00,0.00,0.00,63.00),(21,9104,15,'2000-03-10','2000-03-11',1200.00,0.00,60.00,0.00,0.00,1260.00),(36,9100,16,'2009-04-01','2009-05-01',120.00,0.00,6.00,0.00,0.00,126.00),(29,9101,5,'2009-02-19','2009-03-04',120.00,23.20,7.16,1.62,0.00,151.98),(31,9103,14,'2009-03-04','2009-03-12',480.00,0.00,24.00,0.00,0.00,504.00),(40,9112,27,'2009-05-22','2009-06-16',180.00,0.00,9.00,0.00,0.00,189.00),(42,9114,29,'2009-06-08','2009-07-03',60.00,0.00,3.00,0.00,0.00,63.00),(47,9115,30,'2009-07-06','2009-08-13',120.00,0.00,6.00,0.00,0.00,126.00),(55,9122,38,'2009-08-25','2009-08-25',60.00,0.00,3.00,0.00,0.00,63.00),(58,9123,39,'2009-09-09','2009-10-02',300.00,300.93,30.05,21.07,0.00,652.04),(50,9118,33,'2009-07-23','2009-07-23',120.00,73.21,9.66,5.12,0.00,208.00),(51,9119,34,'2009-07-30','2009-08-27',60.00,0.00,3.00,0.00,0.00,63.00),(59,9124,40,'2009-09-22','2009-10-02',120.00,0.00,6.00,0.00,0.00,126.00),(53,9121,37,'2009-08-13','2009-09-16',120.00,0.00,6.00,0.00,0.00,126.00),(60,9125,41,'2009-09-25','2009-09-25',120.00,0.00,6.00,0.00,0.00,126.00),(62,9126,44,'2009-10-29','2009-12-14',150.00,0.00,7.50,0.00,0.00,157.50),(63,9127,45,'2009-10-29','2009-11-10',120.00,0.00,6.00,0.00,0.00,126.00),(64,9128,46,'2009-11-02','2009-10-30',60.00,1370.46,71.52,95.93,0.00,1597.92),(65,9129,47,'2009-11-02','2009-11-18',60.00,0.00,3.00,0.00,0.00,63.00),(66,9130,48,'2009-11-04','2009-11-18',60.00,0.00,3.00,0.00,0.00,63.00),(67,9131,49,'2009-11-13','2009-11-18',120.00,0.00,6.00,0.00,0.00,126.00),(68,9132,50,'2009-11-23','2009-12-22',120.00,0.00,6.00,0.00,0.00,126.00),(69,9133,51,'2009-12-17','2010-03-12',60.00,0.00,3.00,0.00,0.00,63.00),(70,9134,52,'2009-12-21','2009-12-21',480.00,30.00,25.50,2.10,0.00,537.60),(71,9135,53,'2009-12-29','2009-12-29',60.00,0.00,3.00,0.00,0.00,63.00),(73,9136,54,'2010-01-22','2010-02-03',120.00,0.00,6.00,0.00,0.00,126.00),(74,9137,55,'2010-01-22','2010-02-15',120.00,0.00,6.00,0.00,0.00,126.00),(75,9138,56,'2010-02-08','2010-03-02',120.00,134.95,12.75,9.45,0.00,277.14),(76,9139,58,'2010-02-13','2010-02-28',60.00,78.00,6.90,5.46,0.00,150.36),(79,9140,57,'2010-02-26','2010-03-16',480.00,87.00,28.35,6.09,0.00,601.44),(80,9141,59,'2010-03-01','2010-03-01',360.00,85.00,22.25,5.95,0.00,473.20),(85,9145,60,'2010-03-24','2010-04-29',780.00,0.00,39.00,0.00,0.00,819.00),(82,9143,61,'2010-03-24','2010-03-31',120.00,0.00,6.00,0.00,0.00,126.00),(83,9144,62,'2010-03-24','2010-03-25',120.00,0.00,6.00,0.00,0.00,126.00),(87,9146,63,'2010-05-03','2010-05-20',540.00,257.00,39.85,17.99,0.00,854.84),(88,9147,68,'2010-05-10','2010-05-28',850.00,0.00,42.50,0.00,0.00,892.50),(89,9148,67,'2010-05-10','2010-05-14',120.00,0.00,6.00,0.00,0.00,126.00),(90,9149,71,'2010-06-01','2010-06-02',120.00,0.00,6.00,0.00,0.00,126.00),(91,9150,69,'2010-06-03','2010-06-08',210.00,0.00,10.50,0.00,0.00,220.50),(92,9151,73,'2010-06-03','2010-08-05',60.00,0.00,3.00,0.00,0.00,63.00),(93,9152,74,'2010-06-03','2010-07-15',90.00,0.00,4.50,0.00,0.00,94.50),(94,9153,75,'2010-06-14','2010-06-14',120.00,0.00,6.00,0.00,0.00,126.00),(95,9154,76,'2010-06-29','2010-07-06',1100.00,0.00,55.00,0.00,0.00,1155.00),(97,9155,77,'2010-06-30','2010-08-10',60.00,0.00,3.00,0.00,0.00,63.00),(98,9156,78,'2010-06-30','2010-08-05',180.00,0.00,9.00,0.00,0.00,189.00),(100,9157,70,'2010-06-30','2010-07-23',120.00,0.00,6.00,0.00,0.00,126.00),(101,9158,79,'2010-07-15','2010-08-05',90.00,0.00,0.00,0.00,10.80,100.80),(103,9159,81,'2010-07-23','2010-07-28',528.00,0.00,0.00,0.00,63.36,591.36),(118,9160,82,'2010-07-28','2010-10-21',1058.00,0.00,0.00,0.00,126.96,1184.96),(105,9161,83,'2010-07-23','2010-08-05',1250.00,0.00,0.00,0.00,150.00,1400.00),(119,9162,87,'2010-07-30','2010-08-05',60.00,0.00,0.00,0.00,7.20,67.20),(124,2181,84,'2010-08-04','2010-08-05',25.00,0.00,0.00,0.00,3.00,28.00),(121,2179,93,'2010-07-18','2010-08-05',75.00,0.00,0.00,0.00,9.00,84.00),(122,2180,94,'2010-07-31','2010-08-05',150.00,0.00,0.00,0.00,18.00,168.00),(123,9165,95,'2010-08-03','2010-08-05',108.00,0.00,0.00,0.00,12.96,120.96),(125,9167,97,'2010-08-04','2010-08-05',120.00,135.00,0.00,0.00,30.60,285.60),(126,2182,98,'2010-08-05','2010-08-05',25.00,0.00,0.00,0.00,3.00,28.00),(127,2183,99,'2010-08-06','2010-09-20',175.00,0.00,0.00,0.00,21.00,196.00),(128,9170,100,'2010-07-21','2010-07-21',60.00,0.00,0.00,0.00,7.20,67.20),(129,9171,101,'2010-08-09','2010-08-10',60.00,0.00,0.00,0.00,7.20,67.20),(130,9172,102,'2010-08-09','2010-08-09',0.00,95.00,0.00,0.00,11.40,106.40),(131,9173,103,'2010-08-09','2010-08-10',90.00,0.00,0.00,0.00,10.80,100.80),(132,9174,104,'2010-08-10','2010-09-08',180.00,28.00,0.00,0.00,24.96,232.96),(133,9175,105,'2010-08-11','2010-10-01',60.00,0.00,0.00,0.00,7.20,67.20),(134,9176,106,'2010-08-11','2010-09-15',90.00,0.00,0.00,0.00,10.80,100.80),(140,2184,107,'2010-09-17','2010-09-20',62.50,0.00,0.00,0.00,7.50,70.00),(138,2185,88,'2010-09-16','2010-09-20',150.00,0.00,0.00,0.00,18.00,168.00),(141,9180,108,'2010-09-20','2010-09-20',180.00,0.00,0.00,0.00,21.60,201.60),(142,9181,112,'2010-09-23','2010-10-26',180.00,0.00,0.00,0.00,21.60,201.60),(143,2186,113,'2010-09-23','2010-09-23',250.00,0.00,0.00,0.00,30.00,280.00),(145,9183,116,'2010-09-29','2010-10-15',450.00,0.00,0.00,0.00,54.00,504.00),(146,9184,110,'2010-09-30','2010-10-08',135.00,0.00,0.00,0.00,16.20,151.20),(147,9185,117,'2010-10-01','2010-10-01',60.00,70.00,0.00,0.00,15.60,145.60),(148,9186,119,'2010-10-06','2010-10-06',30.00,0.00,0.00,0.00,3.60,33.60),(150,9187,115,'2010-10-06','2010-10-29',435.00,0.00,0.00,0.00,52.20,487.20),(152,9188,122,'2010-10-07','2010-11-03',85.00,0.00,0.00,0.00,10.20,95.20),(154,2187,125,'2010-10-13','2010-10-13',31.00,0.00,0.00,0.00,3.72,34.72),(155,2188,123,'2010-10-13','2010-10-13',150.00,0.00,0.00,0.00,18.00,168.00),(156,2189,124,'2010-10-13','2010-10-13',200.00,0.00,0.00,0.00,24.00,224.00),(157,2190,126,'2010-10-13','2010-10-13',250.00,0.00,0.00,0.00,30.00,280.00),(158,9193,121,'2010-10-13','2010-10-13',420.00,0.00,0.00,0.00,50.40,470.40),(159,2191,127,'2010-10-13','2010-10-13',4.00,0.00,0.00,0.00,0.48,4.48),(160,9195,120,'2010-10-14','2010-11-18',60.00,0.00,0.00,0.00,7.20,67.20),(161,9196,128,'2010-10-14','2010-10-14',60.00,0.00,0.00,0.00,7.20,67.20),(169,9202,133,'2010-11-01','2010-11-12',465.00,0.00,0.00,0.00,55.80,520.80),(166,9201,131,'2010-10-22','2010-10-22',0.00,70.00,0.00,0.00,8.40,78.40),(164,9199,129,'2010-10-16','2010-11-17',60.00,0.00,0.00,0.00,7.20,67.20),(165,9200,130,'2010-10-21','2010-10-21',180.00,0.00,0.00,0.00,21.60,201.60),(170,9203,135,'2010-11-02','2010-12-03',180.00,0.00,0.00,0.00,21.60,201.60),(172,2192,137,'2010-11-02','2010-11-20',75.00,0.00,0.00,0.00,9.00,84.00),(173,2193,139,'2010-11-02','2010-11-20',12.50,0.00,0.00,0.00,1.50,14.00),(174,9204,140,'2010-11-09','2010-11-09',45.00,0.00,0.00,0.00,5.40,50.40),(175,9205,136,'2010-11-09','2010-11-18',225.00,0.00,0.00,0.00,27.00,252.00),(177,2194,142,'2010-11-09','2010-11-20',37.50,0.00,0.00,0.00,4.50,42.00),(178,2143,143,'2010-01-13','2010-01-13',275.00,0.00,13.75,0.00,0.00,288.75),(179,2144,144,'2010-01-13','2010-01-13',300.00,0.00,15.00,0.00,0.00,315.00),(180,2145,145,'2010-01-13','2010-01-13',50.00,0.00,2.50,0.00,0.00,52.50),(181,2146,146,'2010-01-28','2010-01-28',75.00,0.00,3.75,0.00,0.00,78.75),(182,2147,147,'2010-01-28','2010-01-28',30.00,160.00,9.50,11.20,0.00,210.70),(183,2148,148,'2010-02-05','2010-02-05',50.00,0.00,2.50,0.00,0.00,52.50),(184,2149,149,'2010-02-05','2010-02-05',50.00,0.00,2.50,0.00,0.00,52.50),(185,9206,150,'2010-11-15','2010-12-23',60.00,0.00,0.00,0.00,7.20,67.20),(186,2195,151,'2010-11-18','2010-11-20',225.00,0.00,0.00,0.00,27.00,252.00),(187,2196,152,'2010-11-19','2010-11-20',12.50,0.00,0.00,0.00,1.50,14.00),(188,2197,153,'2010-11-18','2010-11-20',50.00,0.00,0.00,0.00,6.00,56.00),(189,9207,154,'2010-11-22','2010-12-23',255.00,0.00,0.00,0.00,30.60,285.60),(190,9208,156,'2010-11-04','2010-11-04',90.00,0.00,0.00,0.00,10.80,100.80),(191,9209,157,'2010-11-17','2010-11-17',60.00,0.00,0.00,0.00,7.20,67.20),(192,9210,159,'2010-11-26','2010-12-02',180.00,0.00,0.00,0.00,21.60,201.60),(194,9211,155,'2010-11-26','2010-12-23',390.00,0.00,0.00,0.00,46.80,436.80),(195,2198,166,'2010-11-30','2010-12-03',250.00,0.00,0.00,0.00,30.00,280.00),(196,9212,167,'2010-12-02','2010-12-23',135.00,0.00,0.00,0.00,16.20,151.20),(197,9213,173,'2010-11-01','2010-12-14',600.00,133.75,0.00,0.00,88.05,821.80),(198,9214,175,'2010-12-10','2010-12-10',0.00,165.00,0.00,0.00,19.80,184.80),(199,9215,168,'2010-12-10','2010-12-17',945.00,0.00,0.00,0.00,113.40,1058.40),(200,9216,177,'2010-12-15','2010-12-17',300.00,10.00,0.00,0.00,37.20,347.20),(201,9217,178,'2010-12-15','2010-12-17',90.00,124.99,0.00,0.00,25.80,240.79),(202,9218,165,'2010-12-21','2010-12-21',150.00,0.00,0.00,0.00,18.00,168.00),(203,9219,176,'2010-12-22','2011-01-04',495.00,0.00,0.00,0.00,59.40,554.40),(204,2199,183,'2010-12-23','2011-01-04',200.00,0.00,0.00,0.00,24.00,224.00),(205,2200,182,'2010-12-20','2011-01-04',250.00,0.00,0.00,0.00,30.00,280.00),(206,2201,184,'2010-12-09','2011-01-04',18.75,0.00,0.00,0.00,2.25,21.00),(207,9220,185,'2011-01-05','2011-01-18',495.00,68.00,0.00,0.00,67.56,630.56),(208,2202,186,'2010-12-27','2011-01-23',37.50,0.00,0.00,0.00,4.50,42.00),(209,2203,187,'2011-01-05','2011-01-23',200.00,0.00,0.00,0.00,24.00,224.00),(210,9221,188,'2011-01-11','2011-01-23',60.00,0.00,0.00,0.00,7.20,67.20),(211,9222,189,'2011-01-20','2011-01-20',105.00,0.00,0.00,0.00,12.60,117.60),(212,9223,191,'2011-01-23','0000-00-00',90.00,0.00,0.00,0.00,10.80,100.80),(213,9224,192,'2011-01-23','0000-00-00',75.00,0.00,0.00,0.00,9.00,84.00),(214,9225,196,'2011-01-23','0000-00-00',60.00,0.00,0.00,0.00,7.20,67.20),(215,9226,194,'2011-01-23','0000-00-00',90.00,0.00,0.00,0.00,10.80,100.80);

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `logid` int(4) NOT NULL auto_increment,
  `clientid` int(3) NOT NULL,
  `logdate` date NOT NULL,
  `logtime` time NOT NULL,
  `problem` longtext NOT NULL,
  `charge` decimal(6,0) NOT NULL,
  `invoiced` enum('Yes','No') NOT NULL default 'No',
  `website` char(5) NOT NULL,
  `invid` int(10) NOT NULL,
  PRIMARY KEY  (`logid`)
) ENGINE=MyISAM AUTO_INCREMENT=197 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` VALUES (5,6,'2009-02-04','12:00:00','Needs to access security system from home','60','Yes','',29),(6,5,'2008-11-09','10:00:00','Oversee software development for Album maker','50','Yes','',33),(10,7,'2009-01-15','12:00:00','Cannot connect to printer\r\nClean PC\r\nSetup new laptop\r\nInstall new laptop','50','Yes','',32),(94,19,'2010-07-22','09:00:00','Arctic Medical Adventures','25','Yes','',122),(88,19,'2010-07-10','09:00:00','A Balanced Kitchen','25','Yes','',138),(14,8,'2009-01-15','12:00:00','Needs to view security camera\\\'s off site','60','Yes','',31),(15,9,'2009-03-02','12:00:00','Needs website','30','Yes','',21),(16,11,'2009-03-03','12:00:00','Need security on wireless','60','Yes','',36),(21,14,'2009-03-13','14:00:00','Can`t send emails\r\nMemory card has fallen into the computer','60','Yes','',23),(22,10,'2009-01-15','10:00:00','Need help accessing DVR system from office computers','60','Yes','',22),(23,1,'2009-03-27','10:00:00','test','60','No','',0),(85,20,'2010-07-28','10:00:00','new test for invoices','60','Yes','',203),(25,7,'2009-04-01','12:00:00','Needs Document Recovered','60','Yes','',37),(26,10,'2009-04-27','12:00:00','Cannot send emails','60','Yes','',39),(27,15,'2009-05-20','12:00:00','Needs to set up new software','60','Yes','',40),(28,7,'2009-05-26','13:00:00','Has 2 Personal Folders in Outlook\r\n','60','Yes','',41),(29,15,'2009-06-02','10:00:00','Need to update ERCS program','60','Yes','',42),(30,10,'2009-06-25','15:00:00','Email Problems','60','Yes','',47),(31,1,'2009-07-07','12:00:00','Problem with email','60','No','',0),(32,1,'2009-07-07','12:00:00','Inca Site','25','No','',0),(33,16,'2009-07-23','15:00:00','Power surge','60','Yes','',50),(34,15,'2009-07-09','12:00:00','New update has slowed the program down','60','Yes','',51),(35,1,'2009-07-31','14:00:00','test me againg','60','No','',0),(36,1,'2009-07-31','01:00:00','test aginaaa','50','No','',0),(37,7,'2009-07-28','12:00:00','Computer Running slow','60','Yes','',53),(38,17,'2009-08-20','12:00:00','Computer slow\r\nExplorer not working','60','Yes','',55),(39,10,'2009-08-14','10:00:00','Setup backup and upgrade pc','60','Yes','',58),(40,10,'2009-09-16','16:00:00','Needs to extract video from DVR\r\nSetup Laptop for Colin','60','Yes','',59),(41,18,'2009-09-25','08:30:00','Cannot switch on PC','60','Yes','',60),(93,19,'2010-07-18','09:30:00','Garden Inspiration Landscape Designs','25','Yes','',121),(44,6,'2009-09-22','09:00:00','Needs to connect remotely with mac','60','Yes','',62),(45,10,'2009-10-20','09:00:00','Scanner Problems','60','Yes','',63),(46,18,'2009-10-22','10:00:00','Needs new PC','60','Yes','',64),(47,20,'2009-10-29','12:00:00','Email and network help','60','Yes','',65),(48,15,'2009-11-04','10:00:00','Need to update ERCS software','60','Yes','',66),(49,20,'2009-11-12','09:00:00','Cannot open Outlook','60','Yes','',67),(50,21,'2009-11-20','11:00:00','Virus on PC','60','Yes','',68),(51,6,'2009-12-10','10:00:00','needs to recover data off an old hard drive','60','Yes','',69),(52,16,'2009-12-17','11:00:00','Need to setup New PC','60','Yes','',70),(53,16,'2010-12-29','10:00:00','Setup second PC','60','Yes','',71),(54,20,'2010-01-04','12:00:00','Needs help with outlook backup','60','Yes','',73),(55,10,'2010-01-14','09:00:00','Need help with too many personal folders in outlook','60','Yes','',74),(56,10,'2010-01-31','17:15:00','Need to get data off a PC','60','Yes','',75),(57,23,'2010-02-01','09:00:00','Need Help to set up new dairy system on PC','60','Yes','',79),(58,22,'2010-02-12','12:00:00','Needs new battery for Dell Laptop','60','Yes','',76),(59,16,'2010-02-24','09:00:00','Fis Simply acountting printing','60','Yes','',80),(60,10,'2010-03-02','07:30:00','Problems with Bruce\\\'s Laptop','60','Yes','',85),(61,20,'2010-03-17','09:00:00','Problem with emails and backup','60','Yes','',82),(62,24,'2010-03-16','10:00:00','Set up new laptop','60','Yes','',83),(63,23,'2010-03-16','09:00:00','Setup Time Force','60','Yes','',87),(64,10,'2010-03-15','14:00:00','Setup Backups on all PC\\\'s','60','Yes','',145),(65,10,'2010-03-19','09:00:00','Laptop shutting down on its own','60','Yes','',145),(67,20,'2010-05-09','09:00:00','Help with new software','60','Yes','',89),(68,25,'2010-02-01','09:00:00','Build New Site','50','Yes','',88),(69,20,'2010-05-14','11:00:00','Problem with printing from Lumber Expert','60','Yes','',91),(70,23,'2010-05-14','10:00:00','No data visible in Dairy Comp','60','Yes','',100),(71,26,'2010-05-13','14:00:00','Need to clean Computers','60','Yes','',90),(72,23,'2010-05-21','14:00:00','Setup new laptop for Carol','60','Yes','',100),(73,15,'2010-05-27','09:00:00','Setup back on new memory stick','60','Yes','',92),(74,27,'2010-06-01','09:00:00','Need to setup new laptop','60','Yes','',93),(75,28,'2010-06-14','09:00:00','No INternet Explorer','60','Yes','',94),(76,29,'2010-04-23','09:00:00','Create Survey Website','50','Yes','',95),(77,10,'2010-06-09','09:00:00','Virus Out of date','60','Yes','',97),(78,21,'2010-06-29','09:00:00','Cannot print when setting up new users','60','Yes','',98),(79,15,'2010-07-13','10:00:00','Need to update ERCS with new fees','60','Yes','',101),(81,25,'2010-07-22','10:00:00','Web Hositng','9','Yes','',103),(82,30,'2010-03-02','09:00:00','Web Design','50','Yes','',118),(83,31,'2010-03-11','09:00:00','Need a website','50','Yes','',105),(84,19,'2010-07-14','09:00:00','Beakem Promotions','25','Yes','',124),(87,32,'2010-07-29','14:00:00','Cannot print pictures','60','Yes','',119),(86,30,'2010-07-28','09:00:00','1 year web hosting','108','Yes','',118),(95,31,'2010-08-03','09:30:00','1 year web hosting','9','Yes','',123),(96,15,'2010-08-04','09:00:00','New ERCS update','60','Yes','',125),(97,15,'2010-08-04','10:00:00','New Cisco Router','60','Yes','',125),(98,19,'2010-08-04','09:00:00','Free Fall Jump','25','Yes','',126),(99,19,'2010-07-06','09:00:00','Pushor Mitchell','25','Yes','',127),(100,33,'2010-07-21','09:00:00','Word not working','60','Yes','',128),(101,33,'2010-08-06','10:00:00','Need to scan for viruses','60','Yes','',129),(102,7,'2010-08-05','10:00:00','Need backup setup','60','Yes','',130),(103,7,'2010-08-05','10:00:00','Need cleanup and backup','60','Yes','',131),(104,10,'2010-08-09','09:00:00','Need to setup contacts on iphone','60','Yes','',132),(105,23,'2010-08-05','11:00:00','No display on parlour pc','60','Yes','',133),(106,16,'2010-08-10','20:30:00','Cannot access site','60','Yes','',134),(107,19,'2010-09-09','09:30:00','Stuarts Law','25','Yes','',140),(108,28,'2010-09-20','09:00:00','Cannot Scan and laptop not connecting to wireless','60','Yes','',141),(109,10,'2010-09-15','09:00:00','iPhone lost connection to wireless','60','Yes','',145),(110,20,'2010-09-20','10:00:00','Roger needs help with email','60','Yes','',146),(111,23,'2010-09-15','09:00:00','Dairy Comp not syncronizing','60','Yes','',150),(112,27,'2010-09-21','08:00:00','Laptop will not start','60','Yes','',142),(113,19,'2010-09-23','09:00:00','Earthkin Energy','25','Yes','',143),(114,23,'2010-09-28','09:00:00','Setup new router','60','Yes','',150),(115,23,'2010-09-29','09:00:00','Setup Quick Books','60','Yes','',150),(116,10,'2010-09-25','20:00:00','Cannot access emails','60','Yes','',145),(117,16,'2010-10-20','13:00:00','Backup Disk Broken','60','Yes','',147),(118,19,'2010-10-04','00:00:30','Stuarts Law Updates','25','Yes','',154),(119,16,'2010-10-06','09:00:00','Change simply reports format','60','Yes','',148),(120,28,'2010-10-05','10:00:00','Needs Spam Filter','60','Yes','',160),(121,34,'2010-10-04','15:00:00','Initial Meeting','60','Yes','',158),(122,25,'2010-09-21','09:03:00','Site Updates','60','Yes','',152),(123,19,'2010-10-04','09:00:00','Kelowna Pet sitting','25','Yes','',155),(124,19,'2010-10-05','09:00:00','One to One Home Support','25','Yes','',156),(125,19,'2010-10-08','09:00:00','Alex Mercks','25','Yes','',154),(126,19,'2010-09-27','08:00:00','AWD Support','25','Yes','',157),(127,19,'2010-10-06','09:00:00','Playa Marine Inc','25','Yes','',159),(128,33,'2010-10-13','14:30:00','Upgrade to Word 2003','60','Yes','',161),(131,33,'2010-10-18','09:00:00','Upgrade memory','60','Yes','',166),(129,22,'2010-10-12','09:00:00','Wireless not working','60','Yes','',164),(130,35,'2010-10-18','14:00:00','Laptop will not start','60','Yes','',165),(132,36,'2010-10-28','13:30:00','Need to network computers and setup email','60','Yes','',169),(133,36,'2010-10-29','11:30:00','Need to network files and quickbooks','60','Yes','',169),(134,0,'0000-00-00','00:00:00','','0','No','',0),(135,10,'2010-10-04','09:00:00','Need to install Mobile PC','60','Yes','',170),(136,15,'2010-10-26','07:15:00','Setup email share','60','Yes','',175),(137,19,'2010-10-14','09:00:00','Frontline First Aid','25','Yes','',172),(139,19,'2010-10-21','09:00:00','Gran Fondo Alex Merckx','25','Yes','',173),(140,16,'2010-11-05','09:30:00','Need to setup printer on shaw','60','Yes','',174),(142,19,'2010-11-04','10:00:00','Body Shop Cross Fit','25','Yes','',177),(143,19,'2010-01-13','09:00:00','Simon & Associates Web Design','25','Yes','',178),(144,19,'2010-01-13','09:00:00','Luwak URban Blendz Web Design','25','Yes','',179),(145,19,'2010-01-13','09:00:00','Office Phone Support','25','Yes','',180),(146,19,'2010-01-28','09:00:00','Luwak URban Blendz Web Design','25','Yes','',181),(147,19,'2010-01-28','09:00:00','Computer Upgrading','60','Yes','',182),(148,19,'2010-02-05','09:00:00','BCGEHR Web Design','25','Yes','',183),(149,19,'2010-02-05','09:00:00','Eating Disorders Web Design','25','Yes','',184),(150,36,'2010-11-08','09:00:00','Setup printer in office','60','Yes','',185),(151,19,'2010-11-17','09:00:00','Bike Lane Aware','25','Yes','',186),(152,19,'2010-11-03','09:00:00','Grab Bags','25','Yes','',187),(153,19,'2010-11-04','09:00:00','Rhea Taylor Photography','25','Yes','',188),(154,36,'2010-11-15','13:00:00','Network has gone down','60','Yes','',189),(155,23,'2010-11-11','09:00:00','Quickbooks and time force problem','60','Yes','',194),(156,37,'2010-11-03','09:00:00','Needs computer help','60','Yes','',190),(157,37,'2010-11-16','09:00:00','Setup wireless router','60','Yes','',191),(158,20,'2010-11-24','09:00:00','Problems with explorer and computer freezing','60','Yes','',203),(159,26,'2010-11-03','16:00:00','Check if computers need cleaning','60','Yes','',192),(160,38,'2010-10-12','12:00:00','Printer not working','60','No','',0),(161,38,'2010-10-07','09:00:00','Created Blenz Banner','60','No','',0),(162,38,'2010-11-25','09:00:00','Upload Adds','60','No','',0),(163,38,'2010-11-26','09:00:00','Change sponsors on site','60','No','',0),(164,38,'2010-11-30','09:00:00','Change tirecraft & create ok restoration','60','No','',0),(165,7,'2010-11-29','14:15:00','Computer freezing','60','Yes','',202),(166,19,'2010-11-16','09:00:00','Odyssey Landscape','25','Yes','',195),(167,36,'2010-11-30','11:00:00','Install new PC','60','Yes','',196),(168,10,'2010-11-30','09:00:00','Assess new office for networking','60','Yes','',199),(169,25,'2010-11-05','09:00:00','Update education section','60','No','',0),(170,39,'2010-12-01','09:00:00','Computer is slow, and explorer not working','60','No','',0),(171,38,'2010-12-02','09:00:00','Support for Ticket sales','60','No','',0),(172,38,'2010-12-06','09:00:00','Cannot print','60','No','',0),(173,40,'2010-11-02','09:00:00','Create Words on Demand website','60','Yes','',197),(175,10,'2010-12-08','09:00:00','Purchase Equipment','60','Yes','',198),(176,20,'2010-12-07','09:00:00','Scanner not working from printed and remote access','60','Yes','',203),(177,26,'2010-12-13','09:00:00','Problem with internet and fax','60','Yes','',200),(178,10,'2010-12-13','09:00:00','Setup PDF editor','60','Yes','',201),(179,10,'2010-12-16','09:00:00','Install Hywood email on Bob\\\'s PC','60','Yes','',207),(180,10,'2010-12-21','09:00:00','No internet connection onmultiple PC\\\'s','60','Yes','',207),(181,31,'2010-10-12','09:00:00','Make site changes','60','No','',0),(182,19,'2010-12-01','09:00:00','English Training International','25','Yes','',205),(183,19,'2010-12-03','09:00:00','Flat Fees Realty','25','Yes','',204),(184,19,'2010-12-08','09:00:00','Body Shop Cross Fit','25','Yes','',206),(185,10,'2010-12-27','09:00:00','Update Bruce\\\\\\\'s AntiV','60','Yes','',207),(186,19,'2010-12-27','09:00:00','Dance with Spirit','25','Yes','',208),(187,19,'2011-01-04','09:00:00','Okanagan Boat Lifts','25','Yes','',209),(188,19,'2011-01-10','09:00:00','Computer not connecting to internet','60','Yes','',210),(189,41,'2011-01-17','09:00:00','Problem with emails','60','Yes','',211),(190,26,'2011-01-10','09:00:00','DVD drive not opening','60','No','',0),(191,36,'2011-01-12','09:00:00','Need to setup email','60','Yes','',212),(192,10,'2011-01-10','09:00:00','Tested Sharon blackberry email','60','Yes','',213),(193,7,'2011-01-03','09:00:00','Problems with firewall','60','No','',0),(194,15,'2011-01-19','09:00:00','Setup temp laptop','60','Yes','',215),(195,38,'2011-01-10','09:00:00','create ads for VWC','60','No','',0),(196,34,'2011-01-04','09:00:00','Need scanner moved','60','Yes','',214);

--
-- Table structure for table `okcategories`
--

CREATE TABLE `okcategories` (
  `cat_id` int(8) NOT NULL auto_increment,
  `cat_parent` int(8) NOT NULL,
  `cat_name` varchar(50) NOT NULL,
  `cat_desc` text NOT NULL,
  `cat_image` varchar(200) NOT NULL,
  PRIMARY KEY  (`cat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `okcategories`
--

INSERT INTO `okcategories` VALUES (1,0,'Visit Us','',''),(2,0,'Events & Activities','',''),(3,0,'History & Collections','',''),(4,0,'Education & Tours','',''),(5,0,'About Us','',''),(6,1,'Map & Location','',''),(7,1,'Admission Rates','',''),(8,2,'Daily Activities','',''),(9,1,'Group Rates','',''),(10,2,'Events Calendar','',''),(16,2,'Agriculture & Animals','',''),(17,2,'Artisans','',''),(18,3,'Ranch History','',''),(19,19,'Tickets for upcoming events','',''),(20,4,'School tours','',''),(21,4,'Group Tours','',''),(23,2,'Weddings','',''),(29,5,'Sponsorships','',''),(30,2,'O\'Keefe Cowboy Festival','',''),(31,23,'Special Information','',''),(32,5,'Adopt-a-Building Program','',''),(33,5,'Volunteers','','');

--
-- Table structure for table `okcontent`
--

CREATE TABLE `okcontent` (
  `cont_id` int(8) NOT NULL auto_increment,
  `cont_cat` int(8) NOT NULL,
  `cont_title` varchar(100) NOT NULL,
  `cont_body` text NOT NULL,
  `cont_publ` varchar(10) NOT NULL default 'yes',
  PRIMARY KEY  (`cont_id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `okcontent`
--



--
-- Table structure for table `oknews`
--

CREATE TABLE `oknews` (
  `news_id` int(11) NOT NULL auto_increment,
  `news_title` varchar(200) NOT NULL,
  `news_cont` text NOT NULL,
  PRIMARY KEY  (`news_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `oknews`
--

INSERT INTO `oknews` VALUES (2,'Latest News','<div>\r\n<p>Up and coming events:</p>\r\n<p><em><strong><span style=\"font-size: small;\">Dec. 10,11,12th: from 2:00 to 6:00 pm<br /><a href=\"http://www.okeeferanch.ca/posters/victorian_christmas.pdf\" target=\"_blank\">Victorian Christmas</a> - </span></strong><span style=\"font-size: small;\">a wonderful afternoon at the Ranch! The O\'Keefe Victorian Mansion will be open, decorated and full of music; we\'ll have Christmas carolers in the Church and along the boardwalk; roasting chestnuts, a bonfire and sleigh rides.Warm your toes and have a hot chocolate by the old stove in the General Store.Dress warm! Rates: $6 per person/$20 per family. </span></em></p>\r\n</div>');

--
-- Table structure for table `stock`
--

CREATE TABLE `stock` (
  `stockid` int(11) NOT NULL auto_increment,
  `category1` varchar(20) NOT NULL,
  `category2` varchar(20) NOT NULL,
  `manufacturer` varchar(20) NOT NULL,
  `model` varchar(20) NOT NULL,
  `description` text NOT NULL,
  `quantity` int(11) NOT NULL,
  `boughtfor` float(10,2) NOT NULL,
  `source` varchar(20) NOT NULL,
  `image` varchar(60) NOT NULL,
  PRIMARY KEY  (`stockid`)
) ENGINE=MyISAM AUTO_INCREMENT=72 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stock`
--

INSERT INTO `stock` VALUES (1,'Cables','Video','Generic','','RCA Video Cable 1m',0,5.00,'FutureShop','rcavideo.jpg'),(10,'Cables','Audio','','','BNC to RCA converter',5,7.99,'TheSource','bncconverter.jpg'),(9,'Cables','Video','','','SVGA Monitor Cable 1.8m',1,15.00,'PCM','svga.jpg'),(11,'Components','Memory','Crucial','X 3200','DDR 400',2,40.00,'Memory Express','ddr.jpg'),(13,'Components','Memory','Crucial','XMS 8500','DDR2 Memory 677mhz',2,129.00,'Ingram','ddr2.jpg'),(14,'Components','CPU','Intel','E220','2.2ghz Core2 Duo',1,187.00,'Ingram','intel.jpg'),(15,'Components','Memory','Crucial','DDR2 677','DDR2 677',3,89.03,'NCIX',''),(16,'Compnoents','Power Supply','Dynex','','Dynex Power Supply',0,82.00,'Futureshop',''),(18,'Components','Memory','Corsair','PC3200 1GB','DDR400 CL3 184PIN',0,45.19,'NCIX',''),(20,'Components','External Storage','Buffalo','MiniStation Cobalt B','320GB Portable External Hard Drive USB ',0,94.99,'NCIX',''),(45,'Cables','USB','Griffin','iPhone Cable','USB iPhone cable',0,28.00,'Rogers Wireless',''),(22,'Software','Office','Microsoft','Office 2007','Office 2007 Student',0,112.00,'Staples',''),(43,'Components','Disk Drive','Seagate','Goflex 320Gb','Seagate Goflex 320Gb',0,89.00,'Futureshop',''),(24,'Systems','PC','Generic','','Quad core - Windows 7 PC',0,1076.83,'NCIX',''),(26,'Networking','Wireless','Dlink','WUA-1340 USB','USB Wireless Adapter',0,45.00,'Futureshop',''),(28,'Hardware','Disk Drive','Seagate','','320GB Portable External Hard Drive USB ',0,111.99,'Futureshop',''),(30,'Components','Memory','Kingston','DDR333','2 GB DDR Memory',0,87.00,'NCIX',''),(32,'Components','Battery','Dell','','Dell C600 Battery',0,60.00,'West Coast Power',''),(34,'Components','Disk Drive','Comstar','400GB External','400GB External Drive',1,70.00,'Futureshop',''),(35,'Networking','Wireless','EnGenius','EOC-3610S','Outddor Wireless Router',0,91.63,'NCIX',''),(37,'Networking','Wireless','ASUS','USB-N13','Wireless USB Adapter',0,29.99,'NCIX',''),(39,'Cables','Networking','CableTec','CAT 5E','Cat 5E Cable',35,0.80,'Home Depot',''),(41,'Networking','Wireless','Cisco','WRT310N','Cisco Wireless N Router',0,119.00,'Futureshop',''),(47,'Components','External Storage','Seagate','250GB USB 2.0','250GB Portable Hard Disk',1,67.00,'Futureshop',''),(48,'Components','Memory','Corsair','DDR 400','DDR 400 Memory',0,59.00,'NCIX',''),(50,'Components','Memory','Kingston','ValueRam','DDR 333 Memory',0,34.99,'NCIX',''),(52,'Components','Video','ASUS','','Asus 1GB Graphics Card',0,70.00,'NCIX',''),(54,'Web','Hosting','','','Year web hosting',0,0.00,'',''),(58,'Components','Video','Sapphire','5450 512MB','ATI Graphics Card 5450',0,83.99,'Futureshop',''),(56,'Web','Domain name','','','Purchase of domain name',0,25.75,'',''),(66,'Cables','USB','','','2m USB Printer Cable',0,0.00,'',''),(68,'Software','Office','Nitro','PDF Editor Pro','PDF Editor',0,124.99,'Online',''),(60,'Networking','Ethernet Card','Dlink','','Dlink Ethernet Card',0,30.00,'Staples',''),(61,'','','','','',0,0.00,'',''),(62,'Web','Domain name','','','Domain Name',-14,15.00,'',''),(63,'','','','','',0,0.00,'',''),(64,'Web','Email Hosting','','','1 year email hosing',0,30.00,'',''),(65,'','','','','',0,0.00,'',''),(67,'','','','','',0,0.00,'',''),(69,'','','','','',0,0.00,'',''),(70,'Software','Anti Virus','Symantec','Norton Anti Virus','Norton Anti Virus',0,68.00,'Symantec',''),(71,'','','','','',0,0.00,'','');

--
-- Table structure for table `stocksold`
--

CREATE TABLE `stocksold` (
  `stocksoldid` int(11) NOT NULL auto_increment,
  `stockid` int(11) NOT NULL,
  `visitid` int(11) NOT NULL,
  `description` text NOT NULL,
  `quantity` int(11) NOT NULL,
  `boughtfor` float(10,2) NOT NULL,
  `soldfor` float(10,2) NOT NULL,
  `markup` int(11) NOT NULL,
  PRIMARY KEY  (`stocksoldid`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stocksold`
--

INSERT INTO `stocksold` VALUES (1,10,2,'BNC to RCA converter',1,5.00,12.45,300),(2,1,2,'RCA Video Cable 1m',1,5.00,10.75,100),(12,15,21,'DDR2 677',1,89.03,89.03,0),(14,18,42,'DDR400 CL3 184PIN',1,45.19,65.95,0),(13,16,37,'Dynex Power Supply',1,82.00,73.21,0),(15,20,43,'320GB Portable External Hard Drive USB ',1,94.99,119.99,0),(16,22,43,'Office 2007 Student',1,112.00,114.99,0),(17,24,55,'Quad core - Windows 7 PC',1,1076.83,1370.46,0),(18,26,64,'USB Wireless Adapter',1,45.00,30.00,0),(19,28,70,'320GB Portable External Hard Drive USB ',1,111.99,134.95,0),(20,30,71,'2 GB DDR Memory',1,87.00,87.00,0),(21,32,74,'Dell C600 Battery',1,60.00,78.00,0),(22,0,76,'400GB External Drive',1,70.00,85.00,0),(23,37,90,'Wireless USB Adapter',1,29.99,45.00,0),(24,35,90,'Outddor Wireless Router',1,91.63,176.00,0),(25,39,90,'30m CAT 5E',1,25.00,36.00,0),(26,41,149,'Cisco Wireless N Router',1,119.00,135.00,0),(27,43,154,'Seagate Goflex 320Gb',1,89.00,95.00,0),(28,45,158,'USB iPhone cable',1,28.00,28.00,0),(29,0,182,'250GB Portable Hard Disk',1,67.00,70.00,0),(30,48,206,'DDR 400 Memory',1,59.00,70.00,0),(31,50,240,'DDR 333 Memory',2,34.99,40.00,0),(32,52,240,'Asus 1GB Graphics Card',1,70.00,80.00,0),(33,54,283,'Year web hosting',1,0.00,108.00,0),(35,56,280,'Purchase of domain name',1,25.75,25.75,0),(36,58,285,'ATI Graphics Card 5450',1,83.99,85.00,0),(37,60,285,'Dlink Ethernet Card',1,30.00,35.00,0),(38,62,285,'Domain Name',1,15.00,15.00,0),(39,64,285,'1 year email hosing',1,30.00,30.00,0),(40,66,290,'2m USB Printer Cable',1,0.00,10.00,0),(41,68,291,'PDF Editor',1,124.99,124.99,0),(42,70,310,'Norton Anti Virus',1,68.00,68.00,0);

--
-- Table structure for table `visits`
--

CREATE TABLE `visits` (
  `visitid` int(9) NOT NULL auto_increment,
  `logid` varchar(9) NOT NULL,
  `visitdate` date NOT NULL,
  `visittime` time NOT NULL,
  `timetaken` decimal(5,2) NOT NULL,
  `hrstaken` int(11) NOT NULL,
  `mintaken` int(11) NOT NULL,
  `workdone` longtext NOT NULL,
  PRIMARY KEY  (`visitid`)
) ENGINE=MyISAM AUTO_INCREMENT=329 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `visits`
--



--
-- Table structure for table `vmarticles`
--

CREATE TABLE `vmarticles` (
  `art_id` int(12) NOT NULL auto_increment,
  `art_title` varchar(100) NOT NULL,
  `art_body` text NOT NULL,
  `art_date` date NOT NULL,
  PRIMARY KEY  (`art_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vmarticles`
--

INSERT INTO `vmarticles` VALUES (1,'Test Allan Brooks','Allan Brooks was born at Etawah, northern India, on February 16th, 1869.  Allan’s father, William Edwin Brooks, was a civil engineer and amateur ornithologist.  While stationed in India with the East Indian Railroad, William Brooks studied bird life with a passion and spent much of his spare time collecting bird specimens for the British Museum.  William Brooks was good friends with Allan Octavian Hume (1829-1912), a civil servant in British India and one of the founders of the Indian National Congress, a political party that was later to prove instrumental in the Indian independence movement.  Hume, like William Brooks, was an amateur ornithologist and was once referred to as “the Father of Indian Ornithology.”  William Brooks named his son Allan after Hume.\r\n\r\nWilliam Brooks had hoped one of his sons (there were three boys and two girls in the family) would become an ornithologist and Allan showed promise in this field early in his childhood.  At the age of only two Allan often handled his father’s bird specimens and was considered then to have a born talent for being a naturalist.\r\n\r\nIn 1873, Allan was sent to England where he spent the next eight years living with his grandmother and maiden aunt while attending school in Northumberland.\r\n\r\nA special friend of William Brooks, John Hancock (1808-1890), “considered to be the father of modern taxidermy,” spent a lot of time with Allan and taught him about butterfly collecting, botany, and basic taxidermy.  It was said that Allan considered such things as board games or sports a waste of time and he preferred taking walks in the moors and observing wildlife.\r\n\r\nIn 1881, William Brooks retired from his work in India.  Although he was still a young man, William’s wife, Mary, was in poor health and it was recommended that she be taken to Canada where she could live in a healthier environment.  Wanting only the best for his wife, William packed up his entire family and sailed for eastern Canada.  Sadly, shortly after their arrival in Quebec, Mary Brooks passed away.  She was only 44 years of age.\r\n\r\nMary Brooks was buried in Quebec.  William then moved on to Milton, Ontario, where he attempted to make a home for himself and his children on a 200-acre farm.\r\n\r\nWilliam Brooks continued with his studies in ornithology and, over the ensuing years, many leading naturalists, ornithologists, and taxidermists in the region and from Europe came to visit, and sometimes stay for extended periods at the Brooks’ farm.  During these years, Allan spent much of his time preparing bird skins, sketching, reading numerous books on bird identification, and accompanying his father and visitors on field trips.  \r\n','2010-04-07');

--
-- Table structure for table `vmimages`
--

CREATE TABLE `vmimages` (
  `img_id` smallint(9) NOT NULL auto_increment,
  `img_desc` text NOT NULL,
  `img_keyw` text NOT NULL,
  `img_date` date NOT NULL,
  `img_location` varchar(100) NOT NULL,
  `img_phgr` varchar(100) NOT NULL,
  `img_circa` varchar(50) NOT NULL,
  `img_gvma` varchar(50) NOT NULL,
  `img_src` text NOT NULL,
  PRIMARY KEY  (`img_id`)
) ENGINE=MyISAM AUTO_INCREMENT=316 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vmimages`
--

INSERT INTO `vmimages` VALUES (1,'Portrait of Sophie (Johnson) Ellison who became Vernon&#039;s first school teacher in 1884.','ELLISON, SCHOOL','2010-04-27','','','1900','7783','7783.jpg'),(2,'Price Ellison. Elected MPP for Yale East in 1898.','ELLISON','2010-04-22','','','1893','3844','3844.jpg'),(154,'Cutting firewood on the Bailey property in the Commonage.','COMMONAGE, BAILEY','2010-04-22','Vernon','','1920&#039;s','2265','2265.jpg'),(22,'Portrait of Clarence Fulton. ','FULTON','2010-04-22','','Le Blond','1938','11204','11204.jpg'),(5,'The Schoolhouse at Oyama.','SCHOOL, OYAMA','2010-04-22','Oyama','','1912','15376','15376.jpg'),(6,'Lumby Elementary School.','SCHOOL','2010-04-27','Lumby','','1913','7978','7978.jpg'),(7,'Mara Elementary School.','SCHOOL','2010-04-27','Mara','','1938','3785','3785.jpg'),(8,'Elementary School (Park School). Constructed in 1893 and opened January 11th, 1894.','SCHOOL','2010-04-27','Vernon','','1895','833','833.jpg'),(19,'Portrait of Anna Fulton.','FULTON','2010-04-27','','','1946','6812','6812.jpg'),(9,'Elementary School (Park School). Group photo of students and teachers standing outside the entrance.','SCHOOL','2010-04-22','','','1895','1181','1181.jpg'),(12,'Clarence Fulton (L) and John Forsyth (R). Fulton was principal of Vernon High School from 1902 to 1917.  Smith was the editor of the Vernon News from 1906 to 1907.','FULTON, FORSYTH, SCHOOL, VERNON NEWS','2010-04-22','','','1906','11932','11932.jpg'),(13,'Vernon High School students and principal, Clarence Fulton. Clarence Fulton (bottom row, left) Thekla Reinhard, Clarence Fulton’s future wife, is seated in the second row at the left. Front steps of high school on Mason Street.','SCHOOL, FULTON, REINHARD','2010-04-27','Vernon','','1905','2790','2790.jpg'),(14,'Vernon High School. Mason Street (part of what is now 28th Street) location with new second story that was added in 1907.','SCHOOL','2010-04-22','','','1910','13641','13641.jpg'),(15,'Clarence Fulton at the time of his wedding.','FULTON','2010-04-22','','','1908','17210 ','17210.jpg'),(16,'Thekla Fulton at the time of her wedding.','FULTON','2010-04-22','','','1908','17211','17211.jpg'),(17,'Lakeview Dairy delivery wagon. Rupert Fulton, father to Clarence Fulton.','DAIRY, FULTON','2010-04-22','','','1916','17213','17213.jpg'),(20,'Portrait of Clarence Fulton.','FULTON','2010-04-22','','','1925','4013','4013.jpg'),(18,'Group photo of Central School students. Grade eight class for 1919-1920.  Clarence Fulton is at the back of the room.','FULTON, SCHOOL','2010-04-22','Vernon','','1919','3153','3153.jpg'),(23,'Anna Caroline Fulton. 1-year 8-months.','FULTON','2010-04-22','','','1913','24242','24242.jpg'),(24,'Lakeview Dairy delivery wagon. Rupert Fulton (Anna’s grandfather) with children (Anna second from left).','DAIRY, FULTON','2010-04-22','','','1916','11101','11101.jpg'),(25,'View of downtown and East Hill. The Reinhard home (built in 1907) is second from left on the hillside.','REINHARD, HOUSE, VERNON','2010-04-27','Vernon','','1909','2789','2789.jpg'),(26,'Thekla Fulton and her mother-in-law, Mary Fulton, possibly at Cameron’s Point on Okanagan Lake.','FULTON','2010-04-27','Okanagan Landing','','1908','24025','24025.jpg'),(27,'Members of the Fulton &amp; Reinhard Families. Back L-R: Lina Reinhard, Mary Fulton. Middle L-R: Robert Fulton, Thekla Fulton (holding Anna) Oscar Reinhard. Front L-R: Bill Fulton, Annie (Reinhard) Fulton.','FULTON, REINHARD','2010-04-22','','','1912','17214','17214.jpg'),(28,'Portrait of Caroline (Lina) Reinhard. Anna Fulton’s grandmother.','REINHARD, FULTON','2010-04-22','','','1890','19392','19392.jpg'),(29,'Reinhard Home (Dr. Reinhard’s first home and office on 29th Street) Vernon. L-R: Billy, Oscar, Gus, Lina Reinhard; Dr. Reinhard; Thekla, Anna.','REINHARD, HOUSE','2010-04-22','1896','','','11103','11103.jpg'),(30,'CGIT (Canadian Girls in Training) Camp. Anna Fulton is seated at left.','FULTON, GUIDES','2010-04-22','','','1927','19287','19287.jpg'),(31,'The Silver Star Ski Club. Anna Fulton (middle).','FULTON, SILVER STAR','2010-04-27','Vernon','','1939','19559','19559.jpg'),(218,'Formal group photo of the members of the Price Ellison family taken on a visit to Peoria.  L-R: Price Ellison, Elizabeth; Anna; Myra; Sophia; Ellen (on floor).','ELLISON','2010-04-22','Peoria, Ill.','N.E. Loquist,, Peoria','1893','3845','3845.jpg'),(32,'Skating on Long (Kalamalka) Lake. (left to right) Cathryn Simmons, Anna Fulton, Dorothy Price, Shiela Simmons, Eileen McNeil.','FULTON, SIMMONS, PRICE, MCNEIL, KALAMALKA LAKE','2010-04-27','Vernon','','1927','19283','19283.jpg'),(34,'Vernon High School Play. “The Closetâ€ (L to R) Janet Clarke, Mary-Jo Keron, Catherine Ormsby, Dorothy Tunbridge and Anna Fulton.','THEATRE, FULTON, ORMSBY, CLARKE, KERON, TUNBRIDGE, SCHOOL','2010-04-22','','','1938','7896','7896.jpg'),(35,'Vernon High School Staff. Anna Fulton (front row left). Clarence Fulton (back row left).','SCHOOL, FULTON','2010-04-27','Vernon','','1942','4834','4834.jpg'),(36,'Anna Fulton wearing uniform of the Red Cross Corps (Voluntary Aid Detachment).','FULTON, MILITARY','2010-04-27','','','1943','24245','24245.jpg'),(37,'Red Cross Corps (Voluntary Aid Detachment – Nursing). Anna Fulton (second from left) Vernon teacher, Betty Baillie, is on far right.','FULTON, BAILLIE, MILITARY','2010-04-27','','','1944','24241','24241.jpg'),(38,'Anna Fulton attending to a patient.','FULTON, MILITARY','2010-04-27','','','1944','24244','24244.jpg'),(39,'Group photo of Vernon contingent of the Canadian Red Cross Corps. Anna Fulton (front row, left).','FULTON, MILITARY','2010-04-27','','','1943','10805','10805.jpg'),(40,'Vernon High School Air Cadets. Photo taken on the front steps of the school.','SCHOOL, MILITARY','2010-04-27','Vernon','','1942','19312','19312.jpg'),(41,'Guests at British Council Tea. Anna Fulton is seated third from left.  The Canadian High Commissioner to London, Norman Robertson, is seated next to Anna.','FULTON, ROBERTSON','2010-04-27','','','1949','24313','24313.jpg'),(42,'Vernon High School grade 11 class. Anna Fulton (front row centre, light coloured suit).','FULTON, SCHOOL','2010-04-27','Vernon','','1949','24233','24233.jpg'),(43,'Robert Edgar Cail.','CAIL','2010-04-27','','','1956','24243','24243.jpg'),(44,'Anna (Fulton) Cail. Shortly before her retirement from teaching.','CAIL, FULTON','2010-04-27','Vernon','','1975','23657','23657.jpg'),(45,'Friends of History. (left to right standing) Bill Ramsay, Anna Cail, Len McLeod. (left to right, seated) Terry Lodge, Edna Oram, Claude McKim.','CAIL, RAMSEY, MCLEOD, LODGE, MCKIM','2010-04-27','Vernon','','1990','24237','24237.jpg'),(46,'Anna (Fulton) Cail in front of the Vernon library attending a United Nations Peace Rally.','FULTON, CAIL','2010-04-27','Vernon','','1990','14108','14108.jpg'),(47,'Anna (Fulton) Cail. Group seeking to establish a by-law for the protection of heritage trees. The group supported a policy that would give trees with a diameter of more than 8-inches heritage status. Left to right standing – Peter Blundell, Anna Cail, Joan Heriot, Marjorie Wise, Merv Prier, Eleanor Wilmot, Glen Niskisari. Left to right kneeling – Marion Blundell, Betty Ann Prier, Marnie Skobalski.','CAIL, FULTON','2010-04-27','','','1991','14376','14376.jpg'),(48,'Anna Cail inspecting a development project on the corner of Pleasant Valley Road and 39th Avenue.','CAIL','2010-04-27','Vernon','','1992','14650','14650.jpg'),(49,'Anna Cail looking at a photo depicting an architect’s rendition of how high rise buildings may look from Vernon’s downtown.  Anna hopes the hills and sky will continue to predominate the area.','CAIL','2010-04-27','Vernon','','1994','14988','14988.jpg'),(50,'Anna (Fulton) Cail giving a presentation to the Friends of History group.  ','CAIL, FULTON','2010-04-27','Vernon','','1994','21884','21884.jpg'),(58,'S.S. Okanagan on Okanagan Lake.','BOAT, OKANAGAN LAKE','2010-04-27','Okanagan Lake','','1910','71','71.jpg'),(53,'William Pound\r\n','','2010-04-19','','','1945','16561','16561.jpg'),(54,'David Howrie Sr.\r\nMayor of Vernon 1943-1947.\r\n','HOWRIE, CIVIC','2010-04-27','','','1945','3721','3721.jpg'),(55,'Exterior view of the Vernon Museum when it was located at the former police station.\r\n','MUSEUM','2010-04-27','Vernon','','1965','1272','1272.jpg'),(56,'L to R: George Melvin, Charlie Haines, David Howrie Sr.  Display cases built by Haines for the Pound collection are in the background.\r\n','MUSEUM, MELVIN, HAINES, HOWRIE ','2010-04-27','Vernon','','1956','1820','1820.jpg'),(57,'Entrance foyer to the Greater Vernon Museum &amp; Archives.','MUSEUM','2010-04-29','Vernon','','1967','11667','11667.jpg'),(59,'WW I soldiers with the Vernon nursing staff (the Blue Jays) on the lawns of Vernon Jubilee Hospital. ','MILITARY, HOSPITAL','2010-04-27','Vernon','','1916','2','2.jpg'),(60,'View of the Vernon Catholic Church (now St. James) at 2607-27 Street.','CHURCH','2010-04-22','Vernon','Vernon Photo /Schofield','1912','3','3.jpg'),(61,'View of the BX Ranch, Vernon.','FARM','2010-04-22','Vernon','Holliday Photo  Vernon','1893','15','15.jpg'),(62,'Portrait of the Okanagan Mounted Rifles with the band seated in front.','BAND, MILITARY','2010-04-27','Vernon','G.H.E. Hudson, Penticton','1914','18','18.jpg'),(63,'Portrait of Captain Thomas Shorts.','SHORTS','2010-04-20','','George  A. Meeres Photo','1890','42','42.jpg'),(64,'W.C. Pound, taxidermist and furrier, standing behind the counter in his store.','POUND, STORE','2010-04-20','Vernon','','1910','82','82.jpg'),(65,'The first meeting of the Vernon Automobile Club.','AUTOS','2010-04-20','Vernon','Vernon Photo Co.','1912','85','85.jpg'),(66,'The Carswell motion picture truck, covered in advertisements from local Vernon businesses, sitting in front of the Vernon movie house. ','TRUCK, MOVIE, THEATRE','2010-04-22','Vernon','','1922','95','95.jpg'),(67,'Front view of Watkin\'s Garage with crowds out front looking at new model Fords.','GARAGE, WATKIN','2010-04-20','Vernon','F. and M. Salt, Vernon','1925','96','96.jpg'),(68,'J.W. Knight and Mr. Smith standing with a steer outside of the Knight &amp; Co. Butcher shop in Vernon.','STORE, KNIGHT, SMITH','2010-04-22','Vernon','','1894','114','114.jpg'),(69,'The decorated No. 1 Fire Hall with men and equipment in front.  It was located at 3005-30 Street.','FIRE HALL, VFD','2010-04-22','Vernon',' G.H.E. Hudson','1912','143','143.jpg'),(70,'The BX stage coach on the Cariboo Road.','COACH, HORSES','2010-04-29','','','1900','148','148.jpg'),(71,'Vernon City Hall.','CIVIC','2010-04-27','Vernon','Schofield,  &amp; Vernon Photo Co.','1911','174','174.jpg'),(72,'The Vernon Hotel bar room with patrons lined up along the bar.','HOTEL','2010-04-22','Vernon','','1895','184','184.jpg'),(73,'Frank S. Reynolds agriculture machinery building at 3101 - 30 Avenue.','STORE, REYNOLDS','2010-04-22','Vernon','R.H. Trueman','1910','189','189.jpg'),(74,'A. Rodgers &amp; Co. Engine &amp; Machine Works which was located at 3202 - 31 Avenue.','STORE, RODGERS','2010-04-22','Vernon','W.B. Finley, Photographer','1905','190','190.jpg'),(75,'Pupils, parents and Principal William Sievwright, gathered in the school yard at Vernon’s second school.','SCHOOL ','2010-04-27','Vernon','','1891','192','192.jpg'),(76,'W.R. Megaw’s Store on Barnard Avenue.  Mr. Megaw is standing in the door way on the left side.','STORE, MEGAW, BARNARD','2010-04-22','Vernon','A.D. Wargan Photographer, Vernon BC','1892','197','197.jpg'),(77,'The Vernon News building on 32 Street (now Highway 97).','VERNON NEWS','2010-04-20','Vernon','','1898','198','198.jpg'),(78,'Vernon’s first Vernon courthouse on Coldstream Avenue.','COURT HOUSE','2010-04-22','Vernon','','1895','200','200.jpg'),(79,'The Kalamalka Hotel located at 3004 - Barnard Avenue.','HOTEL, BARNARD','2010-04-22','Vernon','A.D. Worgan','1891','201','201.jpg'),(80,'Vernon’s Boer War contingent – Strathcona’s Horse Regiment.','MILITARY','2010-04-27','Vernon','','1900','202','202.jpg'),(81,'Formal portrait of J.J. Hull, Vernon&#039;s first Fire Chief from 1899-1903.','HULL, VFD','2010-04-22','Vernon','','1900','203','203.jpg'),(82,'The Victoria Hotel on Coldstream Avenue.','HOTEL','2010-04-20','Vernon','','1890','209','209.jpg'),(83,'Portrait of Mrs. W.F. Cameron, founder of Vernon&#039;s first hospital.','CAMERON, HOSPITAL','2010-04-22','Vernon','','1900','211','211.jpg'),(84,'Employees standing in front of the Okanagan Harness & Saddlery Co.','STORE','2010-04-20','Vernon','','1895','212','212.jpg'),(85,'Children on horses and on foot standing outside Vernon&#039;s second elementary school.','SCHOOL','2010-04-22','Vernon','','1891','214','214.jpg'),(86,'The SS Penticton and her crew at the Okanagan Landing wharf.','BOAT, OKANAGAN LANDING','2010-04-27','Okanagan Landing','','1895','215','215.jpg'),(87,'Interior view of the Vernon News office.  Seated at their desks are J. A. McKelvie and Louis Ball.','VERNON NEWS, BALL, MCKELVIE','2010-04-22','Vernon','','1906','217','217.jpg'),(88,'Group photo of Vernon surveyors.','BURNYEAT, CORYELL, KIRBY','2010-04-22','Vernon','','1891','219','219.jpg'),(89,'Portrait of the Vernon Fire Brigade Band.','BAND, VFD','2010-04-22','Vernon','Trueman Vancouver, Kaslo, Sandon &amp; Revelstoke BC','1901','223','223.jpg'),(90,'Exterior view of the Mohr House, located at 2301 -32 Avenue.','MOHR, HOUSE','2010-04-22','Vernon','A.D. Worgan The Aberdeen Studio, Vernon BC','1893','225','225.jpg'),(91,'Dedication of the Vernon Cenotaph.','CENOTAPH','2010-04-20','Vernon','','1924','239','239.jpg'),(92,'The Honourable K.C. MacDonald standing beside the Silver Star Road commemorative sign.','MACDONALD, SILVER STAR','2010-04-20','Vernon',' George A. Meeres','1939','242','242.jpg'),(93,'Portrait of the founding fathers of Okanagan business and commerce.  Back row, left to right: Cornelius O\'Keefe, Moses Lumby,  Luc Girouard, James Charles Crozier. Front row left to right: Edward Tronson, Bernard Lequime, Frederick Brent, Isadore Boucherie and Thomas Ellis.','O’KEEFE, LUMBY, GIROUARD, CROZIER, TRONSON, LEQUIME, BRENT, BOUCHERIE, ELLIS','2010-04-20','Vernon','A.D. Worgan','1890','243','243.jpg'),(94,'Vernon&#039;s Capitol Theatre and accompanying National Café building on 30 Avenue.','THEATRE, BARNARD','2010-04-22','Vernon','','1930&#039;s','298','298.jpg'),(95,'The C.B. Lefroy farm, next to Swan Lake.','LEFROY','2010-04-20','Vernon','','1900','313','313.jpg'),(96,'View of the destruction of the Vernon Powerhouse, taken after the accident in which the flywheel on the diesel engine broke free of its moorings.','POWER HOUSE','2010-04-20','Vernon','','1923','330','330.jpg'),(97,'Line of cars leading to the ski jump hill near Kin Racetrack in Vernon with the Grey Canal in the background.','SKI, GREY CANAL, RACE TRACK, AUTOS','2010-04-22','Vernon','','1929','371','371.jpg'),(98,'White Valley Power &amp; Irrigation Co. working on the Grey Canal near Vernon.','GREY CANAL','2010-04-22','Vernon','','1908','391','391.jpg'),(99,'Vernon May Queens and Princesses. Left to right: Muriel Dahl, Marian Edwards, Ada Doherty, Muriel Butchart, Helen Cochrane and Margaret Ormsby.','MAY DAY, ORMSBY, COCHRANE, BUTCHART, DOHERTY, EDWARDS, DAHL','2010-04-22','Vernon','','1922','395','395.jpg'),(100,'Group photo of students and teachers in front of the Vernon Park School.','SCHOOL','2010-04-22','Vernon','S.A. Smythe, Vancouver BC','1896','441','441.jpg'),(101,'Vernon\'s Cenotaph Square.','CENOTAPH','2010-04-20','Vernon','BC Printing & Lithograph Ltd, Vancouver','1925','461','461.jpg'),(102,'View of the Okanagan Mounted Rifles, B Squadron’s first cavalry training camp at Okanagan Lake.','MILITARY, OKANAGAN LAKE','2010-04-27','Vernon','Vernon Photo Co.','1909','471','471.jpg'),(103,'Aerial view of the tents set up during training at Camp Vernon.','AERIAL, MILITARY','2010-04-27','Vernon','Douglas Kermode','1940','481','481.jpg'),(104,'Formal portrait of S.C. Smith, one of Vernon&#039;s first city council aldermen.','SMITH, CIVIC','2010-04-22','Vernon','G.E. Whiten','1905','506','506.jpg'),(105,'Interior view of the Bank of Montreal living quarters which were found above the bank.  Sitting in the room left to right are: G.A. Henderson (manager), C. Dudley Keating and W.L. Germaine (accountant).','BANK, HENDERSON, KEATING, GERMAINE','2010-04-20','Vernon','Holliday Portrait & Landscape Photographer','1890\'s','507','507.jpg'),(106,'Aerial view of Vernon taken looking north towards Swan Lake.','SWAN LAKE, AERIAL','2010-04-20','Vernon','','1968','527','527.jpg'),(107,'Cowboy Ken Little with Mr. and Mrs. Ted Dixon dressed up for Vernon Days celebrations.','VERNON DAYS, LITTLE, DIXON','2010-04-20','Vernon','Kermode\\\'s Studio','1939','543','543.jpg'),(108,'The Vernon Post Office at 3001 -30 Avenue.','POST OFFICE','2010-04-20','Vernon','','1912','616','616.jpg'),(109,'Horse and jockey hitting the finish line during a trotters&#039; race at Kin Race Track.','RACE TRACK, SPORTS','2010-04-22','Vernon','','1902','627','627.jpg'),(110,'Mutual Fruit Co. packing house located on the 2800 block of 32 Avenue.','PACKING','2010-04-20','Vernon','','1925-1930','691','691.jpg'),(111,'Joe Harwood Livery Express barn with teamsters and children standing in front. The children in the hayloft are: left to right: Fred Harwood, Albert Harwood, Henry Harwood and Charley Harwood.  ','HARWOOD','2010-04-20','Vernon','Le Blond, Vernon','1905','692','692.jpg'),(112,'The Polson Park bandstand.','POLSON, BAND','2010-04-27','Vernon','','1912','708','708.jpg'),(113,'Interior view of Nolan\'s Drugs drug store located at 3001 Barnard Avenue.','NOLAN, STORE','2010-04-20','Vernon','','1945','802','802.jpg'),(114,'Lord Aberdeen with family, friends and colleagues while visiting in Victoria.  Left to right: Col. James Baker, Lord Aberdeen, Marjorie Aberdeen, Archie Aberdeen, Lady Aberdeen, Lt. Gov. Edgar Dewdney, Mrs. Baker, Mrs. Dewdney, Miss Allison (Dewdney&#039;s aide-de-camp) and F.G. Vernon.','ABERDEEN, BAKER, DEWDNEY, ALLISON, VERNON','2010-04-22','Victoria','E.J.Eyres, Imperial Art Studio, Victoria','1894','809','809.jpg'),(115,'Photo of the Jacques family standing in front of tents while camping at Kalamalka beach.','JACQUES, KALAMALKA LAKE','2010-04-22','Vernon','Holliday Photo  Vernon','1890&#039;s','1071','1071.jpg'),(116,'Interior view of Dick Taylor’s Drug Store, Vernon.','STORE, TAYLOR','2010-04-22','Vernon','Holliday Photo  Vernon','1890','1074','1074.jpg'),(117,'Exterior view of Cameron’s General Store in Vernon.','STORE, CAMERON','2010-04-20','Vernon','','1895','1075','1075.jpg'),(118,'A group of men standing on the front walk of Vernon&#039;s first Hudson&#039;s Bay Co. store.','STORE, HBC','2010-04-22','Vernon','','1887','1103','1103.jpg'),(119,'Aerial view of the Civic Centre complex site just after completion.','CIVIC, AERIAL','2010-04-22','Vernon','Kermode&#039;s Studio','1965','1132','1132.jpg'),(120,'Aerial view of the businesses at the east end of Vernon&#039;s main street.','AERIAL, VERNON','2010-04-22','Vernon','Doug Kermode','1930’s','1133','1133.jpg'),(121,'Vernon Winter Carnival chairman George Melvin presenting the silver plate and trophy to the first Queen Silver Star Rhondda Oliver.','MELVIN, OLIVER, CARNIVAL','2010-04-27','Vernon','Kermode&#039;s Studio','1961','1143','1143.jpg'),(122,'View from the water of the SS Aberdeen sternwheeler as it is being launched onto Okanagan Lake.','BOAT, OKANAGAN LAKE','2010-04-22','Vernon','A.D. Worgan','1893','1165','1165.jpg'),(123,'The interior view of a soda water factory in Vernon.  It is most likely M.J. O’brien’s.','STORE','2010-04-22','Vernon','','1900','1170','1170.jpg'),(124,'Children playing in the schoolyard of the Vernon Public School.','SCHOOL','2010-04-22','Vernon','Vernon Photo Co','1910','1218','1218.jpg'),(125,'Group photo of the students who rode the first Okanagan Landing school bus.','SCHOOL','2010-04-20','Vernon','','1924','1239','1239.jpg'),(126,'Front view of the IXL Service Station located at 2801-32 Street, Vernon.','GARAGE','2010-04-29','Vernon','Salt Photo','1925','1287','1287.jpg'),(127,'Kids diving off of the diving platform and pier at the Kalamalka Lake beach wharf.','KALAMALKA LAKE','2010-04-20','Coldstream','','1970','1292','1292.jpg'),(128,'Edward Walton and Dave McKay overseeing the irrigation system using treated effluent on the fields in the Commonage.','WALTON, MCKAY, COMMONAGE','2010-04-20','Vernon','','1970','1296','1296.jpg'),(129,'The Vernon Scout Hall located at the corner of 28 Avenue and 30 Street.','SCOUTS','2010-04-22','Vernon','','1926','1337','1337.jpg'),(130,'Formal portrait of the Kwong family of Vernon. Left to right: Mrs. Kwong, Harry Kwong and Mr. Kwong holding Bertha Kwong.','KWONG, CHINATOWN','2010-04-22','Vernon','','1902','1362','1362.jpg'),(131,'Motorcycles parked in front of the Megaw Motor Co. and Megaw Motorcycle Shop. The shop was located in the 3300 block of Barnard Avenue (30th Avenue).','MEGAW, STORE, BARNARD','2010-04-22','Vernon','','1915','1379','1379.jpg'),(132,'Flooding near the 3200 block on Barnard Avenue (30th Avenue).  In the foreground are a stack of drainpipes awaiting installment.','BARNARD','2010-04-22','Vernon','','1906','1431','1431.jpg'),(133,'Front exterior view of the Dreamland Theatre in Vernon, with movie posters and placards on display.','THEATRE, MOVIE','2010-04-22','Vernon','','1911','1497','1497.jpg'),(134,'The front exterior view of Luc Girouard&#039;s cabin on Old Kamloops Road. This cabin was used as the first post office in Vernon.','POST OFFICE, GIROUARD','2010-04-22','Vernon','','1920','1505','1505.jpg'),(135,'Formal portrait of Marion and Joe Harwood.  Mr. Harwood was a drayman and school trustee in Vernon.','HARWOOD','2010-04-22','Vernon','','1915','1520','1520.jpg'),(136,'Three men and a horse-drawn sled cutting up ice blocks from Swan Lake.','SWAN LAKE','2010-04-22','Vernon','Hood Stationery Co.','1915','1527','1527.jpg'),(137,'Red Cross nurses manning a Red Cross membership drive table in front of the Hudson’s Bay store.','HBC, HOSPITAL, MILITARY','2010-04-27','Vernon','','1915','1552','1552.jpg'),(138,'Old truck used by the Vernon Junior Board of Trade as a float to promote the buying of war savings certificates during WW II.','FLOAT, WWII','2010-04-20','Vernon','Douglas Kermode','1940','1625','1625.jpg'),(139,'Front view of the Vernon Garage at night.   The garage was located at 2907 - 32 Street.','GARAGE','2010-04-20','Vernon','Le Blond','1926','1653','1653.jpg'),(140,'The front entrance to the Vernon Empress Theatre which was located at 3207-30 Avenue.  Out front are various movie and theatre posters, placards, a stuffed bear, and an elk head.','THEATRE, MOVIE','2010-04-22','Vernon','','1931','1666','1666.jpg'),(141,'Chinatown Fire.','FIRE, CHINATOWN','2010-04-20','Vernon','','1978','1727','1727.jpg'),(142,'Jack Monk waving good-bye to the SS Sicamous sternwheeler as it is towed from Okanagan Landing on its last voyage down Okanagan Lake.','SS, OKANAGAN LAKE, MONK','2010-04-20','Vernon','Kermode\'s Studio','1951','1751','1751.jpg'),(143,'Shuswap women racing down the Shuswap River near Enderby in their hand carved dugout canoes.','ENDERBY, NATIVE','2010-04-22','Enderby','Merlin Dunwoodie','1908','1753','1753.jpg'),(144,'Interior view of the Vernon power house showing the turbines.','POWER HOUSE','2010-04-20','Vernon','','1920','1782','1782.jpg'),(145,'SS Sicamous sternwheeler stuck in the ice at Okanagan Landing.','BOAT, OKANAGAN LANDING','2010-04-22','Okanagan Landing','','1916','1839','1839.jpg'),(146,'Vernon High School girls basketball team with Anna Cail as their coach.','VHS, CAIL, SPORTS','2010-04-20','Vernon','','1937','2021','2021.jpg'),(147,'View of Vernon looking west from East Hill down 30th Avenue.','VERNON','2010-04-27','Vernon','S.A.Smythe, Vancouver','1897','2053','2053.jpg'),(148,'The troops at Camp Vernon training for trench warfare.','MILITARY','2010-04-27','Vernon','Harold Smith, Military Photographer','1916','2065','2065.jpg'),(149,'Passengers about to take a day excursion up Kalamalka Lake, standing on and around the Johnston &amp; Carswell&#039;s SS City of Vernon launch.','BOAT, KALAMALKA LAKE','2010-04-27','Coldstream','','1910','2139','2139.jpg'),(150,'Portrait of the graduating class of the Vernon Jubilee Hospital nurses school.','HOSPITAL','2010-04-27','Vernon','F. and M. Salt, Vernon','1926','2207','2207.jpg'),(155,'Aerial view of the north end of Kalamalka Lake.','KALAMALKA LAKE, AERIAL','2010-04-20','Coldstream','Le Blond','1970&#039;s','2274','2274.jpg'),(156,'Aerial view of the intersection of Kal Lake Road and Hwy 6 where the Polson Park Mall is under construction.','AERIAL, POLSON','2010-04-27','Vernon','Le Blond','1974','2281','2281.jpg'),(157,'Aerial view of Hwy 97 with the Village Green Mall construction site.','AERIAL','2010-04-20','Vernon','Le Blond','1974','2285','2285.jpg'),(158,'Justice Court Park with the Vernon Court House in the background.','COURT HOUSE','2010-04-20','Vernon','','1975','2369','2369.jpg'),(159,'Members of the Oddfellows and Rebekah Lodge parading down Barnard Avenue accompanied by the Salvation Army Band and the silent policeman.','PARADE, SERVICE CLUB, BARNARD, BAND','2010-04-22','Vernon','F. and M. Salt, Vernon','1915','2435','2435.jpg'),(160,'Formal portrait of Joe Moses, Chief Spallumcheen, dressed in his native regalia.','NATIVE, MOSES','2010-04-20','Spallumcheen','','1890','2479','2479.jpg'),(161,'View of the slalom ski course on the east side of the Commonage.','SKI, COMMONAGE','2010-04-20','Vernon','','1939','2482','2482.jpg'),(162,'Vernon Asylum located in MacDonald Park.','ASYLUM','2010-04-22','Vernon','Schofield','1912','2639','2639.jpg'),(163,'Boy Scouts parading near Polson Park grandstand.','SCOUTS, POLSON','2010-04-27','Vernon','','1935','2643','2643.jpg'),(164,'Exterior view of the ruins of an Interior Salish Kekuli. Probably built by the Thompson people.','NATIVE','2010-04-20','Kamloops','','1900','2715','2715.jpg'),(165,'View of Vernon&#039;s Chinatown businesses, located on 28 Avenue looking east. Some of the businesses shown include: Kwong Hing Chong Co.; Kwong Yuen Chong Co.; Wing Wah Lung. ','CHINATOWN, KWONG','2010-04-22','Vernon','','1907','2766','2766.jpg'),(167,'View of the SS Okanagan sternwheeler docked at the Okanagan Landing wharf.  Decorated for Lord and Lady Bing&#039;s reception.','BOAT, OKANAGAN LANDING, ROYALTY','2010-04-22','Okanagan Landing','','1910','2803','2803.jpg'),(168,'Side view of the SS Naramata tugboat passing the pilings at Okanagan Landing.','BOAT, OKANAGAN LANDING','2010-04-27','Okanagan Landing','','1975','2806','2806.jpg'),(169,'Aerial view of Camp Vernon.','AERIAL, MILITARY','2010-04-27','Vernon','Doug Kermode','1965','2812','2812.jpg'),(170,'Staff of the Shuswap Okanagan Diary Industries Co-op Association.','DAIRY','2010-04-27','Vernon','','1950','2863','2863.jpg'),(171,'Front exterior view of the Vernon Creamery building.','DAIRY','2010-04-22','Vernon','','1921','2867','2867.jpg'),(172,'Barnard Avenue under re-construction.','BARNARD','2010-04-20','Vernon','Viel&#039;s Sports Centre','1950','2870','2870.jpg'),(173,'Staff members of the Canadian battle drill training school that took place at the Coldstream Ranch.','COLDSTREAM, SCHOOL, MILITARY','2010-04-27','Coldstream','','1943','2951','2951.jpg'),(174,'&#039;Soldiers of the Soil&#039; boys helping out in the Vernon Fruit Union packing house.','PACKING, VFU','2010-04-20','Vernon','','1915','2958','2958.jpg'),(175,'Queen Elizabeth and Prince Philip in Vernon.','ROYALTY','2010-04-20','Vernon','William Brown','1959','2966','2966.jpg'),(176,'Members of the 2nd Canadian Mounted Rifles washing dishes after meal time at Camp Vernon.','MILITARY','2010-04-27','Vernon','Harold Smith, Military Photographer','1916','3014','3014.jpg'),(177,'Portrait of (Eyes Left) &#039;Jack&#039; the crow, mascot of the 172nd battalion Rocky Mountain Rangers.','MILITARY','2010-04-27','Vernon','Harold Smith, Military Photographer','1916','3053','3053.jpg'),(178,'Vernon Courthouse.','COURT HOUSE','2010-04-22','Vernon','Vernon Photo Co.','1914','3056','3056.jpg'),(179,'Exterior view of the Vernon Fruit Union packinghouse.','VFU, PACKING','2010-04-27','Vernon','Le Blond Studio','1931','3093','.jpg'),(180,'Formal portrait of Samuel Polson.','POLSON','2010-04-20','Vernon','','1912','3113','3113.jpg'),(181,'Interior view of the Vernon Fruit Union packinghouse, showing the fruit packers working at the assembly line.','VFU, PACKING','2010-04-20','Vernon','','1930&#039;s','3137','3137.jpg'),(182,'View of the Carswell and Johnston&#039;s sawmill located on the shores of Kalamalka Lake.','KALAMALKA LAKE, LOGGING','2010-04-22','Coldstream','G.H.E. Hudson','1905','3183','3183.jpg'),(183,'View of Cosen&#039;s Bay on Long Lake (Kalamalka Lake).','KALAMALKA LAKE','2010-04-20','Coldstream','Holliday Photo  Vernon','1895','3184','3184.jpg'),(184,'View of the buildings and grounds at the Vernon Spring Brewery.','BREWERY','2010-04-20','Vernon','A.D. Worgan, The Aberdeen Studio','1895','3190','3190.jpg'),(185,'Vernon vs the Yorkton Terriers in the Allen Cup hockey tournament.','HOCKEY, SPORTS','2010-04-27','Vernon','','1950&#039;s','3199','3199.jpg'),(186,'View of the businesses on Barnard Avenue.','BARNARD','2010-04-20','Vernon','Walter,W.H. - Interior Photos','1960','3210','3210.jpg'),(187,'Jockeys at Kin Racetrack during Vernon Days.','RACE TRACK, VERNON DAYS, SPORTS','2010-04-22','Vernon','','1935','3228','3228.jpg'),(188,'A group of men loading a wagon full of army supplies onto the SS Aberdeen, while docked at Okanagan Landing.','BOAT, OKANAGAN LANDING','2010-04-27','Okanagan Landing','','1915','3247','3247.jpg'),(189,'Soldiers from the Canadian Army Battle School storming a hill during training at the Coldstream Ranch.','MILITARY, COLDSTREAM, SCHOOL','2010-04-27','Coldstream','Canadian Army Photo','1943','3317','3317.jpg'),(190,'Members of the Vernon Riding Club out on a fox hunt. Identified are: Jock Cameron (centre); Bert Ellison (second whip); Tommy Wilmot (Master of Hounds); and Jack Stamer (first whip).','HORSES, CLUB, ELLISON, WILMOT, CAMERON, STAMER','2010-04-22','Vernon','','1935','3348','3348.jpg'),(191,'Interior of Campbell&#039;s Bros. Furniture Store.','STORE, CAMPBELL','2010-04-20','Vernon','','1912','3367','3367.jpg'),(192,'Front exterior view of the Coldstream Hotel.','HOTEL','2010-04-20','Vernon','Vernon Photo Co.-Schofield','1915','3415','3415.jpg'),(193,'Interior view of Jacques Jewellers, with proprietor F.B. Jacques at the counter. Located in the 3100 block of Barnard Avenue (30th Avenue).','STORE, JACQUES, BARNARD','2010-04-22','Vernon','','1907','3429','3429.jpg'),(194,'Three men standing in the front entrance of the newly constructed Vernon News building','VERNON NEWS','2010-04-22','Vernon','','1894','3432','3432.jpg'),(195,'The Vernon May Day Queens and their attendants standing in front of the Minty coach.','MAY DAY','2010-04-20','Vernon','Douglas Kermode','1941','3437','3437.jpg'),(196,'Front exterior view of the newly completed Vernon Jubilee Hospital.','HOSPITAL,','2010-04-27','Vernon','','1909','3443','3443.jpg'),(197,'Theatre production of &#039;Sentimental Sally&#039;.','THEATRE','2010-04-22','Vernon','Le Blond','1934','3446','3446.jpg'),(198,'Front view of the the arched entrance and banner announcing the annual Vernon Industrial Exposition.','EXPOSITION','2010-04-20','Vernon','Kermode&#039;s Studio','1949','3466','3466.jpg'),(199,'Three horse-drawn ploughs breaking up a field on Coldstream Ranch.','FARM, COLDSTREAM ','2010-04-27','Coldstream','A.D. Worgan The Aberdeen Studio','1895','3484','3484.jpg'),(200,'View of the 3400 block of Barnard  Avenue (30th Avenue). Some of the businesses shown include: Glovers&#039;s Hardware; Vernon Photo Co.; Post Office; Campbell House and Megaw&#039;s Store.','BARNARD, MEGAW, CAMPBELL, GLOVER, STORE','2010-04-20','Vernon','Schofield/Vernon Photo Co','1912','3497','3497.jpg'),(201,'Men in an orchard, spraying the trees with pesticides with old wand sprayers.','ORCHARD','2010-04-20','Vernon','','1910','3508','3508.jpg'),(202,'Two men standing in front of the main O&#039;Keefe ranch house.','O&#039;KEEFE, FARM','2010-04-27','Spallumcheen','','1890','3518','3518.jpg'),(203,'View of the crowds enjoying the music and speeches at the Vernon Centennial celebrations ceremony held in Polson Park.','POLSON, CENTENNIAL','2010-04-27','Vernon','Le Blond','1967','3532','3532.jpg'),(204,'Group photo of sawmill crew at Smith Sawmill in Vernon.  ','SMITH, LOGGING','2010-04-27','Vernon','C.W. Holliday, portrait and landscape photographer','1895','3540','3540.jpg'),(205,'Close up of the Vernon army camp cadets doing a march past while on parade.','PARADE, MILITARY','2010-04-27','Vernon','Le Blond','1960','3555','3555.jpg'),(206,'View of S.C. Smith&#039;s sawmill, sash and door factory, and  the Vernon Flour Mill.  The jam factory is to the left of the flour mill.','SMITH, LOGGING','2010-04-27','Vernon','Schofield-Vernon Photo Co','1912','3581','3581.jpg'),(207,'The S.C. Smith House.','SMITH, HOUSE','2010-04-20','Vernon','Vernon Photo Co','1910','3587','3587.jpg'),(208,'Group photo of members of the Vernon Fire Department, winners of the Hub &amp; Hub 100 yard dash and wet test.','VFD','2010-04-20','Vernon','','1895','3622','3622.jpg'),(209,'Front exterior view of the Vernon Hotel and the Hotel Vernon.','HOTEL','2010-04-20','Vernon','Schofield-Vernon Photo Co.','1910','3624','3624.jpg'),(210,'Front exterior view of the newly constructed Vernon Central School.','SCHOOL','2010-04-22','Vernon','','1909','3629','3629.jpg'),(211,'The Internment Camp at MacDonald Park.','CAMP, INTERNMENT','2010-04-20','Vernon','','1916','3698','3698.jpg'),(212,'Formal portrait of W.R. Megaw.  Megaw was mayor of Vernon from 1900-1901.','MEGAW, CIVIC','2010-04-22','Vernon','','1899','3723','3723.jpg'),(213,'Interior view of Nick&#039;s Candy Kitchen, located at 3017-30th Avenue, Vernon.','STORE, NICK&#039;S','2010-04-20','Vernon','','1948','3774','3774.jpg'),(214,'Crowds helping sift through the ruins of the Okanagan Hotel after it was destroyed by fire.','HOTEL, FIRE','2010-04-22','Vernon','','1909','3788','3788.jpg'),(215,'Group photo of the members of the Vernon hockey team &#039;76 Gasoline&#039;.','HOCKEY, SPORTS','2010-04-22','Vernon','Le Blond','1934','3814','3814.jpg'),(216,'Formal portrait of F.J. Barnard, one of the &quot;builders of British Columbia&quot;.','BARNARD','2010-04-20','Vernon','','1885','3820','3820.jpg'),(217,'Four men beside the skeleton of the single engine airplane &#039;City of Vernon&#039; under construction above the Kal Lake Store.  Left to right: Ernie Buffum; Jack Taylor; Jim Duddle and Eldon Seymour.\r\n','AIRPLANE, DUDDLE, SEYMOUR, BUFFUM, TAYLOR','2010-04-22','Vernon','','1934','3831','3831.jpg'),(219,'A passenger train at the Vernon CPR station.  In the background is the Opera House, Mason Street School and the Megaw&#039;s warehouse.','CPR, STATION, SCHOOL, MEGAW, THEATRE','2010-04-22','Vernon','','1905','3846','3846.jpg'),(220,'Four Bren gun carriers training at Camp Vernon.','MILITARY','2010-04-27','Vernon','','1942','3871','3871.jpg'),(221,'Female postal workers, and their male supervisors, at work in the Vernon Post Office.','POST OFFICE','2010-04-21','Vernon','','1915','3885','3885.jpg'),(222,'View of a Vernon hotel fire. ','HOTEL, FIRE','2010-04-21','Vernon','','1950','3943','3943.jpg'),(223,'The Civic Arena  at 3003-37 Avenue.','ARENA','2010-04-21','Vernon','Le Blond Photo','1960','3952','3952.jpg'),(224,'The O&#039;Keefe, McDonnell and O&#039;Neal children on a raft at Kalamalka Lake. Left to right: Alice O&#039;Neal, Sam O&#039;Neal, Lawrence McDonnell, Betty O&#039;Neal, Margaret O&#039;Keefe, Leslie McDonnell, Genie O&#039;Neal, Tierney O&#039;Keefe and Geraldine O&#039;Neal.','O&#039;NEAL, O&#039;KEEFE, MCDONNELL, KALAMALKA LAKE','2010-04-21','Coldstream','','1915','3965','3965.jpg'),(225,'The front exterior view of the Vernon court house while under construction. ','COURT HOUSE','2010-04-21','Vernon','','1912','4058','4058.jpg'),(226,'Two young ladies posing beside a car used at the Shillam&#039;s Garage Dodge display at the 1949 Industrial Exposition.','GARAGE, SHILLAM','2010-04-21','Vernon','Kermode&#039;s Studio','1949','4114','4114.jpg'),(227,'Members of a Vernon baseball team. Back row left to right: Felix Henschke (centre field); Louie Nuyens (spare); George Jones (spare); Elmer Block (pitcher); T. Van Antwerp (left field); Jack Burrows (short stop catcher); Bill Wilson (short stop pitcher); Lyle Seaton (catcher right field); Joe Atkinson (first base); Jack Stainton (relief catcher)\r\nFront left to right: Mr. Mitcheltree; Fred Brown; Dr. Hamilton (President).','SPORTS','2010-04-22','Vernon','','1923','4123','4123.jpg'),(228,'Front exterior view of the W.R. Megaw house located at 3203 - Pleasant Valley Road.  Standing out front are left to right: Mrs. Proctor (sister of Mrs. Megaw), William Earle, Albert Proctor, Irene Megaw, Mrs. Megaw.','MEGAW, HOUSE','2010-04-21','Vernon','','1900','4328','4328.jpg'),(229,'Four men and a horse team acting as a road crew building the Vernon-Mission near Oyama.','OYAMA','2010-04-22','Oyama','','1911','4353','4353.jpg'),(230,'The members of the SS Aberdeen sternwheeler crew. Taken on board the Aberdeen.  Identified is George Verey (second from the right).','VEREY, BOAT, OKANAGAN LAKE','2010-04-22','Vernon','','1902','4403','4403.jpg'),(231,'View of the the dining room of the SS Sicamous sternwheeler. Taken from the upper deck looking down.','BOAT','2010-04-22','Vernon','','1934','4406','4406.jpg'),(232,'Bow view of the SS Kelowna and the SS Naramata tugs, docked side by side at the Kelowna wharf.','BOAT, KELOWNA','2010-04-22','Kelowna','','1934','4408','4408.jpg'),(233,'Stern view of the SS Sicamous sternwheeler on the ways at Okanagan Landing, just before her launch in 1914.  The Strand Hotel is in background.','BOAT, OKANAGAN LANDING, HOTEL','2010-04-22','Okanagan Landing','','1914','4420','4420.jpg'),(234,'View of the crowds enjoying the Diamond Jubilee celebrations.','JUBILEE','2010-04-22','Vernon','S.A. Smythe, Vancouver','1897','4444','4444.jpg'),(235,'A group of men standing outside the Okanagan Telephone building located on 32 Street.','TELEPHONE','2010-04-21','Vernon','G.E. Whiten','1910','4546','4546.jpg'),(236,'Front view of the completed &#039;City of Vernon&#039; single engine airplane, constructed by Jim Duddle and Eldon Seymour.','AIRPLANE, DUDDLE, SEYMOUR','2010-04-22','Vernon','','1937','4565','4565.jpg'),(237,'View of the ways at Okanagan Landing where a barge is under construction,  Docked at the wharf is the SS Sicamous, the SS Okanagan, and the SS Kelowna. In the background is the Strand Hotel.','BOAT, HOTEL, OKANAGAN LANDING','2010-04-22','Okanagan Landing','','1925','4664','4664.jpg'),(238,'Four women in the dining room of the Kalamalka Hotel.','HOTEL','2010-04-22','Vernon','','1914','4703','4703.jpg'),(239,'Photo of the Kal Hotel Chinese kitchen staff.','HOTEL','2010-04-27','Vernon','','1914','4704','4704.jpg'),(240,'Two men checking in at the Kal Hotel reception/lobby. Behind is the bellhop with luggage.','HOTEL','2010-04-27','Vernon','','1914','4706','4706.jpg'),(241,'Two horse drawn carriages sitting in front of the Campbell house,   In the first carriage are Mabel and Madge Dickson.  In the second carriage are Anna and Frank Dickson.','CAMPBELL, DICKSON, HOUSE','2010-04-27','Vernon','','1910','4716','4716.jpg'),(242,'Two native men showing off their day&#039;s fish catch on Okanagan Lake.','NATIVE, OKANAGAN LAKE','2010-04-27','Okanagan Lake','','1895','4721','4721.jpg'),(243,'Group photo of the members of Price Ellison&#039;s threshing crew with threshing machinery, working out at the Simpson Ranch.','FARM, ELLISON, SIMPSON','2010-04-27','Vernon','','1900','4722','4722.jpg'),(244,'Boys from the Vernon Preparatory School on the parallel bars in the school gymnasium.','SCHOOL, COLDSTREAM','2010-04-27','Coldstream','','1920','4741','4741.jpg'),(245,'Back exterior view of the nurses&#039; residence in Vernon.','HOSPITAL','2010-04-27','Vernon','','1925','4754','4754.jpg'),(246,'Front exterior view of the newly constructed Vernon High School. By 1970, the school was known as Clarence Fulton Junior Secondary School.','SCHOOL','2010-04-27','Vernon','Doug Kermode','1938','5006','5006.jpg'),(247,'Aerial view of logging trucks in procession down 30 Avenue in front of the Kalamalka Hotel, Allison Hotel and Capitol Motors during National Forest Products Week.','AERIAL, HOTEL, LOGGING, BARNARD','2010-04-27','Vernon','Doug Kermode','1965','5013','5013.jpg'),(248,'Group of cowboys on horses out rounding up cattle.','HORSES, FARM','2010-04-27','North Okanagan','S.A. Smythe, Vancouver','1888','5021','5021.jpg'),(249,'Men with horses in front of Neil &amp; Wilson&#039;s Okanagan Livery, Feed &amp; Sale Stable.','NEIL, WILSON, STORE','2010-04-27','Vernon','','1896','5026','5026.jpg'),(250,'View of a Coldstream orchard in summer.','COLDSTREAM, ORCHARD','2010-04-27','Coldstream','S.A. Smythe','1900','5029','5029.jpg'),(251,'Portrait of Cornelius O&#039;Keefe.','O&#039;KEEFE','2010-04-27','Vernon','','1895','5042','5042.jpg'),(252,'View of St. Michael&#039;s Girls&#039; School with the surrounding gardens.','SCHOOL','2010-04-27','Vernon','Le Blond','1925','5055','5055.jpg'),(253,'Portrait of Moses Lumby, government agent in Vernon.','LUMBY','2010-04-27','Vernon','Maynard F. MacDonald &amp; Son, Commerical Photograph','1891','5083','5083.jpg'),(254,'View of the Vernon Preparatory School, located at 8405 Aberdeen Road.  On the far right young John Mackie and Verity Grieve are sitting on the grass.','SCHOOL, MACKIE, GRIEVE, COLDSTREAM','2010-04-28','Coldstream','','1921','5129','5129.jpg'),(255,'Portrait of Forbes George Vernon. Mr. Vernon was an early settler in the Okanagan and owner of the Coldstream Ranch.  He was the Chief Commissioner of Lands for BC in 1887, MPP for the Yale district in 1875, and BC Agent-General from 1895-1898. He is the name-sake of the city of Vernon.','VERNON','2010-04-28','London, England','The VanderWeyoe Light','1895','5339','5339.jpg'),(256,'Members of the Vernon polo team playing polo.','SPORTS, HORSES','2010-04-28','Vernon','','1930','5476','5476.jpg'),(257,'View of the hop fields at Coldstream Ranch.  Three men with horse teams walking the edge of the field.','FARM, COLDSTREAM, HORSES','2010-04-28','Coldstream','','1900','5607','5607.jpg'),(258,'View of 30th Avenue, with the Royal Hotel (later named the National Hotel) and the Kalamalka Hotel.','HOTEL, BARNARD','2010-04-28','Vernon','G.H.E. Hudson','1910','5664','5664.jpg'),(259,'Lt. Gov. Woodward inspecting the troops during a parade in Vernon.  Also identified are: Col. Hamilton-Grant and Lt. Kilpatrick.','WOODWARD, HAMILTON-GRANT, KILPATRICK, MILITARY, PARADE','2010-04-28','Vernon','','1942','5684','5684.jpg'),(260,'The members of the Vernon McIntosh Girls Pipe Band posing with the Armstrong May Day Queen and her entourage. ','ARMSTRONG, MAY DAY, ROYALTY, BAND','2010-04-28','Armstrong','Kermode&#039;s Studio','1950','5717','5717.jpg'),(261,'Vernon crowds enjoying the midway of the visiting Barnum &amp; Bailey circus.  A snake charmer is in the centre.','CIRCUS','2010-04-28','Vernon','Doug Kermode','1938','5743','5743.jpg'),(262,'View of the buildings which make up the Vernon civic centre complex, take from across the street.  Behind the fountain is the City Hall and police station.  To the left is the museum and library.','CIVIC, MUSEUM','2010-04-28','Vernon','','1970','5762','5762.jpg'),(263,'Aerial photo of the Vernon Sewage Treatment Plant, taken looking northeast.','AERIAL, VERNON, CIVIC','2010-04-29','','','1974','5862','5862.jpg'),(264,'Polson Park&#039;s Floral Clock.','POLSON','2010-04-29','Vernon','Doug Kermode','1969','5925','5925.jpg'),(265,'Aerial photo of the buildings and grounds of the Coldstream Ranch, with the packinghouse in the foreground.','AERIAL, COLDSTREAM, FARM','2010-04-29','Coldstream','','1970','5949','5949.jpg'),(266,'Front exterior view of the Vernon Junior High School (later known at Seaton) located on 41 Avenue. Taken just before it was officially opened.','SCHOOL','2010-04-29','Vernon','Le Blond Studio','1950','5960','5960.jpg'),(267,'Aerial photo of the Coldstream orchards in bloom on the east shores of Kalamalka Lake.','COLDSTREAM, ORCHARD','2010-04-29','Coldstream','Doug Kermode','1950','5975','5975.jpg'),(268,'Aerial view of the Coldstream valley and orchards, taken looking east over the area which is now known as Summertree.','AERIAL, COLDSTREAM','2010-04-29','Coldstream','Doug Kermode','1965','5979','5979.jpg'),(269,'A young woman on a ladder picking apples from the top branches of a local apple tree.','ORCHARD','2010-04-29','Vernon','Doug Kermode','1950','5998','5998.jpg'),(270,'Skiers at a cabin enjoying a day of skiing on Silver Star mountain.','SKI, SILVER STAR','2010-04-29','Vernon','','1938','6007','6007.jpg'),(271,'Interior view of the Vernon Court House with a ceremony in session.  Judge Charles Morrow presiding.','COURT HOUSE, MORROW','2010-05-04','Vernon','Doug Kermode','1956','6069','6069.jpg'),(272,'Aerial photo of the ski runs at the Tillicum Valley ski resort near Vernon.  Also Tillicum Raceway.','AERIAL, SKI, RACE TRACK','2010-05-04','Vernon','Doug Kermode','1972','6147','6147.jpg'),(273,'Men, women and children camping on the shores of Kalamalka Lake.','KALAMALKA LAKE','2010-05-04','Vernon','','1900','6407','6407.jpg'),(274,'Six men enjoying a drink at the Vimy Ridge Bar in the Kalamalka Hotel. The hotel was located at 3300 - 30 Avenue.','HOTEL','2010-05-04','Vernon','','1921','6481','6481.jpg'),(275,'Two men standing at the Coldstream Hotel bar.','HOTEL','2010-05-04','','','1944','6742','6742.jpg'),(276,'View of the cashier lanes at the new Safeway Store on Barnard Avenue (30th Avenue) on opening day.','STORE','2010-05-04','Vernon','','1951','6766','6766.jpg'),(277,'View of the Vernon Steam Laundry &amp; Dry Cleaners building, taken from across the street.','STORE','2010-05-04','Vernon','','1940','6999','6999.jpg'),(278,'Fire Brigade band playing for the crowd at the Pleasant Valley Cemetery during a funeral.','BAND','2010-05-04','Vernon','','1910','7812','7812.jpg'),(279,'View of the town site of Vernon. Taken looking southeast.','VERNON','2010-05-04','Vernon','','1888','7821','7821.jpg'),(280,'View down the main work aisle of the Bulman&#039;s Cannery showing the female workers peeling and packing tomatoes.','CANNERY','2010-05-04','Vernon','Interior Photos','1942','7972','7972.jpg'),(281,'Photo postcard showing a crowd of people surrounding the plane flown by Captain Hoy while he stopped at the Vernon Airport during his historic first flight from Vancouver to Calgary.','HOY, AIRPLANE, AIRPORT','2010-05-04','Vernon','','1910','7974','7974.jpg'),(282,'Cast members who played in the production of &#039;The Geisha&#039;, at Vernon&#039;s Empress Theatre.  Left to right: Frances Turner; Winnifred Beattie; Roland Weir; Betty Mickleborough; Gladys Bailey; Hamilton Lang; Ed Byers; Violet Schmitz and Eric Dunn.','THEATRE, BAILEY','2010-05-04','Vernon','','1913','8665','8665.jpg'),(283,'Group of nurses on the front porch of Vernon&#039;s first cottage hospital.','HOSPITAL, NURSES','2010-05-04','Vernon','','1908','8696','8696.jpg'),(284,'Back exterior view of the Vernon Jubilee Hospital.','HOSPITAL','2010-05-04','Vernon','','1911','8699','8699.jpg'),(285,'A group of people in front of the SS Sicamous, sternwheeler. Left to right: Sarah Berry; Jean Megaw; Elizabeth Fleming; Madelaine Megaw; Betty Jane Fleming &amp; Stuart Fleming.','BOAT, MEGAW, FLEMING','2010-05-04','Vernon','','1926','8737','8737.jpg'),(286,'Group of men and women picking apples in one of the Coldstream Ranch orchards.  ','COLDSTREAM, ORCHARD','2010-05-04','Coldstream','Le Blond','1918','8746','8746.jpg'),(287,'View of three boats full of harvested milfoil weed from Okanagan Lake.','BOAT, OKANAGAN LAKE','2010-05-04','Vernon','Vernon Daily News','1975','8807','8807.jpg'),(288,'View of the demolition of the original Hudson&#039;s Bay Co. building on Barnard Avenue (30th Avenue).  Taken from above looking east along Barnard Ave.','HBC','2010-05-04','Vernon','Vernon Daily News','1976','8837','8837.jpg'),(289,'The 1978 high school graduates spray painting their &quot;mark&quot; along Suicide Hill of 30 Avenue.','SCHOOL','2010-05-04','Vernon','Vernon Daily News','1978','8884','8884.jpg'),(290,'Aerial view of the planes parked between the runway and outbuildings at the Vernon airport near Okanagan Landing.','AERIAL, AIRPORT, AIRPLANE, OKANAGAN LANDING','2010-05-04','Vernon','Vernon Daily News','1981','8929','8929.jpg'),(291,'Aerial view of the Polson Park oval filled with athletes competing in the BC Summer games held in Vernon.','POLSON, SPORTS','2010-05-04','Vernon','Al Brunet Photography','1982','8943','8943.jpg'),(292,'Side view of the horses with jockeys leaving the starting gates during a horse race at Kin Race Track.','SPORTS, RACE TRACK','2010-05-04','Vernon','Vernon Daily News','1983','8959','8959.jpg'),(293,'Eight man logging crew and their horse team taking a break from towing a large load of newly harvested logs.','LOGGING, HORSES','2010-05-04','Okanagan Valley','Vernon Daily News','1920','8976','8976.jpg'),(294,'View of the early stages of construction on the Kalamalka campus of Okanagan College.','COLLEGE','2010-05-04','Vernon','Vernon Daily News','1981','8983','8983.jpg'),(295,'View down Barnard  Avenue (30th Avenue). Taken from the north side of street looking east.','BARNARD','2010-05-04','Vernon','Vernon Daily News','1980','8984','8984.jpg'),(296,'Group photo of a family of men, women and children who were internees in the Vernon internment camp during WWI. ','INTERNMENT','2010-05-04','Vernon','','1914 to 1920','9062','9062.jpg'),(297,'Pamoramic photo of the cars and crowds at the Coldstream Ranch during the Duke of Connaught&#039;s visit.  In the foreground are the Nez Perce pickers in full regalia.','NATIVE, COLDSTREAM, ROYALTY','2010-05-04','Coldstream','G.H.E. Hudson','1912','9064','9064.jpg'),(298,'Crowds watching a convoy of elephant-drawn carts from the Sells-Floto Circus arriving in Vernon.','CIRCUS','2010-05-04','Vernon','','1938','9091','9091.jpg'),(299,'Five young men lazing on the sand at their &quot;San Souci&quot; summer camp at Husband&#039;s Point on the west side of Kalamalka Lake.','KALAMALKA LAKE','2010-05-04','Coldstream','Harold Smith, Vancouver','1912','9111','9111.jpg'),(300,'Cowboys on their horses at Coldstream Ranch.','COLDSTREAM, FARM, HORSES','2010-05-04','Coldstream','','1910','9115','9115.jpg'),(301,'Ranch hands watering the horses at the stream in front of the Coldstream Ranch house, just before lunch time.','COLDSTREAM, FARM, HORSES','2010-05-04','Coldstream','','1910','9116','9116.jpg'),(302,'View of the Nez Perce Indians encampment at the Coldstream Ranch.','NATIVE, COLDSTREAM','2010-05-04','Coldstream','Culver','1910','9132','9132.jpg'),(303,'Members of the Nez Perce who worked as hop pickers at Coldstream Ranch. Chief in headdress at centre right is Charlie Whilpocken.','NATIVE, COLDSTREAM','2010-05-04','Coldstream','','1910','9137','9137.jpg'),(304,'Front exterior view of Vernon&#039;s first Anglican Church during the winter.','CHURCH','2010-05-04','Vernon','','1895','9151','9151.jpg'),(305,'View of Vernon looking east with wooden shacks.  Possibly 32 Street.','VERNON','2010-05-04','Vernon','','','9513','9513.jpg'),(306,'Man standing in Rock Quarry at Ellison Park.','ELLISON, QUARRY','2010-05-04','Vernon','','','9590','9590.jpg'),(307,'Interior view of Mackenzie&#039;s Mens Wear with two male clerks standing by the counters.','STORE, MACKENZIE','2010-05-04','Vernon','','1907','10050','10050.jpg'),(308,'View of Vernon&#039;s Okanagan College Kalamalka campus just off Hwy 97 near the Coldstream turnoff.','COLLEGE','2010-05-04','Vernon','Laviolette, Ernie','1992','10151','10151.jpg'),(309,'Front exterior view of the Natural Heritage Shop, located at 2805 - 27 Street.','STORE, HOUSE','2010-05-04','Vernon','Laviolette, Ernie','1992','10152','10152.jpg'),(310,'Front exterior view of the Green Gable Gift Shop, located at 3909 - 27 Street.','STORE, HOUSE','2010-05-04','Vernon','Laviolette, Ernie','1992','10154','10154.jpg'),(311,'Exterior view of the businesses in the Fruit Union Plaza at the corner of Hwy 97 and 25 Avenue. Taken from across the parking lot.','STORE, VFU','2010-05-04','Vernon','Laviolette, Ernie','1992','10156','10156.jpg'),(312,'Two early logging trucks loaded with fresh logs, taking a break on the roadside.','LOGGING, TRUCK','2010-05-04','','','1920&#039;s','10162','10162.jpg'),(313,'View of the Ellison family house, yard and outbuildings (located at present day Polson Park).  Two of the Ellison children are sitting on the wooden fence.','ELLISON, FARM, POLSON','2010-05-04','Vernon','','1890','10163','10163.jpg'),(314,'Formal portrait of W.F. Cameron, Vernon&#039;s first mayor.','CAMERON, CIVIC','2010-05-04','Victoria','Skene Lowe','1901','12046','12046.jpg'),(315,'Panoramic photo of Bulman Cannery staff standing in front of Bulman&#039;s Ltd.','CANNERY','2010-05-04','Vernon','Ribelin','1936','16583','16583.jpg');


