   PRIMARY KEY       (`id`),
   FOREIGN KEY       (gift_id)       REFERENCES  gifts(id),
   FOREIGN KEY       (group_id)      REFERENCES  groups(id)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     
 INSERT INTO `status` (`id`, `description`) VALUES
 (0, 'yes'),

  PRIMARY KEY       (`id`),
  FOREIGN KEY       (group_id)      REFERENCES  groups(id),
  FOREIGN KEY       (status)        REFERENCES  status(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `locations` (
  `id`              int(4)          NOT NULL     AUTO_INCREMENT,

(2, 'Suzanne', 'VanElslander', 'svan@here.com'),
(2, 'Noah', 'Bayntun', '');

INSERT INTO `gifts` (`title`, `description`, `cost`, `contributed`) VALUES
('TV', 'great!', 600, 0.5),
('HoneyMoon', 'Greece!', 3000, 0.2),
('Toaster', 'meh', 36, 0.0),
('Fruit Basket', 'yum', 21, 1.0),
('Goldfish', 'flush', 5, 0.0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
