Notes: - Routes - /SakeStorageServer/StorageServer.asmx - WSDL file (DWC): https://web.archive.org/web/20140602214517/http://hmm.sake.gs.nintendowifi.net/SakeStorageServer/StorageServer.asmx?WSDL - PC games additionally have GetMyImages and DeleteImage operations. - /SakeStorageServer/FiraxisServices.asmx - Not used by DWC. - /SakeFileServer/download.aspx?fileid=1234567&gameid=1234&pid=123456789 - GET - Response - Headers - Sake-File-Result - Content-Type (text/html) - Content-Length - Body - File - /SakeFileServer/upload.aspx?gameid=1234&pid=123456789 - POST - Request - Headers - Content-Type (multipart/form-data) - Response - Headers - Sake-File-Result - Sake-File-Id - Data types - byteValue (u8) - shortValue (s16) - intValue (s32) - int64Value (s64) - floatValue (f32) - booleanValue (true or false) - dateAndTimeValue (YYYY-MM-DDThh:mm:ss.fff or YYYY-MM-DDThh:mm:ss.ff) - asciiStringValue - unicodeStringValue - binaryDataValue - Database fields - Every SAKE field must have a non-null value. Returning null WILL cause issues. - Special fields (generated on the fly) - file info - {field containing file id}.create_time (dateAndTimeValue) - {field containing file id}.downloads (intValue) - {field containing file id}.size (intValue) - ... - ratings - average_rating (floatValue) - my_rating (intValue) - num_ratings (intValue) - sum_ratings (intValue) ? - other - row - Sake-File-Result codes - 0 = success - 1 = ? (error) - 2 = ? (error) - ... - Error codes (4XXYY) - XX values - 02 = CreateRecord - 03 = DeleteRecord - 04 = UpdateRecord - 05 = File download? - 06 = File upload - 07 = GetMyRecords - 08 = GetRecordLimit? - 09 = GetSpecificRecords - 10 = RateRecord - 11 = SearchForRecords - 12 = GetRandomRecords - 13 = GetRecordCount - YY values - 52 = Result: SecretKeyInvalid - 53 = Result: ServiceDisabled - 54 = ? - 55 = Invalid response or the server did not answer - 56 = Invalid value in response - 57 = ? - 58 = Result: DatabaseUnavailable - 59 = Result: LoginTicketInvalid - 60 = Result: LoginTicketExpired - 61 = Result: TableNotFound - 62 = Result: RecordNotFound - 63 = Result: FieldNotFound - 64 = Result: FieldTypeInvalid - 65 = Result: NoPermission - 66 = Result: RecordLimitReached - 67 = Result: AlreadyRated - 68 = Result: NotRateable - 69 = Result: NotOwned - 70 = Result: FilterInvalid - 71 = Result: SortInvalid - 72 = Unknown result - 73 = Connection error? - 74 = ? - 75 = Connection error? - 76 = ? - 77 = ? - 78 = ? - 79 = ? - 80 = Result: TargetFilterInvalid - Filter examples - (recordid - 1) % 500000 / 10 = 0 AND EUlast_modified > 10895778 AND EUopne_flag = 1 - region = 3 - (ownerid != 123456) and (POWER(2, region - 1) & 0 != 0) and (approval_flag & 1 = 1) - OwnerName = 'KEE' - ds_hash_key = '7c8260bac' - recordid > -1 - ds_hash_key = '7c8260bac' AND pet_status = '3' - ownerid = 601629585 - Sort examples - allowed_regions desc - recordid - ladder DESC Games: 1374 / mmvdkds - Special features - nintendowifi.com features - Levels on tblNintendoMap may be replaced with users' levels? - View other players' stats on the website? 1443 / bandbrosds 1607 / girlsds 1658 / smashbrosxwii 1687 / mariokartwii 2050 / madeinoreds 2051 / guinnesswrds 2052 / guinnesswrwii 2253 / micchannelwii 2448 / mvsdk25ds - Special features - moderation system 2497 / spectro2wii 2649 / bandbroseuds 2689 / petz09ds - Special features - Receive pets from the Petz website? 2708 / imaginejdds - Special features - "Welcome your friends into your boutique via Wi-Fi, and trade jewelry and beads with friends, showcase your designs in the online Style Lab gallery." - "Order, own and wear your in-game creations through a partnership with bead manufacturer who will produce designs that girls upload to the online gallery and then purchase." 2738 / gokuidsi 2793 / trkmaniawii 2999 / playgroundds - Special features - moderation system - contests 3026 / dental2ds 3110 / slclothingds ???? / banburadxds ???? / girlskoreads ???? / imagineartds - Special features - "Share your designs with the world by uploading them to the online Imagine Town Gallery where you can enter contests and explore your creativity!" ???? / jyotrainwii ???? / syachi2ds - https://github.com/mm201/pkmn-classic-framework/issues/111 - https://github.com/mm201/pkmn-classic-framework/issues/8 mmvdkds tblNintendoMap(Eur/Jap) levels: recordid ownerid mapid map_name mapid.create_time (type) (region) (dump?) 77793 95534419 797290 Princess 2007-03-26T14:13:37.05 NINTENDO PAL Y 84122 96804450 1000324 InsaneD 2007-04-09T17:35:09.78 User Level USA Y 84123 96804450 1000323 DealMT 2007-04-09T17:35:09.75 User Level USA Y 89722 97367709 1141437 Mark 2007-04-16T18:40:17.27 User Level USA Y 90894 97462983 1167948 ピ一チタワー 2007-04-18T08:00:49.067 NINTENDO Japan Y 96199 98007927 1289251 LMNO 2007-04-24T11:38:55.43 User Level USA Y 101703 98604493 1407043 Try 2 2007-04-30T17:41:22.157 User Level USA Y 108518 99396173 1550948 ManyMini 2007-05-09T14:50:41.77 User Level USA Y ? ? ? PipeLine 2007-03-19T17:17:30.307 NINTENDO PAL Y ? ? ? キノピオライン 2007-04-11T08:00:33.083 NINTENDO Japan Y ? ? ? CircusKO ? NINTENDO PAL Y ? ? ? CoolKong ? NINTENDO PAL Y ? ? ? Mini DK ? NINTENDO PAL Y ? ? ? MM Panic ? NINTENDO PAL Y ? ? ? Snatchem ? NINTENDO PAL Y ? ? ? WiFiKong ? NINTENDO PAL Y ? ? ? Wi-Fi! ? NINTENDO Japan Y ? ? ? 1•2•サーカス ? NINTENDO Japan Y ? ? ? トライボックス ? NINTENDO Japan Y ? ? ? ジャングルR&B ? NINTENDO Japan Y ? ? ? DKキャリー ? NINTENDO Japan Y ? ? ? MMパニック ? NINTENDO Japan Y Tables: ======================================================================================================================= common # files FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A create_time dateAndTimeValue CURRENT_TIMESTAMP(3) N/A downloads intValue 0 N/A size intValue N/A N/A ... # {tableName} ratings FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A {rated_recordid} intValue N/A {tableName} recordid {rating} intValue ? N/A ======================================================================================================================= 1374 / mmvdkds # tblNintendoMap, tblNintendoMapEur, tblNintendoMapJap PERMISSIONS limitPerOwner = N/A create = false update = false search = true delete = false rate = false FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A map1 intValue 0 tblMapInfo recordid? map2 intValue 0 tblMapInfo recordid? map3 intValue 0 tblMapInfo recordid? map4 intValue 0 tblMapInfo recordid? map5 intValue 0 tblMapInfo recordid? map6 intValue 0 tblMapInfo recordid? map7 intValue 0 tblMapInfo recordid? map8 intValue 0 tblMapInfo recordid? nintendo_name unicodeStringValue (8) 'NINTENDO' N/A # tblPlayerInfo PERMISSIONS limitPerOwner = 1 create = true update = true search = true delete = false rate = false FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A player_name unicodeStringValue (8) '' N/A map1 intValue 0 tblMapInfo recordid? map2 intValue 0 tblMapInfo recordid? map3 intValue 0 tblMapInfo recordid? map4 intValue 0 tblMapInfo recordid? map5 intValue 0 tblMapInfo recordid? map6 intValue 0 tblMapInfo recordid? map7 intValue 0 tblMapInfo recordid? map8 intValue 0 tblMapInfo recordid? allowed_pids asciiStringValue (660 ?) '' N/A nintendowifi_dot_com_love booleanValue false N/A sp_stats binaryDataValue (444) '\0' * 444 N/A # tblMapInfo PERMISSIONS limitPerOwner = 8 create = true update = false search = true delete = true rate = false FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A mapid intValue N/A files recordid map_name unicodeStringValue (8) N/A N/A crc intValue N/A N/A mapid.create_time dateAndTimeValue - - ======================================================================================================================= 2051 / guinnesswrds 2052 / guinnesswrwii # ProfileNames PERMISSIONS limitPerOwner = ? create = true update = ? search = true delete = ? rate = false FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A OwnerName unicodeStringValue N/A ? N/A Country byteValue N/A ? N/A Region byteValue N/A ? N/A # RecordTable PERMISSIONS limitPerOwner = ? create = true update = ? search = true delete = ? rate = false FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A GameID byteValue N/A N/A Score intValue N/A N/A OwnerName unicodeStringValue N/A ? N/A Country byteValue N/A ? N/A Region byteValue N/A ? N/A AvatarParts binaryDataValue N/A ? N/A AvatarModel byteValue N/A ? N/A AvatarName unicodeStringValue N/A ? N/A DateTimeSet dateAndTimeValue CURRENT_TIMESTAMP(3) N/A <-- this is a stored generated field ======================================================================================================================= 2708 / imaginejdds # unlocks FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A ds_hash_key asciiStringValue (9 ?) N/A ? ? unlocks_bitmask ? N/A ? N/A # stats FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A ds_hash_key asciiStringValue (9 ?) N/A ? current_level intValue 1 N/A number_star_customers_served intValue 0 N/A number_regular_customers_served intValue 0 N/A number_customers_encountered intValue 0 N/A # jewelry FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A ds_hash_key asciiStringValue (9 ?) N/A ? ? jewelry_image intValue ? files recordid pattern_id intValue ? ? time_to_create intValue ? N/A coins_total_value intValue ? N/A materials binaryDataValue (1560(+) ?) ? N/A private booleanValue true ? N/A boutique_name asciiStringValue '' ? N/A boutique_color_theme_id intValue ? ? has_letters_numbers booleanValue ? N/A ======================================================================================================================= 3110 / slclothingds # clothing FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A ds_hash_key asciiStringValue ? ? garment_type byteValue ? ? garment_variation shortValue ? ? garment_color intValue ? ? clothing_data binaryDataValue (772(+) ?) ? ? ======================================================================================================================= 1607 / girlsds # EUNewShop FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A EUshop_name unicodeStringValue ? ? EUowner_name unicodeStringValue ? ? EUbg byteValue ? ? EUopne_flag booleanValue ? ? EUleft_mannequin_id intValue ? ? EUcenter_mannequin_id intValue ? ? EUright_mannequin_id intValue ? ? EUleft_mannequin_costume binaryDataValue ? ? EUcenter_mannequin_costume binaryDataValue ? ? EUright_mannequin_costume binaryDataValue ? ? EUleft_mannequin_color byteValue ? ? EUcenter_mannequin_color byteValue ? ? EUright_mannequin_color byteValue ? ? EUdisplay byteValue ? ? EUlast_modified intValue ? ? EUdisplay_owner booleanValue ? ? EUowner_face binaryDataValue ? ? EUhash binaryDataValue ? ? ======================================================================================================================= 2448 / mvsdk25ds # tblPlayerInfo PERMISSIONS limitPerOwner = 1 create = true update = true search = true delete = false rate = ? FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A map1 intValue 0 tblMapInfo recordid? map2 intValue 0 tblMapInfo recordid? map3 intValue 0 tblMapInfo recordid? map4 intValue 0 tblMapInfo recordid? map5 intValue 0 tblMapInfo recordid? map6 intValue 0 tblMapInfo recordid? map7 intValue 0 tblMapInfo recordid? map8 intValue 0 tblMapInfo recordid? map9 intValue 0 tblMapInfo recordid? map10 intValue 0 tblMapInfo recordid? map11 intValue 0 tblMapInfo recordid? map12 intValue 0 tblMapInfo recordid? map13 intValue 0 tblMapInfo recordid? map14 intValue 0 tblMapInfo recordid? map15 intValue 0 tblMapInfo recordid? map16 intValue 0 tblMapInfo recordid? map17 intValue 0 tblMapInfo recordid? map18 intValue 0 tblMapInfo recordid? map19 intValue 0 tblMapInfo recordid? map20 intValue 0 tblMapInfo recordid? player_name unicodeStringValue '' N/A my_rating intValue - - # tblNintendoMap PERMISSIONS limitPerOwner = N/A create = false update = false search = true delete = false rate = false FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A nintendo_name unicodeStringValue? 'NINTENDO' ? N/A map1 intValue 0 tblMapInfo recordid? map2 intValue 0 tblMapInfo recordid? map3 intValue 0 tblMapInfo recordid? map4 intValue 0 tblMapInfo recordid? map5 intValue 0 tblMapInfo recordid? map6 intValue 0 tblMapInfo recordid? map7 intValue 0 tblMapInfo recordid? map8 intValue 0 tblMapInfo recordid? map9 intValue 0 tblMapInfo recordid? map10 intValue 0 tblMapInfo recordid? map11 intValue 0 tblMapInfo recordid? map12 intValue 0 tblMapInfo recordid? map13 intValue 0 tblMapInfo recordid? map14 intValue 0 tblMapInfo recordid? map15 intValue 0 tblMapInfo recordid? map16 intValue 0 tblMapInfo recordid? map17 intValue 0 tblMapInfo recordid? map18 intValue 0 tblMapInfo recordid? map19 intValue 0 tblMapInfo recordid? map20 intValue 0 tblMapInfo recordid? # tblRegionInfo PERMISSIONS limitPerOwner = N/A create = false update = false search = true delete = false rate = false FIELD TYPE DEFAULT REFERENCES region byteValue? N/A N/A allowed_regions asciiStringValue ?? '/0/1/2' or '/E/J/U' ??? N/A min_ratings asciiStringValue ?? '/0/0/0' ??? N/A # tblApproval PERMISSIONS limitPerOwner = ? create = ? update = ? search = true delete = true rate = ? FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A approval_flag intValue? ? N/A region byteValue? N/A N/A map_recordid intValue N/A tblMapInfo recordid average_rating floatValue - - my_rating intValue - - kit byteValue? N/A N/A # tblMapInfo FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A author_name unicodeStringValue ? N/A average_rating floatValue - - crc intValue ? N/A high_score shortValue ? N/A kit byteValue N/A N/A map_name unicodeStringValue ? N/A mapid intValue ? files recordid? mapid.create_time dateAndTimeValue - - my_rating intValue - - num_ratings intValue - - private booleanValue ? N/A region byteValue ? N/A stat_fileid intValue ? files recordid stat_fileid.downloads intValue - - approval_recordid intValue ? tblApproval recordid # tblOffensiveMap FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A offensiveid intValue N/A ? ======================================================================================================================= 2793 / trkmaniawii # player FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A ladder intValue ? N/A avatar intValue ? N/A mii intValue ? N/A wins intValue ? N/A loses intValue ? N/A count intValue ? N/A name asciiStringValue ? N/A row intValue - - # solo FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A trackid intValue ? ? time floatValue ? N/A ghostid intValue ? ? ghosttime floatValue ? N/A date intValue ? N/A ghostsize intValue ? N/A # custom FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A name asciiStringValue? ? ? author ? ? ? date intValue? ? ? env ? ? ? trackFile intValue? ? files recordid? trackSize ? ? ? goldFile ? ? ? goldSize ? ? ? silverFile ? ? ? silverSize ? ? ? bronzeFile ? ? ? bronzeSize ? ? ? isValidated booleanValue? ? ? # customDLC FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A name asciiStringValue? ? N/A author ? ? N/A date intValue? ? N/A env ? ? ? trackFile intValue? ? files recordid? trackSize ? ? N/A goldFile ? ? ? goldSize ? ? N/A silverFile ? ? ? silverSize ? ? N/A bronzeFile ? ? ? bronzeSize ? ? N/A isValidated booleanValue? ? N/A isDLC booleanValue? ? N/A ======================================================================================================================= 2689 / petz09ds # petzinfo FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A ds_hash_key asciiStringValue? ? ? pet_status ? ? ? name ? ? ? title_id ? ? ? breed ? ? ? needs_toilet_decreaser ? ? ? needs_toilet_increaser ? ? ? needs_toilet_favorite ? ? ? needs_thirst_decreaser ? ? ? needs_thirst_increaser ? ? ? needs_thirst_favorite ? ? ? needs_hunger_decreaser ? ? ? needs_hunger_increaser ? ? ? needs_hunger_favorite ? ? ? needs_sleepy_decreaser ? ? ? needs_sleepy_increaser ? ? ? needs_sleepy_favorite ? ? ? needs_dirty_decreaser ? ? ? needs_dirty_increaser ? ? ? wants_cuddle_decreaser ? ? ? wants_cuddle_increaser ? ? ? wants_cuddle_favorite ? ? ? wants_play_decreaser ? ? ? wants_play_increaser ? ? ? wants_play_favorite ? ? ? wants_cuddlepet_decreaser ? ? ? wants_cuddlepet_increaser ? ? ? wants_cuddlepet_favorite ? ? ? wants_petplay_decreaser ? ? ? wants_petplay_increaser ? ? ? wants_petplay_favorite ? ? ? frisbee_pets_max ? ? ? frisbee_pets_min ? ? ? frisbee_pets_start ? ? ? frisbee_petf_max ? ? ? frisbee_petf_min ? ? ? frisbee_petf_start ? ? ? frisbee_petvf_max ? ? ? frisbee_petvf_min ? ? ? frisbee_petvf_start ? ? ? frisbee_current_skill ? ? ? trick_pets_max ? ? ? trick_pets_min ? ? ? trick_pets_start ? ? ? trick_petf_max ? ? ? trick_petf_min ? ? ? trick_petf_start ? ? ? trick_petvf_max ? ? ? trick_petvf_min ? ? ? trick_petvf_start ? ? ? trick_current_skill ? ? ? skate_pets_max ? ? ? skate_pets_min ? ? ? skate_pets_start ? ? ? skate_petf_max ? ? ? skate_petf_min ? ? ? skate_petf_start ? ? ? skate_petvf_max ? ? ? skate_petvf_min ? ? ? skate_petvf_start ? ? ? skate_current_skill ? ? ? obstacle_pets_max ? ? ? obstacle_pets_min ? ? ? obstacle_pets_start ? ? ? obstacle_petf_max ? ? ? obstacle_petf_min ? ? ? obstacle_petf_start ? ? ? obstacle_petvf_max ? ? ? obstacle_petvf_min ? ? ? obstacle_petvf_start ? ? ? obstacle_current_skill ? ? ? ball_pets_max ? ? ? ball_pets_min ? ? ? ball_pets_start ? ? ? ball_petf_max ? ? ? ball_petf_min ? ? ? ball_petf_start ? ? ? ball_petvf_max ? ? ? ball_petvf_min ? ? ? ball_petvf_start ? ? ? ball_current_skill ? ? ? age_number_coinz ? ? ? adopted ? ? ? gender ? ? ? trick_is_revealed ? ? ? skate_is_revealed ? ? ? obstacle_is_revealed ? ? ? ball_is_revealed ? ? ? frisbee_is_revealed ? ? ? body_makeup_sex ? ? ? times_left_breeding ? ? ? body_makeup_head ? ? ? body_makeup_body ? ? ? body_makeup_texture ? ? ? private ? ? ? ======================================================================================================================= 1443 / bandbrosds 2649 / bandbroseuds # bbdx_info FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A serialid intValue ? ? stat intValue ? ? message unicodeStringValue ? N/A # bbdx_player FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A stat intValue ? ? # bbdx_search FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A song_name asciiStringValue ? N/A creator_name asciiStringValue ? N/A average_rating floatValue - - serialid intValue ? ? filestore intValue ? ? is_lyric booleanValue ? N/A num_ratings intValue - - sum_ratings intValue - ? - song_code asciiStringValue ? ? artist_name asciiStringValue ? ? ======================================================================================================================= 2999 / playgroundds # tblapproval FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A num_ratings intValue - - average_rating floatValue - - ... # tblcontesthistory FIELD TYPE DEFAULT REFERENCES recordid intValue ownerid intValue contest_expiration ? new ? rules_data ? # tblcontestinfo FIELD TYPE DEFAULT REFERENCES recordid intValue N/A N/A ownerid intValue N/A N/A stat_fileid intValue N/A files recordid stat_fileid.size intValue - - stat_fileid.create_time dateAndTimeValue - - stat_fileid.downloads intValue - - submit_expiration ? ? N/A map_data binaryDataValue? ? N/A rules_data ? ? N/A expired ? ? N/A # tblcontestnotify FIELD TYPE DEFAULT REFERENCES recordid intValue ownerid intValue map_name unicodeStringValue? # tblfavorites FIELD TYPE DEFAULT REFERENCES recordid intValue ownerid intValue favoriteid intValue? # tbljoinmapplayerinfo (this is probably a view) FIELD TYPE DEFAULT REFERENCES recordid intValue - tblmapinfo recordid ownerid intValue - tblmapinfo ownerid stat_fileid intValue - tblmapinfo stat_fileid stat_fileid.size intValue - (tblmapinfo stat_fileid.size) stat_fileid.create_time dateAndTimeValue - (tblmapinfo stat_fileid.create_time) stat_fileid.downloads intValue - (tblmapinfo stat_fileid.downloads) approval_flag intValue - tblapproval approval_flag ? approval_recordid intValue? - tblmapinfo approval_recordid num_ratings intValue - (tblmapinfo num_ratings) average_rating floatValue - (tblmapinfo average_rating) map_name unicodeStringValue? - tblmapinfo map_name author_name unicodeStringValue? - tblmapinfo author_name high_score shortValue? - tblmapinfo high_score time int64Value? - tblmapinfo time num_contestwins intValue? - ? map_data binaryDataValue? - tblmapinfo map_data my_rating intValue - (tblmapinfo my_rating) # tbljoinplayerfavorites (this is probably a view) FIELD TYPE DEFAULT REFERENCES recordid intValue - tblplayerinfo recordid ownerid intValue - tblplayerinfo ownerid player_name unicodeStringValue - tblplayerinfo player_name name_searchable booleanValue? - tblplayerinfo name_searchable region byteValue - tblplayerinfo region map1 intValue - tblplayerinfo map1 map2 intValue - tblplayerinfo map2 map3 intValue - tblplayerinfo map3 map4 intValue - tblplayerinfo map4 map5 intValue - tblplayerinfo map5 map6 intValue - tblplayerinfo map6 map7 intValue - tblplayerinfo map7 map8 intValue - tblplayerinfo map8 map9 intValue - tblplayerinfo map9 map10 intValue - tblplayerinfo map10 map11 intValue - tblplayerinfo map11 map12 intValue - tblplayerinfo map12 map13 intValue - tblplayerinfo map13 map14 intValue - tblplayerinfo map14 map15 intValue - tblplayerinfo map15 map16 intValue - tblplayerinfo map16 map17 intValue - tblplayerinfo map17 map18 intValue - tblplayerinfo map18 map19 intValue - tblplayerinfo map19 map20 intValue - tblplayerinfo map20 num_fans intValue - tblfavorites (count() number of fans) ? # tblmapinfo FIELD TYPE DEFAULT REFERENCES recordid intValue ownerid intValue stat_fileid intValue stat_fileid.size intValue stat_fileid.create_time dateAndTimeValue stat_fileid.downloads intValue map_name unicodeStringValue author_name unicodeStringValue private booleanValue kit byteValue high_score shortValue region byteValue shape byteValue time int64Value map_data binaryDataValue approval_recordid intValue? num_ratings intValue average_rating floatValue # tblnewsfeed FIELD TYPE DEFAULT REFERENCES recordid intValue ownerid intValue language ? news_title unicodeStringValue? news_content unicodeStringValue? # tblnintendomapinfo FIELD TYPE DEFAULT REFERENCES recordid intValue ownerid intValue stat_fileid intValue stat_fileid.size intValue stat_fileid.create_time dateAndTimeValue stat_fileid.downloads intValue num_ratings intValue average_rating floatValue map_name unicodeStringValue? author_name unicodeStringValue? high_score shortValue? time int64Value? map_data binaryDataValue? my_rating intValue # tblplayerinfo FIELD TYPE DEFAULT REFERENCES recordid intValue N/A ownerid intValue N/A player_name unicodeStringValue '' name_searchable booleanValue? false ? region byteValue ? map1 intValue 0 ? map2 intValue 0 ? map3 intValue 0 ? map4 intValue 0 ? map5 intValue 0 ? map6 intValue 0 ? map7 intValue 0 ? map8 intValue 0 ? map9 intValue 0 ? map10 intValue 0 ? map11 intValue 0 ? map12 intValue 0 ? map13 intValue 0 ? map14 intValue 0 ? map15 intValue 0 ? map16 intValue 0 ? map17 intValue 0 ? map18 intValue 0 ? map19 intValue 0 ? map20 intValue 0 ? my_rating intValue - # tblregioninfo FIELD TYPE DEFAULT REFERENCES recordid intValue ownerid intValue region byteValue? allowed_regions ? min_ratings ? # tblOffensiveMap FIELD TYPE DEFAULT REFERENCES recordid intValue ownerid intValue offensiveid ? intValue? # tblContestSubmissions # tblJoinPlayerAllStats (this is probably a view)