CREATE TABLE IF NOT EXISTS `users` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`userName` VARCHAR(100) NOT NULL,
`fullName` VARCHAR(255) NOT NULL,
`email` VARCHAR(100) NOT NULL,
`passwd` VARCHAR(255) NOT NULL,
`status` INT(1) NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `userName` (`userName`,`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `logged_in_users` (
`sessionId` VARCHAR(100) NOT NULL,
`userId` INT(11) NOT NULL,
`lastUpdate` datetime NOT NULL,
PRIMARY KEY (`sessionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;