This repository has been archived on 2024-11-28. You can view files and clone it, but cannot push or open issues or pull requests.
Incam_SGD/sql/mysql/upgrade/3.0.3.4/bulk_export_transaction.sql

9 lines
510 B
SQL

TRUNCATE `zseq_document_transaction_types_lookup`;
INSERT INTO `zseq_document_transaction_types_lookup` SELECT MAX(`id`) FROM `document_transaction_types_lookup`;
SELECT @foo:=id + 1 FROM `zseq_document_transaction_types_lookup`;
INSERT INTO document_transaction_types_lookup VALUES (@foo, 'Bulk Export', 'ktstandard.transactions.bulk_export');
TRUNCATE `zseq_document_transaction_types_lookup`;
INSERT INTO `zseq_document_transaction_types_lookup` SELECT MAX(`id`) FROM `document_transaction_types_lookup`;