20240101000000_create_users.sql « migrations - dawid/silmataivas.git - Rust weather monitoring service with a RESTful API. Sends personalized alerts based on user thresholds and notification preferences.

summary refs log tree commit diff

path: root/migrations/20240101000000_create_users.sql

blob: 8519916d35891fc4b1832dce007916e2f378bfc4 (plain)

-- Migration: Create users table
CREATE TABLE IF NOT EXISTS users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    user_id TEXT NOT NULL UNIQUE,
    role TEXT NOT NULL DEFAULT 'user'
);