-- 
-- Table structure for table `mdl152_user`
-- 

CREATE TABLE `mdl152_user` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `auth` varchar(20) NOT NULL default 'manual',
  `confirmed` tinyint(1) NOT NULL default '0',
  `policyagreed` tinyint(1) NOT NULL default '0',
  `deleted` tinyint(1) NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `idnumber` varchar(64) default NULL,
  `firstname` varchar(20) NOT NULL default '',
  `lastname` varchar(20) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `emailstop` tinyint(1) unsigned NOT NULL default '0',
  `icq` varchar(15) default NULL,
  `skype` varchar(50) default NULL,
  `yahoo` varchar(50) default NULL,
  `aim` varchar(50) default NULL,
  `msn` varchar(50) default NULL,
  `phone1` varchar(20) default NULL,
  `phone2` varchar(20) default NULL,
  `institution` varchar(40) default NULL,
  `department` varchar(30) default NULL,
  `address` varchar(70) default NULL,
  `city` varchar(20) default NULL,
  `country` char(2) default NULL,
  `lang` varchar(10) default 'en',
  `theme` varchar(50) NOT NULL default '',
  `timezone` varchar(100) NOT NULL default '99',
  `firstaccess` int(10) unsigned NOT NULL default '0',
  `lastaccess` int(10) unsigned NOT NULL default '0',
  `lastlogin` int(10) unsigned NOT NULL default '0',
  `currentlogin` int(10) unsigned NOT NULL default '0',
  `lastIP` varchar(15) default NULL,
  `secret` varchar(15) default NULL,
  `picture` tinyint(1) default NULL,
  `url` varchar(255) default NULL,
  `description` text,
  `mailformat` tinyint(1) unsigned NOT NULL default '1',
  `maildigest` tinyint(1) unsigned NOT NULL default '0',
  `maildisplay` tinyint(2) unsigned NOT NULL default '2',
  `htmleditor` tinyint(1) unsigned NOT NULL default '1',
  `autosubscribe` tinyint(1) unsigned NOT NULL default '1',
  `trackforums` tinyint(1) unsigned NOT NULL default '0',
  `timemodified` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `user_deleted` (`deleted`),
  KEY `user_confirmed` (`confirmed`),
  KEY `user_firstname` (`firstname`),
  KEY `user_lastname` (`lastname`),
  KEY `user_city` (`city`),
  KEY `user_country` (`country`),
  KEY `user_lastaccess` (`lastaccess`),
  KEY `user_email` (`email`),
  KEY `auth` (`auth`),
  KEY `idnumber` (`idnumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='One record for each person' ;

-- 
-- Dumping data for table `mdl152_user`
-- 

INSERT INTO `mdl152_user` VALUES (1, 'manual', 1, 0, 0, 'guest', '084e0343a0486ff05530df6c705c8bb4', NULL, 'Guest User', ' ', 'root@localhost', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en', '', '99', 0, 0, 0, 0, NULL, NULL, NULL, NULL, 'This user is a special user that allows read-only access to some courses.', 1, 0, 2, 1, 1, 0, 1121706395);
INSERT INTO `mdl152_user` VALUES (2, 'manual', 1, 0, 0, 'admin', 'ee10c315eba2c75b403ea99136f5b48d', '', 'Admin', 'User', 'admin@jesuits.net', 0, '', '', '', '', '', '', '', 'Dallas JCP', '', '', 'Dallas', 'US', 'en', '', '99', 0, 1121724050, 1121706628, 1121718278, '10.1.3.107', NULL, NULL, '', '', 1, 0, 1, 1, 1, 0, 1121706450);
INSERT INTO `mdl152_user` VALUES (3, 'manual', 1, 0, 0, 'guest1', '084e0343a0486ff05530df6c705c8bb4', NULL, 'Guest User', ' ', 'root1@localhost', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en', '', '99', 0, 0, 0, 0, NULL, NULL, NULL, NULL, 'This user is a special user that allows read-only access to some courses.', 1, 0, 2, 1, 1, 0, 1121706395);
INSERT INTO `mdl152_user` VALUES (4, 'manual', 1, 0, 0, 'admin2', 'ee10c315eba2c75b403ea99136f5b48d', '', 'Admin', 'User', 'admin1@jesuits.net', 0, '', '', '', '', '', '', '', 'Dallas JCP', '', '', 'Dallas', 'US', 'en', '', '99', 0, 1121724050, 1121706628, 1121718278, '10.1.3.107', NULL, NULL, '', '', 1, 0, 1, 1, 1, 0, 1121706450);
INSERT INTO `mdl152_user` VALUES (5, 'manual', 1, 0, 0, 'guest3', '084e0343a0486ff05530df6c705c8bb4', NULL, 'Guest User', ' ', 'root2@localhost', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en', '', '99', 0, 0, 0, 0, NULL, NULL, NULL, NULL, 'This user is a special user that allows read-only access to some courses.', 1, 0, 2, 1, 1, 0, 1121706395);
INSERT INTO `mdl152_user` VALUES (6, 'manual', 1, 0, 0, 'admin4', 'ee10c315eba2c75b403ea99136f5b48d', '', 'Admin', 'User', 'adamin2@jesuits.net', 0, '', '', '', '', '', '', '', 'Dallas JCP', '', '', 'Dallas', 'US', 'en', '', '99', 0, 1121724050, 1121706628, 1121718278, '10.1.3.107', NULL, NULL, '', '', 1, 0, 1, 1, 1, 0, 1121706450);

SELECT * FROM `mdl152_user`
WHERE
username <> 'guest' AND 
deleted = 0 AND 
confirmed = 1 
AND id NOT IN (3);