<?php
defined('PHPWG_ROOT_PATH') or die('Hacking attempt!');

class MyPiwiShop_maintain extends PluginMaintain
{
  private $installed = false;


  function install($plugin_version, &$errors=array())
  {
    global $prefixeTable;
	
	pwg_query('	
	CREATE TABLE IF NOT EXISTS `'. $prefixeTable .'mps_conf` (
	  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	  `PPid` varchar(100) NOT NULL,
	  `currency` varchar(100),
	  `ship` decimal NOT NULL,
	  `comm` text ,
	  `tprmulti` varchar(200) ,
	  `tpruniq` varchar(200) ,
	  PRIMARY KEY (`id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8
	;');
	
  
	pwg_query('
	CREATE TABLE IF NOT EXISTS `'. $prefixeTable .'mps_product` (
	  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	  `order` int(20),
	  `product` varchar(100) NOT NULL,
	  `noteAdmin` varchar(255),
	  `price` float NOT NULL,
	  PRIMARY KEY (`id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8
	;');

	pwg_query('
	CREATE TABLE IF NOT EXISTS `'. $prefixeTable .'mps_prod_img` (
	  `image_id` MEDIUMINT (20) UNSIGNED NOT NULL,
	  `product_id` MEDIUMINT (20) UNSIGNED NOT NULL,
	  PRIMARY KEY (`product_id`,`image_id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8
	;');

	pwg_query('
	CREATE TABLE IF NOT EXISTS `'. $prefixeTable .'mps_option` (
	  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	  `name` varchar(250) NOT NULL,
	  `type` varchar(100) NOT NULL,
	  `titre` varchar(200),
	  `requi` int(10),
	  `order` int(20),
	  
	  PRIMARY KEY (`id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8
	;');

	pwg_query('
	CREATE TABLE IF NOT EXISTS `'. $prefixeTable .'mps_opt_val` (
	  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
	  `val` varchar(100) NOT NULL,
	  `select_id` int(11) NOT NULL,
	  PRIMARY KEY (`id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8
	;');

	pwg_query('
	CREATE TABLE IF NOT EXISTS `'. $prefixeTable .'mps_prod_opt` (
	  `opt_id` MEDIUMINT (20) UNSIGNED NOT NULL,
	  `product_id` MEDIUMINT (20) UNSIGNED NOT NULL,
	  PRIMARY KEY (`product_id`,`opt_id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8
	;');
	
	$this->installed = true;
  }  
	
  function activate($plugin_version, &$errors=array())
  {
   if (!$this->installed) {
    $this->install($plugin_version, $errors);
   }
  }
 
  function deactivate()
  {
  }

  function uninstall()
  {
    global $prefixeTable;
    // delete table
    pwg_query('DROP TABLE `'. $prefixeTable .'mps_conf`;');
    pwg_query('DROP TABLE `'. $prefixeTable .'mps_product`;');
    pwg_query('DROP TABLE `'. $prefixeTable .'mps_prod_img`;');
    pwg_query('DROP TABLE `'. $prefixeTable .'mps_option`;');
    pwg_query('DROP TABLE `'. $prefixeTable .'mps_opt_val`;');
    pwg_query('DROP TABLE `'. $prefixeTable .'mps_prod_opt`;');
  }
}