wp_cyclesave_groups

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_cyclesave_groups ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(150) NOT NULL, slug VARCHAR(150) NOT NULL, admin_user_id BIGINT UNSIGNED NOT NULL, contribution_amount DECIMAL(15,2) NOT NULL DEFAULT 0.00, currency VARCHAR(10) NOT NULL DEFAULT 'USD', frequency ENUM('daily','weekly','monthly') NOT NULL DEFAULT 'monthly', max_members TINYINT UNSIGNED NOT NULL DEFAULT 10, current_round SMALLINT UNSIGNED NOT NULL DEFAULT 0, payout_order_locked TINYINT(1) NOT NULL DEFAULT 0, status ENUM('open','ordering','active','paused','completed') NOT NULL DEFAULT 'open', visibility ENUM('public','private') NOT NULL DEFAULT 'public', grace_period_hours TINYINT NOT NULL DEFAULT 24, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY slug (slug), KEY admin_user_id (admin_user_id), KEY status (status), KEY visibility (visibility) ) $charset_collate;"; // 2. cyclesave_members $sql[] = "CREATE TABLE wp_cyclesave_members ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, group_id BIGINT UNSIGNED NOT NULL, user_id BIGINT UNSIGNED NOT NULL, position TINYINT UNSIGNED NOT NULL DEFAULT 0, has_collected TINYINT(1) NOT NULL DEFAULT 0, total_contributed DECIMAL(15,2) NOT NULL DEFAULT 0.00, missed_payments TINYINT NOT NULL DEFAULT 0, status ENUM('pending','active','suspended','left') NOT NULL DEFAULT 'pending', joined_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY group_user (group_id, user_id), KEY group_id (group_id), KEY user_id (user_id), KEY status (status) ) $charset_collate;"; // 3. cyclesave_rounds $sql[] = "CREATE TABLE wp_cyclesave_rounds ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, group_id BIGINT UNSIGNED NOT NULL, cycle_id BIGINT UNSIGNED NULL, round_number SMALLINT UNSIGNED NOT NULL DEFAULT 1, scheduled_collector_user_id BIGINT UNSIGNED NOT NULL, contribution_due DATETIME NOT NULL, collector_user_id BIGINT UNSIGNED NULL, pot_amount DECIMAL(15,2) NOT NULL DEFAULT 0.00, status ENUM('collecting','pending_payout','paid','skipped') NOT NULL DEFAULT 'collecting', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY group_id (group_id), KEY cycle_id (cycle_id), KEY status (status), KEY contribution_due (contribution_due) ) $charset_collate;"; // 4. cyclesave_contributions $sql[] = "CREATE TABLE wp_cyclesave_contributions ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, round_id BIGINT UNSIGNED NOT NULL, member_id BIGINT UNSIGNED NOT NULL, amount DECIMAL(15,2) NOT NULL DEFAULT 0.00, gateway ENUM('stripe','paypal','monnify','paystack','flutterwave','mollie','bank_transfer','store_payment') NOT NULL DEFAULT 'stripe', gateway_reference VARCHAR(100) NULL DEFAULT NULL, gateway_status VARCHAR(50) NOT NULL DEFAULT '', status ENUM('pending','success','failed','reversed','refunded') NOT NULL DEFAULT 'pending', paid_at DATETIME NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY gateway_reference (gateway_reference), KEY round_id (round_id), KEY member_id (member_id), KEY status (status) ) $charset_collate;"; // 5. cyclesave_payout_order $sql[] = "CREATE TABLE wp_cyclesave_payout_order ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, group_id BIGINT UNSIGNED NOT NULL, member_id BIGINT UNSIGNED NOT NULL, payout_position TINYINT UNSIGNED NOT NULL, changed_by_user_id BIGINT UNSIGNED NULL, change_reason VARCHAR(255) NULL, set_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY group_id (group_id), KEY member_id (member_id), KEY payout_position (payout_position) ) $charset_collate;"; // 6. cyclesave_payouts $sql[] = "CREATE TABLE wp_cyclesave_payouts ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, round_id BIGINT UNSIGNED NOT NULL, collector_user_id BIGINT UNSIGNED NOT NULL, amount DECIMAL(15,2) NOT NULL DEFAULT 0.00, gateway ENUM('stripe','paypal','monnify','paystack','flutterwave','mollie','bank_transfer','store_payment') NOT NULL DEFAULT 'stripe', gateway_reference VARCHAR(100) NOT NULL DEFAULT '', bank_name VARCHAR(100) NOT NULL DEFAULT '', account_number VARCHAR(20) NOT NULL DEFAULT '', status ENUM('pending','processing','success','failed') NOT NULL DEFAULT 'pending', initiated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, completed_at DATETIME NULL, PRIMARY KEY (id), KEY round_id (round_id), KEY collector_user_id (collector_user_id), KEY status (status) ) $charset_collate;"; // 7. cyclesave_notifications $sql[] = "CREATE TABLE wp_cyclesave_notifications ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL, group_id BIGINT UNSIGNED NOT NULL, type VARCHAR(80) NOT NULL, subject VARCHAR(255) NOT NULL DEFAULT '', body LONGTEXT NOT NULL, sent_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), KEY group_id (group_id), KEY type (type) ) $charset_collate;"; // 8. cyclesave_cycles $sql[] = "CREATE TABLE wp_cyclesave_cycles ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, group_id BIGINT UNSIGNED NOT NULL, cycle_number TINYINT UNSIGNED NOT NULL DEFAULT 1, status ENUM('active','completed') NOT NULL DEFAULT 'active', contribution_amount DECIMAL(15,2) NOT NULL DEFAULT 0.00, frequency ENUM('daily','weekly','monthly') NOT NULL DEFAULT 'monthly', max_members TINYINT UNSIGNED NOT NULL DEFAULT 10, started_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, completed_at DATETIME NULL, PRIMARY KEY (id), KEY group_id (group_id), KEY status (status) ) $charset_collate;"; // 9. cyclesave_payment_events $sql[] = "CREATE TABLE wp_cyclesave_payment_events ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, contribution_id BIGINT UNSIGNED NOT NULL DEFAULT 0, gateway VARCHAR(50) NOT NULL DEFAULT '', gateway_reference VARCHAR(100) NOT NULL DEFAULT '', event_type VARCHAR(80) NOT NULL DEFAULT '', event_source VARCHAR(80) NOT NULL DEFAULT '', gateway_status VARCHAR(100) NOT NULL DEFAULT '', payload_hash CHAR(64) NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY contribution_id (contribution_id), KEY gateway_reference (gateway_reference), KEY event_type (event_type), KEY event_source (event_source), KEY payload_hash (payload_hash) ) $charset_collate;"; foreach ( $sql as $query ) { dbDelta( $query );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_cyclesave_groups`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from CycleSave – ROSCA Engine for WordPress