/*
MySQL Data Transfer
Source Host: localhost
Source Database: customercase
Target Host: localhost
Target Database: customercase
Date: 2009-6-11 8:26:51
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
CREATE TABLE `admin` (
  `id` int(10) NOT NULL auto_increment,
  `admin` varchar(40) default NULL,
  `password` varchar(40) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for custom
-- ----------------------------
CREATE TABLE `custom` (
  `id` int(10) NOT NULL auto_increment,
  `gradeid` int(10) default NULL,
  `languageid` int(10) default NULL,
  `company` varchar(100) default NULL,
  `url` varchar(50) default NULL,
  `jsqid` varchar(10) default NULL,
  `state` int(2) default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for grade
-- ----------------------------
CREATE TABLE `grade` (
  `gradeid` int(10) NOT NULL default '0',
  `gradename` varchar(40) default NULL,
  PRIMARY KEY  (`gradeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for guestuser
-- ----------------------------
CREATE TABLE `guestuser` (
  `id` int(10) NOT NULL auto_increment,
  `guestusername` varchar(40) default NULL,
  `guestpwd` varchar(40) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for keyrank
-- ----------------------------
CREATE TABLE `keyrank` (
  `id` int(10) NOT NULL auto_increment,
  `keyword` varchar(1000) default NULL,
  `companyid` int(10) default NULL,
  `searchid` int(10) default NULL,
  `transmean` varchar(1000) default NULL,
  `rank` int(10) default NULL,
  `edittime` varchar(40) default NULL,
  `state` int(2) default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for language
-- ----------------------------
CREATE TABLE `language` (
  `id` int(4) NOT NULL auto_increment,
  `language` varchar(40) collate utf8_unicode_ci default NULL,
  `domain` varchar(10) collate utf8_unicode_ci default NULL,
  `kuozhan` varchar(10) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for searchengine
-- ----------------------------
CREATE TABLE `searchengine` (
  `id` int(5) NOT NULL auto_increment,
  `enginename` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', '21232f297a57a5a743894a0e4a801fc3');
INSERT INTO `custom` VALUES ('1', '1', '1', '上海柴油机股份有限公司', 'sdeciepower.com', '531', '1');
INSERT INTO `custom` VALUES ('2', '1', '1', 'sfs', 'sdfs', '11', '0');
INSERT INTO `grade` VALUES ('1', '上市公司');
INSERT INTO `grade` VALUES ('2', '龙头企业');
INSERT INTO `grade` VALUES ('3', '中小型企业');
INSERT INTO `guestuser` VALUES ('1', '456789', 'e35cf7b66449df565f93c607d5a81d09');
INSERT INTO `guestuser` VALUES ('2', '12345678', '25d55ad283aa400af464c76d713c07ad');
INSERT INTO `keyrank` VALUES ('2', 'diesel engines', '1', '1', '柴油机', '3', '1244518986', '1');
INSERT INTO `keyrank` VALUES ('16', 'electric engine', '1', '2', '电机', '1', '1244525614', '1');
INSERT INTO `keyrank` VALUES ('17', 'ceshi 2', '1', '1', 'ceshi 2', '7', '1244540796', '1');
INSERT INTO `language` VALUES ('1', '英语', 'English', 'en');
INSERT INTO `language` VALUES ('2', '俄罗斯', 'Russian', 'ru');
INSERT INTO `language` VALUES ('3', '西班牙', 'Spanish', 'es');
INSERT INTO `language` VALUES ('4', '法语', 'French', 'fr');
INSERT INTO `language` VALUES ('5', '德语', 'German', 'de');
INSERT INTO `language` VALUES ('6', '日语', 'Japanese', 'jp');
INSERT INTO `language` VALUES ('7', '韩语', 'Korean', 'kr');
INSERT INTO `language` VALUES ('8', '阿拉伯', 'Arabic', 'ae');
INSERT INTO `language` VALUES ('9', '葡萄牙', 'Portuguese', 'pt');
INSERT INTO `language` VALUES ('10', '意大利', 'Italian', 'it');
INSERT INTO `language` VALUES ('11', '越南', 'Vietnamese', 'vn');
INSERT INTO `language` VALUES ('13', ' 波兰', '', '');
INSERT INTO `searchengine` VALUES ('1', 'google.com');
INSERT INTO `searchengine` VALUES ('2', 'yahoo.com');
INSERT INTO `searchengine` VALUES ('5', 'google.ru');
INSERT INTO `searchengine` VALUES ('4', 'google.es');
INSERT INTO `searchengine` VALUES ('6', 'google.fr');
