-- MySQL dump 10.9 -- -- Host: localhost Database: h47dk5js8 -- ------------------------------------------------------ -- Server version 5.0.45-community-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `admins` -- DROP TABLE IF EXISTS `admins`; CREATE TABLE `admins` ( `id` int(11) NOT NULL, `username` varchar(50) NOT NULL, `password` varchar(50) NOT NULL, `first_name` varchar(50) NOT NULL, `last_name` varchar(50) NOT NULL, `status` varchar(20) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `admins` -- LOCK TABLES `admins` WRITE; /*!40000 ALTER TABLE `admins` DISABLE KEYS */; INSERT INTO `admins` VALUES (0,'Rob','pass','Rob','Miles','admin'); /*!40000 ALTER TABLE `admins` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `clients` -- DROP TABLE IF EXISTS `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` -- LOCK TABLES `clients` WRITE; /*!40000 ALTER TABLE `clients` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `clients` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `danygraigcal` -- DROP TABLE IF EXISTS `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` -- LOCK TABLES `danygraigcal` WRITE; /*!40000 ALTER TABLE `danygraigcal` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `danygraigcal` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `events` -- DROP TABLE IF EXISTS `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` -- LOCK TABLES `events` WRITE; /*!40000 ALTER TABLE `events` DISABLE KEYS */; INSERT INTO `events` VALUES (1,'Funtastic','2010-05-12'),(2,'Farmers Market','2010-05-12'); /*!40000 ALTER TABLE `events` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `expenses` -- DROP TABLE IF EXISTS `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` -- LOCK TABLES `expenses` WRITE; /*!40000 ALTER TABLE `expenses` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `expenses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `invoices` -- DROP TABLE IF EXISTS `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` -- LOCK TABLES `invoices` WRITE; /*!40000 ALTER TABLE `invoices` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `invoices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `logs` -- DROP TABLE IF EXISTS `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` -- LOCK TABLES `logs` WRITE; /*!40000 ALTER TABLE `logs` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `okcategories` -- DROP TABLE IF EXISTS `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` -- LOCK TABLES `okcategories` WRITE; /*!40000 ALTER TABLE `okcategories` DISABLE KEYS */; 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','',''); /*!40000 ALTER TABLE `okcategories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `okcontent` -- DROP TABLE IF EXISTS `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` -- LOCK TABLES `okcontent` WRITE; /*!40000 ALTER TABLE `okcontent` DISABLE KEYS */; INSERT INTO `okcontent` VALUES (2,7,'Admission Rates','

 

\r\n

OUR RATES

\r\n

 

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n

Adults (19 – 64)

\r\n		\r\n

$12.00

\r\n
\r\n

Seniors (65 +)

\r\n		\r\n

$11.00

\r\n
\r\n

Youth (13 – 18)

\r\n		\r\n

$  9.00

\r\n
\r\n

Children (6 – 12)

\r\n		\r\n

$  7.00

\r\n
\r\n

Toddlers (5 and under)

\r\n		\r\n

FREE

\r\n
\r\n

Family Pass (Mom, Dad and Kids)

\r\n		\r\n

$30.00

\r\n
\r\n

 

\r\n

WE ALSO HAVE SEASON’S PASSES

\r\n

 

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n

Individual

\r\n		\r\n

$30.00

\r\n
\r\n

Family Pass

\r\n		\r\n

$60.00

\r\n
\r\n

Grandparents & Grandkids Pass

\r\n		\r\n

$60.00

\r\n
\r\n

Extended Family (Grandparents, parents, kids)

\r\n		\r\n

$75.00

\r\n
\r\n

 

\r\n

Group Home Pass – varies by number of residents. Please contact us for the applicable rates

\r\n

If you are interested in becoming a member of O’Keefe Ranch, and have voting rights at the Annual General Meeting or Special Meetings,  please call the Ranch directly at 250-542-7868.

','yes'),(4,6,'Map & Location','\r\n\r\n\r\n\r\n\r\n\r\n
\r\n

Located in the North Okanagan, Historic O’Keefe Ranch is easy to find.

\r\n

9380 Hwy 97N, just 12 km north of Vernon, BC

\r\n

 

\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\"\"
\r\n
\r\n

Dates/Hours of Operation
Dates: The Ranch is open to the public    from May 9th to October 10th, 2010. 
Hours: May, June, September October: 10:00 a.m. to 5:00 pm.
July and August:  10:00 a.m. to 6:00 p.m.

\r\n
','yes'),(17,8,'Daily Activities','

The Ranch is a wonderful place to explore history and nature

\r\n

Guided Tours:
Our interpreters, in heritage costume, walk you through the Historic O’Keefe Mansion. Built in 1886, the Mansion displays the original furnishings of the O’Keefe family. The tour takes approximately 30 minutes.

\r\n

Self-guided Tours:
Beside the Mansion is the old Carriage Shed, with its traditional buggies. And above the Carriage Shed is the stove museum. Over twenty antique, historic stoves are located in the museum, with a variety of different uses, from parlor stoves to cooking stoves.

\r\n

Heritage Walk:
Take a stroll down the boardwalk; walk through the log house, the original dwelling of the O’Keefe’s, visit the General Store with its original Post Office and its pot-bellied stove. The Blacksmith shop, saddle shop and potter’s barn are just down the way. At the end of the Boardwalk, the old St.Anne’s Church is located, popular site of many modern weddings. The old cemetery is located directly beside the Church and is well worth a visit.

\r\n

Across the Creek:
Across the bridge you’ll find the original Schubert House, with it’s traditional kitchen stove, and just to the right is the old Schoolhouse. The schoolhouse retains the old wood-burning furnace, and the old school desks.

\r\n

Antique Equipment:
Our antique farming equipment is located “up the hill”. We have old hay-rakes, bailers, and farm tractors. The arena is located on the top of the hill, as is the implement shed, with its antique buggies and farm implements.

\r\n

Animals: 
Don’t forget to visit our farm animals. These are a favorite attraction for kids. The Jacob Sheep, with their double sets of curved horns, are a rare breed and unique to see. The Ranch annually features cows and goats, as well as rabbits. Our bird pens are filled with exotic and domestic birds, from roosters to silkies, geese to turkeys.

\r\n

The Ranch covers 53 acres. There’s plenty of room to sit and enjoy the view and the great outdoors. Take you time, and visit this site that’s a small slice of history.

','yes'),(18,9,'Group Rates','

O’Keefe Ranch is an ideal destination for group tours of all shapes and sizes.  We have plenty of experience accommodating groups, so whether you are a tour operator or a collection of friends, we can help make your visit as easy and enjoyable as possible.  Also, we have many special events scheduled throughout the season.  There is guaranteed to be something for everyone.

\r\n

Group rates are listed below.  For more information, or to book your tour, contact us at 250-542-7868 or email events@okeeferanch.ca for more information.

\r\n

Group Admission
Includes entrance to site, and all tours and demonstrations

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n

Adults

\r\n		\r\n

$8.00

\r\n
\r\n

Seniors

\r\n		\r\n

$7.00

\r\n
\r\n

Youth

\r\n		\r\n

$6.50

\r\n
\r\n

Children

\r\n		\r\n

$6.00

\r\n
\r\n

Elementary School Tours – per child (teacher is complimentary)

\r\n		\r\n

$6.00

\r\n
\r\n

 

','yes'),(19,10,'Events Calendar','\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
May 9thMother’s Day Opening
Family day, Kids activities, Bouncy play, coloring, hay rides, model railroad, mural painting, much more!
  
May 28 & 29Spring Murder Mystery Dinner Show
Spring Play. Enjoy a meal and a Murder Mystery!! Follow the show and analyze the clues. Expect a lot of laughs and a lot of fun!
  
June 4thThe United Empire Loyalists
Black powder demonstrations & gold panning.
  
June 12thMOPARS !! Here are the traditional Chrysler Muscle Cars on display!
  
June 26thFamily Fun Day
Enjoy the end of school and beginning of summer.  Lots of activities for kids and adults.  Wagon rides, mural painting and more.
  
July 2nd, 9th & 16th\r\n

Cowboy Dinner Show 

\r\n

Entertainment with Rob Dinwoodie & Friends; great BBQ, cowboy poetry, stagecoach rides, and singing around the campfire.  This is a fantastic evening to take family and friends to.

\r\n
  
July 10thVintage Motorcycle Track Races
Yes, they’re back – check out these classic motorcycles and enjoy the races
  
July 24 and 25thCanadian Horse Show.
A celebration of Canadian horses.  Full show with clinic in the morning and games in the afternoon. This is the national horse of Canada; a major part of Canada’s history.
  
July 31st & August 1stO’Keefe Cowboy Days
Cowboy Ranch rodeo;  real cowboys ropin\' and herdin\' in competition; kids activities and much more.  Two days of fun-packed entertainment in the middle of summer.
  
August 14th &15thBack in Time:
On Saturday, we\'ve got traditional threshing demonstrations, using our own home-grown wheat! Sunday it\'s The Society for Creative Anachronism – creatures dressed in medieval costumes, holding displays of sword fighting, baking, quill making and other crafts.  This is a fun bunch to spend the day with.
  
August 28thSecond Annual Late Summer Family Day:
Here’s where we have the popular scarecrow building for kids, mural painting, fishing pond, hay rides, etc.  Old-tyme games in the gazebo, miniature railroad display, hot dogs and fun!!
  
September 10th & 11thFall Murder Mystery Dinner Show
Once again, a meal and a mystery served up.  Follow the acts to various locations around the Ranch, then sit down to a good meal and examine the clues!! Who is the culprit???
  
September 12thGrandparents Day
Kids, this is the day you get to treat your grandma and grandpa to a full day at the Ranch.  Treasure hunt, coloring contest, hay rides.$15 per family/ $5 per person
  
October 10th\r\n

Thanksgiving Enter our pie-baking contest; Carve a pumpkin for our Halloween display; We\'ll have a couple of craft workshops. Event runs from 1100 am to 4:00 pm. A great day for the family.  Rates:  $6.per person/ $20 per family

\r\n
  
October 30thOur Halloween event won\'t be taking place this year.  There are Halloween events in town, as well as the Haunted House put on by the Science Centre.  Look for this event at the Ranch next year.
  
December 10, 11 & 12thVictorian Christmas
A wonderful afternoon and evening 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.  Dress Warm!! Rates: $6 per person/ $20 per family.
','yes'),(21,16,'Agriculture & Animals','

Cornelius O’Keefe along with Thomas Greenhow brought cattle to this great valley and settled here.  The foundation of the O’Keefe Ranch was livestock; the very reason for its existence.  Grain, hay and livestock production were all incorporated to ensure the Ranch was a thriving and viable operation.

\r\n

\"JacobThe Ranch has two hayfields which still provide it with its supply of hay for the farm animals. Today, the Ranch houses a small number of farm animals.  Each year, we feature a different type of both sheep and cows.  Our Jacob Sheep, however, remain throughout the year. This is one of the rare breeds listed on the American Livestock Breeds Conservancy.   This sheep is easily identified by the double sets of curving horns that the mature sheep sport.

\r\n

Our bird pens contain a variety of exotic and domestic breeds, from the Silkie and Old English Bantam, to the Wild Turkey and Peacock.

\r\n

The Arena at the top of the hill is home to several annual events.  The traditional O’Keefe Cowboy Days is hosted in the Arena, with the Cowboy Rodeo and other activities taking place.

','yes'),(22,17,'Artisans','

At Historic O’Keefe Ranch you will find some very talented individuals carrying on the tradition of saddle making, spinning and weaving, blacksmithing and creating clay pottery. Even, the art of baking on a coal and wood store is offered here.

\r\n

The Pottery Barn
Northfire Pottery’s Burt Cohen has been producing pottery on site for several years. There is an extensive selection of items for sale. And if you are interested Burt can tell you about “Potters Without Borders” a program to bring clean water to third world countries.

\r\n

The Blacksmith Shop
Our Blacksmith, Joe, shows up as often as he can to demonstrate his work. The Shop is always open for those who would just like to take a peek.

\r\n

\"Blacksmith

\r\n

Spinners and Weavers
The ranch welcomes spinners and weavers at different events during the season. These come from our local spinner and weaver groups to join Mrs.Duddy and Mrs. Schubert in the log house, the pavilion, or on occasion the Schubert House.

','yes'),(23,18,'Ranch History','

\"\"The Historic O’Keefe Ranch is as old as Canada.  It was founded in 1867 by Cornelius O’Keefe, who was born near Ottawa in 1838, of Irish immigrant parents. 

\r\n

Cornelius came west in his early 20’s and began to drive cattle from Oregon to provide food for the gold miners in the north.  He camped on the site of the Ranch, and decided to raise cattle rather than drive them from Oregon. Cornelius pre-empted 161 acres of land.  By the early 1900’s, with Thomas Greenhow, a business partner, the ranch had grown to 15,000 acres.  As well as cattle, the ranch produced large quantities of grain.

\r\n

In 1907, 12,000 acres were sold to a group of Belgians wishing to bring settlers to the area.  Cornelius O’Keefe died in 1919, and his second wife, Elizabeth in1929.  The ranch continued to be operated by his youngest son Tierney and his wife Betty until 1967, at which time they decided, as the ranch was as old as Canada, to preserve it as part of Canadian history.  they restored and rebuilt the original ranch buildings and opened the Historic O\'Keefe Ranch in 1967, exactly 100 years after Cornelius O\'Keefe had arrived on the site.

\r\n

The O\'Keefe family operated the Ranch as a tourist attraction until 1977, when the buildings and their furnishings were purchsed by the Devonian Foundation out of Calgary.  The Foundation gave the historic site to the City of Vernon.  A non-profit organization, the O\'Keefe Ranch & interior Heritage Society, was set up to operate the site.  The society is a also a registered Canadian charity.

\r\n

Financial support is provided by the City of Vernon, and the Government of British Columbia through the BC Arts Council.

','yes'),(24,19,'Tickets for upcoming events','

Cowboy Dinner Show

\r\n

The Cowboy Dinner show is a great night out for all.

\r\n

Pavilion / Tent Layout

\r\n

\"Cowboy
Click to enlarge

\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Quantity
Seat
Date
\r\n \"\"
\r\n

Click on \"Continue\" on the left if you do not have a paypal account

','yes'),(25,20,'School tours','

 \"Schoolkids

\r\n

\"To look backward for a while is to refresh the eye, to restore it, and to render it the more fit for it\'s prime function of looking forward.\"  Margaret Fairless Barber

\r\n

O\'Keefe Ranch Education Programs are offered in May, June, September and October each year. The School Program operates near capacity, so please call as early as possible to book. 

\r\n

The  Historic O\'Keefe Ranch is a unique site to educate and entertain all learning levels.  The program offers learning opportunities for students from pre-school to college level, and annually attracts over 3,500 students.  Students experience a lesson in the Balmoral School using slate boards, while tours of the heritage walk and agricultural area are also included.  Children and supervisors are invited to dress in period costume and pack a heritage picnic lunch.  Our program is tailored to each grade and has flexibility to include special requests.

\r\n

Teacher Information: 

\r\n

Pre-visitation materials are generated and distributed to schools prior to their visit.  Students are divided into groups so that they can best experience the different learning stations.

','yes'),(26,23,'Weddings','

Looking for a Wedding Venue?  

\r\n

Try one of ours.. . .

\r\n

\"\"A unique wedding site and an engaging place to say \"I do\" O\'Keefe Ranch offers several venues for weddings.  From the rustic charm of St.Anne\'s Church (circa 1889) to the brand new outdoor pavilion, we offer packages to suit all tastes.  Enjoy the ceremony, take pictures throughout the Ranch, and then enjoy the reception either in the Cattlemen\'s Club Restaurant or in the more open Pavilion.

\r\n

Our horse drawn carriage can take you to the church in style. . . . .

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\"Okeefe
\r\n

Size - 21mb, please right
click and select \"save as\"

\r\n
\r\n

Historic O\'Keefe Ranch is also pleased to offer facilities for Reunions, Anniversaries, Corporate Parties, and whatever other party you, as our guest, may have in mind

\r\n

THE CEREMONY

\r\n

St.Ann\'s Church for the Traditional: - seats 70 guests

\r\n

A charming landmark that stands on the original location upon which it was built.  Originally a Roman Catholic Church, it is now non-denominational.  Because it is a heritage building, permitted decorations are limited.

\r\n\r\n

The Rose Garden for the Romantic: - seating up to 120 guests

\r\n

This attractive tree-lined garden is nestled next to the elegant and historic O\'Keefe Mansion, and is a popular summertime choice for an intimate and memorable outdoor occasion.  The Rose Garden has an arbour under which the ceremony can take place.

\r\n\r\n

The Gazebo with its lacy fencing:

\r\n

This lovely latticed building is perfect for the small wedding party.  The ceremony takes place in the open gazebo, while the guests are seated just outside.

\r\n\r\n

THE RECEPTION

\r\n

For the reception dinner, the Cattlemen\'s Restaurant provides scrumptious menus to choose from;  have it indoors in the restaurant or outside in our new Pavilion;  decorate the Pavilion to your heart\'s content. 

\r\n

The Pavilion

\r\n

Completed in 2009, this is a building which brings the outdoors in.  Roofed and with pony walls, the Pavilion will hold up to 100 guests plus the wedding party.  A great semi-outdoors venue to decorate with your special taste.

\r\n','yes'),(33,29,'Sponsorships','

The O\'Keefe Ranch is grateful for the ongoing annual financial support it receives from the BC Arts Council, and from the City of Vernon.

','yes'),(34,30,'O\'Keefe Cowboy Festival','

2010 O’KEEFE COWBOY DAYS FESTIVAL SCHEDULE

\r\n

 Saturday & Sunday:

\r\n

*Pony Rides       *Bouncy Castle

\r\n

*Cloth Dyeing    *Roping demonstrations      *Ice Cream

\r\n

*Water features for kids       *Animals             *Hamburgers     

\r\n

 

\r\n

RODEO

\r\n

Saturday, July 31st

\r\n

8:30 – 10:30                Ranch Horse Slack                              Thomas Greenhow Arena

\r\n

10:30 to 12:30             1st Perf Ranch Horse                           Thomas Greenhow Arena

\r\n

                                    Competition

\r\n

1:00 pm.                      OPENING CEREMONIES                       Thomas GreenhowArena

\r\n

1:30 pm                       Competitor Rule Review                      Announcer’s Stand

\r\n

2:00 to 5:00                 1st Perf Ranch Rodeo                          Thomas Greenhow Arena

\r\n

5:00 pnm                     Reata Long Throw                               TBA

\r\n

5:30 to 7:30                COWBOY BBQ                                      The Pavilion

\r\n

 

\r\n

Sunday, August 1st

\r\n

8:30 to 10:30               Ranch Horse Slack                                Thomas Greenhow Arena

\r\n

9:00 to 10:00               COWBOY CHURCH                                  St Anne’s Church

\r\n

10:00 to 12:30             1st Perf Ranch Horse                             Thomas Greenhow Arena

\r\n

 

\r\n

1:00 pm                       Competitor Rule Review                      Thomas Greenhow Arena

\r\n

1:30 – 4:30                  1st Perf Ranch Rodeo                            Thomas Greenhow Arena

\r\n
\r\n

5:00 pm                       AWARDS CEREMONY                             Summerview Barn

\r\n
\r\n

 

\r\n

Sunday, August 1st

\r\n

2:30                             Free Two-Step Lessons                            Pavilion

\r\n

                                    (by Cheek to Cheek Dance Studio)

\r\n

4:00                             Two-Step Competition                             Pavilion

\r\n

 

\r\n

7:30 to 11:30              Boot Scootin’Boogie                               Pavilion  $20

\r\n

                                    Barn Dance –

\r\n

                                    Live Country Band – Blue Scarlett

','yes'),(35,31,'Special Information','

SPECIAL INFORMATION & DETAILS - WEDDING VENUES

\r\n\r\n

If you have questions, please contact us at 250-545-7868

\r\n

 

\r\n

 

','yes'),(36,32,'Adopt-a-Building Program','

\"Old

\r\n

 

\r\n

O\'Keefe Ranch Sponsorship Opportunities

\r\n

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

\r\n

For those wishing to assist in preserving, protecting and displaying buildings representing the early BC ranching history, there are several options for consideration.

\r\n

The \"Adopt-a-Building\" Program

\r\n

There are currently 19 heritage structures on site.  A number of these are in need of restoration. The Ranch is looking for individuals or corporations interested in sponsoring the restoration of any of these buildings.  Once the building has been \"adopted\", the sponsor will receive the following:

\r\n\r\n

Please contact the Ranch (General Manager - 250-306-7868) directly to obtain details of buildings and the amount of restoration required.  Our buildings needs range from $3,000 to $12,000.  We also welcome partial sponsorships.

\r\n

 

','yes'),(37,33,'Volunteers','

\"Volunteers

\r\n

 

\r\n

Volunteers

\r\n

Meet Lorna and Philip, two dedicated volunteers, and two of the happiest people we know.

\r\n

If you enjoy history and you enjoy people, you will love volunteering at Historic O\'Keefe Ranch.  The Ranch is operated by a non-profit organization, and a variety of skills are needed to maintain and represent history. 

\r\n

Volunteering gives you an opportunity to share a passionate interest or hobby with others.

\r\n

The Historic O\'Keefe Ranch needs volunteers to fulfill many roles. Our volunteer contingent is a very vital and necessary part of the operations of the Ranch.

\r\n

We need volunteers who can:

\r\n\r\n

Areas where volunteers are needed:

\r\n\r\n

Two-person volunteer teams are welcome!  For more information, please call 250-542-7868 or email events@okeeferanch.ca

\r\n

 

\r\n

 

\r\n

 

','yes'); /*!40000 ALTER TABLE `okcontent` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oknews` -- DROP TABLE IF EXISTS `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` -- LOCK TABLES `oknews` WRITE; /*!40000 ALTER TABLE `oknews` DISABLE KEYS */; INSERT INTO `oknews` VALUES (2,'Latest News','
\r\n

Up and coming events:

\r\n

Dec. 10,11,12th: from 2:00 to 6:00 pm
Victorian Christmas - 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.

\r\n
'); /*!40000 ALTER TABLE `oknews` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stock` -- DROP TABLE IF EXISTS `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` -- LOCK TABLES `stock` WRITE; /*!40000 ALTER TABLE `stock` DISABLE KEYS */; 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,'',''); /*!40000 ALTER TABLE `stock` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stocksold` -- DROP TABLE IF EXISTS `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` -- LOCK TABLES `stocksold` WRITE; /*!40000 ALTER TABLE `stocksold` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `stocksold` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `user_id` int(6) NOT NULL auto_increment, `clientid` int(6) NOT NULL, `user_name` varchar(50) NOT NULL, `user_login` varchar(30) NOT NULL, `user_pass` varchar(10) NOT NULL, `user_date` date NOT NULL, `user_type` varchar(20) NOT NULL, PRIMARY KEY (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,0,'Administrator','admin','12345','2010-05-12','admin'),(2,19,'Rob Miles','rmiles','smiler','2010-05-12','admin'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `visits` -- DROP TABLE IF EXISTS `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` -- LOCK TABLES `visits` WRITE; /*!40000 ALTER TABLE `visits` DISABLE KEYS */; INSERT INTO `visits` VALUES (1,'5','2009-02-04','13:00:00','1.00',0,0,'Troubleshooted Network connections\r\nConnected and configured Security system\r\nInstalled and tested camera software\r\nTested camera software offsite'),(2,'5','2009-02-09','13:00:00','1.00',0,0,'Connected TV to security system'),(3,'10','2009-01-16','15:00:00','1.00',0,0,'Checked printer connection\r\nRemoved unwanted printers'),(4,'10','2009-01-20','12:00:00','1.00',0,0,'Ran various cleanup programs to remove clutter\r\nChecked startup programs and removed unnecessary files'),(5,'10','2009-02-10','15:00:00','2.00',0,0,'Remove Vista and install XP\r\nInstall drivers\r\nInstall Office 2003 and other programs'),(8,'14','2009-02-09','10:00:00','3.00',0,0,'Tested network\r\nCalled GreenTek to try and unlock router\r\nPurchased Dlink router\r\nProgrammed router and found fault with wireless settings'),(7,'10','2009-02-17','14:30:00','3.00',0,0,'Setup screen\r\nSetup programs\r\nSetup printers\r\nTest programs and printers'),(9,'14','2009-02-10','09:30:00','3.00',0,0,'Replaced faulty router with Dlink N router\r\nFound fault with port settings\r\nCalled Dlink\r\nReplaced router with Linksys router'),(10,'14','2009-02-12','08:00:00','2.00',0,0,'Programmed Linksys router\r\nDisconnected Greentek router and tested network\r\nCalled Dedicated Macros for support on security system\r\nDownloaded new firmware for security system\r\nUploaded firmware to DVR\r\nRebooted and tested security software from remote computer'),(11,'15','2009-03-10','13:00:00','9.99',0,0,'Setup hosting account\r\nCreated web site framwork\r\nUploaded pictures\r\nInputed information on all pages\r\nCreated contact page\r\nCreated client database\r\nBuilt client system with login\r\nUploded pages\r\nTested online and checked all links and functions\r\n*Client system to be completed at later date'),(12,'16','2009-03-03','09:00:00','1.00',0,0,'Troubleshooted wireless connection\r\nChecked office PC for network connections\r\nChecked for wireless networks\r\nDisabled wireless on Dlink router'),(13,'6','2008-11-17','10:00:00','1.00',0,0,'Called chase payment to setup dummy account to test software'),(14,'6','2008-11-18','16:00:00','1.00',0,0,'Tested dummy account with software\r\nConcluded PHP programming required'),(15,'6','2008-11-20','15:00:00','1.00',0,0,'Met Dan to discuss software process and PHP requirements'),(16,'6','2008-11-24','12:00:00','1.00',0,0,'Tested software with PHP payment page'),(17,'22','2009-01-22','10:00:00','2.00',0,0,'Initial Meeting\r\nConfiguring DVR System\r\nCreating user guide'),(18,'22','2009-02-09','12:00:00','1.00',0,0,'Installed and configured DVR software on Laptop'),(19,'22','2009-03-12','09:30:00','1.00',0,0,'Configured DVR system to constantly display video feed from camera'),(20,'21','2009-03-03','14:00:00','1.00',0,0,'Retrieved memory card from inside case\r\nTested email settings\r\nChanged SMTP settings\r\nRemoved emails from outbox'),(21,'23','2009-03-27','11:00:00','1.00',0,0,'Test stock'),(22,'16','2009-03-27','16:30:00','1.00',0,0,'Tested modem\r\nTested USB serial ports\r\nChecked Chubb Director settings\r\nChanged Chubb Communicator settings to match modem'),(23,'25','2009-04-02','11:00:00','0.50',0,0,'Tried to recover word document\r\nChanged word settings to create backup copy'),(24,'25','2009-03-12','13:00:00','0.50',0,0,'Tested email settings\r\nSent and received test emails\r\nChecked email limit settings'),(25,'25','2009-04-03','13:00:00','0.50',0,0,'Removed Antivir\r\nInstalled Avast\r\nConfigured scan settings'),(26,'25','2009-04-16','11:00:00','0.50',0,0,'Connected through log me in to troubleshoot email not sent\r\nResent emails and tested sending and receiving\r\nCreated new send and receive group and tested'),(27,'26','2009-04-27','13:00:00','1.00',0,0,'Called Telus to check SMTP server settings\r\nChanged SMTP settings\r\nMoved emails to draft folder\r\nCreated new send and receive group\r\nTested sending emails\r\nPerformed system cleanup'),(28,'27','2009-05-21','09:45:00','2.00',0,0,'Installed ERCS 3.9.7 and encountered errors\r\nCalled WorkSafeBC to get technical support\r\nTried to install with recommended changes\r\nSetup print share on Server\r\nInstalled AVG on Dell PC\r\nRestarted and checked network settings on Dell PC\r\nCalled technical support again in afternoon'),(29,'27','2009-05-22','09:45:00','1.00',0,0,'Received call from WorkSafeBC and installed new 3.9.7 on server\r\nInstalled software on 4 other PCs\r\nConfigured network settings on Server\r\nInstalled updates and restarted Server'),(30,'28','2009-05-27','09:00:00','1.00',0,0,'Scanned PST file for errors\r\nCreated new outlook profile\r\nRemoved copy of personal folder\r\nRemoved Avast anti virus\r\nInstalled Shaw Secure\r\nSetup Archive settings\r\nReconnected printer to PC'),(31,'29','2009-06-02','15:00:00','0.50',0,0,'Updated all PC`s with latest version of ERCS\r\nReinstalled LogMeIn on gym PC'),(32,'29','2009-06-04','09:00:00','0.50',0,0,'Installed Office 2003 on server\r\nCopied emails from reception PC\r\nConfigured and tested Outlook on server'),(33,'30','2009-06-25','15:00:00','2.00',0,0,'Checked Email account and settings\r\nSet new profile as default\r\nChanged taskbar settings\r\nChanged power settings\r\nOn other PCs\r\nRemoved programs from startup\r\nRemoved Business contact manager\r\nInstalled Office compatability pack\r\nChecked computer settings'),(34,'31','2009-07-07','13:00:00','1.00',0,0,'Removed virus\r\nTested emaill'),(35,'32','2009-07-08','10:00:00','2.00',0,0,'Initial Design'),(36,'32','2009-07-09','10:00:00','2.00',0,0,'Created pages'),(37,'33','2009-07-23','16:30:00','2.00',0,0,'Tested computer and checked cables\r\nReplaced power supply and started successfully\r\nInstalled new power supply\r\nTied up cables inside and outside PC\r\nSwitched on and changed boot up settings'),(38,'34','2009-07-10','09:00:00','1.00',0,0,'Checked PC speeds\r\nTested network speed\r\nChecked computer settings\r\nChecked server speed\r\nDetermined new update cause of slow speeds'),(131,'86','2010-07-28','09:00:00','1.00',0,0,'12 months hosting at $9 a month'),(40,'37','2009-08-06','09:00:00','2.00',0,0,'Ran system cleanup software\r\nRemoved startup programs and restarted PC\r\nUninstalled Acrobat Reader 9\r\nInstalled Acrobat Reader 8 to save online PDFs\r\nTested Computer speed'),(41,'38','2009-08-21','14:00:00','1.00',0,0,'Removed startup programs\r\nRemoved Java programs and toolbars\r\nTested Internet Explorer\r\nChanged file association for web pages\r\nRan computer cleanup to speed up PC'),(42,'39','2009-08-19','13:00:00','1.00',0,0,'Installed Memory on Doreens PC\r\nTested Memory\r\nWorked on Excel File with Edie'),(43,'39','2009-08-25','10:00:00','2.00',0,0,'Installed Office 2007 on Doreens PC\r\nTested with 2007 documents\r\nSetup Backup\r\nTested Backup\r\nHelped Edie with Word document contents'),(45,'40','2009-09-17','10:00:00','0.50',0,0,'Extracted video from security system\r\nAttempted to convert and edit movie'),(44,'39','2009-09-03','13:00:00','2.00',0,0,'Changed Screen resolution settings\r\nScanned for viruses on Bruces PC\r\nStress tested Bruces PC\r\nScanned hard drive for damage\r\nSetup fingerprint recognition\r\nTested network connection in spare office'),(46,'40','2009-09-18','09:30:00','0.50',0,0,'Extracted 5 minute video from security system\r\nCreated 2 copies'),(47,'40','2009-09-21','09:30:00','1.00',0,0,'Created new user account on laptop for Colin Lee\r\nCopied Steve Edwards data from laptop to his PC\r\nAssisted Steve in backup setup for Maximiser\r\nSetup outlook for Colin on Laptop'),(48,'41','2009-09-25','10:00:00','2.00',0,0,'Checked wiring and power source\r\nRemoved startup programs\r\nScanned and removed clutter\r\nChecked computer settings\r\nTested scanner'),(49,'42','2009-10-07','10:00:00','2.00',0,0,'Design of city scene header\r\nCreation of business people image'),(50,'43','2009-10-07','10:00:00','1.00',0,0,'Building of database\r\nBuilding of business listing and entry forms\r\nImplementation of search tools\r\nCreation of random ad entry and display parts'),(51,'44','2009-09-22','10:00:00','1.00',0,0,'Tested Network settings\r\nAccessed security locally on PC and Mac'),(52,'44','2009-09-23','11:00:00','1.50',0,0,'Called Dedicated Macros Support\r\nUpgraded security system firmware\r\nTested local web access on Mac\r\nTested remotely on PC'),(53,'45','2009-10-20','12:00:00','1.50',0,0,'Performed maintenance on Bruces PC\r\nChecked scanner settings\r\nPerformed test scans'),(54,'45','2009-10-27','09:30:00','0.50',0,0,'Changed time on camera system'),(55,'46','2009-10-30','09:00:00','1.00',0,0,'Installed PC\r\nSetup Outlook\r\nInstalled printer\r\nTested setup'),(56,'47','2009-11-02','09:00:00','1.00',0,0,'Moved PST from Dell to HP\r\nSetup PST in outlook\r\nSetup scanning to HP\r\nTested remote desktop\r\nAdvised on backups'),(57,'48','2009-11-04','11:00:00','1.00',0,0,'Updated ERCS software on all PCs'),(58,'49','2009-11-12','10:00:00','1.00',0,0,'Scanned PST file and repaired errors\r\nRepaired Outlook\r\nSetup Gord account on server'),(59,'49','2009-11-13','09:00:00','1.00',0,0,'Renamed PC to Station3\r\nTested Gord account on Station3\r\nSetup Outlook\r\nSetup scanning\r\nSetup shared pictures folder all PCs'),(60,'50','2009-11-20','18:00:00','2.00',0,0,'Scanned and removed viruses at boot\r\nInstalled Anti Malware Software\r\nScanned and removed trojans\r\nScanned with AVG\r\nTested PC'),(61,'51','2009-12-10','11:00:00','1.00',0,0,'Recovered data from My Documents on old hard drive\r\nTransferred data to USB Stick\r\nDownloaded Network Viewer and placed on USB Stick'),(62,'52','2009-12-18','13:00:00','3.00',0,0,'Installed new power surge protector\r\nConnected new PC and setup programs\r\nSetup Printers\r\nInstalled Simply Accounting\r\nInstalled Office Trial\r\nTransferred documents from old PC'),(63,'52','2009-12-19','10:00:00','3.00',0,0,'Tested Sony Vaio Desktop\r\nDetermined key windows files corrupted\r\nCopied favourites and documents\r\nFormatted PC and installed XP\r\nInstalled programs and copied data\r\n'),(64,'52','2009-12-21','14:00:00','2.00',0,0,'Transferred photos from old PC\r\nConverted emails on laptop to PST\r\nSetup Office 2007 on new PC\r\nSetup Outlook\r\nInstalled wireless USB stick on old PC\r\nMoved old PC down stairs'),(65,'53','2010-12-29','12:00:00','1.00',0,0,'Configured Camedia software\r\nTested Scanner\r\nSetup Epson LQ-590 Printer\r\nSetup shared files and folders'),(66,'54','2010-01-05','13:00:00','1.00',0,0,'Created shortcut on desktop to backup outlook\r\nCreated shortcut on all other PCs\r\nRan backup on server\r\nConfigured iPhone to receive aaforest email\r\nRestarted and tested scanner'),(67,'54','2010-01-12','11:00:00','1.00',0,0,'Checked scanner shortcut settings\r\nTested scanner\r\nTested alternative settings on iPhone'),(68,'55','2010-01-08','13:00:00','1.00',0,0,'Changed default personal folder in outlook\r\nRemoved duplicate personal folder\r\nChecked archive folder\r\nTalked to Edie about scanner\r\nRemoved temporary internet files from PC\r\nAdvised on changing signatures'),(69,'55','2010-01-12','09:30:00','1.00',0,0,'Installed spam filter on 2 PCs\r\nAdvised Edie on editing PDFs\r\nTalked to Tom about server requirements'),(70,'56','2010-02-01','19:00:00','2.00',0,0,'Checked email settings\r\nTested email\r\nScanned PST files'),(71,'57','2010-02-01','09:30:00','4.00',0,0,'Backed up House PC\r\nInstalled new Memory\r\nTransferred data from house PC to Barn PC\r\nSwapped PCs\r\nInstalled programs onto Barn PC\r\n'),(72,'57','2010-02-02','09:30:00','2.00',0,0,'Switched printers over in office\r\nInstall HP in windows 7\r\nTested remote access to shared folder\r\nInstalled programs to test VPN\r\nTested Barn PC'),(73,'57','2010-02-04','11:30:00','1.00',0,0,'Installed remote program on PC\r\nTested accessing shared folder remotely'),(74,'58','2010-02-15','09:00:00','1.00',0,0,'Researched for battery for Dell C600\r\nOrdered battery\r\nInstalled'),(75,'57','2010-02-25','09:00:00','1.00',0,0,'Demonstrated Logmein connection to Farm PC\r\nRemoved start up programs on laptop\r\nRemoved memory from laptop\r\nInstalled Logmein on Parlour PC'),(76,'59','2010-02-24','09:30:00','5.00',0,0,'Tested Simply Accounting Printing\r\nContacted simply accounting\r\nInstalled simply 2010\r\nCreated custom crytal reports\r\nTested printing\r\nSetup backup'),(77,'59','2010-03-01','11:30:00','1.00',0,0,'Setup web cam\r\nCreated crystal custom statement\r\nTested printer\r\nScanned registry on old PC\r\nInstalled Chrome on old PC'),(78,'60','2010-03-01','09:30:00','1.00',0,0,'Tested PC\r\nScanned memory\r\nCleaned Registry\r\nChanged email filter settings'),(79,'60','2010-03-01','19:00:00','2.00',0,0,'Removed Microsoft One Care\r\nInstalled Norton Internet Security 2010\r\nScanned PC and removed viruses\r\nPerformed star up scan\r\nRemoved start up items\r\nTested PC restart\r\nTested Outlook\r\nRestored windows password\r\n'),(80,'60','2010-03-02','09:30:00','1.00',0,0,'Restored email password\r\nRestored screen settings\r\nInstalled Norton Internet Security 2010'),(81,'60','2010-03-02','14:30:00','1.00',0,0,'Reinstalled program\r\nChanged firewall settings\r\nRemoved email account'),(82,'61','2010-03-17','13:00:00','1.00',0,0,'Setup automatic daily backup on server\r\nRan repair on Outlook\r\nChecked Remote Desktop settings\r\nTested Remote Desktop offsite'),(83,'61','2010-03-19','10:00:00','1.00',0,0,'Restarted router and switch\r\nInstalled Anti Crash program\r\nTested Remote desktop\r\nChecked backups'),(84,'62','2010-03-16','13:00:00','2.00',0,0,'Set up Dlink Router\r\nTransferred files from old laptop to new\r\nInstalled Office\r\nInstalled Norton\r\nInstalled printer'),(86,'63','2010-03-16','11:00:00','2.00',0,0,'Installed Time Force on house PC\r\nConfigured computer for Time Force\r\nCalled Time Force support\r\nCreated VPN\r\nTested Hamachi'),(87,'63','2010-03-23','10:30:00','2.00',0,0,'Tested Time Force\r\nCalled Time Force Support\r\nUninstalled Time Force\r\nCalled Time Force Support\r\nTested Time Force on network\r\nTested VPN'),(88,'60','2010-03-17','09:30:00','7.00',0,0,'Installed 2 new PC\\\'s\r\nSetup network Storage Disk\r\nConfigured users an folders on storage disk\r\nSetup automatic backup on all PC\\\'s'),(89,'60','2010-03-19','12:15:00','1.00',0,0,'Checked backup settings\r\nChecked backup folders on disk\r\nSetup printers on new PC\r\nSetup folder share'),(90,'63','2010-04-16','09:30:00','2.00',0,0,'Programmed Wireless Access Point\r\nSetup Drop Box on Farm PC\r\nSetup Drop Box on Bevs PC\r\nTested drop box'),(91,'63','2010-04-22','13:00:00','1.00',0,0,'Connected and configured wireless access point\r\nInstalled USB wireless adapter in parlour\r\nConnected parlour to access point\r\nSetup shared folder'),(92,'63','2010-04-27','09:30:00','2.00',0,0,'Restarted router and restored internet\r\nInstalled Dairy Comp on house PC\r\nSetup active sync on parlour PC\r\nSetup Time Force on parlour PC\r\nCalled Dairy Comp support\r\nInstalled Dairy Comp on Bevs laptop'),(93,'68','2010-04-06','09:00:00','8.00',0,0,'Built initial site template\r\nCreated site graphics\r\nImplemented colour scheme in all sections\r\nCreated mouse over effect for images\r\nInstalled lightbox image viewer'),(94,'68','2010-04-13','10:00:00','3.00',0,0,'Created following internal pages\r\n- Allan Brooks\r\n- Anna Cail\r\n- Ice Pail\r\n- Interior Salish\r\n- Fur Trade\r\n- Beginnings of Early Vernon\r\n- Museum and its Archives\r\n- Accessing the Archives'),(95,'68','2010-04-19','13:00:00','6.00',0,0,'Created image upload section\r\nCreated image database\r\nCreated image details page\r\nCreated image list\r\nUploaded test images\r\nAdded delete feature to image list\r\n'),(96,'67','2010-04-15','13:00:00','1.00',0,0,'Installed Lumber Trader software on all PCs\r\nInstalled VNC Software on all PCs\r\nInstalled Outlook backup software on all PCs '),(97,'67','2010-04-16','10:30:00','1.00',0,0,'Supported Roger with email connection\r\nResearch Qwest pop settings\r\nCalled Qwest support\r\nHelped setup gmail account\r\nHelped enter gmail settings in Outlook\r\n'),(98,'69','2010-05-14','13:00:00','1.00',0,0,'Installed Cute PDF program\r\nTalked to Kevin on program issues\r\nBacked up computer to server\r\nChecked server backup'),(99,'70','2010-05-14','11:00:00','1.00',0,0,'Checked program backups\r\nChecked program USB stick\r\nRan daily backup\r\nTested working system\r\nCalled Jeromy on backup errors\r\nChecked files on house PC'),(100,'69','2010-05-17','13:30:00','0.50',0,0,'Met Lisa at Staples to talk to technician'),(101,'69','2010-05-19','13:00:00','0.50',0,0,'Uninstalled Office 2003 and 2007\r\nReinstalled Office 2007\r\nRemoved Anti Crash\r\nRan Registry Repair\r\nTested Outlook'),(102,'','0000-00-00','00:00:00','0.00',0,0,''),(103,'','0000-00-00','00:00:00','0.00',0,0,''),(104,'','0000-00-00','00:00:00','0.00',0,0,''),(105,'','0000-00-00','00:00:00','0.00',0,0,''),(106,'71','2010-05-19','17:30:00','2.00',0,0,'Cleaned inside upstairs PCs\r\nCleaned inside and CPU fans of downstairs PCs\r\nInstalled internet file on downstairs PCs\r\nChecked Anti Virus on all PCs'),(107,'69','2010-06-01','09:00:00','0.50',0,0,'Supported Johnal with Gmail in Outlook'),(108,'69','2010-05-25','09:00:00','1.00',0,0,'Cleaned Dell PC\r\nRepaired registry\r\nInstalled and tested remote program'),(110,'73','2010-05-27','13:00:00','0.50',0,0,'Formatted memory stick\r\nChecked backup system'),(111,'73','2010-05-28','14:00:00','0.50',0,0,'Copied backup files from existing memory stick\r\nSuccessfully tested backup'),(112,'74','2010-06-01','14:00:00','1.50',0,0,'Removed Office trial and Works 9\r\nInstalled Office 2003\r\nInstalled printer\r\nInstalled ERCS\r\nCalled Clinic Essentials to install software\r\nChanged AVG to free version\r\nCopied files from old laptop\r\nSetup outlook calander'),(113,'75','2010-06-14','11:00:00','2.00',0,0,'Cleaned desktop PC\r\nInstalled Office 2007 on laptop and desktop\r\nRemoved startup programs\r\nSecured wireless\r\nSetup Outlook on laptop'),(114,'76','2010-05-07','09:00:00','9.99',0,0,'Created initial site design\r\nCreation of database to store users, events, and survey results\r\nLogin page for users and administrators\r\nPage for administrators to add new users\r\nPage for administrators to add new events\r\nPages to display questions\r\nStoring of answers in database\r\nReporting page to display to display survey results\r\nPage to export to excel by selecting events\r\nTesting on Blackberry'),(115,'77','2010-06-09','12:00:00','1.00',0,0,'Installed Anti Virus\r\nChecked backups on backup drive'),(116,'78','2010-06-29','14:00:00','3.00',0,0,'Reinstalled printer on host PC\r\nReinstalled printer on all PCs\r\nTested adding new users\r\nReset Internet Explorer settings\r\nTested Dell laptop\r\nCalled Dell support\r\nTested Dell laptop on network'),(130,'72','2010-05-26','09:30:00','1.00',0,0,'Work Done on Carols Laptop\r\nSetup Office 2003\r\nInstalled Telus USB internet connection\r\nCopied data from old hard drive to new laptop'),(117,'79','2010-07-14','08:30:00','1.00',0,0,'Called Workforce for password support\r\nUpdated server\r\nUpdated 3 clinic PCs'),(118,'79','2010-07-15','09:30:00','0.50',0,0,'Connected Laptop to network\r\nInstalled update\r\nTested update'),(194,'121','2010-10-09','12:00:00','2.50',0,0,'Installed anti virus on 2 PC at clinic\r\nInstalled service pack 2 on clinic PC\r\nShared folder between 2 PCs\r\nTested printer\r\nChanged printer settings\r\nTested printer on laptop'),(120,'81','2010-07-23','01:00:00','9.99',0,0,'1 Year Web Hosting'),(121,'82','2010-07-23','10:00:00','8.00',0,0,'Designed site and created graphics'),(122,'82','2010-07-23','11:00:00','3.00',0,0,'Created internal pages and contact form'),(123,'82','2010-07-23','12:00:00','6.00',0,0,'Created store admin area to enter products'),(124,'82','2010-07-23','14:00:00','2.00',0,0,'Link shopping basket to payment gateway'),(125,'83','2010-07-23','09:00:00','9.99',0,0,'Created site design and graphics and internal pages'),(126,'83','2010-07-23','10:00:00','4.00',0,0,'Created site map with information on mouse rollover'),(127,'83','2010-07-23','11:00:00','8.00',0,0,'Created site admin area with content management'),(128,'83','2010-07-23','12:00:00','3.00',0,0,'Created and edited paypal button and created tickets page'),(129,'84','2010-07-22','10:00:00','1.00',0,0,'Created site graphics and template'),(132,'87','2010-07-29','15:30:00','1.00',0,0,'Connected to PC remotely\r\nChecked printer settings\r\nPrinted test picture\r\nChecked installed programs'),(133,'91','2010-07-31','04:30:00','1.00',0,0,'werwer'),(135,'88','2010-07-31','09:30:00','1.00',0,0,'Installed Recent Comments plugin'),(136,'88','2010-07-31','09:30:00','1.00',0,0,'Installed and configured side links'),(137,'88','2010-07-31','09:30:00','1.00',0,0,'Support and guide emails'),(138,'88','2010-07-31','09:30:00','1.00',0,0,'Installed and configured stats plugin'),(139,'88','2010-07-31','09:30:00','2.00',0,0,'Created dropdown for catagory listing'),(140,'93','2010-07-18','10:00:00','1.50',0,0,'Created site template with header and menu'),(141,'93','2010-07-18','10:15:00','0.50',0,0,'Created site pages'),(142,'93','2010-07-18','10:45:00','1.00',0,0,'Created and tested site forms'),(143,'94','2010-07-23','09:30:00','1.00',0,0,'Created site template'),(144,'94','2010-07-23','09:45:00','2.00',0,0,'Created internal pages'),(145,'94','2010-07-23','10:00:00','1.00',0,0,'Created flash movie'),(146,'94','2010-07-23','10:15:00','2.00',0,0,'Created image gallery'),(147,'95','2010-08-03','10:30:00','9.99',0,0,'12 months hosting at $9 a month'),(148,'96','2010-08-04','08:45:00','1.00',0,0,'Installed update on all PCs\r\nInstalled update on laptop\r\nDiagnosed network problems'),(149,'97','2010-08-04','13:30:00','1.00',0,0,'Installed router\r\nConfigured IP addresses on all PCs\r\nInstalled update on Dell PC\r\nInstalled update on server\r\nTested network printing'),(150,'98','2010-08-05','09:30:00','1.00',0,0,'Changed login details\r\nChanged logo\r\nCreated and changed slide show'),(151,'99','2010-08-05','09:30:00','7.00',0,0,'Configured keywords and descriptions for lawyer pages\r\nInstalled and configured drupal modules'),(152,'100','2010-07-21','14:30:00','1.00',0,0,'Installed new Normal.dot template\r\nTested word\r\nCleaned temporary files\r\nCleaned registry'),(153,'101','2010-08-09','08:30:00','1.00',0,0,'Scanned for viruses\r\nInstalled anti-spyware program\r\nScanned and removed spyware\r\nReinstalled Word\r\nCreated short cut in word for transcript template'),(154,'102','2010-08-09','14:00:00','0.00',0,0,'Installed backup drive'),(155,'103','2010-08-06','14:00:00','0.75',0,0,'Setup external screen\r\nCleaned temporary files\r\nCleaned registry'),(156,'103','2010-08-09','14:00:00','0.50',0,0,'Installed backup drive\r\nSetup backup software\r\nSetup password'),(157,'103','2010-08-10','13:00:00','0.25',0,0,'Checked backup'),(158,'104','2010-08-10','10:00:00','3.00',0,0,'Synchronized Outlook contacts and calendar with iPhones\r\nConnected to office wireless\r\nSetup and configured gmail accounts\r\nConnected iPhone to vehicle bluetooth'),(159,'105','2010-08-05','14:00:00','1.00',0,0,'Tested screen\r\nChecked computer settings\r\nChanged to on-board display\r\nInstalled driver\r\nChanged resolution'),(160,'106','2010-08-10','20:30:00','0.50',0,0,'Connected over internet to PC\r\nInstalled Chrome, to test site\r\nChanged Explorer settings\r\nReset Explorer settings to default\r\nChecked router settings\r\nDisabled security to test site'),(161,'106','2010-08-11','10:00:00','1.00',0,0,'Connected over internet to PC\r\nRestarted router\r\nChanged internet explorer settings\r\nCalled Telus support\r\nDiscussed problems with Telus\r\nReset router on Telus advice'),(162,'107','2010-09-09','09:30:00','2.50',0,0,'Made changes to site according to email\r\nChanged menu\r\nCreated 2 new pages\r\nAdded Cayman Exchange logo to all pages\r\nAdded text to 6 current pages\r\nMade changes on Anthony Akiwumi page\r\nAdded Immigration page\r\nMade changes to bio\r\nMade changes to practice areas'),(163,'108','2010-09-20','14:00:00','3.00',0,0,'Updated laptop wireless driver\r\nInstalled service pack 1 on laptop\r\nConnected Laptop to wireless network\r\nReinstalled HP software\r\nUninstalled McAfee\r\nUninstalled Spy Sweeper\r\nReinstalled updated HP software\r\nTransferred blackberry photos to PC'),(164,'109','2010-09-16','11:00:00','2.00',0,0,'Tested Gmail settings\r\nDemonstrated webmail on iPhone\r\nSynchronized contacts with Outlook and iPhone\r\nTested Bluetooth in Toyota\r\nUninstalled Telus Security on Steves PC\r\nInstalled NOD32 on Steves PC\r\nResearched Bell Internet Hub'),(165,'109','2010-09-20','11:00:00','2.50',0,0,'Connected iPhone to wireless network\r\nResearched Garmin GPS\r\nInstalled Service Pack 3 on Steves PC\r\nInvestigated hold music '),(166,'110','2010-09-21','10:00:00','2.25',0,0,'Connected to Rogers PC\r\nTested email settings\r\nSetup new Gmail account\r\nHelped Roger setup email on iPhone\r\nChecked backup'),(167,'111','2010-09-14','13:00:00','2.00',0,0,'Tested parlour Dairy Comp\r\nChecked house folders\r\nCreated backup for parlour Dairy Comp\r\nTested house Dairy Comp\r\nCalled Dairy Comp support\r\nCalled xplorenet\r\nSetup printer on Bevs laptop\r\nInstalled backup on house PC\r\nInstalled balckberry desktop manager\r\nBacked up blackberrys'),(168,'','0000-00-00','00:00:00','0.00',0,0,''),(169,'112','2010-09-21','09:00:00','2.00',0,0,'Attempted to recover windows\r\nAttempted to run recovery from DVD\r\nCalled Toshiba support\r\nAdvised to backup and reformat\r\nBacked up desktop, documents, outlook and Dragon10\r\nFormatted Laptop\r\nReinstalled Office 2007\r\nConfigured network printer\r\n'),(170,'112','2010-09-22','09:30:00','1.00',0,0,'Configured Outlook\r\nInstalled Dragon 10 user profiles\r\nInstalled ERCS\r\nCalled Clinic Essentials for install Instructions\r\nInstalled Clinic Essentials'),(171,'113','2010-09-23','10:00:00','4.00',0,0,'Created Flash logo'),(172,'113','2010-09-23','09:30:00','3.00',0,0,'Created site pages'),(173,'113','2010-09-23','09:30:00','1.00',0,0,'Created contact button and manipulated images'),(174,'113','2010-09-23','09:30:00','2.00',0,0,'Created product contact page'),(175,'109','2010-09-22','14:00:00','2.00',0,0,'Picked up Eee PC Netbook\r\nUpgraded software on iMac\r\nRemoved start-up items\r\nInstalled screen clean-up software\r\nChanged contrast'),(176,'109','2010-09-23','15:00:00','0.50',0,0,'Setup iMac\r\nTested printer\r\nTested internet connection'),(178,'114','2010-09-28','14:45:00','1.50',0,0,'Setup DLink router\r\nSwitched off dlink wireless\r\nTested wireless at parlour\r\nSetup wireless on Carols Laptop\r\nSetup pinnacle email in outlook'),(177,'114','2010-09-27','14:00:00','0.50',0,0,'Downloaded DLink software for router\r\nAttempted to reprogram DLink'),(180,'115','2010-09-29','11:00:00','3.25',0,0,'Called Dairy Plan support\r\nInstalled Quickbooks on house PC\r\nCalled quickbooks to register software\r\nSetup quickbooks data files\r\nSetup Carols gmail on Pinnacle user\r\nCopied outlook folders to Pinnacle user\r\nSetup firstpinnaclefinancial.com on blackberry\r\nSetup outlook on carols laptop\r\nCopied outlook folders to carols laptop\r\nSetup quickbooks on Bevs Laptop\r\nSetup FTP server for Dairy Comp\r\nSetup synchronization for FTP'),(181,'116','2010-09-25','20:15:00','0.50',0,0,'Connected to PC to check email settings\r\nTested email settings online\r\nTested email settings on laptop\r\n'),(182,'117','2010-10-01','14:15:00','1.00',0,0,'Purchased Portable Hard Disk\r\nTested old hard disk\r\nSetup backups\r\nTested backups'),(183,'118','2010-10-04','14:30:00','0.50',0,0,'Updated content on investment funds\r\nUpdated content on corporate services\r\nUpdated content on corporate & commercial\r\nUpdated content on capital markets & structured finance\r\nUpdated content on private equity\r\nUpdated content on project finance\r\nUpdated content on banking and asset finance\r\nUpdated content on insurance\r\nUpdated content on regulatory and financial services'),(184,'118','2010-09-28','17:15:00','0.50',0,0,'Created new page for Community\r\nCreated new menu item for Community\r\nEdited News page\r\nCreated PDFs'),(185,'118','2010-10-05','14:00:00','0.08',0,0,'Removed link from News page\r\nUploaded Community PDFs'),(186,'119','2010-10-06','16:00:00','0.50',0,0,'Edited Simply Accounting Report\r\nTested Backup\r\nChanged backup drive letter'),(187,'120','2010-10-06','09:30:00','1.00',0,0,'Installed updates on Garage PC\r\nInstalled Service pack 3\r\nInstalled Spam Filter\r\nInstalled updates on Laptop\r\nInstalled spam filter'),(188,'121','2010-10-06','11:00:00','3.00',0,0,'Uninstalled PowerDesk Pro\r\nInstalled Power Desk Pro\r\nCalled IHA Support\r\nInstalled Service Pack 1\r\nInstalled Remote Desktop\r\nLogged into IHA\r\nSetup scanner to share files\r\nChanged screen saver settings in exam room\r\nPurchased NOD32'),(189,'122','2010-09-21','09:30:00','0.50',0,0,'Made changes to site while on Phone with Pat'),(190,'122','2010-09-22','11:30:00','0.50',0,0,'Created PDF forms\r\nUploaded to server\r\nCreated Categories 2009 page\r\nCreated Categories 2010 page'),(191,'122','2010-10-28','19:00:00','0.25',0,0,'Created and linked Fair Resources page\r\nChanged intent form date\r\nChanged site form links'),(192,'122','2010-10-29','14:30:00','0.08',0,0,'Edited Intent Form\r\nChanged site links'),(193,'122','2010-10-06','10:00:00','0.08',0,0,'Changed Date on student form\r\nAdded links to stamp forms on education page'),(195,'123','2010-10-04','10:00:00','6.00',0,0,'Created site graphics\r\nCreated site template\r\nCreated internal pages\r\nCreated contact page'),(196,'124','2010-10-05','10:00:00','8.00',0,0,'Created site design\r\nCreated internal pages\r\nCreated services pages\r\nCreated contact form'),(197,'125','2010-10-08','10:00:00','0.16',0,0,'Removed text from home page\r\nAdded text to home page'),(198,'126','2010-09-27','08:30:00','10.00',0,0,'Looked after business for 10 business days'),(199,'121','2010-10-13','13:00:00','1.50',0,0,'Networked C drive\r\nSetup Canon Printer\r\nShared Printers\r\nSetup Scanner'),(200,'127','2010-10-06','10:00:00','0.16',0,0,'Created image for Storage on home page'),(201,'128','2010-10-14','15:30:00','1.00',0,0,'Upgraded to Office Student 2003\r\nUninstalled Live Toolbar\r\nChecked word settings\r\nTested template\r\nChecked memory settings'),(202,'35','2010-10-15','10:30:00','0.00',2,30,'test'),(203,'129','2010-10-13','08:30:00','0.00',1,0,'Updated wireless driver\r\nReinstalled wireless software\r\nTested laptop with other wireless card\r\nChanged USB wireless settings'),(204,'130','2010-10-20','13:30:00','0.00',2,0,'Ran Vista startup repair\r\nBacked up user data\r\nReinstalled Vista\r\nRan updates'),(205,'130','2010-10-21','09:30:00','0.00',1,0,'Installed Shaw Security on laptop and Desktop\r\nSetup user account\r\nSetup email in all user account\r\nChanged wireless password\r\nChanged wireless password on iPod's'),(206,'131','2010-10-22','10:30:00','0.00',0,0,'Restored windows to previous day\r\nInstalled memory\r\nRemoved startup items'),(207,'132','2010-10-27','15:00:00','0.00',1,45,'Setup info email at 4 seasons storage\r\nSetup accounting email and tested printer\r\nTested norm.cross email at Fenders\r\nSetup network drives on 2 PC\'s\r\nShared reception printer\r\nConnected tablet to netowrk\r\nTested tablet remote desktop'),(211,'35','2010-10-29','09:30:00','0.00',2,30,'new test'),(212,'133','2010-11-01','09:30:00','0.00',3,0,'Tested email\r\nInstalled laser printer\r\nSetup scanning\r\nShared printer to office PC\r\nSetup computers to share Simply Accounting\r\nSetup user account in simply accounting\r\nInstalled Adobe Reader\r\nRemoved user accounts from Workshop PC\'s\r\nSetup new user on server\r\nTested network connections\r\nSetup email accounts\r\nSetup and tested email account on Blackberry'),(209,'132','2010-10-28','14:30:00','0.00',3,0,'Setup remote desktop on PC\r\nTested remote desktop on tablet\r\nSetup users on shop PC\'s\r\nSetup network drives on shop PC\'s\r\nSetup printer\r\nSetup Outlook on 4 PC\'s\r\nTested emails'),(213,'135','2010-10-15','14:00:00','0.00',1,0,'Contacted Garmin about Mobile PC compatibility\r\nContacted Backroads about compatibility\r\nRegistered and posted question on LaptopGPSworld.com'),(214,'135','2010-10-18','14:00:00','0.00',1,0,'Installed Garmin Mobile PC\r\nTested with Backroads\r\nContacted LaptopGPSworld'),(215,'135','2010-10-28','09:00:00','0.00',1,0,'Installed DVD version of Backroads\r\nTransferred maps to mobile PC\r\nTested Mobile PC'),(216,'136','2010-10-26','09:00:00','0.00',1,0,'Setup pvmtc email on all PC\'s\r\nTested email'),(217,'136','2010-10-29','09:00:00','0.00',0,45,'Tested email settings\r\nChecked phone system for hold music compatibility'),(218,'137','2010-10-14','12:00:00','0.00',3,0,'Edited logo graphics\r\nCreated flash logo\r\nUploaded and tested'),(227,'143','2010-01-13','09:30:00','0.00',4,0,'Initial design and build'),(223,'140','2010-11-08','12:45:00','0.00',0,45,'Connected printer to computer\r\nTested scanner\r\nEdited Simply Accounting Invoice'),(224,'136','2010-11-03','09:00:00','0.00',1,0,'Created new Outlook file for managing tasks\r\nShared task file on all PC\'s\r\nCreated share on all PC\'s for HTP form'),(225,'136','2010-11-03','14:30:00','0.00',1,0,'Created HTP report forms '),(226,'142','2010-11-04','09:30:00','0.00',1,30,'Added new Cross Fit graphics\r\nRecreated movie at 250 pixels high'),(222,'139','2010-10-21','09:30:00','0.00',0,30,'Uploaded files\r\nCreated and tested contact form'),(228,'143','2010-01-13','09:30:00','0.00',3,0,'Creation of banner images '),(229,'143','2010-01-13','09:30:00','0.00',1,0,'Creation of plan images '),(230,'143','0000-00-00','11:45:00','0.00',1,0,'Customizing of contact page'),(231,'143','2010-01-13','12:00:00','0.00',2,0,'Creation of Coupon Site Template '),(232,'144','2010-01-13','09:15:00','0.00',6,0,'Initial design and build'),(233,'144','2010-01-13','09:30:00','0.00',2,0,'Editing of images'),(234,'144','2010-01-13','09:45:00','0.00',2,0,'Creation of remaining pages'),(235,'144','2010-01-13','10:00:00','0.00',2,0,'Paypal intergration into pricing page'),(236,'145','2010-01-13','09:30:00','0.00',2,0,'Office Phone Support between Nov 5th – 23rd '),(237,'146','2010-01-28','09:30:00','0.00',2,0,'Updates and changes to site'),(240,'147','2010-01-28','09:30:00','0.00',0,30,'Installed memory and Graphics Card'),(239,'146','2010-01-28','09:45:00','0.00',1,0,'Paypal shipping calculations'),(241,'148','2010-02-05','09:30:00','0.00',1,0,'Created template of home page'),(242,'148','2010-02-05','09:45:00','0.00',1,0,'Created template or inner pages'),(243,'149','2010-02-05','09:30:00','0.00',1,0,'Edited and cropped images for header '),(244,'149','2010-11-05','09:30:00','0.00',1,0,'Created site template'),(245,'150','2010-11-08','10:30:00','0.00',1,0,'Tested remote desktop on tablet\r\nTested printer\r\nTested email\r\nSetup printer in office\r\nInstalled colour printer at 4 Seasons Storage'),(246,'151','2010-11-18','09:30:00','0.00',9,0,'Edited site graphics\r\nCreted site template\r\nCreated internal pages\r\nCreated contact, feedback and staging forms'),(247,'152','2010-11-19','09:30:00','0.00',0,30,'Edited shop page\r\nChanged Paypal button'),(248,'153','2010-11-18','09:30:00','0.00',2,0,'Created Site template\r\nEdited site graphics\r\nCreated flash movie'),(249,'154','2010-11-16','09:30:00','0.00',1,30,'Assessed network problems\r\nTested computer connections\r\nChanged over to old switch\r\nTested computer networking'),(250,'154','2010-11-18','11:00:00','0.00',2,45,'Installed new switch\r\nTested network\r\nInstalled new router\r\nTested network on all PC\'s\r\nSetup picture storage disk'),(251,'155','2010-11-11','09:00:00','0.00',1,0,'Tested quickbooks\r\nChanged printer settings\r\nTested Hamachi\r\nCalled shaw about internet problems'),(252,'155','2010-11-16','13:00:00','0.00',3,0,'Meeting with Dairy Comp'),(253,'156','2010-11-04','09:00:00','0.00',1,30,'Re positioned Laptop\r\nTested printer\r\nSetup Skype\r\nTested web-cam\r\nHelped edit website\r\nSetup email address'),(254,'157','2010-11-17','09:30:00','0.00',1,0,'Installed wireless router\r\nInstalled keyboard and mouse\r\nChanged printer ink\r\nTested printer'),(255,'155','2010-11-24','10:45:00','0.00',1,0,'Networked Dairy Plan\r\nTested printer\r\nTested Hamachi'),(256,'155','2010-11-25','09:00:00','0.00',0,45,'Tested Hamachi\r\nTested Time Force\r\nTested and changed fax settings'),(257,'158','2010-11-24','15:15:00','0.00',0,15,'Supported Johnal over phone about computer freezing'),(258,'158','2010-11-25','10:00:00','0.00',1,30,'Removed startup items\r\nConfigured outlook archiving\r\nInstalled Skype\r\nRe-Installed Internet Explorer on Gord\'s PC\r\n'),(259,'159','2010-11-03','16:30:00','0.00',1,0,'Checked inside reception PC for dirt\r\nChecked Virus settings on all PC\'s\r\nTested reception network connection'),(260,'159','2010-11-18','15:00:00','0.00',1,30,'Tested network\r\nInstalled new router\r\nChanged Lisa\'s network settings\r\nCalled support for help on Tag Registry software\r\nChanged software settings'),(261,'159','2010-11-11','09:30:00','0.00',0,30,'Tested network\r\nCalled Advantage support\r\nChanged network settings'),(262,'155','2010-11-25','16:30:00','0.00',0,15,'Changed firewall settings\r\nTested Hamachi'),(263,'155','2010-11-18','17:00:00','0.00',0,30,'Installed Dairy Comp at Creekside Animal Clinic'),(264,'158','2010-11-26','09:15:00','0.00',4,0,'Performed Backup on PC\r\nVisited Staples\r\nVisited Futureshop\r\nRemoved programs\r\nSetup Office 2007\r\nSetup Simply Accounting\r\nInstalled Norton 360\r\nInstalled printer and scanner\r\nConfigured Outlook'),(265,'158','2010-11-29','09:45:00','0.00',0,30,'Installed Ultra VNC\r\nHelped Kevin connect through Teamviewer'),(266,'160','2010-10-12','12:30:00','0.00',1,0,'Deleted print queue\r\nReinstalled print service\r\nChanged IP address\r\nTested printer\r\nTested scanner'),(267,'161','2010-10-08','09:30:00','0.00',0,30,'Created banner\r\nCreated map\r\nEdited banner details'),(268,'162','2010-11-25','13:30:00','0.00',1,0,'Created Tirecraft banner\r\nMade banner visible on all pages\r\nCreated spot ad for Interior Recycling\r\nUploaded parade form'),(269,'163','2010-11-29','10:00:00','0.00',1,0,'Created site sponsor images\r\nUploaded images to site\r\nChanged sponsorship pages'),(270,'164','2010-11-30','10:30:00','0.00',0,45,'Edited graphics on Tirecraft banner\r\nCreated and uploaded Okanagan Restoration spot ad'),(271,'165','2010-11-29','14:45:00','0.00',1,0,'Reinstalled Explorer\r\nCleaned computer\r\nCleaned registry\r\nInvestigated update problem\r\nRemoved .NET framework 1.1'),(272,'166','2010-11-30','09:30:00','0.00',10,0,'Created site design\r\nCreated site graphics\r\nCreated flash movie\r\nCreated internal pages\r\nCreated contact form'),(273,'167','2010-12-01','12:15:00','0.00',2,15,'Backed up documents and outlook\r\nInstalled new PC and upgraded to Pro\r\nInstalled office\r\nConfigured outlook\r\nSetup desktop and documents\r\nInstalled printer\r\nSetup shared folders'),(274,'168','2010-12-01','15:00:00','0.00',2,15,'Checked for network cable between offices\r\nSetup Mac in back office\r\nSetup and tested backup for Tim\r\nChanged email on iPhone'),(275,'169','2010-11-05','14:00:00','0.00',0,30,'Created new pages in Heritage Fair section\r\nChanged navigation'),(276,'170','2010-12-02','13:30:00','0.00',1,0,'Reinstalled Internet Explorer\r\nCleaned computer\r\nCleaned registry'),(277,'168','2010-12-03','11:30:00','0.00',3,30,'Tested cabling between offices\r\nTested Mac in back office\r\nSetup Doreen\'s PC in back office\r\nSetup printer\r\nPurchased NOD32 Security for Steve'),(278,'171','2010-12-03','09:00:00','0.00',1,30,'Monitored ticket sales online\r\nEdited Irish Pub night details\r\nChanged online ticket limits'),(279,'172','2010-12-06','11:00:00','0.00',0,30,'Connected remotely to PC\r\nRestarted Print Spool\r\nDeleted documents in print queue\r\nTested printer'),(280,'173','2010-11-01','09:30:00','0.00',4,0,'Purchased domain name\r\nCreated site template and graphics'),(281,'173','2010-11-18','09:30:00','0.00',2,0,'Implemented colour and graphic changes'),(282,'173','2010-11-22','09:30:00','0.00',2,0,'Created internal pages\r\nUploaded my work pdf\'s'),(283,'173','2010-12-06','09:30:00','0.00',2,0,'Created new menu\r\nChanged home page text\r\nUploaded testimonials'),(284,'168','2010-12-08','10:00:00','0.00',5,30,'Tested screens\r\nChecked Steve\'s backup\r\nTested Paul\'s network connection\r\nChanged Paul\'s network setting\r\nChecked junk mail settings\r\nMoved Brad\'s PC\r\nTrouble shot Brad\'s display issue\r\nDetermined graphics card\r\nBought and installed graphics card\r\nSetup dual display for Brad\r\nSetup email for Sharon\r\nInstalled Mac in office for Sharon'),(285,'175','2010-12-08','14:00:00','0.00',0,0,'Purchased hardware'),(286,'168','2010-12-10','10:00:00','0.00',4,30,'Tested Mac and researched reinstall\r\nSetup email on Sharon\'s blackberry\r\nPurchased domain\r\nSetup laser printer on Ian\'s PC\r\nMoved laser printer in back office\r\nInstalled network card\r\nTested Paul\'s network connection\r\nMoved shared folder to PC\r\nSetup share on Paul\'s PC\r\nResearched for PDF converter'),(287,'176','2010-12-09','13:30:00','0.00',1,0,'Changed Samsung software settings\r\nChanged router port settings\r\nTested ports\r\nCalled Linksys support'),(288,'177','2010-12-13','13:00:00','0.00',1,0,'Tested fax\r\nTested internet\r\nCalled Telus'),(289,'177','2010-12-14','14:00:00','0.00',3,0,'Installed new router\r\nTested network on all PC\'s\r\nChecked printer on all PC\'s\r\nConnected Lisa\'s laptop to network\r\nSetup Advantage on Laptop\r\nCalled advantage support\r\nCopied new install files to CD\r\nInstalled Norton'),(290,'177','2010-12-15','08:30:00','0.00',1,0,'Setup Epson printer\r\nShared printer on office PC\'s\r\nSetup printers on laptop'),(291,'178','2010-12-15','11:00:00','0.00',1,30,'Purchased PDF editor online\r\nEdited Sharon\'s email signature to link to email\r\nInstalled PDF editor on Edie\'s PC\r\nDemonstrated software to Edie\r\nSynced Bruce\'s iPhone'),(292,'165','2010-12-13','15:00:00','0.00',1,0,'Reinstalled Explorer\r\nChecked internet settings\r\nChanged firewall settings\r\nTested BMO program'),(293,'176','2010-12-13','14:30:00','0.00',0,30,'Called samsung\r\nChanged scanner settings\r\nTested scanner\r\n'),(294,'165','2010-12-16','14:00:00','0.00',0,30,'Tested program\r\nChanged firwall settings\r\nRestarted computer\r\nTested with no errors'),(295,'179','2010-12-17','12:00:00','0.00',1,0,'Installed email on PC\r\nInstalled printer on Sharon\'s PC\r\nChecked Tim\'s PC power button\r\nInstalled AVG on Brad\'s PC\r\nInstalled AVG on Joanne\'s PC'),(296,'180','2010-12-21','13:00:00','0.00',1,0,'Connected Steve\'s PC to network\r\nTransferred Sharon\'s email to outlook\r\nChanged network cabling'),(297,'176','2010-12-17','09:00:00','0.00',0,30,'Changed router port settings\r\nTested remote connection\r\nTransferred documents and emails to other user account\r\nTested scanner\r\n'),(298,'176','2010-12-20','12:15:00','0.00',0,0,'Connected to Lisa\'s PC\r\nTransferred favourites\r\nInstalled log me in\r\nTested remote access'),(299,'176','2010-12-22','11:00:00','0.00',0,0,'Checked Gord\'s PC\r\nDeleted cookies and temp internet files\r\nChecked files'),(300,'181','2010-10-22','09:30:00','0.00',1,30,'Created new site header\r\nRemoved images from menu'),(301,'181','2010-12-21','09:30:00','0.00',1,0,'Linked side items\r\nChanged header\r\nChanged wedding image\r\nAdded publish option to back end\r\nCarried changes to all pages'),(302,'180','2010-12-23','09:30:00','0.00',2,0,'Changed network\r\nRestarted router\r\nChanged cabling\r\nRestarted switch\r\nTested backup\r\nSetup signatures\r\nPurchased Shastaproperties.ca\r\nSetup email on server'),(303,'182','2010-12-20','09:30:00','0.00',6,0,'Created site graphics and recreated template'),(304,'182','2010-12-21','09:30:00','0.00',3,0,'Created site internal pages'),(305,'182','2010-12-22','09:30:00','0.00',1,0,'Created Paypal button\r\nIntergrated and test on website'),(306,'183','2010-12-23','09:30:00','0.00',3,0,'Created site graphics and design'),(307,'183','2010-12-24','09:30:00','0.00',3,0,'Created site template and internal pages'),(308,'183','2010-12-24','09:30:00','0.00',2,0,'Created internal pages and contact page'),(309,'184','2010-12-09','09:30:00','0.00',0,45,'Created application PHP form'),(310,'185','2010-12-30','09:30:00','0.00',2,15,'Moved DLink switch to server room\r\nMoved 3com switch to back room\r\nRenewed Bruce\'s Anti Virus\r\nPurchased shastaproperties.ca'),(311,'185','2011-01-05','09:30:00','0.00',2,0,'Reapplied Sharon\'s email account\r\nReinstalled printer\r\nInstalled Blackberry software\r\nSynced blackberry\r\nReinstalled backup software\r\nAdded email account'),(312,'186','2010-12-27','10:00:00','0.00',1,30,'Called on Skype\r\nConnected to PC remotely\r\nHelped configure Joomla\r\nEdited articles\r\nInserted Paypal button code\r\nTested newsletter\r\n'),(313,'187','2011-01-05','09:30:00','0.00',3,0,'Created Flash Animation'),(314,'187','2011-01-05','13:30:00','0.00',2,0,'Created site graphics and menu'),(315,'187','2011-01-05','15:30:00','0.00',3,0,'Created internal pages and contact page'),(316,'188','2011-01-10','10:30:00','0.00',1,0,'Tested network connections\r\nConfigured network IP address\r\nUninstalled sound driver\r\nUpdated sound driver\r\nTested sound'),(317,'189','2011-01-19','16:00:00','0.00',1,45,'Removed Ad Aware\r\nCleaned PC clutter\r\nUpdated Spybot\r\nChanged date on Fax\r\nChanged confirmation settings\r\nCopied music to laptop\r\nImported music into iTunes'),(318,'190','2011-01-18','09:30:00','0.00',1,0,'Tested DVD drive\r\nInstalled Norton Internet Security\r\nUpdated Norton'),(319,'191','2011-01-17','09:30:00','0.00',1,15,'Uninstalled Java on Doug\'s PC\r\nInstalled latest Java\r\nTested online site\r\nTested 4 seasons network\r\nTested accounting program\r\nSetup email address'),(320,'191','2011-01-19','10:00:00','0.00',0,15,'Connected remotely to test email'),(321,'192','2011-01-10','13:30:00','0.00',1,15,'Tested Sharon\'s email\r\nSetup Doreen\'s email\r\nHelped Brad with Nitro PDF install problem'),(322,'193','2011-01-06','14:00:00','0.00',0,30,'Added programs to Shaw security\r\nTested program'),(323,'193','2011-01-10','15:00:00','0.00',1,0,'Uninstalled Shaw security\r\nDownloaded and installed NOD32\r\nUpdated Antivirus\r\nTested programs'),(324,'194','2011-01-27','10:00:00','0.00',1,0,'Tested laptop connections\r\nInstalled wireless card\r\nConnected to office wireless\r\nUpdated security'),(325,'195','2011-01-11','09:30:00','0.00',0,30,'created ad 230x480'),(326,'195','2011-01-20','09:30:00','0.00',0,30,'created ad 700x100'),(327,'196','2011-01-19','13:00:00','0.00',1,0,'Moved PC under desk\r\nMoved scanner to front desk\r\nSetup profiles\r\nTested scanner'),(328,'194','2011-01-21','14:00:00','0.00',0,30,'Made changed to master template'); /*!40000 ALTER TABLE `visits` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `vmarticles` -- DROP TABLE IF EXISTS `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` -- LOCK TABLES `vmarticles` WRITE; /*!40000 ALTER TABLE `vmarticles` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `vmarticles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `vmimages` -- DROP TABLE IF EXISTS `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` -- LOCK TABLES `vmimages` WRITE; /*!40000 ALTER TABLE `vmimages` DISABLE KEYS */; INSERT INTO `vmimages` VALUES (1,'Portrait of Sophie (Johnson) Ellison who became Vernon'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'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 & 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 & 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 & 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, & 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 & Co. Engine & 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'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'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'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 & 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's Capitol Theatre and accompanying National Café building on 30 Avenue.','THEATRE, BARNARD','2010-04-22','Vernon','','1930'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 & 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'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' 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'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'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's first Hudson'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's Studio','1965','1132','1132.jpg'),(120,'Aerial view of the businesses at the east end of Vernon'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'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'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 & Carswell'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'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'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'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'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,''Soldiers of the Soil' 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) 'Jack' 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's','3137','3137.jpg'),(182,'View of the Carswell and Johnston'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'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'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'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 'Sentimental Sally'.','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'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's Hardware; Vernon Photo Co.; Post Office; Campbell House and Megaw'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'Keefe ranch house.','O'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'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 & 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's Candy Kitchen, located at 3017-30th Avenue, Vernon.','STORE, NICK'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 '76 Gasoline'.','HOCKEY, SPORTS','2010-04-22','Vernon','Le Blond','1934','3814','3814.jpg'),(216,'Formal portrait of F.J. Barnard, one of the "builders of British Columbia".','BARNARD','2010-04-20','Vernon','','1885','3820','3820.jpg'),(217,'Four men beside the skeleton of the single engine airplane 'City of Vernon' 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'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'Keefe, McDonnell and O'Neal children on a raft at Kalamalka Lake. Left to right: Alice O'Neal, Sam O'Neal, Lawrence McDonnell, Betty O'Neal, Margaret O'Keefe, Leslie McDonnell, Genie O'Neal, Tierney O'Keefe and Geraldine O'Neal.','O'NEAL, O'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's Garage Dodge display at the 1949 Industrial Exposition.','GARAGE, SHILLAM','2010-04-21','Vernon','Kermode'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 'City of Vernon' 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'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'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' 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 & Wilson's Okanagan Livery, Feed & 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'Keefe.','O'KEEFE','2010-04-27','Vernon','','1895','5042','5042.jpg'),(252,'View of St. Michael's Girls' 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 & 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's Studio','1950','5717','5717.jpg'),(261,'Vernon crowds enjoying the midway of the visiting Barnum & 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'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 & 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'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 'The Geisha', at Vernon'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'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 & 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'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 "mark" 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'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 "San Souci" summer camp at Husband'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'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'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'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'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'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's Ltd.','CANNERY','2010-05-04','Vernon','Ribelin','1936','16583','16583.jpg'); /*!40000 ALTER TABLE `vmimages` ENABLE KEYS */; UNLOCK TABLES; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;