Sample Code to Create the Activities Table -
Personal Activities Calendar Program

<?php

$db_name = "calendar";
$connection = @mysql_connect("localhost", "username", "password") or die ("Database is unavailable at this time. Please try later.");

$db = @mysql_select_db($db_name, $connection) or die ("Could not connect to the database at this time. Please try later.");

$sql = "CREATE TABLE activities (
act_ID    INT(11)    UNSIGNED    NOT NULL    AUTO_INCREMENT,
act_title    VARCHAR(255)    NOT NULL,
act_desc    TEXT    DEFAULT NULL    NULL,
act_timestamp_1    INT(50)    DEFAULT 0    NOT NULL,
act_timestamp_2    INT(50)    DEFAULT 0    NOT NULL,
act_status    INT(1)    DEFAULT 0    NOT NULL,
PRIMARY KEY(act_ID)
)";

$result = @mysql_query($sql, $connection) or die ("Could not complete the task at this time. Please try later.");

?>

Sample Code to Create the Activities Table -Personal Activities Calendar Program

Sample Code to Create the Activities Table -
Personal Activities Calendar Program