CREATE TABLE `luser` (
`uid` int(11) unsigned NOT NULL COMMENT '关联 fuser 一对一',
`pid` int(11) DEFAULT NULL COMMENT '邀请人为普通用户',
`spid` int(11) DEFAULT NULL COMMENT '邀请人为合伙人',
`inviteCount` int(11) unsigned DEFAULT '0' COMMENT '邀请人数',
`activityCount` int(11) unsigned DEFAULT '0' COMMENT '参加的活动数',
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updateTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`status` tinyint(255) unsigned DEFAULT '1' COMMENT '是否可用',
PRIMARY KEY (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
CURRENT_TIMESTAMP COMMENT
ON UPDATE CURRENT_TIMESTAMP