SQLize | PHPize | SQLtest

CREATE TABLE `marc_import_queue` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `client_id` int(11) unsigned DEFAULT NULL, `detected_time` datetime DEFAULT NULL, `ready_time` datetime DEFAULT NULL, `start_time` datetime DEFAULT NULL, `state` enum('LOCAL','RUNNING','UPLOADING','READY') DEFAULT NULL, `file_name` varchar(128) DEFAULT NULL, `file_timestamp` timestamp NULL DEFAULT NULL, `file_size` bigint(20) unsigned DEFAULT 0, `target` enum('MONGODB','OPENSEARCH','TYPESENSE') DEFAULT NULL, `log` varchar(512) DEFAULT NULL, `file_date` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; INSERT INTO marc_import_queue (client_id, state, file_name, file_size, file_date, target, detected_time) VALUES (377, 'UPLOADING', 'test.mrc', 1234, FROM_UNIXTIME(12345678), 'TYPESENSE', NOW()); -- fetch SELECT * FROM marc_import_queue;