-- MySQL dump 8.22 -- -- Host: localhost Database: monitor --------------------------------------------------------- -- Server version 3.23.53 -- -- Table structure for table 'bbarchive' -- DROP TABLE IF EXISTS bbarchive; CREATE TABLE bbarchive ( hostname varchar(50) NOT NULL default '', service varchar(50) NOT NULL default '', status varchar(25) NOT NULL default '', timestamp timestamp(14) NOT NULL, log text NOT NULL, KEY hostname (hostname), KEY service (service), KEY timestamp (timestamp) ) TYPE=MyISAM; -- -- Table structure for table 'bbhistory' -- DROP TABLE IF EXISTS bbhistory; CREATE TABLE bbhistory ( hostname varchar(50) NOT NULL default '', service varchar(50) NOT NULL default '', status varchar(25) NOT NULL default '', timestamp timestamp(14) NOT NULL, log text NOT NULL, KEY hostname (hostname), KEY service (service), KEY timestamp (timestamp) ) TYPE=MyISAM;