hmCrm
/
hmcrm_2015-04-02.sql

# ************************************************************
# Sequel Pro SQL dump
# Version 4096
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# Host: 127.0.0.1 (MySQL 5.5.42)
# Database: hmcrm
# Generation Time: 2015-04-02 14:15:33 +0000
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table hmcrm_album
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hmcrm_album`;

CREATE TABLE `hmcrm_album` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `gname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `gpath` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

LOCK TABLES `hmcrm_album` WRITE;
/*!40000 ALTER TABLE `hmcrm_album` DISABLE KEYS */;

INSERT INTO `hmcrm_album` (`id`, `cid`, `gname`, `gpath`, `date`)
VALUES
	(2,53,X'',X'31343237353238363435353531363562633533616439312E6A7067','2015-03-28'),
	(3,53,X'',X'31343237353238363630353531363562643439323665642E6A7067','2015-03-28'),
	(4,53,X'',X'31343237353238363736353531363562653435383136652E6A7067','2015-03-28'),
	(5,53,X'',X'31343237353238363836353531363562656564313535662E6A7067','2015-03-28'),
	(6,53,X'',X'31343237353238363938353531363562666130336438362E6A7067','2015-03-28'),
	(7,53,X'',X'31343237353238373437353531363563326230383036362E6A7067','2015-03-28'),
	(8,53,X'',X'31343237353238373534353531363563333237303235392E6A7067','2015-03-28'),
	(9,53,X'',X'31343237353238373630353531363563333864393936342E6A7067','2015-03-28'),
	(10,53,X'',X'31343237353238373636353531363563336563343364632E6A7067','2015-03-28'),
	(11,53,X'',X'31343237353238373733353531363563343539626261332E6A7067','2015-03-28'),
	(12,50,X'',X'31343237353239363739353531363566636632383630372E6A7067','2015-03-28'),
	(13,52,X'',X'31343237393334353238353531633864343032613434322E6A7067','2015-04-02'),
	(14,53,X'',X'31343237393635353535353531643036373336373734352E6A7067','2015-04-02'),
	(15,53,X'',X'31343237393635363437353531643036636664333432362E706E67','2015-04-02'),
	(16,53,X'',X'31343237393635363731353531643036653730316262322E706E67','2015-04-02'),
	(17,53,X'',X'31343237393635363731353531643036653730316262322E706E67','2015-04-02'),
	(18,53,X'',X'31343237393635363731353531643036653730316262322E706E67','2015-04-02'),
	(19,53,X'',X'31343237393635363731353531643036653730316262322E706E67','2015-04-02'),
	(20,53,X'',X'31343237393635363731353531643036653730316262322E706E67','2015-04-02'),
	(21,53,X'',X'31343237393635363731353531643036653730316262322E706E67','2015-04-02'),
	(22,53,X'',X'31343237393635363731353531643036653730316262322E706E67','2015-04-02'),
	(23,53,X'',X'31343237393635363731353531643036653730316262322E706E67','2015-04-02'),
	(24,53,X'',X'31343237393635373137353531643037313565666335372E6A7067','2015-04-02'),
	(25,53,X'',X'31343237393635373334353531643037323633306132322E6A7067','2015-04-02'),
	(26,53,X'',X'31343237393635373334353531643037323633306132322E6A7067','2015-04-02'),
	(27,53,X'',X'31343237393635383039353531643037373134613035632E706E67','2015-04-02'),
	(28,53,X'',X'31343237393635383039353531643037373134613035632E706E67','2015-04-02'),
	(29,53,X'',X'31343237393635393931353531643038323738353430322E6A7067','2015-04-02'),
	(30,53,X'',X'31343237393635393931353531643038323738353430322E6A7067','2015-04-02'),
	(31,53,X'',X'31343237393636303335353531643038353332666164632E6A7067','2015-04-02'),
	(32,53,X'',X'31343237393636303335353531643038353332666164632E6A7067','2015-04-02'),
	(33,53,X'',X'31343237393636303338353531643038353636613438392E6A7067','2015-04-02'),
	(34,53,X'',X'31343237393636303338353531643038353636613438392E6A7067','2015-04-02'),
	(35,53,X'',X'31343237393636303937353531643038393139366565302E6A7067','2015-04-02'),
	(36,52,X'',X'31343237393830363537353531643431373130623565332E6A7067','2015-04-02'),
	(37,52,X'',X'31343237393830373131353531643431613737393364652E6A7067','2015-04-02'),
	(38,59,X'',X'31343237393830373439353531643431636464356633372E6A7067','2015-04-02'),
	(39,52,X'',X'31343237393833343838353531643463383062373837312E6A7067','2015-04-02'),
	(40,59,X'',X'31343237393833363739353531643464336664656438352E6A7067','2015-04-02'),
	(41,59,X'',X'31343237393833373335353531643464373730333464302E6A7067','2015-04-02'),
	(42,59,X'',X'31343237393833373534353531643464386163343339312E6A7067','2015-04-02');

