   PRIMARY KEY       (`id`),
   FOREIGN KEY       (group_id)      REFERENCES  groups(id),
   FOREIGN KEY       (status)        REFERENCES  status(id)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
 CREATE TABLE IF NOT EXISTS `locations` (
   `id`              int(4)          NOT NULL     AUTO_INCREMENT,

  `address`         varchar(256)    NOT NULL,
  `html`            text            NOT NULL,
  PRIMARY KEY       (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


--

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