+------------------+
| Tables_in_ekstra |
+------------------+
| category         |
| groupcat         |
| indexarticles    |
| indexposts       |
| posts            |
| users            |
+------------------+

mysql> describe groupcat;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| groupCatId | int(11)     | NO   | PRI | NULL    | auto_increment |
| name       | varchar(20) | NO   |     | NULL    |                |
+------------+-------------+------+-----+---------+----------------+

mysql> describe category;
+----------------+-------------+------+-----+---------+----------------+
| Field          | Type        | Null | Key | Default | Extra          |
+----------------+-------------+------+-----+---------+----------------+
| cat_categoryId | int(11)     | NO   | PRI | NULL    | auto_increment |
| cat_groupCatId | int(11)     | NO   | MUL | NULL    |                |
| name           | varchar(20) | NO   |     | NULL    |                |
+----------------+-------------+------+-----+---------+----------------+

mysql> describe posts;
+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| postId          | int(11)      | NO   | PRI | NULL    | auto_increment |
| post_categoryId | int(11)      | NO   | MUL | NULL    |                |
| addedBy         | varchar(50)  | NO   |     | NULL    |                |
| dateAdded       | int(11)      | NO   |     | NULL    |                |
| title           | varchar(100) | NO   |     | NULL    |                |
| content         | text         | NO   |     | NULL    |                |
| pictureName     | varchar(50)  | NO   |     | NULL    |                |
| viewed          | int(11)      | NO   |     | 0       |                |
+-----------------+--------------+------+-----+---------+----------------+