CREATE TABLE `data_ticket_comment` (
`Guid` char(50) NOT NULL,
`TicketGuid` char(50) NOT NULL,
`CommentText` text DEFAULT NULL,
`CommentedBy` varchar(255) DEFAULT NULL,
`IsInternal` char(2) DEFAULT 'N',
`IsDeleted` char(2) DEFAULT 'N',
`Package` char(255) DEFAULT NULL,
`CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`Guid`),
KEY `idx_ticket_guid` (`TicketGuid`),
KEY `idx_commented_by` (`CommentedBy`),
KEY `idx_internal` (`IsInternal`),
KEY `idx_deleted` (`IsDeleted`),
KEY `idx_created` (`CreatedDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};
SELECT *
FROM data_ticket_comment
WHERE Guid = '{guid}'
INSERT INTO data_ticket_comment
(Guid, TicketGuid, CommentText,
CommentedBy, IsInternal, Package,
CreatedDate)
VALUES
('{guid}', '{ticket_guid}',
'{comment_text}', '{commented_by}',
'{is_internal}', '{package}', now())
SELECT *
FROM data_ticket_comment
WHERE TicketGuid = '{ticket_guid}'
AND IsDeleted = 'N'
ORDER BY CreatedDate
SELECT *
FROM data_ticket_comment
WHERE TicketGuid = '{ticket_guid}'
AND IsDeleted = 'N'
AND IsInternal = 'N'
ORDER BY CreatedDate
UPDATE data_ticket_comment
SET IsDeleted = 'Y'
WHERE Guid = '{guid}'