Mysql
14:55/* Create Database */ |
CREATE DATABASE userlitdb; |
/* Create Table */ |
CREATE TABLE `usertbl` ( |
`id` int(11) NOT NULL auto_increment, |
`full_name` varchar(32) collate utf8_unicode_ci NOT NULL default '', |
`email` varchar(32) collate utf8_unicode_ci NOT NULL default '', |
`username` varchar(20) collate utf8_unicode_ci NOT NULL default '', |
`password` varchar(32) collate utf8_unicode_ci NOT NULL default '', |
PRIMARY KEY (`id`), |
UNIQUE KEY `username` (`username`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
0 comentarios