12 lines
349 B
SQL
12 lines
349 B
SQL
-- +goose Up
|
|
|
|
ALTER TABLE users
|
|
ADD COLUMN distribution_site_id BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '归属分销站点ID (0=主站)' AFTER register_track_code,
|
|
ADD KEY idx_users_distribution_site_id (distribution_site_id);
|
|
|
|
-- +goose Down
|
|
|
|
ALTER TABLE users
|
|
DROP KEY idx_users_distribution_site_id,
|
|
DROP COLUMN distribution_site_id;
|