pggit

const (
	CreateTableSql = `
CREATE TABLE IF NOT EXISTS %s
(
    id serial,
    ` + fileNameCol + ` character varying(40) COLLATE pg_catalog."default" NOT NULL,
    ` + keyCol + ` character varying(40) COLLATE pg_catalog."default" NOT NULL,
    ` + versionCol + ` character varying(500) COLLATE pg_catalog."default" NOT NULL,
    ` + dataCol + ` bytea,
    date_create timestamp without time zone NOT NULL DEFAULT now(),
    CONSTRAINT %s_pkey PRIMARY KEY (id),
    CONSTRAINT %s_uxk UNIQUE (file_name, key, version)
        WITH (FILLFACTOR=100)
)
`

	DeleteBranchKeySql = `DELETE FROM %s WHERE ` + versionCol + ` = $1 AND ` + keyCol + ` = $2`
	DeleteBranchSql    = `DELETE FROM %s WHERE ` + versionCol + ` = $1`
	UpdateBranchSql    = `UPDATE %s SET ` + versionCol + ` = $1 WHERE ` + versionCol + ` = $2`
	CopyBranchSql      = `
	INSERT INTO %s (` + fileNameCol + `, ` + keyCol + `, ` + dataCol + `, ` + versionCol + `)
	(SELECT ` + fileNameCol + `, ` + keyCol + `, ` + dataCol + `, $1 As ` + versionCol + ` FROM %s WHERE ` + versionCol + ` = $2)
`
)