Page MenuHomePhabricator
Paste P1933

(An Untitled Masterwork)
ActivePublic

Authored by Mattflaschen-WMF on Aug 26 2015, 10:56 PM.
mattflaschen@deployment-bastion:~$ echo 'SHOW CREATE TABLE flow_ext_ref;'|sql aawiki
Table Create Table
flow_ext_ref CREATE TABLE `flow_ext_ref` (\n `ref_src_object_id` binary(11) NOT NULL,\n `ref_src_object_type` varbinary(32) NOT NULL,\n `ref_src_workflow_id` binary(11) NOT NULL,\n `ref_src_namespace` int(11) NOT NULL,\n `ref_src_title` varbinary(255) NOT NULL,\n `ref_target` varbinary(255) NOT NULL,\n `ref_type` varbinary(16) NOT NULL,\n `ref_src_wiki` varbinary(16) NOT NULL,\n KEY `flow_ext_ref_idx_v2` (`ref_src_wiki`,`ref_src_namespace`,`ref_src_title`,`ref_type`,`ref_target`,`ref_src_object_type`,`ref_src_object_id`),\n KEY `flow_ext_ref_revision_v2` (`ref_src_wiki`,`ref_src_namespace`,`ref_src_title`,`ref_src_object_type`,`ref_src_object_id`,`ref_type`,`ref_target`)\n) ENGINE=InnoDB DEFAULT CHARSET=binary
mattflaschen@deployment-bastion:~$ echo 'SHOW CREATE TABLE flow_ext_ref;'|sql enwiki
Table Create Table
flow_ext_ref CREATE TABLE `flow_ext_ref` (\n `ref_src_object_id` binary(11) NOT NULL,\n `ref_src_object_type` varbinary(32) NOT NULL,\n `ref_src_workflow_id` binary(11) NOT NULL,\n `ref_src_namespace` int(11) NOT NULL,\n `ref_src_title` varbinary(255) NOT NULL,\n `ref_target` blob,\n `ref_type` varbinary(16) NOT NULL,\n `ref_src_wiki` varchar(16) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,\n KEY `flow_ext_ref_idx_v2` (`ref_src_wiki`,`ref_src_namespace`,`ref_src_title`,`ref_type`,`ref_target`(255),`ref_src_object_type`,`ref_src_object_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=latin1