| Server IP : 173.209.174.21 / Your IP : 216.73.216.89 Web Server : Apache/2.4.58 (Ubuntu) System : Linux wcfs-server 6.8.0-124-generic #124-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 13:00:45 UTC 2026 x86_64 User : nodor ( 1000) PHP Version : 8.3.6 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/wcfs/pest/database/ |
Upload File : |
CREATE TABLE customers ( id VARCHAR(64) NOT NULL, name VARCHAR(255) DEFAULT '', firm VARCHAR(255) DEFAULT '', sites JSON NULL, created_at VARCHAR(40) NOT NULL, updated_at VARCHAR(40) NOT NULL, PRIMARY KEY (id), INDEX idx_customers_name (name), INDEX idx_customers_firm (firm) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE pesticide_records ( id VARCHAR(64) NOT NULL, record_name VARCHAR(255) DEFAULT '', application_date DATE NULL, method VARCHAR(80) DEFAULT '', site_type VARCHAR(255) DEFAULT '', area_treated VARCHAR(120) DEFAULT '', permit_number VARCHAR(120) DEFAULT '', location TEXT NULL, customer_name VARCHAR(255) DEFAULT '', customer_firm VARCHAR(255) DEFAULT '', customer_street VARCHAR(255) DEFAULT '', customer_city VARCHAR(120) DEFAULT '', customer_state VARCHAR(20) DEFAULT '', customer_zip VARCHAR(40) DEFAULT '', applicator_name VARCHAR(255) DEFAULT '', applicator_license VARCHAR(120) DEFAULT '', applicator_firm VARCHAR(255) DEFAULT '', applicator_phone VARCHAR(80) DEFAULT '', applicator_street VARCHAR(255) DEFAULT '', applicator_city_state_zip VARCHAR(255) DEFAULT '', start_time VARCHAR(20) DEFAULT '', end_time VARCHAR(20) DEFAULT '', temperature VARCHAR(80) DEFAULT '', wind_direction VARCHAR(80) DEFAULT '', wind_velocity VARCHAR(80) DEFAULT '', equipment VARCHAR(255) DEFAULT '', weather_lookup_enabled TINYINT(1) NOT NULL DEFAULT 0, weather_zip VARCHAR(40) DEFAULT '', weather_lat VARCHAR(80) DEFAULT '', weather_lon VARCHAR(80) DEFAULT '', notes TEXT NULL, pesticides JSON NULL, created_at VARCHAR(40) NOT NULL, updated_at VARCHAR(40) NOT NULL, PRIMARY KEY (id), INDEX idx_records_customer (customer_name), INDEX idx_records_application_date (application_date), INDEX idx_records_updated_at (updated_at) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;