Subversion Repositories oidplus

<?php

/*

 * OIDplus 2.0

 * Copyright 2020 Daniel Marschall, ViaThinkSoft

 *

 * Licensed under the Apache License, Version 2.0 (the "License");

 * you may not use this file except in compliance with the License.

 * You may obtain a copy of the License at

 *

 *     http://www.apache.org/licenses/LICENSE-2.0

 *

 * Unless required by applicable law or agreed to in writing, software

 * distributed under the License is distributed on an "AS IS" BASIS,

 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

 * See the License for the specific language governing permissions and

 * limitations under the License.

 */

// DATABASE UPDATE 201 -> 202

// This script will be included by OIDplusDatabaseConnection.class.php inside function afterConnect().

// Parameters: $this is the OIDplusDatabaseConnection class

//             $version is the current version (this script MUST increase the number by 1 when it is done)

if (!isset($version)) throw new OIDplusException(_L('Argument "%1" is missing; was the file included in a wrong way?','version'));

if (!isset($this))    throw new OIDplusException(_L('Argument "%1" is missing; was the file included in a wrong way?','this'));

if ($this->transaction_supported()) $this->transaction_begin();

// Change bit(1) types to boolean/tinyint(1)

if ($this->getSlang()::id() == 'pgsql') {

        $this->query("alter table ###config  alter protected    drop default");

        $this->query("alter table ###config  alter protected    type boolean using get_bit(protected   ,0)::boolean");

        $this->query("alter table ###config  alter protected    set default false");

        $this->query("alter table ###config  alter visible      drop default");

        $this->query("alter table ###config  alter visible      type boolean using get_bit(visible     ,0)::boolean");

        $this->query("alter table ###config  alter visible      set default false");

        $this->query("alter table ###asn1id  alter standardized drop default");

        $this->query("alter table ###asn1id  alter standardized type boolean using get_bit(standardized,0)::boolean");

        $this->query("alter table ###asn1id  alter standardized set default false");

        $this->query("alter table ###asn1id  alter well_known   drop default");

        $this->query("alter table ###asn1id  alter well_known   type boolean using get_bit(well_known  ,0)::boolean");

        $this->query("alter table ###asn1id  alter well_known   set default false");

        $this->query("alter table ###iri     alter longarc      drop default");

        $this->query("alter table ###iri     alter longarc      type boolean using get_bit(longarc     ,0)::boolean");

        $this->query("alter table ###iri     alter longarc      set default false");

        $this->query("alter table ###iri     alter well_known   drop default");

        $this->query("alter table ###iri     alter well_known   type boolean using get_bit(well_known  ,0)::boolean");

        $this->query("alter table ###iri     alter well_known   set default false");

        $this->query("alter table ###objects alter confidential type boolean using get_bit(confidential,0)::boolean");

        $this->query("alter table ###ra      alter privacy      drop default");

        $this->query("alter table ###ra      alter privacy      type boolean using get_bit(privacy     ,0)::boolean");

        $this->query("alter table ###ra      alter privacy      set default false");

} else if ($this->getSlang()::id() == 'mysql') {

        $this->query("alter table ###config  modify protected    boolean");

        $this->query("alter table ###config  modify visible      boolean");

        $this->query("alter table ###asn1id  modify standardized boolean");

        $this->query("alter table ###asn1id  modify well_known   boolean");

        $this->query("alter table ###iri     modify longarc      boolean");

        $this->query("alter table ###iri     modify well_known   boolean");

        $this->query("alter table ###objects modify confidential boolean");

        $this->query("alter table ###ra      modify privacy      boolean");

}

// Rename log_user.user to log_user.username, since user is a keyword in PostgreSQL and MSSQL

if ($this->getSlang()::id() == 'pgsql') {

        $this->query("alter table ###log_user rename column \"user\" to \"username\"");

} else if ($this->getSlang()::id() == 'mysql') {

        $this->query("alter table ###log_user change `user` `username` varchar(255) NOT NULL");

}

$version = 202;

$this->query("UPDATE ###config SET value = ? WHERE name = 'database_version'", array($version));

if ($this->transaction_supported()) $this->transaction_commit();