mirror of
https://github.com/pressly/goose.git
synced 2025-05-31 11:42:04 +00:00
18 lines
354 B
SQL
18 lines
354 B
SQL
-- +goose ENVSUB ON
|
|
-- +goose Up
|
|
CREATE TABLE ${GOOSE_ENV_REGION}post (
|
|
id int NOT NULL,
|
|
title text,
|
|
body text,
|
|
PRIMARY KEY(id)
|
|
); -- 1st stmt
|
|
|
|
-- comment
|
|
SELECT 2; -- 2nd stmt
|
|
SELECT 3; SELECT 3; -- 3rd stmt
|
|
SELECT 4; -- 4th stmt
|
|
|
|
-- +goose Down
|
|
-- comment
|
|
DROP TABLE ${GOOSE_ENV_REGION}post; -- 1st stmt
|