-- MySQL dump 10.11 -- -- Host: localhost Database: aoty_nwka -- ------------------------------------------------------ -- Server version 5.0.45 /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 `catches` -- DROP TABLE IF EXISTS `catches`; CREATE TABLE `catches` ( `id` int(10) unsigned NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `species_id` int(11) NOT NULL default '0', `length` double NOT NULL default '0', `date` date NOT NULL default '0000-00-00', `image` varchar(255) NOT NULL default '', `image2` varchar(255) NOT NULL default '', `image3` varchar(255) NOT NULL default '', `notes` text NOT NULL, `created_at` datetime NOT NULL default '0000-00-00 00:00:00', `updated_at` datetime NOT NULL default '0000-00-00 00:00:00', `state` varchar(255) default NULL, PRIMARY KEY (`id`), KEY `date` (`date`) ) ENGINE=MyISAM AUTO_INCREMENT=88 DEFAULT CHARSET=latin1 PACK_KEYS=0; -- -- Dumping data for table `catches` -- LOCK TABLES `catches` WRITE; /*!40000 ALTER TABLE `catches` DISABLE KEYS */; INSERT INTO `catches` VALUES (10,5,8,14.5,'2008-02-17','lkwsh3_021708.jpg','lkwsh4_021708.jpg','','Coastal Cutty caught at Lake Washington on the downrigger.','2008-02-17 19:40:20','2008-02-28 19:08:17','WA'),(11,8,6,29.5,'2008-03-30','3_30_08_springer.jpg','29_point_5_inches.jpg','','Multnomah Channel Springer.','2008-03-30 17:25:34','2008-03-30 17:25:34','OR'),(12,6,1,23,'2008-04-01','img_0025.jpg','img_0029.jpg','img_0027.jpg','This was the second of three lings landed.The first was 21 inches and the third was 21.5. Caught on a 4 inch root beer scampy.','2008-04-01 14:53:08','2008-04-05 22:50:15','OR'),(15,12,8,18,'2008-04-12','fam___fish_020.jpg','fishing_pictures_001.jpg','fishing_pictures_003.jpg','Fished Rufus with my daughter and friend Steve. Steve hooked a couple in the 20-21\" range, handing the rod to Janni. I landed the 18\" and maybe 20 smaller fish. We brought home 5 fish with a total weight of ~20lbs','2008-04-13 01:37:42','2008-04-13 01:40:40','WA'),(13,6,2,14,'2008-04-01','img_0029.jpg','','','Tasty little Black Cod. ','2008-04-01 14:57:03','2008-04-01 16:06:35','OR'),(14,6,2,13,'2008-04-01','img_0028.jpg','','','Another little Black Snapper. Caught on a 3 or 4 inch rootbeer colored jig.','2008-04-01 23:10:18','2008-04-01 23:10:18','OR'),(16,10,6,31,'2008-04-14','p1000297.jpg','p1000290.jpg','p1000299.jpg','Multnomah Channel about 90 minutes following low tide. She struck as soon as soon I hit the clear water, not even as far as the Gilbert River. I only spent 5 minutes on the river!!!','2008-04-14 17:28:02','2008-04-14 17:28:02','OR'),(17,6,2,16,'2008-04-16','img_0033.jpg','','','Black Snapper caught on a red scampy.','2008-04-16 14:19:03','2008-04-16 14:19:03','OR'),(18,11,8,11,'2008-04-20','p4200028.jpg','','','Extreme homesickness for his hatchery dorm room, caused this sad, little depressed fish to impale himself upon my \"Wedding Ring\" at Hagg Lake. Alas his sacrifice is my gain. \r\n\r\nAlthough, somehow the rigid bugger shrank 1/8\" by the time I photographed him. Hopefully he will soon be replaced by a decent size fish, but at least I\'m on the board.','2008-04-20 20:00:31','2008-04-20 20:00:31','OR'),(19,1,8,10.8,'2008-04-20','img_4387.jpg','img_4384.jpg','','Finally on the AOTY board with a little dink of a planter trout from Henry Hagg Lake. It and it\'s four buddies where all caught trolling a green wedding ring tipped with some night crawler. ','2008-04-21 14:35:59','2008-04-21 14:39:40','OR'),(20,6,2,17,'2008-04-25','img_0038.jpg','img_0036.jpg','','Good day for Black Snapper. Caught ten +, kept five. Lost a ton. Great day on the ocean.','2008-04-25 17:52:34','2008-04-25 17:52:34','OR'),(21,12,11,10.5,'2008-05-04','fishing_pictures_002.jpg','','','Janni and I went to Patterson yesterday and today. Yesterday was cold breezy and wet. Good trout weather, but no panfish. Today was warm- shorts, sandals and a t-shirt, and finally a few perch. Used mini jigs in 12-15\' of water.','2008-05-04 20:50:12','2008-05-04 20:50:12','WA'),(22,12,10,10,'2008-05-19','fishing_pictures_016.jpg','fishing_pictures_015.jpg','','Janni and I spent about an hour and a half being blown around Leader Lake, this afternoon.\r\n\r\nWe did some casting and trolling with mini jigs, small swimbaits and a Rapala. Picked up a few small bluegills, rainbows and a handful of small LMB. All LMB were between 9 and 10 inches. It is sad that this little bugger gives me such a lead!\r\n\r\nIn the recent past, this lake was good for SMB- interesting how the LMB population seems to have exploded.','2008-05-19 01:02:41','2008-05-19 01:02:41','WA'),(23,8,8,10.5,'2008-05-18','10.5.jpg','10.5_in_yak.jpg','','Hagg Lake, 5/18/08.\r\nFamily picnic with the yaks.\r\nGood times!','2008-05-19 01:07:54','2008-05-19 01:07:54','OR'),(24,11,11,11.25,'2008-05-30','p5300147.jpg','','','Pulled a couple of Crappie\'s out of the wood pile accross from the launch, suprisingly this guy was pretty good size compared to the others. I share that spot as there were about a dozen folks fishing it when I left. Picture sux, but you can see the ruler at the bottom.','2008-05-31 11:25:34','2008-05-31 11:25:34','OR'),(25,3,8,30,'2008-05-31','lakersize.jpg','lakerhead.jpg','lakeronwater.jpg','9 pound 4 ounce Laker caught on a Kwikfish','2008-05-31 20:22:43','2008-05-31 20:22:43','WA'),(26,11,9,12.25,'2008-05-31','p5310153.jpg','','','Darn, should have removed my secret weapon from this Smallie before taking the picture. He thought he was so smart for ambusing my Rapala I was dragging by a submerged dock, guess I showed him. You too can catch him, he\'s still swimmin around Cedar Oak Island near West Linn. ','2008-05-31 20:39:15','2008-05-31 20:39:15','OR'),(27,8,1,25,'2008-05-31','ling_1.jpg','ling_2.jpg','','8 for 12 kept 2. She aint pretty but she sure tasted good!','2008-06-01 11:30:43','2008-06-01 11:30:43','OR'),(28,8,2,20.5,'2008-05-31','blackie_1.jpg','blackie_2.jpg','','Caught trolling an 8\" twin tail jig (White)','2008-06-01 11:33:34','2008-06-01 11:33:34','OR'),(29,15,1,25,'2008-05-31','kayak_fishing_021.jpg','','','Caught on a speckled root beer jig','2008-06-02 01:15:34','2008-06-02 01:15:34','OR'),(30,15,2,21,'2008-05-31','kayak_fishing_019.jpg','','','another one that likes root beer','2008-06-02 01:21:33','2008-06-02 01:21:33','OR'),(31,6,2,19,'2008-06-02','img_0065.jpg','img_0066.jpg','','big fat black caught at Sunset on a 4 inch root beer scampi.','2008-06-02 16:46:10','2008-06-02 16:46:10','OR'),(33,6,8,19.25,'2008-06-06','img_0070.jpg','img_0071.jpg','','nice 19 inch brooder caught trolling at Upper Empire Lake in Coos Bay on a small size gold colored blue fox. Also caught an 18 incher and a 10 incher that was gut hooked so i couldn\'t release it.','2008-06-06 17:44:55','2008-06-06 17:44:55','OR'),(34,15,8,12,'2008-06-08','kayak_fishing_023.jpg','kayak_fishing_024.jpg','','Fished Lake Langlois today, caught one 11 inches, then 12 inches with the fly pole. Switched gear to fish deep for the biggns... Nothing. Back to the fly rod and hooked many 8 to 10 inches. Let them go to grow','2008-06-08 19:20:50','2008-06-08 19:20:50','WA'),(35,5,9,17.5,'2008-06-14','061408_smallie.jpg','061408_smallie2.jpg','','Personal best smallie caught on the infamous \"Fat Pepper\" crank. Lake, Wa','2008-06-14 22:47:01','2008-06-21 17:22:26','WA'),(36,12,11,11.5,'2008-06-15','fishing_pictures_049.jpg','','','Fished Patterson Lake, for Father\'s Day. Tried bassing, and was drop shotting a 4\" worm when \"Perchzilla\" hit. Thought for sure I had a good SMB, until it hit the net. Last year, I caught a 14\"er, so I may be able to upgrade, yet.','2008-06-17 01:34:50','2008-06-17 01:34:50','WA'),(37,6,1,26,'2008-06-17','img_0075.jpg','img_0076.jpg','img_0072.jpg','Awesome day fishing at Sunset.A 25 and 26 inch Ling and 6 blacks in two hours.Limits baby!! crappy pics but you get the idea.','2008-06-17 15:23:04','2008-06-17 15:23:04','OR'),(38,15,11,6.5,'2008-06-19','kayak_fishing_025.jpg','','','Got out for an evening paddle. Launched at Idylwoood beach park on Lake Sammamish. The plan was to catch a decent size panfish then switch over to bass. the best I could do was 6.5 inch bluegill.','2008-06-19 01:00:18','2008-06-19 01:00:18','WA'),(39,6,1,27.5,'2008-06-19','img_0082.jpg','img_0083.jpg','','A fat lingcod that i was sure had to be30 inches when i was on the water, but it was only 27.5. ','2008-06-19 15:38:28','2008-06-19 15:38:28','OR'),(40,5,2,13,'2008-06-20','copper_0621.jpg','copper2_0621.jpg','','Copper @ Edmonds on the TJW','2008-06-21 08:36:30','2008-06-21 08:36:30','WA'),(41,1,9,13,'2008-06-28','img_4423.jpg','','','Henry Hagg Lake, trolling shoreline with Rebel crawfish.','2008-06-28 18:24:47','2008-06-28 18:24:47','OR'),(42,1,10,11.25,'2008-06-28','img_4424.jpg','','','Henry Hagg Lake, 4\" Senko.','2008-06-28 18:30:38','2008-06-29 08:49:47','OR'),(43,1,11,4,'2008-06-28','img_4425b.jpg','','','Henry Hagg Lake mini-bluegill. My entry for lowest scoring AOTY fish.','2008-06-29 08:45:33','2008-06-29 08:45:33','OR'),(44,8,11,6,'2008-06-30','mc_perch.jpg','','','Monster Multnomah Channel Perch','2008-06-30 22:47:28','2008-06-30 22:47:28','OR'),(45,1,2,14.25,'2008-07-01','img_4428.jpg','','','Slow day out on the Northern Oregon coast. Eight hours of coho trolling and rockfishing and all I have to show for it is a 14 1/4\" black and a 15\" greenling.','2008-07-02 11:51:41','2008-07-02 11:51:41','OR'),(47,8,11,10.25,'2008-07-05','black_crappie.jpg','','','One of hundreds of crappie caught on a 1/32nd pearl crappie jig.','2008-07-07 11:05:38','2008-07-07 11:07:57','OR'),(48,8,8,13.75,'2008-07-04','13.75_inch_trout.jpg','','','Got lucky and picked this one up flat lining a worm durring a break in the wind.','2008-07-07 11:09:29','2008-07-07 11:09:29','OR'),(49,8,9,14,'2008-07-03','14inch_smallmouth.jpg','','','Caught on a crappie jig off a rock wall at sunset.','2008-07-07 11:10:37','2008-07-07 11:10:37','OR'),(50,15,10,17,'2008-07-07','kayak_fishingcullaby_009.jpg\n','','','While waiting for the coast winds to calm. fished cullaby lake Monday evening. First cast with a spinnerbait landed this nice largemouth.','2008-07-08 11:26:13','2008-07-08 11:26:13','OR'),(51,12,9,17.5,'2008-07-06','fishing_pictures_181.jpg','fishing_pictures_180.jpg','','On Sunday the 6th, went down to Brewster, on the Columbia, for summer kings. Still too early- I didn\'t see any caught. Didn\'t help that my FF went TU.\r\n\r\nDid catch a couple of smallies for consolation. Dragged a deep diving Rapala past a rocky point. The SMB were stationed along the current seam. The bigger one was 17.5\" and the other was 14\".','2008-07-09 09:32:28','2008-07-09 09:32:28','WA'),(52,6,9,11.5,'2008-07-10','img_0094.jpg','img_0095.jpg','','fiesty little red eyed devil.Caught an the Umpqua using an earthworm.','2008-07-10 23:45:42','2008-07-10 23:46:09','OR'),(53,5,11,9,'2008-07-13','sammish2.jpg','','','bookmark Perch @ Samammish. Will need to be upgrading... ','2008-07-13 02:49:13','2008-07-13 02:49:13','WA'),(54,10,8,12.5,'2008-07-21','p1000314.jpg','','','Trask River tidewater, trolling a Bob Toman spinner. Not impressive but it\'s on the board...','2008-07-21 23:45:42','2008-07-21 23:45:42','OR'),(55,5,6,8.5,'2008-07-25','micronook.jpg','','','I call this one the \"micro-nook\"! :)\r\n\r\nWhen Bsteves started this smallest of each species, I had to enter this one. He went for a spoon almost the same size as him. Of course, released safe n\' healthy to grow to a nice 40#\'s!','2008-07-26 13:49:56','2008-07-26 13:56:54','WA'),(57,10,9,14,'2008-07-28','p1000317.jpg','','','Smallie (I believe) from Willamette River near Newberg using bobber and nightcrawler.','2008-07-28 01:06:04','2008-07-28 01:06:04','OR'),(58,10,11,7,'2008-07-28','p1000319.jpg','knife.jpg','','Bluegill from Williamette River near Newberg on small floating Rapala minnow.','2008-07-28 01:07:43','2008-07-28 01:56:29','OR'),(59,5,6,24,'2008-08-17','81608_2.jpg','81608_1.jpg','','Ebay chinook on the downrigger. Fell for the power hoochie behind a hot spot UV flasher.','2008-08-17 17:30:39','2008-08-17 17:46:13','WA'),(60,12,2,13.5,'2008-08-19','fam___fish_136.jpg','fam___fish_137.jpg','fam___fish_133.jpg','We spent 8/16-8/20 on Lopez, in the San Juans. Caught a few crabs, a few rockies and a kelp greenling. No salmon, but plenty of dogfish.','2008-08-23 07:08:35','2008-08-23 07:08:35','WA'),(65,15,11,9.5,'2008-09-06','yellow_perch_l._samm..jpg','','','Lake Sammamish South end. biggest of about 100. all caughton a 1/8 oz jig.','2008-09-06 16:53:10','2008-09-06 16:53:10','WA'),(64,6,6,22.5,'2008-09-05','picture_096.jpg','picture_097.jpg','','My first yak caught \'nook. Caught at the marshfield channel on the Coos River. Caught with a no. 5 blue fox orange body spinner.','2008-09-05 16:22:49','2008-09-05 16:22:49','OR'),(62,10,6,35,'2008-08-25','jtp2008-08-25_6.jpg','jtp2008-08-25_5.jpg','','35in hen going upriver right around high tide using a Brad\'s Wobbler (thanks to Spot for the lure ID)','2008-08-25 20:25:11','2008-08-25 20:25:26','OR'),(63,15,5,28.75,'2008-08-29','bouy_10_coho_01.jpg','bouy_10_coho_02.jpg','bouy_10_coho_03.jpg','A nice Coho Couple from B10. Spinners.','2008-08-29 18:49:11','2008-08-29 18:49:11','OR'),(66,10,11,8,'2008-09-08','jtp2008-09-08_10.jpg','','','One of 2 perch caught at Silver Lake, Cowlitz County\r\n\r\n8SEP08','2008-09-08 23:32:33','2008-09-08 23:35:48','WA'),(69,5,10,7,'2008-09-10','imgp0773.jpg','','','Micro LMB... HA!','2008-09-11 00:44:06','2008-09-11 00:44:06','WA'),(70,6,10,8.5,'2008-09-11','picture_113.jpg','picture_114.jpg','','Cute little LMB. Caught on a Zoom baby brush hog, purple glitter.','2008-09-11 16:42:28','2008-09-11 16:42:28','OR'),(71,3,11,10.5,'2008-09-12','imgp1022.jpg','imgp1020.jpg','','Caught on a salt and pepper crappie jig tipped with a worm.','2008-09-12 14:37:31','2008-09-12 14:37:31','WA'),(72,6,11,7,'2008-09-12','picture_131.jpg','','','little perch caught at Ten Mile lake with a worm.','2008-09-12 16:38:02','2008-09-12 16:38:02','OR'),(73,8,10,10.5,'2008-09-14','largemouth_9_14.jpg','','','Caught trolling a crawdad crank bait at dawn','2008-09-14 20:53:36','2008-09-14 20:53:36','OR'),(74,8,9,15.5,'2008-09-14','smallmouth_9_14.jpg','','','Caught on the old faithfull, worm and splitshot.','2008-09-14 20:54:40','2008-09-14 20:54:40','OR'),(75,15,9,6.5,'2008-09-18','l.joy_sm_smb.jpg','','','fished lake joy for the first time. caught about 10 LMB (6-10inches)and only one SMB. I\'ll have to revisit. I\'ll have to try and imorove on this one.','2008-09-18 00:42:01','2008-09-18 00:42:01','WA'),(76,8,2,23.75,'2008-09-20','vermillion_full.jpg','vermillion_tail.jpg','eyeing_the_otolith.jpg','Tournament winning Vermillion Rockfish.\r\nCaught just after sunrise trolling a white 8\" Scampi with 4oz of lead.\r\n\r\nIn Image 3 Brian (bsteves) prepares to remove the otolith for an age assessment. This fish is older than some of the members here.','2008-09-21 20:57:00','2008-09-21 21:35:58','OR'),(77,15,6,30,'2008-09-21','coastal_chinook_002.jpg','','','North Coast Chinook caught on a rainbow spinner','2008-09-22 03:11:13','2008-09-22 03:11:13','OR'),(78,5,2,18,'2008-09-20','black.jpg','','','Black on the rootbeer scamp out at Pacific City.','2008-09-22 17:41:06','2008-09-22 17:41:42','OR'),(79,1,1,26,'2008-09-20','bstevesfish2.jpg','','','2nd place Pacific City Classic. Witnessed by everyone there.','2008-09-23 11:44:10','2008-09-23 11:44:10','OR'),(80,1,2,17.75,'2008-09-20','bstevesfish1.jpg','','','Chunky black caught during Pacific City Classic.','2008-09-23 11:44:57','2008-09-23 11:44:57','OR'),(81,3,2,20.25,'2008-09-19','imgp1038.jpg','imgp1039.jpg','','Black caught the day before the Pac City Classic','2008-10-01 10:46:56','2008-10-01 10:46:56','OR'),(82,5,2,19,'2008-09-21','black1.jpg','black2.jpg','','Pac City black on the rootbeer scampi.','2008-10-01 12:48:30','2008-10-01 12:48:30','WA'),(83,1,11,10.75,'2008-10-12','img_4494.jpg','','','Caught at Silver Lake WA on a small tube jig. ','2008-10-12 00:12:41','2008-10-12 00:12:41','WA'),(84,15,8,15.75,'2008-11-08','beaver_lake__2_.jpg','beaver_lake__1_.jpg','beaver_lake.jpg','Woke up and it wasn\'t raining, could resist trying to add some more AOTY points. Went out to Beaver Lake and cougt a couple of nice rainbows.','2008-11-08 21:58:34','2008-11-08 21:58:34','WA'),(86,8,13,51.75,'2008-11-27','11_27_08_jaba_gets_a_sturgeon.jpg','11_27_08_sturgeon_1.jpg','11_27_08_sturgeon_2.jpg','Happy Thanksgiving!\r\n\r\nCaught on pickled smelt and sandshrimp cocktail.','2008-11-27 16:39:35','2008-11-27 16:39:35','OR'),(87,12,8,20.5,'2008-11-29','fam___fish_011.jpg','fam___fish_012.jpg','fam___fish_014.jpg','Noggin Yakker and I fished the Rufus netpens, 11/29. Fishing was reported to be slow, but we found a pod and had multiple hookups. This one was 20.5\" and pushing 5#. They\'re ugly on the outside, but sure fillet nicely!','2008-11-30 22:12:30','2008-11-30 22:12:30','WA'); /*!40000 ALTER TABLE `catches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `schema_info` -- DROP TABLE IF EXISTS `schema_info`; CREATE TABLE `schema_info` ( `version` int(11) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `schema_info` -- LOCK TABLES `schema_info` WRITE; /*!40000 ALTER TABLE `schema_info` DISABLE KEYS */; INSERT INTO `schema_info` VALUES (1); /*!40000 ALTER TABLE `schema_info` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `species` -- DROP TABLE IF EXISTS `species`; CREATE TABLE `species` ( `id` int(10) unsigned NOT NULL auto_increment, `speciesname` varchar(50) NOT NULL default '', `points` double NOT NULL default '0', `logo` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1; -- -- Dumping data for table `species` -- LOCK TABLES `species` WRITE; /*!40000 ALTER TABLE `species` DISABLE KEYS */; INSERT INTO `species` VALUES (1,'Lingcod',4,'/images/lingcod.gif'),(2,'Rockfish/Cabezon/Greenling',7,'/images/vermillion.gif'),(5,'Coho and other salmon',5,'/images/coho.gif'),(6,'Chinook',4,'/images/chinook.gif'),(7,'Anadromous Trout',5,'/images/steelhead.gif'),(8,'Land-locked Trout',7,'/images/trout.gif'),(9,'Smallmouth Bass',9,'/images/smallmouth_bass.gif'),(10,'Largemouth Bass',8,'/images/largemouth_bass.gif'),(11,'Panfish/Surfperch/Walleye',10,'/images/panfish.gif'),(13,'Sturgeon',3,'/images/sturgeon.gif'); /*!40000 ALTER TABLE `species` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(11) NOT NULL auto_increment, `login` varchar(255) default NULL, `email` varchar(255) default NULL, `crypted_password` varchar(40) default NULL, `salt` varchar(40) default NULL, `created_at` datetime default NULL, `updated_at` datetime default NULL, `remember_token` varchar(255) default NULL, `remember_token_expires_at` datetime default NULL, `date_paid` date default NULL, `last_name` varchar(40) default NULL, `first_name` varchar(40) default NULL, `state` varchar(2) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'bsteves','bsteves@rocketmail.com','8dfe62911f6f90cb583bb8830ef87606c593b6f1','1bde0406b46004b01ab7103392cf160444436cc1','2007-03-30 23:57:00','2008-09-12 18:32:44',NULL,NULL,'2008-01-04','Steves','Brian','OR'),(3,'polepole','polepole@northwestkayakanglers.com','d8543594a691cbf25372c8ec4156a8f585b5488b','06ca03c85608574a63623c5e46437907ec609f27','2007-05-09 21:52:00','2008-04-30 21:05:16',NULL,NULL,'2008-01-04','Sansano','Allen','WA'),(5,'zeelander','kampdawg21@hotmail.com','11d69773c441a52b6cdcb36964b35cbae17c5f95','810b29693b59045b4f25d1cea912f68655bc80b7','2008-01-04 17:23:00','2008-09-22 18:01:48',NULL,NULL,'2008-01-04','Molenkamp','Bryce','WA'),(6,'coosbayyaker','r.marcum@charter.net','653d8a9d52b11739dfd989c18c7c01e5fd882a1c','3ebce71eaac052af9ff03b57554a862d1bb2cb75','2008-01-13 00:57:00','2008-09-12 16:38:14',NULL,NULL,'2008-01-12','Marcum','Roy','OR'),(7,'Alkasazi','alkasazi@yahoo.com','2d3f03a70e2157d6da19928ef4a634f7eab30156','31b787f56cb4bc347f9ecaa806f1058f025e15aa','2008-01-25 11:24:00','2008-07-03 17:42:07',NULL,NULL,'2008-07-03','Massey','Brian','WA'),(8,'Spot','mnveary@verizon.net','44ef1ca167f38ff92f1b588d2d7d698c1447b590','e5fb4a4a953c63f7cb8ecf924659a265b97b97fc','2008-01-31 12:16:00','2008-03-30 17:26:30',NULL,NULL,'2008-03-01','Veary','Mark','OR'),(9,'yakker','rpeffie@msn.com','176df96c85230ecf2ec365bc29f563afcf88e5ba','83f4cccb41f583a2c23333bf0dac5ef0a035d02d','2008-02-04 13:37:00','2008-02-21 21:46:08',NULL,NULL,'2008-02-04','Pefferman','Robert','WA'),(10,'steelheadr','orsteelheader@yahoo.com','33f3a97de625e9d177d9f41bdad681786b6fc775','2e853b95e5436cf20149257a56a8616b1729ef94','2008-03-12 23:53:00','2008-03-19 00:04:49',NULL,NULL,'2008-03-18','Swenberger','Jay','OR'),(11,'Green Butt Skunked','scott_b@opusnet.com','86facaa566a70ace10f5764bb937c304983c3b98','a9f844e04e3190c9cfd4d9b68bcd79fcc044c846','2008-04-09 11:59:00','2008-06-01 12:59:00',NULL,NULL,'2008-04-09','Brown','Scott','OR'),(12,'Pisco Sicko','pisco@methownet.com','2205459c35cb515d4a8b2e0141df9b386100cf5b','cd7a1c629c0cca717e4a8c934c30271474546c4b','2008-04-10 02:04:00','2008-04-10 02:10:51',NULL,NULL,'2008-04-10','Boosman','William','WA'),(13,'InSeine','hobbsja@gmailcom','a7c0257d662824795ca730a6f5ed02e61464040a','fb81158866f6c9ba21f370032a7d3d998be512ad','2008-04-24 20:56:00','2008-06-03 20:53:51',NULL,NULL,'2008-04-30','Hobbs','Jim','ID'),(14,'FishSniffer','gharlow@gmail.com','a7f5f07f40f1552e173eb2fb4b5e13f95183d6a1','ad5de2219008139c722fce91594fe5eae3e44f64','2008-04-28 22:27:50','2008-04-28 22:28:23',NULL,NULL,NULL,'Harlow','Greg','OR'),(15,'kykfshr','skwolfe@msn.com','296471e8dabed9abb2f7c7620d63a401ea4b01a5','efdf5970b048aaf271359dbe9dd9c9f45fcfc9cc','2008-05-30 01:06:00','2008-06-03 20:52:28',NULL,NULL,'2008-05-30','Brenneman','Scott ','WA'),(16,'boxofrain','tamlar@charter.net','5eb944ff6441b02fa6cf1dce7c30d25472da0b29','8a0a11d3ca7292ee7688486eb0df315daf961231','2008-06-04 08:10:00','2008-06-19 16:45:00',NULL,NULL,'2008-06-19','Dennis','Larry','OR'),(17,'dranel','zilk@telus.net','8d8fa5cc16dcc55e0fbb2b4c4df621163d60cede','af5b31afb1b472ddb5a55af0e78644946ac84795','2008-08-13 17:57:24','2008-08-13 17:57:24',NULL,NULL,NULL,'Zilkowsky','Len','BC'),(18,'PNW','p3walker@comcast.net','322e541ac19fc02d8da76b3d5789e487bdc0bb14','ee17d83f5a214befad88d0cc6ad9f68c4909e505','2008-11-22 22:46:48','2008-11-22 22:46:48',NULL,NULL,NULL,'Walker','Paul','OR'),(19,'bluetrident','coosbayroy@gmail.com','8e1132b9e2360f059ee55439be1a7a63ce5fafb0','fe0a396e0a81e9df079b50a6af302ccdd436da95','2009-01-02 19:51:36','2009-01-02 19:51:36',NULL,NULL,NULL,'gault','roy','OR'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!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 */; -- Dump completed on 2009-01-04 5:08:57