Schema:recognized domains

Schema Summary

+------------------------+------------+------+-----+---------+--------------+
| Field                  | Type       | Null | Key | Default | Extra        |
+------------------------+------------+------+-----+---------+--------------+
| domain_id              | int(11)    | NO   | PRI | 0       |auto-increment|
| domain_name            | text       | NO   |     | NULL    |              |
| site_name              | text       | NO   |     | NULL    |              |
| site_url               | mediumtext | YES  |     | NULL    |              |
| linking_allowed        | tinyint(1) | YES  |     | NULL    |              |
| required_segment       | text       | YES  |     | NULL    |              |
| explicit_link_required | tinyint(1) | YES  |     | NULL    |              |
+--------------+-------------+------+-----+---------+-----------------------+

Description

• domain_id - Unique integer auto-incremented domain ID.

• domain_name - Internet domain name.

• site_name - The name of the site that will be credited on ISFDB pages.

• site_url - The URL of the site that will be linked in the credit on ISFDB pages.

• linking_allowed - 1 if the site has given the ISFDB permission to link to its images or 0 if it hasn't.

• required_segment - Optional URL segment; if specified, the string must be present in the URL.

• explicit_link_required - 1 if a Web page URL must be added to the end of the image URL after "|", e.g. https://x.sf-encyclopedia.com/gal/clute/OwenW-More.jpg|https://sf-encyclopedia.com/gallery.php?id=OwenW-More.jpg ; 0 otherwise.