ALTER TABLE user_settings ADD COLUMN deploy_cron VARCHAR(100) DEFAULT '12 12 * * *';
ALTER TABLE user_settings ADD COLUMN backup_cron VARCHAR(100) DEFAULT '12 12 * * *';

ALTER TABLE host ADD COLUMN auto_deploy_enabled BOOLEAN DEFAULT 1;
ALTER TABLE host ADD COLUMN auto_backup_enabled BOOLEAN DEFAULT 1;

ALTER TABLE user_settings DROP COLUMN deploy_interval;
ALTER TABLE user_settings DROP COLUMN backup_interval;


ALTER TABLE host
  ADD COLUMN use_daemon BOOLEAN NOT NULL DEFAULT 0;

ALTER TABLE host
  ALTER COLUMN use_daemon DROP DEFAULT;

ALTER TABLE host
  ADD COLUMN daemon_url VARCHAR(255);

ALTER TABLE host
  ADD COLUMN daemon_token VARCHAR(255);

ALTER TABLE Host ADD COLUMN preferred_hostfile_id INTEGER;
ALTER TABLE Host 
ADD COLUMN preferred_hostfile_id INTEGER 
  REFERENCES host_file(id);

ALTER TABLE user_settings ADD COLUMN global_ssh_key TEXT;
ALTER TABLE user_settings ADD COLUMN global_key_passphrase VARCHAR(200);

ALTER TABLE host ADD COLUMN disable_regex_deploy BOOLEAN NOT NULL DEFAULT 0;

ALTER TABLE host ADD COLUMN disable_local_default BOOLEAN DEFAULT FALSE;
ALTER TABLE user_dynamic_variables DROP TABLE;