Menu
▾
▴
Re: [Slashcode-general] Sections Topics Nexus Weight
|
From: Jim F. <hea...@ya...> - 2006-07-10 03:19:57
|
mysql> select * from topics; +-----+---------------+-----------------+--------+-------+-------+--------+-------------+------------+---------------+ | tid | keyword | textname | series | image | width | height | submittable | searchable | storypickable | +-----+---------------+-----------------+--------+-------+-------+--------+-------------+------------+---------------+ | 1 | mainpage | Main Page | no | | 0 | 0 | no | yes | yes | | 2 | features | Features | no | | 0 | 0 | no | yes | yes | | 3 | pictures | Pictures | no | | 0 | 0 | yes | yes | yes | | 4 | videos | Videos | no | | 0 | 0 | yes | yes | yes | | 5 | news | News Articles | no | | 0 | 0 | yes | yes | yes | | 6 | editorials | Editorials | no | | 0 | 0 | yes | yes | yes | | 7 | audio | Audio | no | | 0 | 0 | yes | yes | yes | | 8 | text | Text Jokes | no | | 0 | 0 | yes | yes | yes | | 9 | games | Games | no | | 0 | 0 | yes | yes | yes | | 10 | animals | Animals | no | | 0 | 0 | yes | yes | yes | | 11 | adult | Adult | no | | 0 | 0 | yes | yes | yes | | 12 | bars | Bars and Drunks | no | | 0 | 0 | yes | yes | yes | | 13 | blondes | Blondes | no | | 0 | 0 | yes | yes | yes | | 14 | business | Business | no | | 0 | 0 | yes | yes | yes | | 15 | celebrity | Celebrity | no | | 0 | 0 | yes | yes | yes | | 16 | computer | Computer | no | | 0 | 0 | yes | yes | yes | | 17 | ethnic | Ethnic | no | | 0 | 0 | yes | yes | yes | | 18 | fart | Fart | no | | 0 | 0 | yes | yes | yes | | 19 | food | Food | no | | 0 | 0 | yes | yes | yes | | 20 | gender | Gender | no | | 0 | 0 | yes | yes | yes | | 21 | holidays | Holidays | no | | 0 | 0 | yes | yes | yes | | 22 | political | Political | no | | 0 | 0 | yes | yes | yes | | 23 | redneck | Redneck | no | | 0 | 0 | yes | yes | yes | | 24 | relationships | Relationships | no | | 0 | 0 | yes | yes | yes | | 25 | religious | Religious | no | | 0 | 0 | yes | yes | yes | | 26 | revenge | Revenge | no | | 0 | 0 | yes | yes | yes | | 27 | sports | Sports | no | | 0 | 0 | yes | yes | yes | +-----+---------------+-----------------+--------+-------+-------+--------+-------------+------------+---------------+ 27 rows in set (0.00 sec) mysql> select * from topic_parents; +-----+------------+------------+ | tid | parent_tid | min_weight | +-----+------------+------------+ | 3 | 1 | 1 | | 3 | 2 | 1 | | 4 | 1 | 1 | | 4 | 2 | 1 | | 5 | 1 | 1 | | 5 | 2 | 1 | | 6 | 1 | 1 | | 6 | 2 | 1 | | 7 | 1 | 1 | | 7 | 2 | 1 | | 8 | 1 | 1 | | 8 | 2 | 1 | | 9 | 1 | 1 | | 9 | 2 | 1 | +-----+------------+------------+ 14 rows in set (0.01 sec) mysql> select * from topic_nexus; +-----+-------------+ | tid | current_qid | +-----+-------------+ | 1 | 3 | | 2 | NULL | | 3 | NULL | | 4 | NULL | | 5 | NULL | | 6 | NULL | | 7 | NULL | | 8 | NULL | | 9 | NULL | +-----+-------------+ 9 rows in set (0.00 sec) mysql> select * from skins; +------+-------+--------------+--------------+------------+---------------+-------+-------------+------------+---------------+-----+-------------------+--------------+---------------+------------------+---------------------+--------+ | skid | nexus | artcount_min | artcount_max | name | title | issue | submittable | searchable | storypickable | url | hostname | cookiedomain | index_handler | max_rewrite_secs | last_rewrite | ac_uid | +------+-------+--------------+--------------+------------+---------------+-------+-------------+------------+---------------+-----+-------------------+--------------+---------------+------------------+---------------------+--------+ | 1 | 1 | 10 | 30 | mainpage | Main Page | no | yes | yes | yes | | duncecapjokes.com | | index.pl | 3600 | 2006-07-09 20:57:05 | 0 | | 2 | 2 | 7 | 21 | features | Features | no | yes | yes | yes | | duncecapjokes.com | | index.pl | 3600 | 2006-07-09 20:57:07 | 0 | | 3 | 3 | 7 | 21 | pics | Pictures | no | yes | yes | yes | | duncecapjokes.com | | index.pl | 3600 | 2006-07-09 21:07:04 | 0 | | 4 | 4 | 7 | 21 | videos | Videos | no | yes | yes | yes | | duncecapjokes.com | | index.pl | 3600 | 2006-07-09 21:07:06 | 0 | | 5 | 5 | 7 | 21 | news | News Articles | no | yes | yes | yes | | duncecapjokes.com | | index.pl | 3600 | 2006-07-09 21:07:08 | 0 | | 6 | 6 | 7 | 21 | editorials | Editorials | no | yes | yes | yes | | duncecapjokes.com | | index.pl | 3600 | 2006-07-09 21:07:09 | 0 | | 7 | 7 | 7 | 21 | audio | Audio | no | yes | yes | yes | | duncecapjokes.com | | index.pl | 3600 | 2006-07-09 21:07:10 | 0 | | 8 | 8 | 7 | 21 | text | Text Jokes | no | yes | yes | yes | | duncecapjokes.com | | index.pl | 3600 | 2006-07-09 21:07:12 | 0 | | 9 | 9 | 7 | 21 | games | Games | no | yes | yes | yes | | duncecapjokes.com | | index.pl | 3600 | 2006-07-09 21:07:13 | 0 | +------+-------+--------------+--------------+------------+---------------+-------+-------------+------------+---------------+-----+-------------------+--------------+---------------+------------------+---------------------+--------+ 9 rows in set (0.00 sec) |
