103 lines
4.3 KiB
Plaintext
103 lines
4.3 KiB
Plaintext
-- nur ausführen, wenn noch nicht vorhanden
|
|
CREATE TABLE `.executedscripts` (
|
|
`Name` varchar(255) UNIQUE,
|
|
`Datum` DATE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
|
|
|
|
INSERT INTO `.executedscripts`
|
|
VALUES ('Changes_2026-02-10 AI Promptbausteinfolder finale', CURDATE());
|
|
|
|
-- Folder
|
|
CREATE TABLE `AiPromptbausteinFolder` (
|
|
`Oid` bigint NOT NULL AUTO_INCREMENT,
|
|
`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,
|
|
`Title` varchar(255),
|
|
`Description` mediumtext,
|
|
`ParentFolderOid` bigint DEFAULT NULL,
|
|
`CreatorOid` bigint DEFAULT NULL,
|
|
`IsPublic` tinyint,
|
|
`Position` int,
|
|
`ActionType` int,
|
|
PRIMARY KEY (`Oid`),
|
|
KEY `FK_AIPROMPTBAUSTEINFOLDER_EMPLOYEE_IDX` (`CreatorOid`),
|
|
KEY `FK_AIPROMPTBAUSTEINFOLDER_PARENT_IDX` (`ParentFolderOid`),
|
|
CONSTRAINT `FK_AIPROMPTBAUSTEINFOLDER_EMPLOYEE` FOREIGN KEY (`CreatorOid`) REFERENCES `employee` (`Oid`),
|
|
CONSTRAINT `FK_AIPROMPTBAUSTEINFOLDER_PARENT` FOREIGN KEY (`ParentFolderOid`) REFERENCES `aipromptbausteinfolder` (`Oid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
|
|
|
|
-- Prompts
|
|
CREATE TABLE `AiPromptbausteinPrompt` (
|
|
`Oid` bigint NOT NULL AUTO_INCREMENT,
|
|
`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,
|
|
`Title` varchar(255),
|
|
`Description` mediumtext,
|
|
`ParentFolderOid` bigint DEFAULT NULL,
|
|
`CreatorOid` bigint,
|
|
`IsPublic` tinyint,
|
|
`Position` int,
|
|
`Prompt` mediumtext,
|
|
`ShowPrompt` tinyint,
|
|
`ShowPromptByTenant` tinyint,
|
|
`IsOwnsoftPrompt` tinyint,
|
|
`OwnsoftRefLink` varchar(255),
|
|
`PromptId` varchar(255),
|
|
`ActionType` int,
|
|
PRIMARY KEY (`Oid`),
|
|
KEY `FK_AIPROMPTBAUSTEINPROMPT_EMPLOYEE_IDX` (`CreatorOid`),
|
|
KEY `FK_AIPROMPTBAUSTEINPROMPT_PARENT_IDX` (`ParentFolderOid`),
|
|
CONSTRAINT `FK_AIPROMPTBAUSTEINPROMPT_EMPLOYEE` FOREIGN KEY (`CreatorOid`) REFERENCES `employee` (`Oid`),
|
|
CONSTRAINT `FK_AIPROMPTBAUSTEINPROMPT_PARENT` FOREIGN KEY (`ParentFolderOid`) REFERENCES `aipromptbausteinfolder` (`Oid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
|
|
|
|
-- linking tables
|
|
CREATE TABLE `aipromptbausteinprompt2empfavorite` (
|
|
`AiPromptbausteinPromptOid` bigint NOT NULL,
|
|
`EmployeeOid` bigint NOT NULL,
|
|
PRIMARY KEY (`AiPromptbausteinPromptOid`,`EmployeeOid`),
|
|
CONSTRAINT `FK_AIPROMPTBAUSTEIN2EMPFAV_AIPROMPT` FOREIGN KEY (`AiPromptbausteinPromptOid`) REFERENCES `aipromptbausteinprompt` (`Oid`),
|
|
CONSTRAINT `FK_AIPROMPTBAUSTEIN2EMPFAV_APPUSER` FOREIGN KEY (`EmployeeOid`) REFERENCES `employee` (`Oid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
CREATE TABLE `aipromptbausteinprompt2emphide` (
|
|
`AiPromptbausteinPromptOid` bigint NOT NULL,
|
|
`EmployeeOid` bigint NOT NULL,
|
|
PRIMARY KEY (`AiPromptbausteinPromptOid`,`EmployeeOid`),
|
|
CONSTRAINT `FK_AIPROMPTBAUSTEIN2EMPHIDE_AIPROMPT` FOREIGN KEY (`AiPromptbausteinPromptOid`) REFERENCES `aipromptbausteinprompt` (`Oid`),
|
|
CONSTRAINT `FK_AIPROMPTBAUSTEIN2EMPHIDE_APPUSER` FOREIGN KEY (`EmployeeOid`) REFERENCES `employee` (`Oid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
CREATE TABLE `aipromptbausteinfolder2emphide` (
|
|
`AiPromptbausteinFolderOid` bigint NOT NULL,
|
|
`EmployeeOid` bigint NOT NULL,
|
|
PRIMARY KEY (`AiPromptbausteinFolderOid`,`EmployeeOid`),
|
|
CONSTRAINT `FK_AIPROMPTBAUSTEIN2EMPHIDE_AIFOLDER` FOREIGN KEY (`AiPromptbausteinFolderOid`) REFERENCES `aipromptbausteinfolder` (`Oid`),
|
|
CONSTRAINT `FK_AIPROMPTBAUSTEIN2EMPHIDE_APPUSER2` FOREIGN KEY (`EmployeeOid`) REFERENCES `employee` (`Oid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
CREATE TABLE `aipromptbausteinfolder2empshare` (
|
|
`AiPromptbausteinFolderOid` bigint NOT NULL,
|
|
`EmployeeOid` bigint NOT NULL,
|
|
PRIMARY KEY (`AiPromptbausteinFolderOid`,`EmployeeOid`),
|
|
CONSTRAINT `FK_AIPROMPTBAUSTEIN2EMPSHARE_AIFOLDER` FOREIGN KEY (`AiPromptbausteinFolderOid`) REFERENCES `aipromptbausteinfolder` (`Oid`),
|
|
CONSTRAINT `FK_AIPROMPTBAUSTEIN2EMPSHARE_APPUSER` FOREIGN KEY (`EmployeeOid`) REFERENCES `employee` (`Oid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
ALTER TABLE `aipromptbausteinprompt`
|
|
ADD COLUMN `SamplesCount` INT NOT NULL DEFAULT 0 AFTER `ActionType`;
|