-- Database: `lifeline`
-- 
-- CREATE DATABASE `lifeline`;
-- USE lifeline;

-- --------------------------------------------------------

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

CREATE TABLE `events` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(80) NOT NULL default '',
  `start` datetime NOT NULL default '0000-00-00 00:00:00',
  `end` datetime default '0000-00-00 00:00:00',
  `description` text,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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

INSERT INTO `events` VALUES (1, 'Born', '1952-12-05 00:00:00', '0000-00-00 00:00:00', 'Kelly John Carney is born.');
INSERT INTO `events` VALUES (123, 'Folks Here', '2000-06-20 00:00:00', '2000-06-28 00:00:00', '');
INSERT INTO `events` VALUES (124, 'Elephant Butte', '2000-07-29 00:00:00', '2000-08-05 00:00:00', '');
INSERT INTO `events` VALUES (120, 'Steve and Family here', '1999-04-02 00:00:00', '1999-04-05 00:00:00', '');
INSERT INTO `events` VALUES (121, 'Ireland', '1999-06-01 00:00:00', '0000-00-00 00:00:00', '');
INSERT INTO `events` VALUES (122, 'Ouray', '2000-03-11 00:00:00', '2000-03-19 00:00:00', '');
INSERT INTO `events` VALUES (115, 'Vancouver', '1996-09-18 00:00:00', '0000-00-00 00:00:00', '');
INSERT INTO `events` VALUES (116, 'Maine A''ya', '1997-09-18 00:00:00', '0000-00-00 00:00:00', 'Free tickets, $1000 stock in 10 days.');
INSERT INTO `events` VALUES (117, 'Wis/S.Dakata', '1998-07-01 00:00:00', '0000-00-00 00:00:00', 'Date unsure.');
INSERT INTO `events` VALUES (114, 'Paleo Field School', '1996-06-15 00:00:00', '0000-00-00 00:00:00', 'Two weeks in DeBeque, Colorado. Lost weight, got tan.');
INSERT INTO `events` VALUES (111, 'Xmas in Wis', '1985-12-25 00:00:00', '0000-00-00 00:00:00', 'Janis and Nancy are pregnant!');
INSERT INTO `events` VALUES (112, 'Yellowstone Canoe', '1988-09-18 00:00:00', '0000-00-00 00:00:00', 'Mary was 18 months old. We went with Tim and Teri Bullen. Tim and I took a canoe into the back country...');
INSERT INTO `events` VALUES (113, 'Grand Junction wSteve''s Fam', '1995-07-02 00:00:00', '0000-00-00 00:00:00', 'Date not right. Look in journal1995_07.txt for details.');
INSERT INTO `events` VALUES (118, 'RV weekend', '1998-10-09 00:00:00', '1998-10-11 00:00:00', '');
INSERT INTO `events` VALUES (119, 'Wis', '1998-11-20 00:00:00', '1998-11-28 00:00:00', '');
INSERT INTO `events` VALUES (110, 'Pacific NorthWest', '1985-09-01 00:00:00', '0000-00-00 00:00:00', 'JR was pregnant with Mary. We had driven all day and needed a place to stay. As bad luck would have it, it was ''Pow Wow Days'' in Washington state. I got us a $20 room that made JR burst into tears...');
INSERT INTO `events` VALUES (109, 'Germany', '1984-09-01 00:00:00', '0000-00-00 00:00:00', 'Jeff Armstrong and wife Mary had sent us a postcard saying we should visit. We took them up on their offer. We spent the first week with them and the second week on our own.');
INSERT INTO `events` VALUES (108, 'Cayman Islands', '1983-05-01 00:00:00', '0000-00-00 00:00:00', '');
INSERT INTO `events` VALUES (107, '?Yellowstone/Tetons', '1981-09-18 00:00:00', '0000-00-00 00:00:00', 'The year may be incorrect on this...');
INSERT INTO `events` VALUES (106, 'Mt Audobon', '1980-07-04 00:00:00', '0000-00-00 00:00:00', 'Greenhorns camp above timberline and I end up with a lightning problem...');
INSERT INTO `events` VALUES (105, '1st Xmas in CO', '1977-12-25 00:00:00', '0000-00-00 00:00:00', 'JR and I visited Dave and Barb. I stayed to look for a job...');
INSERT INTO `events` VALUES (104, 'Trip Out West', '1973-08-01 00:00:00', '0000-00-00 00:00:00', 'Mike Antony and I drive through LaCrosse, Minn, S. Dakota, Wyoming, Yellowstone, to Disneyland, back by Grand Canyon.');
INSERT INTO `events` VALUES (103, '1st Colorado Trip with Jerry MacDonald', '1972-12-25 17:00:00', '0000-00-00 00:00:00', '');
INSERT INTO `events` VALUES (125, '1st time Door Cnty Cabin', '2000-09-15 00:00:00', '2000-09-19 00:00:00', '');
INSERT INTO `events` VALUES (126, 'DisneyWorld', '2000-12-15 00:00:00', '2000-12-22 00:00:00', '');
INSERT INTO `events` VALUES (127, 'Get together with Jerry MacDonald', '2001-02-01 00:00:00', '0000-00-00 00:00:00', '');
INSERT INTO `events` VALUES (128, 'Mom and Dad here, Winterpark', '2001-06-12 00:00:00', '0000-00-00 00:00:00', '');
INSERT INTO `events` VALUES (129, 'Fossils/Golf WY Anniv', '2001-09-18 00:00:00', '0000-00-00 00:00:00', '');
INSERT INTO `events` VALUES (130, '1st Mexico', '2001-12-28 00:00:00', '2002-01-04 00:00:00', 'Dave, Barb, Sarah, Jon, Katie, Nick, and us...');
INSERT INTO `events` VALUES (131, 'Door County wHelix', '2002-06-28 00:00:00', '2002-07-08 00:00:00', '');
INSERT INTO `events` VALUES (132, 'Garden Park I', '2002-07-01 00:00:00', '0000-00-00 00:00:00', '');
INSERT INTO `events` VALUES (133, 'Hike to Lone Eagle Peak', '2002-08-01 00:00:00', '0000-00-00 00:00:00', '');
INSERT INTO `events` VALUES (134, 'Wis Vacation - van dies', '2003-06-14 00:00:00', '2003-06-29 00:00:00', 'Sheboygan Falls, Door County, bike, Kenosha (Steve has hole for new house), van dies in Iowa...');
INSERT INTO `events` VALUES (135, 'Garden Park II', '2003-07-01 00:00:00', '0000-00-00 00:00:00', '');
INSERT INTO `events` VALUES (136, 'San Diego', '2003-12-27 00:00:00', '0000-00-00 00:00:00', '1st visit. Dave, Barb, Sarah, Jon, Jerry, Linda, and Rob there too...');
INSERT INTO `events` VALUES (137, 'Girls to Mexico', '2004-06-08 00:00:00', '2004-06-15 00:00:00', 'I stay home and use the money to buy my 17" Powerbook.');
INSERT INTO `events` VALUES (138, 'Xmas in Wis', '2004-12-25 00:00:00', '2005-01-03 00:00:00', '');
INSERT INTO `events` VALUES (139, 'Wisconsin', '2005-06-24 00:00:00', '2005-07-05 00:00:00', '');
INSERT INTO `events` VALUES (140, 'CNG', '2006-06-01 00:00:00', '0000-00-00 00:00:00', 'Comanche National Grassland');
INSERT INTO `events` VALUES (141, 'B.F. Wyoming and Yellowstone', '2006-06-17 00:00:00', '2006-06-23 00:00:00', '');
INSERT INTO `events` VALUES (142, 'Wisconsin', '2006-07-05 00:00:00', '2006-07-14 00:00:00', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `tags`
-- 

CREATE TABLE `tags` (
  `id` int(11) NOT NULL auto_increment,
  `event_id` int(11) NOT NULL default '0',
  `tag` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tags`
--