Spaces:

MuhammedSuhaib
/

todo-fastapi

Sleeping

todo-fastapi / update_neon_schema.sql

Deployment via uv

cdaf146 verified 10 months ago

487 Bytes

-- Phase II Neon schema (tasks only)
-- Backend is JWT-verify only, no user table

CREATE TABLE IF NOT EXISTS task (
  id SERIAL PRIMARY KEY,
  user_id TEXT NOT NULL,
  title TEXT NOT NULL,
  description TEXT,
  completed BOOLEAN DEFAULT FALSE,
  priority TEXT DEFAULT 'medium',
  category TEXT,
  tags JSONB DEFAULT '[]',
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX IF NOT EXISTS idx_task_user_id ON task(user_id);

	-- Phase II Neon schema (tasks only)
	-- Backend is JWT-verify only, no user table

	CREATE TABLE IF NOT EXISTS task (
	id SERIAL PRIMARY KEY,
	user_id TEXT NOT NULL,
	title TEXT NOT NULL,
	description TEXT,
	completed BOOLEAN DEFAULT FALSE,
	priority TEXT DEFAULT 'medium',
	category TEXT,
	tags JSONB DEFAULT '[]',
	created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
	updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
	);

	CREATE INDEX IF NOT EXISTS idx_task_user_id ON task(user_id);