Project

General

Profile

Feature #9208

Manage 'recent' records

Added by Carsten Rose about 1 year ago. Updated 9 months 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;

History

#1 Updated by Carsten Rose 11 months ago

  • Status changed from New to Some day maybe

#2 Updated by Carsten Rose 11 months ago

  • Status changed from Some day maybe to New

#3 Updated by Carsten Rose 9 months ago

  • Tracker changed from Support to Feature

#4 Updated by Carsten Rose 9 months ago

  • Target version changed from 146 to next

#5 Updated by Carsten Rose 9 months ago

  • Target version changed from next to next2

Also available in: Atom PDF