db/migrations/1.62_gender_iso_5218.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

<?php

class GenderIso5218 extends Migration
{
    function description()
    {
        return 'make gender representation match ISO 5218';
    }

    function up()
    {
        $db = DBManager::get();

        $db->exec("UPDATE user_info SET geschlecht = 2 WHERE geschlecht = 1");
    }

    function down()
    {
        $db = DBManager::get();

        $db->exec("UPDATE user_info SET geschlecht = 0 WHERE geschlecht = 1");
        $db->exec("UPDATE user_info SET geschlecht = 1 WHERE geschlecht = 2");
    }
}