Admin:db
From The Scuba Wiki
DB Stuff
Note, edit this page to actually be able to see anything. It's gibberish in wiki format.
Categories can easily be searched in the categorylinks table
select * FROM categorylinks WHERE cl_to = 'Test'
Here is the DB structure:
mysql> describe categorylinks;
+--------------+------------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+-------------------+-------+
| cl_from | int(10) unsigned | NO | PRI | 0 | |
| cl_to | varbinary(255) | NO | PRI | NULL | |
| cl_sortkey | varbinary(70) | NO | | NULL | |
| cl_timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
+--------------+------------------+------+-----+-------------------+-------+
Text fields are stored here:
mysql> describe smw_text2;
+------------+-----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-----------------+------+-----+---------+-------+
| s_id | int(8) unsigned | NO | MUL | NULL | |
| p_id | int(8) unsigned | NO | MUL | NULL | |
| value_blob | mediumblob | YES | | NULL | |
+------------+-----------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