/*!40000 ALTER TABLE `hmcrm_album` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table hmcrm_babys
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hmcrm_babys`;

CREATE TABLE `hmcrm_babys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `b_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `b_birth` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `b_sex` enum('男','女') COLLATE utf8_bin DEFAULT '男',
  `b_age` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `b_remark` text COLLATE utf8_bin,
  `b_head` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `hmcrm_babys` WRITE;
/*!40000 ALTER TABLE `hmcrm_babys` DISABLE KEYS */;

INSERT INTO `hmcrm_babys` (`id`, `cid`, `b_name`, `b_birth`, `b_sex`, `b_age`, `b_remark`, `b_head`)
VALUES
	(1,50,X'E78E8BE5A4A7E994A431',X'323031342D31322D3132',X'E794B7',X'35',X'6265616E7374616C6B20E698AFE4B880E4B8AAE7AE80E58D95E38081E5BFABE9809FE79A84E6B688E681AFE9989FE58897E38082E794B1E4BA8EE98089E59E8BE99C80E8A681EFBC8CE7BBBCE59088E59084E7A78DE8AFADE8A880E694AFE68C81E4B88AE99DA2E38081E680A7E883BDE4B88AE99DA2E38081E4BDBFE794A8E58A9FE883BDE4B88AE99DA2E5819AE4BA86E5AFB9E6AF94EFBC8CE7BBBCE59088E4BC98E4BA8EE585B6E4BB96E79A84E6B688E681AF2E2E323133313233',X'75706C6F61642F353530643165343134396638362E6A7067'),
	(11,52,X'E585B3E6B0B8E7A5BA',X'323031342D3032EFBC8D3031',X'E794B7',X'31','',X'75706C6F61642F31343237393833333335353531643462653733316532392E6A7067'),
	(12,53,X'E8B5B52E2E2E3F',X'323030392D30332D3132',X'E794B7',X'35','',X'75706C6F61642F31343237393732333938353531643231326562623532322E6A7067');

/*!40000 ALTER TABLE `hmcrm_babys` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table hmcrm_consultant
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hmcrm_consultant`;

CREATE TABLE `hmcrm_consultant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `pwd` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `lastlogin` datetime DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `cname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `chead` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `hmcrm_consultant` WRITE;
/*!40000 ALTER TABLE `hmcrm_consultant` DISABLE KEYS */;

INSERT INTO `hmcrm_consultant` (`id`, `account`, `pwd`, `lastlogin`, `email`, `cname`, `chead`)
VALUES
	(1,X'79636368656E',X'313838376432666137386366363362353038666537376534306164643431636532393365353731393637316262653763393464653461306564356239343934333930356335623837366233326239396662346337323634303336383966663537','2015-03-19 09:55:12',X'64657640697773686F702E636E',X'497679',X'687474703A2F2F686D63726D2F6C61796F7574732F5468756D626E61696C2F3F703D2F75706C6F61642F31343237393830363537353531643431373130623565332E6A706726683D32303026773D323030');

/*!40000 ALTER TABLE `hmcrm_consultant` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table hmcrm_customer_labelhash
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hmcrm_customer_labelhash`;

CREATE TABLE `hmcrm_customer_labelhash` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `hashkey` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `label_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


# Dump of table hmcrm_customer_labels
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hmcrm_customer_labels`;

CREATE TABLE `hmcrm_customer_labels` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(11) unsigned DEFAULT NULL,
  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


# Dump of table hmcrm_customers
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hmcrm_customers`;

CREATE TABLE `hmcrm_customers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cus_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `cus_addate` date DEFAULT NULL,
  `cus_age` tinyint(4) DEFAULT NULL,
  `cus_sex` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `cus_uid` tinyint(4) DEFAULT '0',
  `cus_head` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `cus_birth` date DEFAULT NULL,
  `cus_city` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `cus_prov` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `cus_addr` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `cus_personid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `cus_email` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `cus_phone` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `hmcrm_customers` WRITE;
/*!40000 ALTER TABLE `hmcrm_customers` DISABLE KEYS */;

