Page MenuHomePhabricator
Paste P5712

Implicit not null
ActivePublic
Actions

Authored by • Mattflaschen-WMF on Jul 10 2017, 8:59 PM.
Tags
Referenced Files
F8695622: Implicit not null
Jul 10 2017, 8:59 PM
Subscribers
None
(20:58) root@localhost:[wiki]> CREATE TABLE /*_*/blah (
-> blah_list_id binary(11) not null,
-> blah_id binary(11),
-> PRIMARY KEY (blah_list_id, blah_id)
-> ) /*$wgDBTableOptions*/;
Query OK, 0 rows affected (0.00 sec)
(20:58) root@localhost:[wiki]> SHOW CREATE TABLE blah;
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Table | Create Table
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| blah | CREATE TABLE `blah` (
`blah_list_id` binary(11) NOT NULL,
`blah_id` binary(11) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0',
PRIMARY KEY (`blah_list_id`,`blah_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)
(20:58) root@localhost:[wiki]> CREATE TABLE /*_*/blah2 (
-> blah2_list_id binary(11) not null,
-> blah2_id binary(11)
-> ) /*$wgDBTableOptions*/;
Query OK, 0 rows affected (0.00 sec)
(20:58) root@localhost:[wiki]> SHOW CREATE TABLE blah2;
+-------+-----------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+-----------------------------------------------------------------------------------------------------------------------------------------+
| blah2 | CREATE TABLE `blah2` (
`blah2_list_id` binary(11) NOT NULL,
`blah2_id` binary(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+-----------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
(20:58) root@localhost:[wiki]> ALTER TABLE /*_*/blah2 ADD PRIMARY KEY (blah2_list_id, blah2_id);
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
(20:58) root@localhost:[wiki]> SHOW CREATE TABLE blah2;
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Table | Create Table
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| blah2 | CREATE TABLE `blah2` (
`blah2_list_id` binary(11) NOT NULL,
`blah2_id` binary(11) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0',
PRIMARY KEY (`blah2_list_id`,`blah2_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL