ALTER TABLE `admin` CHANGE `calc` `calc` INT(11) DEFAULT '0' NULL; ALTER TABLE `tournaments` ADD `grp` INT(11) DEFAULT '0' NOT NULL; CREATE TABLE `groups` ( `grp` INT(11) NOT NULL, `name` VARCHAR(10) DEFAULT NULL, `calc` INT(11) NOT NULL DEFAULT '0', PRIMARY KEY (`grp`) ) ENGINE=MYISAM DEFAULT CHARSET=utf8; CREATE TABLE `parties` ( `id` INT(11) NOT NULL DEFAULT '0', `class` INT(11) NOT NULL DEFAULT '0', `party` VARCHAR(100) NOT NULL, PRIMARY KEY (`id`,`class`) ) ENGINE=MYISAM DEFAULT CHARSET=utf8; CREATE TABLE `classifications` ( `class` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(30) DEFAULT NULL, `calc` INT(11) NOT NULL DEFAULT '0', `logoh` TEXT, PRIMARY KEY (`class`) ) ENGINE=MYISAM DEFAULT CHARSET=utf8;