CREATE TABLE IF NOT EXISTS `users` (
  `user_id` mediumint(8) unsigned NOT NULL auto_increment,
  `first_name` varchar(20) NOT NULL,
  `last_name` varchar(40) NOT NULL,
  `email` varchar(60) NOT NULL,
  `pass` varchar(40) NOT NULL,
  `registration_date` date NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `bookmark` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL,
  `comment` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

INSERT INTO `bookmark` (`title`, `comment`, `url`) VALUES
('Strictly Discs', 'Madison record store for new and used vinyl.', 'https://strictlydiscs.com'),
('B-Side Records', 'Classic State Street record shop in Madison.', 'https://www.b-sidemadison.com'),
('Madison Music Foundry', 'Local music lessons, rehearsal rooms, and community music resource.', 'https://madisonmusicfoundry.com'),
('Isthmus Music', 'Madison music listings, local stories, and events.', 'https://isthmus.com/music/'),
('Discogs', 'Research albums, releases, and vinyl pressings.', 'https://www.discogs.com'),
('Bandcamp', 'Discover independent artists and labels.', 'https://bandcamp.com'),
('The Sylvee', 'Madison live music venue.', 'https://www.thesylvee.com');
