-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 18, 2010 at 09:30 AM
-- Server version: 5.1.41
-- PHP Version: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 utf8 */;

--
-- Database: `book_store2`
--

-- --------------------------------------------------------

--
-- Table structure for table `author`
--

CREATE TABLE IF NOT EXISTS `author` (
  `id_author` int(5) NOT NULL AUTO_INCREMENT,
  `author` varchar(255) NOT NULL,
  PRIMARY KEY (`id_author`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `author`
--

INSERT INTO `author` (`id_author`, `author`) VALUES
(1, 'Auth1'),
(2, 'Auth2');

-- --------------------------------------------------------

--
-- Table structure for table `author_to_book`
--

CREATE TABLE IF NOT EXISTS `author_to_book` (
  `id_atb` int(5) NOT NULL,
  `id_bta` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `author_to_book`
--

INSERT INTO `author_to_book` (`id_atb`, `id_bta`) VALUES
(1, 1),
(2, 2),
(2, 1),
(1, 2);

-- --------------------------------------------------------

--
-- Table structure for table `books`
--

CREATE TABLE IF NOT EXISTS `books` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `desc` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `books`
--

INSERT INTO `books` (`id`, `title`, `price`, `desc`) VALUES
(1, 'Book1', '0.00', NULL),
(2, 'Book2', '0.00', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `ganre`
--

CREATE TABLE IF NOT EXISTS `ganre` (
  `id_ganre` int(5) NOT NULL AUTO_INCREMENT,
  `ganre` varchar(255) NOT NULL,
  PRIMARY KEY (`id_ganre`),
  FULLTEXT KEY `genre` (`ganre`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `ganre`
--

INSERT INTO `ganre` (`id_ganre`, `ganre`) VALUES
(1, 'Ganre1'),
(2, 'Ganre2');

-- --------------------------------------------------------

--
-- Table structure for table `ganre_to_book`
--

CREATE TABLE IF NOT EXISTS `ganre_to_book` (
  `id_gtb` int(5) NOT NULL,
  `id_btg` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ganre_to_book`
--

INSERT INTO `ganre_to_book` (`id_gtb`, `id_btg`) VALUES
(1, 1),
(2, 2),
(2, 1);

/*!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 */;
