Record Shift Hours

Log work for rkpatech.com client contracts

Subcontractor

Client Block Contract *

Work Date *

Hours Worked *

Category / Task

Detailed Work Description *

Recent Shift Timecards

Your logged hours and linked client retainer blocks

4 entries

Date	Contractor	Client Block	Hours	Status	Actions
2026-10-01	Alex Rivers	Apex Global Logistics	8.00 hrs	Approved	Locked
2026-10-02	Alex Rivers	Apex Global Logistics	4.00 hrs	Approved	Locked
2026-10-01	Sarah Jenkins	Vanguard Health Tech	7.50 hrs	Approved	Locked
2026-10-02	Sarah Jenkins	Vanguard Health Tech	5.00 hrs	Pending

Client Block Hours & Activity Report Generator

Generate branded client statements for block hour retainers

Select Client Contract *

Start Date

End Date

rkpatech.com

Block Hours Statement & Deliverables Report

Apex Global Logistics

Date Range: 2026-10-01 - 2026-10-31

Purchased Block 100.00 hrs

Period Usage 12.00 hrs

Lifetime Used 12.00 hrs

Remaining Balance 88.00 hrs

Itemized Task & Hours Log

Work Date	Resource / Engineer	Category	Deliverables & Detailed Activity	Hours Deducted
2026-10-01	Alex Rivers	Cloud Infrastructure	Configured AWS VPC security groups & VPN access rules for Apex Global	8.00 hrs
2026-10-02	Alex Rivers	Server Maintenance	Optimized PostgreSQL database indexes and automated nightly backup scripts	4.00 hrs
Total Deducted Period Hours				12.00 hrs

Add Subcontractor

Contractor Full Name *

Email / Username (@rkpatech.com) *

Password *

Pay Rate ($/hr)

Status

RK Tech Subcontractor Roster

Active accounts for rkpatech.com

2 active

Name	rkpatech.com Email	Pay Rate	Status	Actions
Alex Rivers	alex@rkpatech.com	$50.00/hr	Active
Sarah Jenkins	sarah@rkpatech.com	$65.00/hr	Active

Month Filter

Contractor

Status Filter

Date	Contractor	Client Block Contract	Deliverables	Hours	Pay Amount	Status
2026-10-02	Alex Rivers	Apex Global Logistics	Optimized PostgreSQL database indexes and automated nightly backup scripts	4.00 hrs	$200.00	Approved
2026-10-02	Sarah Jenkins	Vanguard Health Tech	Integrated OAuth2 authentication layer and endpoint validation	5.00 hrs	$325.00	Pending
2026-10-01	Alex Rivers	Apex Global Logistics	Configured AWS VPC security groups & VPN access rules for Apex Global	8.00 hrs	$400.00	Approved
2026-10-01	Sarah Jenkins	Vanguard Health Tech	Built React dashboard component for Vanguard patient intake portal	7.50 hrs	$487.50	Approved

RK Tech Monthly Payout Statement

Export formatted summaries for Square Up & QuickBooks payout processing

Pay Period Month:

Subcontractor	Pay Period	Approved Shifts	Hours	Pay Rate	Total Payment Due
Alex Rivers	2026-10	2 shift(s)	12.00 hrs	$50.00/hr	$600.00
Sarah Jenkins	2026-10	1 shift(s)	7.50 hrs	$65.00/hr	$487.50
Grand Total Payout			19.50 hrs	-	$1087.50

