2026-03-25 11:38:24 +01:00
|
|
|
INSERT INTO `.executedscripts`
|
2026-03-25 11:52:09 +01:00
|
|
|
VALUES ('Changes_2026-03-24 AiUserSettings', CURDATE());
|
|
|
|
|
|
|
|
|
|
CREATE TABLE `aiusersetting` (
|
|
|
|
|
`Oid` bigint NOT NULL,
|
|
|
|
|
`InsTs` datetime DEFAULT NULL,
|
|
|
|
|
`InsUser` varchar(256) DEFAULT NULL,
|
|
|
|
|
`Notice` varchar(1024) DEFAULT NULL,
|
|
|
|
|
`Tid` int DEFAULT NULL,
|
|
|
|
|
`UdpUser` varchar(256) DEFAULT NULL,
|
|
|
|
|
`Version` bigint DEFAULT NULL,
|
|
|
|
|
`IsActive` tinyint DEFAULT NULL,
|
|
|
|
|
`SystemEntryID` int DEFAULT NULL,
|
|
|
|
|
`ApplicationUserOid` bigint NOT NULL,
|
|
|
|
|
`AutoStartRecording` tinyint DEFAULT NULL,
|
|
|
|
|
PRIMARY KEY (`Oid`),
|
|
|
|
|
CONSTRAINT `FK_AIUSERSETTINGUSEROID_APPLICATIONUSER` FOREIGN KEY (`ApplicationUserOid`) REFERENCES `applicationuser` (`Oid`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1
|
