{"slug":"bitlence-dev-code-tracker","name":"Bitlence Dev Code Tracker","description":"Track time spent in wp-admin per page/post with idle detection, a 30-day chart, streak tracker, and per-page breakdown.","author":"Kuldipsinh Parmar","active_installs":0,"version":"1.2.0","wp_org_url":"https://wordpress.org/plugins/bitlence-dev-code-tracker/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"bdct_daily_summary","full_table_name":"wp_bdct_daily_summary","description":"Stores bdct daily summary data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"summary_date","type":"DATE","nullable":false,"primary_key":false},{"name":"total_sec","type":"INT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_bdct_daily_summary ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL, summary_date DATE NOT NULL, total_sec INT NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY user_date (user_id, summary_date) ) $charset;\" );"},{"table_name":"bdct_time_sessions","full_table_name":"wp_bdct_time_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"post_id","type":"INT","nullable":true,"primary_key":false},{"name":"post_type","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"admin_page","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"started_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"ended_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"duration_sec","type":"INT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_bdct_time_sessions ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL, post_id INT DEFAULT NULL, post_type VARCHAR(50) DEFAULT NULL, admin_page VARCHAR(100) DEFAULT NULL, started_at DATETIME NOT NULL, ended_at DATETIME NOT NULL, duration_sec INT NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY user_id (user_id), KEY started_at (started_at) ) $charset;\" );"}],"table_count":2}