// functions/api.js export async function onRequest(context) { const { request, env } = context; const url = new URL(request.url); const action = url.searchParams.get("action"); const headers = { "Content-Type": "application/json", "Access-Control-Allow-Origin": "*" }; try { // 1. SYNC GET ALL DATA if (request.method === "GET" && action === "sync") { const users = await env.DB.prepare("SELECT * FROM users").all(); const timecards = await env.DB.prepare("SELECT * FROM timecards ORDER BY date DESC").all(); const contracts = await env.DB.prepare("SELECT * FROM contracts").all(); return new Response(JSON.stringify({ users: users.results || [], timecards: timecards.results || [], contracts: contracts.results || [] }), { headers }); } // 2. SAVE TIMECARD if (request.method === "POST" && action === "saveTimecard") { const card = await request.json(); await env.DB.prepare(` INSERT INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT(id) DO UPDATE SET hours=excluded.hours, date=excluded.date, category=excluded.category, notes=excluded.notes, contract_id=excluded.contract_id, status=excluded.status `).bind(card.id, card.userEmail, card.userName, card.date, card.hours, card.rate, card.category, card.notes, card.contractId, card.status).run(); return new Response(JSON.stringify({ success: true }), { headers }); } // 3. DELETE TIMECARD if (request.method === "POST" && action === "deleteTimecard") { const { id } = await request.json(); await env.DB.prepare("DELETE FROM timecards WHERE id = ?").bind(id).run(); return new Response(JSON.stringify({ success: true }), { headers }); } // 4. SAVE CONTRACTOR if (request.method === "POST" && action === "saveUser") { const user = await request.json(); await env.DB.prepare(` INSERT INTO users (id, name, email, password, role, hourly_rate, status) VALUES (?, ?, ?, ?, ?, ?, ?) ON CONFLICT(id) DO UPDATE SET name=excluded.name, email=excluded.email, password=excluded.password, hourly_rate=excluded.hourly_rate, status=excluded.status `).bind(user.id, user.name, user.email, user.password, user.role, user.hourly_rate, user.status).run(); return new Response(JSON.stringify({ success: true }), { headers }); } // 5. DELETE CONTRACTOR if (request.method === "POST" && action === "deleteUser") { const { id } = await request.json(); await env.DB.prepare("DELETE FROM users WHERE id = ?").bind(id).run(); return new Response(JSON.stringify({ success: true }), { headers }); } // 6. SAVE BLOCK CONTRACT if (request.method === "POST" && action === "saveContract") { const c = await request.json(); await env.DB.prepare(` INSERT INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES (?, ?, ?, ?, ?, ?, ?) ON CONFLICT(id) DO UPDATE SET client_name=excluded.client_name, title=excluded.title, total_hours=excluded.total_hours, hourly_rate=excluded.hourly_rate, low_threshold=excluded.low_threshold, status=excluded.status `).bind(c.id, c.client_name, c.title, c.total_hours, c.hourly_rate, c.low_threshold, c.status).run(); return new Response(JSON.stringify({ success: true }), { headers }); } // 7. DELETE BLOCK CONTRACT if (request.method === "POST" && action === "deleteContract") { const { id } = await request.json(); await env.DB.prepare("DELETE FROM contracts WHERE id = ?").bind(id).run(); return new Response(JSON.stringify({ success: true }), { headers }); } return new Response(JSON.stringify({ error: "Invalid Action" }), { status: 400, headers }); } catch (err) { return new Response(JSON.stringify({ error: err.message }), { status: 500, headers }); } }

