23/04/2026 - 10:27:14 [ OPERATION OK ] Connected to 'rankrise_iwitintn9': [DBHOST] = localhost | [DBUSER] = rankrise_iwitintn9
23/04/2026 - 10:27:14 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'rankrise_iwitintn9' AND TABLE_NAME = 'oc_t_usc_user_meta' LIMIT 1
23/04/2026 - 10:27:14 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'rankrise_iwitintn9' AND TABLE_NAME = 'oc_t_usc_user_plans' LIMIT 1
23/04/2026 - 10:27:14 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'rankrise_iwitintn9' AND TABLE_NAME = 'oc_t_usc_feature_usage' LIMIT 1
23/04/2026 - 10:27:14 [ OPERATION OK ] SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'rankrise_iwitintn9' AND TABLE_NAME = 'oc_t_usc_plans_config' LIMIT 1
23/04/2026 - 10:27:14 [ OPERATION OK ] CREATE TABLE IF NOT EXISTS `oc_t_usc_payments` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `user_id` INT(11) UNSIGNED NOT NULL, `purchase_type` VARCHAR(20) NOT NULL DEFAULT 'plan', `purchase_ref` VARCHAR(50) NOT NULL DEFAULT '', `credits_amount` INT(11) NOT NULL DEFAULT 0, `amount` DECIMAL(10,2) NOT NULL DEFAULT 0.00, `currency` VARCHAR(10) NOT NULL DEFAULT 'TND', `payment_method` VARCHAR(20) NOT NULL DEFAULT 'bank', `status` VARCHAR(20) NOT NULL DEFAULT 'pending', `idempotency_key` VARCHAR(64) DEFAULT NULL COMMENT 'Prevents duplicate payments', `reference_code` VARCHAR(30) DEFAULT NULL, `proof_image` VARCHAR(255) DEFAULT NULL, `transaction_id` VARCHAR(100) DEFAULT NULL, `gateway_payload` TEXT DEFAULT NULL, `admin_note` VARCHAR(500) DEFAULT NULL, `reviewed_by` INT(11) DEFAULT NULL, `reviewed_at` DATETIME DEFAULT NULL, `expires_at` DATETIME DEFAULT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `uq_reference` (`reference_code`), UNIQUE KEY `uq_idempotency` (`idempotency_key`), KEY `idx_user` (`user_id`), KEY `idx_status` (`status`), KEY `idx_method` (`payment_method`), KEY `idx_type` (`purchase_type`), KEY `idx_created` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
23/04/2026 - 10:27:14 [ OPERATION OK ] CREATE TABLE IF NOT EXISTS `oc_t_usc_audit_log` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `payment_id` INT(11) NOT NULL, `action` VARCHAR(50) NOT NULL, `from_state` VARCHAR(20) DEFAULT NULL, `to_state` VARCHAR(20) DEFAULT NULL, `actor_id` INT(11) DEFAULT NULL, `meta` TEXT DEFAULT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_payment` (`payment_id`), KEY `idx_action` (`action`), KEY `idx_date` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
23/04/2026 - 10:27:14 [ OPERATION OK ] CREATE TABLE IF NOT EXISTS `oc_t_usc_events_log` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `event_type` VARCHAR(50) NOT NULL, `payload` TEXT DEFAULT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_event` (`event_type`), KEY `idx_date` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
23/04/2026 - 10:27:14 [ OPERATION OK ] CREATE TABLE IF NOT EXISTS `oc_t_usc_notifications` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `user_id` INT(11) UNSIGNED NOT NULL, `type` VARCHAR(30) NOT NULL DEFAULT 'info', `title` VARCHAR(120) NOT NULL DEFAULT '', `message` VARCHAR(500) NOT NULL DEFAULT '', `icon` VARCHAR(10) DEFAULT NULL, `link` VARCHAR(255) DEFAULT NULL, `is_read` TINYINT(1) NOT NULL DEFAULT 0, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_user` (`user_id`), KEY `idx_read` (`is_read`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
23/04/2026 - 10:27:14 [ OPERATION OK ] CREATE TABLE IF NOT EXISTS `oc_t_usc_analytics` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `user_id` INT(11) UNSIGNED NOT NULL DEFAULT 0, `event` VARCHAR(50) NOT NULL DEFAULT '', `meta` VARCHAR(500) DEFAULT NULL, `ip` VARCHAR(45) DEFAULT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_user` (`user_id`), KEY `idx_event` (`event`), KEY `idx_date` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
23/04/2026 - 10:27:14 [ OPERATION OK ] Connection with 'rankrise_iwitintn9' released properly

Recherche

Prix

Condition

Transaction

Période

Paramètres supplémentaires

Aucune annonce trouvée