· 8 years ago · Jan 17, 2018, 05:02 AM
1CREATE TABLE IF NOT EXISTS `tbl_profile` (
2`user_id` int(11) NOT NULL AUTO_INCREMENT,
3`lastname` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
4`firstname` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
5PRIMARY KEY (`user_id`)
6) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;