Skip to main content
Homepage
Explore
Search or go to…
/
Sign in
Explore
Primary navigation
Project
M
Migrations
Manage
Activity
Members
Labels
Plan
Wiki
Code
Merge requests
Repository
Branches
Commits
Tags
Repository graph
Compare revisions
Locked files
Deploy
Releases
Package registry
Container registry
Model registry
Operate
Environments
Terraform modules
Analyze
Value stream analytics
Contributor analytics
Repository analytics
Code review analytics
Insights
Model experiments
Help
Help
Support
GitLab documentation
Compare GitLab plans
GitLab community forum
Contribute to GitLab
Provide feedback
Terms and privacy
Keyboard shortcuts
?
Collapse sidebar
Snippets
Groups
Projects
Show more breadcrumbs
Coscine
backend
libraries
Migrations
Merge requests
!95
This project is archived. Its data is
read-only
.
New: Index on Log table
Code
Review changes
Check out branch
Open in Workspace
Download
Patches
Plain diff
Expand sidebar
Merged
New: Index on Log table
Issue/2284-dbLogIndex
into
master
Overview
0
Commits
5
Pipelines
5
Changes
2
Merged
New: Index on Log table
Petar Hristov
requested to merge
Issue/2284-dbLogIndex
into
master
Nov 4, 2022
Overview
0
Commits
5
Pipelines
5
Changes
2
coscine/issues#2284
MR to
master
is intended. Has to be released swiftly.
Edited
Nov 4, 2022
by
Petar Hristov
0
0
Merge request reports
Compare
master
version 4
439f53e2
Nov 7, 2022
version 3
7695433b
Nov 7, 2022
version 2
f51cd3dc
Nov 4, 2022
version 1
c35c2a42
Nov 4, 2022
master (base)
and
latest version
latest version
e3ee6137
5 commits,
Nov 7, 2022
version 4
439f53e2
4 commits,
Nov 7, 2022
version 3
7695433b
3 commits,
Nov 7, 2022
version 2
f51cd3dc
2 commits,
Nov 4, 2022
version 1
c35c2a42
1 commit,
Nov 4, 2022
2 files
+
23
−
1
Inline
Compare changes
Side-by-side
Inline
Show whitespace changes
Show one file at a time
Files
2
src/Migrations/Migrations/Migration202211040919LogDbIndex.cs
0 → 100644
+
22
−
0
View file @ e3ee6137
Edit in single-file editor
Open in Web IDE
using
FluentMigrator
;
namespace
Coscine.Migrations.Migrations
{
//yyyymmddhhmm
[
Migration
(
202211040919
)]
public
class
Migration202211040919LogDbIndex
:
Migration
{
public
override
void
Down
()
{
Delete
.
Index
(
"log_idx_userid_loglevel_servertime"
).
OnTable
(
"Log"
);
}
public
override
void
Up
()
{
Create
.
Index
(
"log_idx_userid_loglevel_servertime"
).
OnTable
(
"Log"
)
.
OnColumn
(
"UserId"
).
Ascending
()
.
OnColumn
(
"LogLevel"
).
Ascending
()
.
OnColumn
(
"ServerTimestamp"
).
Ascending
();
}
}
}
\ No newline at end of file
Loading