CREATE TABLE `users` (
  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
  `name` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `roles` (
  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
  `name` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `usersroles` (
  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
  `id_users` INTEGER NULL DEFAULT NULL,
  `id_roles` INTEGER NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);


INSERT INTO `users` (`id`,`name`) VALUES ('1','Василий');
INSERT INTO `roles` (`id`,`name`) VALUES ('1','Певец');

INSERT INTO `usersroles` (`id_users`) SELECT `id` FROM `users`;
INSERT INTO `usersroles` (`id_roles`) SELECT `id` FROM `roles`;

ALTER TABLE `usersroles` ADD FOREIGN KEY (id_users) REFERENCES `users` (`id`);
ALTER TABLE `usersroles` ADD FOREIGN KEY (id_roles) REFERENCES `roles` (`id`);

INSERT INTO `usersroles` (`id`,`id_users`, `id_roles`) VALUES ('', SELECT `id` FROM `users`, SELECT `id` FROM `roles`);