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