Aimeos\Upscheme\Task\LocaleRemoveCharConstraints::up()

Complexity

Conditions	8
Paths	5

Size

Total Lines	24
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
	public function up()
	{
		$db = $this->db( 'db-locale' );

		if( !$db->hasTable( 'mshop_locale' ) ) {
			return;
		}

		$this->info( 'Remove mshop_locale char constraints' , 'v' );

		if( $db->hasForeign( 'mshop_locale', 'fk_msloc_langid' )
			&& $db->hasColumn( 'mshop_locale', 'langid' )
			&& $db->table( 'mshop_locale' )->col( 'langid', 'string' )->fixed()
		) {
			$this->info( 'Checking constraint for "langid"', 'v', 1 );
			$db->dropForeign( 'mshop_locale', 'fk_msloc_langid' );
		}

		if( $db->hasForeign( 'mshop_locale', 'fk_msloc_currid' )
			&& $db->hasColumn( 'mshop_locale', 'currencyid' )
			&& $db->table( 'mshop_locale' )->col( 'currencyid', 'string' )->fixed()
		) {
			$this->info( 'Checking constraint for "currencyid"', 'v', 1 );
			$db->dropForeign( 'mshop_locale', 'fk_msloc_currid' );
		}