sample_mysql.sql

-- Sample MySQL dump file for performance testing
CREATE TABLE `users` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`),
    KEY `idx_name` (`name`),
    FULLTEXT KEY `idx_fulltext_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `users` VALUES (1,'john@example.com','John Doe',NOW(),NOW());
INSERT INTO `users` VALUES (2,'jane@example.com','Jane Smith',NOW(),NOW());
INSERT INTO `users` VALUES (3,'bob@example.com','Bob Johnson',NOW(),NOW());

CREATE TABLE `products` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `price` decimal(10,2) NOT NULL DEFAULT '0.00',
    `description` longtext,
    `status` enum('active','inactive','pending') NOT NULL DEFAULT 'pending',
    `metadata` json DEFAULT NULL,
    `thumbnail` mediumblob,
    PRIMARY KEY (`id`),
    KEY `idx_status` (`status`),
    KEY `idx_price` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT IGNORE INTO `products` (`name`, `price`, `description`) VALUES 
('Product 1', 19.99, 'First product'),
('Product 2', 29.99, 'Second product'),
('Product 3', 39.99, 'Third product') ON DUPLICATE KEY UPDATE `price` = VALUES(`price`);