title: django.db.utils.IntegrityError in Custom UserModel
body: <p>Custom User Model:</p>
  
  <pre><code>class User(AbstractBaseUser):
      id = models.AutoField(primary_key=True)
      username = models.CharField(max_length=30)
      email = models.EmailField(unique=True,max_length=75)
      test = models.CharField(max_length=20)
  
      USERNAME_FIELD = 'email'
  
      class Meta:
          managed = False
          db_table = 'auth_user'
  </code></pre>
  
  <p>On running <code>./manage.py migrate</code>, I get the following error:</p>
  
  <pre><code>django.db.utils.IntegrityError: (1215, 'Cannot add foreign key constraint')
  </code></pre>
  
  <p><code>SHOW ENGINE INNODB STATUS</code> on mysql shows:</p>
  
  <pre><code>2015-07-12 19:29:25 133f4a000 Error in foreign key constraint of table edutraffic/#sql-55ea_17a:
   FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`):
  Cannot resolve table name close to:
   (`id`)
  </code></pre>
  
  <p>So, I deleted the complete database and recreated it, still getting the same error.</p>
  
  <p><code>settings.py</code> file:</p>
  
  <pre><code>AUTH_USER_MODEL = 'users.User'
  INSTALLED_APPS = (
      'django.contrib.admin',
      'django.contrib.auth',
      'django.contrib.contenttypes',
      'django.contrib.sessions',
      'django.contrib.staticfiles',
      'django.contrib.sites',
      'rest_framework',
      'rest_framework.authtoken',
      'rest_auth',
      'allauth',
      'allauth.account',
      'rest_auth.registration',
      'allauth.socialaccount',
      'allauth.socialaccount.providers.facebook',
      'allauth.socialaccount.providers.google',
  
      'users',
  )
  </code></pre>