mirror of
https://github.com/inspircd/inspircd.git
synced 2025-03-09 10:39:02 -04:00
f166ef0a70
- Only create the pgsql table if it doesn't exist. - Separate the active column out from others.
33 lines
602 B
SQL
33 lines
602 B
SQL
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
|
|
);
|