Question to Core developers [Upgrader Stream Module]

randomdude

I found two places to put your SQL into. One on the setup folder that will be deleted upon finished installation and the other on on the "Upgrader Stream" module.

What is the process into creating a new SQL patch file? During the first time setup of the osTicket. Will the upgrade streamer run after setup apply the install-mysql.sql file?

Thanks

KevinTheJedi

randomdude

Upgrader streams directory contains only patches and tasks for upgrades. For new installs the structure comes from the install-mysql file and the data comes from YAML files in the en_US lang pack.

Cheers.

randomdude

KevinTheJedi Let me rephrase my question. How can I create a new upgrade task on my own?

For example I went to add an example patch file 00000000-000000001.patch.sql

/**
 * @version v1.17-tree
 * @signature c577f3df105981ceb77cd00a803e98bb
 * @title Add new index
 *
 */

-- Some SQL here and there

UPDATE `%TABLE_PREFIX%config`
    SET `value` = 'c577f3df105981ceb77cd00a803e98bb'
    WHERE `key` = 'schema_signature' AND `namespace` = 'core';

Then according to docs I found about the streamer.md I need to add this signature I made randomly to core.sig.

commit: 95d35fc066dde2e170440dcd9b2845a4de416827

83a22ba22b1a6a624fcb1da03882ac1b
c577f3df105981ceb77cd00a803e98bb

But this does not work and it throws error that the signature was invalid for some reason

KevinTheJedi

randomdude

The signature is an MD5 hash of the install-mysql file. You make the needed changes there for new install and then make a new MD5 hash.

Cheers.