| Index: trunk/extensions/SocialProfile/SystemGifts/systemgifts.sql |
| — | — | @@ -1,4 +1,4 @@ |
| 2 | | -CREATE TABLE /*$wgDBprefix*/user_system_gift ( |
| | 2 | +CREATE TABLE /*_*/user_system_gift ( |
| 3 | 3 | `sg_id` int(11) NOT NULL PRIMARY KEY auto_increment, |
| 4 | 4 | `sg_gift_id` int(5) unsigned NOT NULL default '0', |
| 5 | 5 | `sg_user_id` int(11) unsigned NOT NULL default '0', |
| — | — | @@ -9,7 +9,7 @@ |
| 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 | |
| 13 | | -CREATE TABLE /*$wgDBprefix*/system_gift ( |
| | 13 | +CREATE TABLE /*_*/system_gift ( |
| 14 | 14 | `gift_id` int(11) NOT NULL PRIMARY KEY auto_increment, |
| 15 | 15 | `gift_name` varchar(255) NOT NULL default '', |
| 16 | 16 | `gift_description` text, |
| Index: trunk/extensions/SocialProfile/UserBoard/user_board.sql |
| — | — | @@ -2,7 +2,7 @@ |
| 3 | 3 | -- Table structure for table `user_board` |
| 4 | 4 | -- |
| 5 | 5 | |
| 6 | | -CREATE TABLE /*$wgDBprefix*/user_board ( |
| | 6 | +CREATE TABLE /*_*/user_board ( |
| 7 | 7 | `ub_id` int(11) PRIMARY KEY auto_increment, |
| 8 | 8 | `ub_user_id` int(11) NOT NULL default '0', |
| 9 | 9 | `ub_user_name` varchar(255) NOT NULL default '', |
| Index: trunk/extensions/SocialProfile/UserProfile/user_profile.sql |
| — | — | @@ -2,7 +2,7 @@ |
| 3 | 3 | -- Table structure for table `user_profile` |
| 4 | 4 | -- |
| 5 | 5 | |
| 6 | | -CREATE TABLE /*$wgDBprefix*/user_profile ( |
| | 6 | +CREATE TABLE /*_*/user_profile ( |
| 7 | 7 | `up_user_id` int(5) NOT NULL PRIMARY KEY default '0', |
| 8 | 8 | `up_location_city` varchar(255) default NULL, |
| 9 | 9 | `up_location_state` varchar(100) default NULL, |
| Index: trunk/extensions/SocialProfile/UserRelationship/user_relationship.sql |
| — | — | @@ -2,7 +2,7 @@ |
| 3 | 3 | -- Table structure for table `user_relationship` |
| 4 | 4 | -- |
| 5 | 5 | |
| 6 | | -CREATE TABLE /*$wgDBprefix*/user_relationship ( |
| | 6 | +CREATE TABLE /*_*/user_relationship ( |
| 7 | 7 | `r_id` int(11) PRIMARY KEY auto_increment, |
| 8 | 8 | `r_user_id` int(5) unsigned NOT NULL default '0', |
| 9 | 9 | `r_user_name` varchar(255) NOT NULL default '', |
| — | — | @@ -18,7 +18,7 @@ |
| 19 | 19 | -- Table structure for table `user_relationship_request` |
| 20 | 20 | -- |
| 21 | 21 | |
| 22 | | -CREATE TABLE /*$wgDBprefix*/user_relationship_request ( |
| | 22 | +CREATE TABLE /*_*/user_relationship_request ( |
| 23 | 23 | `ur_id` int(11) PRIMARY KEY auto_increment, |
| 24 | 24 | `ur_user_id_from` int(5) unsigned NOT NULL default '0', |
| 25 | 25 | `ur_user_name_from` varchar(255) NOT NULL default '', |
| — | — | @@ -30,4 +30,4 @@ |
| 31 | 31 | `ur_date` datetime default NULL |
| 32 | 32 | ) DEFAULT CHARSET=utf8; |
| 33 | 33 | CREATE INDEX /*i*/ur_user_id_from ON /*_*/user_relationship_request (`ur_user_id_from`); |
| 34 | | -CREATE INDEX /*I*/ur_user_id_to ON /*_*/user_relationship_request (`ur_user_id_to`); |
| | 34 | +CREATE INDEX /*i*/ur_user_id_to ON /*_*/user_relationship_request (`ur_user_id_to`); |
| Index: trunk/extensions/SocialProfile/UserGifts/usergifts.sql |
| — | — | @@ -1,4 +1,4 @@ |
| 2 | | -CREATE TABLE /*$wgDBprefix*/user_gift ( |
| | 2 | +CREATE TABLE /*_*/user_gift ( |
| 3 | 3 | `ug_id` int(11) PRIMARY KEY auto_increment, |
| 4 | 4 | `ug_gift_id` int(5) unsigned NOT NULL default '0', |
| 5 | 5 | `ug_user_id_to` int(5) unsigned NOT NULL default '0', |
| — | — | @@ -13,7 +13,7 @@ |
| 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 | |
| 17 | | -CREATE TABLE /*$wgDBprefix*/gift ( |
| | 17 | +CREATE TABLE /*_*/gift ( |
| 18 | 18 | `gift_id` int(11) UNSIGNED PRIMARY KEY auto_increment, |
| 19 | 19 | `gift_access` int(5) NOT NULL default '0', |
| 20 | 20 | `gift_creator_user_id` int(11) NOT NULL default '0', |
| Index: trunk/extensions/SocialProfile/UserSystemMessages/user_system_messages.sql |
| — | — | @@ -1,4 +1,4 @@ |
| 2 | | -CREATE TABLE /*$wgDBprefix*/user_system_messages ( |
| | 2 | +CREATE TABLE /*_*/user_system_messages ( |
| 3 | 3 | `um_id` int(11) NOT NULL PRIMARY KEY auto_increment, |
| 4 | 4 | `um_user_id` int(11) NOT NULL default '0', |
| 5 | 5 | `um_user_name` varchar(255) NOT NULL default '', |