Board Game Arena

Code: Select all

CREATE TABLE `moves` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `x` mediumint(9) NOT NULL,
  `y` mediumint(9) NOT NULL,
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Code: Select all

       if( $from_version <= 2006020000 )
        {
            $sql = "CREATE TABLE IF NOT EXISTS DBPREFIX_moves (
                id smallint(5) unsigned NOT NULL AUTO_INCREMENT,
                x mediumint(9) NOT NULL,
  `             y mediumint(9) NOT NULL,
                PRIMARY KEY (id)
                ) ENGINE=InnoDB DEFAULT CHARSET=latin1";
            self::applyDbUpgradeToAllDB( $sql );
		}