api_lixeira_temporaria/migrations/migrations_v3.sql

-- Migration v3: create 'cpr_preregistration' table for CPR pre-registration form
PRAGMA foreign_keys=ON;

CREATE TABLE IF NOT EXISTS cpr_preregistration (
    cpr_id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    contact_number TEXT NOT NULL,
    email TEXT NOT NULL,
    product_type TEXT NOT NULL,
    internal_control_number TEXT NOT NULL,
    product_quantity INTEGER NOT NULL,
    property_name TEXT NOT NULL,
    property_location TEXT NOT NULL,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);