Copyright (c) 2006, IT Services, ETH Zurich. All rights reserved.
See also LICENSE.txt

Meta::

  Valid for:  DBEditor 1.1
  Author:     Lorenz Textor

DBEditor
  
  DBEditor is a MySQL database GUI. When added to the ZMI it allows users 
  to view, edit and search the content of a MySQL database. It is not 
  thought to add or remove databases and tables or to edit the structure 
  of the tables.

Requirements

  DBEditor needs a working Z MySQL Database Connection.

Setup

  Use the ZMI to add a DBEditor and the ZMI manage tab to set it up.

  If you want to automatically save the creator, last editor, creation time 
  or modification time of records you have to create the following fields:
    creator:		DBEDITOR_CREATOR (type varchar)
    last editor:	DBEDITOR_LAST_EDITOR (type varchar)
    creation time:	DBEDITOR_CREATION_TIME (type timestamp)
    modification time:	DBEDITOR_MODFICIATION_TIME (type timestamp)

  Use the following table structure for logging:
  CREATE TABLE `dbeditor_logging` (
    `id` int(11) NOT NULL auto_increment,
    `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    `user` varchar(50) default NULL,
    `action_type` enum('insert','update','delete','undo') default NULL,
    `database` varchar(50) default NULL,
    `table` varchar(50) default NULL,
    `record_key` text,
    `undo_from` timestamp NOT NULL default '0000-00-00 00:00:00',
    `sql_query` text,
    `undo_sql_query` text,
    PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8
 
Credits

  Most testing and feature requests come from Marc Petitmermet/Karel Zeman.
  DBEditor uses the datepicker javascript (http://frequency-decoder.com)