Home Explore Help
Register Sign In
DataCollectionGroup
/
DataCollectionDevice
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 7896901760
Branches Tags
DataCollecti...
/
shucai.sql

shucai.sql 14 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167 
  1. -- Adminer 4.8.0 MySQL 5.7.26 dump
    2. 

  2. 

  3. SET NAMES utf8;
    4. 

  4. SET time_zone = '+00:00';
    5. 

  5. SET foreign_key_checks = 0;
    6. 

  6. SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
    7. 

  7. 

  8. CREATE DATABASE `shucai` /*!40100 DEFAULT CHARACTER SET utf8 */;
    9. 

  9. USE `shucai`;
    10. 

  10. 

  11. DROP TABLE IF EXISTS `command`;
    12. 

  12. CREATE TABLE `command` (
    13. 

  13.   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    14. 

  14.   `station_name` varchar(30) NOT NULL,
    15. 

  15.   `command` json NOT NULL,
    16. 

  16.   PRIMARY KEY (`id`)
    17. 

  17. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    18. 

  18. 

  19. 

  20. DROP TABLE IF EXISTS `data_point_tbl`;
    21. 

  21. CREATE TABLE `data_point_tbl` (
    22. 

  22.   `id` int(11) NOT NULL AUTO_INCREMENT,
    23. 

  23.   `station_name` varchar(120) DEFAULT NULL COMMENT '站点名称',
    24. 

  24.   `serial_number` int(11) DEFAULT NULL COMMENT '序列号',
    25. 

  25.   `device_id` varchar(20) DEFAULT NULL COMMENT '设备ID',
    26. 

  26.   `device_name` varchar(120) DEFAULT NULL COMMENT '设备名称',
    27. 

  27.   `io_point_name` varchar(120) DEFAULT NULL COMMENT 'IO点名称',
    28. 

  28.   `unit` varchar(120) DEFAULT NULL COMMENT '单位',
    29. 

  29.   `address` varchar(20) DEFAULT NULL COMMENT '地址',
    30. 

  30.   `data_type` varchar(20) DEFAULT NULL COMMENT '数据类型',
    31. 

  31.   `offset` float DEFAULT NULL COMMENT '偏移量',
    32. 

  32.   `divisor` float DEFAULT NULL COMMENT '除数',
    33. 

  33.   `decimal` int(11) DEFAULT NULL COMMENT '保留小数的位数',
    34. 

  34.   `storage_type` varchar(20) DEFAULT NULL COMMENT '存储类型',
    35. 

  35.   `low_limit` float DEFAULT NULL COMMENT '下限',
    36. 

  36.   `up_limit` float DEFAULT NULL COMMENT '上限',
    37. 

  37.   `alarm_low_limit` float DEFAULT NULL COMMENT '越下报警限',
    38. 

  38.   `alarm_up_limit` float DEFAULT NULL COMMENT '越上报警限',
    39. 

  39.   `negation` tinyint(4) DEFAULT NULL COMMENT '取反',
    40. 

  40.   `signal_type` enum('Switch','Analog') DEFAULT NULL COMMENT '开关量、模拟量',
    41. 

  41.   PRIMARY KEY (`id`)
    42. 

  42. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    43. 

  43. 

  44. INSERT INTO `data_point_tbl` (`id`, `station_name`, `serial_number`, `device_id`, `device_name`, `io_point_name`, `unit`, `address`, `data_type`, `offset`, `divisor`, `decimal`, `storage_type`, `low_limit`, `up_limit`, `alarm_low_limit`, `alarm_up_limit`, `negation`, `signal_type`) VALUES
    45. 

  45. (1,	'wxt536',	1,	'1',	'wxt536',	'风向',	'°',	'1',	NULL,	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    46. 

  46. (2,	'wxt536',	2,	'1',	'wxt536',	'风速',	'm/s',	'2',	NULL,	NULL,	NULL,	2,	'float',	0,	60,	0,	30,	NULL,	'Analog'),
    47. 

  47. (3,	'wxt536',	3,	'1',	'wxt536',	'气温',	'°C',	'3',	NULL,	NULL,	NULL,	2,	'float',	-30,	50,	0,	36,	NULL,	'Analog'),
    48. 

  48. (4,	'wxt536',	4,	'1',	'wxt536',	'相对湿度',	'%RH',	'4',	NULL,	NULL,	NULL,	2,	'float',	0,	100,	0,	1000,	NULL,	'Analog'),
    49. 

  49. (5,	'wxt536',	5,	'1',	'wxt536',	'气压',	'hPa',	'5',	NULL,	NULL,	NULL,	2,	'float',	600,	1300,	600,	1300,	NULL,	'Analog'),
    50. 

  50. (6,	'wxt536',	6,	'1',	'wxt536',	'日降雨量',	'mm',	'6',	NULL,	NULL,	NULL,	2,	'float',	0,	1000,	0,	1000,	NULL,	'Analog'),
    51. 

  51. (7,	'td266',	7,	'1',	'td266',	'流速',	'm/s',	'2',	NULL,	NULL,	100,	2,	'float',	0,	10,	0,	300,	NULL,	'Analog'),
    52. 

  52. (8,	'td266',	8,	'1',	'td266',	'流向',	'Deg.M',	'3',	NULL,	NULL,	NULL,	2,	'float',	0,	360,	0,	360,	NULL,	'Analog'),
    53. 

  53. (9,	'td266',	9,	'1',	'td266',	'艏向',	'Deg.M',	'6',	NULL,	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    54. 

  54. (10,	'td266',	10,	'1',	'td266',	'X轴姿态',	'Deg',	'7',	NULL,	NULL,	NULL,	2,	'float',	-45,	45,	NULL,	NULL,	NULL,	'Analog'),
    55. 

  55. (11,	'td266',	11,	'1',	'td266',	'Y轴姿态',	'Deg',	'8',	NULL,	NULL,	NULL,	2,	'float',	-45,	45,	NULL,	NULL,	NULL,	'Analog'),
    56. 

  56. (12,	'shuizhi',	12,	'1',	'shuizhi',	'溶解氧',	'mg/L',	'',	'',	NULL,	NULL,	2,	'float',	0,	100,	0,	100,	NULL,	'Analog'),
    57. 

  57. (13,	'shuizhi',	13,	'1',	'shuizhi',	'温度',	'°C',	'',	'',	NULL,	NULL,	2,	'float',	-5,	40,	-5,	40,	NULL,	'Analog'),
    58. 

  58. (14,	'shuizhi',	14,	'1',	'shuizhi',	'盐度',	'PSU',	'',	'',	NULL,	NULL,	2,	'float',	0,	100,	0,	100,	NULL,	'Analog'),
    59. 

  59. (15,	'shuizhi',	15,	'1',	'shuizhi',	'PH',	'',	'',	'',	NULL,	NULL,	2,	'float',	0,	14,	0,	14,	NULL,	'Analog'),
    60. 

  60. (16,	'shuizhi',	16,	'1',	'shuizhi',	'叶绿素',	'μg/L',	'',	'',	NULL,	NULL,	2,	'float',	0,	100,	0,	100,	NULL,	'Analog'),
    61. 

  61. (17,	'shuizhi',	17,	'1',	'shuizhi',	'深度',	'm',	'',	'',	NULL,	NULL,	2,	'float',	0,	100,	0,	100,	NULL,	'Analog'),
    62. 

  62. (18,	'adcp',	18,	'1',	'adcp',	'1m流速',	'm/s',	'1',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    63. 

  63. (19,	'adcp',	19,	'1',	'adcp',	'2m流速',	'm/s',	'2',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    64. 

  64. (20,	'adcp',	20,	'1',	'adcp',	'3m流速',	'm/s',	'3',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    65. 

  65. (21,	'adcp',	21,	'1',	'adcp',	'4m流速',	'm/s',	'4',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    66. 

  66. (22,	'adcp',	22,	'1',	'adcp',	'5m流速',	'm/s',	'5',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    67. 

  67. (23,	'adcp',	23,	'1',	'adcp',	'6m流速',	'm/s',	'6',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    68. 

  68. (24,	'adcp',	24,	'1',	'adcp',	'7m流速',	'm/s',	'7',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    69. 

  69. (25,	'adcp',	25,	'1',	'adcp',	'8m流速',	'm/s',	'8',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    70. 

  70. (26,	'adcp',	26,	'1',	'adcp',	'9m流速',	'm/s',	'9',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    71. 

  71. (27,	'adcp',	27,	'1',	'adcp',	'10m流速',	'm/s',	'10',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    72. 

  72. (28,	'adcp',	28,	'1',	'adcp',	'11m流速',	'm/s',	'11',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    73. 

  73. (29,	'adcp',	29,	'1',	'adcp',	'12m流速',	'm/s',	'12',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    74. 

  74. (30,	'adcp',	30,	'1',	'adcp',	'13m流速',	'm/s',	'13',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    75. 

  75. (31,	'adcp',	31,	'1',	'adcp',	'14m流速',	'm/s',	'14',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    76. 

  76. (32,	'adcp',	32,	'1',	'adcp',	'15m流速',	'm/s',	'15',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    77. 

  77. (33,	'adcp',	33,	'1',	'adcp',	'16m流速',	'm/s',	'16',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    78. 

  78. (34,	'adcp',	34,	'1',	'adcp',	'17m流速',	'm/s',	'17',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    79. 

  79. (35,	'adcp',	35,	'1',	'adcp',	'18m流速',	'm/s',	'18',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    80. 

  80. (36,	'adcp',	36,	'1',	'adcp',	'19m流速',	'm/s',	'19',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    81. 

  81. (37,	'adcp',	37,	'1',	'adcp',	'20m流速',	'm/s',	'20',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    82. 

  82. (38,	'adcp',	38,	'1',	'adcp',	'21m流速',	'm/s',	'21',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    83. 

  83. (39,	'adcp',	39,	'1',	'adcp',	'22m流速',	'm/s',	'22',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    84. 

  84. (40,	'adcp',	40,	'1',	'adcp',	'23m流速',	'm/s',	'23',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    85. 

  85. (41,	'adcp',	41,	'1',	'adcp',	'24m流速',	'm/s',	'24',	NULL,	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    86. 

  86. (42,	'adcp',	42,	'1',	'adcp',	'25m流速',	'm/s',	'25',	'',	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    87. 

  87. (43,	'adcp',	43,	'1',	'adcp',	'26m流速',	'm/s',	'26',	'',	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    88. 

  88. (44,	'adcp',	44,	'1',	'adcp',	'27m流速',	'm/s',	'27',	'',	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    89. 

  89. (45,	'adcp',	45,	'1',	'adcp',	'28m流速',	'm/s',	'28',	'',	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    90. 

  90. (46,	'adcp',	46,	'1',	'adcp',	'29m流速',	'm/s',	'29',	'',	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    91. 

  91. (47,	'adcp',	47,	'1',	'adcp',	'30m流速',	'm/s',	'30',	'',	NULL,	NULL,	2,	'float',	0,	5,	NULL,	NULL,	NULL,	'Analog'),
    92. 

  92. (48,	'adcp',	48,	'1',	'adcp',	'1m流向',	'°',	'31',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    93. 

  93. (49,	'adcp',	49,	'1',	'adcp',	'2m流向',	'°',	'32',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    94. 

  94. (50,	'adcp',	50,	'1',	'adcp',	'3m流向',	'°',	'33',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    95. 

  95. (51,	'adcp',	51,	'1',	'adcp',	'4m流向',	'°',	'34',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    96. 

  96. (52,	'adcp',	52,	'1',	'adcp',	'5m流向',	'°',	'35',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    97. 

  97. (53,	'adcp',	53,	'1',	'adcp',	'6m流向',	'°',	'36',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    98. 

  98. (54,	'adcp',	54,	'1',	'adcp',	'7m流向',	'°',	'37',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    99. 

  99. (55,	'adcp',	55,	'1',	'adcp',	'8m流向',	'°',	'38',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    100. 

  100. (56,	'adcp',	56,	'1',	'adcp',	'9m流向',	'°',	'39',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    101. 

  101. (57,	'adcp',	57,	'1',	'adcp',	'10流向',	'°',	'40',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    102. 

  102. (58,	'adcp',	58,	'1',	'adcp',	'11流向',	'°',	'41',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    103. 

  103. (59,	'adcp',	59,	'1',	'adcp',	'12流向',	'°',	'42',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    104. 

  104. (60,	'adcp',	60,	'1',	'adcp',	'13流向',	'°',	'43',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    105. 

  105. (61,	'adcp',	61,	'1',	'adcp',	'14流向',	'°',	'44',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    106. 

  106. (62,	'adcp',	62,	'1',	'adcp',	'15流向',	'°',	'45',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    107. 

  107. (63,	'adcp',	63,	'1',	'adcp',	'16流向',	'°',	'46',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    108. 

  108. (64,	'adcp',	64,	'1',	'adcp',	'17流向',	'°',	'47',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    109. 

  109. (65,	'adcp',	65,	'1',	'adcp',	'18流向',	'°',	'48',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    110. 

  110. (66,	'adcp',	66,	'1',	'adcp',	'19流向',	'°',	'49',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    111. 

  111. (67,	'adcp',	67,	'1',	'adcp',	'20流向',	'°',	'50',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    112. 

  112. (68,	'adcp',	68,	'1',	'adcp',	'21流向',	'°',	'51',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    113. 

  113. (69,	'adcp',	69,	'1',	'adcp',	'22流向',	'°',	'52',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    114. 

  114. (70,	'adcp',	70,	'1',	'adcp',	'23流向',	'°',	'53',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    115. 

  115. (71,	'adcp',	71,	'1',	'adcp',	'24流向',	'°',	'54',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    116. 

  116. (72,	'adcp',	72,	'1',	'adcp',	'25流向',	'°',	'55',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    117. 

  117. (73,	'adcp',	73,	'1',	'adcp',	'26流向',	'°',	'56',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    118. 

  118. (74,	'adcp',	74,	'1',	'adcp',	'27流向',	'°',	'57',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    119. 

  119. (75,	'adcp',	75,	'1',	'adcp',	'28流向',	'°',	'58',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    120. 

  120. (76,	'adcp',	76,	'1',	'adcp',	'29流向',	'°',	'59',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    121. 

  121. (77,	'adcp',	77,	'1',	'adcp',	'30流向',	'°',	'60',	'',	NULL,	NULL,	2,	'float',	0,	360,	NULL,	NULL,	NULL,	'Analog'),
    122. 

  122. (78,	'sm140',	78,	'1',	'sm140',	'有效波高',	'm',	'8',	'',	NULL,	NULL,	2,	'float',	0,	50,	0,	50,	NULL,	'Analog'),
    123. 

  123. (79,	'sm140',	79,	'1',	'sm140',	'最大波高',	'm',	'10',	'',	NULL,	NULL,	2,	'float',	0,	50,	0,	50,	NULL,	'Analog'),
    124. 

  124. (81,	'sm140',	81,	'1',	'sm140',	'有效波周期',	's',	'20',	'',	NULL,	NULL,	2,	'float',	0,	100,	0,	100,	NULL,	'Analog'),
    125. 

  125. (82,	'sm140',	82,	'1',	'sm140',	'平均波周期',	's',	'28',	'',	NULL,	NULL,	2,	'float',	0,	100,	0,	100,	NULL,	'Analog'),
    126. 

  126. (83,	'sm140',	83,	'1',	'sm140',	'最大波周期',	's',	'30',	'',	NULL,	NULL,	2,	'float',	0,	100,	0,	100,	NULL,	'Analog'),
    127. 

  127. (84,	'sm140',	84,	'1',	'sm140',	'最大波高的波周期',	's',	'32',	'',	NULL,	NULL,	2,	'float',	0,	100,	0,	100,	NULL,	'Analog');
    128. 

  128. 

  129. DROP TABLE IF EXISTS `shuizhi_insitu_instruct`;
    130. 

  130. CREATE TABLE `shuizhi_insitu_instruct` (
    131. 

  131.   `parameter_id` int(6) NOT NULL COMMENT 'id，用于判断是哪个参数',
    132. 

  132.   `name` varchar(10) CHARACTER SET utf8 NOT NULL COMMENT '参数名称',
    133. 

  133.   `units_id` int(6) DEFAULT NULL COMMENT '单位id，判断单位值',
    134. 

  134.   `station_code` varchar(8) CHARACTER SET utf8 NOT NULL COMMENT '站号',
    135. 

  135.   `function_code` varchar(8) CHARACTER SET utf8 NOT NULL COMMENT '功能码',
    136. 

  136.   `address` int(6) NOT NULL COMMENT '寄存器的位置'
    137. 

  137. ) ENGINE=InnoDB DEFAULT CHARSET=utf16 COMMENT='读取水质参数，组合In-situ发送指令';
    138. 

  138. 

  139. INSERT INTO `shuizhi_insitu_instruct` (`parameter_id`, `name`, `units_id`, `station_code`, `function_code`, `address`) VALUES
    140. 

  140. (3,	'深度',	NULL,	'01',	'03',	5464),
    141. 

  141. (12,	'盐度',	NULL,	'01',	'03',	5527),
    142. 

  142. (17,	'PH',	NULL,	'01',	'03',	5562),
    143. 

  143. (51,	'叶绿素',	NULL,	'01',	'03',	5800),
    144. 

  144. (1,	'温度',	NULL,	'01',	'03',	5450),
    145. 

  145. (20,	'溶解氧',	NULL,	'01',	'03',	5583);
    146. 

  146. 

  147. DROP TABLE IF EXISTS `station_info_tbl`;
    148. 

  148. CREATE TABLE `station_info_tbl` (
    149. 

  149.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    150. 

  150.   `station_name` varchar(120) NOT NULL,
    151. 

  151.   `connector_module` varchar(120) NOT NULL,
    152. 

  152.   `connector` varchar(120) NOT NULL,
    153. 

  153.   `connector_config` json NOT NULL,
    154. 

  154.   `converter_module` varchar(120) NOT NULL,
    155. 

  155.   `converter` varchar(120) NOT NULL,
    156. 

  156.   `status` tinyint(4) DEFAULT NULL,
    157. 

  157.   PRIMARY KEY (`id`)
    158. 

  158. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    159. 

  159. 

  160. INSERT INTO `station_info_tbl` (`id`, `station_name`, `connector_module`, `connector`, `connector_config`, `converter_module`, `converter`, `status`) VALUES
    161. 

  161. (1,	'wxt536',	'tcp_connector',	'TcpConnector',	'{\"ip\": \"192.168.1.84\", \"port\": 4001, \"save_frequency\": 5, \"alarm_save_frequency\": 15}',	'wxt536_converter',	'WXT536Converter',	1),
    162. 

  162. (2,	'sm140',	'tcp_connector',	'TcpConnector',	'{\"ip\": \"192.168.1.83\", \"port\": 4001, \"save_frequency\": 5, \"alarm_save_frequency\": 15}',	'nmea0183_converter',	'NEMA0183Converter',	1),
    163. 

  163. (3,	'td266',	'tcp_connector',	'TcpConnector',	'{\"ip\": \"192.168.1.89\", \"port\": 4001, \"save_frequency\": 180, \"alarm_save_frequency\": 15}',	'td266_converter',	'TD266Converter',	1),
    164. 

  164. (4,	'adcp',	'tcp_connector',	'TcpConnector',	'{\"ip\": \"192.168.1.252\", \"port\": 4001, \"save_frequency\": 180, \"alarm_save_frequency\": 15}',	'adcp_converter',	'AdcpConverter',	1),
    165. 

  165. (5,	'shuizhi',	'shuizhi_tcp_connector',	'ShuizhiTcpConnector',	'{\"ip\": \"192.168.1.254\", \"port\": 4001, \"save_frequency\": 5, \"alarm_save_frequency\": 15}',	'shuizhi_converter',	'ShuizhiConverter',	1);
    166. 

  166. 

  167. -- 2022-07-19 03:10:34
    168.