Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This tag is reserved for further implementations of plugin dependencies. The structure of tags is not final and may change.

plugin-install.sql

...

and plugin-uninstall.sql

These files contain additional statements executed on the installation / uninstall of the plugin. 

Info
titleCurrently under construction

This part of the page is currently under construction and soon contains all relevant information. Please be patient.

plugin-uninstall.sql

This file contains additional statement executed on the uninstallation of the plugin.

...

titleCurrently under construction

...

Both files expects one statement per line. Multi line statements are currently not supported and will lead to errors.

Because plugin database tables must have a special prefix, a special keyword "!PREFIX!" is available to replace it accordingly. Statements, which does not contain this placeholder are not executed.

Furthermore, it is only possible to execute the following database operations.

Installation typeAvailable operations
Installation
  • CREATE TABLE IF NOT EXISTS
  • INSERT INTO

  • UPDATE
  • ALTER TABLE
Uninstall
  • DELETE FROM
  • DROP TABLE

 

The prefix placeholder contains the common database table prefix (per default: "con_") following by the chars "pi" for plugin.

Code Block
languagesql
titleExample
INSERT INTO !PREFIX!_news_log ...
gets
INSERT INTO con_pi_news_log ...