INSERT INTO `hmcrm_customers` (`id`, `cus_name`, `cus_addate`, `cus_age`, `cus_sex`, `cus_uid`, `cus_head`, `cus_birth`, `cus_city`, `cus_prov`, `cus_addr`, `cus_personid`, `cus_email`, `cus_phone`)
VALUES
	(52,X'E5BB96E8B59F','2015-03-24',33,X'E5A5B3',1,X'75706C6F61642F31343237393831373535353531643435626230663861302E6A7067','1982-05-10',X'E5B9BFE5B79E',X'E5B9BFE4B89CE79C81',X'E5B9BFE5B79EE5B882E795AAE7A6BAE58CBAE6B49BE6BAAAE696B0E59F8EE6B49BE6B996E5B185E4B880E6A08BE4B98BE59B9B343031',X'343430353037313938323035313030363858',X'',X'3135313132313239363438'),
	(53,X'E78E8BE5B08FE69687','2015-03-26',30,X'E5A5B3',1,X'75706C6F61642F31343237393831373439353531643435623539356636632E6A7067','1984-09-01',X'E5B9BFE5B79E',X'E5B9BFE4B89C',X'E5B9BFE5B79EE5B882E5A4A9E6B2B3E58CBAE5BBBAE4B8ADE8B7AF3636E58FB7E4BDB3E983BDE59586E58AA1E5A4A7E58EA635E6A5BC353033E5AEA4',X'3432393030363139383430393031',X'',X'3138363838383930303630'),
	(54,X'313233','2015-04-02',12,X'E794B7',1,NULL,'1992-12-12',X'',X'617336356434',X'717765717765',X'',X'313233717364',X'363561733464'),
	(55,X'313233','2015-04-02',12,X'E794B7',1,NULL,'1992-12-12',X'',X'617336356434',X'717765717765',X'',X'313233717364',X'363561733464'),
	(59,X'32313233','2015-04-02',12,X'E794B7',1,X'75706C6F61642F31343237393830373336353531643431633063316165342E6A7067','2012-11-01',X'',X'',X'',X'',X'',X'');

/*!40000 ALTER TABLE `hmcrm_customers` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table hmcrm_ext
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hmcrm_ext`;

CREATE TABLE `hmcrm_ext` (
  `id` int(11) NOT NULL,
  `ext` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Dump of table hmcrm_ideas
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hmcrm_ideas`;

CREATE TABLE `hmcrm_ideas` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `idea` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

LOCK TABLES `hmcrm_ideas` WRITE;
/*!40000 ALTER TABLE `hmcrm_ideas` DISABLE KEYS */;

INSERT INTO `hmcrm_ideas` (`id`, `cid`, `idea`, `date`)
VALUES
	(3,50,X'',NULL),
	(4,53,X'617364617364','2015-04-02 08:28:40'),
	(5,52,X'E5B9BFE5B79EE5B882E795AAE7A6BAE58CBAE6B49BE6BAAAE696B0E59F8EE6B49BE6B996E5B185E4B880E6A08BE4B98BE59B9B343031','2015-04-02 22:07:44');

/*!40000 ALTER TABLE `hmcrm_ideas` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table hmcrm_journal
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hmcrm_journal`;

CREATE TABLE `hmcrm_journal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(4) DEFAULT NULL,
  `jtitle` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `jdate` datetime DEFAULT NULL,
  `jcont` text COLLATE utf8_bin,
  `cusid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOCK TABLES `hmcrm_journal` WRITE;
/*!40000 ALTER TABLE `hmcrm_journal` DISABLE KEYS */;

