core (MySQL!) database structure: -- Relations CREATE TABLE tiny_content ( -- contentID INT NOT NULL, -- ----------+ title VARCHAR(120), -- | headline VARCHAR(120), -- | text TEXT, -- | locationID INT NOT NULL, -- <--+ | date_creation DATETIME, -- | | date_modification TIMESTAMP, -- | | PRIMARY KEY (contentID)) -- |1:1 | -- | |1:n CREATE TABLE tiny_location ( -- | | locationID INT NOT NULL, -- <--+ | parentID INT, -- | pseudo_tree VARCHAR(60), -- | PRIMARY KEY (locationID)) -- | -- | CREATE TABLE tiny_rel_content_plugin ( -- | contentID INT NOT NULL, -- <---------+ pluginID INT NOT NULL, -- <---------+ PRIMARY KEY (contentID, pluginID)) -- | -- |1:n CREATE TABLE tiny_plugin ( -- | pluginID INT NOT NULL, -- ----------+ name VARCHAR(60), -- administrable BIT, -- template_block VARCHAR(60), -- PRIMARY KEY (pluginID)) --