{"slug":"temporary-login-without-password","name":"Temporary Login Without Password","description":"Create self-expiring, temporary admin accounts. Easily share direct login links (no need for username/password) with your developers or editors.","author":"storeapps","active_installs":100000,"version":"1.9.7","wp_org_url":"https://wordpress.org/plugins/temporary-login-without-password/","is_closed":false,"cleanup":{"has_uninstall_hook":null,"drops_tables_on_uninstall":null,"deletes_options_on_uninstall":null},"tables":[{"table_name":"tlwp_activity_logs","full_table_name":"wp_tlwp_activity_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"alert_id","type":"BIGINT(20)","nullable":true,"primary_key":false},{"name":"object","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"action","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"user_roles","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"username","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"user_id","type":"BIGINT(20)","nullable":true,"primary_key":false},{"name":"post_status","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"post_type","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"post_id","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"created_on","type":"DOUBLE","nullable":false,"primary_key":false},{"name":"client_ip","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"user_agent","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"activity_log_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"meta_key","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"data","type":"longtext","nullable":false,"primary_key":false},{"name":"identifier","type":"char(13)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_tlwp_activity_logs` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `alert_id` BIGINT(20) DEFAULT NULL, `object` VARCHAR(255) NOT NULL, `action` VARCHAR(255) NOT NULL, `user_roles` VARCHAR(255) NOT NULL, `username` VARCHAR(255) NULL, `user_id` BIGINT(20) NULL, `post_status` VARCHAR(255) NOT NULL, `post_type` VARCHAR(255) NOT NULL, `post_id` BIGINT(20) NOT NULL, `created_on` DOUBLE NOT NULL, `client_ip` VARCHAR(255) NOT NULL, `user_agent` VARCHAR(255) NOT NULL, PRIMARY KEY (id) ) $collate; CREATE TABLE `wp_tlwp_activity_logs_meta` ( `meta_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `activity_log_id` BIGINT(20) UNSIGNED NOT NULL, `meta_key` VARCHAR(255) DEFAULT NULL, `meta_value` LONGTEXT DEFAULT NULL, PRIMARY KEY (meta_id), KEY activity_log_id (activity_log_id), KEY meta_key (meta_key) ) $collate; \"; return $tables; } public static function get_tlwp_193_schema( $collate = '' ) { global $wpdb; $tables = \" CREATE TABLE wp_tlwp_user_temp_import ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `data` longtext NOT NULL, `identifier` char(13) NOT NULL, PRIMARY KEY (ID) ) $collate; \"; return $tables; } /** * Collect multiple version schema * * @param string $collate * * @return string * * @since 4.2.0 */ private static function get_schema( $collate = '' ) { $tables = self::get_tlwp_192_schema( $collate );"},{"table_name":"tlwp_activity_logs_meta","full_table_name":"wp_tlwp_activity_logs_meta","description":"Stores additional metadata (key-value pairs) for tlwp activity logs records.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"tlwp_user_temp_import","full_table_name":"wp_tlwp_user_temp_import","description":"Stores tlwp user temp import data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":3}