INSERT INTO `hmcrm_journal` (`id`, `uid`, `jtitle`, `jdate`, `jcont`, `cusid`)
VALUES
	(54,52,X'','2015-03-24 17:12:10',X'E88AB1E78E8B786CE68B89E68B89E8A3A4EFBC8C786CE7BAB8E5B0BFE8A3A4EFBC8C6CE68B89E68B89E8A3A4EFBC8CE59BA4E8B4A73130E58C85E38082E5A49FE794A832E4B8AAE69C88EFBC8CE4B98BE5898DE5B08FE5ADA9E5AD90E5969DE6BEB3E6B4B2E788B1E4BB96E7BE8EEFBC8CE78EB0E59CA8E5B7B2E7BB8FE68DA2E4BA86E587A0E7A78DEFBC8CE8BF98E59CA8E5B09DE8AF95E588ABE79A84E59381E7898CEFBC8CE69CAAE69C80E7BB88E7A1AEE5AE9AE38082',1),
	(55,52,X'','2015-03-24 17:19:58',X'4CE7A081E68B89E68B89E8A3A433E58C85EFBC8C584CE7A081E68B89E68B89E8A3A436E58C85EFBC8C584CE7BAB8E5B0BFE8A3A437E58C85',1),
	(56,52,X'','2015-03-26 13:10:41',X'32E58C856CE7A081E68B89E68B89E8A3A4EFBC8C3130E58C85786CE68B89E68B89E8A3A4E38082E68890E4BAA4E38082E5AEA2E688B7E6AF94E8BE83E5969CE6ACA2E5B08FE7A4BCE59381EFBC8CE4B88DE8A681E5BF98E8AEB0E982AEE5AF84E7BBB5E7BE8AE6B2B9E38082',1),
	(57,53,X'','2015-03-26 14:29:14',X'32E58C85E5BEB7E8BF90E884B1E88482E5A5B6E7B289EFBC8CE8AFB4E4BD93E9AA8CE4B98BE5908EE8A681E698AFE58FAFE4BBA5E68EA8E88D90E7BB99E5908CE4BA8B',1),
	(62,50,X'','2015-03-28 16:01:38',X'4A75737420427265616B206974',1),
	(63,58,X'','2015-04-02 17:19:13',X'313233313233313233',1),
	(64,53,X'','2015-04-02 17:19:23',X'313233313233313233',1),
	(65,59,X'','2015-04-02 21:33:10',X'5648532076656E69616D20616C69717561207468756E6465726361747320646F6C6F7265206B656666697965682C206469726563742074726164652061757468656E7469632050425220656975736D6F642E20446F6C6F72652076656E69616D2066616E6E79207061636B2C2070726F6964656E74206970686F6E65206D697874617065206972757265207365642E204C6F2D6669206C656767696E6773207374756D70746F776E20636172646967616E20657473792C207069746368666F726B206563686F207061726B2074657272792072696368617264736F6E206E657874206C6576656C206C61626F72652070726F6964656E742E',1),
	(66,52,X'','2015-04-02 22:06:14',X'E88AB1E78E8B786CE68B89E68B89E8A3A4EFBC8C786CE7BAB8E5B0BFE8A3A4EFBC8C6CE68B89E68B89E8A3A4EFBC8CE59BA4E8B4A73130E58C85E38082E5A49FE794A832E4B8AAE69C88EFBC8CE4B98BE5898DE5B08FE5ADA9E5AD90E5969DE6BEB3E6B4B2E788B1E4BB96E7BE8EEFBC8CE78EB0E59CA8E5B7B2E7BB8FE68DA2E4BA86E587A0E7A78DEFBC8CE8BF98E59CA8E5B09DE8AF95E588ABE79A84E59381E7898CEFBC8CE69CAAE69C80E7BB88E7A1AEE5AE9AE38082',1);

/*!40000 ALTER TABLE `hmcrm_journal` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table hmcrm_newfeeds
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hmcrm_newfeeds`;

CREATE TABLE `hmcrm_newfeeds` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  `ftype` int(11) DEFAULT NULL,
  `fhash` text CHARACTER SET utf8 COLLATE utf8_bin,
  `fid` int(11) DEFAULT '0',
  `ftime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

LOCK TABLES `hmcrm_newfeeds` WRITE;
/*!40000 ALTER TABLE `hmcrm_newfeeds` DISABLE KEYS */;

