DcBH20gr

1CREATE TABLE IF NOT EXISTS statusupdates (sid int UNIQUE, fullname VARCHAR(64), oldstatus VARCHAR(16), newstatus VARCHAR(16), time TIMESTAMP);
2
3INSERT INTO statusupdates VALUES
4(null, 'fictHTTP', 'Off', 'On', '2017-01-01 02:20:00'),
5(null, 'faked', 'On', 'Inactive', '2017-01-01 02:25:00'),
6(null, 'ipsum', 'Inactive', 'On', '2017-01-01 02:30:00'),
7(null, 'resultd', 'On', 'Inactive', '2017-01-01 02:35:00'),
8(null, 'ipsum', 'On', 'Active', '2017-01-01 02:40:00'),
9(null, 'fictHTTP', 'On', 'Active', '2017-01-01 02:45:00'),
10(null, 'faked', 'Inactive', 'Off', '2017-01-01 02:50:00'),
11(null, 'ipsum', 'Active', 'Off', '2017-01-01 02:55:00'),
12(null, 'resultd', 'Inactive', 'Off', '2017-01-01 03:00:00');