sample.sql

use AulasTech2;

-- Schools
insert into tb_schools (name) values
('Escola Técnica Recife'),
('Colégio Glória'),
('Instituto de Tecnologia Pernambuco');

-- Users
insert into tb_user (user, name) values
('ANDRE_SANTOS', 'André Santos'), -- system admin
('MARIA_SILVA', 'Maria Silva'),
('JOAO_PEREIRA', 'João Pereira'),
('CARLA_MELO', 'Carla Melo'),
('PEDRO_ALMEIDA', 'Pedro Almeida'),
('ANA_COSTA', 'Ana Costa'),
('LUCAS_FERREIRA', 'Lucas Ferreira');

-- User–School relationships
-- Maria Silva enrolled in all 3 schools
insert into tb_user_school (user, id_school) values
('MARIA_SILVA', 1), ('MARIA_SILVA', 2), ('MARIA_SILVA', 3),

-- João in 2 schools
('JOAO_PEREIRA', 1), ('JOAO_PEREIRA', 2),

-- Carla in 1 school
('CARLA_MELO', 2),

-- Pedro in 2 schools
('PEDRO_ALMEIDA', 2), ('PEDRO_ALMEIDA', 3),

-- Ana in 1 school
('ANA_COSTA', 3),

-- Lucas in 2 schools
('LUCAS_FERREIRA', 1), ('LUCAS_FERREIRA', 3);

-- Materials
insert into tb_materials (name, form_link, assignment_link, added_in) values
('Matemática Básica', 'https://forms.gle/math101', 'https://assignments.com/math101', '2026-01-10'),
('História do Brasil', 'https://forms.gle/historybr', null, '2026-01-11'),
('Introdução à Programação', null, 'https://assignments.com/progintro', '2026-01-12'),
('Química Experimental', 'https://forms.gle/chemexp', 'https://assignments.com/chemexp', '2026-01-12');

-- School–Material relationships
insert into tb_school_material (id_school, id_material) values
(1, 1), (1, 3),
(2, 2), (2, 3),
(3, 4), (3, 1);

-- Material links
insert into tb_link_material (id_material, title, url) values
(1, 'Vídeo Aula Matemática', 'https://youtube.com/watch?v=math101'),
(2, 'Artigo sobre Independência', 'https://example.com/independencia'),
(3, 'Tutorial Python Básico', 'https://example.com/python-intro'),
(4, 'Experimentos de Química', 'https://example.com/chem-lab');