*************************** 1. row ***************************
       Table: site_configuration
Create Table: CREATE TABLE `site_configuration` (
  `master_host` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `slave_server_id` int(11) DEFAULT NULL,
  `slave_base_dir` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `slave_db_host` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `slave_port` int(11) DEFAULT NULL,
  `slave_web_host` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `short_name` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `long_name` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `mysqld_multi_index` int(11) DEFAULT NULL,
  `replication_mode` enum('Online','Dialup','Offline','On-request','mssql') COLLATE latin1_general_ci DEFAULT NULL,
  `state` set('Running','Stopped') COLLATE latin1_general_ci NOT NULL DEFAULT 'Stopped',
  `monitor_state` enum('active','inactive','passive','virtual') COLLATE latin1_general_ci DEFAULT 'active',
  `replication_hours` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `dialup_phone` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `dialup_user` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `dialup_pw` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `version` varchar(64) COLLATE latin1_general_ci DEFAULT '4',
  `runsoon` enum('yes','no') COLLATE latin1_general_ci DEFAULT 'no',
  `compression_ratio` float DEFAULT NULL,
  `compression_message` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `compression_time` datetime DEFAULT NULL,
  `compression_usage_ratio` float DEFAULT NULL,
  `site_note` text COLLATE latin1_general_ci,
  `users_update_timestamp` datetime DEFAULT NULL,
  `last_trigger_time` datetime DEFAULT NULL,
  `protocol` enum('legacy','rest','restssl') COLLATE latin1_general_ci NOT NULL DEFAULT 'legacy',
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `unique_shortname` (`short_name`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci