db/migrations/1.27_step_147_mail_activationlink.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
25
26
27
28
29
30
31

<?php

/*
 * 02_step_102_datenfeldtypen.php - migration for StEP00102
 *
 * Copyright (C) 2008 - Florian Ludwig (dino@phidev.org)
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License as
 * published by the Free Software Foundation; either version 2 of
 * the License, or (at your option) any later version.
 */


class Step147MailActivationLink extends Migration
{
    public function description()
    {
        return 'modify db schema for StEP00147 to provide validation key attribute';
    }

    public function up()
    {
        DBManager::get()->exec("ALTER TABLE `auth_user_md5` ADD `validation_key` VARCHAR(10) NOT NULL AFTER `Email`");
    }

    public function down()
    {
        DBManager::get()->exec("ALTER TABLE `auth_user_md5` DROP `validation_key`");
    }
}