CREATE TABLE `user` (
  `user_id` int(11) NOT NULL auto_increment,
  `firstname` varchar(50) NOT NULL default '',
  `lastname` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM;
insert  into `user` values 
(1, 'John', 'Day'), 
(2, 'Jacqui', 'Burke'), 
(3, 'Brenda', 'Day'), 
(4, 'Cassie', 'Cat'), 
(5, 'Steven', 'Burke'), 
(6, '', '');

CREATE TABLE `role` (
  `role_id` int(11) NOT NULL auto_increment,
  `rolename` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`role_id`)
) TYPE=MyISAM;
insert  into role values 
(1, 'Typist'), 
(2, 'Programmer'), 
(3, 'Cleaner');

CREATE TABLE `user_role` (
  `user_id` int(11) NOT NULL default '0',
  `role_id` int(11) NOT NULL default '0'
) TYPE=MyISAM;
insert  into user_role values 
(1, 1), 
(1, 2), 
(1, 3), 
(2, 2), 
(3, 1), 
(3, 2), 
(0, 0);