summaryrefslogtreecommitdiff
path: root/db/migrate
Commit message (Collapse)AuthorAgeFilesLines
* Fix member expiration not always workingsh-add-index-members-expiresStan Hu2019-09-111-0/+17
| | | | | | | | | The Sidekiq job `RemoveExpiredMembersWorker` was failing to run in production because it was hitting statement timeouts because it was scanning all rows in order. On staging, where it used to scan 4 million rows, adding an index brought this down to only a few hundred rows. Closes https://gitlab.com/gitlab-org/gitlab-ce/issues/67286
* Merge branch 'static-objects-external-storage' into 'master'Thong Kuah2019-09-113-0/+53
|\ | | | | | | | | Enable serving static objects from an external storage See merge request gitlab-org/gitlab-ce!31025
| * Enable serving static objects from an external storagestatic-objects-external-storageAhmad Sherif2019-09-103-0/+53
| | | | | | | | | | | | | | | | | | | | It consists of two parts: 1. Redirecting users to the configured external storage 1. Allowing the external storage to request the static object(s) on behalf of the user by means of specific tokens Part of https://gitlab.com/gitlab-com/gl-infra/infrastructure/issues/6829
* | Add index on group_id column concurrentlyJan Provaznik2019-09-101-2/+12
| | | | | | | | | | This fixes previously added migration which caused timeouts on big events table.
* | Merge branch 'make-epics-position-migration-robust' into 'master'Andreas Brandl2019-09-091-3/+18
|\ \ | | | | | | | | | | | | | | | | | | Make epic_issues relative_position migration more robust Closes #66923 See merge request gitlab-org/gitlab-ce!32646
| * | Make epic_issues relative_position migration more robustmake-epics-position-migration-robustSean McGivern2019-09-041-3/+18
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | If someone installed EE, then downgraded to CE before this column was added, upgrading to the latest version of CE will fail: 1. We have a backport migration for the entire EE schema but the table `epic_issues` exists, just not the `relative_position` column. 2. The migration that changes the default (quite reasonably) didn't check if the column exists. If the column doesn't exist, we can just create it with the correct default.
* | | Merge branch 'ce-detect-github-pull-requests' into 'master'Kamil Trzciński2019-09-064-0/+74
|\ \ \ | |_|/ |/| | | | | | | | Port CreateGithubPullRequestEvents migration from EE See merge request gitlab-org/gitlab-ce!31802
| * | CE port for pipelines for external pull requestsce-detect-github-pull-requestsFabio Pitino2019-09-054-0/+74
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Detect if pipeline runs for a GitHub pull request When using a mirror for CI/CD only we register a pull_request webhook. When a pull_request webhook is received, if the source branch SHA matches the actual head of the branch in the repository we create immediately a new pipeline for the external pull request. Otherwise we store the pull request info for when the push webhook is received. When using "only/except: external_pull_requests" we can detect if the pipeline has a open pull request on GitHub and create or not the job based on that.
* | | New interruptible attribute supported in YAML parsing.Cédric Tabin2019-09-052-0/+28
| | | | | | | | | | | | | | | | | | | | | Since it is not possible to dynamically detect if a job is automatically cancellable or not, a this new attribute is necessary. Moreover, it let the maintainer of the repo to adjust the behaviour of the auto cancellation feature to match exactly what he needs.
* | | Add structure to support EE feature of COARKerri Miller2019-09-051-0/+31
|/ / | | | | | | | | | | | | These are the structural changes for supporting the EE feature of moving "code_owner_approval_required" state from existing on a project to being on the protected branches individually, allowing for CODEOWNER validation on push events.
* | Merge branch 'ab/unconfirmed-email-index' into 'master'Andreas Brandl2019-09-051-0/+17
|\ \ | | | | | | | | | | | | Create index for users.unconfirmed_email See merge request gitlab-org/gitlab-ce!32664
| * | Create index for users.unconfirmed_emailab/unconfirmed-email-indexAndreas Brandl2019-09-041-0/+17
| |/ | | | | | | | | | | | | | | | | | | | | | | | | This speeds up the following query: ```sql SELECT users.* FROM users WHERE users.unconfirmed_email = ? ORDER BY users.id ASC LIMIT 1 ``` Presumably, this is a query coming from Devise. Context is https://gitlab.com/gitlab-org/gitlab-ce/issues/66958.
* | Create partial index for gitlab-monitor CI metricsab-add-index-for-ci-builds-metricsAndreas Brandl2019-09-041-0/+19
|/ | | | | | | | | | This creates a partial index intended to speed up queries on `ci_builds`. Particularly, `gitlab-monitor` has rather heavy queries. Those have been changed to only look back 7 days and benefit from this index tremendously. Relates to https://gitlab.com/gitlab-org/gitlab-exporter/merge_requests/101.
* Create an event on epic actionsJan Provaznik2019-09-031-0/+9
| | | | | Creates new event when an epic is created, closed, reopened or commented.
* Added relationships between Release and MilestoneEtienne Baqué2019-09-031-0/+20
| | | | | | Modified schema via migrations. Added one-to-one relationship between the two models. Added changelog file
* Add not null constraints to prometheus_metrics table columnsArun Kumar Mohan2019-09-021-0/+8
|
* Replace indexes for counting active usersab-admin-page-user-active-countAndreas Brandl2019-09-021-0/+23
| | | | | | | | | | | | | | | | | | | | | | | This adjusts the partial condition for an index. The index is intended to be used when counting active users with `ghost IS NOT TRUE AND bot_type IS NULL`. With the current index, this wasn't working as the partial condition didn't match the query: `ghost <> TRUE` is not semantically equivalent to `ghost IS NOT TRUE` (null semantics). The reason we add an index particularly intended for EE is that the EE query is going to have the additional part `AND bot_type IS NULL` whereas the CE query doesn't. Logically, it'd be enough to have an index for `ghost IS NOT TRUE`. However, on GitLab.com, the query planner makes poor choices when the additional `AND bot_type IS NULL` part is present: It goes for the index on `bot_type` and doesn't use the partial index. Note the existing index isn't being used at all according to GitLab.com index statistics. Hence we can first remove it and don't have to worry about the window of time without an index. Relates to https://gitlab.com/gitlab-org/gitlab-ce/issues/66770
* Rename epic column state to state_idFelipe Artur2019-08-301-0/+17
| | | | | Rename epic column state to state_id to be consistent with issues and merge requests
* Default clusters namespace_per_environment to trueTiger2019-08-301-0/+12
|
* Merge branch 'master' of dev.gitlab.org:gitlab/gitlabhqRobert Speicher2019-08-293-0/+45
|\
| * Merge branch 'security-enable-image-proxy' into 'master'GitLab Release Tools Bot2019-08-291-0/+16
| |\ | | | | | | | | | | | | | | | | | | Use image proxy to mitigate stealing ip addresses Closes #2812 See merge request gitlab/gitlabhq!2926
| | * disable cop Migration/AddLimitToStringColumnsBrett Walker2019-08-231-2/+2
| | |
| | * Add support for using a Camo proxy serverBrett Walker2019-08-231-0/+16
| | | | | | | | | | | | | | | | | | User images and videos will get proxied through the Camo server in order to keep malicious sites from collecting the IP address of users.
| * | Merge branch 'security-59549-add-capcha-for-failed-logins' into 'master'GitLab Release Tools Bot2019-08-291-0/+12
| |\ \ | | | | | | | | | | | | | | | | Require a captcha after unique failed logins from the same IP See merge request gitlab/gitlabhq!3270
| | * | Add captcha if there are multiple failed login attemptsMałgorzata Ksionek2019-07-311-0/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Add method to store session ids by ip Add new specs for storing session ids Add cleaning up records after login Add retrieving anonymous sessions Add login recaptcha setting Add new setting to sessions controller Add conditions for showing captcha Add sessions controller specs Add admin settings specs for login protection Add new settings to api Add stub to devise spec Add new translation key Add cr remarks Rename class call Add cr remarks Change if-clause for consistency Add cr remarks Add code review remarks Refactor AnonymousSession class Add changelog entry Move AnonymousSession class to lib Move store unauthenticated sessions to sessions controller Move link to recaptcha info Regenerate text file Improve copy on the spam page Change action filter for storing anonymous sessions Fix rubocop offences Add code review remarks
| * | | Merge branch 'security-add-job-activity-limit-ce' into 'master'GitLab Release Tools Bot2019-08-291-0/+17
| |\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Introduce JobActivity limit for alive jobs Closes gitlab-ee#376 See merge request gitlab/gitlabhq!3339
| | * | | Add active_jobs_limit to plans tableFabio Pitino2019-08-211-0/+17
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This is a port from EE changes where we introduce a new limit for Plan model. https://dev.gitlab.org/gitlab/gitlab-ee/merge_requests/1182
* | | | | Remove redundant indexThong Kuah2019-08-291-0/+18
| | | | | | | | | | | | | | | | | | | | | | | | | Now we have cluster_id, state index, we don't the cluster_id index as well.
* | | | | Add index to improve query performanceThong Kuah2019-08-291-0/+17
| | | | | | | | | | | | | | | | | | | | For Environment.deployed_to_cluster
* | | | | Save board lists collapsed settingFelipe Artur2019-08-281-0/+16
| | | | | | | | | | | | | | | | | | | | Persists if a board list is collapsed for each user.
* | | | | Update CE files for GSD projects filterVictor Zagorodny2019-08-281-0/+22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | A new param with_security_reports was added to GET /groups/:id/projects API and the code to support this logic in GroupProjectsFinder and Project model. Also, a DB index was added to ci_job_artifacts table to speed up the search of security reports artifacts for projects
* | | | | Add limit: 255 to token_ecnrypted column63502-encrypt-deploy-tokenStan Hu2019-08-261-1/+1
| | | | |
* | | | | Added new index to deploy_tokens tableEtienne Baqué2019-08-261-0/+17
| | | | |
* | | | | Added migration to encrypt token in DeployToken recordsEtienne Baqué2019-08-262-0/+22
| | | | | | | | | | | | | | | | | | | | | | | | | Added migrations to make token column accepting null values and to add encrypted token column.
* | | | | Using before_save method instead of setterAishwarya Subramanian2019-08-261-0/+14
|/ / / / | | | | | | | | | | | | Removed unused method for name setter method
* | | | Add helper to exactly undo cleanup_concurrent_column_renameReuben Pereira2019-08-251-1/+1
| |_|/ |/| | | | | | | | - Also add helper to undo rename_column_concurrently.
* | | Adds cop to enforce string limits on migrationsMayra Cabrera2019-08-2367-48/+100
| | | | | | | | | | | | | | | | | | | | | This cop will analyze migrations that add columns with string, and report an offense if the string has no limit enforced Related to https://gitlab.com/gitlab-org/gitlab-ce/issues/64505
* | | Remove redundant indexSean Carroll2019-08-231-0/+21
| | |
* | | This commit adds a new time series componentMiguel Rincon2019-08-211-0/+13
| | | | | | | | | | | | | | | | | | | | | | | | Adds a time series component for line and area charts. Displays new charts in the dashboard. - Use dynamic components for line/area swapping - Add new line charts to dashboard in 2 panels
* | | Add SortingPreference concernGeorge Koltsov2019-08-211-0/+13
|/ / | | | | | | | | | | | | Sorting preference functionality has been extracted from `IssuableCollections` to a new `SortingPreference` concern in order to reuse this functionality in projects (and groups in the future).
* | Add new table to store email domainGosia Ksionek2019-08-161-0/+22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | In order to save user preferences regarding user emails allowed to be invited to group Add foreign_key and down method Change adding foreign key Add partial call to view Add changelog entry Fix schema
* | Optimize DB indexes for ES indexing of notesMarkus Koller2019-08-162-0/+59
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | To index notes, we exclude system notes and use `find_in_batches` to load them in batches for submission to the ES bulk import API. These queries often result in DB timeouts because the usage of `ORDER BY id` results in the `notes_pkey` index being used. This adds an optimized partial index, and removes the unused index `index_notes_on_noteable_type` which is already covered for our usage by the existing `index_notes_on_noteable_id_and_noteable_type`. Newer versions of PostgreSQL (at least 11) are smarter about this and use `index_notes_on_project_id_and_noteable_type` instead, so we might be able to remove the partial index again in the future.
* | Migrations for Cycle Analytics backendAdam Hegyi2019-08-152-0/+70
| | | | | | | | | | | | | | This change lays the foundation for customizable cycle analytics stages. The main reason for the change is to extract the event definitions to separate objects (start_event, end_event) so that it could be easily customized later on.
* | Allow disabling group/project email notificationsBrett Walker2019-08-152-0/+18
| | | | | | | | | | | | - Adds UI to configure in group and project settings - Removes notification configuration for users when disabled at group or project level
* | Add object storage flag to Geo Node (migration)Gabriel Mazetto2019-08-131-0/+21
| |
* | Merge branch 'ce-docker_image_replication_node_status' into 'master'Douglas Barbosa Alexandre2019-08-101-0/+16
|\ \ | | | | | | | | | | | | Backport of https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/14943 See merge request gitlab-org/gitlab-ce!31406
| * | Backport of https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/14943ce-docker_image_replication_node_statusValery Sizov2019-08-071-0/+16
| | | | | | | | | | | | Docker Registry Replication
* | | Merge branch ↵Bob Van Landuyt2019-08-091-0/+10
|\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | '13208-epicissue-has-an-unexpected-default-relative-position-ce' into 'master' [CE] Remove default `relative_position` from `epic_issues` See merge request gitlab-org/gitlab-ce!31514
| * | | Remove default relative_position value13208-epicissue-has-an-unexpected-default-relative-position-ceHeinrich Lee Yu2019-08-091-0/+10
| | | | | | | | | | | | | | | | | | | | This makes `epic_issues` consistent with other tables using our `RelativePositioning` class
* | | | Revert "Merge branch ↵Winnie Hellmann2019-08-091-24/+0
| | | | | | | | | | | | | | | | | | | | | | | | '4221-board-milestone-should-persist-any-none-properly-ce' into 'master'" This reverts merge request !30613