@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix schema: <https://schema.org/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .

<https://knobit.org/id/task/ddl-review/I5> a edu:Question ;
    rdfs:label "I5 (2 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    schema:hasPart <https://knobit.org/id/register/data-modelling#I-815>,
        <https://knobit.org/id/register/data-modelling#I-816> ;
    schema:identifier "I5" ;
    schema:position 8 ;
    schema:text "Deployment, 1 each: (a) tightening payout_iban to NOT NULL cannot be deployed by running this greenfield DDL against a populated database where 3% of migrated rows are null - it needs a backfill and a hand-written migration, and the generated diff is the statement of intent; (b) 99_drop_tables.sql is not a rollback for a migration, and the runbook step that uses it would remove the data."@en .

edu:Question rdfs:label "Question"@en,
        "Küsimus"@et .

<https://knobit.org/id/register/data-modelling#I-815> rdfs:label "ddl-review I5a: greenfield DDL against a populated table"@en .

<https://knobit.org/id/register/data-modelling#I-816> rdfs:label "ddl-review I5b: drop script as rollback"@en .