-- Upgrade: schema_version 3 to 4
--
ALTER TABLE system_config ADD use_repo_download CHAR(1);
UPDATE system_config SET use_repo_download = 'N';
ALTER TABLE system_config ALTER COLUMN use_repo_download SET DEFAULT 'N';
ALTER TABLE system_config ALTER COLUMN use_repo_download SET NOT NULL;

ALTER TABLE system_config ADD git_daemon_url VARCHAR(255);

ALTER TABLE accounts ADD show_site_header CHAR(1);
UPDATE accounts SET show_site_header = 'Y';
ALTER TABLE accounts ALTER COLUMN show_site_header SET DEFAULT 'N';
ALTER TABLE accounts ALTER COLUMN show_site_header SET NOT NULL;

UPDATE schema_version SET version_nbr = 4;

CREATE INDEX changes_byProjectOpen
ON changes (dest_project_name, sort_key)
WHERE open = 'Y';