install.php

<?php

/**
 * This function is called on installation and is used to create database schema for the plugin
 */
function extension_install_userinstalledapps()
{
    $commonObject = new ExtensionCommon;

    $commonObject -> sqlQuery("CREATE TABLE `userinstalledapps`(
        `ID` INT(11) NOT NULL AUTO_INCREMENT,
        `HARDWARE_ID` INT (11) NOT NULL,
        `USERNAME` VARCHAR(255) DEFAULT NULL,
        `APPNAME` VARCHAR(255) DEFAULT NULL,
        `PUBLISHER` VARCHAR(255) DEFAULT NULL,
        `VERSION` VARCHAR(255) DEFAULT NULL,
        PRIMARY KEY (`ID`, `HARDWARE_ID`)
        ) ENGINE=INNODB ;"); 
}

/**
 * This function is called on removal and is used to destroy database schema for the plugin
 */
function extension_delete_userinstalledapps()
{
    $commonObject = new ExtensionCommon;
    $commonObject -> sqlQuery("DROP TABLE `userinstalledapps`");
}

/**
 * This function is called on plugin upgrade
 */
function extension_upgrade_userinstalledapps()
{

}