CREATE TABLE IF NOT EXISTS `vms_bonusaktionen` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `url` varchar(255) NOT NULL, `description` text NOT NULL, `verguetung` double(10,2) NOT NULL, `bis` int(11) NOT NULL, `menge` int(11) NOT NULL, `restmenge` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `vms_bonusaktionen_ok` ( `uid` int(11) NOT NULL, `aktionid` int(11) NOT NULL, `namenick` varchar(255) NOT NULL, `ok` enum('true','false') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;