-CREATE TABLE ircd_opers (\rid integer primary key,\rusername text,\rpassword text,\rhostname text,\rtype text);\r\r
\ No newline at end of file
+CREATE TABLE ircd_opers (
+id integer primary key,
+name text NOT NULL,
+password text NOT NULL,
+hash text,
+host text NOT NULL,
+type text NOT NULL,
+fingerprint text,
+autologin integer NOT NULL DEFAULT 0,
+active integer NOT NULL DEFAULT 1);