14f96e78f9
Add SQL bridge, support functions, cron jobs, error handling, and PyPI version pinning so Python triggers match PHP capabilities. Co-authored-by: Cursor <cursoragent@cursor.com>
15 lines
513 B
SQL
15 lines
513 B
SQL
USE SYS_PRD_BND;
|
|
CREATE TABLE IF NOT EXISTS `CronJobs` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`Minute` int(11) NOT NULL DEFAULT -1,
|
|
`Hour` int(11) NOT NULL DEFAULT -1,
|
|
`DayOfMonth` int(11) NOT NULL DEFAULT -1,
|
|
`Month` int(11) NOT NULL DEFAULT -1,
|
|
`DayOfWeek` int(11) NOT NULL DEFAULT -1,
|
|
`PhpCode` text DEFAULT NULL,
|
|
`PyCode` text DEFAULT NULL,
|
|
`LastUpdated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
|
|
`LastError` text DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
);
|