CREATE TABLE `heightmaps` (
  `room` text collate latin1_general_ci NOT NULL,
  `map` text collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
INSERT INTO `heightmaps` VALUES ('pub', 'xxxxxxxxxxxxxxxxxxxxxxxxx\r\nxxxxxxxxx2222222211111xxx\r\nxxxxxxxxx2222222211111xxx\r\nxxxxxxxxx2222222211111xxx\r\nxxxxxxxxx2222222211111xxx\r\nxxxxxxxxx2222222222111xxx\r\nxxxxxxxxx2222222222111xxx\r\nxxxxxxxxx2222222222000xxx\r\nxxxxxxxxx2222222222000xxx\r\nxxxxxxxxx2222222222000xxx\r\nxxxxxxxxx2222222222000xxx\r\nx333333332222222222000xxx\r\nx333333332222222222000xxx\r\nx333333332222222222000xxx\r\nx333333332222222222000xxx\r\nx333333332222222222000xxx\r\nx333332222222222222000xxx\r\nx333332222222222222000xxx\r\nx333332222222222222000xxx\r\nx333332222222222222000xxx\r\nx333333332222222222000xxx\r\nxxxxx31111112222222000xxx\r\nxxxxx31111111000000000xxx\r\nxxxxx31111111000000000xxx\r\nxxxxx31111111000000000xxx\r\nxxxxx31111111000000000xxx\r\nxxxxxxxxxxxxxxx00xxxxxxxx\r\nxxxxxxxxxxxxxxx00xxxxxxxx\r\nxxxxxxxxxxxxxxx00xxxxxxxx\r\nxxxxxxxxxxxxxxx00xxxxxxxx\r\nxxxxxxxxxxxxxxxxxxxxxxxxx');
CREATE TABLE `users` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `password` varchar(20) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `figure` text NOT NULL,
  `directmail` tinyint(1) NOT NULL default '0',
  `birthday` varchar(10) NOT NULL default '',
  `phonenumber` varchar(10) NOT NULL default '',
  `customdata` varchar(120) NOT NULL default '',
  `had_read_agreement` tinyint(1) NOT NULL default '0',
  `sex` varchar(6) NOT NULL default '',
  `country` varchar(20) NOT NULL default '',
  `has_special_rights` varchar(5) NOT NULL default '0',
  `badge_type` varchar(5) NOT NULL default '0',
  `on_time` varchar(20) NOT NULL default '',
  `credits` bigint(20) NOT NULL default '0',
  `online` varchar(20) NOT NULL default '',
  `info` tinytext NOT NULL,
  `state` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
INSERT INTO `users` VALUES (1, 'R4000', 'removed pass, this should be in plain text :P', 'drewmoo@gmail.com', 'sd=001/0&hr=001/255,255,255&hd=002/255,204,153&ey=001/0&fc=001/255,204,153&bd=001/255,204,153&lh=001/255,204,153&rh=001/255,204,153&ch=001/232,177,55&ls=001/232,177,55&rs=001/232,177,55&lg=001/119,159,187&sh=001/175,220,223', 0, '30.11.1990', '56546', 'coolness', 1, 'Male', 'gfggf', '1', 'A', '05/08/2006 01:18:03', 991, '0', '', '');