dodil/erp-brick-timesheets

DODIL ERP brick: timesheets

src/brick_timesheets/migrations/00002_default_activities_and_rates/up.sql

-- 00002_default_activities_and_rates - data only: the activities every company starts with (company_code '*' = all companies; a company's own row of
-- the same code wins) and the spec's PLACEHOLDER standard cost rates (GBP an hour from 2026-01-01) the customer replaces. Plain INSERTs: the
-- migration journal runs this once.

INSERT INTO ts_activity (company_code, activity_code, valid_from, name, billable_default, internal_only, created_at, updated_at) VALUES
    ('*', 'DEV', DATE '2000-01-01', 'Development', TRUE, FALSE, NOW(), NOW()),
    ('*', 'MEETING', DATE '2000-01-01', 'Meetings', TRUE, FALSE, NOW(), NOW()),
    ('*', 'ADMIN', DATE '2000-01-01', 'Administration', FALSE, FALSE, NOW(), NOW());

INSERT INTO ts_cost_rate (company_code, rate_group, valid_from, rate_amount, currency, set_by, created_at, updated_at) VALUES
    ('*', 'JUNIOR', DATE '2026-01-01', 28.0000, 'GBP', 'migration', NOW(), NOW()),
    ('*', 'SENIOR', DATE '2026-01-01', 52.0000, 'GBP', 'migration', NOW(), NOW()),
    ('*', 'PRINCIPAL', DATE '2026-01-01', 75.0000, 'GBP', 'migration', NOW(), NOW());