DROP TABLE IF EXISTS `userRecord`;CREATE TABLE `userRecord` (`id` int(11) NOT NULL AUTO_INCREMENT,`userId` int(11) NOT NULL COMMENT
'fk'
,`totalStep` int(11) DEFAULT
'0'
COMMENT
'总步数'
,`updateTime` datetime DEFAULT NULL,`createTime` datetime NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT=
'用户记录总表'
;
LOCK TABLES `userRecord` WRITE;insertinto `userRecord`(`id`,`userId`,`totalStep`,`updateTime`,`createTime`) values (1,1001,88000,
'2014-05-16 14:16:50'
,
'2014-05-13 14:16:52'
),(2,1002,35000,
'2014-05-16 14:26:22'
,
'2014-05-12 14:26:24'
),(3,1003,95000,
'2014-05-16 14:28:00'
,
'2014-05-12 14:28:06'
),(4,1007,150000,
'2014-05-16 14:30:31'
,
'2014-04-28 14:30:33'
),(5,1009,288,
'2014-05-19 16:24:26'
,
'2014-05-19 16:24:26'
),(6,1010,33,
'2014-05-19 17:01:50'
,
'2014-05-19 17:01:50'
),(7,1011,33,
'2014-05-19 17:03:31'
,
'2014-05-19 17:03:31'
);UNLOCK TABLES;
DROP TABLE IF EXISTS `userRecordDetail`;CREATE TABLE `userRecordDetail` (`id` int(11) NOT NULL AUTO_INCREMENT,`weigh` double DEFAULT
'0'
COMMENT
'今日体重 kg'
,`calorie` int(11) DEFAULT
'0'
COMMENT
'今日消耗卡路里'
,`stepNum` int(11) DEFAULT
'0'
COMMENT
'今日步数'
,`userId` int(11) NOT NULL COMMENT
'fk'
,`sleepTimes` int(11) DEFAULT
'0'
COMMENT
'今日睡眠时间 单位:分钟'
,`lightSleepTimes` int(11) DEFAULT
'0'
COMMENT
'今日轻度睡眠时间 单位:分钟'
,`heavySleepTimes` int(11) DEFAULT
'0'
COMMENT
'今日重度睡眠时间 单位:分钟'
,`wakeupNum` int(11) DEFAULT
'0'
COMMENT
'今日唤醒次数'
,`updateTime` datetime DEFAULT NULL,`createTime` datetime NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT=
'用户记录详细信息表'
;
LOCK TABLES `userRecordDetail` WRITE;insertinto `userRecordDetail`(`id`,`weigh`,`calorie`,`stepNum`,`userId`,`sleepTimes`,`lightSleepTimes`,`heavySleepTimes`,`wakeupNum`,`updateTime`,`createTime`) values (1,0,0,10000,1001,0,0,0,0,NULL,
'2014-05-16 14:17:53'
),(2,0,0,10000,1001,0,0,0,0,NULL,
'2014-05-15 14:22:58'
),(3,0,0,15000,1001,0,0,0,0,NULL,
'2014-05-14 14:23:56'
),(4,0,0,13000,1001,0,0,0,0,NULL,
'2014-05-13 14:24:10'
),(5,0,0,20000,1001,0,0,0,0,NULL,
'2014-05-12 14:24:32'
),(6,0,0,8000,1001,0,0,0,0,NULL,
'2014-05-11 14:24:51'
),(7,0,0,12000,1001,0,0,0,0,NULL,
'2014-05-09 14:25:02'
),(8,0,0,10000,1002,0,0,0,0,NULL,
'2014-05-16 14:26:50'
),(9,0,0,5000,1002,0,0,0,0,NULL,
'2014-05-15 14:26:58'
),(10,0,0,20000,1002,0,0,0,0,NULL,
'2014-05-14 14:27:14'
),(11,0,0,20000,1003,0,0,0,0,NULL,
'2014-05-16 14:28:46'
),(12,0,0,30000,1003,0,0,0,0,NULL,
'2014-05-15 14:28:54'
),(13,0,0,25000,1003,0,0,0,0,NULL,
'2014-05-13 14:29:01'
),(14,0,0,15000,1003,0,0,0,0,NULL,
'2014-05-12 14:29:07'
),(15,0,0,5000,1003,0,0,0,0,NULL,
'2014-05-08 14:29:39'
),(16,0,0,20000,1007,0,0,0,0,NULL,
'2014-05-16 14:30:45'
),(17,0,0,30000,1007,0,0,0,0,NULL,
'2014-05-15 14:30:54'
),(18,0,0,25000,1007,0,0,0,0,NULL,
'2014-05-14 14:31:02'
),(19,0,0,15000,1007,0,0,0,0,NULL,
'2014-05-13 14:31:10'
),(20,0,0,35000,1007,0,0,0,0,NULL,
'2014-05-12 14:31:18'
),(21,0,0,25000,1007,0,0,0,0,NULL,
'2014-05-11 14:31:26'
),(22,0,0,20000,1007,0,0,0,0,NULL,
'2014-04-30 14:32:02'
),(23,45,111,288,1009,600,100,500,2,
'2014-05-19 16:24:26'
,
'2014-05-19 16:24:26'
),(24,0,66,33,1010,0,0,0,0,
'2014-05-19 17:01:50'
,
'2014-05-19 17:01:50'
),(25,45,33,33,1011,600,100,500,0,
'2014-05-19 17:03:31'
,
'2014-05-19 17:03:31'
);UNLOCK TABLES;