Database information - PSF1/pharinix GitHub Wiki

• Table node_type

Node types definitions. Only contains name of type and some log information. Fields named created, creator_node_user, modifier and modifier_node_user contains creation and modification dates and ID of the future user node_type.

• Table node_type_field

name: Field name

type: Type of the field, it can be a basic type, 'longtext', 'bool', 'datetime', 'double', 'integer, 'string', 'password', 'htmltext' or a node type name. A 'password' type save a MD5 representation of her value.

len: Length of field, if it's applicable

required: is a required field?

readonly: is a not writeble field?

locked: is a system field?

node_type: ID of owner node type

default: Default value

label: Label in form, or table headers

help: Help about the field

multi: If type is not a basic type, it can link some other records. (One to any relation)

• Table pages

name: Page name, it's used how ID to some commands

template: Relative path to the template, ex. etc/templates/pages/default.xml

title: Title of the page

description: Meta description, it's for search indexers

keys: Meta key words, it's for search indexers

• Table page-blocks

idpage: Numeric ID of the page owner of the block. A zero ID is for show in all pages, that have the idcol selected

idcol: ID of the column. In the template editor you can see/modify this IDs

command: The command to execute (case sensitive on linux)

parameters: Post parametes to apply to the command, it must be URL encoded

priority: If a block have more than one command, this value change the execution order

• Table url_rewrite

url: Relative URL to rewrite.

rewriteto: Post parameters to apply when rewrite the URL, it must be URL encoded and include the parameter 'command'

All the tables must have a indexed key field named 'id'.

Notes: I encourage you to read first the tests files, and then read the source code.