Location: PHPKode > projects > Esvon Personals > esvon-personals/upgrades/v4_to_v4_09/upgrade402-403.php

// File to upgrade Esvon Classifieds from 4.0.2 to 4.0.3
// After use this, you can delete it


define('DB_UPGRADE', 1);

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

  mysql_query("CREATE TABLE ".hwModTable('Member_Website','user_info')." (
   id mediumint(8) unsigned NOT NULL auto_increment,
   v_255_1 varchar(255) NOT NULL,
   PRIMARY KEY (id))");

  mysql_query("ALTER TABLE ".TBL_AD." ADD hw_auct_enabled char(1) NOT NULL");
  mysql_query("ALTER TABLE ".TBL_AD." ADD hw_auct_res_price decimal(9,2) unsigned NOT NULL");

  mysql_query("ALTER TABLE ".hwModTable('Reviews','data')." ADD writer_id mediumint(8) unsigned DEFAULT '0' NOT NULL");

mysql_query("CREATE TABLE ".TBL_FILE." (
  lid mediumint(8) unsigned DEFAULT '0' NOT NULL,
  fname varchar(255) NOT NULL default '',
  descr text NOT NULL,
  approved tinyint(3) unsigned DEFAULT '1' NOT NULL,
  PRIMARY KEY (lid,fname)

  $tbl = hwModTable('Form_to_Email','log');
  mysql_query("DROP TABLE $tbl");
  mysql_query("CREATE TABLE $tbl (
  ip int(11) unsigned NOT NULL,
  date_added datetime NOT NULL,
  PRIMARY KEY (ip))");

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

Return current item: Esvon Personals