Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.5.4.1deb2ubuntu2
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Jul 27, 2017 at 07:46 PM
- -- Server version: 5.7.19-0ubuntu0.16.04.1
- -- PHP Version: 7.0.18-0ubuntu0.16.04.1
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!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 */;
- --
- -- Database: `ISBN`
- --
- DELIMITER $$
- --
- -- Procedures
- --
- CREATE DEFINER=`root`@`%` PROCEDURE `Copy_Data_9780` () BEGIN
- INSERT IGNORE INTO `978-0XXXXXXXXX` select * from `Bookinfo` where ISBN13 like "9780%";
- delete from `Bookinfo` where ISBN13 like "9780%";
- INSERT IGNORE INTO `978-1XXXXXXXXX` select * from `Bookinfo` where ISBN13 like "9781%";
- delete from `Bookinfo` where ISBN13 like "9781%";
- INSERT IGNORE INTO `978-2XXXXXXXXX` select * from `Bookinfo` where ISBN13 like "9782%";
- delete from `Bookinfo` where ISBN13 like "9782%";
- INSERT IGNORE INTO `978-3XXXXXXXXX` select * from `Bookinfo` where ISBN13 like "9783%";
- delete from `Bookinfo` where ISBN13 like "9783%";
- INSERT IGNORE INTO `978-4XXXXXXXXX` select * from `Bookinfo` where ISBN13 like "9784%";
- delete from `Bookinfo` where ISBN13 like "9784%";
- INSERT IGNORE INTO `978-5XXXXXXXXX` select * from `Bookinfo` where ISBN13 like "9785%";
- delete from `Bookinfo` where ISBN13 like "9785%";
- INSERT IGNORE INTO `978-6XXXXXXXXX` select * from `Bookinfo` where ISBN13 like "9786%";
- delete from `Bookinfo` where ISBN13 like "9786%";
- INSERT IGNORE INTO `978-7XXXXXXXXX` select * from `Bookinfo` where ISBN13 like "9787%";
- delete from `Bookinfo` where ISBN13 like "9787%";
- INSERT IGNORE INTO `978-8XXXXXXXXX` select * from `Bookinfo` where ISBN13 like "9788%";
- delete from `Bookinfo` where ISBN13 like "9788%";
- INSERT IGNORE INTO `978-9XXXXXXXXX` select * from `Bookinfo` where ISBN13 like "9789%";
- delete from `Bookinfo` where ISBN13 like "9789%";
- END$$
- DELIMITER ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `978-0XXXXXXXXX`
- --
- CREATE TABLE `978-0XXXXXXXXX` (
- `ISBN13` varchar(13) NOT NULL,
- `BookName` varchar(255) DEFAULT NULL,
- `Author` varchar(255) DEFAULT NULL,
- `Genre` varchar(255) DEFAULT NULL,
- `ShortDescription` varchar(1024) DEFAULT NULL,
- `LongDecription` longtext,
- `Publisher` varchar(45) DEFAULT NULL,
- `Flag` tinyint(1) DEFAULT NULL,
- `PubDate` varchar(45) DEFAULT NULL,
- `inGoogle` bit(1) NOT NULL,
- `Skipped` bit(1) NOT NULL DEFAULT b'0',
- `SmallThumb` text,
- `LargeThumb` text,
- `ISBN10` char(10) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `978-1XXXXXXXXX`
- --
- CREATE TABLE `978-1XXXXXXXXX` (
- `ISBN13` varchar(13) NOT NULL,
- `BookName` varchar(255) DEFAULT NULL,
- `Author` varchar(255) DEFAULT NULL,
- `Genre` varchar(255) DEFAULT NULL,
- `ShortDescription` varchar(1024) DEFAULT NULL,
- `LongDecription` longtext,
- `Publisher` varchar(45) DEFAULT NULL,
- `Flag` tinyint(1) DEFAULT NULL,
- `PubDate` varchar(45) DEFAULT NULL,
- `inGoogle` bit(1) NOT NULL,
- `Skipped` bit(1) NOT NULL DEFAULT b'0',
- `SmallThumb` text,
- `LargeThumb` text,
- `ISBN10` char(10) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `978-2XXXXXXXXX`
- --
- CREATE TABLE `978-2XXXXXXXXX` (
- `ISBN13` varchar(13) NOT NULL,
- `BookName` varchar(255) DEFAULT NULL,
- `Author` varchar(255) DEFAULT NULL,
- `Genre` varchar(255) DEFAULT NULL,
- `ShortDescription` varchar(1024) DEFAULT NULL,
- `LongDecription` longtext,
- `Publisher` varchar(45) DEFAULT NULL,
- `Flag` tinyint(1) DEFAULT NULL,
- `PubDate` varchar(45) DEFAULT NULL,
- `inGoogle` bit(1) NOT NULL,
- `Skipped` bit(1) NOT NULL DEFAULT b'0',
- `SmallThumb` text,
- `LargeThumb` text,
- `ISBN10` char(10) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `978-3XXXXXXXXX`
- --
- CREATE TABLE `978-3XXXXXXXXX` (
- `ISBN13` varchar(13) NOT NULL,
- `BookName` varchar(255) DEFAULT NULL,
- `Author` varchar(255) DEFAULT NULL,
- `Genre` varchar(255) DEFAULT NULL,
- `ShortDescription` varchar(1024) DEFAULT NULL,
- `LongDecription` longtext,
- `Publisher` varchar(45) DEFAULT NULL,
- `Flag` tinyint(1) DEFAULT NULL,
- `PubDate` varchar(45) DEFAULT NULL,
- `inGoogle` bit(1) NOT NULL,
- `Skipped` bit(1) NOT NULL DEFAULT b'0',
- `SmallThumb` text,
- `LargeThumb` text,
- `ISBN10` char(10) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `978-4XXXXXXXXX`
- --
- CREATE TABLE `978-4XXXXXXXXX` (
- `ISBN13` varchar(13) NOT NULL,
- `BookName` varchar(255) DEFAULT NULL,
- `Author` varchar(255) DEFAULT NULL,
- `Genre` varchar(255) DEFAULT NULL,
- `ShortDescription` varchar(1024) DEFAULT NULL,
- `LongDecription` longtext,
- `Publisher` varchar(45) DEFAULT NULL,
- `Flag` tinyint(1) DEFAULT NULL,
- `PubDate` varchar(45) DEFAULT NULL,
- `inGoogle` bit(1) NOT NULL,
- `Skipped` bit(1) NOT NULL DEFAULT b'0',
- `SmallThumb` text,
- `LargeThumb` text,
- `ISBN10` char(10) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `978-5XXXXXXXXX`
- --
- CREATE TABLE `978-5XXXXXXXXX` (
- `ISBN13` varchar(13) NOT NULL,
- `BookName` varchar(255) DEFAULT NULL,
- `Author` varchar(255) DEFAULT NULL,
- `Genre` varchar(255) DEFAULT NULL,
- `ShortDescription` varchar(1024) DEFAULT NULL,
- `LongDecription` longtext,
- `Publisher` varchar(45) DEFAULT NULL,
- `Flag` tinyint(1) DEFAULT NULL,
- `PubDate` varchar(45) DEFAULT NULL,
- `inGoogle` bit(1) NOT NULL,
- `Skipped` bit(1) NOT NULL DEFAULT b'0',
- `SmallThumb` text,
- `LargeThumb` text,
- `ISBN10` char(10) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `978-6XXXXXXXXX`
- --
- CREATE TABLE `978-6XXXXXXXXX` (
- `ISBN13` varchar(13) NOT NULL,
- `BookName` varchar(255) DEFAULT NULL,
- `Author` varchar(255) DEFAULT NULL,
- `Genre` varchar(255) DEFAULT NULL,
- `ShortDescription` varchar(1024) DEFAULT NULL,
- `LongDecription` longtext,
- `Publisher` varchar(45) DEFAULT NULL,
- `Flag` tinyint(1) DEFAULT NULL,
- `PubDate` varchar(45) DEFAULT NULL,
- `inGoogle` bit(1) NOT NULL,
- `Skipped` bit(1) NOT NULL DEFAULT b'0',
- `SmallThumb` text,
- `LargeThumb` text,
- `ISBN10` char(10) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `978-7XXXXXXXXX`
- --
- CREATE TABLE `978-7XXXXXXXXX` (
- `ISBN13` varchar(13) NOT NULL,
- `BookName` varchar(255) DEFAULT NULL,
- `Author` varchar(255) DEFAULT NULL,
- `Genre` varchar(255) DEFAULT NULL,
- `ShortDescription` varchar(1024) DEFAULT NULL,
- `LongDecription` longtext,
- `Publisher` varchar(45) DEFAULT NULL,
- `Flag` tinyint(1) DEFAULT NULL,
- `PubDate` varchar(45) DEFAULT NULL,
- `inGoogle` bit(1) NOT NULL,
- `Skipped` bit(1) NOT NULL DEFAULT b'0',
- `SmallThumb` text,
- `LargeThumb` text,
- `ISBN10` char(10) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `978-8XXXXXXXXX`
- --
- CREATE TABLE `978-8XXXXXXXXX` (
- `ISBN13` varchar(13) NOT NULL,
- `BookName` varchar(255) DEFAULT NULL,
- `Author` varchar(255) DEFAULT NULL,
- `Genre` varchar(255) DEFAULT NULL,
- `ShortDescription` varchar(1024) DEFAULT NULL,
- `LongDecription` longtext,
- `Publisher` varchar(45) DEFAULT NULL,
- `Flag` tinyint(1) DEFAULT NULL,
- `PubDate` varchar(45) DEFAULT NULL,
- `inGoogle` bit(1) NOT NULL,
- `Skipped` bit(1) NOT NULL DEFAULT b'0',
- `SmallThumb` text,
- `LargeThumb` text,
- `ISBN10` char(10) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `978-9XXXXXXXXX`
- --
- CREATE TABLE `978-9XXXXXXXXX` (
- `ISBN13` varchar(13) NOT NULL,
- `BookName` varchar(255) DEFAULT NULL,
- `Author` varchar(255) DEFAULT NULL,
- `Genre` varchar(255) DEFAULT NULL,
- `ShortDescription` varchar(1024) DEFAULT NULL,
- `LongDecription` longtext,
- `Publisher` varchar(45) DEFAULT NULL,
- `Flag` tinyint(1) DEFAULT NULL,
- `PubDate` varchar(45) DEFAULT NULL,
- `inGoogle` bit(1) NOT NULL,
- `Skipped` bit(1) NOT NULL DEFAULT b'0',
- `SmallThumb` text,
- `LargeThumb` text,
- `ISBN10` char(10) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `Bookinfo`
- --
- CREATE TABLE `Bookinfo` (
- `ISBN13` varchar(13) NOT NULL,
- `BookName` varchar(255) DEFAULT NULL,
- `Author` varchar(255) DEFAULT NULL,
- `Genre` varchar(255) DEFAULT NULL,
- `ShortDescription` varchar(1024) DEFAULT NULL,
- `LongDecription` longtext,
- `Publisher` varchar(45) DEFAULT NULL,
- `Flag` tinyint(1) DEFAULT NULL,
- `PubDate` varchar(45) DEFAULT NULL,
- `inGoogle` bit(1) NOT NULL,
- `Skipped` bit(1) NOT NULL DEFAULT b'0',
- `SmallThumb` text,
- `LargeThumb` text,
- `ISBN10` char(10) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `LCCNinfo`
- --
- CREATE TABLE `LCCNinfo` (
- `LCCN` varchar(10) NOT NULL,
- `BookName` varchar(255) DEFAULT NULL,
- `Author` varchar(255) DEFAULT NULL,
- `Genre` varchar(255) DEFAULT NULL,
- `ShortDescription` varchar(1024) DEFAULT NULL,
- `LongDecription` longtext,
- `Publisher` varchar(45) DEFAULT NULL,
- `Flag` tinyint(1) DEFAULT NULL,
- `PubDate` varchar(45) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `978-0XXXXXXXXX`
- --
- ALTER TABLE `978-0XXXXXXXXX`
- ADD PRIMARY KEY (`ISBN13`),
- ADD KEY `ISBN13` (`ISBN13`);
- --
- -- Indexes for table `978-1XXXXXXXXX`
- --
- ALTER TABLE `978-1XXXXXXXXX`
- ADD PRIMARY KEY (`ISBN13`),
- ADD KEY `ISBN13` (`ISBN13`);
- --
- -- Indexes for table `978-2XXXXXXXXX`
- --
- ALTER TABLE `978-2XXXXXXXXX`
- ADD PRIMARY KEY (`ISBN13`),
- ADD KEY `ISBN13` (`ISBN13`);
- --
- -- Indexes for table `978-3XXXXXXXXX`
- --
- ALTER TABLE `978-3XXXXXXXXX`
- ADD PRIMARY KEY (`ISBN13`),
- ADD KEY `ISBN13` (`ISBN13`);
- --
- -- Indexes for table `978-4XXXXXXXXX`
- --
- ALTER TABLE `978-4XXXXXXXXX`
- ADD PRIMARY KEY (`ISBN13`),
- ADD KEY `ISBN13` (`ISBN13`);
- --
- -- Indexes for table `978-5XXXXXXXXX`
- --
- ALTER TABLE `978-5XXXXXXXXX`
- ADD PRIMARY KEY (`ISBN13`),
- ADD KEY `ISBN13` (`ISBN13`);
- --
- -- Indexes for table `978-7XXXXXXXXX`
- --
- ALTER TABLE `978-7XXXXXXXXX`
- ADD PRIMARY KEY (`ISBN13`),
- ADD KEY `ISBN13` (`ISBN13`);
- --
- -- Indexes for table `Bookinfo`
- --
- ALTER TABLE `Bookinfo`
- ADD PRIMARY KEY (`ISBN13`),
- ADD KEY `ISBN13` (`ISBN13`);
- --
- -- Indexes for table `LCCNinfo`
- --
- ALTER TABLE `LCCNinfo`
- ADD PRIMARY KEY (`LCCN`),
- ADD KEY `LCCN` (`LCCN`);
- DELIMITER $$
- --
- -- Events
- --
- CREATE DEFINER=`root`@`%` EVENT `BookShuffle` ON SCHEDULE EVERY 2 MINUTE STARTS '2017-06-26 00:00:00' ON COMPLETION PRESERVE ENABLE DO Call `Copy_Data_9780`$$
- DELIMITER ;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement