P9UTei8F

1CREATE TABLE IF NOT EXISTS `users` (
2`id` int(11) NOT NULL AUTO_INCREMENT,
3`userName` varchar(100) NOT NULL,
4`fullName` varchar(255) NOT NULL,
5`email` varchar(100) NOT NULL,
6`passwd` varchar(255) NOT NULL,
7`status` int(1) NOT NULL,
8`date` datetime NOT NULL,
9PRIMARY KEY (`id`),
10UNIQUE KEY `userName` (`userName`,`email`)
11) ENGINE=InnoDB DEFAULT CHARSET=utf8
12AUTO_INCREMENT=1 ;
13
14
15CREATE TABLE IF NOT EXISTS `logged_in_users` (
16`sessionId` varchar(100) NOT NULL,
17`userId` int(11) NOT NULL,
18`lastUpdate` datetime NOT NULL,
19PRIMARY KEY (`sessionId`)
20) ENGINE=InnoDB DEFAULT CHARSET=utf8;