Jacek Pyziak
b653cea252
- Create SQL migration for prompt templates used in article and image generation. - Add migration to change publish interval from days to hours in the sites table. - Implement InstallerController to handle installation requests and validation. - Develop FtpService for FTP connections and file uploads. - Create InstallerService to manage the WordPress installation process, including downloading, extracting, and configuring WordPress. - Add index view for the installer with form inputs for FTP, database, and WordPress admin settings. - Implement progress tracking for the installation process with AJAX polling.
19 lines
1.1 KiB
SQL
19 lines
1.1 KiB
SQL
-- 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;
|