wikimedia / mediawiki

	protected function setDefault( $table, $field, $default ) {

		$info = $this->db->fieldInfo( $table, $field );

		if ( $info->defaultValue() !== $default ) {

			$this->output( "Changing '$table.$field' default value\n" );

			$this->db->query( "ALTER TABLE $table ALTER $field SET DEFAULT " . $default );

		}

	}

	protected function changeNullableField( $table, $field, $null ) {

		}

		if ( $fi->isNullable() ) {

			# # It's NULL - does it need to be NOT NULL?

			if ( 'NOT NULL' === $null ) {

				$this->output( "Changing '$table.$field' to not allow NULLs\n" );

				$this->db->query( "ALTER TABLE $table ALTER $field SET NOT NULL" );

			} else {

				$this->output( "...column '$table.$field' is already set as NULL\n" );

			}

		} else {

			# # It's NOT NULL - does it need to be NULL?

			if ( 'NULL' === $null ) {

			}

		} else {

			# # It's NOT NULL - does it need to be NULL?

			if ( 'NULL' === $null ) {

				$this->output( "Changing '$table.$field' to allow NULLs\n" );

				$this->db->query( "ALTER TABLE $table ALTER $field DROP NOT NULL" );

			} else {

				$this->output( "...column '$table.$field' is already set as NOT NULL\n" );

			}

		}

	}