Database structure

From Popms Wiki
Jump to: navigation, search

This page contains structure of the database for website, wiki, forum and Multiplayer Platform. Website, wiki and forums are using MySQL, Multiplayer Platform is using PostgreSQL.

[edit] Website

[edit] Multiplayer Platform

Multiplayer Platform uses template files which are preprocessed to the standard SQL files during compilation. All occurrence of constants like {NAME_OF_CONST} are replaced with their values.

-- Installed modules on the server
CREATE TABLE {MP_PREF}modules(
    module_id    SERIAL PRIMARY KEY,
    name         VARCHAR(20) 
);

[edit] Templates for modules

Personal tools
Namespaces

Variants
Actions
Navigation
Tools