webcol / Calima

	/**

	 * @see QueryWriter::addUniqueIndex

	 */

	public function addUniqueConstraint( $type, $properties )

	{

		$tableNoQ = $this->esc( $type, TRUE );

		$columns = array();

		foreach( $properties as $key => $column ) $columns[$key] = $this->esc( $column );

		$table = $this->esc( $type );

		sort( $columns ); // Else we get multiple indexes due to order-effects

		$name = 'UQ_' . sha1( implode( ',', $columns ) );

		try {

			$sql = "ALTER TABLE $table

						 ADD UNIQUE INDEX $name (" . implode( ',', $columns ) . ")";

			$this->adapter->exec( $sql );

		} catch ( SQLException $e ) {

			//do nothing, dont use alter table ignore, this will delete duplicate records in 3-ways!

			return FALSE;

		}

		return TRUE;

	}

	/**

	 * @see QueryWriter::addIndex

	/**

	 * @see QueryWriter::addUniqueIndex

	 */

	public function addUniqueConstraint( $type, $properties )

	{

		$tableNoQ = $this->esc( $type, TRUE );

		$columns = array();

		foreach( $properties as $key => $column ) $columns[$key] = $this->esc( $column );

		$table = $this->esc( $type );

		sort( $columns ); //else we get multiple indexes due to order-effects

		$name = "UQ_" . sha1( $table . implode( ',', $columns ) );

		$sql = "ALTER TABLE {$table}

                ADD CONSTRAINT $name UNIQUE (" . implode( ',', $columns ) . ")";

		try {

			$this->adapter->exec( $sql );

		} catch( SQLException $e ) {

			return FALSE;

		}

		return TRUE;

	}

	/**

	 * @see QueryWriter::sqlStateIn