| To make your wait a bit less boring, here are all the names of the tables in the phpMyDesktop DB with a small description what they're used for. PMD_Users
Here are the profile informations stored of all users that are registered at your phpMyDesktop installation.
PMD_Groups
In this table, all the settings for the different user groups are stored. Some of them are default, like Admins, Moderators and Members, the rest is completly up to you. For example you can add a group for your closest friends and later post very personal messages only to that group.
PMD_Permissions
To make sure that your personal post can't be read by everyone, the permission table stores which group has which permissions. You can even connect them with different categories, usefull if a specific group should only have access to specific categories inside your installation.
PMD_Categories
The information in this table brings order into your data. The category system works similar like the folder system on your PC with unlimited depth. The system even allows labels for grouping features.
PMD_Subblocks
Subblocks are the sub content blocks that are mostly displayed in a smaller column left and/or right of the main block. You can select different sublocks for different main categories if you like or just store one main arrangement.
PMD_CustomFields
A normal post has two fields, title and message. With adding custom fields, you can add more specific structure to different posttypes.
PMD_CustomData
Here is the data stored from all posts with customFields.
PMD_PostTypes
Here are all the different post type settings stored. The most basic post type is the message to your desktop. Other default post types are: Discussion Topic, Announcement, Journal, Private Message. You can add more post types if you need something different.
PMD_Textblock
All text message blocks are stored in this table. If someone edits a message, the old one will be linked from the new one, but not deleted. This way, nothing can be lost, you could even make a Wiki with phpMyDesktop if you like.
PMD_Posts
Every thread starting post is stored in here. Not exactly the data itself, but the reference to the dataset IDs where the data is located. A lot of settings can be set by the user for each post, either.
PMD_Comments
A comment is always linked to an other post or an other item, like a link, a poll, an image in the gallery ... not as setting rich as posts, but they can be used for much everything in phpMyDesktop.
PMD_Kicks
Is an user hijacking a thread with nonsense, maybe more then once? Then this table makes it possible to kick that user out of a specific discussion. You can even set for how long.
PMD_Stats
phpMyDesktop has an intern statistic system. This system not only makes it possible to see graphicaly when you where receiving posts sended to your desktop, it's a global statistic system over the whole phpMyDesktop installation, even session trackings are possible with the data stored in here.
PMD_Links
Every link you want to show to your friends is stored in here. Combined with the category table, it's even possible to make a link directory if you wish.
PMD_Files
Do you have files you want to share with your friends? No problem, phpMyDesktop can make them accesible whenever you like.
PMD_Polls
Polls and their settings are stored in this table. You can order them in categories or even add them to a post.
PMD_Settings
Tons of global phpMyDesktop settings are stored in here. You can directly change them with the admin interface of the tool.
PMD_Gallery
Do you want to show the latest photos you made to your friends? No problem, just store them in the phpMyDesktop gallery.
PMD_Pictures
The informations of a picture inside the gallery is stored in here, with links to scaled down versions of the picture if needed.
PMD_Pictureframes
This table defines a pictureframe format used to set a specific size for specific pictures used in your different post types. For example you can define the x/y dimension of pictures that can be posted as a thread starter.
PMD_BadUsers
Here are IP addresses of banned users stored and informations of users on the ignore list. With additional informations like their bann reason, how long are they banned ...
PMD_Replacements
Badwords, smilies, helptexts, function-tags and other things to replace are stored in this table. Here you add new smilies, add new bad words or additional function-tags from the coder community.
PMD_Skins
Here you store your different skins, anyway if default skins, user selectable or still work in progress, it's all stored and editable in here.
PMD_SkinVariations
You can define skin variations for different posttypes and/or categories in here. This makes it possible to fully customize the look of special categories and/or posttypes.
PMD_Desktops
This table manages the Flash frontends displayed on your desktop, what is send to them and different other settings.
PMD_Ratings
With phpMyDesktop it is possible to rate much everything (if enabled). Anyway if this are messages to your desktop, links added by you or your users or every other content.
PMD_Quotes
The best quotes out of posts and their origins are stored in here. This way you have a place to remember the best old discussions and comments your friends made.
PMD_Interviews
Questions by members and their awnser by a member or you are stored in here. It's like an ongoing interview between each of your friends and you or an other friend.
PMD_Autolocations
History of locations by IP by each user. With the informations stored in here you can see if a user has changed his location over the time he was registered on your phpMyDesktop installation. |
