| 123456789101112131415161718192021 |
- -- Audit Express — création de table (exécuter si install.php ne peut pas tourner)
- -- Remplacer `modx_` par votre préfixe MODX réel.
- CREATE TABLE IF NOT EXISTS `modx_audit_requests` (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `audit_uid` VARCHAR(36) NOT NULL DEFAULT '',
- `pack_id` VARCHAR(64) NOT NULL DEFAULT '',
- `answers` TEXT DEFAULT NULL,
- `optional_data` TEXT DEFAULT NULL,
- `result` MEDIUMTEXT DEFAULT NULL,
- `email` VARCHAR(255) DEFAULT NULL,
- `status` ENUM('draft','completed','emailed') NOT NULL DEFAULT 'draft',
- `ip_hash` VARCHAR(64) DEFAULT NULL,
- `step` TINYINT(3) NOT NULL DEFAULT 0,
- `created_at` DATETIME NOT NULL,
- `updated_at` DATETIME NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `audit_uid` (`audit_uid`),
- KEY `status` (`status`),
- KEY `created_at` (`created_at`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|