<?php
if(!defined('DLE_SHOP_INSTALL'))
{
  die("Hacking attempt!");
}

$db_query = array();
   
$db_query["3.0"][] = "CREATE TABLE IF NOT EXISTS `".PREFIX."_activcost` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `fam` varchar(50) NOT NULL DEFAULT '',
  `otch` varchar(50) NOT NULL DEFAULT '',
  `numb` varchar(50) NOT NULL DEFAULT '',
  `adress` varchar(50) NOT NULL DEFAULT '',
  `comments` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `user_id` mediumint(8) NOT NULL DEFAULT '0',
  `cost` text NOT NULL,
  `oplata` int(2) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;";

$db_query["3.0"][] = "CREATE TABLE IF NOT EXISTS `".PREFIX."_shopcat` (
  `id` smallint(5) NOT NULL AUTO_INCREMENT,
  `parentid` smallint(5) NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `alt_name` varchar(50) NOT NULL DEFAULT '',
  `icon` varchar(200) NOT NULL DEFAULT '',
  `descr` varchar(200) NOT NULL DEFAULT '',
  `keywords` text NOT NULL,
  `sort` varchar(10) DEFAULT NULL,
  `metatitle` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;";

$db_query["3.0"][] = "CREATE TABLE IF NOT EXISTS `".PREFIX."_tovar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `short_story` text NOT NULL,
  `full_story` text NOT NULL,
  `price` float(10,2) NOT NULL,
  `sales` float(10,3) NOT NULL DEFAULT '0.000',
  `foto` varchar(255) NOT NULL,
  `clear` float(10,2) NOT NULL,
  `xfields` text NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `descr` varchar(200) NOT NULL DEFAULT '',
  `keywords` text NOT NULL,
  `category` varchar(200) NOT NULL DEFAULT '0',
  `alt_name` varchar(200) NOT NULL DEFAULT '',
  `rating` smallint(5) NOT NULL DEFAULT '0',
  `vote_num` smallint(5) unsigned NOT NULL DEFAULT '0',
  `comm_num` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `alt_name` (`alt_name`),
  KEY `category` (`category`),
  KEY `date` (`date`),
  FULLTEXT KEY `short_story` (`short_story`,`full_story`,`xfields`,`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;";

$db_query["3.0"][] = "CREATE TABLE IF NOT EXISTS `".PREFIX."_shop_comm` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL DEFAULT '0',
  `user_id` mediumint(8) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `autor` varchar(40) NOT NULL DEFAULT '',
  `email` varchar(40) NOT NULL DEFAULT '',
  `text` text NOT NULL,
  `ip` varchar(16) NOT NULL DEFAULT '',
  `is_register` tinyint(1) NOT NULL DEFAULT '0',
  `approve` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;";

$db_query["3.1"][] = "CREATE TABLE IF NOT EXISTS `".PREFIX."_shopstatus` (
  `id` smallint(5) NOT NULL AUTO_INCREMENT,
  `end` smallint(1) NOT NULL DEFAULT '0',
  `name` varchar(150) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;";
$db_query["3.1"][] = "ALTER TABLE `".PREFIX."_activcost` ADD `status` int(2) NOT NULL AFTER `date`;";
$db_query["3.2"][] = "ALTER TABLE `".PREFIX."_tovar` ADD `oldprice` float(10,2) NOT NULL default '0' AFTER `price`;";
$db_query["3.2"][] = "ALTER TABLE `".PREFIX."_tovar` ADD `tcount` int(11) NOT NULL default '0' AFTER `price`;";
$db_query["3.3"][] = "CREATE TABLE ".PREFIX."_shop_logs (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tovar` int(10) NOT NULL default '0',
  `member` varchar(40) NOT NULL default '',
  `ip` varchar(16) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `tovar` (`tovar`),
  KEY `member` (`member`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */";
  
$db_query["3.4"][] = "ALTER TABLE `".PREFIX."_tovar` ADD `echo` int(1) NOT NULL default '0' AFTER `price`;";

$db_query["3.4"][] = "UPDATE `".PREFIX."_tovar` SET echo=1;";

$db_query["3.5"][] = "ALTER TABLE `".PREFIX."_tovar` ADD `fotos` varchar(255) NOT NULL AFTER `foto`;";

$db_query["3.5"][] = "ALTER TABLE `".PREFIX."_activcost` ADD `fields` text NOT NULL AFTER `email`;";

$db_query["3.5"][] = "ALTER TABLE `".PREFIX."_tovar` ADD `metatitle` varchar(255) NOT NULL AFTER `title`;";

$db_query["3.5"][] = "ALTER TABLE `".PREFIX."_shop_comm` ADD `fields` text NOT NULL AFTER `text`;";

$db_query["3.5"][] = "CREATE TABLE ".PREFIX."_shop_banners (
  `id` smallint(5) NOT NULL auto_increment,
  `banner_tag` varchar(40) NOT NULL default '',
  `descr` varchar(200) NOT NULL default '',
  `code` text NOT NULL,
  `approve` tinyint(1) NOT NULL default '0',
  `short_place` tinyint(1) NOT NULL default '0',
  `bstick` tinyint(1) NOT NULL default '0',
  `main` tinyint(1) NOT NULL default '0',
  `category` VARCHAR(255) NOT NULL default '',
  `grouplevel` varchar(100) NOT NULL default 'all',
  `start` varchar(15) NOT NULL default '',
  `end` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */";
  
?>