https://bugzilla.wikimedia.org/show_bug.cgi?id=50740
--- Comment #2 from Sam Reed (reedy) <[email protected]> --- It seems to exist/be up to date.. mysql:wikiadmin@db1019 [test2wiki]> explain ep_revisions\G *************************** 1. row *************************** Field: rev_id Type: int(10) unsigned Null: NO Key: PRI Default: NULL Extra: auto_increment *************************** 2. row *************************** Field: rev_object_id Type: int(10) unsigned Null: NO Key: MUL Default: NULL Extra: *************************** 3. row *************************** Field: rev_object_identifier Type: varbinary(255) Null: YES Key: MUL Default: NULL Extra: *************************** 4. row *************************** Field: rev_type Type: varbinary(32) Null: NO Key: MUL Default: NULL Extra: *************************** 5. row *************************** Field: rev_comment Type: tinyblob Null: NO Key: Default: NULL Extra: *************************** 6. row *************************** Field: rev_user_id Type: int(10) unsigned Null: NO Key: MUL Default: 0 Extra: *************************** 7. row *************************** Field: rev_user_text Type: varbinary(255) Null: NO Key: MUL Default: NULL Extra: *************************** 8. row *************************** Field: rev_time Type: varbinary(14) Null: NO Key: MUL Default: NULL Extra: *************************** 9. row *************************** Field: rev_minor_edit Type: tinyint(3) unsigned Null: NO Key: MUL Default: 0 Extra: *************************** 10. row *************************** Field: rev_deleted Type: tinyint(3) unsigned Null: NO Key: MUL Default: 0 Extra: *************************** 11. row *************************** Field: rev_data Type: blob Null: NO Key: Default: NULL Extra: 11 rows in set (0.00 sec) mysql:wikiadmin@db1019 [test2wiki]> show indexes from ep_revisions\G *************************** 1. row *************************** Table: ep_revisions Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: rev_id Collation: A Cardinality: 80 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *************************** 2. row *************************** Table: ep_revisions Non_unique: 1 Key_name: ep_revision_object_id Seq_in_index: 1 Column_name: rev_object_id Collation: A Cardinality: 80 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *************************** 3. row *************************** Table: ep_revisions Non_unique: 1 Key_name: ep_revision_type Seq_in_index: 1 Column_name: rev_type Collation: A Cardinality: 5 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *************************** 4. row *************************** Table: ep_revisions Non_unique: 1 Key_name: ep_revision_user_id Seq_in_index: 1 Column_name: rev_user_id Collation: A Cardinality: 26 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *************************** 5. row *************************** Table: ep_revisions Non_unique: 1 Key_name: ep_revision_user_text Seq_in_index: 1 Column_name: rev_user_text Collation: A Cardinality: 26 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *************************** 6. row *************************** Table: ep_revisions Non_unique: 1 Key_name: ep_revision_time Seq_in_index: 1 Column_name: rev_time Collation: A Cardinality: 80 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *************************** 7. row *************************** Table: ep_revisions Non_unique: 1 Key_name: ep_revision_minor_edit Seq_in_index: 1 Column_name: rev_minor_edit Collation: A Cardinality: 5 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *************************** 8. row *************************** Table: ep_revisions Non_unique: 1 Key_name: ep_revision_deleted Seq_in_index: 1 Column_name: rev_deleted Collation: A Cardinality: 5 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *************************** 9. row *************************** Table: ep_revisions Non_unique: 1 Key_name: ep_revision_object_identifier Seq_in_index: 1 Column_name: rev_object_identifier Collation: A Cardinality: 80 Sub_part: NULL Packed: NULL Null: YES Index_type: BTREE Comment: 9 rows in set (0.00 sec) mysql:wikiadmin@db1019 [test2wiki]> -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
