INSERT INTO `all_accesses` ( `type` , `name` ) 
VALUES (
'mddjine_admin', 'аукцион джинов - управление (MD)'
);

ALTER TABLE `user` ADD `md_djine` ENUM( '0', '1' ) DEFAULT '0' NOT NULL ;
-- 
-- Структура таблицы `md_djine`
-- 

DROP TABLE IF EXISTS `md_djine`;
CREATE TABLE `md_djine` (
  `id` int(11) NOT NULL auto_increment,
  `start` int(11) NOT NULL,
  `step_time` int(11) default NULL,
  `time_activate` int(11) NOT NULL,
  `stat` varchar(8) NOT NULL,
  `moder` int(11) NOT NULL,
  `stop_note` varchar(255) NOT NULL,
  `id_lot` int(11) NOT NULL,
  `stavka_lot` int(11) NOT NULL,
  `val` varchar(8) NOT NULL,
  `kto_lot` int(11) default NULL,
  `step_lot` int(11) NOT NULL,
  `count_st` int(11) default '0',
  `next_time` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Структура таблицы `md_djine_chat`
-- 

DROP TABLE IF EXISTS `md_djine_chat`;
CREATE TABLE `md_djine_chat` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL,
  `msg` varchar(1024) character set utf8 collate utf8_unicode_ci default NULL,
  `ank_otv` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `time` (`time`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Структура таблицы `md_djine_profile`
-- 

DROP TABLE IF EXISTS `md_djine_profile`;
CREATE TABLE `md_djine_profile` (
  `id` int(11) NOT NULL,
  `count_prod` int(11) default '0',
  `reit` int(11) NOT NULL default '0',
  `billing` int(11) default '0',
  `money` int(11) default '0',
  `balls` int(11) default '0',
  `dis` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Таблица профилей статистики';

-- --------------------------------------------------------

-- 
-- Структура таблицы `md_djine_resp`
-- 

DROP TABLE IF EXISTS `md_djine_resp`;
CREATE TABLE `md_djine_resp` (
  `id` int(11) NOT NULL auto_increment,
  `st` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `autor` int(11) NOT NULL,
  `djine` int(11) NOT NULL,
  `est` smallint(1) default '0',
  `text` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Структура таблицы `md_djine_uch`
-- 

DROP TABLE IF EXISTS `md_djine_uch`;
CREATE TABLE `md_djine_uch` (
  `id` int(11) NOT NULL auto_increment,
  `auc_id` int(11) NOT NULL,
  `uid` int(11) default NULL,
  `s_stavka` int(11) NOT NULL,
  `val` varchar(8) NOT NULL,
  `stat` enum('0','1','2','3') default '0',
  `prod` int(11) NOT NULL default '0',
  `komu` int(11) NOT NULL default '0',
  `count_stavk` int(11) NOT NULL default '0',
  `djtime` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
