# Upgrading poweradmin from 2.1.6 to 2.1.7 requires the following manual steps:

## Updating instructions for 2.1.6:

 1. dnf upgrade to 2.1.7
 2. Backup your database
 3. Update database structure (see below)
 4. Execute migration script http://YOUR_HOSTNAME/migrations/201405302318_add_relations_to_zone_templates.php. 
      Later you can remove this file.

## Database Update Instructions

### MySQL

ALTER TABLE users ADD use_ldap BOOLEAN NOT NULL;

ALTER TABLE users ENGINE=InnoDB;
ALTER TABLE perm_items ENGINE=InnoDB;
ALTER TABLE perm_templ ENGINE=InnoDB;
ALTER TABLE perm_templ_items ENGINE=InnoDB;
ALTER TABLE zones ENGINE=InnoDB;
ALTER TABLE zone_templ ENGINE=InnoDB;
ALTER TABLE zone_templ_records ENGINE=InnoDB;
ALTER TABLE domainmetadata ENGINE=InnoDB;
ALTER TABLE cryptokeys ENGINE=InnoDB;
ALTER TABLE tsigkeys ENGINE=InnoDB;
ALTER TABLE domains ENGINE=InnoDB;
ALTER TABLE records ENGINE=InnoDB;
ALTER TABLE supermasters ENGINE=InnoDB;

CREATE TABLE records_zone_templ (
    domain_id INTEGER NOT NULL,
    record_id INTEGER NOT NULL,
    zone_templ_id INTEGER NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE migrations (
    version VARCHAR(255) NOT NULL,
    apply_time INTEGER NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

### PostgreSQL

ALTER TABLE users ADD COLUMN use_ldap smallint NOT NULL DEFAULT 0;

CREATE TABLE records_zone_templ (
    domain_id integer NOT NULL,
    record_id integer NOT NULL,
    zone_templ_id integer NOT NULL
);

CREATE TABLE migrations (
    version varchar(255) NOT NULL,
    apply_time integer NOT NULL
);

### SQLite

ALTER TABLE users ADD use_ldap BOOLEAN NOT NULL DEFAULT 0;

CREATE TABLE records_zone_templ (
    domain_id int(11) NOT NULL,
    record_id int(11) NOT NULL,
    zone_templ_id int(11) NOT NULL
);

CREATE TABLE migrations (
    version varchar(255) NOT NULL,
    apply_time int(11) NOT NULL
);