U6qcpnX2

1CREATE TABLE IF NOT EXISTS `users` (
2  `id` bigint(20) NOT NULL AUTO_INCREMENT,
3  `first_name` varchar(255) NOT NULL,
4  `last_name` varchar(255) NOT NULL,
5  `email` varchar(500) NOT NULL,
6  `password` varchar(255) NOT NULL,
7  `gender` varchar(10) NOT NULL,
8  `birthday` date DEFAULT NULL,
9  `role` enum('student','tutor','admin') NOT NULL,
10  `profile_picture` varchar(3000) NOT NULL DEFAULT 'avatar.jpg',
11  `about_me` text NOT NULL,
12  `status` enum('active','inactive','blocked') NOT NULL DEFAULT 'active',
13  `email_verified` tinyint(1) NOT NULL DEFAULT '0',
14  `auth_key` varchar(255) NOT NULL,
15  `mobile` varchar(10) DEFAULT NULL,
16  `date_created` datetime NOT NULL,
17  `date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
18  `last_activity` datetime NOT NULL,
19  PRIMARY KEY (`id`)
20) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
21
22
23CREATE TABLE IF NOT EXISTS `subject` (
24  `id` int(11) NOT NULL AUTO_INCREMENT,
25  `user_id` int(11) NOT NULL,
26  `name` varchar(100) NOT NULL,
27  `subject_experience` int(2) DEFAULT NULL,
28  `status` enum('show','hide') NOT NULL,
29  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
30  PRIMARY KEY (`id`)
31) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;