   visits int(14),
   public char(1),
   genreId int(14),
-  PRIMARY KEY (albumId)
+  PRIMARY KEY  (albumId)
 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
 
 DROP TABLE IF EXISTS tiki_jukebox_tracks;

  genreId int(14) unsigned NOT NULL auto_increment,
  genreName varchar(80),
  genreDescription text,
  PRIMARY KEY (genreId)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS tiki_jukebox_albums;


# Homework permissions - ggeller
INSERT INTO users_permissions(permName, permDesc, level, type) VALUES ('tiki_p_hw_admin','Can adminsiter homework','admin','homework');
INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_hw_teacher','Can create new homework assignments, see student names and grade assignments','editors','homework');
INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_hw_grader','Can grade homework assignments','editors','homework');
INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_hw_student','Can do homework assignments','registered','homework');

