CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'preview id from storage',
  `image_path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `nh_id` int(11) DEFAULT NULL,
  `invited_by` int(10) unsigned NOT NULL DEFAULT '0',
  `facebook_user_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `twitter_user_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `google_user_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `calendly` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `shipping_address1` varchar(1080) COLLATE utf8_unicode_ci DEFAULT NULL,
  `shipping_address2` varchar(1080) COLLATE utf8_unicode_ci DEFAULT NULL,
  `shipping_country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `shipping_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `shipping_zip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `shipping_city` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `self_serv` int(11) NOT NULL DEFAULT '0',
  `password_old` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `salt_old` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `stripe_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `card_brand` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `card_last_four` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `trial_ends_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=235861 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'anonymous','','[email protected]','d41d8cd98f00b204e9800998ecf8427e',0,'','2017-03-01 05:54:46',0,0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,'','',NULL,'2017-03-01 05:54:46','2017-03-01 05:54:46',NULL,NULL,NULL,NULL,NULL),(5,'Zhang','Aleax','[email protected]','d41d8cd98f00b204e9800998ecf8427e',0,'data/avatar/100004701638626.jpg','2012-12-05 03:06:02',11,0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,'','',NULL,'2012-12-05 03:06:02','2017-03-01 05:54:46',NULL,NULL,NULL,NULL,NULL),(7,'Greg','Mousseau','[email protected]','d41d8cd98f00b204e9800998ecf8427e',0,'data/avatar/58004560.jpg','2012-12-12 10:52:49',11,0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',0,'','',NULL,'2012-12-12 10:52:49','2017-03-01 05:54:46',NULL,NULL,NULL,NULL,NULL)