salix/db/versions/11342-crimsonDendro/04-itemShelvingLog.sql

9 lines
240 B
MySQL
Raw Permalink Normal View History

/*
2024-11-15 07:45:28 +00:00
CREATE OR REPLACE TEMPORARY TABLE tmp.tItemShelvingLog
(PRIMARY KEY (id))
ENGINE = MEMORY
SELECT ishl.id, s.id shelvingFk
FROM vn.itemShelvingLog ishl
JOIN vn.shelving s ON s.code = ishl.shelvingFk COLLATE utf8mb3_unicode_ci;
*/