taps
taps copied to clipboard
ricardochimal
Some default types overridden
When we pull down our database from an AWS RDS instance running 5.5.13 to our Macs running the same version of MySQL we see some default values are overwritten with NULLs.
In this example the email and encrypted_password have NULL inserted in the Default field.
Before:
mysql> explain users;
+------------------------+--------------+------+-----+----------------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+--------------+------+-----+----------------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| email | varchar(255) | NO | UNI | | |
| encrypted_password | varchar(128) | NO | | | |
| reset_password_token | varchar(255) | YES | UNI | NULL | |
| reset_password_sent_at | datetime | YES | | NULL | |
| remember_created_at | datetime | YES | | NULL | |
| sign_in_count | int(11) | YES | | 0 | |
| current_sign_in_at | datetime | YES | | NULL | |
| last_sign_in_at | datetime | YES | | NULL | |
| current_sign_in_ip | varchar(255) | YES | | NULL | |
| last_sign_in_ip | varchar(255) | YES | | NULL | |
| confirmation_token | varchar(255) | YES | UNI | NULL | |
| confirmed_at | datetime | YES | | NULL | |
| confirmation_sent_at | datetime | YES | | NULL | |
| failed_attempts | int(11) | YES | | 0 | |
| unlock_token | varchar(255) | YES | UNI | NULL | |
| locked_at | datetime | YES | | NULL | |
| created_at | datetime | YES | | NULL | |
| updated_at | datetime | YES | | NULL | |
| first_name | varchar(255) | YES | | NULL | |
| last_name | varchar(255) | YES | | NULL | |
| invite_code | varchar(255) | YES | | NULL | |
| company_size | varchar(255) | YES | | NULL | |
| company_sector | varchar(255) | YES | | NULL | |
| company | varchar(255) | YES | | NULL | |
| time_zone | varchar(255) | NO | | Pacific Time (US & Canada) | |
| currency | varchar(3) | NO | | USD | |
| language | varchar(255) | NO | | en-us | |
| summary_period | varchar(255) | NO | | daily | |
| summary_watermark_at | datetime | NO | | 1986-08-25 19:00:44 | |
| summary_hour | int(11) | NO | | 6 | |
+------------------------+--------------+------+-----+----------------------------+----------------+
31 rows in set (0.16 sec)
After:
mysql> explain users;
+------------------------+--------------+------+-----+----------------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+--------------+------+-----+----------------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| email | varchar(255) | NO | UNI | NULL | |
| encrypted_password | varchar(128) | NO | | NULL | |
| reset_password_token | varchar(255) | YES | UNI | NULL | |
| reset_password_sent_at | datetime | YES | | NULL | |
| remember_created_at | datetime | YES | | NULL | |
| sign_in_count | int(11) | YES | | 0 | |
| current_sign_in_at | datetime | YES | | NULL | |
| last_sign_in_at | datetime | YES | | NULL | |
| current_sign_in_ip | varchar(255) | YES | | NULL | |
| last_sign_in_ip | varchar(255) | YES | | NULL | |
| confirmation_token | varchar(255) | YES | UNI | NULL | |
| confirmed_at | datetime | YES | | NULL | |
| confirmation_sent_at | datetime | YES | | NULL | |
| failed_attempts | int(11) | YES | | 0 | |
| unlock_token | varchar(255) | YES | UNI | NULL | |
| locked_at | datetime | YES | | NULL | |
| created_at | datetime | YES | | NULL | |
| updated_at | datetime | YES | | NULL | |
| first_name | varchar(255) | YES | | NULL | |
| last_name | varchar(255) | YES | | NULL | |
| invite_code | varchar(255) | YES | | NULL | |
| company_size | varchar(255) | YES | | NULL | |
| company_sector | varchar(255) | YES | | NULL | |
| company | varchar(255) | YES | | NULL | |
| time_zone | varchar(255) | NO | | Pacific Time (US & Canada) | |
| currency | varchar(3) | NO | | USD | |
| language | varchar(255) | NO | | en-us | |
| summary_period | varchar(255) | NO | | daily | |
| summary_watermark_at | datetime | NO | | 1986-08-25 19:00:44 | |
| summary_hour | int(11) | NO | | 6 | |
+------------------------+--------------+------+-----+----------------------------+----------------+
31 rows in set (0.00 sec)
