-- itam_projects.sql
-- migrations/2026_05_28_000001_create_projects_table.sql
CREATE TABLE itam_projects (
id SERIAL PRIMARY KEY,
slug VARCHAR(120) NOT NULL UNIQUE,
client VARCHAR(120) NOT NULL,
started_at DATE NOT NULL,
ended_at DATE NULL,
stack TEXT[] NOT NULL DEFAULT '{}',
is_featured BOOLEAN NOT NULL DEFAULT FALSE
);
CREATE INDEX idx_projects_featured ON itam_projects (is_featured, started_at DESC);
INSERT INTO itam_projects (slug, client, started_at, stack, is_featured) VALUES
('qualidata-pg', 'Qualidata', '2020-11-01', '{postgres,web2}', true),
('sapient-sirius','Sapient France', '2014-06-01', '{php,oracle}', true),
('publicis-msf', 'Médecins sans frontières', '2010-08-01', '{php,plsql}', true),
('freenews-spip', 'Freenews.fr', '2007-01-01', '{spip2,php}', true);