stats/create_log_tables.php

<?php

require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_dashboard_rw.class.php";
require_once "hostname.php";

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

//////////////////////////////////////////////
//                                          //
// Create the table that will hold all logs //
//                                          //
//////////////////////////////////////////////
$query = "CREATE TABLE ".log_table()." (project varchar(50), ";
$query .= " news_text mediumtext, mail_text mediumtext, bugs_text mediumtext, ";

// Primary key
$query .= "PRIMARY KEY(project))";

echo $query;

mysql_query($query,$db_handle) or die("Could not create table: ".mysql_error());

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