Child pages
  • Database table properties

Versions Compared


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


The table properties contains values of various properties.

Properties are a clientwide ressources.

Table structure

Field nameField specificationComment / Explanation
idpropertyint(11)Primary key (auto increment)
idclientint(11)Foreign key to table clients
itemtypevarchar(64)Type of the property item
itemidvarchar(255)ID of the property item
typevarchar(96)Type of the property
namevarchar(96)Name of the property
valuetextValue of the property
authorvarchar(32)Username of the creator
createddatetimeDate and time of creation
modifieddatetimeDate and time of last modification
modifiedbyvarchar(32)Username of the last modifier