Change Details

`community_requests` * `cr_page` int ... FK to tbl `page` * `cr_status_id` int * `cr_type_id` int * `cr_focus_area_page` int ... FK to `community_requests_focus_areas.crfa_page` (see T388223) * `cr_actor_id` int ... the user who created the wish * `cr_created` datetime `community_requests_translations` * `crt_id` int PK * `cr_id` int ... FK to tbl `community_requests` * `crt_title` string * `crt_other_project` text * `crt_lang_code` string * `crt_is_base_lang` bool The following should be stored in config: * set of projects with `project_id` and msg keys (project-wish links to be stored in [[ https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CommunityRequests/+/refs/heads/master/sql/community_requests_projects.json | community-requests-projects ]]) * set of statuses with `status_id` and msg keys * set of wish types with `type_id` and msg keys Also drop [[ https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CommunityRequests/+/refs/heads/master/sql/community_requests_votes.json | the existing table that stores votes for wishes ]]

`community_requests` * `cr_page` int ... FK to tbl `page` * `cr_status_id` int * `cr_type_id` int * `cr_focus_area_page` int ... FK to `community_requests_focus_areas.crfa_page` (see T388223) * `cr_actor_id` int ... the user who created the wish * `cr_created` datetime `community_requests_translations` * `crt_id` int PK * `cr_id` int ... FK to tbl `community_requests` * `crt_title` binary * `crt_other_project` text * `crt_lang_code` string * `crt_is_base_lang` bool The following should be stored in config: * set of projects with `project_id` and msg keys (project-wish links to be stored in [[ https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CommunityRequests/+/refs/heads/master/sql/community_requests_projects.json | community-requests-projects ]]) * set of statuses with `status_id` and msg keys * set of wish types with `type_id` and msg keys Also drop [[ https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CommunityRequests/+/refs/heads/master/sql/community_requests_votes.json | the existing table that stores votes for wishes ]]

`community_requests` * `cr_page` int ... FK to tbl `page` * `cr_status_id` int * `cr_type_id` int * `cr_focus_area_page` int ... FK to `community_requests_focus_areas.crfa_page` (see T388223) * `cr_actor_id` int ... the user who created the wish * `cr_created` datetime `community_requests_translations` * `crt_id` int PK * `cr_id` int ... FK to tbl `community_requests` * `crt_title` stringbinary * `crt_other_project` text * `crt_lang_code` string * `crt_is_base_lang` bool The following should be stored in config: * set of projects with `project_id` and msg keys (project-wish links to be stored in [[ https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CommunityRequests/+/refs/heads/master/sql/community_requests_projects.json | community-requests-projects ]]) * set of statuses with `status_id` and msg keys * set of wish types with `type_id` and msg keys Also drop [[ https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CommunityRequests/+/refs/heads/master/sql/community_requests_votes.json | the existing table that stores votes for wishes ]]