| @@ -26,9 +26,9 @@ | ||
| 26 | 26 | * Table name without prefix |
| 27 | 27 | * |
| 28 | 28 | * @var string The base table name without WordPress prefix |
| 29 | 29 | */ |
| 30 | - protected static string $table = 'yatra_new_reviews'; | |
| 30 | + protected static string $table = 'yatra_reviews'; | |
| 31 | 31 | |
| 32 | 32 | /** |
| 33 | 33 | * Get the complete table schema as raw SQL CREATE TABLE statement |
| 34 | 34 | * |
| @@ -53,9 +53,9 @@ | ||
| 53 | 53 | `content` text NOT NULL, |
| 54 | 54 | `author_name` varchar(100) NOT NULL, |
| 55 | 55 | `author_email` varchar(100) DEFAULT NULL, |
| 56 | 56 | `author_location` varchar(100) DEFAULT NULL, |
| 57 | - `status` enum('pending','approved','rejected') DEFAULT 'pending', | |
| 57 | + `status` enum('pending','approved','rejected','spam','trash') DEFAULT 'pending', | |
| 58 | 58 | `helpful_count` int(11) UNSIGNED DEFAULT 0, |
| 59 | 59 | `created_at` datetime DEFAULT CURRENT_TIMESTAMP, |
| 60 | 60 | `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 61 | 61 | `created_by` bigint(20) unsigned DEFAULT NULL COMMENT 'User ID who created this review', |