mirror of
https://git.meshkee.com/Meshkee/backend.git
synced 2026-08-11 22:30:59 +04:30
Ali Reza
bb59d5e9ba
NestJS backend with Prisma, Docker Compose for Postgres/Redis, and deploy docs for the production VM.
10 lines
275 B
SQL
10 lines
275 B
SQL
-- Business i18n fields: name_fa, about (English name uses existing `name` column)
|
|
|
|
ALTER TABLE businesses
|
|
ADD COLUMN IF NOT EXISTS name_fa VARCHAR(255),
|
|
ADD COLUMN IF NOT EXISTS about TEXT;
|
|
|
|
UPDATE businesses
|
|
SET name_fa = COALESCE(name_fa, name)
|
|
WHERE name_fa IS NULL;
|