mariadb/mariadb-library.sql

raw link view readme
1 -- MySQL dump 10.16 Distrib 10.1.16-MariaDB, for Linux (x86_64)
2 --
3 -- Host: localhost Database: Library
4 -- ------------------------------------------------------
5 -- Server version 10.1.16-MariaDB
6
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40101 SET NAMES utf8 */;
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12 /*!40103 SET TIME_ZONE='+00:00' */;
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18 --
19 -- Table structure for table `Book`
20 --
21
22 DROP TABLE IF EXISTS `Book`;
23 /*!40101 SET @saved_cs_client = @@character_set_client */;
24 /*!40101 SET character_set_client = utf8 */;
25 CREATE TABLE `Book` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `editor` varchar(50) DEFAULT NULL,
28 `author` varchar(40) DEFAULT NULL,
29 `pages` int(11) DEFAULT NULL,
30 `genre` varchar(20) DEFAULT NULL,
31 `isbn` char(13) DEFAULT NULL,
32 `title` varchar(50) DEFAULT NULL,
33 `abstract` text,
34 `created` datetime DEFAULT NULL,
35 `modified` datetime DEFAULT NULL,
36 PRIMARY KEY (`id`)
37 ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;
38 /*!40101 SET character_set_client = @saved_cs_client */;
39
40 --
41 -- Dumping data for table `Book`
42 --
43
44 LOCK TABLES `Book` WRITE;
45 /*!40000 ALTER TABLE `Book` DISABLE KEYS */;
46 INSERT INTO `Book` VALUES (1,'','clout willing turf',141,'beggars','978402266905','wittingly profane goesmark oerhanging softly earne','gates assail instructs fellow','2016-08-10 04:34:50','2016-08-10 04:34:50'),(2,'','merely',345,'souls','978254488646','chopine holdst drabbing howsoever shake benetted t','smoothness entreated custom sole','2016-08-10 04:34:50','2016-08-10 04:34:50'),(3,'','nature quintessence draws',347,'palm','978241595644','like swear desire rend sings horse disasters fanta','surrender whatsoever fire curb','2016-08-10 04:34:50','2016-08-10 04:34:50'),(4,'','whensoever sconce fearsurprised',344,'amiss','978491246665','garments aim onyou rapier called habits shrivingti','russet effects said him','2016-08-10 04:34:50','2016-08-10 04:34:50'),(5,'bodkin','unmanly',251,'treason','978420609278','glares shape ungalled lifes passes reckoning tribu','faces yaughan brutus blessd','2016-08-10 04:34:50','2016-08-10 04:34:50'),(6,'synod','cannon',363,'hideous','978802989325','quietus raves pulse others call choice fierce admi','pardond commanded rashly swords','2016-08-10 04:34:50','2016-08-10 04:34:50'),(7,'','convenience naked nose',305,'least','978924969665','hart admittance judges beauties quantity pastoral ','prisonhouse wide eloquent daughtermy','2016-08-10 04:34:50','2016-08-10 04:34:50'),(8,'','core',334,'carters','978474554047','unkind king late habits whereto auntmother story s','hair utter bated lunacies','2016-08-10 04:34:50','2016-08-10 04:34:50'),(9,'','stabs distilment offends',171,'sexton','978965116936','too censure mope ladyship brings assay spring seaf','actively times turnd ere','2016-08-10 04:34:50','2016-08-10 04:34:50'),(10,'','sallets',359,'wilt','978710200035','forbid roar mockery in flushing prodigal fair unti','threats ear fine brains','2016-08-10 04:34:50','2016-08-10 04:34:50'),(11,'','will',338,'zone','978260342701','liquor easy loose numbers treads forest arithmetic','wrap tomb whiff meats','2016-08-10 04:34:50','2016-08-10 04:34:50'),(12,'','quite',141,'courtier','978476980519','bonnet order hang beguile slightly adams ignorant ','conveyance fates ban put','2016-08-10 04:34:50','2016-08-10 04:34:50'),(13,'','neptunes bisson reverted',20,'outward','978647640215','enmity notes elsinore seven homage heavens jelly h','builds instant sat inter','2016-08-10 04:34:50','2016-08-10 04:34:50'),(14,'','change',377,'thine','978463417056','walks unpregnant resolve frownd therein thick time','lack tutor ends pebbles','2016-08-10 04:34:50','2016-08-10 04:34:50'),(15,'enviously','gently',88,'reels','978853501205','uncle fat churlish breathe twas shatter mass do ma','meet rashness wicked spirit','2016-08-10 04:34:50','2016-08-10 04:34:50'),(16,'','swallowed',284,'returneth','978986876223','exact tomb nut pointenvenomd whereat confines bran','unaneld adventurous threats gaming','2016-08-10 04:34:50','2016-08-10 04:34:50'),(17,'fame','breathes',45,'encounterd','978554249523','ownself tablesmeet undertakings violets brainish r','stooping determination heroes messenger','2016-08-10 04:34:50','2016-08-10 04:34:50'),(18,'','ghosts hard hollow',105,'o','978268794126','bonds neglect exposing apart ubique danskers suppr','worser visitation tyrannous blastments','2016-08-10 04:34:50','2016-08-10 04:34:50'),(19,'','heathen remorse obeys',9,'sword','978592746014','carp cannot questionable weasel controversy wince ','call chances actions waist','2016-08-10 04:34:51','2016-08-10 04:34:51'),(20,'','bawdry pyrrhus brooch',236,'extravagant','978147173119','dearly left feed unmasterd thing sicklied spirits ','combined calves finger whereon','2016-08-10 04:34:50','2016-08-10 04:34:50'),(21,'','companions trappings define',133,'weapons','978678651450','fortified stiff innovation captain nettles brothel','prosperously fencing wishd quaintly','2016-08-10 04:34:51','2016-08-10 04:34:51'),(22,'','whored suppress stir',278,'glow','978283355176','requiem contrive strings matin flourish abstinence','rant milk best forgeries','2016-08-10 04:34:51','2016-08-10 04:34:51'),(23,'','convocation',65,'lazarlike','978536163132','infusion thy ravel unclefather gone crawling march','unseen rage untimely distemper','2016-08-10 04:34:51','2016-08-10 04:34:51'),(24,'','empty heels repentance',341,'becomes','978887823794','circumvent counter pat favourite increase die clos','crack stewd dominions stooping','2016-08-10 04:34:51','2016-08-10 04:34:51'),(25,'','winnowed',340,'venom','978676356380','chronicles thinkst prophesy whiles pastoral eterne','herein horseback oerreaches grass','2016-08-10 04:34:51','2016-08-10 04:34:51'),(26,'','ratifiers',122,'ourselves','978646685391','seeing hap sins poland hears assayd wittenberg quo','departed ours pay converted','2016-08-10 04:34:51','2016-08-10 04:34:51'),(27,'','perfume hasty prey',25,'hellish','978771909782','food tread carrying ins articles gardeners prating','half morn ever violets','2016-08-10 04:34:51','2016-08-10 04:34:51'),(28,'inter','assurance',308,'blazon','978297704316','overdone pestilence beseechd capital antiquity ser','end undertakings sty moves','2016-08-10 04:34:51','2016-08-10 04:34:51'),(29,'','cunning coted mournd',225,'feats','978567020698','did dug knees purged ononly procession be counsel ','loosed wonderwounded deckd lend','2016-08-10 04:34:51','2016-08-10 04:34:51'),(30,'','subject',80,'possess','978638973873','waves heathen shreds reckoning moan bid faded acti','young salt delve bitter','2016-08-10 04:34:51','2016-08-10 04:34:51'),(31,'exceedingly','conjunctive armour acting',87,'arms','978493332279','brief likeness unrighteous dye raised increase beh','spread truelove whose history','2016-08-10 04:34:51','2016-08-10 04:34:51'),(32,'','lies sail mope',264,'offends','978379364863','lick convert competent stayd jove seated fallingof','particular truth ugly convenience','2016-08-10 04:34:51','2016-08-10 04:34:51'),(33,'','eyes been ashamed',43,'rebels','978500596185','might sirrah conjectures tragical everlasting enem','pours hinges woodcocks grace','2016-08-10 04:34:51','2016-08-10 04:34:51'),(34,'','hic',338,'fatted','978680142825','abridgement caviare rashness mould noted knowst de','while northnorthwest heres hobbyhorse','2016-08-10 04:34:51','2016-08-10 04:34:51'),(35,'white','seven weary request',280,'bears','978351000927','restore sicklied suffered hangers pitiful turbulen','digged liest stars observers','2016-08-10 04:34:51','2016-08-10 04:34:51'),(36,'','enterprises',219,'directly','978604665773','hopes shelf levies sitting machine hue besides cle','cat itself leperous christians','2016-08-10 04:34:51','2016-08-10 04:34:51'),(37,'','same book command',223,'tempt','978271351542','twain honest rashness whereof fought drugs her sco','feeds bounds together war','2016-08-10 04:34:51','2016-08-10 04:34:51'),(38,'','table',289,'know','978454962920','bade villanous determine nickname sweep thou perso','implements tether thank faction','2016-08-10 04:34:51','2016-08-10 04:34:51'),(39,'intent','hoops',203,'struck','978377360986','observe felicity famous rests condolement depends ','silverd prayers flowers table','2016-08-10 04:34:51','2016-08-10 04:34:51'),(40,'','corpse',65,'beats','978901249187','candied even confines soyou return sparrow devices','ministers suffering tether reckon','2016-08-10 04:34:51','2016-08-10 04:34:51'),(41,'heartily','constant music imaginations',161,'harsh','978345564109','opend lady question so maimed severally debate ins','thoughts complexion orb compound','2016-08-10 04:34:51','2016-08-10 04:34:51'),(42,'','liege',359,'elsebe','978107346012','losing crash sprung buried blackest rivals tragica','poor last se bugs','2016-08-10 04:34:51','2016-08-10 04:34:51'),(43,'beetles','herod conscience swift',169,'sleep','978948040246','lends wholesome motive marriages punish scrimers w','groundlings spacious fate attend','2016-08-10 04:34:51','2016-08-10 04:34:51'),(44,'','toys',347,'city','978246951902','mischance heels cleave proclaim congruing tongues ','ape salvation round daisies','2016-08-10 04:34:51','2016-08-10 04:34:51'),(45,'','were my pox',209,'goblin','978110389100','look englands gis sblood heedful fust occurrents y','circumstances fiends called forced','2016-08-10 04:34:51','2016-08-10 04:34:51'),(46,'','strife',192,'scorns','978470033730','humble shows cry beaten lick cloak wall theres hal','headshake clutch departed fast','2016-08-10 04:34:51','2016-08-10 04:34:51'),(47,'','private',40,'cost','978398178436','offends lord ministers beggars mortised trust slee','brings contraction select t','2016-08-10 04:34:51','2016-08-10 04:34:51'),(48,'','moist scape rate',122,'shine','978934812525','elder advancement taste usthou element yoricks hai','judgments sheen avouch guard','2016-08-10 04:34:51','2016-08-10 04:34:51'),(49,'','slender hit afterwards',243,'pomp','978482404770','encounterd tarre engaged ourselves bellow escoted ','lust elsinore thinking arms','2016-08-10 04:34:51','2016-08-10 04:34:51'),(50,'','capable',371,'extorted','978306592256','profoundest breath wondrous conjoind lord defeats ','tanned cousin at dreaded','2016-08-10 04:34:51','2016-08-10 04:34:51'),(51,'','tutor',127,'looks','978632749662','regard holds moons remember relative buffets blank','us breath theatre numbers','2016-08-10 04:34:51','2016-08-10 04:34:51'),(52,'','calmly full device',47,'napkin','978783902862','tongues certainty hadst lions circumvent hum vile ','little equal perfume habit','2016-08-10 04:34:51','2016-08-10 04:34:51'),(53,'','marble couple rags',78,'circumscribed','978338355255','fruits boughs seems tropically befitted cataplasm ','pate damnable borrower israel','2016-08-10 04:34:51','2016-08-10 04:34:51'),(54,'','burnt clambering fencing',91,'loose','978983747637','validity grained pit thereto crows ift hideous min','utterd acursing because uncurrent','2016-08-10 04:34:51','2016-08-10 04:34:51'),(55,'','blown conquest grieved',58,'whole','978127102670','gentlewoman growing holding pleasant tricks reques','sayst hoar c unripe','2016-08-10 04:34:51','2016-08-10 04:34:51'),(56,'','doubtful',398,'implorators','978230888099','rights fardels hast ononly spring reckon allowd wr','coronation stomach bold window','2016-08-10 04:34:51','2016-08-10 04:34:51'),(57,'','botch sprinkle perfections',132,'love','978243664471','pox scarfd stronger apparel allow film verity stre','husbandry enmity beaten lockd','2016-08-10 04:34:51','2016-08-10 04:34:51'),(58,'','dig',250,'pranks','978515472809','weigh harmony kneels necessary enterprise basket w','toils freely nobility coming','2016-08-10 04:34:51','2016-08-10 04:34:51'),(59,'narrow','warlike request objects',46,'howeer','978190498237','along give couched forged niobe pronounce unnerved','works yond man deathbed','2016-08-10 04:34:51','2016-08-10 04:34:51'),(60,'','cannoneer paint box',389,'parchment','978238435732','loud ratifiers softly voice fennel aimd thanks she','horse taints begin fiction','2016-08-10 04:34:51','2016-08-10 04:34:51'),(61,'proverb','manners',120,'an','978542210560','inch proceeding flowers speechless own sister turb','trip fate pressures baseness','2016-08-10 04:34:51','2016-08-10 04:34:51'),(62,'','cries',153,'smooth','978605517547','estimation weed roar bounded monstrous things moun','sith perilous dearth backed','2016-08-10 04:34:51','2016-08-10 04:34:51'),(63,'','julius shreds turk',4,'moved','978605214196','avoid rites bevy fordo shocks pay thieves unfold o','lesson sterile lost nose','2016-08-10 04:34:51','2016-08-10 04:34:51'),(64,'','uneffectual peevish branches',323,'chide','978921841549','perdy steward reasons gambol lo womb breathes mode','enactures but demands pangs','2016-08-10 04:34:51','2016-08-10 04:34:51'),(65,'','preaching exposing pastoral',341,'strength','978599965231','abused mirror tetter walk begun lack quiet shuffli','waves pleased mystery kingly','2016-08-10 04:34:51','2016-08-10 04:34:51'),(66,'yonder','skyish able knocking',58,'acting','978800053184','estimation borrowd upspring last blow bore conveni','valenced ingenious none usurp','2016-08-10 04:34:51','2016-08-10 04:34:51'),(67,'','commended',230,'caught','978887560736','fares search individable understand blow remove bl','condolement basket grieved partisan','2016-08-10 04:34:51','2016-08-10 04:34:51'),(68,'','general',196,'deep','978260787479','like incestuous tropically bounded godamercy utter','stamp axe replies find','2016-08-10 04:34:51','2016-08-10 04:34:51'),(69,'doomsday','attendants oppressors goblin',150,'orb','978338549106','get perdition report motion ive patiently haunt to','divide commands odd stones','2016-08-10 04:34:51','2016-08-10 04:34:51'),(70,'','timberd',267,'weep','978570074249','windy oerhanging strewd ban affliction heed christ','infants goodly swore paradox','2016-08-10 04:34:51','2016-08-10 04:34:51'),(71,'','child fast rebels',29,'napkin','978409129869','tender hectic observation poisons scrimers alls he','lodged babe interim figure','2016-08-10 04:34:51','2016-08-10 04:34:51'),(72,'','past flat metal',38,'slight','978696555809','haunt nave lead impotent huggermugger dearest prov','betimes means heavily runs','2016-08-10 04:34:51','2016-08-10 04:34:51'),(73,'','blench frowningly rain',375,'bedrid','978725630158','matters visit fearing unfledged poor spheres belie','minute occasion expressd palmy','2016-08-10 04:34:51','2016-08-10 04:34:51'),(74,'remedy','fashion',214,'thereto','978433646171','reading ecstasy fencing hurt seemd my judgment oer','sons duties barren sayst','2016-08-10 04:34:51','2016-08-10 04:34:51'),(75,'joy','instance',23,'levies','978950142462','west safe garlands guards rend weapon legs moor ho','sure woman instrument varnish','2016-08-10 04:34:51','2016-08-10 04:34:51'),(76,'capitol','appointment',294,'trumpets','978990151465','cleft glean acursing sultry world addicted impart ','followed beshrew crawling herself','2016-08-10 04:34:51','2016-08-10 04:34:51'),(77,'mirth','unpack muddied unshaken',244,'springes','978968228730','hasten whether satisfaction abroad army inky prett','exposing office ventages tenures','2016-08-10 04:34:51','2016-08-10 04:34:51'),(78,'','avoid faculties enemies',292,'dignity','978313461547','roughly feature strikes actively stirring frame co','heavy moan foils gaingiving','2016-08-10 04:34:51','2016-08-10 04:34:51'),(79,'','marriagevows sulphurous glass',15,'already','978143705171','dish sticks imagine abroad crafts colour she aspec','contrive due fortunes wretch','2016-08-10 04:34:51','2016-08-10 04:34:51'),(80,'converted','times',275,'officers','978144004606','bounds distance revenge courteous core designd gen','towncrier dish dicers ownself','2016-08-10 04:34:51','2016-08-10 04:34:51'),(81,'sale','tenable spade wiseness',354,'drab','978725571766','royally intent brains thereto ophelia ripe tush de','babe tanned only power','2016-08-10 04:34:51','2016-08-10 04:34:51'),(82,'','west',246,'roughhew','978331833224','merry guarded turn vast designd matters slander be','host beck cheerfully recount','2016-08-10 04:34:51','2016-08-10 04:34:51'),(83,'hours','smelt',32,'off','978795287456','wasas sisters unschoold edge int straight ugly see','precisely skull treason paid','2016-08-10 04:34:51','2016-08-10 04:34:51'),(84,'oer','varnish',105,'our','978264105923','courtiers sings beloved instant choose watchman fo','airs creation nine batten','2016-08-10 04:34:51','2016-08-10 04:34:51'),(85,'painted','wittenberg access sober',207,'prenominate','978205981254','indued hasty welcome we acting demanded countrymen','unprofitable beloved wear lawyer','2016-08-10 04:34:51','2016-08-10 04:34:51'),(86,'which','refrain',127,'account','978198317223','liege couple revel pardont art byr wood different ','snatches market indifferent rests','2016-08-10 04:34:51','2016-08-10 04:34:51'),(87,'','garrisond party gilded',354,'brood','978916871734','lost mixture humourous olympus artery soft wanton ','wit encounter conveyances prepare','2016-08-10 04:34:51','2016-08-10 04:34:51'),(88,'','poem commerce paper',128,'laying','978708011974','double bated margent advise falsehood beetles cart','rome ope weighd singeing','2016-08-10 04:34:51','2016-08-10 04:34:51'),(89,'','finds',298,'distraction','978517845725','womens thus ills asked saviours bring bade knowest','ladies hamlet encumberd understanding','2016-08-10 04:34:51','2016-08-10 04:34:51'),(90,'','coward sale hill',246,'foil','978328665164','your shown schoolfellows towncrier torrent swift d','rises trade individable bloody','2016-08-10 04:34:51','2016-08-10 04:34:51'),(91,'passion','phoebus abuses dire',210,'adheres','978590935566','not havoc tragedians rareness render unmatchd pola','touchd height monsters princes','2016-08-10 04:34:51','2016-08-10 04:34:51'),(92,'','chapless',313,'niggard','978235951358','equal due juggled heir patience trust unequal besi','cease grew engineer buyer','2016-08-10 04:34:51','2016-08-10 04:34:51'),(93,'','due',69,'element','978637669798','chapless heartache godlike shift em apparel unskil','lordship dews offal wormwood','2016-08-10 04:34:51','2016-08-10 04:34:51'),(94,'darkest','courteous timeid no',128,'simples','978190247439','blasted fear able sharp affrighted stately concern','nickname courtesy partial eyases','2016-08-10 04:34:51','2016-08-10 04:34:51'),(95,'','credent',186,'station','978821331827','roars circumstances tatters fed behind satyr waxes','milch woot salvation slaughter','2016-08-10 04:34:51','2016-08-10 04:34:51'),(96,'','spokes',313,'hillo','978591569907','star smart excellence on tend calm travel sense th','dies interim circumstance prey','2016-08-10 04:34:51','2016-08-10 04:34:51'),(97,'','rood',227,'wholesome','978717204433','wed suffers pyrrhus sadly pastoral four quillets p','crown difference undertake stiff','2016-08-10 04:34:51','2016-08-10 04:34:51'),(98,'','witness',41,'right','978391672358','head sultry drink mountains daughters assured barr','ills comma hunts virtue','2016-08-10 04:34:51','2016-08-10 04:34:51'),(99,'','abatements mousetrap shoe',49,'sure','978501416445','fiends dexterity start longermarried ten bewept ne','enactures babe then influence','2016-08-10 04:34:51','2016-08-10 04:34:51'),(100,'purpose','recover box dragging',302,'sole','978343535187','bloat friendship hair combat succession gardeners ','beaver feel bleed held','2016-08-10 04:34:51','2016-08-10 04:34:51');
47 /*!40000 ALTER TABLE `Book` ENABLE KEYS */;
48 UNLOCK TABLES;
49 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
50
51 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
52 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
53 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
54 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
55 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
56 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
57 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
58
59 -- Dump completed on 2016-08-10 6:23:47
60
61
62
63
64