To install run sql line :
CREATE TABLE IF NOT EXISTS `users` (
`P_Id` int NOT NULL AUTO_INCREMENT,
`username` varchar(200) collate utf8_unicode_ci NOT NULL,
`password` varchar(200) collate utf8_unicode_ci NOT NULL,
`email` varchar(254) collate utf8_unicode_ci NOT NULL,
`regdate` varchar(200) collate utf8_unicode_ci NOT NULL,
`CpassReqDate` varchar(200) collate utf8_unicode_ci NOT NULL,
`voucher` varchar(200) collate utf8_unicode_ci NOT NULL,
UNIQUE id (P_Id),
UNIQUE username(username)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
|