WordPress database error: [Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause]
CREATE TABLE IF NOT EXISTS Libsoftsrfm_entries ( ID BIGINT(20) UNSIGNED AUTO_INCREMENT PRIMARY KEY, form_id BIGINT(20) UNSIGNED, user_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, form_data LONGTEXT, logs LONGTEXT, notes LONGTEXT, submission_info LONGTEXT, status VARCHAR(10), type VARCHAR(20), extras LONGTEXT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, INDEX idx_form_id (form_id), INDEX idx_user_id (user_id), INDEX idx_form_id_created_at_status (form_id, created_at, status) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

WordPress database error: [Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause]
CREATE TABLE IF NOT EXISTS Libsoftsrfm_payments ( id BIGINT(20) UNSIGNED AUTO_INCREMENT PRIMARY KEY, form_id BIGINT(20) UNSIGNED, block_id VARCHAR(255) NOT NULL, status VARCHAR(50) NOT NULL, total_amount DECIMAL(26,8) NOT NULL, refunded_amount DECIMAL(26,8) NOT NULL, currency VARCHAR(10) NOT NULL, entry_id BIGINT(20) UNSIGNED NOT NULL, gateway VARCHAR(20) NOT NULL, type VARCHAR(30) NOT NULL, mode VARCHAR(20) NOT NULL, transaction_id VARCHAR(50) NOT NULL, customer_id VARCHAR(50) NOT NULL, subscription_id VARCHAR(50) NOT NULL, subscription_status VARCHAR(20) NOT NULL, parent_subscription_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, payment_data LONGTEXT, extra LONGTEXT, log LONGTEXT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, srfm_txn_id VARCHAR(100) NOT NULL, customer_email VARCHAR(255) NOT NULL, customer_name VARCHAR(255) NOT NULL ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

Library Software

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!