Files
SGF/scripts/sgf-service-documents-schema.php
2026-11-11 09:00:17 +02:00

5 lines
517 B
PHP

<?php
$book=$argv[1]??'regression';require __DIR__.'/sgf-single-bootstrap.php';
if(!$host->getSchemaBuilder()->hasTable('sd_versions'))$host->transaction(function()use($host,$repo){$host->unprepared(file_get_contents($repo.'/database/sql/service_documents.sql'));foreach(['sd_versions_id_seq','sd_outputs_id_seq','sd_commands_id_seq'] as $seq)$host->statement('REVOKE ALL ON SEQUENCE '.$seq.' FROM PUBLIC');});
echo json_encode(['passed'=>true,'book'=>$book,'new_tables'=>3,'old_tables_not_migrated'=>true]).PHP_EOL;