-- SLMB Database Export
CREATE TABLE `admin_users` (
`id` int NOT NULL AUTO_INCREMENT,
`username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`password_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`pepper_version` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'v1',
`created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `client_inquiries` (
`id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`status` enum('unread','read','replied') COLLATE utf8mb4_unicode_ci DEFAULT 'unread',
`created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `contact_messages` (
`id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`status` enum('unread','read','replied') COLLATE utf8mb4_unicode_ci DEFAULT 'unread',
`created_at` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO contact_messages (id, name, email, phone, subject, message, status, created_at) VALUES ('msg_1790840621547_7jhj8', 'Tharuka', 'ttharuka885@gmail.com', '+94 728486364', 'Web Contact Inquiry', 'Hello .', 'read', 'Thu Oct 01 2026 07:43:41 GMT+0000 (Coordinated Universal Time)');
CREATE TABLE `email_config` (
`id` int NOT NULL DEFAULT '1',
`notification_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sender_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sender_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`signature` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`smtp_host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`smtp_port` int DEFAULT '465',
`smtp_user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`smtp_pass` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`smtp_secure` tinyint(1) DEFAULT '1',
`updated_at` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `google_drive_config` (
`id` int NOT NULL DEFAULT '1',
`root_folder_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`root_folder_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`root_folder_url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`connected_account_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`connected_account_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_connected` tinyint(1) DEFAULT '0',
`auto_upload_enabled` tinyint(1) DEFAULT '1',
`access_token` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`refresh_token` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`updated_at` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`client_id` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`client_secret` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`auth_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'service_account',
`service_account_json` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`service_account_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`service_account_private_key` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`service_account_project_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO google_drive_config (id, root_folder_id, root_folder_name, root_folder_url, connected_account_email, connected_account_name, is_connected, auto_upload_enabled, access_token, refresh_token, updated_at, client_id, client_secret, auth_type, service_account_json, service_account_email, service_account_private_key, service_account_project_id) VALUES ('1', '1ZVRE0ezbGy4dyqx_9danCUClJEfwsTmH', 'slmb-web-client-input-storage', 'https://drive.google.com/drive/folders/1ZVRE0ezbGy4dyqx_9danCUClJEfwsTmH', 'slmb-drive-uploader-bot@backups-2a2b1.iam.gserviceaccount.com', 'Google Cloud Service Account', '1', '1', 'ya29.a0AX07CmvMFz5QW4kyueGviXTRCW0ntRNnnUMiddHKqsAUb_oxGjr5MlP0x18-rwVSBNPyjib_8H5SvXE1h_y18Z98_SDLfm8LYusaMTqbv6xp2NpkVM32J3ZBP0UabjPugfP5XfqRKs5_PIa0Daj_tVqd2PITAg6SK-fNRzq5KEB7kjWZdYW6AwnFhsA0OcH5ig5U_REekLxlM2Puc9tiRLENqwGOJ9PA11BIMTiQtwqHhjAFXupIB1jl__gUqtZPrG36Jc_k3qS4_jrwO2kC2I4G_uPgrQaCgYKAcMSARcSFQHGX2Mia4BpT-m_0efo9OI2Kc_O9Q0293', '1//04KT81_SpFLRYCgYIARAAGAQSNwF-L9IrL-MMT__u6KDpTH1W1coDw5SO0iLPbu14fVZZdHg8vYheFhsZdMqWogedIJM2vjY8JoI', 'Tue Oct 20 2026 08:29:30 GMT+0000 (Coordinated Universal Time)', '1010786161874-0f9kj1dhojvjgiq9j87qudj5jfjooocp.apps.googleusercontent.com', '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', 'service_account', '{
"type": "service_account",
"project_id": "backups-2a2b1",
"private_key_id": "16e79ceb14e0e00492f378ca42968b8f8bb2d9ab",
"private_key": "-----BEGIN PRIVATE KEY-----\nMIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQDSMKpBRAWwIBX9\n7XQ+aauvpWrz9JcbyEYJM8inkEf90dVAEaDSr6lOBQFb7Ryly+Frmmm0ISk1ed42\nx4mrp0yDfENB1ClmpmLyq0gDCf6l9cNQNXlc1+ueo5X5a7icjrcngtBXFPWAoFP9\nKRcQnt2QqkG8MmyLPQ62Qc20a3f1qD21vfjzeca5LtSwa47GV66kXcXVX3ci004n\nNhNVc2S1buvAk5vZPiIZOoDwhy76noacQ5sm6NWMndWEzIPn3jvoTb/cMzRPuz6n\nIBoYx/ydYheTQY/R6JImf8pJRGebNu5T0ATvT1/fSimcuicUhWB44en4SjW1gcdW\nl7QAak4bAgMBAAECggEATziSYwj9T9W4FD30SzXOxOQG/K3aallAtGU1IprJ14vH\n4V8Di4Uzvbk7OueSnZbLfp/zaTX6bzJgo6rvY6gpuYETZHNPq2XY83fFK4gP14Na\nuxd8h5bGMsObWifUrAVKWPUAC2JV6cYEAe4DyHroLYdOQV2L9arsqZsBqhe7XfX9\nU33p8KI0SLiavvV1SG1xnkPv0fQfe1OlBaZqQQ3eVlinl/0y/dReYdmsXjjbSUrz\n5zELLlYG2DR2XfyyfCmgV8hAhKblLehvOPK7WDDxWOWrgxJ0FffFMRfSkbPxRPcX\nPjlB0zLZukDgSiJjODyZ2/h99HE/etFbx6cmpLIGKQKBgQDxipl3RSAzI3fpbo0r\nMQMBiMHjjH2YsTf0tISRR16c+zLwLXS1bf9IR23faYPB9HGH4OvPCVCDR/bQsS4F\nqNVrQDd1CrkKWYFULM1YZtA5paEtXPdlgDJehCfQ7/jiSIlHN+FWTfDSB6egq8HZ\nhloIeN1wdjy3BVjfAMGguVrDDQKBgQDexaK0NcOJ1UceQKIev0QihipTQL9Hp2pI\naBjOeVN6YQrObtlZCJkBM0WQz7l78ljXyFcEI6KRxqzmT30IjfxiKYl8Bv4MBbwV\n+KuycLP5y3U2W9QLsx+/HRgavxL3CYacDtEXsgRov6glhRBVUmRS4nyn4yvUup5j\nG0fWXB+rxwKBgC1tqet6vtGfbCAlQLvM3gnd1MmdVMnxGtsVUJGaYLsZq7zsb7Tn\n2UmY1ZtdVwCVnvy1WuR3lgL69/rMOCGsXWdsjoGe4KqHpwFT49MqkyMkean0gDtA\n3zhTlsF/QMoeZmNUqTb4NcDq26YmZ7EnyasqQEu0kTrC8LIQjFpUQjPJAoGBAKDm\ncGDm4Ceigu5n0nCQxv6ElvdwsXdohQxtG1WuLcwbYTm+uH9lBVXnmVxBnH/Yh7C7\nA5Z6woW10NW8Hdva6apgw+twBXfbgIECDckhO+y0tiEf7CTTKJ/ZvLo8vc7t82qu\nDPmnWyXpH+KRnD1z+AAhk9WS7+qDK7j7UESUX0+rAoGAV97rS8ileGWswoeosGV+\nzzcwX1d0JeXcTKeSfLLIRkWiMwjJejbg/sPRAmDtXjNn7iceqN0k1rg0AUK3H30J\niSmA7qPwPi8TWcez9xf5ndfMpIjIsJhyBt+mNqNBgp5mM7dIqSOuWI20d+muR/oR\nIFvzZU22SKOXd/oSJcFaBvo=\n-----END PRIVATE KEY-----\n",
"client_email": "slmb-drive-uploader-bot@backups-2a2b1.iam.gserviceaccount.com",
"client_id": "112944972746955690189",
"auth_uri": "https://accounts.google.com/o/oauth2/auth",
"token_uri": "https://oauth2.googleapis.com/token",
"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
"client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/slmb-drive-uploader-bot%40backups-2a2b1.iam.gserviceaccount.com",
"universe_domain": "googleapis.com"
}', 'slmb-drive-uploader-bot@backups-2a2b1.iam.gserviceaccount.com', '-----BEGIN PRIVATE KEY-----
MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQDSMKpBRAWwIBX9
7XQ+aauvpWrz9JcbyEYJM8inkEf90dVAEaDSr6lOBQFb7Ryly+Frmmm0ISk1ed42
x4mrp0yDfENB1ClmpmLyq0gDCf6l9cNQNXlc1+ueo5X5a7icjrcngtBXFPWAoFP9
KRcQnt2QqkG8MmyLPQ62Qc20a3f1qD21vfjzeca5LtSwa47GV66kXcXVX3ci004n
NhNVc2S1buvAk5vZPiIZOoDwhy76noacQ5sm6NWMndWEzIPn3jvoTb/cMzRPuz6n
IBoYx/ydYheTQY/R6JImf8pJRGebNu5T0ATvT1/fSimcuicUhWB44en4SjW1gcdW
l7QAak4bAgMBAAECggEATziSYwj9T9W4FD30SzXOxOQG/K3aallAtGU1IprJ14vH
4V8Di4Uzvbk7OueSnZbLfp/zaTX6bzJgo6rvY6gpuYETZHNPq2XY83fFK4gP14Na
uxd8h5bGMsObWifUrAVKWPUAC2JV6cYEAe4DyHroLYdOQV2L9arsqZsBqhe7XfX9
U33p8KI0SLiavvV1SG1xnkPv0fQfe1OlBaZqQQ3eVlinl/0y/dReYdmsXjjbSUrz
5zELLlYG2DR2XfyyfCmgV8hAhKblLehvOPK7WDDxWOWrgxJ0FffFMRfSkbPxRPcX
PjlB0zLZukDgSiJjODyZ2/h99HE/etFbx6cmpLIGKQKBgQDxipl3RSAzI3fpbo0r
MQMBiMHjjH2YsTf0tISRR16c+zLwLXS1bf9IR23faYPB9HGH4OvPCVCDR/bQsS4F
qNVrQDd1CrkKWYFULM1YZtA5paEtXPdlgDJehCfQ7/jiSIlHN+FWTfDSB6egq8HZ
hloIeN1wdjy3BVjfAMGguVrDDQKBgQDexaK0NcOJ1UceQKIev0QihipTQL9Hp2pI
aBjOeVN6YQrObtlZCJkBM0WQz7l78ljXyFcEI6KRxqzmT30IjfxiKYl8Bv4MBbwV
+KuycLP5y3U2W9QLsx+/HRgavxL3CYacDtEXsgRov6glhRBVUmRS4nyn4yvUup5j
G0fWXB+rxwKBgC1tqet6vtGfbCAlQLvM3gnd1MmdVMnxGtsVUJGaYLsZq7zsb7Tn
2UmY1ZtdVwCVnvy1WuR3lgL69/rMOCGsXWdsjoGe4KqHpwFT49MqkyMkean0gDtA
3zhTlsF/QMoeZmNUqTb4NcDq26YmZ7EnyasqQEu0kTrC8LIQjFpUQjPJAoGBAKDm
cGDm4Ceigu5n0nCQxv6ElvdwsXdohQxtG1WuLcwbYTm+uH9lBVXnmVxBnH/Yh7C7
A5Z6woW10NW8Hdva6apgw+twBXfbgIECDckhO+y0tiEf7CTTKJ/ZvLo8vc7t82qu
DPmnWyXpH+KRnD1z+AAhk9WS7+qDK7j7UESUX0+rAoGAV97rS8ileGWswoeosGV+
zzcwX1d0JeXcTKeSfLLIRkWiMwjJejbg/sPRAmDtXjNn7iceqN0k1rg0AUK3H30J
iSmA7qPwPi8TWcez9xf5ndfMpIjIsJhyBt+mNqNBgp5mM7dIqSOuWI20d+muR/oR
IFvzZU22SKOXd/oSJcFaBvo=
-----END PRIVATE KEY-----
', 'backups-2a2b1');
CREATE TABLE `order_attachments` (
`id` int NOT NULL AUTO_INCREMENT,
`order_id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`file_size_bytes` bigint DEFAULT '0',
`file_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`drive_file_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`drive_file_url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
KEY `idx_order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=420001;
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('1', 'ord_1790839969631_H4OZ07', '2.webp', '81778', 'image/webp', NULL, NULL, 'Thu Oct 01 2026 07:32:50 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('2', 'ord_1790839969631_H4OZ07', '3.webp', '65780', 'image/webp', NULL, NULL, 'Thu Oct 01 2026 07:32:50 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('3', 'ord_1790839969631_H4OZ07', '4.webp', '77456', 'image/webp', NULL, NULL, 'Thu Oct 01 2026 07:32:50 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('4', 'ord_1790839969631_H4OZ07', '7.webp', '46492', 'image/webp', NULL, NULL, 'Thu Oct 01 2026 07:32:50 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('30001', 'ord_1790844539387_AVA2CW', '6.webp', '200306', 'image/webp', NULL, 'https://drive.google.com/drive/folders/124pzF4PXGFfqBJByTJedD2X1vwW0pzfv', 'Thu Oct 01 2026 08:48:59 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('30002', 'ord_1790844539387_AVA2CW', '7.webp', '46492', 'image/webp', NULL, 'https://drive.google.com/drive/folders/124pzF4PXGFfqBJByTJedD2X1vwW0pzfv', 'Thu Oct 01 2026 08:48:59 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('30003', 'ord_1790844539387_AVA2CW', 'Book1.xlsx', '2560345', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', NULL, 'https://drive.google.com/drive/folders/124pzF4PXGFfqBJByTJedD2X1vwW0pzfv', 'Thu Oct 01 2026 08:48:59 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('60001', 'ord_1790855642113_IQ6IC1', 'Book1.xlsx', '2560345', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', NULL, NULL, 'Thu Oct 01 2026 11:54:02 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('60002', 'ord_1790855642113_IQ6IC1', 'Document1 (1).htm', '214452', 'text/html', NULL, NULL, 'Thu Oct 01 2026 11:54:02 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('90001', 'ord_1790856873501_XJW3OR', 'Book1.xlsx', '2560345', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', NULL, NULL, 'Thu Oct 01 2026 12:14:34 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('90002', 'ord_1790856873501_XJW3OR', 'Document1 (1).htm', '214452', 'text/html', NULL, NULL, 'Thu Oct 01 2026 12:14:34 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('120001', 'ord_1790858459302_RNBW41', 'APE_SANSKRUTHIKA_URUMAYA.docx', '6874643', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', NULL, NULL, 'Thu Oct 01 2026 12:40:59 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('120002', 'ord_1790858459302_RNBW41', 'Book1.xlsx', '2560345', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', NULL, NULL, 'Thu Oct 01 2026 12:40:59 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('150001', 'ord_1790913576527_OH1XRX', 'APE_SANSKRUTHIKA_URUMAYA.docx', '6874643', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', '1n-5PethSkC2oyIEPIg8bFA1nyoOzeUw7', 'https://docs.google.com/document/d/1n-5PethSkC2oyIEPIg8bFA1nyoOzeUw7/edit?usp=drivesdk&ouid=113708001612544184969&rtpof=true&sd=true', 'Fri Oct 02 2026 03:59:37 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('150002', 'ord_1790913576527_OH1XRX', 'Book1.xlsx', '2560345', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '1EnD6DufPQ0x06l6N4phZKdeD3s2Xbcdh', 'https://docs.google.com/spreadsheets/d/1EnD6DufPQ0x06l6N4phZKdeD3s2Xbcdh/edit?usp=drivesdk&ouid=113708001612544184969&rtpof=true&sd=true', 'Fri Oct 02 2026 03:59:37 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('180001', 'ord_1790915317238_PDATBM', 'robotic_arm_spec.step', '1024', 'application/octet-stream', '1Vz7OZmr_FER4g2wwKtbqjrhwVL1OYyfK', 'https://drive.google.com/file/d/1Vz7OZmr_FER4g2wwKtbqjrhwVL1OYyfK/view?usp=drivesdk', 'Fri Oct 02 2026 04:28:37 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('210001', 'ord_1790927561833_GV3NDL', 'APE_SANSKRUTHIKA_URUMAYA.docx', '6874643', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', '1hwE1hCzMlBoksiG90ymkvvtqD1RdCgDQ', 'https://docs.google.com/document/d/1hwE1hCzMlBoksiG90ymkvvtqD1RdCgDQ/edit?usp=drivesdk&ouid=113708001612544184969&rtpof=true&sd=true', 'Fri Oct 02 2026 07:52:42 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('210002', 'ord_1790927561833_GV3NDL', 'Book1.xlsx', '2560345', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '1g1tv0WBzcDJavNgXWO8dy0UjpSVX7lBW', 'https://docs.google.com/spreadsheets/d/1g1tv0WBzcDJavNgXWO8dy0UjpSVX7lBW/edit?usp=drivesdk&ouid=113708001612544184969&rtpof=true&sd=true', 'Fri Oct 02 2026 07:52:42 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('210003', 'ord_1790927561833_GV3NDL', 'Document1 (1).htm', '214452', 'text/html', '1rrsnwSUmuwLO6iQp-ArS2JtGLSz6IKrS', 'https://drive.google.com/file/d/1rrsnwSUmuwLO6iQp-ArS2JtGLSz6IKrS/view?usp=drivesdk', 'Fri Oct 02 2026 07:52:42 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('210004', 'ord_1790928415755_VPP5NK', 'engine.glb', '11173636', 'application/octet-stream', '1sNC4oa66o9SAt-ADkBAdE51JLHCpDf63', 'https://drive.google.com/file/d/1sNC4oa66o9SAt-ADkBAdE51JLHCpDf63/view?usp=drivesdk', 'Fri Oct 02 2026 08:06:56 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('240001', 'ord_1792483431654_0019', 'Looman (3).png', '29593', 'image/png', NULL, 'https://drive.google.com/drive/folders/1aiCHLvHW14-fhtTw0t71Af1qCQnMPg3J', 'Tue Oct 20 2026 08:03:52 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('240002', 'ord_1792483431654_0019', 'Looman.png', '42084', 'image/png', NULL, 'https://drive.google.com/drive/folders/1aiCHLvHW14-fhtTw0t71Af1qCQnMPg3J', 'Tue Oct 20 2026 08:03:52 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('240003', 'ord_1792483431654_0019', 'SLMB-ORD-26-0016-Quotation.doc', '8134', 'application/msword', NULL, 'https://drive.google.com/drive/folders/1aiCHLvHW14-fhtTw0t71Af1qCQnMPg3J', 'Tue Oct 20 2026 08:03:52 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('240004', 'ord_1792483431654_0019', 'SLMB-ORD-26-0016-Quotation.pdf', '16595', 'application/pdf', NULL, 'https://drive.google.com/drive/folders/1aiCHLvHW14-fhtTw0t71Af1qCQnMPg3J', 'Tue Oct 20 2026 08:03:52 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('270001', 'ord_1792484981452_0020', 'bracket_v1.dxf', '1024', 'application/dxf', 'local_1792484985988', 'https://drive.google.com/drive/folders/1-d09h5K1BOGQ852urnabjcjiW1-hRSQj', 'Tue Oct 20 2026 08:29:41 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('300001', 'ord_1792485433814_0021', 'bracket_v2.dxf', '1024', 'application/dxf', 'local_1792485436666', 'https://drive.google.com/drive/folders/1G3DLdUcfAjUM_zd46DBGPPkSB4xwe7m7', 'Tue Oct 20 2026 08:37:14 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('330001', 'ord_1792486048886_0022', 'Looman (2).png', '33405', 'image/png', 'local_1792486052263', 'https://drive.google.com/drive/folders/1RSYJOEAGJMsE-2JN-oAInY0yDonf9bk4', 'Tue Oct 20 2026 08:47:29 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('330002', 'ord_1792486048886_0022', 'Looman (3).png', '29593', 'image/png', 'local_1792486054549', 'https://drive.google.com/drive/folders/1RSYJOEAGJMsE-2JN-oAInY0yDonf9bk4', 'Tue Oct 20 2026 08:47:29 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('330003', 'ord_1792486048886_0022', 'Looman.png', '42084', 'image/png', 'local_1792486057140', 'https://drive.google.com/drive/folders/1RSYJOEAGJMsE-2JN-oAInY0yDonf9bk4', 'Tue Oct 20 2026 08:47:29 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('330004', 'ord_1792486048886_0022', 'SLMB-ORD-26-0016-Quotation.doc', '8134', 'application/msword', 'local_1792486059319', 'https://drive.google.com/drive/folders/1RSYJOEAGJMsE-2JN-oAInY0yDonf9bk4', 'Tue Oct 20 2026 08:47:29 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('330005', 'ord_1792486048886_0022', 'SLMB-ORD-26-0016-Quotation.pdf', '16595', 'application/pdf', 'local_1792486060854', 'https://drive.google.com/drive/folders/1RSYJOEAGJMsE-2JN-oAInY0yDonf9bk4', 'Tue Oct 20 2026 08:47:29 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('360001', 'ord_1792487084639_0024', 'Looman (3).png', '29593', 'image/png', 'local_1792487087982', 'https://drive.google.com/drive/folders/1IYV3pyjU1jD4y_N98mSzVg0UrBRzB3cQ', 'Tue Oct 20 2026 09:04:45 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('360002', 'ord_1792487084639_0024', 'Looman.png', '42084', 'image/png', 'local_1792487090341', 'https://drive.google.com/drive/folders/1IYV3pyjU1jD4y_N98mSzVg0UrBRzB3cQ', 'Tue Oct 20 2026 09:04:45 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('360003', 'ord_1792487084639_0024', 'SLMB-ORD-26-0016-Quotation.doc', '8134', 'application/msword', 'local_1792487091872', 'https://drive.google.com/drive/folders/1IYV3pyjU1jD4y_N98mSzVg0UrBRzB3cQ', 'Tue Oct 20 2026 09:04:45 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('360004', 'ord_1792487084639_0024', 'SLMB-ORD-26-0016-Quotation.pdf', '16595', 'application/pdf', 'local_1792487093355', 'https://drive.google.com/drive/folders/1IYV3pyjU1jD4y_N98mSzVg0UrBRzB3cQ', 'Tue Oct 20 2026 09:04:45 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('390001', 'ord_1792487556222_0025', 'Looman (3).png', '29593', 'image/png', 'local_1792487571129', 'https://drive.google.com/drive/folders/1wNoaOT1eSZjJ6MtN2BMIQ50nn0Ay_zDT', 'Tue Oct 20 2026 09:12:36 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('390002', 'ord_1792487556222_0025', 'Looman.png', '42084', 'image/png', 'local_1792487573198', 'https://drive.google.com/drive/folders/1wNoaOT1eSZjJ6MtN2BMIQ50nn0Ay_zDT', 'Tue Oct 20 2026 09:12:36 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('390003', 'ord_1792487556222_0025', 'SLMB-ORD-26-0016-Quotation.doc', '8134', 'application/msword', 'local_1792487575029', 'https://drive.google.com/drive/folders/1wNoaOT1eSZjJ6MtN2BMIQ50nn0Ay_zDT', 'Tue Oct 20 2026 09:12:36 GMT+0000 (Coordinated Universal Time)');
INSERT INTO order_attachments (id, order_id, file_name, file_size_bytes, file_type, drive_file_id, drive_file_url, created_at) VALUES ('390004', 'ord_1792487556222_0025', 'SLMB-ORD-26-0016-Quotation.pdf', '16595', 'application/pdf', 'local_1792487576456', 'https://drive.google.com/drive/folders/1wNoaOT1eSZjJ6MtN2BMIQ50nn0Ay_zDT', 'Tue Oct 20 2026 09:12:36 GMT+0000 (Coordinated Universal Time)');
CREATE TABLE `order_replies` (
`id` int NOT NULL AUTO_INCREMENT,
`order_id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`body_html` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`sender_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sent_at` timestamp DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
KEY `idx_reply_order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `orders` (
`id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`order_reference` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
`client_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`category` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`product_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`product_model` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`quantity` int DEFAULT '1',
`budget` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`currency` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT 'USD',
`notes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`specifications_html` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`drive_folder_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`drive_folder_url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` enum('pending','processing','completed','cancelled') COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
`created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`quotation_result` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
UNIQUE KEY `order_reference` (`order_reference`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1790839969631_H4OZ07', 'SLMB-ORD-H4OZ07', 'Dasun', 'ttharuka885@gmail.com', '+94 784450223', 'ABC', 'Industrial 3D Printing (SLA / SLS / FDM)', 'Industrial 3D Printing (SLA / SLS / FDM)', 'Custom Specification', '1', '$ 1000', 'USD', 'Company: ABC
Budget: $1000
Attached Files: 2.webp, 3.webp, 4.webp, 7.webp
Project Specifications:
Hello , Good Engineering Works .', 'Hello , Good Engineering Works .', NULL, NULL, 'processing', 'Thu Oct 01 2026 07:32:50 GMT+0000 (Coordinated Universal Time)', 'Fri Oct 09 2026 11:20:48 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1790841311220_KOJOI5', 'SLMB-ORD-KOJOI5', 'Kamil', 'ttharuka885@gmail.com', '+94 784450223', 'ABC', 'CNC Precision Machining', 'CNC Precision Machining', 'Custom Specification', '1', '€ 350', 'EUR', 'Company: ABC
Budget: €350
Attached Files: None
Project Specifications:
hello,', 'hello,', NULL, NULL, 'processing', 'Thu Oct 01 2026 07:55:11 GMT+0000 (Coordinated Universal Time)', 'Fri Oct 09 2026 11:18:12 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1790844539387_AVA2CW', 'SLMB-ORD-AVA2CW', 'Vimal', 'tharuka.slmb@gmail.com', '+1 1234456798', 'ABC', 'Mechanical Assembly & Automation', 'Mechanical Assembly & Automation', 'Custom Specification', '1', '$ 6500', 'USD', 'Company: ABC
Budget: $6500
Attached Files: 6.webp, 7.webp, Book1.xlsx
Project Specifications:
Project Status Update: Mechanical Assembly Line
Dear SLMB Design Solutions,
I am writing to share the latest progress report on the mechanical assembly for [PROJ-26-0043].
Our team completed the primary framework integration and core component alignment on 01/10/2026. All current assemblies have passed our standard quality checks without any safety or performance issues.
We are moving into the final testing phase on [Date]. We expect to deliver the fully completed assembly unit to your facility by 21/10/2026.
Please review the attached technical summary for detailed measurements and parts lists. Let me know if you have any questions or need adjustments before we begin the final phase.
Best regards,
Vimal
Lead Mechanical Engineer
ABC LLC
+1 1234456798', 'Project Status Update: Mechanical Assembly Line
Dear SLMB Design Solutions,
I am writing to share the latest progress report on the mechanical assembly for [PROJ-26-0043].
Our team completed the primary framework integration and core component alignment on 01/10/2026. All current assemblies have passed our standard quality checks without any safety or performance issues.
We are moving into the final testing phase on [Date]. We expect to deliver the fully completed assembly unit to your facility by 21/10/2026.
Please review the attached technical summary for detailed measurements and parts lists. Let me know if you have any questions or need adjustments before we begin the final phase.
Vimal
Lead Mechanical Engineer
ABC LLC
+1 1234456798
Streamline Your Prototyping with Custom 3D Printing Services
Dear SLMB Design Solutions,
I hope this email finds you well.
I am reaching out from ABC LLC, a specialized digital fabrication studio. We assist companies like yours in bringing concept designs to physical reality through fast, high-precision 3D printing and additive manufacturing services.
Whether you need quick engineering prototypes to validate fit, or durable end-use production parts, we can match the exact technology and material required for your application.
Our Core Capabilities & Tech Stack
- Technologies Offered: Fused Deposition Modeling (FDM), Stereolithography (SLA/Resin), and Selective Laser Sintering (SLS).
- Production Materials: High-strength PLA/PETG, Tough Engineering Resins, Flexible TPU, and Carbon Fiber Nylon (CF-Nylon) for industrial-grade strength.
- Supported File Formats: We natively accept
.STL, .STEP, .OBJ, and .3MF files. - Turnaround Time: Standard parts are fabricated and shipped within 2 to 5 business days.
If you have an active project or an idea sketches ready, we would love to review your requirements. Simply reply to this email with your layout or CAD files (under 10MB), and our engineering team will provide a comprehensive, transparent quote.
Alternatively, we can mail you a physical material sample kit completely free of charge so you can feel the finishes and test the material properties firsthand.
Are you available for a brief, 5-minute call this week to see how we can save your team prototyping time?
Dasun
Production Director
ABC LLC
+1 123456789
Subject: Streamline Your Prototyping with Custom 3D Printing Services – [Your Business Name]
Dear [Client Name or Product Development Team],
I hope this email finds you well.
I am reaching out from [Your Business Name], a specialized digital fabrication studio. We assist companies like yours in bringing concept designs to physical reality through fast, high-precision 3D printing and additive manufacturing services.
Whether you need quick engineering prototypes to validate fit, or durable end-use production parts, we can match the exact technology and material required for your application.
Our Core Capabilities & Tech Stack
- Technologies Offered: Fused Deposition Modeling (FDM), Stereolithography (SLA/Resin), and Selective Laser Sintering (SLS).
- Production Materials: High-strength PLA/PETG, Tough Engineering Resins, Flexible TPU, and Carbon Fiber Nylon (CF-Nylon) for industrial-grade strength.
- Supported File Formats: We natively accept
.STL, .STEP, .OBJ, and .3MF files. - Turnaround Time: Standard parts are fabricated and shipped within 2 to 5 business days.
If you have an active project or an idea sketches ready, we would love to review your requirements. Simply reply to this email with your layout or CAD files (under 10MB), and our engineering team will provide a comprehensive, transparent quote.
Alternatively, we can mail you a physical material sample kit completely free of charge so you can feel the finishes and test the material properties firsthand.
Are you available for a brief, 5-minute call this week to see how we can save your team prototyping time?
[Your Name]
[Your Title, e.g., Production Director]
[Your Business Name]
[Website Link] | [Phone Number]
Subject: Streamline Your Prototyping with Custom 3D Printing Services – [Your Business Name]
Dear [Client Name or Product Development Team],
I hope this email finds you well.
I am reaching out from [Your Business Name], a specialized digital fabrication studio. We assist companies like yours in bringing concept designs to physical reality through fast, high-precision 3D printing and additive manufacturing services.
Whether you need quick engineering prototypes to validate fit, or durable end-use production parts, we can match the exact technology and material required for your application.
Our Core Capabilities & Tech Stack
- Technologies Offered: Fused Deposition Modeling (FDM), Stereolithography (SLA/Resin), and Selective Laser Sintering (SLS).
- Production Materials: High-strength PLA/PETG, Tough Engineering Resins, Flexible TPU, and Carbon Fiber Nylon (CF-Nylon) for industrial-grade strength.
- Supported File Formats: We natively accept
.STL, .STEP, .OBJ, and .3MF files. - Turnaround Time: Standard parts are fabricated and shipped within 2 to 5 business days.
If you have an active project or an idea sketches ready, we would love to review your requirements. Simply reply to this email with your layout or CAD files (under 10MB), and our engineering team will provide a comprehensive, transparent quote.
Alternatively, we can mail you a physical material sample kit completely free of charge so you can feel the finishes and test the material properties firsthand.
Are you available for a brief, 5-minute call this week to see how we can save your team prototyping time?
[Your Name]
[Your Title, e.g., Production Director]
[Your Business Name]
[Website Link] | [Phone Number]
- Subject: Meeting Request: Project Update and Next Steps
- Opening: Hi Mark,
- Body:
I hope you are having a good week. I am reaching out to schedule a brief meeting to discuss the results of our last project.Are you available to connect via video call this Wednesday at 2:00 PM? - Call to Action: Let me know if that time works for you, or suggest an alternative.
- Closing:
Best regards,Alex Smith
Project Manager
ABC Company
alex.smith@abccompany.com
', '13ibFEYUnGlcnu1JWanz52PkOfwJGJda0', 'https://drive.google.com/drive/folders/13ibFEYUnGlcnu1JWanz52PkOfwJGJda0', 'pending', 'Fri Oct 02 2026 03:58:28 GMT+0000 (Coordinated Universal Time)', 'Fri Oct 02 2026 03:58:29 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1790913576527_OH1XRX', 'SLMB-ORD-OH1XRX', 'Tharuka Tharuka', 'ttharuka885@gmail.com', '+94 2474587576', 'asd', 'Custom CAD / CAM Design', 'Custom CAD / CAM Design', 'Custom Specification', '1', '$ 1249', 'USD', 'Company: asd
Budget: $1249
Attached Files: APE_SANSKRUTHIKA_URUMAYA.docx, Book1.xlsx
Project Specifications:
Subject: Meeting Request: Project Update and Next Steps
Opening: Hi Mark,
Body:
I hope you are having a good week. I am reaching out to schedule a brief meeting to discuss the results of our last project.Are you available to connect via video call this Wednesday at 2:00 PM?
Call to Action: Let me know if that time works for you, or suggest an alternative.
Closing:
Best regards,Alex Smith
Project Manager
ABC Company
alex.smith@abccompany.com', '- Subject: Meeting Request: Project Update and Next Steps
- Opening: Hi Mark,
- Body:
I hope you are having a good week. I am reaching out to schedule a brief meeting to discuss the results of our last project.Are you available to connect via video call this Wednesday at 2:00 PM? - Call to Action: Let me know if that time works for you, or suggest an alternative.
- Closing:
Best regards,Alex Smith
Project Manager
ABC Company
alex.smith@abccompany.com
', '1LiVZzOhSEYfWuqUfGJxFkj3Hs2nX4cuC', 'https://drive.google.com/drive/folders/1LiVZzOhSEYfWuqUfGJxFkj3Hs2nX4cuC', 'pending', 'Fri Oct 02 2026 03:59:37 GMT+0000 (Coordinated Universal Time)', 'Fri Oct 02 2026 03:59:41 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1790915317238_PDATBM', 'SLMB-ORD-PDATBM', 'Test Customer', 'customer@test.com', NULL, NULL, '3D CAD Modeling', 'Custom Robotic Joint', 'Custom Specification', '1', '$500', 'USD', 'Testing Google Drive automated vault attachment upload.', NULL, '1tkYZowF4tpaHsrOox65IQXRFB4cGCzp2', 'https://drive.google.com/drive/folders/1tkYZowF4tpaHsrOox65IQXRFB4cGCzp2', 'pending', 'Fri Oct 02 2026 04:28:37 GMT+0000 (Coordinated Universal Time)', 'Fri Oct 02 2026 04:28:40 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1790927561833_GV3NDL', 'SLMB-ORD-GV3NDL', 'AA', 'tharukadasun885@gmail.com', '+1 123456789', 'ABC', 'CNC Precision Machining', 'CNC Precision Machining', 'Custom Specification', '1', '$ 2200', 'USD', 'Company: ABC
Budget: $2200
Attached Files: APE_SANSKRUTHIKA_URUMAYA.docx, Book1.xlsx, Document1 (1).htm
Project Specifications:
Subject: Meeting Request: Project Update and Next Steps
Opening: Hi Mark,
Body:
I hope you are having a good week. I am reaching out to schedule a brief meeting to discuss the results of our last project.Are you available to connect via video call this Wednesday at 2:00 PM?
Call to Action: Let me know if that time works for you, or suggest an alternative.
Closing:
Best regards,Alex Smith
Project Manager
ABC Company
alex.smith@abccompany.com', '- Subject: Meeting Request: Project Update and Next Steps
- Opening: Hi Mark,
- Body:
I hope you are having a good week. I am reaching out to schedule a brief meeting to discuss the results of our last project.Are you available to connect via video call this Wednesday at 2:00 PM? - Call to Action: Let me know if that time works for you, or suggest an alternative.
- Closing:
Best regards,Alex Smith
Project Manager
ABC Company
alex.smith@abccompany.com
', '1zmQLN5E4DR4DEzbjo3UoL2J-2ezEaDTd', 'https://drive.google.com/drive/folders/1zmQLN5E4DR4DEzbjo3UoL2J-2ezEaDTd', 'pending', 'Fri Oct 02 2026 07:52:42 GMT+0000 (Coordinated Universal Time)', 'Fri Oct 02 2026 07:52:48 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1790928415755_VPP5NK', 'SLMB-ORD-VPP5NK', 'LL', 'tharukadasun@gmail.com', '+94784450223', 'ADHTF', 'CNC Precision Machining', 'CNC Precision Machining', 'Custom Specification', '1', '$ 1234', 'USD', 'Company: ADHTF
Budget: $1234
Attached Files: engine.glb
Project Specifications:
Subject: Meeting Request: Project Update and Next Steps
Opening: Hi Mark,
Body:
I hope you are having a good week. I am reaching out to schedule a brief meeting to discuss the results of our last project.Are you available to connect via video call this Wednesday at 2:00 PM?
Call to Action: Let me know if that time works for you, or suggest an alternative.
Closing:
Best regards,Alex Smith
Project Manager
ABC Company
alex.smith@abccompany.com', '- Subject: Meeting Request: Project Update and Next Steps
- Opening: Hi Mark,
- Body:
I hope you are having a good week. I am reaching out to schedule a brief meeting to discuss the results of our last project.Are you available to connect via video call this Wednesday at 2:00 PM? - Call to Action: Let me know if that time works for you, or suggest an alternative.
- Closing:
Best regards,Alex Smith
Project Manager
ABC Company
alex.smith@abccompany.com
', '1bkM9zpgW_lu389x6i3pHsbg33jq7_0lR', 'https://drive.google.com/drive/folders/1bkM9zpgW_lu389x6i3pHsbg33jq7_0lR', 'pending', 'Fri Oct 02 2026 08:06:56 GMT+0000 (Coordinated Universal Time)', 'Fri Oct 02 2026 08:06:58 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1791285817920_ZGFDJ2', 'SLMB-ORD-ZGFDJ2', 'tharuka', 'ttharuka885@gmail.com', '+94 65756897890', 'asd', 'Custom CAD / CAM Design', 'Custom CAD / CAM Design', 'Custom Specification', '1', '$ 1238', 'USD', 'Company: asd
Budget: $1238
Attached Files: None
Project Specifications:
Subject: Meeting Request: [Project Name / Topic] — [Your Company Name]
Dear [Recipient\'s Name],
I hope this email finds you well.
I am reaching out to discuss [state the main purpose of your email in one sentence, e.g., the upcoming timeline for the Q4 marketing campaign].
Would you be available for a brief 15-minute call this week on [Day of the week, e.g., Thursday] at [Time, e.g., 2:00 PM] to go over the details? If that time does not work for you, please let me know a time that suits your schedule better.
Thank you for your time and consideration.
Best regards,
[Your Name]
[Your Job Title]
[Your Company Name]
[Phone Number]
[Website or LinkedIn URL]', 'Subject: Meeting Request: [Project Name / Topic] — [Your Company Name]
Dear [Recipient\'s Name],
I hope this email finds you well.
I am reaching out to discuss [state the main purpose of your email in one sentence, e.g., the upcoming timeline for the Q4 marketing campaign].
Would you be available for a brief 15-minute call this week on [Day of the week, e.g., Thursday] at [Time, e.g., 2:00 PM] to go over the details? If that time does not work for you, please let me know a time that suits your schedule better.
Thank you for your time and consideration.
Best regards,
[Your Name]
[Your Job Title]
[Your Company Name]
[Phone Number]
[Website or LinkedIn URL]
', NULL, 'https://drive.google.com/drive/folders/1PmcUSrGYPVKI-1s1Bjo05vKUOsKDXEJe', 'pending', 'Tue Oct 06 2026 11:23:38 GMT+0000 (Coordinated Universal Time)', 'Tue Oct 06 2026 11:23:38 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1791374068541_PCCDJU', 'SLMB-ORD-PCCDJU', 'Tharuka', 'ttharuka885@gmail.com', '+94 434343567', 'ABC', 'Custom CAD / CAM Design', 'Custom CAD / CAM Design', 'Custom Specification', '1', '$ 4200', 'USD', 'Company: ABC
Budget: $4200
Attached Files: None
Project Specifications:
Key Parts of a Business Email
Subject line: Short and clear (under 60 characters).
Greeting: Polite and professional (e.g., "Dear [Name]," or "I hope you are well,").
Body: Direct purpose, short sentences, and simple words.
Call to action: What you want the reader to do next.
Sign-off: Professional closing and your contact details.
Example Template: Meeting Request
Subject: Request for a quick call to discuss [Topic]
Greeting: Dear [Name],
Opening: I hope this email finds you well.
Body: I am reaching out to schedule a brief call regarding [Project/Topic]. I would love to learn more about your goals and share how we can help.
Call to action: Would you be available for a 15-minute chat this Thursday or Friday?
Sign-off: Best regards, [Your Name]
If you want, tell me:
What is the main goal of your email?
Who is your target audience (a client, partner, or coworker)?
I can write a custom template for you.', 'Key Parts of a Business Email
- Subject line: Short and clear (under 60 characters).
- Greeting: Polite and professional (e.g., "Dear [Name]," or "I hope you are well,").
- Body: Direct purpose, short sentences, and simple words.
- Call to action: What you want the reader to do next.
- Sign-off: Professional closing and your contact details.
Example Template: Meeting Request
- Subject: Request for a quick call to discuss [Topic]
- Greeting: Dear [Name],
- Opening: I hope this email finds you well.
- Body: I am reaching out to schedule a brief call regarding [Project/Topic]. I would love to learn more about your goals and share how we can help.
- Call to action: Would you be available for a 15-minute chat this Thursday or Friday?
- Sign-off: Best regards, [Your Name]
If you want, tell me:
- What is the main goal of your email?
- Who is your target audience (a client, partner, or coworker)?
I can write a custom template for you.
Key Parts of a Business Email
- Subject line: Short and clear (under 60 characters).
- Greeting: Polite and professional (e.g., "Dear [Name]," or "I hope you are well,").
- Body: Direct purpose, short sentences, and simple words.
- Call to action: What you want the reader to do next.
- Sign-off: Professional closing and your contact details.
Example Template: Meeting Request
- Subject: Request for a quick call to discuss [Topic]
- Greeting: Dear [Name],
- Opening: I hope this email finds you well.
- Body: I am reaching out to schedule a brief call regarding [Project/Topic]. I would love to learn more about your goals and share how we can help.
- Call to action: Would you be available for a 15-minute chat this Thursday or Friday?
- Sign-off: Best regards, [Your Name]
If you want, tell me:
- What is the main goal of your email?
- Who is your target audience (a client, partner, or coworker)?
I can write a custom template for you.
I will now update the application to generate a live, scannable QR code embedded above the barcode in the receipt. When scanned with any smartphone camera, the QR code encodes all the complete order details and live tracker data from the bill, allowing the client to instantly access and review their receipt and status anywhere at any time.
index.html [generated with web_code_canvas tool]
', NULL, 'https://drive.google.com/drive/folders/1PmcUSrGYPVKI-1s1Bjo05vKUOsKDXEJe', 'pending', 'Wed Oct 07 2026 12:29:46 GMT+0000 (Coordinated Universal Time)', 'Wed Oct 07 2026 12:29:46 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1791377665550_0016', 'SLMB-ORD-26-0016', 'Tharuka Tharuka', 'ttharuka885@gmail.com', '+94 213456789', 'ABC', 'Industrial 3D Printing (SLA / SLS / FDM)', 'Industrial 3D Printing (SLA / SLS / FDM)', 'Custom Specification', '1', '$ 1200', 'USD', 'Company: ABC
Budget: $1200
Attached Files: None
Project Specifications:
I will now update the application to generate a live, scannable QR code embedded above the barcode in the receipt. When scanned with any smartphone camera, the QR code encodes all the complete order details and live tracker data from the bill, allowing the client to instantly access and review their receipt and status anywhere at any time.
index.html [generated with web_code_canvas tool]', 'I will now update the application to generate a live, scannable QR code embedded above the barcode in the receipt. When scanned with any smartphone camera, the QR code encodes all the complete order details and live tracker data from the bill, allowing the client to instantly access and review their receipt and status anywhere at any time.
index.html [generated with web_code_canvas tool]
', NULL, 'https://drive.google.com/drive/folders/1PmcUSrGYPVKI-1s1Bjo05vKUOsKDXEJe', 'processing', 'Wed Oct 07 2026 12:54:26 GMT+0000 (Coordinated Universal Time)', 'Tue Oct 20 2026 04:42:05 GMT+0000 (Coordinated Universal Time)', '{"projectTitle":"QR/Barcode Integration & Industrial Tracking System Development","executiveSummary":"Development of a cross-platform application (Android, iOS, Web) capable of generating and reading QR/Barcode data for industrial receipt tracking. This project focuses on software architecture, UI/UX design, and integration of scanning libraries to ensure real-time order status accessibility.","scopeOfWork":["Requirements gathering and system architecture design","Development of QR/Barcode generation module","Implementation of cross-platform scanning engine (React Native/Flutter)","Backend integration for live order tracking data","UI/UX design for receipt display and status tracking","Testing and deployment on Android, iOS, and Web platforms"],"totalEstimatedCostUSD":"1200","totalEstimatedHours":"48","effectiveHourlyRateUSD":"25","totalEstimatedDuration":"4 weeks","phasedRoadmap":[{"phaseName":"System Architecture & UI Design","duration":"1 week","deliverables":["System architecture diagram","UI/UX wireframes"],"estimatedHours":"10","milestones":["Design sign-off"],"phaseCostUSD":"250","technicalDependencies":["None"]},{"phaseName":"Core Development (Scanning & Generation)","duration":"2 weeks","deliverables":["QR/Barcode generation module","Scanning engine integration"],"estimatedHours":"25","milestones":["Functional prototype"],"phaseCostUSD":"625","technicalDependencies":["System architecture"]},{"phaseName":"Testing & Deployment","duration":"1 week","deliverables":["Final build","User manual"],"estimatedHours":"13","milestones":["Final delivery"],"phaseCostUSD":"325","technicalDependencies":["Functional prototype"]}],"costBreakdown":[{"itemDescription":"System Architecture & UI Design","estimatedHours":"10","costUSD":"250","category":"Software Engineering","hourlyRateUSD":"25"},{"itemDescription":"Core Development","estimatedHours":"25","costUSD":"625","category":"Software Engineering","hourlyRateUSD":"25"},{"itemDescription":"Testing & Deployment","estimatedHours":"13","costUSD":"325","category":"Quality Assurance","hourlyRateUSD":"25"}],"engineeringAssumptions":["Client will provide access to existing order tracking database API","Cross-platform development will utilize a single codebase (e.g., React Native)","Standard libraries for QR/Barcode scanning will be used to minimize custom development"],"technicalRiskAssessment":[{"riskTitle":"API Integration Compatibility","impactLevel":"High","mitigationStrategy":"Early verification of existing API documentation and endpoints"},{"riskTitle":"Cross-Platform Performance","impactLevel":"Medium","mitigationStrategy":"Rigorous testing on multiple device types during development"}],"clarificationQuestions":["What is the existing backend technology stack?","Are there specific security requirements for the order data?","Does the client have existing developer accounts for Apple App Store and Google Play Store?"],"termsAndConditions":["All IP rights transfer to client upon final payment","30-day warranty on software functionality post-delivery","Confidentiality agreement applies to all project data"],"confidenceScorePercent":"95","generatedAt":"2026-10-09T11:40:45.483Z"}');
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1791378239095_0017', 'SLMB-ORD-26-0017', 'Tharuka Tharuka', 'ttharuka885@gmail.com', '+94 12456788657', 'ABC', 'Industrial 3D Printing (SLA / SLS / FDM)', 'Industrial 3D Printing (SLA / SLS / FDM)', 'Custom Specification', '1', '$ 1200', 'USD', 'Company: ABC
Budget: $1200
Attached Files: None
Project Specifications:
I will now update the application to generate a live, scannable QR code embedded above the barcode in the receipt. When scanned with any smartphone camera, the QR code encodes all the complete order details and live tracker data from the bill, allowing the client to instantly access and review their receipt and status anywhere at any time.
index.html [generated with web_code_canvas tool]', 'I will now update the application to generate a live, scannable QR code embedded above the barcode in the receipt. When scanned with any smartphone camera, the QR code encodes all the complete order details and live tracker data from the bill, allowing the client to instantly access and review their receipt and status anywhere at any time.
index.html [generated with web_code_canvas tool]
', NULL, 'https://drive.google.com/drive/folders/1PmcUSrGYPVKI-1s1Bjo05vKUOsKDXEJe', 'processing', 'Wed Oct 07 2026 13:03:59 GMT+0000 (Coordinated Universal Time)', 'Thu Oct 08 2026 12:38:08 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1792482894535_0018', 'SLMB-ORD-26-0018', 'Kamal Wijesinghe', 'kamal@gmail.com', '+94 784450778', 'ABC testing', 'Rapid Prototyping & R&D', 'Rapid Prototyping & R&D', 'Custom Specification', '1', '$ 3800', 'USD', 'Company: ABC testing
Budget: $3800
Attached Files: None
Project Specifications:
Meeting Request: Testing order
Dear SLMB Design Solutions,
I hope you are having a productive week.
I am writing to schedule a brief meeting to discuss [state the main purpose, e.g., the upcoming marketing timeline or project status]. We want to review the next steps and ensure everything stays on track.
Would you be available for a 15-minute call this Thursday at 10:00 AM or Friday at 2:00 PM? If not, please let me know what time works best for your schedule.
Best regards,
Kamal
CEO
ABC Pvt ltd.
+94 784450778 / https//:abc.com', ' Meeting Request: Testing order
Dear SLMB Design Solutions,
I hope you are having a productive week.
I am writing to schedule a brief meeting to discuss [state the main purpose, e.g., the upcoming marketing timeline or project status]. We want to review the next steps and ensure everything stays on track.
Would you be available for a 15-minute call this Thursday at 10:00 AM or Friday at 2:00 PM? If not, please let me know what time works best for your schedule.
Best regards,
Kamal
CEO
ABC Pvt ltd.
+94 784450778 / https//:abc.com
', NULL, 'https://drive.google.com/drive/folders/1aiCHLvHW14-fhtTw0t71Af1qCQnMPg3J', 'pending', 'Tue Oct 20 2026 07:54:55 GMT+0000 (Coordinated Universal Time)', 'Tue Oct 20 2026 07:54:54 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1792483431654_0019', 'SLMB-ORD-26-0019', 'Tharuka Tharuka', 'ttharuka885@gmail.com', '+94 451237852', 'ABC test 1', 'CNC Precision Machining', 'CNC Precision Machining', 'Custom Specification', '1', '$ 1200', 'USD', 'Company: ABC test 1
Budget: $1200
Attached Files: Looman (3).png, Looman.png, SLMB-ORD-26-0016-Quotation.doc, SLMB-ORD-26-0016-Quotation.pdf
Project Specifications:
Meeting Request: Testing order
Dear SLMB Design Solutions,
I hope you are having a productive week.
I am writing to schedule a brief meeting to discuss [state the main purpose, e.g., the upcoming marketing timeline or project status]. We want to review the next steps and ensure everything stays on track.
Would you be available for a 15-minute call this Thursday at 10:00 AM or Friday at 2:00 PM? If not, please let me know what time works best for your schedule.
Best regards,
Kamal
CEO
ABC Pvt ltd.
+94 784450778 / https//:abc.com', ' Meeting Request: Testing order
Dear SLMB Design Solutions,
I hope you are having a productive week.
I am writing to schedule a brief meeting to discuss [state the main purpose, e.g., the upcoming marketing timeline or project status]. We want to review the next steps and ensure everything stays on track.
Would you be available for a 15-minute call this Thursday at 10:00 AM or Friday at 2:00 PM? If not, please let me know what time works best for your schedule.
Best regards,
Kamal
CEO
ABC Pvt ltd.
+94 784450778 / https//:abc.com
', NULL, 'https://drive.google.com/drive/folders/1aiCHLvHW14-fhtTw0t71Af1qCQnMPg3J', 'pending', 'Tue Oct 20 2026 08:03:52 GMT+0000 (Coordinated Universal Time)', 'Tue Oct 20 2026 08:03:52 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1792484981452_0020', 'SLMB-ORD-26-0020', 'Test Tharuka', 'ttharuka885@gmail.com', NULL, NULL, 'Automation & CNC', 'Precision CNC Aluminum Bracket', 'Custom Specification', '5', '$ 500', 'USD', 'Test order to verify Google Drive subfolder creation', NULL, '1-d09h5K1BOGQ852urnabjcjiW1-hRSQj', 'https://drive.google.com/drive/folders/1-d09h5K1BOGQ852urnabjcjiW1-hRSQj', 'pending', 'Tue Oct 20 2026 08:29:41 GMT+0000 (Coordinated Universal Time)', 'Tue Oct 20 2026 08:29:46 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1792485433814_0021', 'SLMB-ORD-26-0021', 'Test Tharuka Again', 'ttharuka885@gmail.com', NULL, NULL, 'Automation & CNC', 'Precision CNC Aluminum Bracket', 'Custom Specification', '5', '$ 500', 'USD', 'Test order to verify Google Drive subfolder creation - attempt 2', NULL, '1G3DLdUcfAjUM_zd46DBGPPkSB4xwe7m7', 'https://drive.google.com/drive/folders/1G3DLdUcfAjUM_zd46DBGPPkSB4xwe7m7', 'pending', 'Tue Oct 20 2026 08:37:14 GMT+0000 (Coordinated Universal Time)', 'Tue Oct 20 2026 08:37:16 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1792486048886_0022', 'SLMB-ORD-26-0022', 'Testing 01', 'abc@gmail.com', '+1 23564842', 'ABC_Testing', 'CNC Precision Machining', 'CNC Precision Machining', 'Custom Specification', '1', '$ 4000', 'USD', 'Company: ABC_Testing
Budget: $4000
Attached Files: Looman (2).png, Looman (3).png, Looman.png, SLMB-ORD-26-0016-Quotation.doc, SLMB-ORD-26-0016-Quotation.pdf
Project Specifications:
Meeting Request: Testing order
Dear SLMB Design Solutions,
I hope you are having a productive week.
I am writing to schedule a brief meeting to discuss [state the main purpose, e.g., the upcoming marketing timeline or project status]. We want to review the next steps and ensure everything stays on track.
Would you be available for a 15-minute call this Thursday at 10:00 AM or Friday at 2:00 PM? If not, please let me know what time works best for your schedule.
Best regards,
Kamal
CEO
ABC Pvt ltd.
+94 784450778 / https//:abc.com', ' Meeting Request: Testing order
Dear SLMB Design Solutions,
I hope you are having a productive week.
I am writing to schedule a brief meeting to discuss [state the main purpose, e.g., the upcoming marketing timeline or project status]. We want to review the next steps and ensure everything stays on track.
Would you be available for a 15-minute call this Thursday at 10:00 AM or Friday at 2:00 PM? If not, please let me know what time works best for your schedule.
Best regards,
Kamal
CEO
ABC Pvt ltd.
+94 784450778 / https//:abc.com
', '1RSYJOEAGJMsE-2JN-oAInY0yDonf9bk4', 'https://drive.google.com/drive/folders/1RSYJOEAGJMsE-2JN-oAInY0yDonf9bk4', 'pending', 'Tue Oct 20 2026 08:47:29 GMT+0000 (Coordinated Universal Time)', 'Tue Oct 20 2026 08:47:40 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1792487018143_0023', 'SLMB-ORD-26-0023', 't', 'ttharuka885@gmail.com', '+94 48', NULL, '68', '68', 'Custom Specification', '1', '$ 668', 'USD', 'Company: N/A
Budget: $668
Attached Files: None
Project Specifications:
', NULL, '1H1bppZuuZjPC3qYS1M3Lfn75sAb0lU1K', 'https://drive.google.com/drive/folders/1H1bppZuuZjPC3qYS1M3Lfn75sAb0lU1K', 'pending', 'Tue Oct 20 2026 09:03:38 GMT+0000 (Coordinated Universal Time)', 'Tue Oct 20 2026 09:03:39 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1792487084639_0024', 'SLMB-ORD-26-0024', 'Tharuka Tharuka', 'ttharuka885@gmail.com', '+94 654114151', 'gdsz', 'CNC Precision Machining', 'CNC Precision Machining', 'Custom Specification', '1', '$ 4555', 'USD', 'Company: gdsz
Budget: $4555
Attached Files: Looman (3).png, Looman.png, SLMB-ORD-26-0016-Quotation.doc, SLMB-ORD-26-0016-Quotation.pdf
Project Specifications:
Meeting Request: Testing order
Dear SLMB Design Solutions,
I hope you are having a productive week.
I am writing to schedule a brief meeting to discuss [state the main purpose, e.g., the upcoming marketing timeline or project status]. We want to review the next steps and ensure everything stays on track.
Would you be available for a 15-minute call this Thursday at 10:00 AM or Friday at 2:00 PM? If not, please let me know what time works best for your schedule.
Best regards,
Kamal
CEO
ABC Pvt ltd.
+94 784450778 / https//:abc.com', ' Meeting Request: Testing order
Dear SLMB Design Solutions,
I hope you are having a productive week.
I am writing to schedule a brief meeting to discuss [state the main purpose, e.g., the upcoming marketing timeline or project status]. We want to review the next steps and ensure everything stays on track.
Would you be available for a 15-minute call this Thursday at 10:00 AM or Friday at 2:00 PM? If not, please let me know what time works best for your schedule.
Best regards,
Kamal
CEO
ABC Pvt ltd.
+94 784450778 / https//:abc.com
', '1IYV3pyjU1jD4y_N98mSzVg0UrBRzB3cQ', 'https://drive.google.com/drive/folders/1IYV3pyjU1jD4y_N98mSzVg0UrBRzB3cQ', 'pending', 'Tue Oct 20 2026 09:04:45 GMT+0000 (Coordinated Universal Time)', 'Tue Oct 20 2026 09:04:53 GMT+0000 (Coordinated Universal Time)', NULL);
INSERT INTO orders (id, order_reference, client_name, email, phone, company, category, product_title, product_model, quantity, budget, currency, notes, specifications_html, drive_folder_id, drive_folder_url, status, created_at, updated_at, quotation_result) VALUES ('ord_1792487556222_0025', 'SLMB-ORD-26-0025', 'Tharuka Tharuka-t', 'ttharuka885@gmail.com', '+94', 'abc', 'Industrial 3D Printing (SLA / SLS / FDM)', 'Industrial 3D Printing (SLA / SLS / FDM)', 'Custom Specification', '1', '$ 8967', 'USD', 'Company: abc
Budget: $8967
Attached Files: Looman (3).png, Looman.png, SLMB-ORD-26-0016-Quotation.doc, SLMB-ORD-26-0016-Quotation.pdf
Project Specifications:
Meeting Request: Testing order
Dear SLMB Design Solutions,
I hope you are having a productive week.
I am writing to schedule a brief meeting to discuss [state the main purpose, e.g., the upcoming marketing timeline or project status]. We want to review the next steps and ensure everything stays on track.
Would you be available for a 15-minute call this Thursday at 10:00 AM or Friday at 2:00 PM? If not, please let me know what time works best for your schedule.
Best regards,
Kamal
CEO
ABC Pvt ltd.
+94 784450778 / https//:abc.com', ' Meeting Request: Testing order
Dear SLMB Design Solutions,
I hope you are having a productive week.
I am writing to schedule a brief meeting to discuss [state the main purpose, e.g., the upcoming marketing timeline or project status]. We want to review the next steps and ensure everything stays on track.
Would you be available for a 15-minute call this Thursday at 10:00 AM or Friday at 2:00 PM? If not, please let me know what time works best for your schedule.
Best regards,
Kamal
CEO
ABC Pvt ltd.
+94 784450778 / https//:abc.com
', '1wNoaOT1eSZjJ6MtN2BMIQ50nn0Ay_zDT', 'https://drive.google.com/drive/folders/1wNoaOT1eSZjJ6MtN2BMIQ50nn0Ay_zDT', 'pending', 'Tue Oct 20 2026 09:12:36 GMT+0000 (Coordinated Universal Time)', 'Tue Oct 20 2026 09:12:56 GMT+0000 (Coordinated Universal Time)', NULL);
CREATE TABLE `reviews` (
`id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`client_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`rating` int DEFAULT '5',
`comment` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`product` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`approved` tinyint(1) DEFAULT '1',
`created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO reviews (id, client_name, company, rating, comment, product, approved, created_at, updated_at) VALUES ('rev_1791285205188_7hfv', 'Tharuka', 'ABC - Anuradhapura', '5', 'hello........', NULL, '1', 'Tue Oct 06 2026 11:13:25 GMT+0000 (Coordinated Universal Time)', 'Tue Oct 20 2026 04:38:45 GMT+0000 (Coordinated Universal Time)');
INSERT INTO reviews (id, client_name, company, rating, comment, product, approved, created_at, updated_at) VALUES ('rev_seed_1', 'David Harrison', 'Precision Dynamics Ltd', '5', 'SLMB\'s Pro-CNC 5X system reduced our prototype turnaround time from 3 weeks to 48 hours with flawless accuracy.', 'SLMB-CNC-5X', '1', 'Thu Oct 01 2026 09:40:08 GMT+0000 (Coordinated Universal Time)', 'Tue Oct 20 2026 04:38:40 GMT+0000 (Coordinated Universal Time)');
INSERT INTO reviews (id, client_name, company, rating, comment, product, approved, created_at, updated_at) VALUES ('rev_seed_2', 'Dr. Aris Thorne', 'AeroTech Defense Labs', '5', 'The 3D handheld laser metrology scanner delivered sub-micron point cloud mesh density without surface reflective spray.', 'SLMB-MS-3D', '1', 'Thu Oct 01 2026 09:40:08 GMT+0000 (Coordinated Universal Time)', 'Tue Oct 20 2026 04:38:32 GMT+0000 (Coordinated Universal Time)');
INSERT INTO reviews (id, client_name, company, rating, comment, product, approved, created_at, updated_at) VALUES ('rev_seed_3', 'Michael Sterling', 'Sterling Robotics Corp', '5', 'Exceptional kinematic analysis and precision engineering. All 3D STEP files arrived organized directly in our client Drive vault.', 'Robotics Automation', '1', 'Thu Oct 01 2026 09:40:08 GMT+0000 (Coordinated Universal Time)', 'Tue Oct 20 2026 04:38:38 GMT+0000 (Coordinated Universal Time)');