CREATE DATABASE `sigg` DEFAULT CHARACTER SET ascii COLLATE ascii_general_ci;
USE sigg;
CREATE TABLE `sigg`.`queries` (`event` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , `time` INT NOT NULL ) ENGINE = MYISAM ;
ALTER TABLE `queries` ADD PRIMARY KEY ( `event` ) ;
CREATE TABLE `sigg`.`results` (`event` VARCHAR( 1000 ) NOT NULL ,`time` INT NOT NULL ) ENGINE = MYISAM ;
ALTER TABLE `results` ADD PRIMARY KEY ( `event` ) ; 
GRANT ALL ON sigg.* TO sigg identified BY 'bil1kri2';

