· 8 years ago · Feb 09, 2018, 01:54 AM
1CREATE TABLE IF NOT EXISTS `tbl_users` (
2`userID` int(11) NOT NULL AUTO_INCREMENT,
3`userName` varchar(100) NOT NULL,
4`userEmail` varchar(100) NOT NULL UNIQUE,
5`userPass` varchar(100) NOT NULL,
6`userStatus` enum('Y','N') NOT NULL DEFAULT 'N',
7`tokenCode` varchar(100) NOT NULL,
8PRIMARY KEY (`userID`)
9)