stats/tables/mod_tables.php

<?php

require_once("/home/data/httpd/eclipse-php-classes/system/dbconnection_dashboard_rw.class.php");
require_once($_SERVER['DOCUMENT_ROOT'] . "/projects/stats/hostname.php");

$db_connection = new DBConnectionDashboard();
$db_handle = $db_connection->connect();


$query = "ALTER TABLE ".stats_table()." CHANGE COLUMN project project_id varchar(100)";
echo $query."<br>";
mysql_query($query,$db_handle) or die("Could not alter table: ".mysql_error());

$query = "ALTER TABLE ".log_table()." CHANGE COLUMN project project_id varchar(100)";
echo $query."<br>";
mysql_query($query,$db_handle) or die("Could not alter table: ".mysql_error());
  

$db_handle = null;
$db_connection = null;
?>