{"slug":"phildesigns-client-review","name":"PhilDesigns Client Review","description":"Invite clients to preview your site privately, drop visual pin annotations, and submit a formatted review summary by email.","author":"phildesigns","active_installs":0,"version":"1.2.0","wp_org_url":"https://wordpress.org/plugins/phildesigns-client-review/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"cr_annotations","full_table_name":"wp_cr_annotations","description":"Stores cr annotations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cr_invites","full_table_name":"wp_cr_invites","description":"Stores cr invites data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"token","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"label","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"created_by","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"expires_at","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"page_url","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"device","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"x_percent","type":"decimal(8,4)","nullable":false,"primary_key":false},{"name":"y_percent","type":"decimal(8,4)","nullable":false,"primary_key":false},{"name":"comment","type":"text","nullable":false,"primary_key":false},{"name":"status","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"admin_note","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cr_invites ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, token varchar(64) NOT NULL, label varchar(255) NOT NULL DEFAULT '', created_by bigint(20) UNSIGNED NOT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, expires_at datetime DEFAULT NULL, user_id bigint(20) UNSIGNED DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY token (token) ) $charset;\"; $annotations = \"CREATE TABLE wp_cr_annotations ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id bigint(20) UNSIGNED NOT NULL, page_url varchar(500) NOT NULL, device varchar(20) NOT NULL DEFAULT 'desktop', x_percent decimal(8,4) NOT NULL DEFAULT 0, y_percent decimal(8,4) NOT NULL DEFAULT 0, comment text NOT NULL, status varchar(30) NOT NULL DEFAULT 'open', admin_note text 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), KEY user_id (user_id), KEY page_url (page_url(191)) ) $charset;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $invites );"}],"table_count":2}