Installation · origen_admin

CREATE TABLE IF NOT EXISTS `origen_admin_bans` (
  `ID`         INT(11) NOT NULL AUTO_INCREMENT,
  `license`    VARCHAR(100) NOT NULL DEFAULT '0',
  `banTime`    INT(11) NOT NULL DEFAULT 0,
  `expireTime` INT(11) NOT NULL DEFAULT 0,
  `reason`     LONGTEXT NOT NULL,
  `staff`      VARCHAR(50) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
 
CREATE TABLE IF NOT EXISTS `origen_admin_sanctions` (
  `id`          INT(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `userlicense` VARCHAR(150) DEFAULT NULL,
  `type`        VARCHAR(50) NOT NULL DEFAULT '0',
  `text`        LONGTEXT NOT NULL,
  `staff`       VARCHAR(50) NOT NULL DEFAULT '',
  `created`     INT(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
 
CREATE TABLE IF NOT EXISTS `origen_admin_priority` (
  `license`  VARCHAR(100) NOT NULL DEFAULT '',
  `priority` INT(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`license`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
 
CREATE TABLE IF NOT EXISTS `origen_admin_permissions` (
  `license` VARCHAR(75) NOT NULL,
  `group`   VARCHAR(25) NOT NULL,
  `updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() ON UPDATE CURRENT_TIMESTAMP(),
  PRIMARY KEY (`license`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

ensure origen_admin