Refactor: unify database columns

[zc-devs]

Clear and concise description of the problem

There are examples of entities:

type Pipeline struct {
	ID                  int64                   `json:"id"                      xorm:"pk autoincr 'pipeline_id'"`
	Status              StatusValue             `json:"status"                  xorm:"INDEX 'pipeline_status'"`
	ChangedFiles        []string                `json:"changed_files,omitempty" xorm:"LONGTEXT 'changed_files'"`
	PullRequestLabels   []string                `json:"pr_labels,omitempty"     xorm:"json 'pr_labels'"`

type Step struct {
	ID         int64       `json:"id"                   xorm:"pk autoincr 'step_id'"`
	Type       StepType    `json:"type,omitempty"       xorm:"step_type"`
	Name       string      `json:"name"                 xorm:"step_name"`
	State      StatusValue `json:"state"                xorm:"step_state"`

type LogEntry struct {
	ID      int64        `json:"id"       xorm:"pk autoincr 'id'"`
	StepID  int64        `json:"step_id"  xorm:"INDEX 'step_id'"`
	Created int64        `json:"-"        xorm:"created"`

Suggested solution

Get rid of useless prefixes like pipeline_ in pipelines table, step_ in steps table and so on. Exception is link to other entities like step_id in log_entries table.

Alternative

No response

Additional context

No response

Validations

• Checked that the feature isn't part of the next version already [https://woodpecker-ci.org/faq#which-version-of-woodpecker-should-i-use]
• Read the docs.
• Check that there isn't already an issue that request the same feature to avoid creating a duplicate.

[qwerty287]

Similar for table names: some are singular, some plural.