#120 ✓resolved
Dae San Hwang

index duplication?

Reported by Dae San Hwang | January 2nd, 2008 @ 01:44 PM

When unique index is defined inline, two indices are created. (one unique, and one non-unique)

class User < DataMapper::Base
  property :login, :string, :nullable => false, :index => :unique

mysql> show create table users;

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(50) NOT NULL,
  UNIQUE KEY `login` (`login`),
  KEY `users_login_index` (`login`)

Comments and changes to this ticket

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

People watching this ticket