-- Site credentials (FTP, database, WP admin)
-- Saved during remote WordPress installation for future reference

ALTER TABLE sites ADD COLUMN ftp_host VARCHAR(255) NULL AFTER is_multisite;
ALTER TABLE sites ADD COLUMN ftp_port INT NULL DEFAULT 21 AFTER ftp_host;
ALTER TABLE sites ADD COLUMN ftp_user VARCHAR(255) NULL AFTER ftp_port;
ALTER TABLE sites ADD COLUMN ftp_pass VARCHAR(255) NULL AFTER ftp_user;
ALTER TABLE sites ADD COLUMN ftp_path VARCHAR(255) NULL AFTER ftp_pass;

ALTER TABLE sites ADD COLUMN db_host VARCHAR(255) NULL AFTER ftp_path;
ALTER TABLE sites ADD COLUMN db_name VARCHAR(255) NULL AFTER db_host;
ALTER TABLE sites ADD COLUMN db_user VARCHAR(255) NULL AFTER db_name;
ALTER TABLE sites ADD COLUMN db_pass VARCHAR(255) NULL AFTER db_user;
ALTER TABLE sites ADD COLUMN db_prefix VARCHAR(50) NULL DEFAULT 'wp_' AFTER db_pass;

ALTER TABLE sites ADD COLUMN wp_admin_user VARCHAR(255) NULL AFTER db_prefix;
ALTER TABLE sites ADD COLUMN wp_admin_pass VARCHAR(255) NULL AFTER wp_admin_user;
ALTER TABLE sites ADD COLUMN wp_admin_email VARCHAR(255) NULL AFTER wp_admin_pass;