 DROP TABLE IF EXISTS `system`;
 CREATE TABLE `system` (
   `id` INT NOT NULL AUTO_INCREMENT,
+  PRIMARY KEY (`id`)
+) CHARACTER SET utf8
+  ENGINE=InnoDB;
+
+DROP TABLE IF EXISTS `systems`;
+CREATE TABLE `systems` (
+  `id` INT NOT NULL AUTO_INCREMENT,
+  `slug` VARCHAR(50) NOT NULL UNIQUE,
+  `name` VARCHAR(255) NOT NULL,
+  `url` VARCHAR(255) NOT NULL,
+  `description` TEXT NULL,
+  `email` VARCHAR(255) NULL,
+  `imageId` INT NULL REFERENCES `images`(`id`),
   PRIMARY KEY (`id`)
 ) CHARACTER SET utf8
   ENGINE=InnoDB;

) CHARACTER SET utf8
  ENGINE=InnoDB;

DROP TABLE IF EXISTS `badges`;
CREATE TABLE `badges` (
  `id` INT NOT NULL AUTO_INCREMENT,

  `imageId` INT NOT NULL REFERENCES `images`(`id`),
  `issuerId` INT NULL REFERENCES `issuers`(`id`),
  `archived` BOOLEAN NOT NULL DEFAULT FALSE,
  PRIMARY KEY (`id`)
) CHARACTER SET utf8
  ENGINE=InnoDB;
