package schema

// DB9ContentLayoutRepairStatements returns the idempotent TiDB/MySQL repairs
// required before code can query append-log content metadata in an existing DB9
// tenant.
func DB9ContentLayoutRepairStatements() []string {
	return []string{
		`ALTER TABLE files ADD COLUMN IF NOT EXISTS content_layout VARCHAR(32) NOT NULL DEFAULT 'single'`,
		`ALTER TABLE contents ADD COLUMN IF NOT EXISTS content_layout VARCHAR(32) NOT NULL DEFAULT 'single'`,
		`ALTER TABLE file_gc_tasks ADD COLUMN IF NOT EXISTS content_layout VARCHAR(32) NOT NULL DEFAULT 'single'`,
	}
}