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
300 B
SQL
10 lines
300 B
SQL
ALTER TABLE domains
|
|
ADD COLUMN IF NOT EXISTS expires_at TIMESTAMPTZ,
|
|
ADD COLUMN IF NOT EXISTS is_active BOOLEAN NOT NULL DEFAULT TRUE;
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_domains_is_active ON domains (is_active);
|
|
|
|
UPDATE domains
|
|
SET expires_at = NOW() + INTERVAL '365 days'
|
|
WHERE expires_at IS NULL;
|