INSERT INTO `hmcrm_newfeeds` (`id`, `cid`, `uid`, `ftype`, `fhash`, `fid`, `ftime`)
VALUES
	(1,NULL,1,0,X'31343237393635373334353531643037323633306132322E6A7067',0,'2015-04-02 17:09:34'),
	(2,53,1,0,X'31343237393635383039353531643037373134613035632E706E67',0,'2015-04-02 17:10:09'),
	(3,53,1,0,X'31343237393635393931353531643038323738353430322E6A7067',29,'2015-04-02 17:13:11'),
	(4,53,1,0,X'31343237393636303335353531643038353332666164632E6A7067',31,'2015-04-02 17:13:55'),
	(5,53,1,0,X'31343237393636303338353531643038353636613438392E6A7067',33,'2015-04-02 17:13:58'),
	(6,53,1,0,X'31343237393636303937353531643038393139366565302E6A7067',35,'2015-04-02 17:14:57'),
	(7,52,1,0,X'31343237393830363537353531643431373130623565332E6A7067',36,'2015-04-02 21:17:37'),
	(8,52,1,0,X'31343237393830373131353531643431613737393364652E6A7067',37,'2015-04-02 21:18:31'),
	(9,59,1,0,X'31343237393830373439353531643431636464356633372E6A7067',38,'2015-04-02 21:19:09'),
	(10,59,1,1,X'5648532076656E69616D20616C69717561207468756E6465726361747320646F6C6F7265206B656666697965682C206469726563742074726164652061757468656E7469632050425220656975736D6F642E20446F6C6F72652076656E69616D2066616E6E79207061636B2C2070726F6964656E74206970686F6E65206D697874617065206972757265207365642E204C6F2D6669206C656767696E6773207374756D70746F776E20636172646967616E20657473792C207069746368666F726B206563686F207061726B2074657272792072696368617264736F6E206E657874206C6576656C206C61626F72652070726F6964656E742E',65,'2015-04-02 21:33:10'),
	(11,52,0,0,X'31343237393833343838353531643463383062373837312E6A7067',39,'2015-04-02 22:04:48'),
	(12,52,1,1,X'E88AB1E78E8B786CE68B89E68B89E8A3A4EFBC8C786CE7BAB8E5B0BFE8A3A4EFBC8C6CE68B89E68B89E8A3A4EFBC8CE59BA4E8B4A73130E58C85E38082E5A49FE794A832E4B8AAE69C88EFBC8CE4B98BE5898DE5B08FE5ADA9E5AD90E5969DE6BEB3E6B4B2E788B1E4BB96E7BE8EEFBC8CE78EB0E59CA8E5B7B2E7BB8FE68DA2E4BA86E587A0E7A78DEFBC8CE8BF98E59CA8E5B09DE8AF95E588ABE79A84E59381E7898CEFBC8CE69CAAE69C80E7BB88E7A1AEE5AE9AE38082',66,'2015-04-02 22:06:14'),
	(13,59,0,0,X'31343237393833363739353531643464336664656438352E6A7067',40,'2015-04-02 22:07:59'),
	(14,59,1,0,X'31343237393833373335353531643464373730333464302E6A7067',41,'2015-04-02 22:08:57'),
	(15,59,1,0,X'31343237393833373534353531643464386163343339312E6A7067',42,'2015-04-02 22:09:14');

/*!40000 ALTER TABLE `hmcrm_newfeeds` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table hmcrm_remind
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hmcrm_remind`;

CREATE TABLE `hmcrm_remind` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `remind` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

LOCK TABLES `hmcrm_remind` WRITE;
/*!40000 ALTER TABLE `hmcrm_remind` DISABLE KEYS */;

INSERT INTO `hmcrm_remind` (`id`, `cid`, `remind`, `date`)
VALUES
	(5,53,X'61617364617364','2015-04-02 08:28:37'),
	(6,53,X'363534363534363534','2015-04-02 17:15:11'),
	(7,59,X'617373647364','2015-04-02 21:19:06'),
	(8,52,X'E5B9BFE5B79EE5B882E795AAE7A6BAE58CBAE6B49BE6BAAAE696B0E59F8EE6B49BE6B996E5B185E4B880E6A08BE4B98BE59B9B343031','2015-04-02 22:07:41');

/*!40000 ALTER TABLE `hmcrm_remind` ENABLE KEYS */;
UNLOCK TABLES;


/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;