Plugins

Database Name

If a plugin requires a database table, by default the tables should exist in the wikidb, not a separate database.  However, a plugin should be configurable so the tables can exist in a separate database.

Putting the tables in the wiki database makes migrations much easier.

Table Naming

If a plugin requires a database table(s) the tables should have a standard prefix.  For example:

plugin_{plugin_name}

The table name must not exceed 64 characters.

Database Schema

The DDL to create tables should be named the following and should exist within the root of the plugin directory:

{plugin_name}.sql

• {plugin_name}.sql should be unix formatted (no windows line endings)
• Do not specify ENGINE, DEFAULT CHARSET, COLLATE - These values should be inherited from the database if the table is going in wikidb or specified in the CREATE DATABASE line if being created in a separate database.
• always use CREATE TABLE IF NOT EXISTS
• do not specify AUTO_INCREMENT=1
• do not rely on stored procedures
• always attempt to make the DDL (and queries) as portable as possible.  Avoid any mysql-specific features.