Attachment 1448404 Details for Bug 1567344 – site_configuration

site_configuration

site_configuration.table.txt (text/plain), 2.01 KB, created by Rupesh Patel on 2018-06-06 18:06:50 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Rupesh Patel

Created: 2018-06-06 18:06:50 UTC

Size: 2.01 KB

patch

obsolete

>*************************** 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

Actions: View

Attachments on bug 1567344: 1448402 | 1448403 | 1448404 | 1448405 | 1448406