http://www.mediawiki.org/wiki/Special:Code/MediaWiki/98068
Revision: 98068
Author: ashley
Date: 2011-09-25 16:39:48 +0000 (Sun, 25 Sep 2011)
Log Message:
-----------
SocialProfile: change hardcoded table options to /*$wgDBTableOptions*/ in all
SQL files
Modified Paths:
--------------
trunk/extensions/SocialProfile/SystemGifts/systemgifts.sql
trunk/extensions/SocialProfile/UserBoard/user_board.sql
trunk/extensions/SocialProfile/UserGifts/usergifts.sql
trunk/extensions/SocialProfile/UserProfile/user_profile.sql
trunk/extensions/SocialProfile/UserRelationship/user_relationship.sql
trunk/extensions/SocialProfile/UserStats/user_stats.sql
trunk/extensions/SocialProfile/UserSystemMessages/user_system_messages.sql
Modified: trunk/extensions/SocialProfile/SystemGifts/systemgifts.sql
===================================================================
--- trunk/extensions/SocialProfile/SystemGifts/systemgifts.sql 2011-09-25
16:32:15 UTC (rev 98067)
+++ trunk/extensions/SocialProfile/SystemGifts/systemgifts.sql 2011-09-25
16:39:48 UTC (rev 98068)
@@ -5,7 +5,7 @@
`sg_user_name` varchar(255) NOT NULL default '',
`sg_status` int(2) default '1',
`sg_date` datetime default NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) /*$wgDBTableOptions*/;
CREATE INDEX /*i*/sg_user_id ON /*_*/user_system_gift (`sg_user_id`);
CREATE INDEX /*i*/sg_gift_id ON /*_*/user_system_gift (`sg_gift_id`);
@@ -17,6 +17,6 @@
`gift_category` int(11) default '0',
`gift_threshold` int(15) default '0',
`gift_createdate` datetime default NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) /*$wgDBTableOptions*/;
CREATE INDEX /*i*/giftcategoryidx ON /*_*/system_gift (`gift_category`);
CREATE INDEX /*i*/giftthresholdidx ON /*_*/system_gift (`gift_threshold`);
Modified: trunk/extensions/SocialProfile/UserBoard/user_board.sql
===================================================================
--- trunk/extensions/SocialProfile/UserBoard/user_board.sql 2011-09-25
16:32:15 UTC (rev 98067)
+++ trunk/extensions/SocialProfile/UserBoard/user_board.sql 2011-09-25
16:39:48 UTC (rev 98068)
@@ -11,7 +11,7 @@
`ub_message` text NOT NULL,
`ub_type` int(5) default '0',
`ub_date` datetime default NULL
-) DEFAULT CHARSET=utf8;
+) /*$wgDBTableOptions*/;
CREATE INDEX /*i*/ub_user_id ON /*_*/user_board (ub_user_id);
CREATE INDEX /*i*/ub_user_id_from ON /*_*/user_board (ub_user_id_from);
CREATE INDEX /*i*/ub_type ON /*_*/user_board (ub_type);
Modified: trunk/extensions/SocialProfile/UserGifts/usergifts.sql
===================================================================
--- trunk/extensions/SocialProfile/UserGifts/usergifts.sql 2011-09-25
16:32:15 UTC (rev 98067)
+++ trunk/extensions/SocialProfile/UserGifts/usergifts.sql 2011-09-25
16:39:48 UTC (rev 98068)
@@ -9,7 +9,7 @@
`ug_type` int(2) default NULL,
`ug_message` varchar(255) default NULL,
`ug_date` datetime default NULL
-) ENGINE=InnoDB;
+) /*$wgDBTableOptions*/;
CREATE INDEX /*i*/ug_user_id_from ON /*_*/user_gift (`ug_user_id_from`);
CREATE INDEX /*i*/ug_user_id_to ON /*_*/user_gift (`ug_user_id_to`);
@@ -22,4 +22,4 @@
`gift_description` text,
`gift_given_count` int(5) default '0',
`gift_createdate` datetime default NULL
-) ENGINE=InnoDB;
\ No newline at end of file
+) /*$wgDBTableOptions*/;
\ No newline at end of file
Modified: trunk/extensions/SocialProfile/UserProfile/user_profile.sql
===================================================================
--- trunk/extensions/SocialProfile/UserProfile/user_profile.sql 2011-09-25
16:32:15 UTC (rev 98067)
+++ trunk/extensions/SocialProfile/UserProfile/user_profile.sql 2011-09-25
16:39:48 UTC (rev 98068)
@@ -35,4 +35,4 @@
`up_custom_5` text,
`up_last_seen` datetime default NULL,
`up_type` int(5) NOT NULL default '1'
-) DEFAULT CHARSET=utf8;
+) /*$wgDBTableOptions*/;
Modified: trunk/extensions/SocialProfile/UserRelationship/user_relationship.sql
===================================================================
--- trunk/extensions/SocialProfile/UserRelationship/user_relationship.sql
2011-09-25 16:32:15 UTC (rev 98067)
+++ trunk/extensions/SocialProfile/UserRelationship/user_relationship.sql
2011-09-25 16:39:48 UTC (rev 98068)
@@ -10,7 +10,7 @@
`r_user_name_relation` varchar(255) NOT NULL default '',
`r_type` int(2) default NULL,
`r_date` datetime default NULL
-) DEFAULT CHARSET=utf8;
+) /*$wgDBTableOptions*/;
CREATE INDEX /*i*/r_user_id ON /*_*/user_relationship (`r_user_id`);
CREATE INDEX /*i*/r_user_id_relation ON /*_*/user_relationship
(`r_user_id_relation`);
@@ -28,6 +28,6 @@
`ur_type` int(2) default NULL,
`ur_message` varchar(255) default NULL,
`ur_date` datetime default NULL
-) DEFAULT CHARSET=utf8;
+) /*$wgDBTableOptions*/;
CREATE INDEX /*i*/ur_user_id_from ON /*_*/user_relationship_request
(`ur_user_id_from`);
CREATE INDEX /*i*/ur_user_id_to ON /*_*/user_relationship_request
(`ur_user_id_to`);
Modified: trunk/extensions/SocialProfile/UserStats/user_stats.sql
===================================================================
--- trunk/extensions/SocialProfile/UserStats/user_stats.sql 2011-09-25
16:32:15 UTC (rev 98067)
+++ trunk/extensions/SocialProfile/UserStats/user_stats.sql 2011-09-25
16:39:48 UTC (rev 98068)
@@ -48,4 +48,4 @@
`stats_quiz_questions_correct_percent` float default '0',
`stats_links_submitted` int(11) NOT NULL default '0',
`stats_links_approved` int(11) NOT NULL default '0'
-) DEFAULT CHARSET=utf8;
+) /*$wgDBTableOptions*/;
Modified:
trunk/extensions/SocialProfile/UserSystemMessages/user_system_messages.sql
===================================================================
--- trunk/extensions/SocialProfile/UserSystemMessages/user_system_messages.sql
2011-09-25 16:32:15 UTC (rev 98067)
+++ trunk/extensions/SocialProfile/UserSystemMessages/user_system_messages.sql
2011-09-25 16:39:48 UTC (rev 98068)
@@ -5,5 +5,5 @@
`um_message` varchar(255) NOT NULL default '',
`um_type` int(5) default '0',
`um_date` datetime default NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) /*$wgDBTableOptions*/;
CREATE INDEX /*i*/up_user_id ON /*_*/user_system_messages (`um_user_id`);
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
