Admin:db
From The Scuba Wiki
TxHockeyGuy (Talk | contribs) (Created page with '===== DB Stuff ===== Categories can easily be searched in the categorylinks table select * FROM categorylinks WHERE cl_to = 'Test' Here is the DB structure: mysql> describe cā¦') |
TxHockeyGuy (Talk | contribs) (āDB Stuff) |
||
| Line 7: | Line 7: | ||
Here is the DB structure: | Here is the DB structure: | ||
| - | mysql> describe categorylinks; | + | <nowiki>mysql> describe categorylinks; |
+--------------+------------------+------+-----+-------------------+-------+ | +--------------+------------------+------+-----+-------------------+-------+ | ||
| Field | Type | Null | Key | Default | Extra | | | Field | Type | Null | Key | Default | Extra | | ||
| Line 15: | Line 15: | ||
| cl_sortkey | varbinary(70) | NO | | NULL | | | | cl_sortkey | varbinary(70) | NO | | NULL | | | ||
| cl_timestamp | timestamp | YES | | CURRENT_TIMESTAMP | | | | cl_timestamp | timestamp | YES | | CURRENT_TIMESTAMP | | | ||
| - | +--------------+------------------+------+-----+-------------------+-------+ | + | +--------------+------------------+------+-----+-------------------+-------+</nowiki> |
Revision as of 03:43, 9 February 2010
DB Stuff
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 | | +--------------+------------------+------+-----+-------------------+-------+
