[ExDragon]

CREATE TABLE `auction` (
  `guid` int(11) unsigned NOT NULL default '0',
  `account` int(11) unsigned default '0',
  `if_class` tinyint(3) unsigned default '0',
  `if_flag` tinyint(3) unsigned default '0',
  `if_level` tinyint(3) unsigned default '0',
  PRIMARY KEY  (`guid`),
  KEY `account` (`account`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `shop` (
  `key` int(11) unsigned default '0',
  `guid` int(11) unsigned NOT NULL default '0',
  `shop_guid` int(11) unsigned default '0',
  UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `news` (
  `id_news` int(11) unsigned NOT NULL default '0',
  `author` varchar(32) default NULL,
  `name` tinytext NOT NULL,
  `min` text NOT NULL
  `full` text NOT NULL
  `date` timestamp NOT NULL default '0000-00-00 00:00:00',
  `hide` enum('show','hide') default 'show',
  PRIMARY KEY  (`id_news`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;