<?php

 # SQL> CREATE TABLE  keywords (
 #   2    kwID     INT AUTO_INCREMENT PRIMARY KEY,
 #   3    keyword  VARCHAR(64) );
 #
 # SQL> CREATE TABLE  url_title (
 #   2    urlID  INT AUTO_INCREMENT PRIMARY KEY,
 #   3    url    VARCHAR(128),
 #   4    title  VARCHAR(128) );
 #
 # SQL> CREATE TABLE  www_index (
 #   2    kwID   INT,
 #   3    urlID  INT,
 #   4    PRIMARY KEY ( kwID, urlID ),
 #   5    FOREIGN KEY ( kwID  ) REFERENCES  keywords  ( kwID ),
 #   6    FOREIGN KEY ( urlID ) REFERENCES  url_title ( urlID ) );

 $host     = "undcemmysql.mysql.database.azure.com";
 $username = "your_id";
 $database = "your_db";
 $password = "your-pw";
 $conn     = mysqli_init( );
 mysqli_ssl_set( $conn, NULL, NULL, "DigiCertGlobalRootCA.crt.pem", NULL, NULL );
 mysqli_real_connect( $conn, $host, $username, $password, $database, 3306 );

 if ( $conn->connect_errno )
   die( 'Failed to connect to MySQL: ' . $conn->connect_error );

 $sql = "DELETE FROM www_index;";
 echo( $sql . "\n" );
 if ( $conn->query( $sql ) == TRUE )    
   echo "Table www_index deleted successfully\n\n";
 else
   echo "Error deleting table: " . $conn->error;

 $sql = "DELETE FROM keywords;";
 echo( $sql . "\n" );
 if ( $conn->query( $sql ) == TRUE )
   echo "Table keywords deleted successfully\n\n";
 else
   echo "Error deleting table: " . $conn->error;

 $sql = "DELETE FROM url_title;";
 echo( $sql . "\n" );
 if ( $conn->query( $sql ) == TRUE )
   echo "Table url_title deleted successfully";
 else
   echo "Error deleting table: " . $conn->error;

 # Close the database connection.
 $conn->close( );

?>