

--
-- Table structure for table `unittestskin`
--

CREATE TABLE `unittestskin` (
  `uid` int(11) NOT NULL,
  `car` varchar(255) NOT NULL default 'maypor',
  `color` varchar(255) NOT NULL default 'black',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='user skins';

--
-- Dumping data for table `unittestskin`
--

INSERT INTO `unittestskin` VALUES (10,'manta','orange'),(12,'manta','navy'),(11,'vw','orange');

--
-- Table structure for table `unittestuser`
--

CREATE TABLE `unittestuser` (
  `uid` int(11) NOT NULL auto_increment,
  `nickname` varchar(255) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `surname` varchar(255) NOT NULL default '',
  `forename` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `changed` datetime NOT NULL,
  `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
  `lang` varchar(10) NOT NULL default '',
  `flags` set('enabled','approved','new') default NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY  (`uid`),
  KEY `email` (`email`),
  KEY `nickname` (`nickname`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='users';

--
-- Dumping data for table `unittestuser`
--

INSERT INTO `unittestuser` VALUES
(10,'gerd','118e24c471c8ea75880e41721bac03a2','Schaufelberger','gERD','gerd@example.com','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','enabled,approved',0),
(11,'foo','a21c32c763bda2023294184d824731c2','Bar','Foo','foo@example.com','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','enabled,approved',0),
(12,'joe','c007c05c5916e52b6ced8c4cae5c6936','Joe','Doe','joe@example.com','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','enabled,approved',0);


