mirror of
https://gerrit.wikimedia.org/r/mediawiki/extensions/DiscussionTools
synced 2024-11-27 17:51:09 +00:00
c490dc8164
Per Manuel Arostegui in T263817#7033384. As I understand, this is just for consistency with tables in MediaWiki core. Given that all tables are created with "DEFAULT CHARSET=binary" (as defined in $wgDBTableOptions), there is no difference in behavior between these two types. Bug: T263817 Change-Id: I8dabcb45e447e0bf60b119fd4f7d6532147a44fc
19 lines
796 B
SQL
19 lines
796 B
SQL
-- This file is automatically generated using maintenance/generateSchemaSql.php.
|
|
-- Source: sql/discussiontools_subscription.json
|
|
-- Do not modify this file directly.
|
|
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
|
|
CREATE TABLE /*_*/discussiontools_subscription (
|
|
sub_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
|
|
sub_item VARBINARY(255) NOT NULL,
|
|
sub_namespace INT DEFAULT 0 NOT NULL,
|
|
sub_title VARBINARY(255) NOT NULL,
|
|
sub_section VARBINARY(255) NOT NULL,
|
|
sub_state INT DEFAULT 1 NOT NULL,
|
|
sub_user INT UNSIGNED NOT NULL,
|
|
sub_created BINARY(14) NOT NULL,
|
|
sub_notified BINARY(14) DEFAULT NULL,
|
|
UNIQUE INDEX discussiontools_subscription_itemuser (sub_item, sub_user),
|
|
INDEX discussiontools_subscription_user (sub_user),
|
|
PRIMARY KEY(sub_id)
|
|
) /*$wgDBTableOptions*/;
|