CREATE TABLE IF NOT EXISTS `ircd_opers` (
  `active` bool NOT NULL DEFAULT true,

  `name` text NOT NULL,
  `password` text NOT NULL,
  `host` text NOT NULL,
  `type` text NOT NULL,

  `autologin` ENUM ('strict', 'relaxed', 'never'),
  `class` text,
  `hash` text,
  `maxchans` bigint,
  `nopassword` bool,
  `vhost` text,

  `commands` text,
  `privs` text,
  `chanmodes` text,
  `usermodes` text,
  `snomasks` text,

  `account` text,
  `autojoin` text,
  `automotd` bool,
  `fingerprint` text,
  `level` bigint,
  `modes` text,
  `motd` bool,
  `override` text,
  `sslonly` bool,
  `swhois` text
);