github/TheGame
1
1
Fork 0
mirror of https://github.com/MetaFam/TheGame.git synced 2026-04-24 03:00:09 -04:00
Code Issues Packages Projects Releases Wiki Activity
Files
feat/initQuests
TheGame/hasura/migrations
History
dan13ram c2cee16681 feat: setup initiation quests
2022-03-16 00:43:35 +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
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05: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
1638233855361_set_fk_public_player_account_player_id
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1638256399268_alter_table_public_player_alter_column_availability_hours
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1638333712988_alter_table_public_profile_cache_alter_column_country
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1639455871385_rename_table_public_profile_cache
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1639455903307_alter_table_public_profile_alter_column_background_image_url
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1639457137925_alter_table_public_profile_add_column_pronouns
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1639457861149_alter_table_public_profile_add_column_background_image_url
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1639458378073_set_fk_public_profile_player_id
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1639458403546_alter_table_public_profile_add_unique_player_id
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1639458853392_alter_table_public_profile_add_column_username
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1639476052965_alter_table_public_player_drop_column_pronouns
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1639476452544_move_view_username_to_profile
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1639476534860_alter_table_public_player_drop_column_username
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1640057892300_alter_table_public_profile_alter_column_image_url
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1640078300535_move_avaialable_hours_column_to_profile
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1640183267176_move_time_zone_to_profile_table
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1640506201289_move_color_mask_to_profile
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1640517316534_case_insensitive_username_uniqueness
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1640532625675_rename_table_public_player_type
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1640532635456_alter_table_public_ExplorerType_alter_column_imageUrl
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1640532806659_alter_table_public_profile_add_column_explorer_type_title
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1640532883795_set_fk_public_profile_explorer_type_title
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1640533703696_alter_table_public_profile_add_unique_id
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1641576381077_alter_table_public_player_add_column_profile_layout
feat: persisting profile layout changes in hasura
2022-01-09 15:36:17 +05:30
1641640073308_create_table_public_quest_role
chore: consolidate migrations
2022-02-02 10:49:59 -07:00
1641944106670_alter_table_public_player_drop_column_player_type_id
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1642342313101_alter_table_public_quest_role_drop_constraint_quest_role_quest_id_key
chore: consolidate migrations
2022-02-02 10:49:59 -07:00
1642440758431_remove_eth_address_usernames
Reading and Writing Profile Info From Ceramic (#943)
2022-01-25 16:51:53 -05:00
1642635473840_alter_table_public_PlayerRole_add_column_basic
Completed quests widget (#1085)
2022-02-03 10:02:39 +01:00
1642777028373_add_player_roles
Completed quests widget (#1085)
2022-02-03 10:02:39 +01:00
1643682237699_alter_table_public_player_skill_add_unique_player_id_skill_id
Miscellaneous changes pulled from #1078 (#1115)
2022-02-08 06:01:06 -05:00
1644880076911_clear_profile_layouts
Refactor Setup Wizard & Profile Modal Configuration Panes (#1127)
2022-02-28 14:06:16 -05:00
1645298472918_create_table_public_dao
Added permissions, removed moloch_address from guild
2022-03-08 20:26:24 +05:30
1645298885991_create_table_public_dao_player
Added permissions, removed moloch_address from guild
2022-03-08 20:26:24 +05:30
1645304381138_move_guild_dao_addresses
Added permissions, removed moloch_address from guild
2022-03-08 20:26:24 +05:30
1645305421648_alter_table_public_guild_drop_column_moloch_address
Added permissions, removed moloch_address from guild
2022-03-08 20:26:24 +05:30
1645463938163_guarantee_players_exist_in_the_profile_table
Refactor Setup Wizard & Profile Modal Configuration Panes (#1127)
2022-02-28 14:06:16 -05:00
1645725664368_alter_table_public_dao_add_check_constraint_contract_address_is_valid
Added link to edit your own guild
2022-03-08 20:26:24 +05:30
1647370817201_create_table_public_QuestCategory
feat: setup initiation quests
2022-03-16 00:43:35 +05:30
1647370864474_create_quest_categories
feat: setup initiation quests
2022-03-16 00:43:35 +05:30
1647371000674_create_table_public_QuestSubcategory
feat: setup initiation quests
2022-03-16 00:43:35 +05:30
1647371092104_create_initiation_quest_subcategories
feat: setup initiation quests
2022-03-16 00:43:35 +05:30
1647371147682_alter_table_public_quest_alter_column_created_by_player_id
feat: setup initiation quests
2022-03-16 00:43:35 +05:30
1647371161668_alter_table_public_quest_add_column_category
feat: setup initiation quests
2022-03-16 00:43:35 +05:30
1647371196172_alter_table_public_quest_add_column_subcategory_id
feat: setup initiation quests
2022-03-16 00:43:35 +05:30
1647371303973_set_fk_public_quest_category
feat: setup initiation quests
2022-03-16 00:43:35 +05:30
1647371318400_set_fk_public_quest_subcategory_id
feat: setup initiation quests
2022-03-16 00:43:35 +05:30
1647371441360_add_initiation_quests
feat: setup initiation quests
2022-03-16 00:43:35 +05:30