| 123456789101112 |
- -- MySQL schema for contract_status
- CREATE TABLE IF NOT EXISTS contract_status (
- clientid VARCHAR(64) PRIMARY KEY,
- sent TINYINT(1) DEFAULT 0,
- sent_at DATETIME NULL,
- signed TINYINT(1) DEFAULT 0,
- signed_at DATETIME NULL,
- last_email_to VARCHAR(255) NULL,
- pdf_path VARCHAR(255) NULL,
- signer_name VARCHAR(255) NULL,
- signer_ip VARCHAR(45) NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
