{"table_name":"cr_invites","full_table_name":"wp_cr_invites","description":"Stores cr invites data created by this plugin.","detection_method":"static","confidence":"medium","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 );","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}],"plugin":{"slug":"phildesigns-client-review","name":"PhilDesigns Client Review","active_installs":0,"version":"1.2.0","wp_org_url":"https://wordpress.org/plugins/phildesigns-client-review/"}}