summaryrefslogtreecommitdiff
path: root/db
Commit message (Collapse)AuthorAgeFilesLines
* Enable serving static objects from an external storagestatic-objects-external-storageAhmad Sherif2019-09-104-0/+57
| | | | | | | | | | 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
* New interruptible attribute supported in YAML parsing.Cédric Tabin2019-09-053-1/+31
| | | | | | | 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-052-0/+33
| | | | | | | 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-052-1/+19
|\ | | | | | | | | 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-042-1/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | 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-042-0/+20
|/ | | | | | | | | | 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-032-0/+12
| | | | | Creates new event when an epic is created, closed, reopened or commented.
* Merge branch 'ab-remove-support-bot-column' into 'master'Yorick Peterse2019-09-032-1/+20
|\ | | | | | | | | Remove Users.support_bot column See merge request gitlab-org/gitlab-ce!32554
| * Remove Users.support_bot columnab-remove-support-bot-columnAndreas Brandl2019-09-022-1/+20
| | | | | | | | | | | | | | This column is not present in `db/schema.rb` and hence needs to be removed conditionally. See https://gitlab.com/gitlab-org/gitlab-ce/issues/66901 for background
* | Fix cycle analytics seed scriptAdam Hegyi2019-09-031-2/+4
| |
* | Added relationships between Release and MilestoneEtienne Baqué2019-09-032-0/+29
| | | | | | | | | | | | 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-022-2/+10
|/
* Replace indexes for counting active usersab-admin-page-user-active-countAndreas Brandl2019-09-022-2/+26
| | | | | | | | | | | | | | | | | | | | | | | 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
* Add production fixture to create projectReuben Pereira2019-08-302-0/+6
| | | | | | Since migrations are not run by new instances, add a production fixture that should ensure that the self-monitoring project is created for new instances as well.
* Rename epic column state to state_idFelipe Artur2019-08-303-1/+35
| | | | | Rename epic column state to state_id to be consistent with issues and merge requests
* Default clusters namespace_per_environment to trueTiger2019-08-302-1/+13
|
* Merge branch 'master' of dev.gitlab.org:gitlab/gitlabhqRobert Speicher2019-08-294-0/+52
|\
| * Merge branch 'security-enable-image-proxy' into 'master'GitLab Release Tools Bot2019-08-292-0/+21
| |\ | | | | | | | | | | | | | | | | | | 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-232-0/+21
| | | | | | | | | | | | | | | | | | 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-292-0/+13
| |\ \ | | | | | | | | | | | | | | | | 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-312-0/+13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-292-1/+19
| |\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-212-1/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-292-1/+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-292-0/+18
| | | | | | | | | | | | | | | | | | | | For Environment.deployed_to_cluster
* | | | | Save board lists collapsed settingFelipe Artur2019-08-282-0/+29
| | | | | | | | | | | | | | | | | | | | Persists if a board list is collapsed for each user.
* | | | | Update CE files for GSD projects filterVictor Zagorodny2019-08-282-1/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* | | | | Adding NOT NULL constraint to private_profileAdam Hegyi2019-08-282-1/+27
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This change sets NOT NULL constraint to users.private profile. closes https://gitlab.com/gitlab-org/gitlab-ce/issues/57538
* | | | | Add limit: 255 to token_ecnrypted column63502-encrypt-deploy-tokenStan Hu2019-08-262-2/+2
| | | | |
* | | | | Added new index to deploy_tokens tableEtienne Baqué2019-08-262-0/+18
| | | | |
* | | | | Iterating through token to encrypt with find_eachEtienne Baqué2019-08-261-2/+2
| | | | |
* | | | | Added migration to encrypt token in DeployToken recordsEtienne Baqué2019-08-264-1/+51
| | | | | | | | | | | | | | | | | | | | | | | | | Added migrations to make token column accepting null values and to add encrypted token column.
* | | | | Using before_save method instead of setterAishwarya Subramanian2019-08-262-1/+17
|/ / / / | | | | | | | | | | | | Removed unused method for name setter method
* | | | Add helper to exactly undo cleanup_concurrent_column_renameReuben Pereira2019-08-252-2/+2
| |_|/ |/| | | | | | | | - Also add helper to undo rename_column_concurrently.
* | | Add a link to docs in project descriptionReuben Pereira2019-08-232-0/+89
| | | | | | | | | | | | Add to the service and migration both.
* | | Adds cop to enforce string limits on migrationsMayra Cabrera2019-08-2370-51/+103
| | | | | | | | | | | | | | | | | | | | | 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-232-1/+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-212-0/+14
| | | | | | | | | | | | | | | | | | | | | 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 service classes for mutating AwardEmojiLuke Duncalfe2019-08-211-24/+11
|/ / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Adding, destroying and toggling emoji previously lacked services and instead were performed through methods called on Awardable models. This led to inconsistencies where relevant todos would be marked as done only when emoji were awarded through our controllers, but not through the API. Todos could also be marked as done when an emoji was being removed. Behaviour changes - Awarding emoji through the API will now mark a relevant Todo as done - Toggling an emoji off (destroying it) through our controllers will no longer mark a relevant Todo as done Closes https://gitlab.com/gitlab-org/gitlab-ce/issues/63372
* | Removed security fixtures as they are ee onlyremove-unused-security-fixturesCameron Swords2019-08-201-74/+1
| | | | | | | | These will be moved to the EE codebase.
* | Add new table to store email domainGosia Ksionek2019-08-162-0/+31
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-163-2/+61
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-153-0/+114
| | | | | | | | | | | | | | 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-153-0/+20
| | | | | | | | | | | | - Adds UI to configure in group and project settings - Removes notification configuration for users when disabled at group or project level
* | Migrate remaining users with null private_profileAdam Hegyi2019-08-142-1/+32
| |
* | Add object storage flag to Geo Node (migration)Gabriel Mazetto2019-08-132-0/+22
| |
* | Merge branch 'ce-docker_image_replication_node_status' into 'master'Douglas Barbosa Alexandre2019-08-102-0/+20
|\ \ | | | | | | | | | | | | 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-072-0/+20
| | | | | | | | | | | | Docker Registry Replication