<?php

//////////////////////////////////////////////////////////////
//===========================================================
// mysql.php(For individual softwares)
//===========================================================
// SOFTACULOUS 
// Version : 1.0
// Inspired by the DESIRE to be the BEST OF ALL
// ----------------------------------------------------------
// Started by: Alons
// Date:       10th Jan 2009
// Time:       21:00 hrs
// Site:       http://www.softaculous.com/ (SOFTACULOUS)
// ----------------------------------------------------------
// Please Read the Terms of use at http://www.softaculous.com
// ----------------------------------------------------------
//===========================================================
// (c)Softaculous Inc.
//===========================================================
//////////////////////////////////////////////////////////////


$queries = array();


//$queries[] = "";

//If UTF-8 were a setting of the software
if(!empty($__settings['utf8'])){

	$queries[] = "ALTER DATABASE ".$__settings['softdb']."
							CHARACTER SET utf8
							DEFAULT CHARACTER SET utf8
							COLLATE utf8_general_ci
							DEFAULT COLLATE utf8_general_ci";
	
}

//Apps - Applications
$queries[] = "CREATE TABLE ".$__settings['dbprefix']."apps (
  `apid` mediumint(8) NOT NULL auto_increment,
  `ap_name` varchar(100) NOT NULL default '',
  `ap_version` varchar(15) NOT NULL default '',
  `installed_time` int(10) NOT NULL default '0',
  `ap_info` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`apid`)
) TYPE=MyISAM".(empty($__settings['utf8']) ? '' : " DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci");

$queries[] = "";

?>