eccola
PHP Code:
DROP TABLE IF EXISTS `mos_users`;
PHP Code:
CREATE TABLE `mos_users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`usertype` varchar(25) NOT NULL default '',
`block` tinyint(4) NOT NULL default '0',
`sendEmail` tinyint(4) default '0',
`gid` tinyint(3) unsigned NOT NULL default '1',
`registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
`activation` varchar(100) NOT NULL default '',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `usertype` (`usertype`),
KEY `idx_name` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=63 ;
#
# Dumping data for table `mos_users`
#
INSERT INTO `mos_users` VALUES (62, 'Administrator', 'admin', 'admin@admin.it', '21232f297a57a5a743894a0e4a801fc3', 'superadministrator', 0, 1, 25, '2004-11-24 15:46:50', '0000-00-00 00:00:00', '', '');
user=admin psw =admin