CREATE TABLE `groups` (
  `id` INTEGER PRIMARY KEY AUTO_INCREMENT
);

CREATE TABLE `permissions` (
  `id` INTEGER PRIMARY KEY AUTO_INCREMENT
);

CREATE TABLE `groups_permissions` (
  `groups` INTEGER NOT NULL,
  `permissions` INTEGER NOT NULL,
  PRIMARY KEY (`groups`, `permissions`)
);

CREATE INDEX `idx_groups_permissions` ON `groups_permissions` (`permissions`);

ALTER TABLE `groups_permissions` ADD CONSTRAINT `fk_groups_permissions__groups` FOREIGN KEY (`groups`) REFERENCES `groups` (`id`);

ALTER TABLE `groups_permissions` ADD CONSTRAINT `fk_groups_permissions__permissions` FOREIGN KEY (`permissions`) REFERENCES `permissions` (`id`);

CREATE TABLE `report` (
  `id` INTEGER PRIMARY KEY AUTO_INCREMENT
);

CREATE TABLE `permissions_report` (
  `permissions` INTEGER NOT NULL,
  `report` INTEGER NOT NULL,
  PRIMARY KEY (`permissions`, `report`)
);

CREATE INDEX `idx_permissions_report` ON `permissions_report` (`report`);

ALTER TABLE `permissions_report` ADD CONSTRAINT `fk_permissions_report__permissions` FOREIGN KEY (`permissions`) REFERENCES `permissions` (`id`);

ALTER TABLE `permissions_report` ADD CONSTRAINT `fk_permissions_report__report` FOREIGN KEY (`report`) REFERENCES `report` (`id`);

CREATE TABLE `users` (
  `id` INTEGER PRIMARY KEY AUTO_INCREMENT
);

CREATE TABLE `groups_users` (
  `groups` INTEGER NOT NULL,
  `users` INTEGER NOT NULL,
  PRIMARY KEY (`groups`, `users`)
);

CREATE INDEX `idx_groups_users` ON `groups_users` (`users`);

ALTER TABLE `groups_users` ADD CONSTRAINT `fk_groups_users__groups` FOREIGN KEY (`groups`) REFERENCES `groups` (`id`);

ALTER TABLE `groups_users` ADD CONSTRAINT `fk_groups_users__users` FOREIGN KEY (`users`) REFERENCES `users` (`id`)