CREATE TABLE `blog_post` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `body` text,
  `date` datetime default NULL,
  PRIMARY KEY  (`id`)
) AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;


INSERT INTO `blog_post` (id,title,body,date) VALUES (1,'Hello','Hello World','2011-08-23 00:00:00');
INSERT INTO `blog_post` (id,title,body,date) VALUES (4,'Truth about this world','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam feugiat malesuada nulla vitae porta. Ut massa diam, congue sit amet gravida in, scelerisque sed neque. Morbi dolor mi, gravida et adipiscing condimentum, condimentum eget arcu. In dui dui, dignissim at pretium adipiscing, tempus sed est. Nulla convallis fermentum justo, in suscipit risus ultricies malesuada. Ut vitae massa sit amet felis imperdiet congue et eget neque. Quisque ac orci ligula, sed ullamcorper magna. Sed quis velit ipsum, eget fringilla mauris. Nulla tempus viverra elementum. Mauris commodo, nibh sit amet lobortis lacinia, urna erat facilisis neque, vitae commodo elit libero nec arcu. Proin molestie laoreet viverra. Proin tincidunt odio et lacus condimentum convallis. Praesent ac imperdiet magna. Integer tempor, turpis quis ornare fringilla, purus purus blandit justo, vitae egestas ante leo sollicitudin felis. In felis dolor, fermentum eu posuere quis, vestibulum id tellus. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Vestibulum ut eros id orci consectetur fringilla a sed ante. Maecenas sit amet vulputate risus. Curabitur dignissim tempor nisi eget faucibus. Curabitur a est tellus, ac tempor lectus. Integer fermentum pellentesque eros, in consequat lorem tempor molestie. Vivamus iaculis, lectus vel aliquam faucibus, quam justo lobortis tortor, non lobortis nisl quam a neque. Sed sollicitudin, felis nec luctus eleifend, arcu orci lacinia sapien, id blandit quam neque commodo diam. Donec ante nunc, viverra a placerat vel, pretium in tortor. Mauris porttitor tincidunt libero, rhoncus aliquet sem laoreet sit amet. Vivamus tincidunt, orci nec gravida pulvinar, enim ligula tempor est, et vestibulum turpis leo eget dolor.

Donec erat mi, porta quis ultrices at, dignissim id ante. Mauris sed sem at ante sollicitudin tincidunt vel id sapien. Vestibulum pellentesque sagittis odio et semper. Duis eu accumsan magna. Praesent euismod aliquam nisl, in tristique dolor elementum molestie. Aenean fermentum quam malesuada libero pellentesque id aliquam dolor volutpat. Aliquam erat volutpat. Proin consectetur nulla sed libero laoreet eleifend. Pellentesque quis tellus pellentesque massa interdum euismod. Praesent sed nibh nunc. Morbi rutrum tincidunt risus, porta lobortis lorem volutpat id. Etiam pharetra, ipsum sed rhoncus volutpat, purus erat mattis magna, nec consectetur lorem ipsum in odio. Sed vel urna felis, at vehicula nunc. Cras ac tellus metus. Vestibulum cursus vehicula odio, quis sagittis ligula faucibus in.','2011-07-13 00:00:00');
INSERT INTO `blog_post` (id,title,body,date) VALUES (5,'Introducing "V"','Voilà! In view, a humble vaudevillian veteran, cast vicariously as both victim and villain by the vicissitudes of fate. This visage, no mere veneer of vanity, is a vestige of the vox populi, now vacant, vanished. However, this valorous visitation of a bygone vexation stands vivified, and has vowed to vanquish these venal and virulent vermin vanguarding vice and vouchsafing the violently vicious and voracious violation of volition! The only verdict is vengeance; a vendetta held as a votive, not in vain, for the value and veracity of such shall one day vindicate the vigilant and the virtuous. Verily, this vichyssoise of verbiage veers most verbose, so let me simply add that it''s my very good honour to meet you and you may call me V.','2011-09-05 00:00:00');
INSERT INTO `blog_post` (id,title,body,date) VALUES (6,'Some dummy legal text here','This product is meant for educational purposes only. Any resemblance to real persons, living or dead is purely coincidental. Void where prohibited. Some assembly required. List each check separately by bank number. Batteries not included.

Contents may settle during shipment. Use only as directed. No other warranty expressed or implied. Do not use while operating a motor vehicle or heavy equipment. Postage will be paid by addressee. Subject to CARB approval.

This is not an offer to sell securities. Apply only to affected area. May be too intense for some viewers. Do not stamp. Not rated by the Motion Picture Association of America. Call for nutritional information. Use other side for additional listings.

Printed on recycled paper. For recreational use only. Do not disturb. All models over 18 years of age. Prize not redeemable for cash value. If condition persists, consult your physician. No user-serviceable parts inside. Freshest if eaten before date on carton.

To be used as a supplementary restraint system only. Always fasten your safety belt. Subject to change without notice. Times approximate. Simulated picture. Do not staple or paper clip. Price slightly higher east of Alaska. No postage necessary if mailed in the United States.

Do not X-ray. Breaking seal constitutes acceptance of agreement. For off-road use only. As seen on TV. One size fits all. Many suitcases look alike. Contains a substantial amount of non-tobacco ingredients. Colors may, in time, fade.

We have sent the forms which seem right for you. Magnetic media, non-returnable if seal is broken. Formatted to fit your screen. Slippery when wet. For office use only. Not affiliated with the American Red Cross. Drop in any mailbox. Edited for television.

Keep cool, process promptly. Post office will not deliver without postage. List was current at time of printing. Return to sender, no forwarding order on file, unable to forward. Prolong exposure to vapors has caused cancer in laboratory animals.

Not responsible for direct, indirect, incidental or consequential damages resulting from any defect, error or failure to perform. Keep away from children. At participating locations only. Not the Beatles. Penalty for private use. See label for sequence.

Substantial penalty for early withdrawal. Do not write below this line. Falling rock. Lost ticket pays maximum rate. Phenylketonurics: contains phenylalnine. Your canceled check is your receipt. Add toner. Place stamp here.

Use only as directed; intentional misuse by deliberately concentrating and inhaling contents can be harmful or fatal. Avoid contact with skin. Road construction ahead. Open other end. Dealer participation may affect final price.

May not be present in all tap water. Sanitized for your protection. Be sure each item is properly endorsed. Sign here without admitting guilt. Slightly higher west of the Mississippi. Park at your own risk. Employees and their families and friends are not eligible. Beware of dog. 

Contestants have been briefed on some questions before the show. Limited time offer, call now to ensure prompt delivery. You must be present to win. No passes accepted for this engagement. No purchase necessary. Processed at location stamped in code at top of carton. Shading within a garment may occur. Keep away from fire or flames. See Uniform Code of Military Justice. Replace with same type. Approved for veterans. Booths for two or more. Indicates a low-fat item. Check here if tax deductible. Some equipment shown is optional.
Price does not include taxes. No Canadian coins. Tax, tag, and title not included in advertised price. Not recommended for children. Prerecorded for this time zone. Reproduction by mechanical or electronic means, including photocopying, is strictly prohibited.

No solicitors. No alcohol, dogs or horses. No anchovies unless otherwise specified. Avoid spraying into eyes. An 18% gratuity will be added for parties of 8 or more. Do not write under this line.','2011-09-12 00:00:00');
CREATE TABLE `movie` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  `imdb` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
);
INSERT INTO `movie` VALUES 
    (1,'V for Vendetta',2006,'http://www.imdb.com/title/tt0434409/'),
    (2,'The Matrix',1999,'http://www.imdb.com/title/tt0133093/'),
    (3,'WALL-E',2008,'http://www.imdb.com/title/tt0910970/');

CREATE TABLE `dvd` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `movie_id` int(11) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `dvd` VALUES
    (1,2,'20397728'),
    (2,1,'20397729'),
    (3,1,'20397730');

CREATE TABLE `customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `customer` VALUES 
    (1,'John Smith'),
    (2,'Peter Taylor');

CREATE TABLE `rental` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) DEFAULT NULL,
  `dvd_id` int(11) DEFAULT NULL,
  `date_rented` varchar(255) DEFAULT NULL,
  `date_returned` varchar(255) DEFAULT NULL,
  `is_returned` enum('Y','N') DEFAULT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `rental` VALUES 
    (1,1,1,'2011-08-21','','N'),
    (2,1,2,'2011-08-18','2011-08-21','Y');

alter table customer add email varchar(255);
alter table customer add password varchar(255);
