title: Cannot create more than one clustered index on table
body: <p>I am having the following error after typing update-database:</p>
  
  <blockquote>
    <p>Cannot create more than one clustered index on table 'dbo.AppUsers'. Drop the existing clustered index 'PK_dbo.AppUsers' before creating another.</p>
  </blockquote>
  
  <p>I am working on an Azure mobile service.</p>
  
  <p>I have three data models:</p>
  
  <pre><code>public class AppUser : EntityData
  {
      public string Username { get; set; }
      public virtual ICollection&lt;RatingItem&gt; userRatings { get; set; }
  }
  
  public class PlaceItem : EntityData
  {
      public string PlaceName { get; set; }
      public int Group { get; set; }
      public string XCoordinate { get; set; }
      public string YCoordinate { get; set; }
  }
  
  public class RatingItem : EntityData
  {
      public int Ratings { get; set; }
      public string PlaceId { get; set; }
      public AppUser user { get; set; }
  }
  </code></pre>
  
  <p>It has to do with migration because :</p>
  
  <ul>
  <li>The initial create is in the <strong>_MigrationHistory</strong> table, but isn't in the migration folder in the solution explorer.</li>
  <li>When I add-migration AddAll, I don't get any errors, and AddAll appears in the migration folder, but not in the table.</li>
  </ul>
  
  <p>In the context file:</p>
  
  <pre><code>public class ICbackendContext : DbContext
  {
          public DbSet&lt;AppUser&gt; AppUsers { get; set; }
          public DbSet&lt;PlaceItem&gt; PlaceItems { get; set; }
          public DbSet&lt;RatingItem&gt; RatingItems { get; set; }
  </code></pre>
  
  <p>}</p>