DEPRECATION WARNING

This documentation is not using the current rendering mechanism and is probably outdated. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.

EXT: Table Updater

Author:Michiel Roos
Created:2013-03-14T14:36:59
Changed by:Michiel Roos
Changed:2013-12-08T23:50:33.995414000
Email:extensions@donationbasedhosting.org
Info 2:
Info 3:
Info 4:

EXT: Table Updater

Extension Key: table updater

Copyright 2010-2011, Michiel Roos <extensions@donationbasedhosting.org>

This document is published under the Open Content License

available from http://www.opencontent.org/opl.shtml

The content of this document is related to TYPO3

- a GNU/GPL CMS/Framework available from www.typo3.com

Table of Contents

EXT: Table Updater 1

Introduction 3

General usage 4

Administration 5

Installation 5

Known problems 6

TODO 7

Changelog 8

Introduction

This extension provides a command line interface for 'updating the database' by supplying three different tasks:

  • update
  • delete
  • updateAndDelete

The update functionality is found in the install tool. This extension exposes it on the command line. It can be used when setting up a site from the command line.

General usage

Ensure a backend user by the name of '_cli_lowlevel' is present.

This extension provides a command line task for 'updating the database' by supplying three different tasks:

  • update
  • delete
  • updateAndDelete

The update task will execute 'CREATE TABLE' and 'ALTER TABLE ADD/ALTER' statements.

The delete task will execute 'DROP TABLE' and 'ALTER TABLE DROP' statements.

The updateAndDelete task will do both.

Please note that (just as in the install tool) the update and delete calls may need to be called multiple times for all the updates to resolve. For example; the first step of the 'delete' call will only 'rename' fields and tables to be deleted with a prefix of 'zzz_'. The second call will do the actual cleanup.

Administration

Installation

Install the extension using the extension manager.

Known problems

If you find any problems, please report them to me by mail.

Please take some time and make a proper report stating at least:

  • version of the extension
  • reproducibility
  • steps to reproduce
  • observed behavior
  • expected behavior

Writing a good bug report will help us to fix the bugs faster and better.

TODO

Currently we have no TODO. If you have great innovative ideas, please let me know by sending me a mail.

Changelog

Version

a

Version

b

Date

c

Changes

1.0.0

a

1.0.0

b

8 December 2013

c

First release

img-1

EXT: Table Updater 0