This guide demonstrates how to create a basic test table and populate it with sample data for form workflows.
-- Create the table
CREATE TABLE data_reference_test (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50),
description TEXT,
created_at DATETIME,
is_active BOOLEAN
);
-- Insert statements
INSERT INTO data_reference_test (name, description, created_at, is_active)
VALUES ('Test Name 1', 'Description for Test Name 1', '2025-03-26 12:00:00', TRUE);
INSERT INTO data_reference_test (name, description, created_at, is_active)
VALUES ('Test Name 2', 'Description for Test Name 2', '2025-03-25 15:00:00', FALSE);
INSERT INTO data_reference_test (name, description, created_at, is_active)
VALUES ('Test Name 3', 'Description for Test Name 3', '2025-03-24 08:30:00', TRUE);
INSERT INTO data_reference_test (name, description, created_at, is_active)
VALUES ('Test Name 4', 'Description for Test Name 4', '2025-03-23 21:45:00', FALSE);
INSERT INTO data_reference_test (name, description, created_at, is_active)
VALUES ('Test Name 5', 'Description for Test Name 5', '2025-03-22 09:15:00', TRUE);