i could now reproduce it:
1) use 1.3.176 and execute users.sql and after that alarm_history.sql
2) shutdown and restart with 1.4.192 and try to execute "DELETE FROM
ALARM_HISTORY"
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_A40B4853_4C20_40CE_B986_96E85710FA14 START WITH 4313 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_31C25C75_0444_4E96_B4AD_A76F37B6F530 START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_DB99439B_4645_4975_9020_460C177CF416 START WITH 3 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_D37CF440_0056_4986_858A_859A1A43C371 START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_8642E227_AB5A_410E_B001_51807AFAEBC9 START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_39DC9DAB_FBB1_4D31_B2D0_4D01DCC9CE8F START WITH 3 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_D77536D8_1D9D_4A74_85E8_E2AAEAD73B6C START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_A0E85635_D4F1_4BDF_85EC_3064FCFD87D7 START WITH 5 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_0830A18F_32F5_4944_B326_EA286D1261C6 START WITH 33 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_161FF4F4_AEB2_443D_BE77_3144FEA308CE START WITH 2 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_B9CBD0A8_0FB8_4D3F_8897_2A637DA263D1 START WITH 142 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_ABD3B446_F282_4800_AFDC_456A6ED02924 START WITH 1245 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_10E65B4C_829E_4441_AC46_3363DD74A88C START WITH 33 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_94E5DDB9_029E_420D_AEE3_46FE93553FEF START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_4AAF70BE_E066_4205_8742_29F52E084E5B START WITH 5 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_AC791833_B12F_4F5B_AB8C_872A5DED5B9A START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_B6CB98C7_DFCF_4389_BD38_1C903D83537C START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_7AC91E0F_78F8_4486_BE14_E88B31309B86 START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_2EC60EB2_12A3_47AE_8766_701CCD320A4E START WITH 689 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_FBF2D857_249F_4931_9524_122E8B426730 START WITH 5 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_7F917534_FD5F_4E62_8AEA_0AF1AEEFAC2F START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_C2F320EC_F67F_4607_973A_32FCD6DA716F START WITH 33 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_F10ABB9E_2A0B_48D5_8E10_005224FE1255 START WITH 8165 BELONGS_TO_TABLE;
CREATE CACHED TABLE PUBLIC.ALARM_HISTORY(
ID INT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_F10ABB9E_2A0B_48D5_8E10_005224FE1255) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_F10ABB9E_2A0B_48D5_8E10_005224FE1255 SELECTIVITY 100,
ACCOUNT INTEGER NOT NULL SELECTIVITY 1,
UNIT TINYINT NOT NULL SELECTIVITY 1,
UNITSTRING VARCHAR(1024) NOT NULL SELECTIVITY 7,
ADDR INTEGER NOT NULL SELECTIVITY 5,
ADDRSTRING VARCHAR(1024) NOT NULL SELECTIVITY 5,
ALARMTYPE INTEGER NOT NULL SELECTIVITY 1,
SEVERITY TINYINT NOT NULL SELECTIVITY 1,
ALARMTEXT VARCHAR(1024) NOT NULL SELECTIVITY 1,
ALARMDATE TIMESTAMP SELECTIVITY 10
);
ALTER TABLE PUBLIC.ALARM_HISTORY ADD CONSTRAINT PUBLIC.PK_ALARM_HISTORY PRIMARY KEY(ID);
-- 534 +/- SELECT COUNT(*) FROM PUBLIC.ALARM_HISTORY;
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(7631, 0, 82, 'RU 144/2', 145, '144/2', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 07:37:02.286'),
(7632, 1, 82, 'RU 144/2', 145, '144/2', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 07:37:02.302'),
(7633, 0, 77, 'MU OTRX 144', 144, '144', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 07:37:03.285'),
(7634, 1, 77, 'MU OTRX 144', 144, '144', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 07:37:03.3'),
(7635, 0, 82, 'RU 144/1', 144, '144/1', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 07:37:04.158'),
(7636, 1, 82, 'RU 144/1', 144, '144/1', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 07:37:04.174'),
(7637, 0, 82, 'RU 5', 5, '5', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:19:59.432'),
(7638, 1, 82, 'RU 5', 5, '5', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:19:59.463'),
(7639, 0, 77, 'MU OTRX 5', 5, '5', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:20:00.134'),
(7640, 1, 77, 'MU OTRX 5', 5, '5', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:20:00.149'),
(7641, 0, 87, 'MC 0', 0, '0', 1, 1, 'O&M Communication Failure', TIMESTAMP '2016-09-02 09:20:12.817'),
(7642, 1, 87, 'MC 0', 0, '0', 1, 1, 'O&M Communication Failure', TIMESTAMP '2016-09-02 09:20:12.832'),
(7643, 0, 77, 'MU OTRX 5', 5, '5', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:20:12.895'),
(7644, 1, 77, 'MU OTRX 5', 5, '5', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:20:12.91'),
(7645, 0, 82, 'RU 5', 5, '5', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:20:12.957'),
(7646, 1, 82, 'RU 5', 5, '5', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:20:12.973'),
(7647, 0, 87, 'MC 0', 0, '0', 0, 1, 'O&M Communication Failure', TIMESTAMP '2016-09-02 09:20:18.869'),
(7648, 1, 87, 'MC 0', 0, '0', 0, 1, 'O&M Communication Failure', TIMESTAMP '2016-09-02 09:20:18.885'),
(7649, 0, 77, 'MU OTRX 5', 5, '5', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:20:18.932'),
(7650, 1, 77, 'MU OTRX 5', 5, '5', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:20:18.947'),
(7651, 0, 82, 'RU 5', 5, '5', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:20:23.145'),
(7652, 1, 82, 'RU 5', 5, '5', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:20:23.176'),
(7653, 0, 83, 'SAB 1', 1, '1', 1, 1, 'External 1 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:35.911'),
(7654, 1, 83, 'SAB 1', 1, '1', 1, 1, 'External 1 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:35.942'),
(7655, 0, 83, 'SAB 1', 1, '1', 1, 1, 'External 2 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:35.973'),
(7656, 1, 83, 'SAB 1', 1, '1', 1, 1, 'External 2 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:35.004'),
(7657, 0, 83, 'SAB 1', 1, '1', 1, 1, 'External 3 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.035'),
(7658, 1, 83, 'SAB 1', 1, '1', 1, 1, 'External 3 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.051'),
(7659, 0, 83, 'SAB 1', 1, '1', 1, 1, 'External 4 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.098'),
(7660, 1, 83, 'SAB 1', 1, '1', 1, 1, 'External 4 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.113'),
(7661, 0, 83, 'SAB 1', 1, '1', 1, 1, 'External 5 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.145'),
(7662, 1, 83, 'SAB 1', 1, '1', 1, 1, 'External 5 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.176'),
(7663, 0, 83, 'SAB 1', 1, '1', 1, 1, 'External 6 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.207'),
(7664, 1, 83, 'SAB 1', 1, '1', 1, 1, 'External 6 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.238'),
(7665, 0, 83, 'SAB 1', 1, '1', 1, 1, 'External 7 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.285'),
(7666, 1, 83, 'SAB 1', 1, '1', 1, 1, 'External 7 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.301'),
(7667, 0, 83, 'SAB 1', 1, '1', 1, 1, 'External 8 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.347'),
(7668, 1, 83, 'SAB 1', 1, '1', 1, 1, 'External 8 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.363'),
(7669, 0, 83, 'SAB 7', 7, '7', 1, 1, 'External 1 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.488');
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(7670, 1, 83, 'SAB 7', 7, '7', 1, 1, 'External 1 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.503'),
(7671, 0, 83, 'SAB 7', 7, '7', 1, 1, 'External 2 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.55'),
(7672, 1, 83, 'SAB 7', 7, '7', 1, 1, 'External 2 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.566'),
(7673, 0, 83, 'SAB 7', 7, '7', 1, 1, 'External 3 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.597'),
(7674, 1, 83, 'SAB 7', 7, '7', 1, 1, 'External 3 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.613'),
(7675, 0, 83, 'SAB 7', 7, '7', 1, 1, 'External 4 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.659'),
(7676, 1, 83, 'SAB 7', 7, '7', 1, 1, 'External 4 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.691'),
(7677, 0, 83, 'SAB 7', 7, '7', 1, 1, 'External 5 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.722'),
(7678, 1, 83, 'SAB 7', 7, '7', 1, 1, 'External 5 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.737'),
(7679, 0, 83, 'SAB 7', 7, '7', 1, 1, 'External 6 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.784'),
(7680, 1, 83, 'SAB 7', 7, '7', 1, 1, 'External 6 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.8'),
(7681, 0, 83, 'SAB 7', 7, '7', 1, 1, 'External 7 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.831'),
(7682, 1, 83, 'SAB 7', 7, '7', 1, 1, 'External 7 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.862'),
(7683, 0, 83, 'SAB 7', 7, '7', 1, 1, 'External 8 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.893'),
(7684, 1, 83, 'SAB 7', 7, '7', 1, 1, 'External 8 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.909'),
(7685, 0, 65, 'PDU 1', 1, '1', 1, 2, 'Rack Supervision Alarm ({UserText})', TIMESTAMP '2016-09-02 09:45:37.143'),
(7686, 1, 65, 'PDU 1', 1, '1', 1, 2, 'Rack Supervision Alarm ({UserText})', TIMESTAMP '2016-09-02 09:45:37.174'),
(7687, 0, 65, 'PDU 1', 1, '1', 1, 1, 'Temperature Alarm', TIMESTAMP '2016-09-02 09:45:37.237'),
(7688, 1, 65, 'PDU 1', 1, '1', 1, 1, 'Temperature Alarm', TIMESTAMP '2016-09-02 09:45:37.252'),
(7689, 0, 65, 'PSDU 9', 9, '9', 1, 1, 'Temperature Alarm', TIMESTAMP '2016-09-02 09:45:37.627'),
(7690, 1, 65, 'PSDU 9', 9, '9', 1, 1, 'Temperature Alarm', TIMESTAMP '2016-09-02 09:45:37.658'),
(7691, 0, 79, 'SR 5 POI 1', 33, '33', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:38.531'),
(7692, 1, 79, 'SR 5 POI 1', 33, '33', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:38.547'),
(7693, 0, 79, 'SR 5 POI 2', 34, '34', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:38.703'),
(7694, 1, 79, 'SR 5 POI 2', 34, '34', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:38.719'),
(7695, 0, 79, 'SR 5 POI 3', 35, '35', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:38.812'),
(7696, 1, 79, 'SR 5 POI 3', 35, '35', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:38.828'),
(7697, 0, 79, 'SR 5 POI 4', 36, '36', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:38.921'),
(7698, 1, 79, 'SR 5 POI 4', 36, '36', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:38.937'),
(7699, 0, 79, 'SR 5 POI 5', 37, '37', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:39.031'),
(7700, 1, 79, 'SR 5 POI 5', 37, '37', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:39.046'),
(7701, 0, 79, 'SR 5 POI 6', 38, '38', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:39.124'),
(7702, 1, 79, 'SR 5 POI 6', 38, '38', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:39.14'),
(7703, 0, 79, 'SR 6 POI 2', 42, '42', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:39.233');
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(7704, 1, 79, 'SR 6 POI 2', 42, '42', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:39.265'),
(7705, 0, 79, 'SR 6 POI 3', 43, '43', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:39.374'),
(7706, 1, 79, 'SR 6 POI 3', 43, '43', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:39.389'),
(7707, 0, 79, 'SR 6 POI 6', 46, '46', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:39.53'),
(7708, 1, 79, 'SR 6 POI 6', 46, '46', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:39.545'),
(7709, 0, 79, 'SR 6 POI 6', 46, '46', 1, 1, 'Fan 1 Failure', TIMESTAMP '2016-09-02 09:45:39.592'),
(7710, 1, 79, 'SR 6 POI 6', 46, '46', 1, 1, 'Fan 1 Failure', TIMESTAMP '2016-09-02 09:45:39.608'),
(7711, 0, 79, 'SR 8 POI 1', 57, '57', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1', TIMESTAMP '2016-09-02 09:45:40.076'),
(7712, 1, 79, 'SR 8 POI 1', 57, '57', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1', TIMESTAMP '2016-09-02 09:45:40.091'),
(7713, 0, 79, 'SR 8 POI 1', 57, '57', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 2', TIMESTAMP '2016-09-02 09:45:40.123'),
(7714, 1, 79, 'SR 8 POI 1', 57, '57', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 2', TIMESTAMP '2016-09-02 09:45:40.138'),
(7715, 0, 79, 'SR 8 POI 2', 58, '58', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1', TIMESTAMP '2016-09-02 09:45:40.279'),
(7716, 1, 79, 'SR 8 POI 2', 58, '58', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1', TIMESTAMP '2016-09-02 09:45:40.279'),
(7717, 0, 79, 'SR 8 POI 2', 58, '58', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 2', TIMESTAMP '2016-09-02 09:45:40.325'),
(7718, 1, 79, 'SR 8 POI 2', 58, '58', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 2', TIMESTAMP '2016-09-02 09:45:40.325'),
(7719, 0, 79, 'SR 8 POI 3', 59, '59', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1', TIMESTAMP '2016-09-02 09:45:40.45'),
(7720, 1, 79, 'SR 8 POI 3', 59, '59', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1', TIMESTAMP '2016-09-02 09:45:40.466'),
(7721, 0, 79, 'SR 8 POI 3', 59, '59', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 2', TIMESTAMP '2016-09-02 09:45:40.497'),
(7722, 1, 79, 'SR 8 POI 3', 59, '59', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 2', TIMESTAMP '2016-09-02 09:45:40.513'),
(7723, 0, 79, 'SR 8 POI 6', 62, '62', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:40.637'),
(7724, 1, 79, 'SR 8 POI 6', 62, '62', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:40.653'),
(7725, 0, 79, 'SR 10 POI 7', 79, '79', 1, 4, 'Power On Reset', TIMESTAMP '2016-09-02 09:45:41.261'),
(7726, 1, 79, 'SR 10 POI 7', 79, '79', 1, 4, 'Power On Reset', TIMESTAMP '2016-09-02 09:45:41.277'),
(7727, 0, 79, 'SR 10 POI 8', 80, '80', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1', TIMESTAMP '2016-09-02 09:45:41.355'),
(7728, 1, 79, 'SR 10 POI 8', 80, '80', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1', TIMESTAMP '2016-09-02 09:45:41.371'),
(7729, 0, 79, 'SR 10 POI 8', 80, '80', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 2', TIMESTAMP '2016-09-02 09:45:41.386'),
(7730, 1, 79, 'SR 10 POI 8', 80, '80', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 2', TIMESTAMP '2016-09-02 09:45:41.402'),
(7731, 0, 79, 'SR 10 POI 8', 80, '80', 1, 4, 'Power On Reset', TIMESTAMP '2016-09-02 09:45:41.433'),
(7732, 1, 79, 'SR 10 POI 8', 80, '80', 1, 4, 'Power On Reset', TIMESTAMP '2016-09-02 09:45:41.449'),
(7733, 0, 79, 'SR 11 POI 3', 83, '83', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:41.542'),
(7734, 1, 79, 'SR 11 POI 3', 83, '83', 1, 1, 'RF Input Power Minimum Threshold Alarm Port 1/2', TIMESTAMP '2016-09-02 09:45:41.542'),
(7735, 0, 77, 'MU OTRX 240/1', 240, '240/1', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:45:50.699');
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(7736, 1, 77, 'MU OTRX 240/1', 240, '240/1', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:45:50.715'),
(7737, 0, 79, 'SR 10 POI 7', 79, '79', 0, 4, 'Power On Reset', TIMESTAMP '2016-09-02 09:45:54.35'),
(7738, 1, 79, 'SR 10 POI 7', 79, '79', 0, 4, 'Power On Reset', TIMESTAMP '2016-09-02 09:45:54.365'),
(7739, 0, 79, 'SR 10 POI 8', 80, '80', 0, 4, 'Power On Reset', TIMESTAMP '2016-09-02 09:45:54.459'),
(7740, 1, 79, 'SR 10 POI 8', 80, '80', 0, 4, 'Power On Reset', TIMESTAMP '2016-09-02 09:45:54.459'),
(7741, 0, 77, 'MU OTRX 6', 6, '6', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:00.247'),
(7742, 1, 77, 'MU OTRX 6', 6, '6', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:00.278'),
(7743, 0, 53, 'TETRA400-IPP 15', 15, '15', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:00.98'),
(7744, 1, 53, 'TETRA400-IPP 15', 15, '15', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:00.995'),
(7745, 0, 52, 'TETRA800-IPP 15', 15, '15', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:01.042'),
(7746, 1, 52, 'TETRA800-IPP 15', 15, '15', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:01.058'),
(7747, 0, 77, 'MU OTRX 15', 15, '15', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:01.245'),
(7748, 1, 77, 'MU OTRX 15', 15, '15', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:01.276'),
(7749, 0, 82, 'RU 15', 15, '15', 1, 1, 'Door 1 Open', TIMESTAMP '2016-09-02 09:46:01.432'),
(7750, 1, 82, 'RU 15', 15, '15', 1, 1, 'Door 1 Open', TIMESTAMP '2016-09-02 09:46:01.448'),
(7751, 0, 82, 'RU 15', 15, '15', 1, 1, 'Fibre Optic UL Current', TIMESTAMP '2016-09-02 09:46:01.495'),
(7752, 1, 82, 'RU 15', 15, '15', 1, 1, 'Fibre Optic UL Current', TIMESTAMP '2016-09-02 09:46:01.51'),
(7753, 0, 82, 'RU 15', 15, '15', 1, 1, 'Fibre Optic DL Current', TIMESTAMP '2016-09-02 09:46:01.557'),
(7754, 1, 82, 'RU 15', 15, '15', 1, 1, 'Fibre Optic DL Current', TIMESTAMP '2016-09-02 09:46:01.573'),
(7755, 0, 82, 'RU 15', 15, '15', 1, 1, 'VSWR Alarm', TIMESTAMP '2016-09-02 09:46:01.635'),
(7756, 1, 82, 'RU 15', 15, '15', 1, 1, 'VSWR Alarm', TIMESTAMP '2016-09-02 09:46:01.651'),
(7757, 0, 82, 'RU 15', 15, '15', 1, 4, 'Redundancy Switch', TIMESTAMP '2016-09-02 09:46:01.682'),
(7758, 1, 82, 'RU 15', 15, '15', 1, 4, 'Redundancy Switch', TIMESTAMP '2016-09-02 09:46:01.697'),
(7759, 0, 82, 'RU 15', 15, '15', 1, 1, 'Redundancy Switch Failed', TIMESTAMP '2016-09-02 09:46:01.729'),
(7760, 1, 82, 'RU 15', 15, '15', 1, 1, 'Redundancy Switch Failed', TIMESTAMP '2016-09-02 09:46:01.744'),
(7761, 0, 82, 'RU 15', 15, '15', 0, 4, 'External 1 Output ({NoUserText})', TIMESTAMP '2016-09-02 09:46:02.181'),
(7762, 1, 82, 'RU 15', 15, '15', 0, 4, 'External 1 Output ({NoUserText})', TIMESTAMP '2016-09-02 09:46:02.197'),
(7763, 0, 82, 'RU 24', 24, '24', 1, 4, 'Amplifier 1 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:03.101'),
(7764, 1, 82, 'RU 24', 24, '24', 1, 4, 'Amplifier 1 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:03.133'),
(7765, 0, 77, 'MU OTRX 30', 30, '30', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:04.287'),
(7766, 1, 77, 'MU OTRX 30', 30, '30', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:04.303'),
(7767, 0, 77, 'MU OTRX 30', 30, '30', 1, 1, 'ConvMod 2 Communication Failure', TIMESTAMP '2016-09-02 09:46:04.334'),
(7768, 1, 77, 'MU OTRX 30', 30, '30', 1, 1, 'ConvMod 2 Communication Failure', TIMESTAMP '2016-09-02 09:46:04.349'),
(7769, 0, 77, 'MU OTRX 41', 41, '41', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:04.817'),
(7770, 1, 77, 'MU OTRX 41', 41, '41', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:04.833'),
(7771, 0, 77, 'MU OTRX 41', 41, '41', 1, 1, 'ConvMod 2 Communication Failure', TIMESTAMP '2016-09-02 09:46:04.864'),
(7772, 1, 77, 'MU OTRX 41', 41, '41', 1, 1, 'ConvMod 2 Communication Failure', TIMESTAMP '2016-09-02 09:46:04.88'),
(7773, 0, 82, 'RU 41', 41, '41', 1, 1, 'Bus I2C Failure', TIMESTAMP '2016-09-02 09:46:04.989');
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(7774, 1, 82, 'RU 41', 41, '41', 1, 1, 'Bus I2C Failure', TIMESTAMP '2016-09-02 09:46:04.005'),
(7775, 0, 82, 'RU 41', 41, '41', 1, 1, 'External 1 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:46:05.036'),
(7776, 1, 82, 'RU 41', 41, '41', 1, 1, 'External 1 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:46:05.067'),
(7777, 0, 82, 'RU 41', 41, '41', 1, 4, 'Amplifier 2 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:05.192'),
(7778, 1, 82, 'RU 41', 41, '41', 1, 4, 'Amplifier 2 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:05.207'),
(7779, 0, 82, 'RU 41', 41, '41', 1, 4, 'Amplifier 2 DL 900MHz RMS level low', TIMESTAMP '2016-09-02 09:46:05.27'),
(7780, 1, 82, 'RU 41', 41, '41', 1, 4, 'Amplifier 2 DL 900MHz RMS level low', TIMESTAMP '2016-09-02 09:46:05.285'),
(7781, 0, 82, 'RU 41', 41, '41', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:05.317'),
(7782, 1, 82, 'RU 41', 41, '41', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:05.348'),
(7783, 0, 82, 'MU OTRX 41', 41, '41', 1, 1, 'ConvMod 2 Communication Failure', TIMESTAMP '2016-09-02 09:46:05.379'),
(7784, 1, 82, 'MU OTRX 41', 41, '41', 1, 1, 'ConvMod 2 Communication Failure', TIMESTAMP '2016-09-02 09:46:05.395'),
(7785, 0, 77, 'MU OTRX 42', 42, '42', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:05.925'),
(7786, 1, 77, 'MU OTRX 42', 42, '42', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:05.941'),
(7787, 0, 77, 'MU OTRX 64', 64, '64', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:06.175'),
(7788, 1, 77, 'MU OTRX 64', 64, '64', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:06.19'),
(7789, 0, 77, 'MU OTRX 71', 71, '71', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:06.877'),
(7790, 1, 77, 'MU OTRX 71', 71, '71', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:06.892'),
(7791, 0, 82, 'RU 88', 88, '88', 1, 1, 'Bus I2C Failure', TIMESTAMP '2016-09-02 09:46:07.391'),
(7792, 1, 82, 'RU 88', 88, '88', 1, 1, 'Bus I2C Failure', TIMESTAMP '2016-09-02 09:46:07.407'),
(7793, 0, 82, 'RU 88', 88, '88', 1, 4, 'Amplifier 3 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:07.579'),
(7794, 1, 82, 'RU 88', 88, '88', 1, 4, 'Amplifier 3 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:07.594'),
(7795, 0, 82, 'RU 88', 88, '88', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:07.625'),
(7796, 1, 82, 'RU 88', 88, '88', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:07.641'),
(7797, 0, 82, 'MU OTRX 88', 88, '88', 1, 1, 'ConvMod 2 Communication Failure', TIMESTAMP '2016-09-02 09:46:07.672'),
(7798, 1, 82, 'MU OTRX 88', 88, '88', 1, 1, 'ConvMod 2 Communication Failure', TIMESTAMP '2016-09-02 09:46:07.688'),
(7799, 0, 82, 'RU 88', 88, '88', 1, 4, 'Amplifier 1 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:07.719'),
(7800, 1, 82, 'RU 88', 88, '88', 1, 4, 'Amplifier 1 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:07.735'),
(7801, 0, 67, 'EU 88-1', 88, '88', 1, 1, 'Bus I2C Failure', TIMESTAMP '2016-09-02 09:46:08.359'),
(7802, 1, 67, 'EU 88-1', 88, '88', 1, 1, 'Bus I2C Failure', TIMESTAMP '2016-09-02 09:46:08.374'),
(7803, 0, 67, 'EU 88-1', 88, '88', 1, 1, 'ConvMod 1 DL LO level too low', TIMESTAMP '2016-09-02 09:46:08.53'),
(7804, 1, 67, 'EU 88-1', 88, '88', 1, 1, 'ConvMod 1 DL LO level too low', TIMESTAMP '2016-09-02 09:46:08.546'),
(7805, 0, 67, 'EU 88-1', 88, '88', 1, 4, 'Amplifier 2 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:08.577'),
(7806, 1, 67, 'EU 88-1', 88, '88', 1, 4, 'Amplifier 2 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:08.593'),
(7807, 0, 77, 'MU OTRX 124', 124, '124', 1, 1, 'Fibre Optic UL Current', TIMESTAMP '2016-09-02 09:46:08.764'),
(7808, 1, 77, 'MU OTRX 124', 124, '124', 1, 1, 'Fibre Optic UL Current', TIMESTAMP '2016-09-02 09:46:08.78'),
(7809, 0, 77, 'MU OTRX 124', 124, '124', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:08.811'),
(7810, 1, 77, 'MU OTRX 124', 124, '124', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:08.842');
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(7811, 0, 77, 'MU OTRX 128', 128, '128', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:09.123'),
(7812, 1, 77, 'MU OTRX 128', 128, '128', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:09.139'),
(7813, 0, 77, 'MU OTRX 132/1', 132, '132/1', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:10.028'),
(7814, 1, 77, 'MU OTRX 132/1', 132, '132/1', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:10.043'),
(7815, 0, 53, 'TETRA400-IPP 136', 136, '136', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:10.636'),
(7816, 1, 53, 'TETRA400-IPP 136', 136, '136', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:10.652'),
(7817, 0, 52, 'TETRA800-IPP 136', 136, '136', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:10.683'),
(7818, 1, 52, 'TETRA800-IPP 136', 136, '136', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:10.699'),
(7819, 0, 49, 'UMTS-IPP 136', 136, '136', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:10.73'),
(7820, 1, 49, 'UMTS-IPP 136', 136, '136', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:10.745'),
(7821, 0, 50, 'GSM1800-IPP 136', 136, '136', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:10.777'),
(7822, 1, 50, 'GSM1800-IPP 136', 136, '136', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:10.792'),
(7823, 0, 51, 'GSM900-IPP 136', 136, '136', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:10.823'),
(7824, 1, 51, 'GSM900-IPP 136', 136, '136', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:10.839'),
(7825, 0, 77, 'MU OTRX 136/1', 136, '136/1', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:10.011'),
(7826, 1, 77, 'MU OTRX 136/1', 136, '136/1', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:10.026'),
(7827, 0, 77, 'MU OTRX 136/1', 136, '136/1', 1, 1, 'ConvMod 2 Communication Failure', TIMESTAMP '2016-09-02 09:46:11.042'),
(7828, 1, 77, 'MU OTRX 136/1', 136, '136/1', 1, 1, 'ConvMod 2 Communication Failure', TIMESTAMP '2016-09-02 09:46:11.057'),
(7829, 0, 82, 'RU 136/2', 137, '136/2', 1, 1, 'Bus I2C Failure', TIMESTAMP '2016-09-02 09:46:11.213'),
(7830, 1, 82, 'RU 136/2', 137, '136/2', 1, 1, 'Bus I2C Failure', TIMESTAMP '2016-09-02 09:46:11.229'),
(7831, 0, 82, 'RU 136/2', 137, '136/2', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:11.401'),
(7832, 1, 82, 'RU 136/2', 137, '136/2', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:11.416'),
(7833, 0, 82, 'MU OTRX 136/2', 137, '136/2', 1, 1, 'ConvMod 2 Communication Failure', TIMESTAMP '2016-09-02 09:46:11.447'),
(7834, 1, 82, 'MU OTRX 136/2', 137, '136/2', 1, 1, 'ConvMod 2 Communication Failure', TIMESTAMP '2016-09-02 09:46:11.463'),
(7835, 0, 82, 'RU 136/2', 137, '136/2', 1, 1, 'Amplifier 1 DL Failure', TIMESTAMP '2016-09-02 09:46:11.51'),
(7836, 1, 82, 'RU 136/2', 137, '136/2', 1, 1, 'Amplifier 1 DL Failure', TIMESTAMP '2016-09-02 09:46:11.525'),
(7837, 0, 67, 'EU 137-1', 137, '137', 1, 1, 'Bus I2C Failure', TIMESTAMP '2016-09-02 09:46:12.025'),
(7838, 1, 67, 'EU 137-1', 137, '137', 1, 1, 'Bus I2C Failure', TIMESTAMP '2016-09-02 09:46:12.04'),
(7839, 0, 67, 'EU 136/2-1', 137, '136/2', 1, 1, 'Amplifier 2 DL Failure', TIMESTAMP '2016-09-02 09:46:12.227'),
(7840, 1, 67, 'EU 136/2-1', 137, '136/2', 1, 1, 'Amplifier 2 DL Failure', TIMESTAMP '2016-09-02 09:46:12.243'),
(7841, 0, 69, 'EU 137-2', 137, '137', 1, 1, 'Bus I2C Failure', TIMESTAMP '2016-09-02 09:46:12.399'),
(7842, 1, 69, 'EU 137-2', 137, '137', 1, 1, 'Bus I2C Failure', TIMESTAMP '2016-09-02 09:46:12.446'),
(7843, 0, 69, 'EU 136/2-2', 137, '136/2', 1, 1, 'Amplifier 1 DL Failure', TIMESTAMP '2016-09-02 09:46:12.695'),
(7844, 1, 69, 'EU 136/2-2', 137, '136/2', 1, 1, 'Amplifier 1 DL Failure', TIMESTAMP '2016-09-02 09:46:12.789'),
(7845, 0, 69, 'EU 136/2-2', 137, '136/2', 1, 1, 'Amplifier 2 DL Failure', TIMESTAMP '2016-09-02 09:46:12.851'),
(7846, 1, 69, 'EU 136/2-2', 137, '136/2', 1, 1, 'Amplifier 2 DL Failure', TIMESTAMP '2016-09-02 09:46:12.883');
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(7847, 0, 49, 'UMTS-IPP 140', 140, '140', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:13.054'),
(7848, 1, 49, 'UMTS-IPP 140', 140, '140', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:13.07'),
(7849, 0, 50, 'GSM1800-IPP 140', 140, '140', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:13.101'),
(7850, 1, 50, 'GSM1800-IPP 140', 140, '140', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:13.117'),
(7851, 0, 51, 'GSM900-IPP 140', 140, '140', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:13.148'),
(7852, 1, 51, 'GSM900-IPP 140', 140, '140', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:46:13.179'),
(7853, 0, 77, 'MU OTRX 148', 148, '148', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:14.801'),
(7854, 1, 77, 'MU OTRX 148', 148, '148', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:14.833'),
(7855, 0, 82, 'RU 160/1', 160, '160/1', 1, 1, 'Bus I2C Failure', TIMESTAMP '2016-09-02 09:46:15.472'),
(7856, 1, 82, 'RU 160/1', 160, '160/1', 1, 1, 'Bus I2C Failure', TIMESTAMP '2016-09-02 09:46:15.503'),
(7857, 0, 82, 'RU 160/1', 160, '160/1', 1, 4, 'Amplifier 1 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:15.644'),
(7858, 1, 82, 'RU 160/1', 160, '160/1', 1, 4, 'Amplifier 1 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:15.675'),
(7859, 0, 82, 'RU 160/1', 160, '160/1', 1, 4, 'Amplifier 2 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:15.722'),
(7860, 1, 82, 'RU 160/1', 160, '160/1', 1, 4, 'Amplifier 2 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:15.753'),
(7861, 0, 82, 'RU 160/1', 160, '160/1', 1, 4, 'Amplifier 3 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:15.8'),
(7862, 1, 82, 'RU 160/1', 160, '160/1', 1, 4, 'Amplifier 3 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:15.909'),
(7863, 0, 82, 'RU 160/1', 160, '160/1', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:15.956'),
(7864, 1, 82, 'RU 160/1', 160, '160/1', 1, 1, 'ConvMod 1 Communication Failure', TIMESTAMP '2016-09-02 09:46:15.987'),
(7865, 0, 82, 'MU OTRX 160/1', 160, '160/1', 1, 1, 'ConvMod 2 Communication Failure', TIMESTAMP '2016-09-02 09:46:16.034'),
(7866, 1, 82, 'MU OTRX 160/1', 160, '160/1', 1, 1, 'ConvMod 2 Communication Failure', TIMESTAMP '2016-09-02 09:46:16.065'),
(7867, 0, 82, 'RU 160/2', 161, '160/2', 1, 4, 'Amplifier 2 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:16.001'),
(7868, 1, 82, 'RU 160/2', 161, '160/2', 1, 4, 'Amplifier 2 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:16.017'),
(7869, 0, 82, 'RU 160/2', 161, '160/2', 1, 4, 'Amplifier 3 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:17.048'),
(7870, 1, 82, 'RU 160/2', 161, '160/2', 1, 4, 'Amplifier 3 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:17.063'),
(7871, 0, 82, 'RU 160/2', 161, '160/2', 1, 4, 'Amplifier 1 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:17.095'),
(7872, 1, 82, 'RU 160/2', 161, '160/2', 1, 4, 'Amplifier 1 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:17.126'),
(7873, 0, 82, 'RU 160/3', 162, '160/3', 1, 4, 'Redundancy Switch', TIMESTAMP '2016-09-02 09:46:17.828'),
(7874, 1, 82, 'RU 160/3', 162, '160/3', 1, 4, 'Redundancy Switch', TIMESTAMP '2016-09-02 09:46:17.859'),
(7875, 0, 82, 'RU 160/4', 163, '160/4', 1, 4, 'Amplifier 1 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:18.779'),
(7876, 1, 82, 'RU 160/4', 163, '160/4', 1, 4, 'Amplifier 1 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:18.795'),
(7877, 0, 82, 'RU 160/4', 163, '160/4', 1, 4, 'Amplifier 2 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:18.842'),
(7878, 1, 82, 'RU 160/4', 163, '160/4', 1, 4, 'Amplifier 2 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:18.873'),
(7879, 0, 82, 'RU 160/4', 163, '160/4', 1, 4, 'Amplifier 3 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:18.904'),
(7880, 1, 82, 'RU 160/4', 163, '160/4', 1, 4, 'Amplifier 3 DL User Shutdown', TIMESTAMP '2016-09-02 09:46:18.904'),
(7881, 0, 77, 'MU OTRX 188/1', 188, '188/1', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:19.622'),
(7882, 1, 77, 'MU OTRX 188/1', 188, '188/1', 1, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-02 09:46:19.637');
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(7883, 0, 82, 'RU 140/4', 143, '140/4', 1, 1, 'Fibre Optic UL Current', TIMESTAMP '2016-09-02 09:53:53.005'),
(7884, 1, 82, 'RU 140/4', 143, '140/4', 1, 1, 'Fibre Optic UL Current', TIMESTAMP '2016-09-02 09:53:53.02'),
(7885, 0, 79, 'SR 5 POI 2', 34, '34', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:27.828'),
(7886, 1, 79, 'SR 5 POI 2', 34, '34', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:27.89'),
(7887, 0, 79, 'SR 5 POI 3', 35, '35', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:28.468'),
(7888, 1, 79, 'SR 5 POI 3', 35, '35', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:28.499'),
(7889, 0, 79, 'SR 5 POI 4', 36, '36', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:29.716'),
(7890, 1, 79, 'SR 5 POI 4', 36, '36', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:29.809'),
(7891, 0, 79, 'SR 5 POI 5', 37, '37', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:30.371'),
(7892, 1, 79, 'SR 5 POI 5', 37, '37', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:30.464'),
(7893, 0, 79, 'SR 5 POI 6', 38, '38', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:31.042'),
(7894, 1, 79, 'SR 5 POI 6', 38, '38', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:31.151'),
(7895, 0, 79, 'SR 6 POI 2', 42, '42', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:32.087'),
(7896, 1, 79, 'SR 6 POI 2', 42, '42', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:32.134'),
(7897, 0, 79, 'SR 6 POI 3', 43, '43', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:32.914'),
(7898, 1, 79, 'SR 6 POI 3', 43, '43', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:32.96'),
(7899, 0, 79, 'SR 6 POI 6', 46, '46', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:33.569'),
(7900, 1, 79, 'SR 6 POI 6', 46, '46', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:33.6'),
(7901, 0, 79, 'SR 6 POI 8', 48, '48', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:34.146'),
(7902, 1, 79, 'SR 6 POI 8', 48, '48', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:34.193'),
(7903, 0, 79, 'SR 7 POI 3', 51, '51', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:34.723'),
(7904, 1, 79, 'SR 7 POI 3', 51, '51', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:34.739'),
(7905, 0, 79, 'SR 7 POI 5', 53, '53', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:35.347'),
(7906, 1, 79, 'SR 7 POI 5', 53, '53', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:35.488'),
(7907, 0, 79, 'SR 8 POI 1', 57, '57', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:36.19'),
(7908, 1, 79, 'SR 8 POI 1', 57, '57', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:36.268'),
(7909, 0, 79, 'SR 8 POI 2', 58, '58', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:36.876'),
(7910, 1, 79, 'SR 8 POI 2', 58, '58', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:36.938'),
(7911, 0, 79, 'SR 8 POI 3', 59, '59', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:37.469'),
(7912, 1, 79, 'SR 8 POI 3', 59, '59', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:37.484'),
(7913, 0, 79, 'SR 8 POI 6', 62, '62', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:37.968'),
(7914, 1, 79, 'SR 8 POI 6', 62, '62', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:37.984'),
(7915, 0, 79, 'SR 8 POI 7', 63, '63', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:38.452'),
(7916, 1, 79, 'SR 8 POI 7', 63, '63', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:38.592'),
(7917, 0, 79, 'SR 9 POI 4', 68, '68', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:39.076'),
(7918, 1, 79, 'SR 9 POI 4', 68, '68', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:39.091'),
(7919, 0, 79, 'SR 10 POI 2', 74, '74', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:39.622'),
(7920, 1, 79, 'SR 10 POI 2', 74, '74', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:39.637'),
(7921, 0, 79, 'SR 10 POI 3', 75, '75', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:40.168');
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(7922, 1, 79, 'SR 10 POI 3', 75, '75', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:40.183'),
(7923, 0, 79, 'SR 10 POI 7', 79, '79', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:40.714'),
(7924, 1, 79, 'SR 10 POI 7', 79, '79', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:40.745'),
(7925, 0, 79, 'SR 10 POI 8', 80, '80', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:41.26'),
(7926, 1, 79, 'SR 10 POI 8', 80, '80', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:41.275'),
(7927, 0, 79, 'SR 11 POI 3', 83, '83', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:41.806'),
(7928, 1, 79, 'SR 11 POI 3', 83, '83', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:41.837'),
(7929, 0, 79, 'SR 11 POI 6', 86, '86', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:42.352'),
(7930, 1, 79, 'SR 11 POI 6', 86, '86', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:42.383'),
(7931, 0, 79, 'SR 12 POI 2', 90, '90', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:42.898'),
(7932, 1, 79, 'SR 12 POI 2', 90, '90', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:42.913'),
(7933, 0, 79, 'SR 12 POI 5', 93, '93', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:43.444'),
(7934, 1, 79, 'SR 12 POI 5', 93, '93', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:43.459'),
(7935, 0, 79, 'SR 13 POI 1', 97, '97', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:43.99'),
(7936, 1, 79, 'SR 13 POI 1', 97, '97', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:43.005'),
(7937, 0, 79, 'SR 13 POI 3', 99, '99', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:44.551'),
(7938, 1, 79, 'SR 13 POI 3', 99, '99', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:44.567'),
(7939, 0, 79, 'SR 13 POI 7', 103, '103', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:45.097'),
(7940, 1, 79, 'SR 13 POI 7', 103, '103', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:45.097'),
(7941, 0, 79, 'SR 14 POI 1', 105, '105', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:45.628'),
(7942, 1, 79, 'SR 14 POI 1', 105, '105', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:45.643'),
(7943, 0, 79, 'SR 14 POI 2', 106, '106', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:46.174'),
(7944, 1, 79, 'SR 14 POI 2', 106, '106', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:46.189'),
(7945, 0, 79, 'SR 14 POI 5', 109, '109', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:46.72'),
(7946, 1, 79, 'SR 14 POI 5', 109, '109', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:46.735'),
(7947, 0, 79, 'SR 14 POI 6', 110, '110', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:47.25'),
(7948, 1, 79, 'SR 14 POI 6', 110, '110', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:47.266'),
(7949, 0, 79, 'SR 14 POI 7', 111, '111', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:47.734'),
(7950, 1, 79, 'SR 14 POI 7', 111, '111', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:47.749'),
(7951, 0, 79, 'SR 14 POI 8', 112, '112', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:48.28'),
(7952, 1, 79, 'SR 14 POI 8', 112, '112', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:48.295'),
(7953, 0, 79, 'SR 15 POI 1', 113, '113', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:48.826'),
(7954, 1, 79, 'SR 15 POI 1', 113, '113', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:48.841'),
(7955, 0, 79, 'SR 15 POI 2', 114, '114', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:49.403'),
(7956, 1, 79, 'SR 15 POI 2', 114, '114', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:49.418'),
(7957, 0, 79, 'SR 15 POI 5', 117, '117', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:49.918'),
(7958, 1, 79, 'SR 15 POI 5', 117, '117', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:49.933'),
(7959, 0, 79, 'SR 15 POI 6', 118, '118', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:50.401'),
(7960, 1, 79, 'SR 15 POI 6', 118, '118', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:50.417');
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(7961, 0, 79, 'SR 15 POI 7', 119, '119', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:50.869'),
(7962, 1, 79, 'SR 15 POI 7', 119, '119', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:50.885'),
(7963, 0, 79, 'SR 15 POI 8', 120, '120', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:51.415'),
(7964, 1, 79, 'SR 15 POI 8', 120, '120', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:51.431'),
(7965, 0, 79, 'SR 16 POI 1', 121, '121', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:51.961'),
(7966, 1, 79, 'SR 16 POI 1', 121, '121', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:51.977'),
(7967, 0, 79, 'SR 16 POI 5', 125, '125', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:52.507'),
(7968, 1, 79, 'SR 16 POI 5', 125, '125', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:52.523'),
(7969, 0, 79, 'SR 16 POI 7', 127, '127', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:53.053'),
(7970, 1, 79, 'SR 16 POI 7', 127, '127', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:53.084'),
(7971, 0, 75, 'IFC 2', 2, '2', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:54.832'),
(7972, 1, 75, 'IFC 2', 2, '2', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:54.847'),
(7973, 0, 75, 'IFC 5', 5, '5', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:57.484'),
(7974, 1, 75, 'IFC 5', 5, '5', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:58:57.499'),
(7975, 0, 75, 'IFC 6', 6, '6', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:59:00.136'),
(7976, 1, 75, 'IFC 6', 6, '6', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:59:00.151'),
(7977, 0, 75, 'IFC 8', 8, '8', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:59:02.788'),
(7978, 1, 75, 'IFC 8', 8, '8', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:59:02.803'),
(7979, 0, 75, 'IFC 9', 9, '9', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:59:05.455'),
(7980, 1, 75, 'IFC 9', 9, '9', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:59:05.455'),
(7981, 0, 75, 'IFC 10', 10, '10', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:59:05.564'),
(7982, 1, 75, 'IFC 10', 10, '10', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:59:05.58'),
(7983, 0, 75, 'IFC 11', 11, '11', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:59:05.72'),
(7984, 1, 75, 'IFC 11', 11, '11', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:59:05.736'),
(7985, 0, 75, 'IFC 12', 12, '12', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:59:05.986'),
(7986, 1, 75, 'IFC 12', 12, '12', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-02 09:59:05.001'),
(7987, 0, 77, 'MU OTRX 6', 6, '6', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:40.039'),
(7988, 1, 77, 'MU OTRX 6', 6, '6', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:40.101'),
(7989, 0, 77, 'MU OTRX 15', 15, '15', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:41.975'),
(7990, 1, 77, 'MU OTRX 15', 15, '15', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:41.099'),
(7991, 0, 82, 'RU 15', 15, '15', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:43.503'),
(7992, 1, 82, 'RU 15', 15, '15', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:43.597'),
(7993, 0, 77, 'MU OTRX 24', 24, '24', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:44.689'),
(7994, 1, 77, 'MU OTRX 24', 24, '24', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:44.783'),
(7995, 0, 82, 'RU 24', 24, '24', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:45.765'),
(7996, 1, 82, 'RU 24', 24, '24', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:45.797'),
(7997, 0, 77, 'MU OTRX 30', 30, '30', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:46.467'),
(7998, 1, 77, 'MU OTRX 30', 30, '30', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:46.514'),
(7999, 0, 82, 'RU 30', 30, '30', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:47.497'),
(8000, 1, 82, 'RU 30', 30, '30', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:47.544');
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(8001, 0, 77, 'MU OTRX 41', 41, '41', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:48.152'),
(8002, 1, 77, 'MU OTRX 41', 41, '41', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:48.199'),
(8003, 0, 82, 'RU 41', 41, '41', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:49.104'),
(8004, 1, 82, 'RU 41', 41, '41', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:49.151'),
(8005, 0, 77, 'MU OTRX 42', 42, '42', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:49.837'),
(8006, 1, 77, 'MU OTRX 42', 42, '42', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:49.868'),
(8007, 0, 77, 'MU OTRX 64', 64, '64', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:50.508'),
(8008, 1, 77, 'MU OTRX 64', 64, '64', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:50.555'),
(8009, 0, 77, 'MU OTRX 71', 71, '71', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:51.21'),
(8010, 1, 77, 'MU OTRX 71', 71, '71', 1, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:51.241'),
(8011, 0, 87, 'MC 0', 0, '0', 1, 1, 'O&M Communication Failure', TIMESTAMP '2016-09-05 05:51:51.896'),
(8012, 1, 87, 'MC 0', 0, '0', 1, 1, 'O&M Communication Failure', TIMESTAMP '2016-09-05 05:51:51.912'),
(8013, 0, 79, 'SR 6 POI 6', 46, '46', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:51.99'),
(8014, 1, 79, 'SR 6 POI 6', 46, '46', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:51.005'),
(8015, 0, 79, 'SR 6 POI 8', 48, '48', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.052'),
(8016, 1, 79, 'SR 6 POI 8', 48, '48', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.068'),
(8017, 0, 79, 'SR 7 POI 3', 51, '51', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.115'),
(8018, 1, 79, 'SR 7 POI 3', 51, '51', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.13'),
(8019, 0, 79, 'SR 7 POI 5', 53, '53', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.193'),
(8020, 1, 79, 'SR 7 POI 5', 53, '53', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.208'),
(8021, 0, 79, 'SR 8 POI 1', 57, '57', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.255'),
(8022, 1, 79, 'SR 8 POI 1', 57, '57', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.317'),
(8023, 0, 79, 'SR 8 POI 2', 58, '58', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.364'),
(8024, 1, 79, 'SR 8 POI 2', 58, '58', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.395'),
(8025, 0, 79, 'SR 8 POI 3', 59, '59', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.442'),
(8026, 1, 79, 'SR 8 POI 3', 59, '59', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.473'),
(8027, 0, 79, 'SR 8 POI 6', 62, '62', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.52'),
(8028, 1, 79, 'SR 8 POI 6', 62, '62', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.536'),
(8029, 0, 79, 'SR 8 POI 7', 63, '63', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.583'),
(8030, 1, 79, 'SR 8 POI 7', 63, '63', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.598'),
(8031, 0, 52, 'TETRA800-IPP 136', 136, '136', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.692'),
(8032, 1, 52, 'TETRA800-IPP 136', 136, '136', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.739'),
(8033, 0, 79, 'SR 9 POI 4', 68, '68', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.785'),
(8034, 1, 79, 'SR 9 POI 4', 68, '68', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.801'),
(8035, 0, 77, 'MU OTRX 6', 6, '6', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.848'),
(8036, 1, 77, 'MU OTRX 6', 6, '6', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.895'),
(8037, 0, 52, 'TETRA800-IPP 15', 15, '15', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.957'),
(8038, 1, 52, 'TETRA800-IPP 15', 15, '15', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.973'),
(8039, 0, 79, 'SR 10 POI 2', 74, '74', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.019');
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(8040, 1, 79, 'SR 10 POI 2', 74, '74', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:52.035'),
(8041, 0, 79, 'SR 10 POI 3', 75, '75', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.082'),
(8042, 1, 79, 'SR 10 POI 3', 75, '75', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.097'),
(8043, 0, 79, 'SR 10 POI 7', 79, '79', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.144'),
(8044, 1, 79, 'SR 10 POI 7', 79, '79', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.16'),
(8045, 0, 79, 'SR 10 POI 8', 80, '80', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.207'),
(8046, 1, 79, 'SR 10 POI 8', 80, '80', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.222'),
(8047, 0, 77, 'MU OTRX 15', 15, '15', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.285'),
(8048, 1, 77, 'MU OTRX 15', 15, '15', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.316'),
(8049, 0, 79, 'SR 11 POI 3', 83, '83', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.378'),
(8050, 1, 79, 'SR 11 POI 3', 83, '83', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.394'),
(8051, 0, 79, 'SR 11 POI 6', 86, '86', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.441'),
(8052, 1, 79, 'SR 11 POI 6', 86, '86', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.472'),
(8053, 0, 79, 'SR 12 POI 2', 90, '90', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.519'),
(8054, 1, 79, 'SR 12 POI 2', 90, '90', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.55'),
(8055, 0, 77, 'MU OTRX 24', 24, '24', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.612'),
(8056, 1, 77, 'MU OTRX 24', 24, '24', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.628'),
(8057, 0, 79, 'SR 12 POI 5', 93, '93', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.675'),
(8058, 1, 79, 'SR 12 POI 5', 93, '93', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.706'),
(8059, 0, 77, 'MU OTRX 30', 30, '30', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.768'),
(8060, 1, 77, 'MU OTRX 30', 30, '30', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.784'),
(8061, 0, 79, 'SR 13 POI 1', 97, '97', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.831'),
(8062, 1, 79, 'SR 13 POI 1', 97, '97', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.846'),
(8063, 0, 53, 'TETRA400-IPP 136', 136, '136', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.893'),
(8064, 1, 53, 'TETRA400-IPP 136', 136, '136', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.94'),
(8065, 0, 79, 'SR 13 POI 3', 99, '99', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.987'),
(8066, 1, 79, 'SR 13 POI 3', 99, '99', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:53.002'),
(8067, 0, 82, 'RU 5', 5, '5', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.049'),
(8068, 1, 82, 'RU 5', 5, '5', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.08'),
(8069, 0, 49, 'UMTS-IPP 136', 136, '136', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.143'),
(8070, 1, 49, 'UMTS-IPP 136', 136, '136', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.174'),
(8071, 0, 79, 'SR 13 POI 7', 103, '103', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.221'),
(8072, 1, 79, 'SR 13 POI 7', 103, '103', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.236'),
(8073, 0, 79, 'SR 14 POI 1', 105, '105', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.283'),
(8074, 1, 79, 'SR 14 POI 1', 105, '105', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.299'),
(8075, 0, 79, 'SR 14 POI 2', 106, '106', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.345'),
(8076, 1, 79, 'SR 14 POI 2', 106, '106', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.361'),
(8077, 0, 49, 'UMTS-IPP 140', 140, '140', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.408'),
(8078, 1, 49, 'UMTS-IPP 140', 140, '140', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.439');
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(8079, 0, 53, 'TETRA400-IPP 15', 15, '15', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.486'),
(8080, 1, 53, 'TETRA400-IPP 15', 15, '15', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.517'),
(8081, 0, 79, 'SR 14 POI 5', 109, '109', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.548'),
(8082, 1, 79, 'SR 14 POI 5', 109, '109', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.564'),
(8083, 0, 79, 'SR 14 POI 6', 110, '110', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.626'),
(8084, 1, 79, 'SR 14 POI 6', 110, '110', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.642'),
(8085, 0, 79, 'SR 14 POI 7', 111, '111', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.689'),
(8086, 1, 79, 'SR 14 POI 7', 111, '111', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.704'),
(8087, 0, 79, 'SR 14 POI 8', 112, '112', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.735'),
(8088, 1, 79, 'SR 14 POI 8', 112, '112', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.751'),
(8089, 0, 79, 'SR 15 POI 1', 113, '113', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.798'),
(8090, 1, 79, 'SR 15 POI 1', 113, '113', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.813'),
(8091, 0, 79, 'SR 15 POI 2', 114, '114', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.86'),
(8092, 1, 79, 'SR 15 POI 2', 114, '114', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.876'),
(8093, 0, 79, 'SR 15 POI 5', 117, '117', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.923'),
(8094, 1, 79, 'SR 15 POI 5', 117, '117', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.938'),
(8095, 0, 79, 'SR 15 POI 6', 118, '118', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.985'),
(8096, 1, 79, 'SR 15 POI 6', 118, '118', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:54.001'),
(8097, 0, 79, 'SR 15 POI 7', 119, '119', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.032'),
(8098, 1, 79, 'SR 15 POI 7', 119, '119', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.047'),
(8099, 0, 79, 'SR 15 POI 8', 120, '120', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.094'),
(8100, 1, 79, 'SR 15 POI 8', 120, '120', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.11'),
(8101, 0, 79, 'SR 16 POI 1', 121, '121', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.157'),
(8102, 1, 79, 'SR 16 POI 1', 121, '121', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.172'),
(8103, 0, 77, 'MU OTRX 41', 41, '41', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.219'),
(8104, 1, 77, 'MU OTRX 41', 41, '41', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.25'),
(8105, 0, 82, 'RU 15', 15, '15', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.297'),
(8106, 1, 82, 'RU 15', 15, '15', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.328'),
(8107, 0, 82, 'RU 30', 30, '30', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.375'),
(8108, 1, 82, 'RU 30', 30, '30', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.406'),
(8109, 0, 79, 'SR 16 POI 5', 125, '125', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.469'),
(8110, 1, 79, 'SR 16 POI 5', 125, '125', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.5'),
(8111, 0, 79, 'SR 16 POI 7', 127, '127', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.547'),
(8112, 1, 79, 'SR 16 POI 7', 127, '127', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.562'),
(8113, 0, 77, 'MU OTRX 42', 42, '42', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.609'),
(8114, 1, 77, 'MU OTRX 42', 42, '42', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.64'),
(8115, 0, 77, 'MU OTRX 64', 64, '64', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.687'),
(8116, 1, 77, 'MU OTRX 64', 64, '64', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.718'),
(8117, 0, 82, 'RU 24', 24, '24', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.765');
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(8118, 1, 82, 'RU 24', 24, '24', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.796'),
(8119, 0, 50, 'GSM1800-IPP 136', 136, '136', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.859'),
(8120, 1, 50, 'GSM1800-IPP 136', 136, '136', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.874'),
(8121, 0, 75, 'IFC 2', 2, '2', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.921'),
(8122, 1, 75, 'IFC 2', 2, '2', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.937'),
(8123, 0, 82, 'RU 41', 41, '41', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.983'),
(8124, 1, 82, 'RU 41', 41, '41', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:55.015'),
(8125, 0, 50, 'GSM1800-IPP 140', 140, '140', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.061'),
(8126, 1, 50, 'GSM1800-IPP 140', 140, '140', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.093'),
(8127, 0, 75, 'IFC 6', 6, '6', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.139'),
(8128, 1, 75, 'IFC 6', 6, '6', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.155'),
(8129, 0, 75, 'IFC 5', 5, '5', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.233'),
(8130, 1, 75, 'IFC 5', 5, '5', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.249'),
(8131, 0, 75, 'IFC 8', 8, '8', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.295'),
(8132, 1, 75, 'IFC 8', 8, '8', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.311'),
(8133, 0, 75, 'IFC 9', 9, '9', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.342'),
(8134, 1, 75, 'IFC 9', 9, '9', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.358'),
(8135, 0, 75, 'IFC 10', 10, '10', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.405'),
(8136, 1, 75, 'IFC 10', 10, '10', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.42'),
(8137, 0, 75, 'IFC 11', 11, '11', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.451'),
(8138, 1, 75, 'IFC 11', 11, '11', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.483'),
(8139, 0, 75, 'IFC 12', 12, '12', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.514'),
(8140, 1, 75, 'IFC 12', 12, '12', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.529'),
(8141, 0, 77, 'MU OTRX 71', 71, '71', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.592'),
(8142, 1, 77, 'MU OTRX 71', 71, '71', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.623'),
(8143, 0, 79, 'SR 5 POI 2', 34, '34', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.67'),
(8144, 1, 79, 'SR 5 POI 2', 34, '34', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.685'),
(8145, 0, 79, 'SR 5 POI 3', 35, '35', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.732'),
(8146, 1, 79, 'SR 5 POI 3', 35, '35', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.748'),
(8147, 0, 79, 'SR 5 POI 4', 36, '36', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.795'),
(8148, 1, 79, 'SR 5 POI 4', 36, '36', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.81'),
(8149, 0, 51, 'GSM900-IPP 136', 136, '136', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.857'),
(8150, 1, 51, 'GSM900-IPP 136', 136, '136', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.888'),
(8151, 0, 79, 'SR 5 POI 5', 37, '37', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.919'),
(8152, 1, 79, 'SR 5 POI 5', 37, '37', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.935'),
(8153, 0, 79, 'SR 5 POI 6', 38, '38', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.982'),
(8154, 1, 79, 'SR 5 POI 6', 38, '38', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:56.997'),
(8155, 0, 51, 'GSM900-IPP 140', 140, '140', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:57.044'),
(8156, 1, 51, 'GSM900-IPP 140', 140, '140', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:57.06'),
(8157, 0, 79, 'SR 6 POI 2', 42, '42', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:57.107');
INSERT INTO PUBLIC.ALARM_HISTORY(ID, ACCOUNT, UNIT, UNITSTRING, ADDR, ADDRSTRING, ALARMTYPE, SEVERITY, ALARMTEXT, ALARMDATE) VALUES
(8158, 1, 79, 'SR 6 POI 2', 42, '42', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:57.122'),
(8159, 0, 79, 'SR 6 POI 3', 43, '43', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:57.153'),
(8160, 1, 79, 'SR 6 POI 3', 43, '43', 0, 1, 'Unit Unavailable', TIMESTAMP '2016-09-05 05:51:57.169'),
(8161, 0, 87, 'MC 0', 0, '0', 0, 1, 'O&M Communication Failure', TIMESTAMP '2016-09-05 05:53:39.552'),
(8162, 1, 87, 'MC 0', 0, '0', 0, 1, 'O&M Communication Failure', TIMESTAMP '2016-09-05 05:53:39.552'),
(8163, 0, 77, 'MU OTRX 5', 5, '5', 0, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-05 05:53:39.583'),
(8164, 1, 77, 'MU OTRX 5', 5, '5', 0, 1, 'Fibre Optic Rx Alarm', TIMESTAMP '2016-09-05 05:53:39.599');
CREATE INDEX PUBLIC.IDX_ALARM_HISTORY_ALARMDATE ON PUBLIC.ALARM_HISTORY(ALARMDATE);
CREATE INDEX PUBLIC.IDX_ALARM_HISTORY_ACCOUNTALARMDATE ON PUBLIC.ALARM_HISTORY(ACCOUNT, ALARMDATE);
ALTER TABLE PUBLIC.ALARM_HISTORY ADD CONSTRAINT PUBLIC.FK_ALARM_HISTORY_USERS FOREIGN KEY(ACCOUNT) REFERENCES PUBLIC.USERS(USERID) ON DELETE CASCADE ON UPDATE CASCADE NOCHECK;
;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_A40B4853_4C20_40CE_B986_96E85710FA14 START WITH 4313 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_31C25C75_0444_4E96_B4AD_A76F37B6F530 START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_DB99439B_4645_4975_9020_460C177CF416 START WITH 3 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_D37CF440_0056_4986_858A_859A1A43C371 START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_8642E227_AB5A_410E_B001_51807AFAEBC9 START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_39DC9DAB_FBB1_4D31_B2D0_4D01DCC9CE8F START WITH 3 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_D77536D8_1D9D_4A74_85E8_E2AAEAD73B6C START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_A0E85635_D4F1_4BDF_85EC_3064FCFD87D7 START WITH 5 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_0830A18F_32F5_4944_B326_EA286D1261C6 START WITH 33 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_161FF4F4_AEB2_443D_BE77_3144FEA308CE START WITH 2 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_B9CBD0A8_0FB8_4D3F_8897_2A637DA263D1 START WITH 142 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_ABD3B446_F282_4800_AFDC_456A6ED02924 START WITH 1245 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_10E65B4C_829E_4441_AC46_3363DD74A88C START WITH 33 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_94E5DDB9_029E_420D_AEE3_46FE93553FEF START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_4AAF70BE_E066_4205_8742_29F52E084E5B START WITH 5 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_AC791833_B12F_4F5B_AB8C_872A5DED5B9A START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_B6CB98C7_DFCF_4389_BD38_1C903D83537C START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_7AC91E0F_78F8_4486_BE14_E88B31309B86 START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_2EC60EB2_12A3_47AE_8766_701CCD320A4E START WITH 689 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_FBF2D857_249F_4931_9524_122E8B426730 START WITH 5 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_7F917534_FD5F_4E62_8AEA_0AF1AEEFAC2F START WITH 1 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_C2F320EC_F67F_4607_973A_32FCD6DA716F START WITH 33 BELONGS_TO_TABLE;
CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_F10ABB9E_2A0B_48D5_8E10_005224FE1255 START WITH 8165 BELONGS_TO_TABLE;
CREATE CACHED TABLE PUBLIC.USERS(
USERID INTEGER NOT NULL,
NAME VARCHAR(1024)
);
ALTER TABLE PUBLIC.USERS ADD CONSTRAINT PUBLIC.PK_USERS PRIMARY KEY(USERID);
-- 10 +/- SELECT COUNT(*) FROM PUBLIC.USERS;
INSERT INTO PUBLIC.USERS(USERID, NAME) VALUES
(2, ''),
(3, ''),
(4, ''),
(5, ''),
(6, ''),
(7, ''),
(8, ''),
(9, ''),
(0, 'FACTORY'),
(1, 'OWNER');
