-- sgnamecard.events definition

CREATE TABLE `events` (
  `sno` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id` char(32) NOT NULL DEFAULT ucase(replace(convert(uuid() using utf8mb4),'-','')),
  `title` varchar(255) DEFAULT NULL,
  `startdate` date NOT NULL,
  `starttime` time DEFAULT NULL,
  `enddate` date DEFAULT NULL,
  `endtime` time DEFAULT NULL,
  `banner` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `created_at` datetime(6) DEFAULT current_timestamp(6),
  `updated_at` datetime(6) DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
  `deleted_at` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `EVENTS_UNIQUE_SNO` (`sno`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


INSERT INTO sgnamecard.events (title,startdate,starttime,enddate,endtime,banner,link,status) VALUES
	 ('Is Your Food Business Future-Ready?','2026-08-19','14:00:00','2026-08-19','16:30:00','https://sgnamecard.com.sg/admin/img/events/Is-Your-Food-Business-Future-Ready-19-Aug.png','https://sgnamecard.com.sg/admin/img/events/Is-Your-Food-Business-Future-Ready-19-Aug.png',1),
	 ('Expand Into ASEAN: Thailand','2026-08-27','14:00:00','2026-08-27','17:00:00','https://sgnamecard.com.sg/admin/img/events/Expand-into-ASEAN_Thailand_27-Aug.png','https://www.smecentre-smf.sg/event/expand-into-asean-thailand/',1),
	 ('SME Centre Conference 2026 – Vision to Action: AI Adoption for SMEs','2026-09-09','09:00:00','2026-09-09','17:00:00','https://sgnamecard.com.sg/admin/img/events/Expand-into-ASEAN_Thailand_27-Aug.png','https://sgnamecard.com.sg/admin/img/events/Expand-into-ASEAN_Thailand_27-Aug.png',1),
	 ('Expand Into ASEAN: Malaysia','2026-10-22','03:00:00','2026-10-22','17:00:00','https://sgnamecard.com.sg/admin/img/events/Expand-into-ASEAN_Malaysia_22-Oct.png','https://www.smecentre-smf.sg/event/expand-into-asean-malaysia/',1),
	 ('Expand Into ASEAN: Indonesia','2026-11-13','02:00:00','2026-11-13','17:00:00','https://sgnamecard.com.sg/admin/img/events/Expand-into-ASEAN_Indonesi_13-Nov.png','https://www.smecentre-smf.sg/event/expand-into-asean-indonesia/',1),
	 ('Future-Proof Your Business with AI','2026-08-12','14:00:00','2026-08-12','17:30:00','https://sgnamecard.com.sg/admin/img/events/Future-Proof-your-Business-with-AI_August-12.png',NULL,1),
	 ('Building the Future Workforce','2026-07-30','14:00:00','2026-07-30','16:00:00','https://sgnamecard.com.sg/admin/img/events/Building-the-Future-Workforce_30th-July.png',NULL,1),
	 ('Can Your Business Afford to Delay Succession Planning?','2026-07-23','15:00:00','2026-07-23','17:00:00','https://sgnamecard.com.sg/admin/img/events/Can-Your-Business-Afford-to-Delay-Succession-Planning_july-23.png',NULL,1),
	 ('FM Digital Connect Day - Scaling Productivity in Food Manufacturing','2026-07-21','13:30:00','2026-07-21','17:30:00','https://sgnamecard.com.sg/admin/img/events/FM-Digital-Connect-Day_july-21.webp',NULL,1),
	 ('How SMEs Can Leverage AI to Transform Operations and Customer Experience','2026-07-15','14:00:00','2026-07-15','17:00:00','https://sgnamecard.com.sg/admin/img/events/AI-to-Transform-Operations-and-Customer-Experience.png',NULL,1);
INSERT INTO sgnamecard.events (title,startdate,starttime,enddate,endtime,banner,link,status) VALUES
	 ('4 Blind Spots Every SME Owner Should Fix Before the End of 2026','2026-07-08','14:00:00','2026-07-08','16:30:00','https://sgnamecard.com.sg/admin/img/events/4-Blind-Spots_SME.png',NULL,1),
	 ('SME Resilience Forum 2026','2026-07-01','12:30:00','2026-07-01','17:30:00','https://sgnamecard.com.sg/admin/img/events/SME-Resilience-Forum-26.png',NULL,1),
	 ('North West Corporate Exchange - AI Frontier','2026-07-01','12:30:00','2026-07-01','17:30:00','https://sgnamecard.com.sg/admin/img/events/AI-Frontier.png',NULL,1),
	 ('Sell Smarter on TikTok: Understanding Content, AI and Social Commerce','2026-06-18','14:00:00','2026-06-18','15:30:00','https://sgnamecard.com.sg/admin/img/events/Sell-Smarter-on-TikTok_18-June-2026.png',NULL,1),
	 ('Navigating Global Shifts: Empowering Your Growth Beyond Borders','2026-04-16',NULL,'2026-04-16',NULL,'https://sgnamecard.com.sg/admin/img/events/SICCI-x-StanChart-16-April-Navigating-Global-Shifts-Banner.jpg',NULL,1),
	 ('Leading with AI in 2026: Managing Change in the AI Era','2026-01-28','14:00:00','2026-01-28','17:00:00','https://sgnamecard.com.sg/admin/img/events/V7_DT-series-Leading-with-AI-in-2026-28-Jan-2026_compressed-1448x2048.jpg',NULL,1),
	 ('Ready-Set-Transform: AI, Sustainability & Workforce Solutions for SMEs','2026-01-26','14:30:00','2026-01-26','17:00:00','https://sgnamecard.com.sg/admin/img/events/eDM-Ready-Set-Transform-AI-Sustainability-Workforce-Solutions-for-SMEs-26-Jan-2026-1-1448x2048.jpg',NULL,1),
	 ('Understanding the Workplace Fairness Act: What Employers Need to Know','2025-12-04','14:30:00','2025-12-04','17:00:00','https://sgnamecard.com.sg/admin/img/events/v42.webp',NULL,1),
	 ('Global AI Compliance & Regulations: Governance Frameworks and International Standards','2026-01-15','14:00:00','2026-01-15','16:00:00','https://sgnamecard.com.sg/admin/img/events/15-Jan-2026-Global-AI-Compliance-Banner-v1-1280-x-720-px.webp',NULL,1),
	 ('From Strategy to Success: Digital & AI Marketing for Business Growth in 2026','2026-01-15','14:00:00','2026-01-15','15:00:00','https://sgnamecard.com.sg/admin/img/events/15-Jan-26_2026-From-Strategy-to-Success-Digital-AI-Marketing-for-Business-Growth-in-2026-724x1024.jpg',NULL,1);
INSERT INTO sgnamecard.events (title,startdate,starttime,enddate,endtime,banner,link,status) VALUES
	 ('How to Work Smarter: AI Solutions and Government Support Schemes to Boost SME''s Productivity','2026-01-14','12:00:00','2026-01-14','14:00:00','https://sgnamecard.com.sg/admin/img/events/IMG-20251126-WA00321-1.jpg',NULL,1),
	 ('Preparing SMEs for the Beverage Container Return Scheme (BCRS) Commencing in April 2026','2026-01-07','15:00:00','2026-01-07','16:30:00','https://sgnamecard.com.sg/admin/img/events/Eventbrite-Cover-Website-Header-5.png',NULL,1);
