-- -- Database: `sophiedogg_googlegraphs` -- -- -------------------------------------------------------- -- -- Table structure for table `activity` -- CREATE TABLE IF NOT EXISTS `activity` ( `id` int(11) NOT NULL AUTO_INCREMENT, `group_id` int(11) NOT NULL, `field_id` int(11) NOT NULL, `label` varchar(30) NOT NULL, `points` int(11) NOT NULL, `max_points` int(11) NOT NULL, `entry_period` int(11) NOT NULL, `position` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ; -- -- Dumping data for table `activity` -- INSERT INTO `activity` (`id`, `group_id`, `field_id`, `label`, `points`, `max_points`, `entry_period`, `position`) VALUES (1, 1, 1, 'Breakfast', 1, 1, 1, 1), (2, 1, 1, 'Lunch', 1, 1, 1, 1), (3, 1, 1, 'Dinner', 1, 1, 1, 1), (4, 1, 2, 'Glasses', 1, 8, 1, 1), (5, 1, 3, 'Round trips', 1, 2, 1, 1), (6, 1, 4, 'Miles', 1, 5, 1, 1), (7, 1, 5, 'I did it', 1, 1, 1, 1), (8, 1, 6, 'I did it', 1, 1, 1, 1), (9, 1, 7, 'None', 0, 0, 1, 1), (10, 1, 7, 'Some', 1, 1, 1, 1), (11, 1, 7, 'Recommended amount', 2, 2, 1, 1), (12, 1, 8, 'None', 0, 0, 1, 1), (13, 1, 8, 'Some', 1, 1, 1, 1), (14, 1, 8, 'Recommended amount', 2, 2, 1, 1), (15, 2, 9, 'Be creative', 1, 1, 1, 1), (16, 2, 10, 'Do something you like', 1, 1, 1, 1), (17, 2, 11, '', 1, 1, 1, 1), (18, 2, 12, 'Times today', 1, 1, 1, 1), (19, 2, 13, 'Fun things today', 1, 1, 1, 1), (20, 2, 14, 'Times today', 10, 10, 1, 1), (21, 3, 15, 'Enter the number of 1/2 hours ', 1, 48, 1, 1), (22, 3, 16, 'Enter the number of 1/2 hours ', 2, 96, 1, 1), (23, 3, 17, 'Enter the number of 1/2 hours ', 3, 144, 1, 1), (24, 3, 18, 'Less than 8,000', 0, 0, 1, 1), (25, 3, 18, '8,000 to 9,999', 1, 1, 1, 1), (26, 3, 18, '10,000 or more', 2, 2, 1, 1), (27, 4, 19, 'I did it', 20, 20, 1, 1), (28, 5, 20, 'I did it', 10, 10, 1, 1), (29, 4, 21, 'I did it', 1, 1, 1, 1), (30, 4, 22, 'I did it', 5, 100, 1, 1), (31, 5, 23, 'Sports', 20, 20, 1, 1), (32, 5, 24, 'Enter pounds lost/gained', 2, 100, 1, 1), (33, 5, 25, 'I did it', 100, 100, 1, 1), (34, 2, 26, 'I did it', 1, 1, 1, 1), (35, 5, 27, 'I did it', 25, 25, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `activityfield` -- CREATE TABLE IF NOT EXISTS `activityfield` ( `id` int(11) NOT NULL AUTO_INCREMENT, `group_id` int(11) NOT NULL, `name` varchar(30) NOT NULL, `type` int(11) NOT NULL, `position` int(11) NOT NULL, `hover` varchar(100) DEFAULT NULL, `link` varchar(250) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ; -- -- Dumping data for table `activityfield` -- INSERT INTO `activityfield` (`id`, `group_id`, `name`, `type`, `position`, `hover`, `link`) VALUES (1, 1, 'Healthy Eating Choices', 2, 1, 'One Point Each', 'http://www.mypyramid.gov/'), (2, 1, 'Drinking Water', 3, 2, '1 point for each 8oz glass, 8 points maximum', NULL), (3, 1, 'Take The Stairs', 3, 3, '1 point for each round trip.', NULL), (4, 1, 'Walk', 3, 4, '1 point for each mile.', NULL), (5, 1, 'Buckle Up', 2, 5, '1 point per day.', NULL), (6, 1, 'Try A Healthy Recipe', 2, 6, '1 point per day.', NULL), (7, 1, 'Eat Vegetables', 1, 7, '1 point for some, 2 points for USRDA.', 'http://www.mypyramid.gov/pyramid/vegetables_amount.aspx'), (8, 1, 'Eat Fruits', 1, 8, '1 point for some, 2 for the USRDA.', 'http://www.mypyramid.gov/pyramid/fruits_amount.aspx'), (9, 2, 'Crafts', 3, 1, '1 point per day.', NULL), (10, 2, 'Hobby', 3, 2, '1 point per day.', NULL), (11, 2, 'Personal Quiet Time', 3, 3, '1 point per day.', NULL), (12, 2, 'Destress', 3, 4, '1 point per day.', NULL), (13, 2, 'Other', 3, 5, '1 point per day.', NULL), (14, 2, 'Class', 3, 6, '10 points per class. This includes Weight Watchers', NULL), (15, 3, 'Minimum Exertion', 3, 1, '1 point per 1/2 hour.', NULL), (16, 3, 'Moderate Exertion', 3, 2, '2 points per 1/2 hour.', NULL), (17, 3, 'Maximum Exertion', 3, 3, '3 points per 1/2 hour.', NULL), (18, 3, '10,000 Steps', 1, 4, '1 point for 8,000 to 9,999 steps, 2 points for 10,000 steps or more.', NULL), (19, 4, 'Test Blood Cholesterol', 2, 1, '20 points.', NULL), (20, 5, 'Test Blood Sugar', 2, 2, 'Test Blood Sugar as prescribed/reccomended', 'http://www.mayoclinic.com/health/blood-sugar/DA00007'), (21, 4, 'Test Blood Pressure', 2, 3, '1 point.', NULL), (22, 4, 'Preventive Health Medical Appo', 2, 4, '5 points.', NULL), (23, 5, 'Formal Sports', 3, 1, '20 points for season long participation in a formal recreational sport', NULL), (24, 5, 'Weight Change', 3, 3, '2 points for each pound lost, -2 points for each pound gained.', NULL), (25, 5, 'Stop Smoking', 2, 4, '100 points for not smoking, or for quitting for the duration of the program.', NULL), (26, 2, 'Charitable Activity', 2, 5, 'Participate in a charitable activity or donate to a charitable cause', NULL), (27, 5, 'Pound for Pound Challenge', 2, 6, 'Participate in the Pound for Pound Challenge, Join the team if you are not on another team', 'http://www.pfpchallenge.com/default.aspx'); -- -------------------------------------------------------- -- -- Table structure for table `points` -- CREATE TABLE IF NOT EXISTS `points` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `activity_id` int(11) NOT NULL, `date` date NOT NULL, `entry` int(11) NOT NULL, `points` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=116806 ; -- -- Dumping data for table `points` -- INSERT INTO `points` (`id`, `user_id`, `activity_id`, `date`, `entry`, `points`) VALUES (75035, 28, 1, '2011-05-13', 1, 1), (75036, 28, 4, '2011-05-13', 8, 8), (75037, 28, 5, '2011-05-13', 2, 2), (75038, 28, 6, '2011-05-13', 5, 5), (75039, 28, 7, '2011-05-13', 1, 1), (75040, 28, 10, '2011-05-13', 1, 1), (75041, 28, 13, '2011-05-13', 1, 1), (75042, 28, 16, '2011-05-13', 1, 1), (75043, 28, 26, '2011-05-13', 2, 2), (75044, 28, 2, '2011-05-14', 1, 1), (75045, 28, 4, '2011-05-14', 5, 5), (75046, 28, 6, '2011-05-14', 8, 5), (75047, 28, 7, '2011-05-14', 1, 1), (75048, 28, 13, '2011-05-14', 1, 1), (75049, 28, 16, '2011-05-14', 1, 1), (75050, 28, 21, '2011-05-14', 2, 2), (75051, 28, 22, '2011-05-14', 2, 4), (75052, 28, 23, '2011-05-14', 1, 3), (75053, 28, 26, '2011-05-14', 2, 2), (75411, 28, 3, '2011-05-15', 1, 1), (75412, 28, 4, '2011-05-15', 3, 3), (75413, 28, 6, '2011-05-15', 1, 1), (75414, 28, 7, '2011-05-15', 1, 1), (75415, 28, 13, '2011-05-15', 1, 1), (75416, 28, 15, '2011-05-15', 1, 1), (75417, 28, 16, '2011-05-15', 1, 1), (76510, 28, 1, '2011-05-16', 1, 1), (76511, 28, 3, '2011-05-16', 1, 1), (76512, 28, 4, '2011-05-16', 4, 4), (76513, 28, 5, '2011-05-16', 2, 2), (76514, 28, 6, '2011-05-16', 3, 3), (76515, 28, 7, '2011-05-16', 1, 1), (76516, 28, 11, '2011-05-16', 2, 2), (76517, 28, 13, '2011-05-16', 1, 1), (76518, 28, 16, '2011-05-16', 1, 1), (77745, 28, 2, '2011-05-17', 1, 1), (77746, 28, 4, '2011-05-17', 2, 2), (77747, 28, 5, '2011-05-17', 2, 2), (77748, 28, 6, '2011-05-17', 2, 2), (77749, 28, 7, '2011-05-17', 1, 1), (77750, 28, 10, '2011-05-17', 1, 1), (81236, 28, 1, '2011-05-18', 1, 1), (81237, 28, 2, '2011-05-18', 1, 1), (81238, 28, 4, '2011-05-18', 6, 6), (81239, 28, 5, '2011-05-18', 1, 1), (81240, 28, 6, '2011-05-18', 3, 3), (81241, 28, 7, '2011-05-18', 1, 1), (81242, 28, 1, '2011-05-19', 1, 1), (81243, 28, 6, '2011-05-19', 2, 2), (81244, 28, 7, '2011-05-19', 1, 1), (81245, 28, 16, '2011-05-19', 1, 1), (81246, 28, 7, '2011-05-22', 1, 1), (81247, 28, 34, '2011-05-22', 1, 1), (86807, 28, 5, '2011-05-23', 1, 1), (86808, 28, 6, '2011-05-23', 3, 3), (86809, 28, 7, '2011-05-23', 1, 1), (86810, 28, 5, '2011-05-24', 1, 1), (86811, 28, 6, '2011-05-24', 3, 3), (86812, 28, 7, '2011-05-24', 1, 1), (86813, 28, 5, '2011-05-25', 1, 1), (86814, 28, 6, '2011-05-25', 3, 3), (86815, 28, 7, '2011-05-25', 1, 1), (86816, 28, 1, '2011-05-26', 1, 1), (86817, 28, 3, '2011-05-26', 1, 1), (86818, 28, 4, '2011-05-26', 8, 8), (86819, 28, 6, '2011-05-26', 3, 3), (86820, 28, 7, '2011-05-26', 1, 1), (86821, 28, 19, '2011-05-26', 1, 1), (86822, 28, 1, '2011-05-27', 1, 1), (86823, 28, 2, '2011-05-27', 1, 1), (86824, 28, 4, '2011-05-27', 8, 8), (86825, 28, 6, '2011-05-27', 5, 5), (86826, 28, 7, '2011-05-27', 1, 1), (86827, 28, 16, '2011-05-27', 1, 1), (86828, 28, 19, '2011-05-27', 1, 1), (86829, 28, 26, '2011-05-27', 2, 2), (86830, 28, 1, '2011-05-28', 1, 1), (86831, 28, 3, '2011-05-28', 1, 1), (86832, 28, 4, '2011-05-28', 6, 6), (86833, 28, 6, '2011-05-28', 4, 4), (86834, 28, 7, '2011-05-28', 1, 1), (86835, 28, 15, '2011-05-28', 1, 1), (86836, 28, 16, '2011-05-28', 1, 1), (86837, 28, 34, '2011-05-28', 1, 1), (86838, 28, 1, '2011-05-29', 1, 1), (86839, 28, 2, '2011-05-29', 1, 1), (86840, 28, 3, '2011-05-29', 1, 1), (86841, 28, 4, '2011-05-29', 8, 8), (86842, 28, 5, '2011-05-29', 2, 2), (86843, 28, 6, '2011-05-29', 8, 5), (86844, 28, 7, '2011-05-29', 1, 1), (86845, 28, 13, '2011-05-29', 1, 1), (86846, 28, 16, '2011-05-29', 1, 1), (86847, 28, 18, '2011-05-29', 1, 1), (86848, 28, 19, '2011-05-29', 1, 1), (86849, 28, 26, '2011-05-29', 2, 2), (90928, 28, 1, '2011-05-30', 1, 1), (90929, 28, 3, '2011-05-30', 1, 1), (90930, 28, 4, '2011-05-30', 6, 6), (90931, 28, 7, '2011-05-30', 1, 1), (90932, 28, 16, '2011-05-30', 1, 1), (90933, 28, 1, '2011-05-31', 1, 1), (90934, 28, 2, '2011-05-31', 1, 1), (90935, 28, 4, '2011-05-31', 5, 5), (90936, 28, 6, '2011-05-31', 3, 3), (90937, 28, 7, '2011-05-31', 1, 1), (90938, 28, 10, '2011-05-31', 1, 1), (90939, 28, 16, '2011-05-31', 1, 1), (90940, 28, 1, '2011-06-01', 1, 1), (90941, 28, 3, '2011-06-01', 1, 1), (90942, 28, 4, '2011-06-01', 4, 4), (90943, 28, 7, '2011-06-01', 1, 1), (90944, 28, 10, '2011-06-01', 1, 1), (90945, 28, 15, '2011-06-01', 1, 1), (90946, 28, 25, '2011-06-01', 1, 1), (91798, 28, 1, '2011-06-02', 1, 1), (91799, 28, 3, '2011-06-02', 1, 1), (91800, 28, 4, '2011-06-02', 4, 4), (91801, 28, 5, '2011-06-02', 2, 2), (91802, 28, 6, '2011-06-02', 4, 4), (91803, 28, 7, '2011-06-02', 1, 1), (91804, 28, 16, '2011-06-02', 1, 1), (92362, 28, 1, '2011-06-03', 1, 1), (92363, 28, 3, '2011-06-03', 1, 1), (92364, 28, 4, '2011-06-03', 2, 2), (92365, 28, 5, '2011-06-03', 1, 1), (92366, 28, 6, '2011-06-03', 4, 4), (92367, 28, 7, '2011-06-03', 1, 1), (92368, 28, 16, '2011-06-03', 1, 1), (92369, 28, 26, '2011-06-03', 2, 2), (92561, 28, 1, '2011-06-04', 1, 1), (92562, 28, 3, '2011-06-04', 1, 1), (92563, 28, 4, '2011-06-04', 4, 4), (92564, 28, 5, '2011-06-04', 1, 1), (92565, 28, 6, '2011-06-04', 5, 5), (92566, 28, 7, '2011-06-04', 1, 1), (92567, 28, 16, '2011-06-04', 1, 1), (92568, 28, 34, '2011-06-04', 1, 1), (92569, 28, 23, '2011-06-04', 3, 9), (92570, 28, 26, '2011-06-04', 2, 2), (93284, 28, 1, '2011-06-05', 1, 1), (93285, 28, 2, '2011-06-05', 1, 1), (93286, 28, 4, '2011-06-05', 2, 2), (93287, 28, 5, '2011-06-05', 1, 1), (93288, 28, 6, '2011-06-05', 3, 3), (93289, 28, 7, '2011-06-05', 1, 1), (93290, 28, 9, '2011-06-05', 0, 0), (93291, 28, 16, '2011-06-05', 1, 1), (93292, 28, 25, '2011-06-05', 1, 1), (94271, 28, 1, '2011-06-06', 1, 1), (94272, 28, 3, '2011-06-06', 1, 1), (94273, 28, 4, '2011-06-06', 3, 3), (94274, 28, 5, '2011-06-06', 1, 1), (94275, 28, 6, '2011-06-06', 3, 3), (94276, 28, 7, '2011-06-06', 1, 1), (94277, 28, 15, '2011-06-06', 1, 1), (94278, 28, 16, '2011-06-06', 1, 1), (94279, 28, 22, '2011-06-06', 8, 16), (95120, 28, 1, '2011-06-07', 1, 1), (95121, 28, 3, '2011-06-07', 1, 1), (95122, 28, 4, '2011-06-07', 4, 4), (95123, 28, 5, '2011-06-07', 2, 2), (95124, 28, 6, '2011-06-07', 4, 4), (95125, 28, 7, '2011-06-07', 1, 1), (95126, 28, 10, '2011-06-07', 1, 1), (95127, 28, 16, '2011-06-07', 1, 1), (95128, 28, 22, '2011-06-07', 2, 4), (95129, 28, 25, '2011-06-07', 1, 1), (95857, 28, 1, '2011-06-08', 1, 1), (95858, 28, 3, '2011-06-08', 1, 1), (95859, 28, 4, '2011-06-08', 4, 4), (95860, 28, 5, '2011-06-08', 2, 2), (95861, 28, 6, '2011-06-08', 4, 4), (95862, 28, 7, '2011-06-08', 1, 1), (95863, 28, 10, '2011-06-08', 1, 1), (95864, 28, 15, '2011-06-08', 1, 1), (95865, 28, 16, '2011-06-08', 1, 1), (95866, 28, 19, '2011-06-08', 1, 1), (95867, 28, 22, '2011-06-08', 2, 4), (95868, 28, 25, '2011-06-08', 1, 1), (98164, 28, 1, '2011-06-09', 1, 1), (98165, 28, 3, '2011-06-09', 1, 1), (98166, 28, 4, '2011-06-09', 4, 4), (98167, 28, 5, '2011-06-09', 1, 1), (98168, 28, 6, '2011-06-09', 3, 3), (98169, 28, 7, '2011-06-09', 1, 1), (98170, 28, 10, '2011-06-09', 1, 1), (98171, 28, 16, '2011-06-09', 1, 1), (98172, 28, 34, '2011-06-09', 1, 1), (98173, 28, 26, '2011-06-09', 2, 2), (98174, 28, 2, '2011-06-10', 1, 1), (98175, 28, 3, '2011-06-10', 1, 1), (98176, 28, 4, '2011-06-10', 2, 2), (98177, 28, 5, '2011-06-10', 1, 1), (98178, 28, 6, '2011-06-10', 4, 4), (98179, 28, 7, '2011-06-10', 1, 1), (98180, 28, 11, '2011-06-10', 2, 2), (98181, 28, 15, '2011-06-10', 1, 1), (98182, 28, 16, '2011-06-10', 1, 1), (98183, 28, 22, '2011-06-10', 2, 4), (98184, 28, 26, '2011-06-10', 2, 2), (98311, 28, 1, '2011-06-11', 1, 1), (98312, 28, 2, '2011-06-11', 1, 1), (98313, 28, 3, '2011-06-11', 1, 1), (98314, 28, 4, '2011-06-11', 3, 3), (98315, 28, 5, '2011-06-11', 1, 1), (98316, 28, 6, '2011-06-11', 3, 3), (98317, 28, 7, '2011-06-11', 1, 1), (98318, 28, 11, '2011-06-11', 2, 2), (98319, 28, 13, '2011-06-11', 1, 1), (98320, 28, 15, '2011-06-11', 1, 1), (98321, 28, 16, '2011-06-11', 1, 1), (98322, 28, 19, '2011-06-11', 1, 1), (98323, 28, 22, '2011-06-11', 2, 4), (99801, 28, 1, '2011-06-12', 1, 1), (99802, 28, 3, '2011-06-12', 1, 1), (99803, 28, 4, '2011-06-12', 2, 2), (99804, 28, 5, '2011-06-12', 1, 1), (99805, 28, 6, '2011-06-12', 3, 3), (99806, 28, 7, '2011-06-12', 1, 1), (99807, 28, 10, '2011-06-12', 1, 1), (99808, 28, 13, '2011-06-12', 1, 1), (99809, 28, 16, '2011-06-12', 1, 1), (99810, 28, 19, '2011-06-12', 1, 1), (99811, 28, 34, '2011-06-12', 1, 1), (99812, 28, 25, '2011-06-12', 1, 1), (101201, 28, 1, '2011-06-13', 1, 1), (101202, 28, 3, '2011-06-13', 1, 1), (101203, 28, 4, '2011-06-13', 3, 3), (101204, 28, 5, '2011-06-13', 1, 1), (101205, 28, 6, '2011-06-13', 5, 5), (101206, 28, 7, '2011-06-13', 1, 1), (101207, 28, 8, '2011-06-13', 1, 1), (101208, 28, 10, '2011-06-13', 1, 1), (101209, 28, 13, '2011-06-13', 1, 1), (101210, 28, 16, '2011-06-13', 1, 1), (101211, 28, 19, '2011-06-13', 1, 1), (101212, 28, 22, '2011-06-13', 6, 12), (101213, 28, 26, '2011-06-13', 2, 2), (101430, 28, 1, '2011-06-14', 1, 1), (101431, 28, 3, '2011-06-14', 1, 1), (101432, 28, 10, '2011-06-14', 1, 1), (101433, 28, 22, '2011-06-14', 12, 24), (102394, 28, 1, '2011-06-15', 1, 1), (102395, 28, 3, '2011-06-15', 1, 1), (102396, 28, 7, '2011-06-15', 1, 1), (102397, 28, 13, '2011-06-15', 1, 1), (102398, 28, 22, '2011-06-15', 12, 24), (103587, 28, 1, '2011-06-16', 1, 1), (103588, 28, 4, '2011-06-16', 2, 2), (103589, 28, 6, '2011-06-16', 2, 2), (103590, 28, 7, '2011-06-16', 1, 1), (103591, 28, 10, '2011-06-16', 1, 1), (103592, 28, 13, '2011-06-16', 1, 1), (103593, 28, 16, '2011-06-16', 1, 1), (103594, 28, 22, '2011-06-16', 9, 18), (104066, 28, 1, '2011-06-17', 1, 1), (104067, 28, 4, '2011-06-17', 2, 2), (104068, 28, 5, '2011-06-17', 1, 1), (104069, 28, 6, '2011-06-17', 2, 2), (104070, 28, 7, '2011-06-17', 1, 1), (104071, 28, 10, '2011-06-17', 1, 1), (104072, 28, 13, '2011-06-17', 1, 1), (104073, 28, 15, '2011-06-17', 1, 1), (104074, 28, 19, '2011-06-17', 1, 1), (104075, 28, 22, '2011-06-17', 6, 12), (104270, 28, 3, '2011-06-18', 1, 1), (104271, 28, 4, '2011-06-18', 3, 3), (104272, 28, 6, '2011-06-18', 2, 2), (104273, 28, 7, '2011-06-18', 1, 1), (104274, 28, 10, '2011-06-18', 1, 1), (104275, 28, 13, '2011-06-18', 1, 1), (104276, 28, 16, '2011-06-18', 1, 1), (104277, 28, 18, '2011-06-18', 1, 1), (104278, 28, 22, '2011-06-18', 2, 4), (105591, 28, 2, '2011-06-19', 1, 1), (105592, 28, 3, '2011-06-19', 1, 1), (105593, 28, 4, '2011-06-19', 2, 2), (105594, 28, 5, '2011-06-19', 1, 1), (105595, 28, 6, '2011-06-19', 2, 2), (105596, 28, 7, '2011-06-19', 1, 1), (105597, 28, 10, '2011-06-19', 1, 1), (105598, 28, 14, '2011-06-19', 2, 2), (105599, 28, 15, '2011-06-19', 1, 1), (105600, 28, 19, '2011-06-19', 1, 1), (105601, 28, 34, '2011-06-19', 1, 1), (105602, 28, 22, '2011-06-19', 3, 6), (106064, 28, 1, '2011-06-20', 1, 1), (106065, 28, 2, '2011-06-20', 1, 1), (106066, 28, 3, '2011-06-20', 1, 1), (106067, 28, 4, '2011-06-20', 2, 2), (106068, 28, 5, '2011-06-20', 1, 1), (106069, 28, 6, '2011-06-20', 3, 3), (106070, 28, 7, '2011-06-20', 1, 1), (106071, 28, 10, '2011-06-20', 1, 1), (106072, 28, 13, '2011-06-20', 1, 1), (106073, 28, 16, '2011-06-20', 1, 1), (106074, 28, 34, '2011-06-20', 1, 1), (106075, 28, 22, '2011-06-20', 2, 4), (107120, 28, 2, '2011-06-21', 1, 1), (107121, 28, 3, '2011-06-21', 1, 1), (107122, 28, 4, '2011-06-21', 2, 2), (107123, 28, 5, '2011-06-21', 1, 1), (107124, 28, 6, '2011-06-21', 5, 5), (107125, 28, 7, '2011-06-21', 1, 1), (107126, 28, 10, '2011-06-21', 1, 1), (107127, 28, 13, '2011-06-21', 1, 1), (107128, 28, 19, '2011-06-21', 1, 1), (107129, 28, 34, '2011-06-21', 1, 1), (107130, 28, 21, '2011-06-21', 6, 6), (107131, 28, 26, '2011-06-21', 2, 2), (107132, 28, 27, '2011-06-21', 20, 20), (108693, 28, 2, '2011-06-22', 1, 1), (108694, 28, 3, '2011-06-22', 1, 1), (108695, 28, 4, '2011-06-22', 2, 2), (108696, 28, 5, '2011-06-22', 1, 1), (108697, 28, 6, '2011-06-22', 5, 5), (108698, 28, 7, '2011-06-22', 1, 1), (108699, 28, 10, '2011-06-22', 1, 1), (108700, 28, 15, '2011-06-22', 1, 1), (108701, 28, 19, '2011-06-22', 1, 1), (108702, 28, 34, '2011-06-22', 1, 1), (108703, 28, 21, '2011-06-22', 4, 4), (108704, 28, 26, '2011-06-22', 2, 2), (109150, 28, 2, '2011-06-23', 1, 1), (109151, 28, 3, '2011-06-23', 1, 1), (109152, 28, 4, '2011-06-23', 2, 2), (109153, 28, 5, '2011-06-23', 2, 2), (109154, 28, 6, '2011-06-23', 3, 3), (109155, 28, 7, '2011-06-23', 1, 1), (109156, 28, 10, '2011-06-23', 1, 1), (109157, 28, 13, '2011-06-23', 1, 1), (109158, 28, 16, '2011-06-23', 1, 1), (109159, 28, 34, '2011-06-23', 1, 1), (110063, 28, 1, '2011-06-24', 1, 1), (110064, 28, 3, '2011-06-24', 1, 1), (110065, 28, 5, '2011-06-24', 1, 1), (110066, 28, 6, '2011-06-24', 4, 4), (110067, 28, 7, '2011-06-24', 1, 1), (110068, 28, 15, '2011-06-24', 1, 1), (110069, 28, 16, '2011-06-24', 1, 1), (110070, 28, 19, '2011-06-24', 1, 1), (110071, 28, 25, '2011-06-24', 1, 1), (110072, 28, 1, '2011-06-25', 1, 1), (110073, 28, 2, '2011-06-25', 1, 1), (110074, 28, 3, '2011-06-25', 1, 1), (110075, 28, 4, '2011-06-25', 2, 2), (110076, 28, 5, '2011-06-25', 1, 1), (110077, 28, 6, '2011-06-25', 5, 5), (110078, 28, 7, '2011-06-25', 1, 1), (110079, 28, 10, '2011-06-25', 1, 1), (110080, 28, 13, '2011-06-25', 1, 1), (110081, 28, 16, '2011-06-25', 1, 1), (110082, 28, 19, '2011-06-25', 1, 1), (110083, 28, 26, '2011-06-25', 2, 2), (111626, 28, 1, '2011-06-27', 1, 1), (111627, 28, 2, '2011-06-27', 1, 1), (111628, 28, 3, '2011-06-27', 1, 1), (111629, 28, 4, '2011-06-27', 2, 2), (111630, 28, 5, '2011-06-27', 1, 1), (111631, 28, 6, '2011-06-27', 3, 3), (111632, 28, 7, '2011-06-27', 1, 1), (111633, 28, 10, '2011-06-27', 1, 1), (111634, 28, 13, '2011-06-27', 1, 1), (111635, 28, 16, '2011-06-27', 1, 1), (111636, 28, 34, '2011-06-27', 1, 1), (111637, 28, 21, '2011-06-27', 2, 2), (112437, 28, 1, '2011-06-26', 1, 1), (112438, 28, 2, '2011-06-26', 1, 1), (112439, 28, 4, '2011-06-26', 2, 2), (112440, 28, 5, '2011-06-26', 1, 1), (112441, 28, 6, '2011-06-26', 3, 3), (112442, 28, 7, '2011-06-26', 1, 1), (112443, 28, 10, '2011-06-26', 1, 1), (112444, 28, 15, '2011-06-26', 1, 1), (112445, 28, 19, '2011-06-26', 2, 1), (112446, 28, 34, '2011-06-26', 1, 1), (112447, 28, 25, '2011-06-26', 1, 1), (112448, 28, 1, '2011-06-28', 1, 1), (112449, 28, 3, '2011-06-28', 1, 1), (112450, 28, 4, '2011-06-28', 2, 2), (112451, 28, 5, '2011-06-28', 1, 1), (112452, 28, 6, '2011-06-28', 6, 5), (112453, 28, 7, '2011-06-28', 1, 1), (112454, 28, 10, '2011-06-28', 1, 1), (112455, 28, 34, '2011-06-28', 1, 1), (112456, 28, 26, '2011-06-28', 2, 2), (113835, 28, 1, '2011-06-29', 1, 1), (113836, 28, 2, '2011-06-29', 1, 1), (113837, 28, 5, '2011-06-29', 1, 1), (113838, 28, 16, '2011-06-29', 1, 1), (113839, 28, 22, '2011-06-29', 7, 14), (113840, 28, 26, '2011-06-29', 2, 2), (114122, 28, 2, '2011-06-30', 1, 1), (114123, 28, 32, '2011-06-30', 20, 40), (114124, 28, 35, '2011-06-30', 25, 25), (116283, 28, 1, '2011-07-01', 1, 1), (116284, 28, 4, '2011-07-01', 2, 2), (116285, 28, 16, '2011-07-01', 1, 1), (85262, 214, 1, '2011-05-20', 1, 1), (85263, 214, 2, '2011-05-20', 1, 1), (85264, 214, 3, '2011-05-20', 1, 1), (85265, 214, 4, '2011-05-20', 4, 4), (85266, 214, 6, '2011-05-20', 1, 1), (85267, 214, 7, '2011-05-20', 1, 1), (85268, 214, 10, '2011-05-20', 1, 1), (85269, 214, 14, '2011-05-20', 2, 2), (85270, 214, 19, '2011-05-20', 1, 1), (85271, 214, 34, '2011-05-20', 1, 1), (85272, 214, 21, '2011-05-20', 3, 3), (85273, 214, 24, '2011-05-20', 0, 0), (85290, 214, 1, '2011-05-21', 1, 1), (85291, 214, 2, '2011-05-21', 1, 1), (85292, 214, 3, '2011-05-21', 1, 1), (85293, 214, 4, '2011-05-21', 3, 3), (85294, 214, 5, '2011-05-21', 6, 2), (85295, 214, 7, '2011-05-21', 1, 1), (85296, 214, 10, '2011-05-21', 1, 1), (85297, 214, 13, '2011-05-21', 1, 1), (85298, 214, 19, '2011-05-21', 1, 1), (85299, 214, 21, '2011-05-21', 2, 2), (85300, 214, 24, '2011-05-21', 0, 0), (77138, 248, 4, '2011-05-13', 3, 3), (77139, 248, 5, '2011-05-13', 4, 2), (77140, 248, 7, '2011-05-13', 1, 1), (77141, 248, 10, '2011-05-13', 1, 1), (77142, 248, 12, '2011-05-13', 0, 0), (77143, 248, 21, '2011-05-13', 2, 2), (77144, 248, 24, '2011-05-13', 0, 0), (77145, 248, 4, '2011-05-14', 4, 4), (77146, 248, 5, '2011-05-14', 10, 2), (77147, 248, 6, '2011-05-14', 3, 3), (77148, 248, 7, '2011-05-14', 1, 1), (77149, 248, 10, '2011-05-14', 1, 1), (77150, 248, 13, '2011-05-14', 1, 1), (77151, 248, 22, '2011-05-14', 4, 8), (77152, 248, 26, '2011-05-14', 2, 2), (77153, 248, 4, '2011-05-15', 4, 4), (77154, 248, 7, '2011-05-15', 1, 1), (77155, 248, 10, '2011-05-15', 1, 1), (77156, 248, 12, '2011-05-15', 0, 0), (77157, 248, 24, '2011-05-15', 0, 0), (77158, 248, 4, '2011-05-16', 6, 6), (77159, 248, 5, '2011-05-16', 4, 2), (77160, 248, 7, '2011-05-16', 1, 1), (77161, 248, 8, '2011-05-16', 1, 1), (77162, 248, 9, '2011-05-16', 0, 0), (77163, 248, 12, '2011-05-16', 0, 0), (77164, 248, 24, '2011-05-16', 0, 0), (78166, 248, 3, '2011-05-17', 1, 1), (78167, 248, 4, '2011-05-17', 2, 2), (78168, 248, 7, '2011-05-17', 1, 1), (78169, 248, 10, '2011-05-17', 1, 1), (78170, 248, 12, '2011-05-17', 0, 0), (78171, 248, 24, '2011-05-17', 0, 0), (79755, 248, 4, '2011-05-18', 4, 4), (79756, 248, 5, '2011-05-18', 4, 2), (79757, 248, 7, '2011-05-18', 1, 1), (79758, 248, 10, '2011-05-18', 1, 1), (79759, 248, 12, '2011-05-18', 0, 0), (79760, 248, 24, '2011-05-18', 0, 0), (79761, 248, 4, '2011-05-19', 6, 6), (79762, 248, 5, '2011-05-19', 6, 2), (79763, 248, 6, '2011-05-19', 1, 1), (79764, 248, 7, '2011-05-19', 1, 1), (79765, 248, 10, '2011-05-19', 1, 1), (79766, 248, 12, '2011-05-19', 0, 0), (79767, 248, 22, '2011-05-19', 4, 8), (79768, 248, 26, '2011-05-19', 2, 2), (81652, 248, 4, '2011-05-20', 4, 4), (81653, 248, 5, '2011-05-20', 6, 2), (81654, 248, 6, '2011-05-20', 1, 1), (81655, 248, 7, '2011-05-20', 1, 1), (81656, 248, 10, '2011-05-20', 1, 1), (81657, 248, 12, '2011-05-20', 0, 0), (81658, 248, 18, '2011-05-20', 1, 1), (81659, 248, 25, '2011-05-20', 1, 1), (81660, 248, 4, '2011-05-21', 4, 4), (81661, 248, 5, '2011-05-21', 3, 2), (81662, 248, 6, '2011-05-21', 1, 1), (81663, 248, 7, '2011-05-21', 1, 1), (81664, 248, 10, '2011-05-21', 1, 1), (81665, 248, 13, '2011-05-21', 1, 1), (81666, 248, 18, '2011-05-21', 1, 1), (81667, 248, 25, '2011-05-21', 1, 1), (81668, 248, 4, '2011-05-22', 6, 6), (81669, 248, 5, '2011-05-22', 8, 2), (81670, 248, 6, '2011-05-22', 1, 1), (81671, 248, 7, '2011-05-22', 1, 1), (81672, 248, 10, '2011-05-22', 1, 1), (81673, 248, 13, '2011-05-22', 1, 1), (81674, 248, 18, '2011-05-22', 1, 1), (81675, 248, 22, '2011-05-22', 6, 12), (81676, 248, 26, '2011-05-22', 2, 2), (82399, 248, 3, '2011-05-23', 1, 1), (82400, 248, 4, '2011-05-23', 4, 4), (82401, 248, 5, '2011-05-23', 6, 2), (82402, 248, 7, '2011-05-23', 1, 1), (82403, 248, 10, '2011-05-23', 1, 1), (82404, 248, 13, '2011-05-23', 1, 1), (82405, 248, 18, '2011-05-23', 1, 1), (82406, 248, 26, '2011-05-23', 2, 2), (83009, 248, 3, '2011-05-24', 1, 1), (83010, 248, 4, '2011-05-24', 4, 4), (83011, 248, 5, '2011-05-24', 8, 2), (83012, 248, 6, '2011-05-24', 1, 1), (83013, 248, 7, '2011-05-24', 1, 1), (83014, 248, 10, '2011-05-24', 1, 1), (83015, 248, 13, '2011-05-24', 1, 1), (83016, 248, 18, '2011-05-24', 1, 1), (83017, 248, 21, '2011-05-24', 6, 6), (83018, 248, 26, '2011-05-24', 2, 2), (84800, 248, 2, '2011-05-25', 1, 1), (84801, 248, 4, '2011-05-25', 3, 3), (84802, 248, 5, '2011-05-25', 6, 2), (84803, 248, 7, '2011-05-25', 1, 1), (84804, 248, 10, '2011-05-25', 1, 1), (84805, 248, 13, '2011-05-25', 1, 1), (84806, 248, 18, '2011-05-25', 1, 1), (84807, 248, 21, '2011-05-25', 1, 1), (84808, 248, 24, '2011-05-25', 0, 0), (85914, 248, 4, '2011-05-26', 2, 2), (85915, 248, 5, '2011-05-26', 6, 2), (85916, 248, 6, '2011-05-26', 1, 1), (85917, 248, 7, '2011-05-26', 1, 1), (85918, 248, 10, '2011-05-26', 1, 1), (85919, 248, 13, '2011-05-26', 1, 1), (85920, 248, 18, '2011-05-26', 1, 1), (85921, 248, 21, '2011-05-26', 1, 1), (85922, 248, 25, '2011-05-26', 1, 1), (87361, 248, 4, '2011-05-27', 8, 8), (87362, 248, 5, '2011-05-27', 10, 2), (87363, 248, 6, '2011-05-27', 2, 2), (87364, 248, 7, '2011-05-27', 1, 1), (87365, 248, 10, '2011-05-27', 1, 1), (87366, 248, 13, '2011-05-27', 1, 1), (87367, 248, 18, '2011-05-27', 1, 1), (87368, 248, 21, '2011-05-27', 2, 2), (87369, 248, 25, '2011-05-27', 1, 1), (87370, 248, 2, '2011-05-28', 1, 1), (87371, 248, 4, '2011-05-28', 8, 8), (87372, 248, 5, '2011-05-28', 4, 2), (87373, 248, 6, '2011-05-28', 2, 2), (87374, 248, 7, '2011-05-28', 1, 1), (87375, 248, 10, '2011-05-28', 1, 1), (87376, 248, 12, '2011-05-28', 0, 0), (87377, 248, 18, '2011-05-28', 1, 1), (87378, 248, 22, '2011-05-28', 10, 20), (87379, 248, 26, '2011-05-28', 2, 2), (87380, 248, 2, '2011-05-29', 1, 1), (87381, 248, 4, '2011-05-29', 8, 8), (87382, 248, 5, '2011-05-29', 4, 2), (87383, 248, 7, '2011-05-29', 1, 1), (87384, 248, 10, '2011-05-29', 1, 1), (87385, 248, 12, '2011-05-29', 0, 0), (87386, 248, 18, '2011-05-29', 1, 1), (87387, 248, 22, '2011-05-29', 4, 8), (87388, 248, 26, '2011-05-29', 2, 2), (87389, 248, 5, '2011-05-30', 4, 2), (87390, 248, 6, '2011-05-30', 1, 1), (87391, 248, 10, '2011-05-30', 1, 1), (87392, 248, 18, '2011-05-30', 2, 1), (87393, 248, 21, '2011-05-30', 2, 2), (87394, 248, 26, '2011-05-30', 2, 2), (89463, 248, 3, '2011-05-31', 1, 1), (89464, 248, 4, '2011-05-31', 6, 6), (89465, 248, 5, '2011-05-31', 4, 2), (89466, 248, 6, '2011-05-31', 1, 1), (89467, 248, 7, '2011-05-31', 1, 1), (89468, 248, 10, '2011-05-31', 1, 1), (89469, 248, 12, '2011-05-31', 0, 0), (89470, 248, 18, '2011-05-31', 1, 1), (89471, 248, 21, '2011-05-31', 2, 2), (89472, 248, 26, '2011-05-31', 2, 2), (90109, 248, 3, '2011-06-01', 1, 1), (90110, 248, 4, '2011-06-01', 4, 4), (90111, 248, 5, '2011-06-01', 4, 2), (90112, 248, 6, '2011-06-01', 1, 1), (90113, 248, 7, '2011-06-01', 1, 1), (90114, 248, 10, '2011-06-01', 1, 1), (90115, 248, 12, '2011-06-01', 0, 0), (90116, 248, 18, '2011-06-01', 1, 1), (90117, 248, 26, '2011-06-01', 2, 2), (91567, 248, 4, '2011-06-02', 5, 5), (91568, 248, 5, '2011-06-02', 5, 2), (91569, 248, 7, '2011-06-02', 1, 1), (91570, 248, 10, '2011-06-02', 1, 1), (91571, 248, 12, '2011-06-02', 0, 0), (91572, 248, 18, '2011-06-02', 1, 1), (92850, 248, 2, '2011-06-03', 1, 1), (92851, 248, 4, '2011-06-03', 5, 5), (92852, 248, 5, '2011-06-03', 5, 2), (92853, 248, 6, '2011-06-03', 1, 1), (92854, 248, 7, '2011-06-03', 1, 1), (92855, 248, 10, '2011-06-03', 1, 1), (92856, 248, 13, '2011-06-03', 1, 1), (92857, 248, 18, '2011-06-03', 1, 1), (92858, 248, 26, '2011-06-03', 2, 2), (92859, 248, 3, '2011-06-04', 1, 1), (92860, 248, 4, '2011-06-04', 5, 5), (92861, 248, 5, '2011-06-04', 2, 2), (92862, 248, 6, '2011-06-04', 2, 2), (92863, 248, 7, '2011-06-04', 1, 1), (92864, 248, 10, '2011-06-04', 1, 1), (92865, 248, 13, '2011-06-04', 1, 1), (92866, 248, 18, '2011-06-04', 1, 1), (92867, 248, 21, '2011-06-04', 2, 2), (92868, 248, 26, '2011-06-04', 2, 2), (92869, 248, 3, '2011-06-05', 1, 1), (92870, 248, 4, '2011-06-05', 5, 5), (92871, 248, 5, '2011-06-05', 2, 2), (92872, 248, 6, '2011-06-05', 1, 1), (92873, 248, 10, '2011-06-05', 1, 1), (92874, 248, 13, '2011-06-05', 1, 1), (92875, 248, 18, '2011-06-05', 1, 1), (92876, 248, 22, '2011-06-05', 4, 8), (92877, 248, 26, '2011-06-05', 2, 2), (93978, 248, 1, '2011-06-06', 1, 1), (93979, 248, 4, '2011-06-06', 4, 4), (93980, 248, 5, '2011-06-06', 4, 2), (93981, 248, 7, '2011-06-06', 1, 1), (93982, 248, 10, '2011-06-06', 1, 1), (93983, 248, 12, '2011-06-06', 0, 0), (93984, 248, 18, '2011-06-06', 1, 1), (93985, 248, 21, '2011-06-06', 5, 5), (93986, 248, 26, '2011-06-06', 2, 2), (94980, 248, 2, '2011-06-07', 1, 1), (94981, 248, 4, '2011-06-07', 4, 4), (94982, 248, 5, '2011-06-07', 6, 2), (94983, 248, 7, '2011-06-07', 1, 1), (94984, 248, 11, '2011-06-07', 2, 2), (94985, 248, 12, '2011-06-07', 0, 0), (94986, 248, 18, '2011-06-07', 1, 1), (94987, 248, 21, '2011-06-07', 2, 2), (94988, 248, 25, '2011-06-07', 1, 1), (97362, 248, 3, '2011-06-09', 1, 1), (97363, 248, 4, '2011-06-09', 4, 4), (97364, 248, 5, '2011-06-09', 6, 2), (97365, 248, 6, '2011-06-09', 1, 1), (97366, 248, 7, '2011-06-09', 1, 1), (97367, 248, 10, '2011-06-09', 1, 1), (97368, 248, 12, '2011-06-09', 0, 0), (97369, 248, 18, '2011-06-09', 1, 1), (97370, 248, 22, '2011-06-09', 4, 8), (97371, 248, 26, '2011-06-09', 2, 2), (97372, 248, 2, '2011-06-08', 1, 1), (97373, 248, 4, '2011-06-08', 5, 5), (97374, 248, 5, '2011-06-08', 10, 2), (97375, 248, 6, '2011-06-08', 2, 2), (97376, 248, 7, '2011-06-08', 1, 1), (97377, 248, 10, '2011-06-08', 1, 1), (97378, 248, 12, '2011-06-08', 0, 0), (97379, 248, 18, '2011-06-08', 1, 1), (97380, 248, 22, '2011-06-08', 8, 16), (97381, 248, 26, '2011-06-08', 2, 2), (98935, 248, 2, '2011-06-10', 1, 1), (98936, 248, 4, '2011-06-10', 5, 5), (98937, 248, 5, '2011-06-10', 6, 2), (98938, 248, 6, '2011-06-10', 1, 1), (98939, 248, 7, '2011-06-10', 1, 1), (98940, 248, 10, '2011-06-10', 1, 1), (98941, 248, 12, '2011-06-10', 0, 0), (98942, 248, 18, '2011-06-10', 1, 1), (98943, 248, 22, '2011-06-10', 2, 4), (98944, 248, 26, '2011-06-10', 2, 2), (98961, 248, 4, '2011-06-11', 6, 6), (98962, 248, 5, '2011-06-11', 6, 2), (98963, 248, 6, '2011-06-11', 2, 2), (98964, 248, 7, '2011-06-11', 1, 1), (98965, 248, 10, '2011-06-11', 1, 1), (98966, 248, 12, '2011-06-11', 0, 0), (98967, 248, 18, '2011-06-11', 1, 1), (98968, 248, 22, '2011-06-11', 4, 8), (98969, 248, 26, '2011-06-11', 2, 2), (98997, 248, 4, '2011-06-12', 6, 6), (98998, 248, 5, '2011-06-12', 4, 2), (98999, 248, 6, '2011-06-12', 1, 1), (99000, 248, 7, '2011-06-12', 1, 1), (99001, 248, 10, '2011-06-12', 1, 1), (99002, 248, 18, '2011-06-12', 1, 1), (99003, 248, 21, '2011-06-12', 2, 2), (99004, 248, 26, '2011-06-12', 2, 2), (100515, 248, 2, '2011-06-13', 1, 1), (100516, 248, 4, '2011-06-13', 4, 4), (100517, 248, 5, '2011-06-13', 4, 2), (100518, 248, 6, '2011-06-13', 1, 1), (100519, 248, 10, '2011-06-13', 1, 1), (100520, 248, 12, '2011-06-13', 0, 0), (100521, 248, 17, '2011-06-13', 1, 1), (100522, 248, 21, '2011-06-13', 4, 4), (100523, 248, 26, '2011-06-13', 2, 2), (101486, 248, 4, '2011-06-14', 4, 4), (101487, 248, 5, '2011-06-14', 4, 2), (101488, 248, 6, '2011-06-14', 1, 1), (101489, 248, 7, '2011-06-14', 1, 1), (101490, 248, 10, '2011-06-14', 1, 1), (101491, 248, 13, '2011-06-14', 1, 1), (101492, 248, 18, '2011-06-14', 1, 1), (101493, 248, 21, '2011-06-14', 2, 2), (101494, 248, 26, '2011-06-14', 2, 2), (102436, 248, 4, '2011-06-15', 4, 4), (102437, 248, 5, '2011-06-15', 4, 2), (102438, 248, 6, '2011-06-15', 1, 1), (102439, 248, 7, '2011-06-15', 1, 1), (102440, 248, 9, '2011-06-15', 0, 0), (102441, 248, 12, '2011-06-15', 0, 0), (102442, 248, 18, '2011-06-15', 1, 1), (102443, 248, 21, '2011-06-15', 1, 1), (102444, 248, 26, '2011-06-15', 2, 2), (104990, 248, 4, '2011-06-16', 4, 4), (104991, 248, 5, '2011-06-16', 10, 2), (104992, 248, 6, '2011-06-16', 2, 2), (104993, 248, 7, '2011-06-16', 1, 1), (104994, 248, 10, '2011-06-16', 1, 1), (104995, 248, 12, '2011-06-16', 0, 0), (104996, 248, 18, '2011-06-16', 1, 1), (104997, 248, 22, '2011-06-16', 2, 4), (104998, 248, 26, '2011-06-16', 2, 2), (104999, 248, 2, '2011-06-17', 1, 1), (105000, 248, 4, '2011-06-17', 6, 6), (105001, 248, 5, '2011-06-17', 10, 2), (105002, 248, 6, '2011-06-17', 2, 2), (105003, 248, 7, '2011-06-17', 1, 1), (105004, 248, 10, '2011-06-17', 1, 1), (105005, 248, 12, '2011-06-17', 0, 0), (105006, 248, 18, '2011-06-17', 1, 1), (105007, 248, 22, '2011-06-17', 2, 4), (105008, 248, 26, '2011-06-17', 2, 2), (105023, 248, 4, '2011-06-18', 8, 8), (105024, 248, 5, '2011-06-18', 4, 2), (105025, 248, 6, '2011-06-18', 2, 2), (105026, 248, 7, '2011-06-18', 1, 1), (105027, 248, 10, '2011-06-18', 1, 1), (105028, 248, 12, '2011-06-18', 0, 0), (105029, 248, 18, '2011-06-18', 1, 1), (105030, 248, 22, '2011-06-18', 5, 10), (105031, 248, 26, '2011-06-18', 2, 2), (105054, 248, 2, '2011-06-19', 1, 1), (105055, 248, 4, '2011-06-19', 5, 5), (105056, 248, 5, '2011-06-19', 6, 2), (105057, 248, 7, '2011-06-19', 1, 1), (105058, 248, 10, '2011-06-19', 1, 1), (105059, 248, 12, '2011-06-19', 0, 0), (105060, 248, 17, '2011-06-19', 1, 1), (105061, 248, 18, '2011-06-19', 1, 1), (105062, 248, 21, '2011-06-19', 2, 2), (105063, 248, 26, '2011-06-19', 2, 2), (106728, 248, 3, '2011-06-20', 1, 1), (106729, 248, 4, '2011-06-20', 6, 6), (106730, 248, 5, '2011-06-20', 5, 2), (106731, 248, 6, '2011-06-20', 1, 1), (106732, 248, 7, '2011-06-20', 1, 1), (106733, 248, 18, '2011-06-20', 1, 1), (106734, 248, 19, '2011-06-20', 1, 1), (106735, 248, 21, '2011-06-20', 6, 6), (106736, 248, 26, '2011-06-20', 2, 2), (107312, 248, 2, '2011-06-21', 1, 1), (107313, 248, 4, '2011-06-21', 6, 6), (107314, 248, 5, '2011-06-21', 6, 2), (107315, 248, 6, '2011-06-21', 1, 1), (107316, 248, 7, '2011-06-21', 1, 1), (107317, 248, 10, '2011-06-21', 1, 1), (107318, 248, 12, '2011-06-21', 0, 0), (107319, 248, 18, '2011-06-21', 1, 1), (107320, 248, 26, '2011-06-21', 2, 2), (108062, 248, 2, '2011-06-22', 1, 1), (108063, 248, 4, '2011-06-22', 6, 6), (108064, 248, 5, '2011-06-22', 10, 2), (108065, 248, 6, '2011-06-22', 2, 2), (108066, 248, 7, '2011-06-22', 1, 1), (108067, 248, 10, '2011-06-22', 1, 1), (108068, 248, 12, '2011-06-22', 0, 0), (108069, 248, 17, '2011-06-22', 1, 1), (108070, 248, 18, '2011-06-22', 1, 1), (108071, 248, 21, '2011-06-22', 14, 14), (108072, 248, 26, '2011-06-22', 2, 2), (109244, 248, 2, '2011-06-23', 1, 1), (109245, 248, 4, '2011-06-23', 6, 6), (109246, 248, 5, '2011-06-23', 6, 2), (109247, 248, 6, '2011-06-23', 1, 1), (109248, 248, 7, '2011-06-23', 1, 1), (109249, 248, 10, '2011-06-23', 1, 1), (109250, 248, 17, '2011-06-23', 1, 1), (109251, 248, 18, '2011-06-23', 1, 1), (109252, 248, 26, '2011-06-23', 2, 2), (109808, 248, 2, '2011-06-24', 1, 1), (109809, 248, 4, '2011-06-24', 4, 4), (109810, 248, 5, '2011-06-24', 6, 2), (109811, 248, 6, '2011-06-24', 1, 1), (109812, 248, 7, '2011-06-24', 1, 1), (109813, 248, 10, '2011-06-24', 1, 1), (109814, 248, 13, '2011-06-24', 1, 1), (109815, 248, 18, '2011-06-24', 1, 1), (109816, 248, 21, '2011-06-24', 10, 10), (109817, 248, 26, '2011-06-24', 2, 2), (110914, 248, 4, '2011-06-25', 4, 4), (110915, 248, 5, '2011-06-25', 4, 2), (110916, 248, 7, '2011-06-25', 1, 1), (110917, 248, 10, '2011-06-25', 1, 1), (110918, 248, 18, '2011-06-25', 1, 1), (110919, 248, 21, '2011-06-25', 2, 2), (110920, 248, 25, '2011-06-25', 1, 1), (110921, 248, 3, '2011-06-26', 1, 1), (110922, 248, 4, '2011-06-26', 4, 4), (110923, 248, 5, '2011-06-26', 4, 2), (110924, 248, 7, '2011-06-26', 1, 1), (110925, 248, 10, '2011-06-26', 1, 1), (110926, 248, 12, '2011-06-26', 0, 0), (110927, 248, 17, '2011-06-26', 1, 1), (110928, 248, 18, '2011-06-26', 1, 1), (110929, 248, 22, '2011-06-26', 6, 12), (110930, 248, 26, '2011-06-26', 2, 2), (112235, 248, 2, '2011-06-27', 1, 1), (112236, 248, 4, '2011-06-27', 6, 6), (112237, 248, 6, '2011-06-27', 1, 1), (112238, 248, 7, '2011-06-27', 1, 1), (112239, 248, 10, '2011-06-27', 1, 1), (112240, 248, 17, '2011-06-27', 1, 1), (112241, 248, 18, '2011-06-27', 1, 1), (112242, 248, 21, '2011-06-27', 8, 8), (112243, 248, 26, '2011-06-27', 2, 2), (112598, 248, 4, '2011-06-28', 6, 6), (112599, 248, 5, '2011-06-28', 10, 2), (112600, 248, 6, '2011-06-28', 1, 1), (112601, 248, 7, '2011-06-28', 1, 1), (112602, 248, 10, '2011-06-28', 1, 1), (112603, 248, 12, '2011-06-28', 0, 0), (112604, 248, 17, '2011-06-28', 1, 1), (112605, 248, 18, '2011-06-28', 1, 1), (112606, 248, 21, '2011-06-28', 10, 10), (112607, 248, 26, '2011-06-28', 2, 2), (114323, 248, 2, '2011-06-29', 1, 1), (114324, 248, 3, '2011-06-29', 1, 1), (114325, 248, 5, '2011-06-29', 6, 2), (114326, 248, 7, '2011-06-29', 1, 1), (114327, 248, 10, '2011-06-29', 1, 1), (114328, 248, 17, '2011-06-29', 1, 1), (114329, 248, 18, '2011-06-29', 1, 1), (114330, 248, 19, '2011-06-29', 2, 1), (114331, 248, 21, '2011-06-29', 1, 1), (114332, 248, 25, '2011-06-29', 1, 1), (114944, 248, 2, '2011-06-30', 1, 1), (114945, 248, 3, '2011-06-30', 1, 1), (114946, 248, 4, '2011-06-30', 4, 4), (114947, 248, 5, '2011-06-30', 10, 2), (114948, 248, 6, '2011-06-30', 1, 1), (114949, 248, 7, '2011-06-30', 1, 1), (114950, 248, 10, '2011-06-30', 1, 1), (114951, 248, 12, '2011-06-30', 0, 0), (114952, 248, 17, '2011-06-30', 1, 1), (114953, 248, 19, '2011-06-30', 1, 1), (114954, 248, 21, '2011-06-30', 10, 10), (114955, 248, 26, '2011-06-30', 2, 2), (116792, 248, 4, '2011-07-01', 10, 8), (116793, 248, 5, '2011-07-01', 10, 2), (116794, 248, 6, '2011-07-01', 2, 2), (116795, 248, 7, '2011-07-01', 1, 1), (116796, 248, 8, '2011-07-01', 1, 1), (116797, 248, 10, '2011-07-01', 1, 1), (116798, 248, 13, '2011-07-01', 1, 1), (116799, 248, 15, '2011-07-01', 1, 1), (116800, 248, 16, '2011-07-01', 1, 1), (116801, 248, 17, '2011-07-01', 1, 1), (116802, 248, 18, '2011-07-01', 1, 1), (116803, 248, 21, '2011-07-01', 10, 10), (116804, 248, 22, '2011-07-01', 10, 20), (116805, 248, 26, '2011-07-01', 2, 2); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE IF NOT EXISTS `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `login` varchar(30) NOT NULL, `email_frequency` int(11) NOT NULL, `last_email_date` date NOT NULL, `goal` int(11) NOT NULL, `daily_goal` int(11) NOT NULL, `calendar_theme` int(11) NOT NULL, `last_entry_date` date NOT NULL, `admin` tinyint(1) NOT NULL, `nickname` varchar(30) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=302 ; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `login`, `email_frequency`, `last_email_date`, `goal`, `daily_goal`, `calendar_theme`, `last_entry_date`, `admin`, `nickname`) VALUES (28, 'benji', 0, '2011-07-01', 750, 6, 1, '2011-07-01', 1, 'Benji'), (214, 'lassie', 3, '2011-06-30', 500, 4, 2, '2011-05-21', 0, 'Lassie'), (248, 'sophiedogg', 0, '2011-07-01', 5000, 37, 2, '2011-07-01', 0, 'SophieDogg');