<?php

// File to upgrade Esvon Classifieds from 2.9 to 3.0
// After use this, you can delete it

//*********************************************

define('DB_UPGRADE', 1);

if(!defined('SITE_PATH')){
  if(!file_exists('./inc/application.php')) die("File Not Found: application.php");
  require_once './inc/application.php';
}

mysql_query("ALTER TABLE ".TBL_PAY_PLAN." ADD pp_exp_into varchar(10) NOT NULL");

mysql_query("ALTER TABLE ".TBL_AD." ADD hw_sold char(1) DEFAULT '0' NOT NULL");

mysql_query("ALTER TABLE ".TBL_PAY_PEND." ADD adid mediumint(8) unsigned NOT NULL");

mysql_query("ALTER TABLE ".TBL_AD." CHANGE pick hw_feat char(1) DEFAULT '0' NOT NULL");

mysql_query("ALTER TABLE ".TBL_AD." CHANGE updated hw_updated datetime NOT NULL");

mysql_query("ALTER TABLE ".TBL_AD." CHANGE date hw_added datetime NOT NULL");

mysql_query("ALTER TABLE ".TBL_PAY_PLAN." ADD pp_url varchar(255) NOT NULL");

mysql_query("ALTER TABLE ".TBL_PAY_PLAN." ADD pp_icon_url varchar(255) NOT NULL");
	
mysql_query("ALTER TABLE ".TBL_AD." ADD v_price decimal(9,2) NOT NULL");

echo 'Esvon Classifieds Tables Updated, Ok.. ('.basename(__FILE__).')';

?>