Files
migrate/database/spanner/examples/migrations/1621360367_create_transactions_table.up.sql
Kyle ChadhaandGitHub 0bb216be40 fix(spanner): upgrade spanner client to latest to support NUMERIC types (#565)
* fix(spanner): upgrade spanner client to latest to support NUMERIC types

* run go mod tidy

* Add spanner example migration test case
2021-05-18 22:16:21 -07:00

7 lines
187 B
SQL

CREATE TABLE Transactions (
UserId INT64,
TransactionId STRING(40),
Total NUMERIC
) PRIMARY KEY(UserId, TransactionId),
INTERLEAVE IN PARENT Users ON DELETE CASCADE