hotspots-tabbed

id	title	address	created_on	lat	lng	notes
1	Academy Canada	167-169 Kenmount Road	2005-12-25 07:27:07	47.555099	-52.766663	Unsecure connection from nearby house
2	Airport	Airport Heights	2005-12-25 07:28:26	47.6202811	-52.751712	NULL
3	Chad's House	13 Liverpool Ave	2005-12-25 07:28:45	47.565027	-52.726991	NULL
4	Coffee & Company	204 Water Street	2005-12-25 07:29:08	47.563719	-52.707639	NULL
5	Convergys Customer Management	274 Torbay Road	2005-12-25 07:29:37	47.599109	-52.711220	Unsecure (admin:admin) from a nearby house
6	Credit Union	341 Freshwater Road	2005-12-25 07:30:39	47.561087	-52.746051	NULL
7	Don Cherry's	290 Freshwater Road	2005-12-25 07:31:28	47.563165	-52.741338	NULL
8	Future Shop	20 Stavanger Dr	2005-12-25 07:31:45	47.615481	-52.718738	NULL
9	Hava Java	216 Water Street	2005-12-25 07:32:13	47.564143	-52.707250	NULL
10	John's House	17 Gambier St	2005-12-25 07:32:32	47.564817	-52.740255	NULL
11	LuigiPokingBean's House	34 Wigmore Ct	2005-12-25 07:33:03	47.564055	-52.762936	Ask permission and I'll let you in.
12	McDonald's	248 Torbay Road	2005-12-25 07:33:42	47.597864	-52.710552	Ask for a coupon when you order. Lasts for 45 minutes
13	Ryan Hayward	54 Blackwood Pl	2005-12-25 07:34:22	47.593442	-52.730503	If I Feel like kicking you...I will
14	The Computer Depot	250 Park Avenue	2005-12-25 07:35:09	47.52091	-52.806301	NULL
15	Tim Horton's	655 Topsail Rd	2005-12-25 07:36:10	47.524516	-52.770522	NULL
16	tracey's house	1 princeton cres	2005-12-25 07:40:15	47.5107659	-52.810142	NULL
17	Robert H's house	20 Donovan Street	2005-12-26 21:54:17	47.5219538	-52.814369	If you access it, drop me a line at ddurge@hotmail.com to let me know you used it. :)
18	B'Nuh's House	25 Cox Marsh road	2005-12-27 17:59:04	47.6295369	-52.719612	If you ever find yourself on a dirt road next to a barn, be my guest
20	Meizano	4 Carew St	2006-01-21 00:12:13	47.5698955	-52.706694	Rogers Express (PM in BK for use)
21	Kevin's House	915 Marine Drive	2006-02-01 07:13:06	47.6522498	-52.703561	Open, so if you're at the beach and need access, i'm just a hop and a skip away.
22	The Keg	135 Harbour Drive	2006-02-04 16:53:52	47.5595794	-52.710438	NULL
23	Quality Hotel	2 Hill O'Chips	2006-02-04 16:56:36	47.5699896	-52.700793	NULL
24	The Delta	120 New Gower Street	2006-02-04 17:00:57	47.5590002	-52.713582	NULL
25	K Cafe	155 New Gower	2006-02-04 21:34:15	47.5591522	-52.713239	NULL
26	Andrew's House	30 Babb Crescent	2006-02-07 18:47:52	47.5149978	-52.828445	If you can get the signal from the street than feel free to connect! :)
27	The Fairmont	115 Cavendish Sq	2006-02-13 23:50:10	47.570761	-52.700574	NULL
28	Leaside Manor Heritage Inn	39 Topsail Rd	2006-02-14 17:01:40	47.546150	-52.722890	NULL
29	Rutledge Manor	2 The Boulevard	2006-02-15 00:02:09	47.577716	-52.703879	Multiple Connections for the 4 floors
30	Wacky Wheatley's TV & Stereo	30 Kenmount Rd	2006-03-01 18:00:23	47.559666	-52.750874	NULL
31	mike's house	5 Franklyn Ave	2006-04-07 17:58:19	47.561657	-52.718170	just don't cripple me
32	Musicstop	25 Kenmount Rd	2006-04-07 20:27:13	47.5595577	-52.749481	For all the music in your life!
33	geekthegirl's house	9 Ellard Place	2006-04-07 20:30:47	47.6435692	-52.730662	is that a ninja up there?
34	Clair's House	32  Densmore Lane	2006-04-09 18:27:04	47.5180122	-52.746219	NULL
35	LuigiPokingBean's New Place	8 Field St	2006-05-05 14:30:08	47.564030	-52.716971	Ask and I'll let you in.
36	Courtyard by Marriott	131 Duckworth St	2006-05-10 11:06:52	47.569303	-52.701730	NULL
37	John Nick's house	Coughlan house, Paton College	2006-09-30 10:10:11	47.5744412	-52.735576	Residence
38	Janet's House	59 Frecker Dr.	2006-10-15 03:14:56	47.5375215	-52.761175	NULL
39	Bob's	2104 W. 2nd Street	2006-10-15 20:21:27	46.9718486	-123.84213	NULL
40	Brendas	901 mill Ave.	2006-10-15 20:24:27	46.9903819	-123.88535	NULL
41	Pro-Art Signs	410 Park St.	2006-10-15 20:30:35	46.9738105	-123.82982	NULL
42	Patrick's	corner of cottage	2006-10-15 20:32:50	46.9937482	-123.89475	NULL
43	DrewBear's house	26 Gander Cres.	2006-10-19 03:48:18	47.5321831	-52.776947	NULL
44	Grut's House	33 Windemere Pl.	2007-01-25 07:46:10	47.5134399	-52.928320	802.11b
45	#2gbl	2 gooseberry lane	2007-06-21 20:51:33	47.5842116	-52.714998	If you see me! email me at cherokeecbs1000@hotmail.com and let know where you are,im interested in knowing my wi-fi range. thanks
46	95pcr	95 Portugal cove road	2007-06-21 20:55:29	47.5847037	-52.714977	Free internet access -> SHORT RANGE
47	A.C Hunter Public Library	Allendale Road	2007-08-19 16:37:08	47.5770757	-52.728753	NULL
48	kittentits	22 balsam street	2007-09-01 16:00:49	47.5630328	-52.711501	there must be students living there but their wireless is all open.
49	Leo Burke Academy	Main Street, Bishop's Falls	2007-09-05 00:32:47	49.0013652	-55.509924	Drive around the back of the building for better strength
50	D and K computers	10 Pinsent Drive, Grand falls-Windsor	2007-09-05 00:38:08	48.9449968	-55.649485	passkey: 489-2771
51	log house	193 freshwater	2007-09-08 20:27:01	47.5629749	-52.737464	come on in.
52	Art and Shirley	Eltero park, Bishop's Falls	2008-01-02 05:02:10	49.0025618	-55.510139	Just an Open connection.
53	Meadus	Lawlor's Road	2008-01-02 05:04:08	47.5561837	-52.884578	 

