wp_lsm_clients

Column Definitions

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS `wp_lsm_clients` ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id bigint(20) UNSIGNED DEFAULT NULL, first_name varchar(100) NOT NULL, last_name varchar(100) NOT NULL, email varchar(100) NOT NULL, phone varchar(20) DEFAULT NULL, address text DEFAULT NULL, notes text DEFAULT NULL, status varchar(20) DEFAULT 'active', created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), UNIQUE KEY email (email) ) $charset_collate;"; // Cases Table $tables[] = "CREATE TABLE IF NOT EXISTS `wp_lsm_cases` ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, client_id bigint(20) UNSIGNED NOT NULL, case_number varchar(50) NOT NULL, title varchar(255) NOT NULL, description text DEFAULT NULL, priority varchar(20) DEFAULT 'medium', court_info text DEFAULT NULL, hearing_dates text DEFAULT NULL, financial_value decimal(15,2) DEFAULT 0.00, status varchar(20) DEFAULT 'open', assigned_lawyer_id bigint(20) UNSIGNED DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY client_id (client_id), KEY assigned_lawyer_id (assigned_lawyer_id), UNIQUE KEY case_number (case_number) ) $charset_collate;"; // Services Table $tables[] = "CREATE TABLE IF NOT EXISTS `wp_lsm_services` ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, description text DEFAULT NULL, base_price decimal(15,2) DEFAULT 0.00, duration int(11) DEFAULT 60, status varchar(20) DEFAULT 'active', created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;"; // Appointments Table $tables[] = "CREATE TABLE IF NOT EXISTS `wp_lsm_appointments` ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, client_id bigint(20) UNSIGNED NOT NULL, service_id bigint(20) UNSIGNED DEFAULT NULL, case_id bigint(20) UNSIGNED DEFAULT NULL, lawyer_id bigint(20) UNSIGNED NOT NULL, appointment_date datetime NOT NULL, duration int(11) NOT NULL, location_type varchar(20) DEFAULT 'in-person', location_details text DEFAULT NULL, notes text DEFAULT NULL, status varchar(20) DEFAULT 'scheduled', created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY client_id (client_id), KEY lawyer_id (lawyer_id), KEY appointment_date (appointment_date) ) $charset_collate;"; // Invoices Table $tables[] = "CREATE TABLE IF NOT EXISTS `wp_lsm_invoices` ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, client_id bigint(20) UNSIGNED NOT NULL, case_id bigint(20) UNSIGNED DEFAULT NULL, invoice_number varchar(50) NOT NULL, amount decimal(15,2) NOT NULL, tax decimal(15,2) DEFAULT 0.00, total decimal(15,2) NOT NULL, status varchar(20) DEFAULT 'unpaid', due_date date DEFAULT NULL, payment_method varchar(50) DEFAULT NULL, transaction_id varchar(100) DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY client_id (client_id), UNIQUE KEY invoice_number (invoice_number) ) $charset_collate;"; // Documents Table $tables[] = "CREATE TABLE IF NOT EXISTS `wp_lsm_documents` ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, client_id bigint(20) UNSIGNED DEFAULT NULL, case_id bigint(20) UNSIGNED DEFAULT NULL, title varchar(255) NOT NULL, file_path text NOT NULL, file_type varchar(50) DEFAULT NULL, template_id bigint(20) UNSIGNED DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY client_id (client_id), KEY case_id (case_id) ) $charset_collate;"; // Notifications Table $tables[] = "CREATE TABLE IF NOT EXISTS `wp_lsm_notifications` ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id bigint(20) UNSIGNED NOT NULL, message text NOT NULL, type varchar(50) DEFAULT 'info', is_read tinyint(1) DEFAULT 0, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), KEY is_read (is_read) ) $charset_collate;"; // Activity Logs Table $tables[] = "CREATE TABLE IF NOT EXISTS `wp_lsm_activity_logs` ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id bigint(20) UNSIGNED DEFAULT NULL, action varchar(255) NOT NULL, object_type varchar(50) DEFAULT NULL, object_id bigint(20) UNSIGNED DEFAULT NULL, ip_address varchar(45) DEFAULT NULL, user_agent text DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id) ) $charset_collate;"; // Sessions Table $tables[] = "CREATE TABLE IF NOT EXISTS `wp_lsm_sessions` ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id bigint(20) UNSIGNED NOT NULL, session_token varchar(255) NOT NULL, ip_address varchar(45) DEFAULT NULL, last_activity datetime DEFAULT CURRENT_TIMESTAMP, expires_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY session_token (session_token), KEY user_id (user_id) ) $charset_collate;"; foreach ($tables as $sql) { dbDelta($sql);

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_lsm_clients`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Legal Services Management