18 lines
571 B
SQL
18 lines
571 B
SQL
ALTER TABLE social_account
|
|
ADD COLUMN name text,
|
|
ADD COLUMN tags text[];
|
|
|
|
UPDATE social_account
|
|
SET name = platform_account_key,
|
|
tags = ARRAY[]::text[];
|
|
|
|
ALTER TABLE social_account
|
|
ALTER COLUMN name SET NOT NULL,
|
|
ALTER COLUMN name SET DEFAULT '未命名账号',
|
|
ALTER COLUMN tags SET NOT NULL,
|
|
ALTER COLUMN tags SET DEFAULT ARRAY[]::text[],
|
|
ADD CONSTRAINT social_account_name_check
|
|
CHECK (name = btrim(name) AND length(name) BETWEEN 1 AND 128),
|
|
ADD CONSTRAINT social_account_tags_check
|
|
CHECK (cardinality(tags) <= 20);
|