ddl

Documentation

Overview

Package ddl provides the Postgres data definition language (DDL) for Vela.

https://en.wikipedia.org/wiki/Data_definition_language

Usage:

import "github.com/go-vela/server/database/postgres/ddl"

Index

• Constants

Constants

const (
	// CreateBuildTable represents a query to
	// create the builds table for Vela.
	CreateBuildTable = `` /* 993-byte string literal not displayed */

	// CreateBuildRepoIDIndex represents a query to create an
	// index on the builds table for the repo_id column.
	CreateBuildRepoIDIndex = `
CREATE INDEX
IF NOT EXISTS
builds_repo_id
ON builds (repo_id);
`

	// CreateBuildStatusIndex represents a query to create an
	// index on the builds table for the status column.
	CreateBuildStatusIndex = `
CREATE INDEX
IF NOT EXISTS
builds_status
ON builds (status);
`

	// CreateBuildCreatedIndex represents a query to create an
	// index on the builds table for the created column.
	CreateBuildCreatedIndex = `
CREATE INDEX CONCURRENTLY
IF NOT EXISTS
builds_created
ON builds (created);
`

	// CreateBuildSourceIndex represents a query to create an
	// index on the builds table for the source column.
	CreateBuildSourceIndex = `
CREATE INDEX CONCURRENTLY
IF NOT EXISTS
builds_source
ON builds (source);
`
)

const (
	// CreateHookTable represents a query to
	// create the hooks table for Vela.
	CreateHookTable = `` /* 438-byte string literal not displayed */

	// CreateHookRepoIDIndex represents a query to create an
	// index on the hooks table for the repo_id column.
	CreateHookRepoIDIndex = `
CREATE INDEX
IF NOT EXISTS
hooks_repo_id
ON hooks (repo_id);
`
)

const (
	// CreateLogTable represents a query to
	// create the logs table for Vela.
	CreateLogTable = `` /* 229-byte string literal not displayed */

	// CreateLogBuildIDIndex represents a query to create an
	// index on the logs table for the build_id column.
	CreateLogBuildIDIndex = `
CREATE INDEX
IF NOT EXISTS
logs_build_id
ON logs (build_id);
`
)

const (
	// CreateSecretTable represents a query to
	// create the secrets table for Vela.
	CreateSecretTable = `` /* 496-byte string literal not displayed */

	// CreateSecretTypeOrgRepo represents a query to create an
	// index on the secrets table for the type, org and repo columns.
	//
	//nolint:gosec // ignore false positive
	CreateSecretTypeOrgRepo = `
CREATE INDEX
IF NOT EXISTS
secrets_type_org_repo
ON secrets (type, org, repo);
`

	// CreateSecretTypeOrgTeam represents a query to create an
	// index on the secrets table for the type, org and team columns.
	//
	//nolint:gosec // ignore false positive
	CreateSecretTypeOrgTeam = `
CREATE INDEX
IF NOT EXISTS
secrets_type_org_team
ON secrets (type, org, team);
`

	// CreateSecretTypeOrg represents a query to create an
	// index on the secrets table for the type, and org columns.
	//
	//nolint:gosec // ignore false positive
	CreateSecretTypeOrg = `
CREATE INDEX
IF NOT EXISTS
secrets_type_org
ON secrets (type, org);
`
)

const (
	// CreateWorkerTable represents a query to
	// create the workers table for Vela.
	CreateWorkerTable = `` /* 275-byte string literal not displayed */

	// CreateWorkerHostnameAddressIndex represents a query to create an
	// index on the workers table for the hostname and address columns.
	CreateWorkerHostnameAddressIndex = `
CREATE INDEX
IF NOT EXISTS
workers_hostname_address
ON workers (hostname, address);
`
)

const (
	// CreateServiceTable represents a query to
	// create the services table for Vela.
	CreateServiceTable = `` /* 474-byte string literal not displayed */

)

const (
	// CreateStepTable represents a query to
	// create the steps table for Vela.
	CreateStepTable = `` /* 500-byte string literal not displayed */

)