PrivateContent stores data in two database tables: pc_users and pc_user_meta.
First one for main users data, and latest for meta. Just like WordPress does with posts.
Feel free to store anything you need into meta table using related class.
It supports also arrays and objects (plugin will serialize it).
pc_users structure:
column | description |
---|---|
id | user's ID |
insert_date | date when user has been inserted. Related to WordPress timezone and saved in datetime format |
name | user's name (max 150 chars long) |
surname | user's surname (max 150 chars long) |
username | user's username (max 150 chars long) |
psw | user's password (encrypted) |
categories | categories belonging to user (serialized IDs array) |
user's email (max 255 chars long) | |
tel | user's telephone (max 20 chars long) |
page_id | user's private page ID |
wp_user_id | WordPress user ID linked to PrivateContent user (if zero - no user linked) |
disable_pvt_page | boolean value (1/0) to know whether user's private page is disabled |
last_access | last login date. Related to WordPress timezone and saved in datetime format |
status | user's status (1 = active / 2 = disabled / 3 = pending) |
pc_user_meta structure:
column | description |
---|---|
meta_id | meta data ID (related to a single user) |
user_id | user ID the meta belongs to |
meta_key | meta key (max 255 chars long) |
meta_value | meta data value (string, integer or serialized array/object) |