###
### Description of mysql tables:  Tags
###

Here you'll find infos about all the tables for using tags on forum posts.

Public tags are defined in the code and have negative tag-IDs.

Important Notes:
   - Guests can NOT perform "writing" operations for tags


###########################################################################
## --- Tags ---

Description:
   Customized tags used by users with name & colors.
   Special tags like Like-tag are not stored in the table, but only defined as const, e.g. TAG_LIKE.

| Field   | Type        | Null | Key | Default | Extra          |
+---------+-------------+------+-----+---------+----------------+
| ID      | int(11)     | NO   | PRI | NULL    | auto_increment |
| User_ID | int(11)     | NO   | MUL | NULL    |                |
| Name    | varchar(64) | NO   |     | NULL    |                |
| ColorBG | char(6)     | NO   |     | NULL    |                |
| ColorFG | char(6)     | NO   |     | NULL    |                |

## Fields:

* ID : Tag ID; PK, auto-increment

* User_ID : Players.ID of tag creator

* Name : name of tag

* ColorBG : background color for tag-rendering

* ColorFG : text color (foreground) for tag-rendering


###########################################################################
## --- Tagged ---

Description:
   Tagging of forum post with private, customized tags by user.

| Field   | Type    | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| User_ID | int(11) | NO   | PRI | NULL    |       |
| Post_ID | int(11) | NO   | PRI | NULL    |       |
| Tag_ID  | int(11) | NO   | PRI | NULL    |       |

## Fields:

* User_ID : FK of Players.ID that set tag

* Post_ID : FK of Posts.ID where tag is set

* Tag_ID : FK of Tags.ID
   - >0 = private customized tags created by users
   - <0 = special implemented tags, e.g. TAG_LIKE