Files
pgson/sql/ddl.go
2025-11-06 16:44:28 +01:00

16 lines
672 B
Go

package sql
var (
DDL_CREATE_TABLE = "CREATE TABLE IF NOT EXISTS %s (\n %s\n);"
DDL_DROP_TABLE = "DROP TABLE IF EXISTS %s;"
DDL_TRUNCATE_TABLE = "TRUNCATE TABLE %s;"
DDL_ALTER_TABLE = "ALTER TABLE %s %s;"
DDL_ADD_COLUMN = "ALTER TABLE %s ADD COLUMN %s;"
DDL_DROP_COLUMN = "ALTER TABLE %s DROP COLUMN %s;"
DDL_ALTER_COLUMN = "ALTER TABLE %s ALTER COLUMN %s %s;"
DDL_ADD_FOREIGN_KEY = "ALTER TABLE %s ADD FOREIGN KEY (%s) REFERENCES %s (%s);"
DDL_DROP_FOREIGN_KEY = "ALTER TABLE %s DROP FOREIGN KEY %s;"
DDL_ADD_CONSTRAINT = "ALTER TABLE %s ADD CONSTRAINT %s %s;"
DDL_DROP_CONSTRAINT = "ALTER TABLE %s DROP CONSTRAINT %s;"
)