Skip to content

Instantly share code, notes, and snippets.

@benwbrum
Created January 28, 2019 22:32
Show Gist options
  • Select an option

  • Save benwbrum/4b50b6ea6936a333148b2a90a05b0142 to your computer and use it in GitHub Desktop.

Select an option

Save benwbrum/4b50b6ea6936a333148b2a90a05b0142 to your computer and use it in GitHub Desktop.

Ben's development machine:

 CREATE TABLE `refinery_authentication_devise_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `encrypted_password` varchar(255) NOT NULL,
  `current_sign_in_at` datetime DEFAULT NULL,
  `last_sign_in_at` datetime DEFAULT NULL,
  `current_sign_in_ip` varchar(255) DEFAULT NULL,
  `last_sign_in_ip` varchar(255) DEFAULT NULL,
  `sign_in_count` int(11) DEFAULT NULL,
  `remember_created_at` datetime DEFAULT NULL,
  `reset_password_token` varchar(255) DEFAULT NULL,
  `reset_password_sent_at` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `userid_detail_id` varchar(255) DEFAULT NULL,
  `password_salt` varchar(255) DEFAULT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_refinery_authentication_devise_users_on_id` (`id`),
  KEY `index_refinery_authentication_devise_users_on_slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=8564 DEFAULT CHARSET=latin1;

CREATE TABLE `refinery_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `encrypted_password` varchar(255) NOT NULL,
  `current_sign_in_at` datetime DEFAULT NULL,
  `last_sign_in_at` datetime DEFAULT NULL,
  `current_sign_in_ip` varchar(255) DEFAULT NULL,
  `last_sign_in_ip` varchar(255) DEFAULT NULL,
  `sign_in_count` int(11) DEFAULT NULL,
  `remember_created_at` datetime DEFAULT NULL,
  `reset_password_token` varchar(255) DEFAULT NULL,
  `reset_password_sent_at` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `userid_detail_id` varchar(255) DEFAULT NULL,
  `password_salt` varchar(255) DEFAULT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_refinery_users_on_id` (`id`),
  KEY `index_refinery_users_on_slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=8460 DEFAULT CHARSET=latin1;

On test3

 CREATE TABLE `refinery_authentication_devise_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `encrypted_password` varchar(255) NOT NULL,
  `current_sign_in_at` datetime DEFAULT NULL,
  `last_sign_in_at` datetime DEFAULT NULL,
  `current_sign_in_ip` varchar(255) DEFAULT NULL,
  `last_sign_in_ip` varchar(255) DEFAULT NULL,
  `sign_in_count` int(11) DEFAULT NULL,
  `remember_created_at` datetime DEFAULT NULL,
  `reset_password_token` varchar(255) DEFAULT NULL,
  `reset_password_sent_at` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `userid_detail_id` varchar(255) DEFAULT NULL,
  `password_salt` varchar(255) DEFAULT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_refinery_authentication_devise_users_on_id` (`id`),
  KEY `index_refinery_authentication_devise_users_on_slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=8678 DEFAULT CHARSET=latin1



test3 does not have the refinery_users table.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment