Extension:SacredText/sacredtext verses table

From MediaWiki.org
Jump to navigation Jump to search
mysql> describe sacredtext_verses;
+-------------------+------------------------------------------------+------+-----+-----------------+----------------+
| Field             | Type                                           | Null | Key | Default         | Extra          |
+-------------------+------------------------------------------------+------+-----+-----------------+----------------+
| st_verse_index    | int(11)                                        | NO   | PRI | NULL            | auto_increment |
| st_religious_text | enum('Christian Bible','Hebrew Bible','Quran') | NO   |     | Christian Bible |                |
| st_book           | varbinary(255)                                 | NO   |     | NULL            |                |
| st_chapter_num    | smallint(6)                                    | NO   |     | NULL            |                |
| st_verse_num      | smallint(6)                                    | NO   |     | NULL            |                |
| st_language       | char(2)                                        | NO   |     | en              |                |
| st_translation    | varchar(255)                                   | NO   |     | NULL            |                |
| st_text           | text                                           | NO   |     | NULL            |                |
+-------------------+------------------------------------------------+------+-----+-----------------+----------------+
8 rows in set (0.00 sec)