rendered paste body+------------------+
| 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 | |
+-----------------+--------------+------+-----+---------+----------------+