BossBey File Manager
PHP:
8.2.28
OS:
Linux
User:
www-data
Root
/
var
/
www
/
alfrieda
/
wordpress
/
wp-content
/
plugins
/
wp-reviews-plugin-for-google
/
include
📤 Upload
📝 New File
📁 New Folder
Close
Editing: schema.php
<?php defined('ABSPATH') or die('No script kiddies please!'); $ti_db_schema = [ 'reviews' => " CREATE TABLE ". $tiReviewsTableName ." ( `id` TINYINT(1) NOT NULL AUTO_INCREMENT, `hidden` TINYINT(1) NOT NULL DEFAULT 0, `user` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci, `user_photo` TEXT, `text` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `rating` DECIMAL(3,1), `highlight` VARCHAR(11), `date` DATE, `reviewId` TEXT, `reply` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, PRIMARY KEY (`id`) ) ", 'views' => " CREATE TABLE ". $tiViewsTableName ." ( `date` DATE NOT NULL, `viewed` BIGINT(20) NOT NULL, PRIMARY KEY (`date`) ) " ]; ?>
Save
Cancel