   `privclass_id` int(8) unsigned NOT NULL COMMENT 'The ID of the privclass.',
   `privclass_name` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'The name of the privclass.',
   `order` smallint(2) unsigned NOT NULL COMMENT 'The chatroom order of the privclass.',
-  `admin` bit(1) NOT NULL DEFAULT '\0' COMMENT 'Admin privs?',
-  `kick` bit(1) NOT NULL DEFAULT '\0' COMMENT 'Kick privs?',
-  `join` bit(1) NOT NULL DEFAULT '' COMMENT 'Join privs?',
-  `msg` bit(1) NOT NULL DEFAULT '' COMMENT 'Message privs?',
-  `topic` bit(1) NOT NULL DEFAULT '\0' COMMENT 'Topic privs?',
-  `title` bit(1) NOT NULL DEFAULT '\0' COMMENT 'Title privs?',
-  `shownotice` bit(1) NOT NULL DEFAULT '' COMMENT 'Show notices apon join/part?',
+  `admin` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Admin privs?',
+  `kick` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Kick privs?',
+  `join` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Join privs?',
+  `msg` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Message privs?',
+  `topic` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Topic privs?',
+  `title` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Title privs?',
+  `shownotice` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Show notices apon join/part?',
   `promote` smallint(2) unsigned NOT NULL DEFAULT '0' COMMENT 'Promote privs.',
   `demote` smallint(2) unsigned NOT NULL DEFAULT '0' COMMENT 'Demote privs.',
   `images` mediumint(3) NOT NULL DEFAULT '0' COMMENT 'Image privs. -1 for unlimited, 0 for none, [number] max.',

  `password_hash` char(128) COLLATE utf8_bin NOT NULL COMMENT 'SHA-512 hash represented as a hexidecimal string.',
  `password_salt` char(6) COLLATE utf8_bin NOT NULL COMMENT 'Password salt.',
  `authtoken` char(32) COLLATE utf8_bin NOT NULL COMMENT 'The user''s current authtoken.',
  PRIMARY KEY (`user_id`),
  KEY `user_name` (`user_name`,`user_id`,`authtoken`,`password_hash`,`password_salt`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;

--
-- Constraints for dumped tables

  `avatars` mediumint(3) NOT NULL DEFAULT '0' COMMENT 'Avatar privs. -1 for unlimited, 0 for none, [number] max.',
  `websites` mediumint(3) NOT NULL DEFAULT '0' COMMENT 'Website privs. -1 for unlimited, 0 for none, [number] max.',
  `objects` mediumint(3) NOT NULL DEFAULT '0' COMMENT 'Object privs. -1 for unlimited, 0 for none, [number] max.',
  `default` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Default Privclass?',
  PRIMARY KEY (`privclass_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Privclass definition table.';

