SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for info
-- ----------------------------
DROP TABLE IF EXISTS `info`;
CREATE TABLE `info`  (
  `Num_i` int(1) UNSIGNED NOT NULL AUTO_INCREMENT,
  `Date` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Prib_id` tinyint(1) UNSIGNED NOT NULL,
  `OpNum` tinyint(1) UNSIGNED NOT NULL,
  `ObjectId` tinyint(1) UNSIGNED NOT NULL,
  `x` float(10, 5) NOT NULL,
  `y` float(10, 5) NOT NULL,
  PRIMARY KEY (`Num_i`) USING BTREE,
  UNIQUE INDEX `Number_id_index`(`Num_i`) USING BTREE,
  INDEX `date_index`(`Date`) USING BTREE,
  INDEX `Unit_index`(`Prib_id`) USING BTREE
) ENGINE = Aria CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Page;

-- ----------------------------
-- Table structure for multiplier
-- ----------------------------
DROP TABLE IF EXISTS `multiplier`;
CREATE TABLE `multiplier`  (
  `unit` tinyint(1) NOT NULL,
  `sensor` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `timestamp` datetime(0) NOT NULL,
  `ratio` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `adr` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  INDEX `Unit_index_multip`(`unit`) USING BTREE
) ENGINE = Aria CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Page;

-- ----------------------------
-- Table structure for objects
-- ----------------------------
DROP TABLE IF EXISTS `objects`;
CREATE TABLE `objects`  (
  `NumOb` tinyint(1) UNSIGNED NOT NULL AUTO_INCREMENT,
  `NameOb` varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`NumOb`) USING BTREE
) ENGINE = Aria CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Page;

-- ----------------------------
-- Table structure for opr_list
-- ----------------------------
DROP TABLE IF EXISTS `opr_list`;
CREATE TABLE `opr_list`  (
  `N` tinyint(1) UNSIGNED NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`N`) USING BTREE
) ENGINE = Aria CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Page;

-- ----------------------------
-- Table structure for save_data
-- ----------------------------
DROP TABLE IF EXISTS `save_data`;
CREATE TABLE `save_data`  (
  `Num` int(1) UNSIGNED NOT NULL,
  `Type` char(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `Value` char(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  INDEX `Num_ses`(`Num`) USING BTREE,
  INDEX `Type_value_index`(`Type`, `Value`) USING BTREE
) ENGINE = Aria CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Page;

-- ----------------------------
-- Table structure for sensors_adr
-- ----------------------------
DROP TABLE IF EXISTS `sensors_adr`;
CREATE TABLE `sensors_adr`  (
  `id` smallint(1) UNSIGNED NOT NULL AUTO_INCREMENT,
  `unit_id` tinyint(1) UNSIGNED NOT NULL,
  `sensor` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `adr` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `timestamp` datetime(0) NOT NULL,
  `sensor_name` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = Aria CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Page;

-- ----------------------------
-- Table structure for units_list
-- ----------------------------
DROP TABLE IF EXISTS `units_list`;
CREATE TABLE `units_list`  (
  `uNum` tinyint(1) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uName` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `Serial` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `AKey` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `OPid` tinyint(1) UNSIGNED NOT NULL,
  `x` float(10, 5) NOT NULL,
  `y` float(10, 5) NOT NULL,
  `IDob` tinyint(1) UNSIGNED NOT NULL,
  `remove` bit(1) NOT NULL,
  PRIMARY KEY (`uNum`) USING BTREE,
  UNIQUE INDEX `Units`(`uNum`, `uName`) USING BTREE
) ENGINE = Aria CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Page;

SET FOREIGN_KEY_CHECKS = 1;