Project

General

Profile

Support #9208

Manage 'recent' records

Added by Carsten Rose 26 days ago.

Status:
New
Priority:
Normal
Assignee:
Target version:
Start date:
19.09.2019
Due date:
% Done:

0%

Estimated time:
Discuss:

Description

  • 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;

Also available in: Atom PDF