-- Cloudflare D1 Database Schema for RK Tech -- Run this in Cloudflare D1 Console or via Wrangler CLI CREATE TABLE IF NOT EXISTS users ( id TEXT PRIMARY KEY, name TEXT NOT NULL, email TEXT UNIQUE NOT NULL, password TEXT NOT NULL, role TEXT DEFAULT 'CONTRACTOR', hourly_rate REAL DEFAULT 0.0, status TEXT DEFAULT 'Active' ); CREATE TABLE IF NOT EXISTS timecards ( id TEXT PRIMARY KEY, user_email TEXT NOT NULL, user_name TEXT NOT NULL, date TEXT NOT NULL, hours REAL NOT NULL, rate REAL DEFAULT 0.0, category TEXT, notes TEXT, contract_id TEXT, status TEXT DEFAULT 'Pending' ); CREATE TABLE IF NOT EXISTS contracts ( id TEXT PRIMARY KEY, client_name TEXT NOT NULL, title TEXT NOT NULL, total_hours REAL NOT NULL, hourly_rate REAL DEFAULT 0.0, low_threshold REAL DEFAULT 10.0, status TEXT DEFAULT 'Active' ); -- Seed Default Admin & Contractor Accounts for rkpatech.com INSERT OR IGNORE INTO users (id, name, email, password, role, hourly_rate, status) VALUES ('u_admin', 'RK Tech Manager', 'admin@rkpatech.com', 'rk_1041928091', 'ADMIN', 0.0, 'Active'), ('c1', 'Alex Rivers', 'alex@rkpatech.com', 'rk_128823194', 'CONTRACTOR', 50.0, 'Active'), ('c2', 'Sarah Jenkins', 'sarah@rkpatech.com', 'rk_128823194', 'CONTRACTOR', 65.0, 'Active'); -- Seed Sample Client Retainer Blocks INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard component for Vanguard patient intake portal', 'blk2', 'Approved'), ('e4', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-02', 5.0, 65.0, 'API Integration', 'Integrated OAuth2 authentication layer and endpoint validation', 'blk2', 'Pending'); -- Seed Sample Block Contracts INSERT OR IGNORE INTO contracts (id, client_name, title, total_hours, hourly_rate, low_threshold, status) VALUES ('blk1', 'Apex Global Logistics', 'Q4 100-Hour Managed Infrastructure Retainer', 100.0, 125.0, 15.0, 'Active'), ('blk2', 'Vanguard Health Tech', 'Q4 50-Hour Custom Software Development Block', 50.0, 150.0, 8.0, 'Active'), ('blk3', 'Summit Capital Partners', 'Adhoc Systems Support Retainer', 25.0, 110.0, 5.0, 'Active'); -- Seed Sample Timecards INSERT OR IGNORE INTO timecards (id, user_email, user_name, date, hours, rate, category, notes, contract_id, status) VALUES ('e1', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-01', 8.0, 50.0, 'Cloud Infrastructure', 'Configured AWS VPC security groups & VPN access rules for Apex Global', 'blk1', 'Approved'), ('e2', 'alex@rkpatech.com', 'Alex Rivers', '2026-10-02', 4.0, 50.0, 'Server Maintenance', 'Optimized PostgreSQL database indexes and automated nightly backup scripts', 'blk1', 'Approved'), ('e3', 'sarah@rkpatech.com', 'Sarah Jenkins', '2026-10-01', 7.5, 65.0, 'Frontend Development', 'Built React dashboard }; contractors.push(targetContractor); } saveData(); if (isD1Connected && targetContractor) { try { await fetch('/api?action=saveUser', { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ id: targetContractor.id, name: targetContractor.name, email: targetContractor.email, password: targetContractor.passwordHash, role: 'CONTRACTOR', hourly_rate: targetContractor.defaultRate, status: targetContractor.status }) }); } catch(err) {} } resetContractorForm(); renderAllViews(); showNotification('Subcontractor profile saved!'); } function editContractor(id) { const item = contractors.find(c => c.id === id); if (!item) return; document.getElementById('manage-contractor-id').value = item.id; document.getElementById('manage-contractor-name').value = item.name; document.getElementById('manage-contractor-email').value = item.email || ''; document.getElementById('manage-contractor-password').value = ''; document.getElementById('manage-contractor-password').placeholder = 'Leave blank to keep existing'; document.getElementById('manage-contractor-password').required = false; document.getElementById('manage-contractor-rate').value = item.defaultRate; document.getElementById('manage-contractor-status').value = item.status; document.getElementById('contractor-form-title').innerText = 'Edit Subcontractor'; document.getElementById('manage-contractor-btn-text').innerText = 'Update Profile'; document.getElementById('cancel-contractor-edit-btn').classList.remove('hidden'); } function resetContractorForm() { document.getElementById('contractor-management-form').reset(); document.getElementById('manage-contractor-id').value = ''; document.getElementById('manage-contractor-password').required = true; document.getElementById('manage-contractor-password').placeholder = 'pass123'; document.getElementById('contractor-form-title').innerText = 'Add Subcontractor'; document.getElementById('manage-contractor-btn-text').innerText = 'Save Contractor'; document.getElementById('cancel-contractor-edit-btn').classList.add('hidden'); } function renderContractorManagementList() { const tbody = document.getElementById('contractors-list-table-body'); document.getElementById('active-contractors-count').textContent = `${contractors.length} active`; if (contractors.length === 0) { tbody.innerHTML = `No subcontractors configured.`; return; } tbody.innerHTML = contractors.map(c => ` ${escapeHtml(c.name)} ${escapeHtml(c.email || 'N/A')} $${c.defaultRate.toFixed(2)}/hr ${c.status} `).join(''); } async function deleteContractor(id) { const contractor = contractors.find(c => c.id === id); if (!contractor) return; if (confirm(`Are you sure you want to delete contractor "${contractor.name}"?\n\nThis will remove their user login account.`)) { contractors = contractors.filter(c => c.id !== id); saveData(); if (isD1Connected) { try { await fetch('/api?action=deleteUser', { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ id }) }); } catch(e) {} } renderAllViews(); showNotification(`Contractor "${contractor.name}" deleted.`); } } function toggleChangePasswordModal(show) { document.getElementById('change-password-modal').classList.toggle('hidden', !show); } function handleChangePasswordSubmit(e) { e.preventDefault(); const newPass = document.getElementById('new-password-input').value; const newHash = hashPassword(newPass); if (currentUser.role === 'ADMIN') { ADMIN_USER.passwordHash = newHash; showNotification('Admin password updated!'); } else { const idx = contractors.findIndex(c => c.id === currentUser.contractor.id); if (idx !== -1) { contractors[idx].passwordHash = newHash; currentUser.contractor.passwordHash = newHash; saveData(); localStorage.setItem(STORAGE_SESSION_KEY, JSON.stringify(currentUser)); showNotification('Password updated successfully!'); } } document.getElementById('new-password-input').value = ''; toggleChangePasswordModal(false); } function renderApprovalTable() { const monthFilter = document.getElementById('approval-month-filter').value; const contractorFilter = document.getElementById('approval-contractor-filter').value; const statusFilter = document.getElementById('approval-status-filter').value; let filtered = entries.filter(e => { const mMatch = !monthFilter || e.date.startsWith(monthFilter); const cMatch = contractorFilter === 'ALL' || e.contractorId === contractorFilter; const sMatch = statusFilter === 'ALL' || e.status === statusFilter; return mMatch && cMatch && sMatch; }).sort((a,b) => new Date(b.date) - new Date(a.date)); const tbody = document.getElementById('approvals-table-body'); if (filtered.length === 0) { tbody.innerHTML = `No timecards match current filters.`; return; } tbody.innerHTML = filtered.map(e => { const totalPay = e.hours * (e.rate || 0); const blockObj = blockContracts.find(b => b.id === e.blockContractId); return ` ${e.date} ${escapeHtml(e.contractorName)} ${blockObj ? escapeHtml(blockObj.clientName) : 'Unlinked'} ${escapeHtml(e.description)} ${e.hours.toFixed(2)} hrs $${totalPay.toFixed(2)} ${e.status} `; }).join(''); } async function updateEntryStatus(id, newStatus) { const item = entries.find(e => e.id === id); if (item) { item.status = newStatus; saveData(); if (isD1Connected) { try { const contractorObj = contractors.find(c => c.id === item.contractorId); await fetch('/api?action=saveTimecard', { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ id: item.id, userEmail: contractorObj ? contractorObj.email : 'admin@rkpatech.com', userName: item.contractorName, date: item.date, hours: item.hours, rate: item.rate, category: item.project, notes: item.description, contractId: item.blockContractId, status: newStatus }) }); } catch(e) {} } renderAllViews(); } } function bulkApprovePending() { entries.forEach(e => { if (e.status === 'Pending') e.status = 'Approved'; }); saveData(); renderAllViews(); showNotification('Pending shifts approved!'); } function updatePendingAndAlertBadges() { const pendingCount = entries.filter(e => e.status === 'Pending').length; document.getElementById('pending-count-badge').textContent = pendingCount; const lowBalanceCount = blockContracts.filter(b => { const stats = calculateBlockContractStats(b.id); return b.status === 'Active' && stats.isLowBalance; }).length; const alertBadge = document.getElementById('low-balance-alert-badge'); if (lowBalanceCount > 0) { alertBadge.classList.remove('hidden'); } else { alertBadge.classList.add('hidden'); } } function renderPayoutSummary() { const payoutMonth = document.getElementById('payout-month-select').value; const filtered = entries.filter(e => (!payoutMonth || e.date.startsWith(payoutMonth)) && (e.status === 'Approved' || e.status === 'Paid')); const aggregated = {}; filtered.forEach(e => { if (!aggregated[e.contractorName]) { aggregated[e.contractorName] = { contractorName: e.contractorName, shiftsCount: 0, totalHours: 0, totalPayout: 0, rate: e.rate }; } aggregated[e.contractorName].shiftsCount += 1; aggregated[e.contractorName].totalHours += e.hours; aggregated[e.contractorName].totalPayout += (e.hours * (e.rate || 0)); }); const tbody = document.getElementById('payout-table-body'); const list = Object.values(aggregated); let totalHours = 0; let totalPayout = 0; if (list.length === 0) { tbody.innerHTML = `No approved work recorded for ${payoutMonth}.`; } else { tbody.innerHTML = list.map(item => { totalHours += item.totalHours; totalPayout += item.totalPayout; return ` ${escapeHtml(item.contractorName)} ${payoutMonth} ${item.shiftsCount} shift(s) ${item.totalHours.toFixed(2)} hrs $${item.rate.toFixed(2)}/hr $${item.totalPayout.toFixed(2)} `; }).join(''); } document.getElementById('payout-grand-hours').textContent = `${totalHours.toFixed(2)} hrs`; document.getElementById('payout-grand-total').textContent = `$${totalPayout.toFixed(2)}`; } function exportToCSV() { const payoutMonth = document.getElementById('payout-month-select').value; const filtered = entries.filter(e => !payoutMonth || e.date.startsWith(payoutMonth)); if (filtered.length === 0) { alert('No data available to export.'); return; } const headers = ['Subcontractor', 'Date', 'Project', 'Hours', 'Rate', 'Total Pay', 'Status', 'Description']; const rows = filtered.map(e => [ `"${e.contractorName}"`, `"${e.date}"`, `"${e.project}"`, e.hours.toFixed(2), (e.rate || 0).toFixed(2), (e.hours * (e.rate || 0)).toFixed(2), `"${e.status}"`, `"${e.description.replace(/"/g, '""')}"` ]); const csvContent = 'data:text/csv;charset=utf-8,' + [headers.join(','), ...rows.map(r => r.join(','))].join('\n'); const encodedUri = encodeURI(csvContent); const link = document.createElement('a'); link.setAttribute('href', encodedUri); link.setAttribute('download', `RKTech_Payouts_${payoutMonth || 'All'}.csv`); document.body.appendChild(link); link.click(); document.body.removeChild(link); } // Dynamic Project Folder ZIP Exporter function downloadProjectBundleZip() { const zip = new JSZip(); // Root index.html (Clean app without studio bar for production) const htmlClean = document.documentElement.outerHTML.replace(/

Record Shift Hours

Recent Shift Timecards

Create Block Contract

Client Block Retainers Overview