source: extensions/MyPiwiShop/maintain.inc.php @ 31547

<?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`;');
  }
}