12 lines
399 B
SQL
12 lines
399 B
SQL
-- +goose Up
|
|
ALTER TABLE games
|
|
ADD COLUMN wifi_name TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN wifi_password TEXT NOT NULL DEFAULT '',
|
|
ADD CONSTRAINT games_wifi_name_length CHECK (octet_length(wifi_name) <= 32),
|
|
ADD CONSTRAINT games_wifi_password_length CHECK (octet_length(wifi_password) <= 64);
|
|
|
|
-- +goose Down
|
|
ALTER TABLE games
|
|
DROP COLUMN wifi_name,
|
|
DROP COLUMN wifi_password;
|