| Index: trunk/extensions/SocialProfile/SystemGifts/systemgifts.sql |
| — | — | @@ -5,7 +5,7 @@ |
| 6 | 6 | `sg_user_name` varchar(255) NOT NULL default '', |
| 7 | 7 | `sg_status` int(2) default '1', |
| 8 | 8 | `sg_date` datetime default NULL |
| 9 | | -) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| | 9 | +) /*$wgDBTableOptions*/; |
| 10 | 10 | CREATE INDEX /*i*/sg_user_id ON /*_*/user_system_gift (`sg_user_id`); |
| 11 | 11 | CREATE INDEX /*i*/sg_gift_id ON /*_*/user_system_gift (`sg_gift_id`); |
| 12 | 12 | |
| — | — | @@ -17,6 +17,6 @@ |
| 18 | 18 | `gift_category` int(11) default '0', |
| 19 | 19 | `gift_threshold` int(15) default '0', |
| 20 | 20 | `gift_createdate` datetime default NULL |
| 21 | | -) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| | 21 | +) /*$wgDBTableOptions*/; |
| 22 | 22 | CREATE INDEX /*i*/giftcategoryidx ON /*_*/system_gift (`gift_category`); |
| 23 | 23 | CREATE INDEX /*i*/giftthresholdidx ON /*_*/system_gift (`gift_threshold`); |
| Index: trunk/extensions/SocialProfile/UserBoard/user_board.sql |
| — | — | @@ -11,7 +11,7 @@ |
| 12 | 12 | `ub_message` text NOT NULL, |
| 13 | 13 | `ub_type` int(5) default '0', |
| 14 | 14 | `ub_date` datetime default NULL |
| 15 | | -) DEFAULT CHARSET=utf8; |
| | 15 | +) /*$wgDBTableOptions*/; |
| 16 | 16 | CREATE INDEX /*i*/ub_user_id ON /*_*/user_board (ub_user_id); |
| 17 | 17 | CREATE INDEX /*i*/ub_user_id_from ON /*_*/user_board (ub_user_id_from); |
| 18 | 18 | CREATE INDEX /*i*/ub_type ON /*_*/user_board (ub_type); |
| Index: trunk/extensions/SocialProfile/UserStats/user_stats.sql |
| — | — | @@ -48,4 +48,4 @@ |
| 49 | 49 | `stats_quiz_questions_correct_percent` float default '0', |
| 50 | 50 | `stats_links_submitted` int(11) NOT NULL default '0', |
| 51 | 51 | `stats_links_approved` int(11) NOT NULL default '0' |
| 52 | | -) DEFAULT CHARSET=utf8; |
| | 52 | +) /*$wgDBTableOptions*/; |
| Index: trunk/extensions/SocialProfile/UserProfile/user_profile.sql |
| — | — | @@ -35,4 +35,4 @@ |
| 36 | 36 | `up_custom_5` text, |
| 37 | 37 | `up_last_seen` datetime default NULL, |
| 38 | 38 | `up_type` int(5) NOT NULL default '1' |
| 39 | | -) DEFAULT CHARSET=utf8; |
| | 39 | +) /*$wgDBTableOptions*/; |
| Index: trunk/extensions/SocialProfile/UserRelationship/user_relationship.sql |
| — | — | @@ -10,7 +10,7 @@ |
| 11 | 11 | `r_user_name_relation` varchar(255) NOT NULL default '', |
| 12 | 12 | `r_type` int(2) default NULL, |
| 13 | 13 | `r_date` datetime default NULL |
| 14 | | -) DEFAULT CHARSET=utf8; |
| | 14 | +) /*$wgDBTableOptions*/; |
| 15 | 15 | CREATE INDEX /*i*/r_user_id ON /*_*/user_relationship (`r_user_id`); |
| 16 | 16 | CREATE INDEX /*i*/r_user_id_relation ON /*_*/user_relationship (`r_user_id_relation`); |
| 17 | 17 | |
| — | — | @@ -28,6 +28,6 @@ |
| 29 | 29 | `ur_type` int(2) default NULL, |
| 30 | 30 | `ur_message` varchar(255) default NULL, |
| 31 | 31 | `ur_date` datetime default NULL |
| 32 | | -) DEFAULT CHARSET=utf8; |
| | 32 | +) /*$wgDBTableOptions*/; |
| 33 | 33 | CREATE INDEX /*i*/ur_user_id_from ON /*_*/user_relationship_request (`ur_user_id_from`); |
| 34 | 34 | CREATE INDEX /*i*/ur_user_id_to ON /*_*/user_relationship_request (`ur_user_id_to`); |
| Index: trunk/extensions/SocialProfile/UserSystemMessages/user_system_messages.sql |
| — | — | @@ -5,5 +5,5 @@ |
| 6 | 6 | `um_message` varchar(255) NOT NULL default '', |
| 7 | 7 | `um_type` int(5) default '0', |
| 8 | 8 | `um_date` datetime default NULL |
| 9 | | -) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| | 9 | +) /*$wgDBTableOptions*/; |
| 10 | 10 | CREATE INDEX /*i*/up_user_id ON /*_*/user_system_messages (`um_user_id`); |
| Index: trunk/extensions/SocialProfile/UserGifts/usergifts.sql |
| — | — | @@ -9,7 +9,7 @@ |
| 10 | 10 | `ug_type` int(2) default NULL, |
| 11 | 11 | `ug_message` varchar(255) default NULL, |
| 12 | 12 | `ug_date` datetime default NULL |
| 13 | | -) ENGINE=InnoDB; |
| | 13 | +) /*$wgDBTableOptions*/; |
| 14 | 14 | CREATE INDEX /*i*/ug_user_id_from ON /*_*/user_gift (`ug_user_id_from`); |
| 15 | 15 | CREATE INDEX /*i*/ug_user_id_to ON /*_*/user_gift (`ug_user_id_to`); |
| 16 | 16 | |
| — | — | @@ -22,4 +22,4 @@ |
| 23 | 23 | `gift_description` text, |
| 24 | 24 | `gift_given_count` int(5) default '0', |
| 25 | 25 | `gift_createdate` datetime default NULL |
| 26 | | -) ENGINE=InnoDB; |
| \ No newline at end of file |
| | 26 | +) /*$wgDBTableOptions*/; |
| \ No newline at end of file |