SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE DATABASE IF NOT EXISTS `@#__@#` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `@#__@#`;

CREATE TABLE `eminer_admin` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `e7a72569b` float unsigned default '0',
  `eea8f538c` char(30) NOT NULL default '',
  `pwd` char(32) NOT NULL default '',
  `uname` char(20) NOT NULL default '',
  `email` char(30) NOT NULL default '',
  `typeid` text,
  `e4ed90012` varchar(20) NOT NULL default '',
  `e80c42f39` varchar(80) NOT NULL,
  `qq` int(13) default '0',
  `logintime` int(11) NOT NULL default '0',
  `e997f5979` int(11) NOT NULL default '0',
  `ecdf740a2` varchar(20) NOT NULL default '',
  `ed1befa03` varchar(300) NOT NULL default '',
  `tel` int(12) default '0',
  `e532c28d5` int(11) default '0',
  `usetime` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=46 ;

CREATE TABLE `eminer_admintype` (
  `rank` float NOT NULL default '1',
  `typename` varchar(30) NOT NULL default '',
  `system` smallint(6) NOT NULL default '0',
  `channel` char(20) default NULL,
  `purviews` varchar(50) NOT NULL,
  PRIMARY KEY  (`rank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `eminer_co_htmls` (
  `aid` mediumint(8) unsigned NOT NULL auto_increment,
  `nid` varchar(8) NOT NULL default '0',
  `typeid` smallint(5) unsigned NOT NULL default '0',
  `title` varchar(60) NOT NULL default '',
  `litpic` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `dtime` int(10) unsigned NOT NULL default '0',
  `isdown` tinyint(1) unsigned NOT NULL default '0',
  `eec5f242f` tinyint(1) NOT NULL default '0',
  `result` mediumtext,
  `isdelete` tinyint(1) NOT NULL default '0',
  `sortid` float(16,4) unsigned NOT NULL default '0.0000',
  `curnum` int(4) NOT NULL default '0',
  `ebee555a9` tinyint(1) NOT NULL default '0',
  `pubtime` int(10) NOT NULL default '0',
  `isdone` tinyint(1) NOT NULL default '0',
  `arcid` mediumint(8) unsigned NOT NULL default '0',
  `ea58179f1` int(3) unsigned NOT NULL default '0',
  `soneca7311bf` int(3) NOT NULL default '0',
  `audit` tinyint(1) NOT NULL default '0',
  `eea8f538c` varchar(21) NOT NULL default '',
  `ed946d2b0` varchar(100) NOT NULL,
  PRIMARY KEY  (`aid`),
  KEY `nid` (`nid`),
  KEY `typeid` (`typeid`,`title`,`url`,`dtime`,`isdown`,`eec5f242f`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6798 ;


CREATE TABLE `eminer_co_mediaurls` (
  `nid` varchar(8) NOT NULL default '0',
  `hash` char(32) NOT NULL default '',
  `tofile` char(60) NOT NULL default '',
  `imgurl` varchar(300) NOT NULL,
  `e0a43a765` varchar(300) NOT NULL default '',
  `eec5f242f` tinyint(1) NOT NULL default '0',
  `isdown` tinyint(1) NOT NULL default '0',
  `pictype` tinyint(1) NOT NULL default '0' COMMENT '0为普通，1为list_pic,2为litpic',
  `sourcearea` tinyint(1) NOT NULL default '1',
  `dtime` int(10) unsigned default '0',
  `id` bigint(12) NOT NULL auto_increment,
  `arcid` int(10) NOT NULL default '0',
  `eea8f538c` varchar(21) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `hash` (`hash`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1219 ;


CREATE TABLE `eminer_kwcache` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `nid` varchar(5) NOT NULL default '0',
  `url` text,
  `title` varchar(500) default NULL,
  `litpic` varchar(500) default NULL,
  `eea8f538c` varchar(21) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=645 ;

CREATE TABLE `eminer_kwhash` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `hash` varchar(32) NOT NULL default '',
  `nid` varchar(8) NOT NULL default '0',
  `suc` tinyint(1) NOT NULL default '0',
  `eea8f538c` varchar(21) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8265 ;