-- ============================================================ -- DATOS DE EJEMPLO — chms-iglesia -- Ejecutar en phpMyAdmin DESPUÉS de completar /install -- Para limpiar: ver sección RESET al final del archivo -- ============================================================ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- Limpiar datos anteriores DELETE FROM sermons; DELETE FROM series; DELETE FROM donations; DELETE FROM campaigns; DELETE FROM donation_categories; DELETE FROM event_rsvps; DELETE FROM `events`; DELETE FROM `group_members`; DELETE FROM `groups`; DELETE FROM member_tags; DELETE FROM tags; DELETE FROM members; DELETE FROM families; ALTER TABLE sermons AUTO_INCREMENT = 1; ALTER TABLE series AUTO_INCREMENT = 1; ALTER TABLE donations AUTO_INCREMENT = 1; ALTER TABLE campaigns AUTO_INCREMENT = 1; ALTER TABLE donation_categories AUTO_INCREMENT = 1; ALTER TABLE event_rsvps AUTO_INCREMENT = 1; ALTER TABLE `events` AUTO_INCREMENT = 1; ALTER TABLE `groups` AUTO_INCREMENT = 1; ALTER TABLE members AUTO_INCREMENT = 1; ALTER TABLE families AUTO_INCREMENT = 1; -- ============================================================ -- FAMILIAS (15) -- ============================================================ INSERT INTO families (id, family_name, address, notes, created_at, updated_at) VALUES (1, 'Familia Aguilar', 'Col. Centro, Managua', NULL, NOW(), NOW()), (2, 'Familia Acevedo', 'Barrio Las Palmas, Managua', NULL, NOW(), NOW()), (3, 'Familia Reyes', 'Reparto San Juan, Managua', NULL, NOW(), NOW()), (4, 'Familia Vargas', 'Bo. La Esperanza, Managua', NULL, NOW(), NOW()), (5, 'Familia López', 'Col. Los Robles, Managua', NULL, NOW(), NOW()), (6, 'Familia Martínez', 'Reparto Shick, Managua', NULL, NOW(), NOW()), (7, 'Familia Hernández', 'Bo. Batahola Norte, Managua', NULL, NOW(), NOW()), (8, 'Familia García', 'Ciudad Sandino, Managua', NULL, NOW(), NOW()), (9, 'Familia Torres', 'Col. Centro, Managua', NULL, NOW(), NOW()), (10, 'Familia Ramos', 'Bo. Jorge Dimitrov, Managua', NULL, NOW(), NOW()), (11, 'Familia Flores', 'Reparto Los Arcos, Managua', NULL, NOW(), NOW()), (12, 'Familia Medina', 'Bo. San Judas, Managua', NULL, NOW(), NOW()), (13, 'Familia Cruz', 'Col. Villa Fontana, Managua', NULL, NOW(), NOW()), (14, 'Familia Morales', 'Reparto Bello Horizonte, Managua', NULL, NOW(), NOW()), (15, 'Familia Castillo', 'Bo. La Fuente, Managua', NULL, NOW(), NOW()); -- ============================================================ -- MIEMBROS (25) -- ============================================================ INSERT INTO members (id, family_id, family_role, first_name, last_name, email, phone, birth_date, gender, marital_status, baptism_date, member_since, status, address, city, occupation, notes, created_at, updated_at) VALUES -- Familia Aguilar (1, 1, 'head', 'Daniel', 'Aguilar', 'daniel.aguilar@email.com', '8888-1001', '1985-03-15', 'M', 'married', '2005-06-12', '2006-01-15', 'active', 'Col. Centro', 'Managua', 'Pastor principal', NULL, NOW(), NOW()), (2, 1, 'spouse', 'Ana Lucía', 'Aguilar', 'ana.aguilar@email.com', '8888-1002', '1987-07-22', 'F', 'married', '2005-06-12', '2006-01-15', 'active', 'Col. Centro', 'Managua', 'Maestra', NULL, NOW(), NOW()), (3, 1, 'child', 'Sofía', 'Aguilar', NULL, NULL, '2010-04-26', 'F', 'single', NULL, '2018-03-01', 'active', 'Col. Centro', 'Managua', 'Estudiante', NULL, NOW(), NOW()), -- Familia Acevedo (4, 2, 'head', 'Andrés', 'Acevedo', 'andres.acevedo@email.com', '8888-2001', '1990-04-30', 'M', 'married', '2010-04-25', '2010-09-01', 'active', 'Barrio Las Palmas', 'Managua', 'Músico', NULL, NOW(), NOW()), (5, 2, 'spouse', 'María José', 'Acevedo', 'mj.acevedo@email.com', '8888-2002', '1992-08-14', 'F', 'married', '2010-04-25', '2010-09-01', 'active', 'Barrio Las Palmas', 'Managua', 'Enfermera', NULL, NOW(), NOW()), -- Familia Reyes (6, 3, 'head', 'Antonia', 'Reyes', 'antonia.reyes@email.com', '8888-3001', '1975-04-26', 'F', 'single', '2000-11-20', '2019-02-10', 'active', 'Reparto San Juan', 'Managua', 'Contadora', NULL, NOW(), NOW()), -- Familia Vargas (7, 4, 'head', 'Daniel', 'Vargas', 'pastor.vargas@email.com', '8888-4001', '1988-02-28', 'M', 'married', '2008-03-15', '2008-08-20', 'active', 'Bo. La Esperanza', 'Managua', 'Pastor asociado', NULL, NOW(), NOW()), (8, 4, 'spouse', 'Carmen', 'Vargas', 'carmen.vargas@email.com', '8888-4002', '1990-09-11', 'F', 'married', '2008-03-15', '2008-08-20', 'active', 'Bo. La Esperanza', 'Managua', 'Diseñadora', NULL, NOW(), NOW()), -- Familia López (9, 5, 'head', 'Roberto', 'López', 'roberto.lopez@email.com', '8888-5001', '1983-12-03', 'M', 'married', '2003-06-08', '2012-05-01', 'active', 'Col. Los Robles', 'Managua', 'Ingeniero', NULL, NOW(), NOW()), (10, 5, 'spouse', 'Lucía', 'López', 'lucia.lopez@email.com', '8888-5002', '1985-04-26', 'F', 'married', '2003-06-08', '2012-05-01', 'active', 'Col. Los Robles', 'Managua', 'Médica', NULL, NOW(), NOW()), -- Familia Martínez (11, 6, 'head', 'Carlos', 'Martínez', 'carlos.martinez@email.com', '8888-6001', '1995-06-17', 'M', 'single', '2015-05-22', '2023-03-01', 'active', 'Reparto Shick', 'Managua', 'Estudiante universitario', NULL, NOW(), NOW()), -- Familia Hernández (12, 7, 'head', 'Gloria', 'Hernández', 'gloria.hernandez@email.com', '8888-7001', '1970-01-09', 'F', 'married', '1998-04-15', '1999-07-01', 'active', 'Bo. Batahola Norte', 'Managua', 'Ama de casa', NULL, NOW(), NOW()), (13, 7, 'spouse', 'Pedro', 'Hernández', 'pedro.hernandez@email.com', '8888-7002', '1968-11-25', 'M', 'married', '1998-04-15', '1999-07-01', 'active', 'Bo. Batahola Norte', 'Managua', 'Comerciante', NULL, NOW(), NOW()), -- Familia García (14, 8, 'head', 'Laura', 'García', 'laura.garcia@email.com', '8888-8001', '1993-07-30', 'F', 'single', '2013-08-10', '2021-11-15', 'active', 'Ciudad Sandino', 'Managua', 'Profesora', NULL, NOW(), NOW()), -- Familia Torres (15, 9, 'head', 'Miguel', 'Torres', 'miguel.torres@email.com', '8888-9001', '1980-10-05', 'M', 'divorced', '2010-12-01', '2020-01-20', 'active', 'Col. Centro', 'Managua', 'Mecánico', NULL, NOW(), NOW()), -- Familia Ramos (16, 10,'head', 'Isabel', 'Ramos', 'isabel.ramos@email.com', '8888-0001', '1965-04-26', 'F', 'widowed', '1995-03-05', '1995-06-01', 'active', 'Bo. Jorge Dimitrov', 'Managua', 'Jubilada', NULL, NOW(), NOW()), -- Familia Flores (17, 11,'head', 'José', 'Flores', 'jose.flores@email.com', '7777-1001', '1978-08-21', 'M', 'married', '2001-09-16', '2002-03-01', 'active', 'Reparto Los Arcos', 'Managua', 'Abogado', NULL, NOW(), NOW()), (18, 11,'spouse', 'Patricia', 'Flores', 'patricia.flores@email.com', '7777-1002', '1980-03-07', 'F', 'married', '2001-09-16', '2002-03-01', 'active', 'Reparto Los Arcos', 'Managua', 'Psicóloga', NULL, NOW(), NOW()), -- Familia Medina (19, 12,'head', 'Ricardo', 'Medina', 'ricardo.medina@email.com', '7777-2001', '1997-02-14', 'M', 'single', '2019-07-28', '2024-01-08', 'active', 'Bo. San Judas', 'Managua', 'Desarrollador web', NULL, NOW(), NOW()), -- Familia Cruz (20, 13,'head', 'Sandra', 'Cruz', 'sandra.cruz@email.com', '7777-3001', '1988-05-31', 'F', 'married', '2009-06-14', '2009-10-01', 'active', 'Col. Villa Fontana', 'Managua', 'Contadora', NULL, NOW(), NOW()), (21, 13,'spouse', 'Eduardo', 'Cruz', 'eduardo.cruz@email.com', '7777-3002', '1985-09-18', 'M', 'married', '2009-06-14', '2009-10-01', 'active', 'Col. Villa Fontana', 'Managua', 'Empresario', NULL, NOW(), NOW()), -- Familia Morales (22, 14,'head', 'Francisco', 'Morales', 'franco.morales@email.com', '7777-4001', '1991-12-25', 'M', 'single', '2012-11-11', '2022-06-01', 'active', 'Reparto Bello Horizonte', 'Managua', 'Administrador', NULL, NOW(), NOW()), -- Familia Castillo (23, 15,'head', 'Yolanda', 'Castillo', 'yolanda.castillo@email.com', '7777-5001', '1973-06-08', 'F', 'married', '2003-04-20', '2004-02-01', 'active', 'Bo. La Fuente', 'Managua', 'Empresaria', NULL, NOW(), NOW()), (24, 15,'spouse', 'Héctor', 'Castillo', 'hector.castillo@email.com', '7777-5002', '1970-11-14', 'M', 'married', '2003-04-20', '2004-02-01', 'active', 'Bo. La Fuente', 'Managua', 'Contador', NULL, NOW(), NOW()), -- Sin familia (25, NULL, NULL, 'Marcos', 'Jiménez', 'marcos.jimenez@email.com', '7777-6001', '2000-08-04', 'M', 'single', '2022-09-25', '2025-01-15', 'active', NULL, 'Managua', 'Estudiante', NULL, NOW(), NOW()); -- ============================================================ -- ETIQUETAS -- ============================================================ INSERT IGNORE INTO tags (id, name, color, category) VALUES (1, 'Líder', '#1a3a5c', 'role'), (2, 'Nuevo', '#3a7d44', 'status'), (3, 'Voluntario', '#b5722b', 'role'), (4, 'Músico', '#6a4c93', 'ministry'), (5, 'Diácono', '#c0392b', 'role'), (6, 'Niños', '#27ae60', 'ministry'), (7, 'Jóvenes', '#8e44ad', 'ministry'), (8, 'Misiones', '#16a085', 'ministry'), (9, 'Cumpleaños', '#e67e22', 'special'), (10, 'Célula', '#2471a3', 'group'); -- ETIQUETAS A MIEMBROS INSERT IGNORE INTO member_tags (member_id, tag_id) VALUES (1, 1),(1, 5), -- Daniel Aguilar: Líder, Diácono (2, 1),(2, 6), -- Ana Lucía: Líder, Niños (4, 1),(4, 4), -- Andrés: Líder, Músico (5, 3), -- María José: Voluntaria (6, 1),(6, 3), -- Antonia: Líder, Voluntaria (7, 1),(7, 5), -- Daniel Vargas: Líder, Diácono (9, 1),(9, 3), -- Roberto: Líder, Voluntario (11, 7),(11, 2), -- Carlos: Jóvenes, Nuevo (12, 3),(12, 6), -- Gloria: Voluntaria, Niños (14, 7),(14, 3), -- Laura: Jóvenes, Voluntaria (17, 1),(17, 3), -- José Flores: Líder, Voluntario (19, 2),(19, 4), -- Ricardo: Nuevo, Músico (22, 2),(22, 7), -- Francisco: Nuevo, Jóvenes (25, 2),(25, 7); -- Marcos: Nuevo, Jóvenes -- ============================================================ -- GRUPOS (6) -- ============================================================ INSERT INTO `groups` (id, type, name, description, meeting_day, meeting_time, meeting_location, visibility, is_active, created_at, updated_at) VALUES (1, 'ministry', 'Ministerio de Niños', 'Enseñanza bíblica para niños de 4 a 12 años.', 'SU', '09:00:00', 'Salón infantil', 'members', 1, NOW(), NOW()), (2, 'ministry', 'Ministerio de Alabanza', 'Equipo de música y adoración congregacional.', 'SA', '15:00:00', 'Santuario principal', 'members', 1, NOW(), NOW()), (3, 'ministry', 'Ministerio de Jóvenes', 'Comunidad para jóvenes de 15 a 30 años.', 'FR', '19:00:00', 'Salón de jóvenes', 'public', 1, NOW(), NOW()), (4, 'cell', 'Célula Casa de Andrés', 'Célula de comunidad en casa de los Acevedo.', 'TH', '19:30:00', 'Casa Acevedo', 'members', 1, NOW(), NOW()), (5, 'team', 'Equipo de Misiones', 'Coordinación de proyectos misioneros locales.', 'TU', '18:00:00', 'Sala de reuniones', 'members', 1, NOW(), NOW()), (6, 'class', 'Escuela Bíblica', 'Clases de formación doctrinal para toda la iglesia.', 'SU', '11:00:00', 'Aula de estudio', 'members', 1, NOW(), NOW()); -- MIEMBROS DE GRUPOS INSERT IGNORE INTO `group_members` (group_id, member_id, role, joined_at, is_active) VALUES (1, 2, 'leader', '2019-01-15', 1), (1, 12, 'co_leader', '2020-03-01', 1), (1, 5, 'member', '2021-06-10', 1), (1, 18, 'member', '2022-01-20', 1), (2, 4, 'leader', '2010-09-01', 1), (2, 19, 'co_leader', '2024-02-01', 1), (2, 11, 'member', '2023-05-15', 1), (2, 14, 'member', '2023-08-01', 1), (2, 25, 'member', '2025-02-01', 1), (3, 14, 'leader', '2021-11-15', 1), (3, 11, 'member', '2023-03-01', 1), (3, 19, 'member', '2024-01-08', 1), (3, 22, 'member', '2022-06-01', 1), (3, 25, 'member', '2025-01-15', 1), (4, 4, 'leader', '2020-01-10', 1), (4, 5, 'co_leader', '2020-01-10', 1), (4, 6, 'member', '2020-03-15', 1), (4, 11, 'member', '2023-06-01', 1), (4, 22, 'member', '2023-01-15', 1), (4, 25, 'member', '2025-02-01', 1), (5, 7, 'leader', '2018-08-20', 1), (5, 9, 'co_leader', '2019-03-01', 1), (5, 17, 'member', '2019-05-01', 1), (5, 20, 'member', '2020-11-01', 1), (6, 1, 'leader', '2010-01-01', 1), (6, 7, 'co_leader', '2015-03-01', 1), (6, 6, 'member', '2019-02-10', 1), (6, 13, 'member', '2019-07-01', 1), (6, 16, 'member', '2019-07-01', 1); -- ============================================================ -- EVENTOS -- ============================================================ INSERT INTO `events` (id, title, description, starts_at, ends_at, all_day, location, capacity, rsvp_required, visibility, status, created_by, created_at, updated_at) VALUES (1, 'Servicio Dominical', 'Culto de adoración y predicación.', '2026-04-27 09:00:00', '2026-04-27 11:30:00', 0, 'Templo principal', 500, 0, 'public', 'published', 1, NOW(), NOW()), (2, 'Ensayo de Alabanza', 'Ensayo semanal del equipo de música.', '2026-04-26 15:00:00', '2026-04-26 17:00:00', 0, 'Santuario principal', 50, 0, 'members', 'published', 1, NOW(), NOW()), (3, 'Reunión Célula — Casa de Andrés','Célula semanal de comunidad y oración.', '2026-05-01 19:30:00', '2026-05-01 21:30:00', 0, 'Casa Acevedo', 20, 1, 'members', 'published', 1, NOW(), NOW()), (4, 'Jóvenes — Noche de Alabanza', 'Noche especial de alabanza para jóvenes.', '2026-05-02 19:00:00', '2026-05-02 22:00:00', 0, 'Salón de jóvenes', 80, 1, 'public', 'published', 1, NOW(), NOW()), (5, 'Escuela Bíblica', 'Clase: Doctrina de la Salvación.', '2026-04-27 11:00:00', '2026-04-27 12:30:00', 0, 'Aula de estudio', 60, 0, 'members', 'published', 1, NOW(), NOW()), (6, 'Retiro de Líderes 2026', 'Retiro anual de formación para líderes.', '2026-05-16 07:00:00', '2026-05-18 18:00:00', 0, 'Centro de retiros', 40, 1, 'members', 'published', 1, NOW(), NOW()), (7, 'Servicio Dominical', 'Culto de adoración y predicación.', '2026-05-04 09:00:00', '2026-05-04 11:30:00', 0, 'Templo principal', 500, 0, 'public', 'published', 1, NOW(), NOW()); -- RSVPs para el retiro INSERT INTO event_rsvps (event_id, member_id, status, guests_count, created_at, updated_at) VALUES (6, 1, 'going', 0, NOW(), NOW()), (6, 2, 'going', 0, NOW(), NOW()), (6, 4, 'going', 0, NOW(), NOW()), (6, 7, 'going', 0, NOW(), NOW()), (6, 9, 'maybe', 0, NOW(), NOW()), (6, 14, 'going', 0, NOW(), NOW()), (6, 17, 'going', 0, NOW(), NOW()); -- ============================================================ -- CATEGORÍAS DE DONACIÓN -- ============================================================ INSERT IGNORE INTO donation_categories (id, name, slug, is_active) VALUES (1, 'Diezmos', 'diezmos', 1), (2, 'Ofrendas', 'ofrendas', 1), (3, 'Misiones', 'misiones', 1), (4, 'Fondo de Ayuda', 'fondo-ayuda', 1), (5, 'Construcción', 'construccion',1); -- ============================================================ -- CAMPAÑA -- ============================================================ INSERT INTO campaigns (id, title, description, goal_amount, currency, starts_at, ends_at, status, created_at, updated_at) VALUES (1, 'Reparación del Techo', 'Campaña para reparar el techo del templo principal.', 15000.00, 'USD', '2026-03-01', '2026-06-30', 'active', NOW(), NOW()); -- ============================================================ -- DONACIONES (últimos 3 meses) -- ============================================================ INSERT INTO donations (member_id, category_id, campaign_id, amount, currency, method, donation_date, payment_status, recorded_by, created_at, updated_at) VALUES (1, 1, NULL, 300.00, 'USD', 'transfer', '2026-04-20', 'completed', 1, NOW(), NOW()), (7, 1, NULL, 250.00, 'USD', 'transfer', '2026-04-20', 'completed', 1, NOW(), NOW()), (9, 1, NULL, 400.00, 'USD', 'transfer', '2026-04-20', 'completed', 1, NOW(), NOW()), (17, 1, NULL, 200.00, 'USD', 'cash', '2026-04-20', 'completed', 1, NOW(), NOW()), (21, 2, NULL, 50.00, 'USD', 'cash', '2026-04-20', 'completed', 1, NOW(), NOW()), (13, 2, NULL, 30.00, 'USD', 'cash', '2026-04-20', 'completed', 1, NOW(), NOW()), (4, 5, 1, 150.00, 'USD', 'transfer', '2026-04-14', 'completed', 1, NOW(), NOW()), (23, 5, 1, 500.00, 'USD', 'transfer', '2026-04-14', 'completed', 1, NOW(), NOW()), (24, 5, 1, 300.00, 'USD', 'check', '2026-04-14', 'completed', 1, NOW(), NOW()), (6, 3, NULL, 75.00, 'USD', 'cash', '2026-04-13', 'completed', 1, NOW(), NOW()), (1, 1, NULL, 300.00, 'USD', 'transfer', '2026-03-23', 'completed', 1, NOW(), NOW()), (7, 1, NULL, 250.00, 'USD', 'transfer', '2026-03-23', 'completed', 1, NOW(), NOW()), (9, 1, NULL, 400.00, 'USD', 'transfer', '2026-03-23', 'completed', 1, NOW(), NOW()), (17, 1, NULL, 200.00, 'USD', 'cash', '2026-03-23', 'completed', 1, NOW(), NOW()), (16, 2, NULL, 40.00, 'USD', 'cash', '2026-03-23', 'completed', 1, NOW(), NOW()), (20, 2, NULL, 60.00, 'USD', 'cash', '2026-03-23', 'completed', 1, NOW(), NOW()), (23, 5, 1, 500.00, 'USD', 'transfer', '2026-03-10', 'completed', 1, NOW(), NOW()), (1, 1, NULL, 300.00, 'USD', 'transfer', '2026-02-23', 'completed', 1, NOW(), NOW()), (7, 1, NULL, 250.00, 'USD', 'transfer', '2026-02-23', 'completed', 1, NOW(), NOW()), (9, 1, NULL, 400.00, 'USD', 'transfer', '2026-02-23', 'completed', 1, NOW(), NOW()), (17, 1, NULL, 200.00, 'USD', 'cash', '2026-02-23', 'completed', 1, NOW(), NOW()), (4, 3, NULL, 100.00, 'USD', 'transfer', '2026-02-16', 'completed', 1, NOW(), NOW()), (5, 2, NULL, 35.00, 'USD', 'cash', '2026-02-23', 'completed', 1, NOW(), NOW()); -- ============================================================ -- SERIES DE PREDICACIÓN -- ============================================================ INSERT INTO series (id, title, description, starts_at, ends_at, created_at, updated_at) VALUES (1, 'Permaneced en Mí', 'Serie sobre Juan 15: la vid y los pámpanos.', '2026-04-01', '2026-04-27', NOW(), NOW()), (2, 'Fe que mueve montes', 'Serie sobre Hebreos 11: los héroes de la fe.', '2026-02-01', '2026-03-30', NOW(), NOW()), (3, 'El Sermón del Monte', 'Mateo 5-7: las bienaventuranzas y el estilo del reino.','2025-11-01', '2026-01-26', NOW(), NOW()); -- ============================================================ -- SERMONES -- ============================================================ INSERT INTO sermons (series_id, title, speaker_name, speaker_member_id, scripture_ref, preached_on, description, duration_seconds, language, status, views_count, created_at, updated_at) VALUES (1, 'Permanecer en la vid', 'Daniel Aguilar', 1, 'Juan 15:1-8', '2026-04-21', 'La importancia de permanecer conectados a Jesús como fuente de vida.', 2520, 'es', 'published', 47, NOW(), NOW()), (1, 'El fruto que permanece', 'Daniel Vargas', 7, 'Juan 15:9-17', '2026-04-14', 'Dios nos llama a dar fruto que dure para la eternidad.', 2880, 'es', 'published', 38, NOW(), NOW()), (1, 'Podados para dar más fruto', 'Daniel Aguilar', 1, 'Juan 15:1-2', '2026-04-07', 'La poda duele pero produce crecimiento espiritual.', 3060, 'es', 'published', 52, NOW(), NOW()), (2, 'La fe de Abraham', 'Daniel Aguilar', 1, 'Hebreos 11:8-19', '2026-03-30', 'Abraham creyó cuando no había evidencia visible de la promesa.', 2700, 'es', 'published', 61, NOW(), NOW()), (2, 'Fe que actúa', 'Daniel Vargas', 7, 'Santiago 2:14-26', '2026-03-23', 'La fe sin obras está muerta — cómo vivir una fe que se ve.', 2400, 'es', 'published', 44, NOW(), NOW()), (3, 'Las Bienaventuranzas', 'Daniel Aguilar', 1, 'Mateo 5:1-12', '2026-01-26', 'El camino contracultural del reino de los cielos.', 3180, 'es', 'published', 89, NOW(), NOW()); SET FOREIGN_KEY_CHECKS = 1; -- ============================================================ -- RESET: para borrar todos los datos de ejemplo, ejecuta esto: -- ============================================================ -- SET FOREIGN_KEY_CHECKS = 0; -- DELETE FROM sermons; -- DELETE FROM series; -- DELETE FROM donations; -- DELETE FROM campaigns; -- DELETE FROM donation_categories WHERE id > 0; -- DELETE FROM event_rsvps; -- DELETE FROM events; -- DELETE FROM group_members; -- DELETE FROM groups; -- DELETE FROM member_tags; -- DELETE FROM tags; -- DELETE FROM members; -- DELETE FROM families; -- SET FOREIGN_KEY_CHECKS = 1; -- ============================================================