Database: bransonparks
Table: links
[11 columns]
+-------------+--------------+
| Column      | Type         |
+-------------+--------------+
| level       | int(11)      |
| size        | float        |
| description | varchar(255) |
| fulltxt     | mediumtext   |
| indexdate   | date         |
| link_id     | int(11)      |
| md5sum      | varchar(32)  |
| site_id     | int(11)      |
| title       | varchar(200) |
| url         | varchar(255) |
| visible     | int(11)      |
+-------------+--------------+

Database: bransonparks
Table: link_keyword1
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: link_keyword0
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: link_keyword3
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: link_keyword2
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: link_keyword5
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: link_keyword4
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: link_keyword7
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: link_keyword6
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: link_keyword9
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: home
[3 columns]
+-------------+---------+
| Column      | Type    |
+-------------+---------+
| id          | int(11) |
| maincontent | text    |
| parkblurb   | text    |
+-------------+---------+

Database: bransonparks
Table: ads
[12 columns]
+----------+-------------+
| Column   | Type        |
+----------+-------------+
| address  | text        |
| big_ad   | int(11)     |
| category | text        |
| city     | text        |
| id       | int(11)     |
| link     | text        |
| logo     | text        |
| name     | text        |
| phone    | varchar(20) |
| phone2   | varchar(20) |
| state    | text        |
| zip      | text        |
+----------+-------------+

Database: bransonparks
Table: link_keywordf
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: sites
[9 columns]
+------------------+--------------+
| Column           | Type         |
+------------------+--------------+
| can_leave_domain | tinyint(1)   |
| disallowed       | text         |
| indexdate        | date         |
| required         | text         |
| short_desc       | text         |
| site_id          | int(11)      |
| spider_depth     | int(11)      |
| title            | varchar(255) |
| url              | varchar(255) |
+------------------+--------------+

Database: bransonparks
Table: parks
[7 columns]
+---------+------------+
| Column  | Type       |
+---------+------------+
| content | text       |
| id      | tinyint(4) |
| image1  | text       |
| image2  | text       |
| image3  | text       |
| image4  | text       |
| name    | text       |
+---------+------------+

Database: bransonparks
Table: sports
[8 columns]
+---------+------------+
| Column  | Type       |
+---------+------------+
| age     | tinyint(4) |
| content | text       |
| id      | int(11)    |
| image1  | text       |
| image2  | text       |
| image3  | text       |
| image4  | text       |
| title   | text       |
+---------+------------+

Database: bransonparks
Table: link_keyword8
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: tournaments
[5 columns]
+----------+---------+
| Column   | Type    |
+----------+---------+
| content  | text    |
| content2 | text    |
| content3 | text    |
| content4 | text    |
| id       | int(11) |
+----------+---------+

Database: bransonparks
Table: events
[2 columns]
+--------+---------+
| Column | Type    |
+--------+---------+
| blurb  | text    |
| id     | int(11) |
+--------+---------+

Database: bransonparks
Table: pending
[5 columns]
+---------+-------------+
| Column  | Type        |
+---------+-------------+
| count   | int(11)     |
| level   | int(11)     |
| num     | int(11)     |
| site_id | int(11)     |
| temp_id | varchar(32) |
+---------+-------------+

Database: bransonparks
Table: link_keyworda
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: site_category
[2 columns]
+-------------+---------+
| Column      | Type    |
+-------------+---------+
| category_id | int(11) |
| site_id     | int(11) |
+-------------+---------+

Database: bransonparks
Table: link_keywordc
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: link_keywordb
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: link_keyworde
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: link_keywordd
[4 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| domain     | int(4)  |
| keyword_id | int(11) |
| link_id    | int(11) |
| weight     | int(3)  |
+------------+---------+

Database: bransonparks
Table: schedule
[2 columns]
+---------+---------+
| Column  | Type    |
+---------+---------+
| content | int(11) |
| id      | int(11) |
+---------+---------+

Database: bransonparks
Table: gallery
[4 columns]
+----------+---------+
| Column   | Type    |
+----------+---------+
| alt_text | text    |
| filename | text    |
| id       | int(11) |
| page_id  | text    |
+----------+---------+

Database: bransonparks
Table: slideshow
[3 columns]
+---------+------------+
| Column  | Type       |
+---------+------------+
| caption | text       |
| id      | tinyint(4) |
| image   | text       |
+---------+------------+

Database: bransonparks
Table: pages
[9 columns]
+-----------+------------+
| Column    | Type       |
+-----------+------------+
| content   | text       |
| gallery   | int(11)    |
| id        | tinyint(4) |
| image1    | text       |
| image2    | text       |
| image3    | text       |
| image4    | text       |
| parent_id | tinyint(4) |
| title     | text       |
+-----------+------------+

Database: bransonparks
Table: categories
[3 columns]
+-------------+---------+
| Column      | Type    |
+-------------+---------+
| category    | text    |
| category_id | int(11) |
| parent_num  | int(11) |
+-------------+---------+

Database: bransonparks
Table: temp
[3 columns]
+--------+--------------+
| Column | Type         |
+--------+--------------+
| level  | int(11)      |
| id     | varchar(32)  |
| link   | varchar(255) |
+--------+--------------+

Database: bransonparks
Table: keywords
[2 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| keyword    | varchar(30) |
| keyword_id | int(11)     |
+------------+-------------+

Database: bransonparks
Table: query_log
[4 columns]
+---------+--------------+
| Column  | Type         |
+---------+--------------+
| time    | timestamp    |
| elapsed | float        |
| query   | varchar(255) |
| results | int(11)      |
+---------+--------------+

Database: bransonparks
Table: domains
[2 columns]
+-----------+--------------+
| Column    | Type         |
+-----------+--------------+
| domain    | varchar(255) |
| domain_id | int(11)      |
+-----------+--------------+