Friday, March 6, 2009

Table User Mysql

CREATE TABLE `user` (
`id` int(10) NOT NULL auto_increment,
`nama` varchar(20) collate latin1_general_ci NOT NULL,
`password` varchar(100) collate latin1_general_ci NOT NULL,
`level` int(3) NOT NULL,
`realname` varchar(50) collate latin1_general_ci NOT NULL,
`email` varchar(100) collate latin1_general_ci NOT NULL,
`url` varchar(100) collate latin1_general_ci NOT NULL,
`waktu` int(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6 ;

No comments:

Post a Comment