CREATE TABLE `users` ( `id` tinyint(8) unsigned NOT NULL auto_increment, `User` varchar(64) NOT NULL default '', `Password` varchar(64) NOT NULL default '', `clear` varchar(64) NOT NULL default '', `Uid` varchar(11) NOT NULL default '', `Gid` varchar(11) NOT NULL default '', `Dir` varchar(128) NOT NULL default '', `QuotaSize` varchar(10) NOT NULL default '', `QuotaFiles` varchar(10) NOT NULL default '', `ULBandwidth` varchar(10) NOT NULL default '', `DLBandwidth` varchar(10) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `User` (`User`) ) TYPE=InnoDB AUTO_INCREMENT=2 ; INSERT INTO `users` VALUES (1, 'test', '5ebe2294ecd0e0f08eab7690d2a6ee69', 'secret', '300', '300', '/Users/test', '12', '', '', '');