-- auto Generated on 2018-12-21
-- DROP TABLE IF EXISTS sc_device_date_base;
CREATE TABLE sc_device_date_base(
	id BIGINT (20) NOT NULL AUTO_INCREMENT COMMENT 'id',
	max VARCHAR (128) DEFAULT '' COMMENT 'max',
	appeui VARCHAR (128) DEFAULT '' COMMENT 'appeui',
	last_upate_time VARCHAR (128) DEFAULT '' COMMENT 'lastUpateTime',
	data VARCHAR (128) DEFAULT '' COMMENT 'data',
	reserver VARCHAR (512) DEFAULT '' COMMENT 'reserver',
	data_type INT (11) DEFAULT -1 COMMENT 'dataType',
	gateways VARCHAR (512) DEFAULT '' COMMENT 'gateways',
	is_analyse INT (11) DEFAULT -1 COMMENT 'isAnalyse',
	date_create TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'dateCreate',
	PRIMARY KEY (id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT '设备上报数据';