CREATE DATABASE bgame; use bgame;

CREATE TABLE `score2a` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) collate latin1_general_ci default NULL,
  `punkte` int(30) default NULL,
  `lr` varchar(30) collate latin1_general_ci default NULL,
  `punkte2` int(11) default NULL,
  `lr2` text collate latin1_general_ci,
  `name2` varchar(200) collate latin1_general_ci default NULL,
  `x` int(11) default NULL,
  `y` int(11) default NULL,
  `xu` int(11) NOT NULL,
  `yu` int(11) default NULL,
  `xp` int(11) default NULL,
  `yp` int(11) default NULL,
  `time` datetime default NULL,
  `spa` varchar(2) collate latin1_general_ci default 'n',
  `s` varchar(1) collate latin1_general_ci default '0',
  `R` varchar(1) collate latin1_general_ci default '0',
  `T` varchar(1) collate latin1_general_ci default '0',
  `Lasergen1` int(11) NOT NULL,
  `Lasergen2` int(11) NOT NULL,
  `Lasergen3` int(11) NOT NULL,
  `Lasersorte1` int(11) NOT NULL,
  `Lasersorte2` int(11) NOT NULL,
  `Lasersorte3` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
);