libgen网站 数据库备份

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `updated`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `updated` ( `ID` int(15) unsigned NOT NULL AUTO_INCREMENT, `Title` varchar(2000) DEFAULT '', `VolumeInfo` varchar(100) DEFAULT '', `Series` varchar(300) DEFAULT '', `Periodical` varchar(200) DEFAULT '', `Author` varchar(1000) DEFAULT '', `Year` varchar(14) DEFAULT '', `Edition` varchar(60) DEFAULT '', `Publisher` varchar(400) DEFAULT '', `City` varchar(100) DEFAULT '', `Pages` varchar(100) DEFAULT '', `PagesInFile` int(10) unsigned NOT NULL DEFAULT 0, `Language` varchar(150) DEFAULT '', `Topic` varchar(500) DEFAULT '', `Library` varchar(50) DEFAULT '', `Issue` varchar(100) DEFAULT '', `Identifier` varchar(300) DEFAULT '', `ISSN` varchar(9) DEFAULT '', `ASIN` varchar(200) DEFAULT '', `UDC` varchar(200) DEFAULT '', `LBC` varchar(200) DEFAULT '', `DDC` varchar(45) DEFAULT '', `LCC` varchar(45) DEFAULT '', `Doi` varchar(45) DEFAULT '', `Googlebookid` varchar(45) DEFAULT '', `OpenLibraryID` varchar(200) DEFAULT '', `Commentary` varchar(10000) DEFAULT '', `DPI` int(6) unsigned DEFAULT 0, `Color` varchar(1) DEFAULT '', `Cleaned` varchar(1) DEFAULT '', `Orientation` varchar(1) DEFAULT '', `Paginated` varchar(1) DEFAULT '', `Scanned` varchar(1) DEFAULT '', `Bookmarked` varchar(1) DEFAULT '', `Searchable` varchar(1) DEFAULT '', `Filesize` bigint(20) unsigned NOT NULL DEFAULT 0, `Extension` varchar(50) DEFAULT '', `MD5` char(32) DEFAULT '', `Generic` char(32) DEFAULT '', `Visible` char(3) DEFAULT '', `Locator` varchar(733) DEFAULT '', `Local` int(10) unsigned DEFAULT 0, `TimeAdded` timestamp NOT NULL DEFAULT '2000-01-01 05:00:00', `TimeLastModified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `Coverurl` varchar(200) DEFAULT '', `Tags` varchar(500) DEFAULT '', `IdentifierWODash` varchar(300) DEFAULT '', PRIMARY KEY (`ID`), UNIQUE KEY `MD5` (`MD5`), KEY `Generic` (`Generic`) USING BTREE, KEY `VisibleTimeAdded` (`Visible`,`TimeAdded`) USING BTREE, KEY `TimeAdded` (`TimeAdded`) USING BTREE, KEY `Topic` (`Topic`(3)) USING BTREE, KEY `VisibleID` (`Visible`,`ID`) USING BTREE, KEY `VisibleTimeLastModified` (`Visible`,`TimeLastModified`,`ID`) USING BTREE, KEY `TimeLastModifiedID` (`TimeLastModified`,`ID`) USING BTREE, KEY `DOI_INDEX` (`Doi`) USING BTREE, KEY `Identifier` (`Identifier`), KEY `Language` (`Language`), KEY `Extension` (`Extension`), FULLTEXT KEY `Title` (`Title`), FULLTEXT KEY `Author` (`Author`), FULLTEXT KEY `Language_FTS` (`Language`), FULLTEXT KEY `Publisher` (`Publisher`), FULLTEXT KEY `Series` (`Series`), FULLTEXT KEY `Year` (`Year`), FULLTEXT KEY `Title1` (`Title`,`Author`,`Series`,`Publisher`,`Year`,`Periodical`,`VolumeInfo`), FULLTEXT KEY `Tags` (`Tags`), FULLTEXT KEY `Identifierfulltext` (`IdentifierWODash`) ) ENGINE=MyISAM AUTO_INCREMENT=3646160 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `updated` WRITE; /*!40000 ALTER TABLE `updated` DISABLE KEYS */; INSERT INTO `updated` (`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`) VALUES (1,'Handbook of Clinical Drug Data','','','','Philip Anderson','2001','10','McGraw-Hill Medical','','1163',1163,'English','12','Kolxo3','17','0-07-136362-9','','','','','','','','','','',0,'','','','','','','1',3627486,'pdf','7b2a4d53fde834e801c26a2bab7e0240','','','B_Biology/Handbook of Clinical Drug Data (10th Edition)(1163s).pdf',0,'2009-07-20 03:45:11','2019-12-21 21:23:21','0/7b2a4d53fde834e801c26a2bab7e0240.jpg','','0071363629'),(2,'Handbook of Herbs and Spices','Volume 1','','','K V Peter','2001','1','CRC Press','','332',332,'English','0','Kolxoz','17','9780849312175,0849312175','','','','','','','','','','',0,'','','','','1','1','1',1552793,'pdf','048ea0496db0444f873139cd705a07af','','','B_Biology/Handbook of Herbs and Spices, Volume 1 (2001)(ISBN 0849312175)(332s).pdf',0,'2009-07-20 03:45:11','2019-12-21 21:23:21','0/048ea0496db0444f873139cd705a07af-d.jpg','Библиотека;Досуг;Кулинария;Соусы и специи;','9780849312175,0849312175'),(3,'Handbook of Herbs and Spices: Volume 2','Volume 2','Handbook of Herbs and Spices','','Peter, K.V.','2004','2, illustrated','Woodhead Pub.','','360',374,'English','49','Kolxo3','17','1855737213, 9781855737211','','','','','','','','jITovbFEuO8C','','',0,'','','','','1','1','1',2298559,'pdf','411b9300a2f2094800e0e30d439c30fd','','','B_Biology/Handbook of Herbs and Spices, Volume 2 (2001)(ISBN 0849325358)(374s).pdf',0,'2009-07-20 03:45:11','2019-12-21 21:23:21','0/411b9300a2f2094800e0e30d439c30fd-d.jpg','Библиотека;Досуг;Кулинария;Соусы и специи;','1855737213,9781855737211'),(4,'Medical terminology, an illustrated guide','','','','Barbara Janson Cohen','2004','4','Lippincott Williams & Wilkins','','744',744,'English','147','Kolxo3','7','9780781762946,0781762944','','','','','','','','','OL9687191M','',300,'1','','','','','','1',12287946,'djvu','372e34d136fbf39dce00460d9e8f1f52','','','B_Biology/Medical terminology, an illustrated guide (4ed)(T)(C)(744s).djvu',0,'2009-07-20 03:45:11','2019-12-21 21:23:21','0/372e34d136fbf39dce00460d9e8f1f52.jpg','','9780781762946,0781762944'),(5,'Международная анатомическая номенклатура (Parisiana nomina anatomica)','','','','Михайлов С.С. (ред.)','1980','','Медицина','','240',240,'Latin,Russian','148','Kolxo3','7','','','','','','','','','','','',300,'','','','','1','','1',4553726,'djvu','1753c32af92fa2f8de5a62fbc3805d95','','','B_Biology/Parisiana nomina anatomica (lat,ru)(T)(240s)_B_.djvu',0,'2009-07-20 03:45:11','2019-12-22 06:23:08','000/1753c32af92fa2f8de5a62fbc3805d95-g.jpg','Биологические дисциплины;Анатомия;Словари и разговорники',''),(6,'Patterson\'s Allergic Diseases','','Allergic Diseases: Diagnosis & Management Patterson','','Leslie C. Grammer, Paul A. Greenberger','2002','Sixth','Lippincott Williams & Wilkins','','509',509,'English','151','Kolxo3','21','9780781723862,0781723868','','','','','616.97','RC584 .A34 2002','','','OL17877281M','',0,'','','','','','','1',13319483,'pdf','c086e2244ad712fe683c37c0e677b79b','','','B_Biology/Patterson\'s Allergic Diseases (6ed, 2002)(509s).pdf',0,'2009-07-20 03:45:11','2019-12-21 21:23:21','0/c086e2244ad712fe683c37c0e677b79b-d.jpg','','9780781723862,0781723868'),(7,'Poucher\'s Perfumes, Cosmetics and Soaps','','','','Hilda Butler, H. Butler','2000','10th ed.','Springer','','820',820,'English','163','Kolxo3','17','0751404799,9780751404791','','','','','668/.5','TP983 .P723 2000','','','OL3321478M','',300,'','','','','1','','1',5373090,'djvu','d0d1b36d6561f74cae2a359e8bc24777','','','B_Bi