Skip to content

Instantly share code, notes, and snippets.

@emaele

emaele/libgen.txt

Last active December 2, 2019 11:58
Show Gist options
  • Save emaele/d85408d8ae8f079073ba95c31ee57c26 to your computer and use it in GitHub Desktop.
Save emaele/d85408d8ae8f079073ba95c31ee57c26 to your computer and use it in GitHub Desktop.
Download ZIP
libgen table
Raw
libgen.txt
+------------------+---------------------+------+-----+---------------------+-------------------------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------------------+-------------------------------+
| ID | int(15) unsigned | NO | PRI | NULL | auto_increment |
| Title | varchar(2000) | YES | MUL | | |
| VolumeInfo | varchar(100) | YES | | | |
| Series | varchar(300) | YES | MUL | | |
| Periodical | varchar(200) | YES | | | |
| Author | varchar(1000) | YES | MUL | | |
| Year | varchar(14) | YES | MUL | | |
| Edition | varchar(60) | YES | | | |
| Publisher | varchar(400) | YES | MUL | | |
| City | varchar(100) | YES | | | |
| Pages | varchar(100) | YES | | | |
| PagesInFile | int(10) unsigned | NO | | 0 | |
| Language | varchar(150) | YES | MUL | | |
| Topic | varchar(500) | YES | MUL | | |
| Library | varchar(50) | YES | | | |
| Issue | varchar(100) | YES | | | |
| Identifier | varchar(300) | YES | MUL | | |
| ISSN | varchar(9) | YES | | | |
| ASIN | varchar(200) | YES | | | |
| UDC | varchar(200) | YES | | | |
| LBC | varchar(200) | YES | | | |
| DDC | varchar(45) | YES | | | |
| LCC | varchar(45) | YES | | | |
| Doi | varchar(45) | YES | MUL | | |
| Googlebookid | varchar(45) | YES | | | |
| OpenLibraryID | varchar(200) | YES | | | |
| Commentary | varchar(10000) | YES | | | |
| DPI | int(6) unsigned | YES | | 0 | |
| Color | varchar(1) | YES | | | |
| Cleaned | varchar(1) | YES | | | |
| Orientation | varchar(1) | YES | | | |
| Paginated | varchar(1) | YES | | | |
| Scanned | varchar(1) | YES | | | |
| Bookmarked | varchar(1) | YES | | | |
| Searchable | varchar(1) | YES | | | |
| Filesize | bigint(20) unsigned | NO | | 0 | |
| Extension | varchar(50) | YES | MUL | | |
| MD5 | char(32) | YES | UNI | | |
| Generic | char(32) | YES | MUL | | |
| Visible | char(3) | YES | MUL | | |
| Locator | varchar(733) | YES | | | |
| Local | int(10) unsigned | YES | | 0 | |
| TimeAdded | timestamp | NO | MUL | 2000-01-01 09:00:00 | |
| TimeLastModified | timestamp | NO | MUL | current_timestamp() | on update current_timestamp() |
| Coverurl | varchar(200) | YES | | | |
| Tags | varchar(500) | YES | MUL | | |
| IdentifierWODash | varchar(300) | YES | MUL | | |
+------------------+---------------------+------+-----+---------------------+-------------------------------+
+--------+--------------------------------------+------------+--------+------------+-------------------------------+------+---------+----------------+------+-------+-------------+----------+-------+-----------+------------+--------------------------+------+------+------+------+--------+-----------------------+------+--------------+---------------+------------+------+-------+---------+-------------+-----------+---------+------------+------------+----------+-----------+----------------------------------+---------+---------+-----------------------------------------------+-------+---------------------+---------------------+----------+------+--------------------------+
| ID | Title | VolumeInfo | Series | Periodical | Author | Year | Edition | Publisher | City | Pages | PagesInFile | Language | Topic | Library | Issue | Identifier | ISSN | ASIN | UDC | LBC | DDC | LCC | Doi | Googlebookid | OpenLibraryID | Commentary | DPI | Color | Cleaned | Orientation | Paginated | Scanned | Bookmarked | Searchable | Filesize | Extension | MD5 | Generic | Visible | Locator | Local | TimeAdded | TimeLastModified | Coverurl | Tags | IdentifierWODash |
+--------+--------------------------------------+------------+--------+------------+-------------------------------+------+---------+----------------+------+-------+-------------+----------+-------+-----------+------------+--------------------------+------+------+------+------+--------+-----------------------+------+--------------+---------------+------------+------+-------+---------+-------------+-----------+---------+------------+------------+----------+-----------+----------------------------------+---------+---------+-----------------------------------------------+-------+---------------------+---------------------+----------+------+--------------------------+
| 175728 | OReilly JUNOS Enterprise Routing Mar | | | | Doug Marschke, Harry Reynolds | 2008 | | O'Reilly Media | | | 0 | English | 79 | Kingdwarf | to 2009-09 | 0596514425,9780596514426 | | | | | 004.62 | TK5105.543 .M367 2008 | | | OL10781008M | | 0 | | | | | | | | 6996620 | chm | 0C0A39637EC25C8927A7BF7D60696A29 | | | OReilly.JUNOS.Enterprise.Routing.Mar.2008.chm | 0 | 2010-01-07 06:59:20 | 2016-04-28 14:48:27 | | | 0596514425,9780596514426 |
+--------+--------------------------------------+------------+--------+------------+-------------------------------+------+---------+----------------+------+-------+-------------+----------+-------+-----------+------------+--------------------------+------+------+------+------+--------+-----------------------+------+--------------+---------------+------------+------+-------+---------+-------------+-----------+---------+------------+------------+----------+-----------+----------------------------------+---------+---------+-----------------------------------------------+-------+---------------------+---------------------+----------+------+--------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment