QFQ

• QFQ soll pro User 'Last Recently Used' Records anlegen

CREATE TABLE `Recent` (
  `id` int(11) NOT NULL,
  `tableName` varchar(63) NOT NULL,
  `r` int(11) NOT NULL,
  `feUser` varchar(63) NOT NULL,
  `formId` int(11) NOT NULL,
  `recordModified` enum('yes','no','') NOT NULL DEFAULT '',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Recent`
--
ALTER TABLE `Recent`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tableName` (`tableName`),
  ADD KEY `feUserTableNameR` (`feUser`,`tableName`,`r`) USING BTREE;
  ADD KEY `feUserFormIdR` (`feUser`,`formId`,`r`) USING BTREE;