hotspots.sql

-- MySQL dump 10.11
--
-- Host: localhost    Database: hotspots
-- ------------------------------------------------------
-- Server version	5.0.67-0ubuntu6

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

--
-- Current Database: `hotspots`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `hotspots` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `hotspots`;

--
-- Table structure for table `hotspots`
--

DROP TABLE IF EXISTS `hotspots`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `hotspots` (
  `id` bigint(20) NOT NULL auto_increment,
  `title` varchar(50) default NULL,
  `address` varchar(50) default NULL,
  `created_on` datetime default NULL,
  `lat` varchar(10) default NULL,
  `lng` varchar(10) default NULL,
  `notes` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `hotspots`
--

LOCK TABLES `hotspots` WRITE;
/*!40000 ALTER TABLE `hotspots` DISABLE KEYS */;
INSERT INTO `hotspots` VALUES (1,'Academy Canada','167-169 Kenmount Road','2005-12-25 07:27:07','47.555099','-52.766663','Unsecure connection from nearby house'),
	(2,'Airport','Airport Heights','2005-12-25 07:28:26','47.6202811','-52.751712',NULL),
	(3,'Chad\'s House','13 Liverpool Ave','2005-12-25 07:28:45','47.565027','-52.726991',NULL),
	(4,'Coffee & Company','204 Water Street','2005-12-25 07:29:08','47.563719','-52.707639',NULL),
	(5,'Convergys Customer Management','274 Torbay Road','2005-12-25 07:29:37','47.599109','-52.711220','Unsecure (admin:admin) from a nearby house'),
	(6,'Credit Union','341 Freshwater Road','2005-12-25 07:30:39','47.561087','-52.746051',NULL),
	(7,'Don Cherry's','290 Freshwater Road','2005-12-25 07:31:28','47.563165','-52.741338',NULL),
	(8,'Future Shop','20 Stavanger Dr','2005-12-25 07:31:45','47.615481','-52.718738',NULL),
	(9,'Hava Java','216 Water Street','2005-12-25 07:32:13','47.564143','-52.707250',NULL),
	(10,'John\'s House','17 Gambier St','2005-12-25 07:32:32','47.564817','-52.740255',NULL),
	(11,'LuigiPokingBean\'s House','34 Wigmore Ct','2005-12-25 07:33:03','47.564055','-52.762936','Ask permission and I\'ll let you in.'),
	(12,'McDonald\'s','248 Torbay Road','2005-12-25 07:33:42','47.597864','-52.710552','Ask for a coupon when you order. Lasts for 45 minutes'),
	(13,'Ryan Hayward','54 Blackwood Pl','2005-12-25 07:34:22','47.593442','-52.730503','If I Feel like kicking you...I will'),
	(14,'The Computer Depot','250 Park Avenue','2005-12-25 07:35:09','47.52091','-52.806301',NULL),
	(15,'Tim Horton\'s','655 Topsail Rd','2005-12-25 07:36:10','47.524516','-52.770522',NULL),
	(16,'tracey\'s house','1 princeton cres','2005-12-25 07:40:15','47.5107659','-52.810142',NULL),
	(17,'Robert H\'s house','20 Donovan Street','2005-12-26 21:54:17','47.5219538','-52.814369','If you access it, drop me a line at ddurge@hotmail.com to let me know you used it. :)'),
	(18,'B\'Nuh\'s House','25 Cox Marsh road','2005-12-27 17:59:04','47.6295369','-52.719612','If you ever find yourself on a dirt road next to a barn, be my guest'),
	(20,'Meizano','4 Carew St','2006-01-21 00:12:13','47.5698955','-52.706694','Rogers Express (PM in BK for use)'),
	(21,'Kevin\'s House','915 Marine Drive','2006-02-01 07:13:06','47.6522498','-52.703561','Open, so if you\'re at the beach and need access, i\'m just a hop and a skip away.'),
	(22,'The Keg','135 Harbour Drive','2006-02-04 16:53:52','47.5595794','-52.710438',NULL),
	(23,'Quality Hotel','2 Hill O\'Chips','2006-02-04 16:56:36','47.5699896','-52.700793',NULL),
	(24,'The Delta','120 New Gower Street','2006-02-04 17:00:57','47.5590002','-52.713582',NULL),
	(25,'K Cafe','155 New Gower','2006-02-04 21:34:15','47.5591522','-52.713239',NULL),
	(26,'Andrew\'s House','30 Babb Crescent','2006-02-07 18:47:52','47.5149978','-52.828445','If you can get the signal from the street than feel free to connect! :)'),
	(27,'The Fairmont','115 Cavendish Sq','2006-02-13 23:50:10','47.570761','-52.700574',NULL),
	(28,'Leaside Manor Heritage Inn','39 Topsail Rd','2006-02-14 17:01:40','47.546150','-52.722890',NULL),
	(29,'Rutledge Manor','2 The Boulevard','2006-02-15 00:02:09','47.577716','-52.703879','Multiple Connections for the 4 floors'),
	(30,'Wacky Wheatley\'s TV & Stereo','30 Kenmount Rd','2006-03-01 18:00:23','47.559666','-52.750874',NULL),
	(31,'mike\'s house','5 Franklyn Ave','2006-04-07 17:58:19','47.561657','-52.718170','just don\'t cripple me'),
	(32,'Musicstop','25 Kenmount Rd','2006-04-07 20:27:13','47.5595577','-52.749481','For all the music in your life!'),
	(33,'geekthegirl\'s house','9 Ellard Place','2006-04-07 20:30:47','47.6435692','-52.730662','is that a ninja up there?'),
	(34,'Clair\'s House','32  Densmore Lane','2006-04-09 18:27:04','47.5180122','-52.746219',NULL),
	(35,'LuigiPokingBean\'s New Place','8 Field St','2006-05-05 14:30:08','47.564030','-52.716971','Ask and I\'ll let you in.'),
	(36,'Courtyard by Marriott','131 Duckworth St','2006-05-10 11:06:52','47.569303','-52.701730',NULL),
	(37,'John Nick\'s house','Coughlan house, Paton College','2006-09-30 10:10:11','47.5744412','-52.735576','Residence'),
	(38,'Janet\'s House','59 Frecker Dr.','2006-10-15 03:14:56','47.5375215','-52.761175',NULL),
	(39,'Bob\'s','2104 W. 2nd Street','2006-10-15 20:21:27','46.9718486','-123.84213',NULL),
	(40,'Brendas','901 mill Ave.','2006-10-15 20:24:27','46.9903819','-123.88535',NULL),
	(41,'Pro-Art Signs','410 Park St.','2006-10-15 20:30:35','46.9738105','-123.82982',NULL),
	(42,'Patrick\'s','corner of cottage','2006-10-15 20:32:50','46.9937482','-123.89475',NULL),
	(43,'DrewBear\'s house','26 Gander Cres.','2006-10-19 03:48:18','47.5321831','-52.776947',NULL),
	(44,'Grut\'s House','33 Windemere Pl.','2007-01-25 07:46:10','47.5134399','-52.928320','802.11b'),
	(45,'#2gbl','2 gooseberry lane','2007-06-21 20:51:33','47.5842116','-52.714998','If you see me! email me at cherokeecbs1000@hotmail.com and let know where you are,im interested in knowing my wi-fi range. thanks'),
	(46,'95pcr','95 Portugal cove road','2007-06-21 20:55:29','47.5847037','-52.714977','Free internet access -> SHORT RANGE'),
	(47,'A.C Hunter Public Library','Allendale Road','2007-08-19 16:37:08','47.5770757','-52.728753',NULL),
	(48,'kittentits','22 balsam street','2007-09-01 16:00:49','47.5630328','-52.711501','there must be students living there but their wireless is all open.'),
	(49,'Leo Burke Academy','Main Street, Bishop\'s Falls','2007-09-05 00:32:47','49.0013652','-55.509924','Drive around the back of the building for better strength'),
	(50,'D and K computers','10 Pinsent Drive, Grand falls-Windsor','2007-09-05 00:38:08','48.9449968','-55.649485','passkey: 489-2771'),
	(51,'log house','193 freshwater','2007-09-08 20:27:01','47.5629749','-52.737464','come on in.'),
	(52,'Art and Shirley','Eltero park, Bishop\'s Falls','2008-01-02 05:02:10','49.0025618','-55.510139','Just an Open connection.'),
	(53,'Meadus','Lawlor\'s Road','2008-01-02 05:04:08','47.5561837','-52.884578',' ');
/*!40000 ALTER TABLE `hotspots` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `questions`
--

DROP TABLE IF EXISTS `questions`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `questions` (
  `order` int(11) default NULL,
  `view` varchar(10) default NULL,
  `title` varchar(255) default NULL,
  `body` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `questions`
--

LOCK TABLES `questions` WRITE;
/*!40000 ALTER TABLE `questions` DISABLE KEYS */;
INSERT INTO `questions` VALUES (20,'mobile','Why am I being redirected to mobile?!','This is because of one or two reasons. Either somewhere in your browser\'s HTTP-ACCEPT string, it contains \"wap\" or \"wml\", which qualifies as a mobile browser. The other is that your browser isn\'t listed below:\r\n\r\n- Firefox\r\n- Internet Explorer 5.5+\r\n- Opera\r\n- Mozilla\r\n- Safari\r\n\r\nThe reason only those browsers are accepted is because they are the only ones that Google Maps accepts. Spoofing your user agent also works. For example, I know that if you have Konqueror identify itself as Safari, it works fine.'),
	(10,'shared','Ahh! Why is my house listed here?! Take it down!','Hotspots are added to the listing with complete anonymity. I will not take any down, however, you can [read how to secure your wireless network](http://www.google.ca/search?q=secure+wireless+network \"google is your friend\") to keep intruders out.'),
	(12,'shared','Can I use the data someplace else?','Be my guest! There is [an RSS 2.0 feed](<%= url_for :controller => \"hotspots\", :action => \"rss\" %>) for you to use with any feed aggregator you wish. Also, there is a [full documentation on the API](<%= url_for :controller => \"api\", :action => \"docs\" %>)'),
	(30,'xhtml','What do the different color markers mean?','Red is weak, blue is average, and green is strong'),
	(11,'shared','Why only 3 signal strengths?','Funny story (only not really). When I first implemented color-coded markers, I had no desire to make my own icons (I am terrible when it comes to graphic design), so I did a quick Google Search and found someone who had made a set of three icons. Now, I learn that [there are packs of 200+ markers](http://people.vanderbilt.edu/~sam.kuhn/gmaps/index.html). So if enough requests are made, more options will be added.');
/*!40000 ALTER TABLE `questions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `strengths`
--

DROP TABLE IF EXISTS `strengths`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `strengths` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `hotspot_id` int(10) unsigned default NULL,
  `strength` int(1) default '2',
  `created_on` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=467 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `strengths`
--

LOCK TABLES `strengths` WRITE;
/*!40000 ALTER TABLE `strengths` DISABLE KEYS */;
INSERT INTO `strengths` VALUES (1,39,1,'2005-12-06 18:36:59'),
	(2,34,3,'2005-12-06 18:36:59'),
	(3,36,2,'2005-12-06 18:36:59'),
	(4,33,1,'2005-12-06 18:36:59'),
	(5,35,3,'2005-12-06 18:36:59'),
	(6,29,2,'2005-12-06 18:36:59'),
	(7,27,3,'2005-12-06 18:36:59'),
	(8,28,2,'2005-12-06 18:36:59'),
	(9,32,3,'2005-12-06 18:36:59'),
	(10,47,2,'2005-12-06 18:36:59'),
	(11,46,3,'2005-12-06 18:36:59'),
	(12,31,1,'2005-12-06 18:36:59'),
	(13,43,2,'2005-12-06 18:36:59'),
	(14,41,3,'2005-12-06 18:36:59'),
	(15,44,2,'2005-12-06 18:36:59'),
	(16,42,2,'2005-12-06 18:36:59'),
	(17,45,1,'2005-12-06 18:36:59'),
	(18,39,3,'2005-12-06 18:37:10'),
	(19,34,2,'2005-12-06 18:37:10'),
	(20,36,3,'2005-12-06 18:37:10'),
	(21,33,1,'2005-12-06 18:37:10'),
	(22,35,2,'2005-12-06 18:37:10'),
	(23,29,3,'2005-12-06 18:37:10'),
	(24,27,2,'2005-12-06 18:37:10'),
	(25,28,1,'2005-12-06 18:37:10'),
	(26,32,2,'2005-12-06 18:37:10'),
	(27,47,3,'2005-12-06 18:37:10'),
	(28,46,2,'2005-12-06 18:37:10'),
	(29,31,1,'2005-12-06 18:37:10'),
	(30,43,2,'2005-12-06 18:37:10'),
	(31,41,3,'2005-12-06 18:37:10'),
	(32,44,2,'2005-12-06 18:37:10'),
	(33,42,1,'2005-12-06 18:37:10'),
	(34,45,2,'2005-12-06 18:37:10'),
	(35,39,3,'2005-12-06 18:37:13'),
	(36,34,3,'2005-12-06 18:37:13'),
	(37,36,3,'2005-12-06 18:37:13'),
	(38,33,2,'2005-12-06 18:37:13'),
	(39,35,3,'2005-12-06 18:37:13'),
	(40,29,2,'2005-12-06 18:37:13'),
	(41,27,3,'2005-12-06 18:37:13'),
	(42,28,1,'2005-12-06 18:37:13'),
	(43,32,3,'2005-12-06 18:37:13'),
	(44,47,2,'2005-12-06 18:37:13'),
	(45,46,1,'2005-12-06 18:37:13'),
	(46,31,3,'2005-12-06 18:37:13'),
	(47,43,1,'2005-12-06 18:37:13'),
	(48,41,2,'2005-12-06 18:37:13'),
	(49,44,2,'2005-12-06 18:37:13'),
	(50,42,3,'2005-12-06 18:37:13'),
	(51,45,2,'2005-12-06 18:37:13'),
	(53,55,3,'2005-12-15 03:17:58'),
	(54,56,1,'2005-12-15 03:20:36'),
	(55,34,3,'2005-12-15 03:30:25'),
	(56,39,3,'2005-12-15 03:30:31'),
	(57,39,1,'2005-12-15 03:30:39'),
	(58,39,1,'2005-12-15 03:30:42'),
	(59,39,1,'2005-12-15 03:30:47'),
	(60,39,1,'2005-12-15 03:30:50'),
	(61,39,1,'2005-12-15 03:30:54'),
	(62,39,1,'2005-12-15 03:31:00'),
	(63,39,1,'2005-12-15 03:31:35'),
	(64,39,1,'2005-12-15 03:31:38'),
	(65,39,1,'2005-12-15 03:34:37'),
	(66,39,1,'2005-12-15 03:34:45'),
	(67,39,1,'2005-12-15 03:34:47'),
	(68,34,1,'2005-12-15 03:42:56'),
	(69,39,3,'2005-12-17 19:23:16'),
	(70,39,3,'2005-12-17 19:24:15'),
	(71,57,2,'2005-12-17 19:27:43'),
	(72,58,2,'2005-12-17 23:47:23'),
	(73,58,1,'2005-12-21 10:13:16'),
	(74,56,3,'2005-12-21 10:14:44'),
	(75,56,1,'2005-12-21 10:15:30'),
	(76,56,3,'2005-12-21 10:15:36'),
	(77,56,2,'2005-12-21 10:15:44'),
	(78,56,3,'2005-12-21 10:15:51'),
	(79,56,3,'2005-12-21 10:16:26'),
	(80,56,3,'2005-12-21 10:16:35'),
	(81,56,3,'2005-12-21 10:16:44'),
	(82,56,3,'2005-12-21 10:17:09'),
	(83,36,1,'2005-12-21 10:18:34'),
	(84,36,1,'2005-12-21 10:18:40'),
	(85,36,1,'2005-12-21 10:18:43'),
	(86,36,1,'2005-12-21 10:18:46'),
	(87,36,1,'2005-12-21 10:18:49'),
	(88,36,1,'2005-12-21 10:18:52'),
	(89,36,1,'2005-12-21 10:18:54'),
	(90,36,1,'2005-12-21 10:18:57'),
	(91,36,3,'2005-12-21 10:19:04'),
	(92,36,1,'2005-12-21 10:19:07'),
	(93,36,1,'2005-12-21 10:19:09'),
	(94,36,1,'2005-12-21 10:19:13'),
	(95,58,3,'2005-12-21 10:19:23'),
	(96,58,1,'2005-12-21 10:19:26'),
	(97,58,3,'2005-12-21 10:19:29'),
	(98,58,3,'2005-12-21 10:19:33'),
	(99,58,1,'2005-12-21 10:19:35'),
	(100,39,1,'2005-12-21 11:18:00'),
	(101,39,1,'2005-12-21 11:18:06'),
	(102,39,1,'2005-12-21 11:18:09'),
	(103,39,1,'2005-12-21 11:18:12'),
	(104,58,1,'2005-12-21 11:38:56'),
	(105,36,3,'2005-12-21 11:39:05'),
	(106,36,3,'2005-12-21 11:39:09'),
	(107,36,3,'2005-12-21 11:39:12'),
	(108,36,3,'2005-12-21 11:39:16'),
	(109,36,3,'2005-12-21 11:39:19'),
	(110,36,3,'2005-12-21 11:39:23'),
	(111,36,3,'2005-12-21 11:39:27'),
	(112,36,3,'2005-12-21 11:39:49'),
	(113,36,3,'2005-12-21 11:39:53'),
	(114,36,3,'2005-12-21 11:39:56'),
	(115,36,3,'2005-12-21 11:39:59'),
	(116,36,3,'2005-12-21 11:40:02'),
	(117,41,1,'2005-12-21 18:29:49'),
	(118,41,1,'2005-12-21 18:35:36'),
	(119,41,1,'2005-12-21 18:35:40'),
	(120,41,1,'2005-12-21 18:35:43'),
	(121,41,1,'2005-12-21 18:35:46'),
	(122,41,1,'2005-12-21 18:35:49'),
	(123,45,3,'2005-12-21 22:02:20'),
	(124,45,3,'2005-12-21 22:02:23'),
	(125,45,3,'2005-12-21 22:02:26'),
	(126,45,3,'2005-12-21 22:02:30'),
	(127,45,3,'2005-12-21 22:02:32'),
	(128,45,1,'2005-12-21 22:02:39'),
	(129,45,3,'2005-12-21 22:02:42'),
	(130,35,1,'2005-12-22 19:36:38'),
	(131,35,3,'2005-12-22 19:36:45'),
	(132,35,3,'2005-12-22 19:36:49'),
	(133,39,3,'2005-12-23 00:12:28'),
	(134,44,3,'2005-12-23 01:02:47'),
	(135,34,3,'2005-12-23 11:16:01'),
	(136,34,1,'2005-12-23 11:16:05'),
	(137,34,3,'2005-12-23 11:16:10'),
	(138,34,3,'2005-12-23 11:16:14'),
	(139,34,3,'2005-12-23 11:16:18'),
	(140,56,1,'2005-12-23 11:19:51'),
	(141,58,1,'2005-12-23 11:25:14'),
	(142,34,1,'2005-12-23 11:44:35'),
	(143,34,3,'2005-12-23 11:45:28'),
	(144,34,3,'2005-12-23 11:45:32'),
	(145,34,3,'2005-12-23 11:45:36'),
	(146,58,3,'2005-12-23 11:52:49'),
	(147,58,1,'2005-12-23 11:56:47'),
	(148,56,1,'2005-12-23 11:57:15'),
	(149,41,1,'2005-12-23 11:57:27'),
	(150,41,1,'2005-12-23 11:57:52'),
	(151,41,3,'2005-12-23 11:57:56'),
	(152,41,1,'2005-12-23 11:58:04'),
	(153,41,1,'2005-12-23 11:58:08'),
	(154,41,1,'2005-12-23 11:58:12'),
	(155,41,2,'2005-12-23 12:00:55'),
	(156,41,1,'2005-12-23 12:01:00'),
	(157,39,1,'2005-12-23 23:52:06'),
	(158,39,1,'2005-12-23 23:52:10'),
	(159,34,1,'2005-12-23 23:56:23'),
	(160,36,1,'2005-12-24 02:37:13'),
	(161,34,3,'2005-12-24 03:07:47'),
	(162,34,3,'2005-12-24 03:09:15'),
	(163,34,3,'2005-12-24 03:09:20'),
	(164,34,1,'2005-12-24 03:09:26'),
	(165,58,3,'2005-12-24 03:41:22'),
	(166,58,3,'2005-12-24 03:41:26'),
	(167,42,1,'2005-12-24 04:01:15'),
	(168,59,3,'2005-12-24 04:13:47'),
	(169,60,3,'2005-12-24 04:15:54'),
	(170,61,2,'2005-12-24 04:56:32'),
	(171,62,2,'2005-12-24 04:56:40'),
	(172,63,2,'2005-12-24 04:59:19'),
	(173,64,2,'2005-12-24 05:02:37'),
	(174,65,2,'2005-12-24 05:04:50'),
	(175,66,2,'2005-12-24 05:10:01'),
	(176,67,1,'2005-12-24 12:06:45'),
	(177,67,2,'2005-12-24 12:29:36'),
	(178,67,1,'2005-12-24 12:29:40'),
	(179,36,3,'2005-12-24 13:18:52'),
	(180,67,2,'2005-12-24 13:19:03'),
	(181,42,2,'2005-12-24 13:21:21'),
	(182,34,3,'2005-12-24 13:22:16'),
	(183,34,3,'2005-12-24 13:22:20'),
	(184,34,3,'2005-12-24 13:22:24'),
	(185,34,1,'2005-12-24 13:22:32'),
	(186,39,2,'2005-12-24 17:44:23'),
	(187,39,2,'2005-12-24 17:44:25'),
	(188,39,2,'2005-12-24 17:44:26'),
	(189,67,2,'2005-12-24 17:50:15'),
	(190,39,2,'2005-12-24 18:09:02'),
	(191,34,1,'2005-12-25 04:54:37'),
	(192,34,3,'2005-12-25 04:54:43'),
	(193,34,3,'2005-12-25 04:54:47'),
	(194,34,3,'2005-12-25 04:54:51'),
	(195,34,3,'2005-12-25 04:54:55'),
	(196,34,3,'2005-12-25 04:54:59'),
	(197,34,3,'2005-12-25 04:55:03'),
	(198,67,3,'2005-12-25 05:16:20'),
	(199,67,3,'2005-12-25 05:16:23'),
	(200,67,3,'2005-12-25 05:16:27'),
	(201,67,3,'2005-12-25 05:16:30'),
	(202,67,3,'2005-12-25 05:16:34'),
	(203,67,3,'2005-12-25 05:16:37'),
	(204,67,3,'2005-12-25 05:16:41'),
	(205,67,3,'2005-12-25 05:16:45'),
	(206,67,3,'2005-12-25 05:16:48'),
	(207,1,2,'2005-12-25 07:27:07'),
	(208,2,2,'2005-12-25 07:28:26'),
	(209,3,2,'2005-12-25 07:28:45'),
	(210,4,2,'2005-12-25 07:29:08'),
	(211,5,2,'2005-12-25 07:29:37'),
	(212,6,2,'2005-12-25 07:30:39'),
	(213,7,2,'2005-12-25 07:31:28'),
	(214,8,2,'2005-12-25 07:31:45'),
	(215,9,2,'2005-12-25 07:32:13'),
	(216,10,2,'2005-12-25 07:32:32'),
	(217,11,2,'2005-12-25 07:33:03'),
	(218,12,2,'2005-12-25 07:33:42'),
	(219,13,2,'2005-12-25 07:34:22'),
	(220,14,2,'2005-12-25 07:35:09'),
	(221,15,2,'2005-12-25 07:36:10'),
	(222,16,2,'2005-12-25 07:40:15'),
	(223,1,2,'2005-12-26 18:54:44'),
	(224,17,2,'2005-12-26 21:54:17'),
	(225,15,1,'2005-12-26 22:05:19'),
	(226,15,1,'2005-12-26 22:05:23'),
	(227,15,3,'2005-12-27 11:39:56'),
	(228,18,2,'2005-12-27 17:59:04'),
	(229,17,2,'2005-12-27 18:12:54'),
	(230,12,1,'2005-12-29 12:54:36'),
	(231,10,1,'2005-12-29 16:48:23'),
	(232,19,2,'2005-12-29 20:44:10'),
	(233,15,1,'2006-01-05 12:18:47'),
	(234,6,3,'2006-01-17 22:08:24'),
	(235,9,2,'2006-01-19 12:37:09'),
	(236,9,2,'2006-01-19 12:37:12'),
	(237,20,2,'2006-01-21 00:12:13'),
	(238,20,1,'2006-01-23 17:50:35'),
	(239,20,1,'2006-01-23 17:50:39'),
	(240,2,1,'2006-01-26 07:00:00'),
	(241,18,2,'2006-01-30 17:38:05'),
	(242,18,2,'2006-01-30 17:38:05'),
	(243,4,3,'2006-01-31 14:14:04'),
	(244,2,3,'2006-01-31 14:34:28'),
	(245,21,1,'2006-02-01 07:13:07'),
	(246,21,2,'2006-02-01 07:14:27'),
	(247,22,2,'2006-02-04 16:53:52'),
	(248,23,2,'2006-02-04 16:56:36'),
	(249,24,2,'2006-02-04 17:00:57'),
	(250,25,2,'2006-02-04 21:34:15'),
	(251,3,1,'2006-02-05 10:43:12'),
	(252,3,1,'2006-02-05 10:43:17'),
	(253,3,3,'2006-02-05 10:43:20'),
	(254,26,2,'2006-02-07 18:47:52'),
	(255,3,3,'2006-02-11 07:15:07'),
	(256,3,2,'2006-02-11 07:15:07'),
	(257,27,2,'2006-02-13 23:50:10'),
	(258,27,2,'2006-02-13 23:50:20'),
	(259,28,2,'2006-02-14 17:01:40'),
	(260,29,2,'2006-02-15 00:02:09'),
	(261,5,1,'2006-02-18 13:05:47'),
	(262,5,1,'2006-02-18 13:05:52'),
	(263,30,2,'2006-03-01 18:00:23'),
	(264,24,1,'2006-03-14 12:41:51'),
	(265,26,1,'2006-03-14 14:10:27'),
	(266,26,1,'2006-03-14 14:10:31'),
	(267,26,2,'2006-03-14 14:10:37'),
	(268,30,3,'2006-03-24 16:15:26'),
	(269,31,2,'2006-04-07 17:58:19'),
	(270,32,3,'2006-04-07 20:27:13'),
	(271,33,2,'2006-04-07 20:30:47'),
	(272,31,1,'2006-04-09 18:21:31'),
	(273,1,3,'2006-04-09 18:21:55'),
	(274,34,1,'2006-04-09 18:27:04'),
	(275,34,3,'2006-04-09 18:27:16'),
	(276,3,1,'2006-04-21 13:32:18'),
	(277,3,3,'2006-04-21 13:32:22'),
	(278,3,1,'2006-04-21 13:32:26'),
	(279,4,2,'2006-04-29 12:52:57'),
	(280,17,2,'2006-04-29 19:06:36'),
	(281,17,1,'2006-04-29 19:06:39'),
	(282,35,2,'2006-05-05 14:30:09'),
	(283,36,2,'2006-05-10 11:06:52'),
	(284,16,3,'2006-05-11 12:02:52'),
	(285,6,2,'2006-05-13 19:22:49'),
	(286,6,3,'2006-05-13 19:22:50'),
	(287,28,3,'2006-05-28 17:49:45'),
	(288,34,3,'2006-05-29 12:25:01'),
	(289,29,3,'2006-06-23 13:05:02'),
	(290,29,3,'2006-06-23 13:05:05'),
	(291,13,1,'2006-06-23 13:05:09'),
	(292,13,1,'2006-06-23 13:05:12'),
	(293,1,3,'2006-08-02 18:15:54'),
	(294,37,2,'2006-09-30 10:10:11'),
	(295,5,2,'2006-10-12 22:59:09'),
	(296,13,1,'2006-10-13 17:16:01'),
	(297,13,1,'2006-10-13 17:16:02'),
	(298,13,1,'2006-10-13 17:16:02'),
	(299,16,2,'2006-10-14 11:38:59'),
	(300,16,3,'2006-10-14 11:39:00'),
	(301,2,3,'2006-10-14 17:38:48'),
	(302,2,3,'2006-10-14 17:38:51'),
	(303,15,3,'2006-10-14 17:39:46'),
	(304,2,3,'2006-10-14 17:54:02'),
	(305,38,3,'2006-10-15 03:14:56'),
	(306,39,2,'2006-10-15 20:21:27'),
	(307,40,2,'2006-10-15 20:24:27'),
	(308,41,2,'2006-10-15 20:30:35'),
	(309,42,2,'2006-10-15 20:32:50'),
	(310,43,2,'2006-10-19 03:48:18'),
	(311,4,3,'2006-10-19 17:24:01'),
	(312,34,3,'2006-10-20 05:17:44'),
	(313,20,2,'2006-10-20 12:32:38'),
	(314,20,3,'2006-10-20 12:32:42'),
	(315,20,1,'2006-10-20 12:32:48'),
	(316,18,3,'2006-10-29 18:57:20'),
	(317,18,3,'2006-10-29 18:57:23'),
	(318,18,3,'2006-10-29 18:57:24'),
	(319,18,3,'2006-10-29 18:57:26'),
	(320,13,3,'2006-10-29 18:57:31'),
	(321,13,3,'2006-10-29 18:57:33'),
	(322,13,3,'2006-10-29 18:57:34'),
	(323,13,3,'2006-10-29 18:57:37'),
	(324,13,3,'2006-10-29 18:57:38'),
	(325,13,3,'2006-10-29 18:57:41'),
	(326,13,3,'2006-10-29 18:57:42'),
	(327,13,3,'2006-10-29 18:57:44'),
	(328,13,3,'2006-10-29 18:57:45'),
	(329,13,3,'2006-10-29 18:57:47'),
	(330,13,3,'2006-10-29 18:57:48'),
	(331,13,3,'2006-10-29 18:57:50'),
	(332,13,3,'2006-10-29 18:57:50'),
	(333,13,3,'2006-10-29 18:57:50'),
	(334,13,3,'2006-10-29 18:57:51'),
	(335,13,3,'2006-10-29 18:57:51'),
	(336,13,3,'2006-10-29 18:57:52'),
	(337,21,3,'2006-10-29 18:58:00'),
	(338,21,3,'2006-10-29 18:58:02'),
	(339,21,3,'2006-10-29 18:58:04'),
	(340,21,3,'2006-10-29 18:58:07'),
	(341,21,3,'2006-10-29 18:58:08'),
	(342,33,3,'2006-10-29 18:58:12'),
	(343,33,3,'2006-10-29 18:58:13'),
	(344,33,3,'2006-10-29 18:58:15'),
	(345,33,3,'2006-10-29 18:58:16'),
	(346,33,3,'2006-10-29 18:58:18'),
	(347,33,3,'2006-10-29 18:58:20'),
	(348,33,3,'2006-10-29 18:58:21'),
	(349,33,3,'2006-10-29 18:58:23'),
	(350,33,3,'2006-10-29 18:58:24'),
	(351,33,3,'2006-10-29 18:58:25'),
	(352,33,3,'2006-10-29 18:58:25'),
	(353,8,3,'2006-10-29 18:58:30'),
	(354,8,3,'2006-10-29 18:58:31'),
	(355,8,3,'2006-10-29 18:58:31'),
	(356,12,3,'2006-10-29 18:58:35'),
	(357,12,3,'2006-10-29 18:58:35'),
	(358,12,3,'2006-10-29 18:58:36'),
	(359,12,3,'2006-10-29 18:58:37'),
	(360,12,3,'2006-10-29 18:58:37'),
	(361,12,3,'2006-10-29 18:58:40'),
	(362,5,3,'2006-10-29 18:58:45'),
	(363,5,3,'2006-10-29 18:58:45'),
	(364,5,3,'2006-10-29 18:58:45'),
	(365,5,3,'2006-10-29 18:58:46'),
	(366,5,3,'2006-10-29 18:58:46'),
	(367,5,3,'2006-10-29 18:58:47'),
	(368,38,1,'2006-10-31 03:50:08'),
	(369,38,3,'2006-10-31 03:50:16'),
	(370,38,3,'2006-10-31 03:50:23'),
	(371,1,1,'2006-11-02 15:34:10'),
	(372,1,1,'2006-11-02 15:34:10'),
	(373,1,2,'2006-11-02 15:34:15'),
	(374,1,3,'2006-11-02 15:34:21'),
	(375,38,2,'2006-11-03 12:26:18'),
	(376,38,1,'2006-11-03 12:26:23'),
	(377,38,3,'2006-11-03 12:26:24'),
	(378,29,1,'2006-12-02 03:41:47'),
	(379,29,1,'2006-12-02 03:41:49'),
	(380,29,1,'2006-12-02 03:41:51'),
	(381,17,3,'2006-12-03 13:56:37'),
	(382,28,3,'2006-12-04 18:45:22'),
	(383,43,3,'2006-12-04 23:42:16'),
	(384,43,1,'2006-12-04 23:42:17'),
	(385,26,1,'2006-12-06 21:04:00'),
	(386,26,2,'2006-12-06 21:04:01'),
	(387,26,1,'2006-12-06 21:04:14'),
	(388,26,3,'2006-12-06 21:04:22'),
	(389,26,1,'2006-12-06 21:04:26'),
	(390,1,1,'2006-12-09 18:26:59'),
	(391,7,1,'2006-12-15 04:14:19'),
	(392,1,3,'2006-12-18 20:26:26'),
	(393,1,2,'2006-12-18 20:26:27'),
	(394,2,1,'2006-12-24 02:15:08'),
	(395,1,2,'2006-12-24 03:22:49'),
	(396,1,2,'2006-12-24 10:28:15'),
	(397,26,2,'2006-12-24 10:28:21'),
	(398,1,2,'2006-12-26 09:10:49'),
	(399,16,3,'2006-12-26 22:13:01'),
	(400,18,1,'2006-12-27 02:42:41'),
	(401,18,1,'2006-12-27 02:42:47'),
	(402,40,2,'2007-01-21 17:27:52'),
	(403,44,2,'2007-01-25 07:46:10'),
	(404,2,3,'2007-01-31 11:53:54'),
	(405,12,1,'2007-02-13 17:21:36'),
	(406,12,3,'2007-02-13 17:21:38'),
	(407,8,1,'2007-02-22 13:16:58'),
	(408,8,3,'2007-02-22 13:17:07'),
	(409,26,2,'2007-03-23 09:38:23'),
	(410,26,1,'2007-03-23 09:38:25'),
	(411,26,3,'2007-03-23 09:44:14'),
	(412,39,3,'2007-04-01 01:23:04'),
	(413,38,3,'2007-04-22 09:30:00'),
	(414,38,1,'2007-04-22 09:30:01'),
	(415,2,3,'2007-05-01 13:06:38'),
	(416,18,3,'2007-05-19 21:36:36'),
	(417,24,3,'2007-06-03 09:08:10'),
	(418,39,3,'2007-06-03 10:27:21'),
	(419,39,2,'2007-06-03 10:27:22'),
	(420,16,2,'2007-06-04 05:03:58'),
	(421,16,1,'2007-06-04 05:04:00'),
	(422,16,3,'2007-06-04 05:04:02'),
	(423,1,1,'2007-06-06 17:29:19'),
	(424,1,1,'2007-06-06 17:29:22'),
	(425,1,2,'2007-06-06 17:29:23'),
	(426,1,2,'2007-06-06 17:29:23'),
	(427,45,3,'2007-06-21 20:51:33'),
	(428,46,3,'2007-06-21 20:55:29'),
	(429,4,2,'2007-08-05 23:43:16'),
	(430,4,3,'2007-08-05 23:43:17'),
	(431,11,1,'2007-08-13 17:16:57'),
	(432,15,3,'2007-08-19 13:27:10'),
	(433,47,2,'2007-08-19 16:37:08'),
	(434,2,1,'2007-08-22 14:31:32'),
	(435,2,3,'2007-08-22 14:31:35'),
	(436,4,1,'2007-08-26 15:46:34'),
	(437,4,1,'2007-08-26 15:46:38'),
	(438,4,3,'2007-08-26 15:46:43'),
	(439,48,2,'2007-09-01 16:00:49'),
	(440,49,1,'2007-09-05 00:32:47'),
	(441,50,2,'2007-09-05 00:38:08'),
	(442,45,3,'2007-09-05 16:20:31'),
	(443,51,2,'2007-09-08 20:27:01'),
	(444,9,3,'2007-09-09 17:24:14'),
	(445,6,2,'2007-09-10 01:53:11'),
	(446,6,3,'2007-09-10 01:53:14'),
	(447,8,3,'2007-09-11 17:47:56'),
	(448,11,3,'2007-09-13 09:27:10'),
	(449,49,3,'2007-09-16 18:47:34'),
	(450,49,1,'2007-09-16 19:31:26'),
	(451,7,1,'2007-10-11 17:39:52'),
	(452,29,3,'2007-10-17 07:07:05'),
	(453,29,2,'2007-10-17 07:07:07'),
	(454,8,2,'2007-10-22 12:36:16'),
	(455,8,3,'2007-10-22 12:36:17'),
	(456,8,1,'2007-10-22 12:36:18'),
	(457,16,2,'2007-11-25 10:52:41'),
	(458,36,2,'2007-11-26 01:56:02'),
	(459,2,3,'2007-12-01 15:41:49'),
	(460,45,3,'2007-12-08 19:20:50'),
	(461,37,1,'2007-12-08 21:17:19'),
	(462,52,3,'2008-01-02 05:02:10'),
	(463,53,2,'2008-01-02 05:04:08'),
	(464,28,3,'2008-01-13 20:12:18'),
	(465,28,3,'2008-01-15 09:49:45'),
	(466,33,1,'2008-02-18 00:59:42');
/*!40000 ALTER TABLE `strengths` 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-09  8:40:31