CREATE TABLE device_info (
id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
device_id varchar(255) NOT NULL COMMENT ‘设备id’,
phone_number varchar(255) NOT NULL COMMENT ‘手机号’,
union_id varchar(255) COMMENT ‘unionid’,
create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘更新时间’,
PRIMARY KEY (id),
UNIQUE KEY unique_device_phone (device_id,phone_number)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=‘设备信息表’;
