| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/MichaelMalz/CST1600/Resources/bookinfo.sql/ |
Upload File : |
-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 21, 2010 at 05:08 AM
-- Server version: 5.1.36
-- PHP Version: 5.3.0
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `bookinfo`
--
-- --------------------------------------------------------
CREATE DATABASE /*!32312 IF NOT EXISTS*/`bookinfo` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `bookinfo`;
--
-- Table structure for table `author`
--
CREATE TABLE IF NOT EXISTS `author` (
`aut_id` varchar(8) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`aut_name` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`country` varchar(25) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`home_city` varchar(25) COLLATE latin1_general_ci NOT NULL DEFAULT '',
PRIMARY KEY (`aut_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `author`
--
INSERT INTO `author` (`aut_id`, `aut_name`, `country`, `home_city`) VALUES
('AUT001', 'William Norton', 'UK', 'Cambridge'),
('AUT002', 'William Maugham', 'Canada', 'Toronto'),
('AUT003', 'William Anthony', 'UK', 'Leeds'),
('AUT004', 'S.B.Swaminathan', 'India', 'Bangalore'),
('AUT005', 'Thomas Morgan', 'Germany', 'Arnsberg'),
('AUT006', 'Thomas Merton', 'USA', 'New York'),
('AUT007', 'Piers Gibson', 'UK', 'London'),
('AUT008', 'Nikolai Dewey', 'USA', 'Atlanta'),
('AUT009', 'Marquis de Ellis', 'Brazil', 'Rio De Janerio'),
('AUT010', 'Joseph Milton', 'USA', 'Houston'),
('AUT011', 'John Betjeman Hunter', 'Australia', 'Sydney'),
('AUT012', 'Evan Hayek', 'Canada', 'Vancouver'),
('AUT013', 'E. Howard', 'Australia', 'Adelaide'),
('AUT014', 'C. J. Wilde', 'UK', 'London'),
('AUT015', 'Butler Andre', 'USA', 'Florida');
-- --------------------------------------------------------
--
-- Table structure for table `book_mast`
--
CREATE TABLE IF NOT EXISTS `book_mast` (
`book_id` varchar(15) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`book_name` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`isbn_no` varchar(15) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`cate_id` varchar(8) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`aut_id` varchar(8) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`pub_id` varchar(8) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`dt_of_pub` date NOT NULL DEFAULT '0000-00-00',
`pub_lang` varchar(15) COLLATE latin1_general_ci DEFAULT NULL,
`no_page` decimal(5,0) NOT NULL DEFAULT '0',
`book_price` decimal(8,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`book_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `book_mast`
--
INSERT INTO `book_mast` (`book_id`, `book_name`, `isbn_no`, `cate_id`, `aut_id`, `pub_id`, `dt_of_pub`, `pub_lang`, `no_page`, `book_price`) VALUES
('BK001', 'Introduction to Electrodynamics', '0000979001', 'CA001', 'AUT001', 'P003', '2001-05-08', 'English', '201', '85.00'),
('BK002', 'Understanding of Steel Construction', '0000979002', 'CA002', 'AUT002', 'P001', '2003-07-15', 'English', '300', '105.50'),
('BK003', 'Guide to Networking', '0000979003', 'CA003', 'AUT003', 'P002', '2002-09-10', 'Hindi', '510', '200.00'),
('BK004', 'Transfer of Heat and Mass', '0000979004', 'CA002', 'AUT004', 'P004', '2004-02-16', 'English', '600', '250.00'),
('BK005', 'Conceptual Physics', '0000979005', 'CA001', 'AUT005', 'P006', '2003-07-16', NULL, '345', '145.00'),
('BK006', 'Fundamentals of Heat', '0000979006', 'CA001', 'AUT006', 'P005', '2003-08-10', 'German', '247', '112.00'),
('BK007', 'Advanced 3d Graphics', '0000979007', 'CA003', 'AUT007', 'P002', '2004-02-16', 'Hindi', '165', '56.00'),
('BK008', 'Human Anatomy', '0000979008', 'CA005', 'AUT008', 'P006', '2001-05-17', 'German', '88', '50.50'),
('BK009', 'Mental Health Nursing', '0000979009', 'CA005', 'AUT009', 'P007', '2004-02-10', 'English', '350', '145.00'),
('BK010', 'Fundamentals of Thermodynamics', '0000979010', 'CA002', 'AUT010', 'P007', '2002-10-14', 'English', '400', '225.00'),
('BK011', 'The Experimental Analysis of Cat', '0000979011', 'CA004', 'AUT011', 'P005', '2007-06-09', 'French', '225', '95.00'),
('BK012', 'The Nature of World', '0000979012', 'CA004', 'AUT005', 'P008', '2005-12-20', 'English', '350', '88.00'),
('BK013', 'Environment a Sustainable Future', '0000979013', 'CA004', 'AUT012', 'P001', '2003-10-27', 'German', '165', '100.00'),
('BK014', 'Concepts in Health', '0000979014', 'CA005', 'AUT013', 'P004', '2001-08-25', NULL, '320', '180.00'),
('BK015', 'Anatomy & Physiology', '0000979015', 'CA005', 'AUT014', 'P008', '2000-10-10', 'Hindi', '225', '135.00'),
('BK016', 'Networks and Telecommunications', '00009790_16', 'CA003', 'AUT015', 'P003', '2002-01-01', 'French', '95', '45.00');
-- --------------------------------------------------------
--
-- Table structure for table `category`
--
CREATE TABLE IF NOT EXISTS `category` (
`cate_id` varchar(8) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`cate_descrip` varchar(25) COLLATE latin1_general_ci NOT NULL DEFAULT '',
PRIMARY KEY (`cate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `category`
--
INSERT INTO `category` (`cate_id`, `cate_descrip`) VALUES
('CA001', 'Science'),
('CA002', 'Technology'),
('CA003', 'Computers'),
('CA004', 'Nature'),
('CA005', 'Medical');
-- --------------------------------------------------------
--
-- Table structure for table `despatch`
--
CREATE TABLE IF NOT EXISTS `despatch` (
`desp_no` varchar(8) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`desp_data` date NOT NULL DEFAULT '0000-00-00',
`client_city` varchar(15) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`client_country` varchar(15) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`book_id` varchar(8) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`aut_id` varchar(8) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`no_of_copy` int NOT NULL DEFAULT '0',
`sell_price` decimal(12,2) NOT NULL DEFAULT '0.00',
`disc_per` decimal(5,2) NOT NULL DEFAULT '0.00',
`total_cost` decimal(12,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`desp_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `despatch`
--
-- --------------------------------------------------------
--
-- Table structure for table `newpublisher`
--
CREATE TABLE IF NOT EXISTS `newpublisher` (
`pub_id` varchar(8) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`pub_name` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`pub_city` varchar(25) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`country` varchar(25) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`country_office` varchar(25) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`no_of_branch` int DEFAULT '0',
`estd` date DEFAULT '0000-00-00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `newpublisher`
--
INSERT INTO `newpublisher` (`pub_id`, `pub_name`, `pub_city`, `country`, `country_office`, `no_of_branch`, `estd`) VALUES
('P001', 'Jex Max Publication', 'New York', 'USA', 'New York', 15, '1969-12-25'),
('P002', 'BPP Publication', 'Mumbai', 'India', 'New Delhi', 10, '1985-10-01'),
('P003', 'New Harrold Publication', 'Adelaide', 'Australia', 'Sydney', 6, NULL),
('P004', 'Ultra Press Inc.', 'London', 'UK', 'London', 8, '1948-07-10'),
('P005', 'Mountain Publication', 'Houstan', 'USA', 'Sun Diego', 25, NULL),
('P006', 'Summer Night Publication', 'New York', 'USA', 'Atlanta', 10, '1990-12-10'),
('P007', 'Pieterson Grp. of Publishers', 'Cambridge', 'UK', 'London', 6, NULL),
('P008', 'Novel Publisher Ltd.', 'New Delhi', 'India', 'Bangalore', 10, '2000-01-01'),
('a001', 'This pub name was corrupted', ' ', ' ', ' ', 5, '2000-01-01');
-- --------------------------------------------------------
--
-- Table structure for table `order`
--
CREATE TABLE IF NOT EXISTS `order` (
`ord_no` varchar(15) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`ord_date` date NOT NULL DEFAULT '0000-00-00',
`book_id` varchar(15) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`book_name` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`cate_id` varchar(8) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`pub_lang` varchar(15) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`ord_qty` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ord_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `order`
--
-- --------------------------------------------------------
--
-- Table structure for table `publisher`
--
CREATE TABLE IF NOT EXISTS `publisher` (
`pub_id` varchar(8) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`pub_name` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`pub_city` varchar(25) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`country` varchar(25) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`country_office` varchar(25) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`no_of_branch` int NOT NULL DEFAULT '0',
`estd` date NOT NULL DEFAULT '0000-00-00',
PRIMARY KEY (`pub_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `publisher`
--
INSERT INTO `publisher` (`pub_id`, `pub_name`, `pub_city`, `country`, `country_office`, `no_of_branch`, `estd`) VALUES
('P001', 'Jex Max Publication', 'New York', 'USA', 'New York', 15, '1969-12-25'),
('P002', 'BPP Publication', 'Mumbai', 'India', 'New Delhi', 10, '1985-10-01'),
('P003', 'New Harrold Publication', 'Adelaide', 'Australia', 'Sydney', 6, '1975-09-05'),
('P004', 'Ultra Press Inc.', 'London', 'UK', 'London', 8, '1948-07-10'),
('P005', 'Mountain Publication', 'Houstan', 'USA', 'Sun Diego', 25, '1975-01-01'),
('P006', 'Summer Night Publication', 'New York', 'USA', 'Atlanta', 10, '1990-12-10'),
('P007', 'Pieterson Grp. of Publishers', 'Cambridge', 'UK', 'London', 6, '1950-07-15'),
('P008', 'Novel Publisher Ltd.', 'New Delhi', 'India', 'Bangalore', 10, '2000-01-01');
-- --------------------------------------------------------
--
-- Table structure for table `purchase`
--
CREATE TABLE IF NOT EXISTS `purchase` (
`invoice_no` varchar(12) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`invoice_dt` date NOT NULL DEFAULT '0000-00-00',
`ord_no` varchar(25) COLLATE latin1_general_ci NOT NULL,
`ord_date` date NOT NULL DEFAULT '0000-00-00',
`receive_dt` date NOT NULL DEFAULT '0000-00-00',
`book_id` varchar(8) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`book_name` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`pub_lang` varchar(8) COLLATE latin1_general_ci DEFAULT NULL,
`cate_id` varchar(8) COLLATE latin1_general_ci DEFAULT NULL,
`receive_qty` int NOT NULL DEFAULT '0',
`purch_price` decimal(12,2) NOT NULL DEFAULT '0.00',
`total_cost` decimal(12,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`invoice_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `purchase`
--
INSERT INTO `purchase` (`invoice_no`, `invoice_dt`, `ord_no`, `ord_date`, `receive_dt`, `book_id`, `book_name`, `pub_lang`, `cate_id`, `receive_qty`, `purch_price`, `total_cost`) VALUES
('INV0001', '2008-07-15', 'ORD/08-09/0001', '2008-07-06', '2008-07-19', 'BK001', 'Introduction to Electrodynamics', 'English', 'CA001', 15, '75.00', '1125.00'),
('INV0002', '2008-08-25', 'ORD/08-09/0002', '2008-08-09', '2008-08-28', 'BK004', 'Transfer of Heat and Mass', 'English', 'CA002', 8, '55.00', '440.00'),
('INV0003', '2008-09-20', 'ORD/08-09/0003', '2008-09-15', '2008-09-23', 'BK005', 'Conceptual Physics', NULL, 'CA001', 20, '20.00', '400.00'),
('INV0004', '2007-08-30', 'ORD/07-08/0005', '2007-08-22', '2007-08-30', 'BK004', 'Transfer of Heat and Mass', 'English', 'CA002', 15, '35.00', '525.00'),
('INV0005', '2007-07-28', 'ORD/07-08/0004', '2007-06-25', '2007-07-30', 'BK001', 'Introduction to Electrodynamics', 'English', 'CA001', 8, '25.00', '200.00'),
('INV0006', '2007-09-24', 'ORD/07-08/0007', '2007-09-20', '2007-09-30', 'BK003', 'Guide to Networking', 'Hindi', 'CA003', 20, '45.00', '900.00');
-- --------------------------------------------------------
--
-- Table structure for table `testtable`
--
CREATE TABLE IF NOT EXISTS `testtable` (
`description` varchar(25) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `testtable`
--
INSERT INTO `testtable` (`description`) VALUES
('Description 1'),
('Description 2'),
('Description 3');