From: Adam Hooper
Date: June 29 2004 12:59pm
Subject: Re: adding a column to a table at the END
List-Archive: http://lists.mysql.com/gui-tools/1407
Message-Id: <40E167B1.1020101@densi.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigE3C47E2BC67F6B51D128503D"

--------------enigE3C47E2BC67F6B51D128503D
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

mark mcaulay wrote:
> 3. when viewing the design, it shows indexes as MUL for multiple, when there are indexes on only one column. It would be good to have the distinction between single and multiple column indexes. An example could be colour coding so you can see which index is on which columns.

That's not what MUL means. MUL means that the index is not unique -- 
i.e., you can have several rows with the same indexed column values.

For example, a primary key column (usually an ID) is unique. But if you 
have a database of employees and you want to index them by first name, 
you would not use a unique index on the "first_name" column.

-- 
Adam Hooper
adamh@stripped

--------------enigE3C47E2BC67F6B51D128503D
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Cygwin)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFA4WezD7ySSW2J9egRAuYPAJ9rz1iLQWJanPfd4VUF17S6piPcfgCeP0U/
3jfbVj98rjobXMTKKOEZJiQ=
=ISXW
-----END PGP SIGNATURE-----

--------------enigE3C47E2BC67F6B51D128503D--