Ysurac / FlightAirMap

		global $tmp_dir, $globalDBdriver;

		include_once('class.create_db.php');

		$Connection = new Connection();

		if ($Connection->tableExists('countries')) {

			$query = 'DROP TABLE countries';

			try {

				$sth = $Connection->db->prepare($query);

            	        	$sth->execute();

	                } catch(PDOException $e) {

    	                	echo "error : ".$e->getMessage();

	                }

		}

		if ($globalDBdriver == 'mysql') {

			update_db::gunzip('../db/countries.sql.gz',$tmp_dir.'countries.sql');

		} else {

    		$error = '';

    		// Create table acars_label

		$error .= create_db::import_file('../db/acars_label.sql');

		if ($error == '') {

		    // Update schema_version to 5

		    $query = "UPDATE `config` SET `value` = '5' WHERE `name` = 'schema_version'";

        	    try {

            		$sth = $Connection->db->prepare($query);

			$sth->execute();

    		    } catch(PDOException $e) {

			return "error (update schema_version) : ".$e->getMessage()."\n";

    		    }

    		}

		return $error;

	}

    		$Connection = new Connection();

		$error = '';

		// Add table stats polar

		if ($globalDBdriver == 'mysql') {

			//$error .= create_db::import_file('../db/stats_source.sql');

		} else {

			//$error .= create_db::import_file('../db/pgsql/stats_source.sql');

			$query = "create index flightaware_id_idx ON spotter_archive USING btree(flightaware_id)";

        		try {

		    		$sth = $Connection->db->prepare($query);

				$sth->execute();

			} catch(PDOException $e) {

				return "error (create index on spotter_archive) : ".$e->getMessage()."\n";

			}

		}

    		$query = "";

        	try {

			$sth = $Connection->db->prepare($query);