CreateRnRFormSignature.java

/*
 * This program is part of the OpenLMIS logistics management information
 * system platform software.
 *
 * Copyright © 2015 ThoughtWorks, Inc.
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published
 * by the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version. This program is distributed in the
 * hope that it will be useful, but WITHOUT ANY WARRANTY; without even the
 * implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 * See the GNU Affero General Public License for more details. You should
 * have received a copy of the GNU Affero General Public License along with
 * this program. If not, see http://www.gnu.org/licenses. For additional
 * information contact info@OpenLMIS.org
 */

package org.openlmis.core.persistence.migrations;

import org.openlmis.core.persistence.Migration;

public class CreateRnRFormSignature extends Migration {
    @Override
    public void up() {
        execSQL("CREATE TABLE `rnr_form_signature` (`form_id` BIGINT, `signature` VARCHAR, `type` VARCHAR ,`id` INTEGER PRIMARY KEY AUTOINCREMENT)");
        execSQL("CREATE UNIQUE INDEX `rnr_form_signature_id_idx` ON `rnr_form_signature` ( `id` )");
    }
}