-- ----------------------------
-- Table structure for iot_to_platform_temp
-- ----------------------------
DROP TABLE IF EXISTS iot_to_platform_temp;
CREATE TABLE iot_to_platform_temp (
  `commodity_name` CHAR(50)  DEFAULT NULL,
  `commodity_key` CHAR(50)  DEFAULT NULL,
  `facility_code` CHAR(50)  DEFAULT NULL,
  `facility_desc` CHAR(50)  DEFAULT NULL,
  `facility_key` CHAR(50)  DEFAULT NULL,
  `commodity_property_name` CHAR(50)  DEFAULT NULL,
  `commodity_property_code` CHAR(50)  DEFAULT NULL,
  `commodity_property_desc` CHAR(50)  DEFAULT NULL,
  `ctrl_value` int(11)  DEFAULT NULL,
  `desc_value` int(11)  DEFAULT NULL,
  `point_code` CHAR(64)  DEFAULT NULL,
  `point_desc` CHAR(128)  DEFAULT NULL,
  `point_type` int(11) DEFAULT NULL,
  `meas_typeid` int(11) DEFAULT NULL,
  `alm_prio` int(11) DEFAULT NULL,
  `controll_able` int(11) DEFAULT NULL,
  `normal_state` int(11) DEFAULT NULL
);

alter table iot_to_platform_temp add primary key (facility_key,commodity_property_code,ctrl_value,point_type);

grant select,insert,delete,update on iot_to_platform_temp to 'SEMASTER','SEDATUM';