github/TheGame
1
1
Fork 0
mirror of https://github.com/MetaFam/TheGame.git synced 2026-01-15 01:17:57 -05:00
Code Issues Packages Projects Releases Wiki Activity
Files
feature/search-functionality
TheGame/hasura/migrations
History
Udit Takkar f1cc02c1a8 feat: search_player and search_guilds added on hasura
2022-01-27 21:01:46 +05:30
..
1575910000000_init
Add ethereum_address to Player model in order to get the box profile
2020-08-04 20:29:08 -06:00
1595681063913_insert_seed_data
Remove incorrect migration
2020-08-26 02:52:05 -06:00
1597557008749_sourcecred-migration
Setup handler to migrate SC ledger accounts to Database Players
2020-08-16 01:45:27 -06:00
1597563241280_player-ranks
Implement Player Ranks
2020-08-16 01:52:20 -06:00
1597818654956_alter_table_public_Account_drop_constraint_Account_identifier_type_player_key
Remove constraint on Account, allowing a Player to have multiple identifiers of the same type
2020-08-21 10:57:31 -06:00
1597822038999_alter_table_public_Player_add_column_created_at
Setup Trigger to fetch verified accounts from 3box when ETH address gets updated or user gets inserted
2020-08-21 23:04:26 -06:00
1597822046056_alter_table_public_Player_add_column_updated_at
Setup Trigger to fetch verified accounts from 3box when ETH address gets updated or user gets inserted
2020-08-21 23:04:26 -06:00
1598418750227_add_skill_categories
Add skill categories enum
2020-08-26 00:29:27 -06:00
1598420094363_add_skills
Create migration to add skills
2020-08-26 00:29:27 -06:00
1602297882653_account-type-table
Update backend to use enum tables + fix migration trigger (#141)
2020-10-09 22:16:15 -06:00
1602298657385_enneagram-type-table
Update backend to use enum tables + fix migration trigger (#141)
2020-10-09 22:16:15 -06:00
1602389597441_update-skills
Update skills and simplify skill categories (#144)
2020-10-11 00:39:20 -06:00
1602392593424_create-me-view
Implement User Auth on Web (#145)
2020-10-11 11:33:16 -06:00
1602808981811_add_player_type
Setup PlayerTypes in backend (#157)
2020-10-15 19:02:08 -06:00
1602811082541_alter_table_public_Player_add_column_availability_hours
Setup Mutations on web app (#158)
2020-10-16 00:11:07 -06:00
1605730139833_create_table_public_guild_player
Create Player Guilds Table
2020-12-19 20:19:12 -07:00
1605829703638_alter_table_public_Player_add_column_tz
Feature/add timezone backend (#230)
2020-12-19 17:54:32 -07:00
1607539990954_alter_table_public_Guild_add_column_description
Setup Guilds table
2020-12-19 20:19:12 -07:00
1607540645353_update_guild_tyles
Setup Guilds table
2020-12-19 20:19:12 -07:00
1607541858765_create_table_public_guild_account
Setup Guilds table
2020-12-19 20:19:12 -07:00
1608424869168_update_guild_table
Squash Migrations for updating guild table
2020-12-19 20:19:12 -07:00
1608450255714_add_guildname_column
Add guildname field to uniquely identify guilds with friendly id
2020-12-20 01:14:21 -07:00
1609366056194_rename_table_public_Player
Renamed table names to be consistent snake_case (#255)
2021-01-04 23:18:29 -07:00
1609366115237_rename_table_public_Skill
Renamed table names to be consistent snake_case (#255)
2021-01-04 23:18:29 -07:00
1609366185785_rename_table_public_Player_Skill
Renamed table names to be consistent snake_case (#255)
2021-01-04 23:18:29 -07:00
1609366236771_rename_table_public_PlayerType
Renamed table names to be consistent snake_case (#255)
2021-01-04 23:18:29 -07:00
1609366692966_rename_table_public_Guild
Renamed table names to be consistent snake_case (#255)
2021-01-04 23:18:29 -07:00
1609366718077_rename_table_public_Account
Renamed table names to be consistent snake_case (#255)
2021-01-04 23:18:29 -07:00
1609366750413_rename_table_public_Player_Rank
Renamed table names to be consistent snake_case (#255)
2021-01-04 23:18:29 -07:00
1609960864949_alter_table_public_player_drop_column_timezone
Renamed player columns to be consistent snake_case (#262)
2021-01-06 22:08:58 -07:00
1609965105543_player_table_consistent_column_names
Renamed player columns to be consistent snake_case (#262)
2021-01-06 22:08:58 -07:00
1612970700332_quests
Fix repetition default value
2021-02-18 21:00:43 -07:00
1613085907468_add_metafam_discord
Added down migration for metafam/discord account
2021-03-26 21:17:15 -06:00
1614278149225_lowercase_player_username
Revert "Revert "Add username lowercase mutation""
2021-03-09 11:52:01 -07:00
1614710766234_alter_table_public_player_add_check_constraint_username_is_valid
fixed constraints
2021-03-12 22:12:23 -07:00
1615312118803_move_discord_ids
Added migration to move discord_id fields to guild and player
2021-03-26 21:17:15 -06:00
1615328641179_add_guild_status
Added status to guild table
2021-03-26 21:17:15 -06:00
1615534737144_lowercase_player_ethereum_address
Revert "Revert ethereum address lowercase (#407)"
2021-03-12 22:12:23 -07:00
1615534770163_alter_table_public_player_add_check_constraint_ethereum_address_is_valid
fixed constraints
2021-03-12 22:12:23 -07:00
1615594547538_guild_add_discord_metadata_jsonb
Added discord_metadata column to guild, moved inviteUrl there
2021-03-26 21:17:15 -06:00
1615614610171_add_metafam_rank_role_ids
Added migration for metafam rank discord role IDs
2021-03-26 21:17:15 -06:00
1616096764854_move_metafam_discord_id
Added migration to populate metafam discord_id, using that in updateDiscordRole action
2021-03-26 21:17:15 -06:00
1616101057636_create-mtg-color-table
~ minimum code to add color chooser 🔦
2021-03-28 22:08:25 -06:00
1616124361730_drop-enneagram-table
removin' Enneagram table 🏓
2021-03-28 22:08:25 -06:00
1617071740377_guild_separate_discord_invite_url
Re-added guild discord_invite_url column as it should be public
2021-04-21 10:07:34 -06:00
1617733060076_add_guild_discord_ids
Changed oauth handler to use a web URL that calls the backend to exchange the given code
2021-04-21 10:07:34 -06:00
1619844206488_guilds_add_twitter_and_github_urls
Added twitter_url and github_url to guild
2021-05-01 23:50:28 -06:00
1622090276691_require_player_ethaddress
Merge develop into master (#629)
2021-06-07 00:40:36 +05:30
1623037326884_create_guild_metadata_table
Fixed a couple migrations
2021-08-26 10:10:01 -06:00
1623259967735_alter_table_public_player_drop_column_sc_identity_id
Allow users to force-update their linked ETH address
2021-07-05 21:44:14 -06:00
1624277873142_insert_metacartel_ventures_data
Fixed a couple migrations
2021-08-26 10:10:01 -06:00
1624445797214_create_table_public_GuildPosition
Add internal / external position property to guilds (closes #489)
2021-08-10 17:11:59 -04:00
1624445996962_alter_table_public_guild_add_column_position
Add internal / external position property to guilds (closes #489)
2021-08-10 17:11:59 -04:00
1624446029497_set_fk_public_guild_position
Add internal / external position property to guilds (closes #489)
2021-08-10 17:11:59 -04:00
1624473635605_seed_GuildPosition_and_set_guild_positions
Add internal / external position property to guilds (closes #489)
2021-08-10 17:11:59 -04:00
1625633004312_create_table_public_profile_cache
adding timestamp to cache entries & creating initial population 🛩
2021-07-28 06:38:25 +05:30
1625902075375_alter_table_public_profile_cache_add_column_last_checked_at
adding timestamp to cache entries & creating initial population 🛩
2021-07-28 06:38:25 +05:30
1626447130608_alter_table_public_player_add_column_season_xp
made season_xp not null
2021-07-22 12:21:04 +05:30
1626453884524_alter_table_public_player_add_column_pronouns
allow a player to store their pronouns as part of their profile
2021-11-04 22:59:58 -06:00
1626583570730_populate_profile_cache
adding timestamp to cache entries & creating initial population 🛩
2021-07-28 06:38:25 +05:30
1626994599013_add_rank_to_skill_table
Add id and rank field to player_skill
2021-09-07 11:34:03 -06:00
1626996347721_modify_primarykey_public_player_skill
Add id and rank field to player_skill
2021-09-07 11:34:03 -06:00
1626996361256_modify_primarykey_public_player_skill
Add id and rank field to player_skill
2021-09-07 11:34:03 -06:00
1629170747964_alter_table_public_guild_add_column_membership_through_discord
Moved membership_through_discord to guild table from guild_metadata
2021-09-02 15:34:33 -06:00
1630635244186_create_table_public_PlayerRole
Added player_role permissions, playerRoleChanged trigger
2021-09-10 11:25:58 -06:00
1630635736784_add_player_discord_roles
Added player_role join table and PlayerRole enum table
2021-09-10 11:25:58 -06:00
1630636031527_create_table_public_player_role
Added player_role join table and PlayerRole enum table
2021-09-10 11:25:58 -06:00
1630636068495_drop_table_public_guild_account
Added player_role join table and PlayerRole enum table
2021-09-10 11:25:58 -06:00
1631675618782_add_details_to_PlayerRole
First pass at desktop select-roles UI
2021-10-15 21:24:33 -06:00
1643221715030_create_search_players
feat: search_player and search_guilds added on hasura
2022-01-27 21:01:46 +05:30
1643222163099_drop_function_public_search_players
feat: search_player and search_guilds added on hasura
2022-01-27 21:01:46 +05:30
1643223622000_run_create_search
feat: search_player and search_guilds added on hasura
2022-01-27 21:01:46 +05:30
1643224552577_run_search_guild
feat: search_player and search_guilds added on hasura
2022-01-27 21:01:46 +05:30