Database Reference
In-Depth Information
--
-- Database: `marc_book`
--
-- --------------------------------------------------------
--
-- Table structure for table `author`
--
CREATE TABLE IF NOT EXISTS `author` (
`id` int(11) NOT NULL,
`name` varchar(30) NOT NULL,
`phone` varchar(30) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `author`
--
INSERT INTO `author` (`id`, `name`, `phone`) VALUES(1, 'John Smith',
'+01 445-789-1234');
INSERT INTO `author` (`id`, `name`, `phone`) VALUES(2, 'Maria
Sunshine', '333-3333');
-- --------------------------------------------------------
--
-- Table structure for table `book`
--
CREATE TABLE IF NOT EXISTS `book` (
`isbn` varchar(25) NOT NULL,
`title` varchar(100) NOT NULL,
`page_count` int(11) NOT NULL,
`author_id` int(11) NOT NULL,
`language` char(2) NOT NULL default 'en',
`description` text NOT NULL,
`cover_photo` blob NOT NULL,
`genre` set('Fantasy','Child','Novel') NOT NULL default 'Fantasy',
`date_published` datetime NOT NULL,
`stamp` timestamp NOT NULL default '0000-00-00 00:00:00' on update
CURRENT_TIMESTAMP,
Search WWH ::
Custom Search