/*
SQLyog Community Edition- MySQL GUI v6.0 Beta 4 
Host - 5.0.51a-community-nt : Database - sakila
*********************************************************************
Server version : 5.0.51a-community-nt
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `actor` */

DROP TABLE IF EXISTS `actor`;

CREATE TABLE `actor` (
  `actor_id` smallint(5) unsigned NOT NULL auto_increment,
  `first_name` varchar(45) NOT NULL,
  `last_name` varchar(45) NOT NULL,
  `last_update` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`actor_id`),
  KEY `idx_actor_last_name` (`last_name`)
) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=utf8;

/*Data for the table `actor` */

insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (1,'Nicolas','nico','2006-02-15 05:03:42');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (2,'NICK','WAHLBERG','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (3,'ED','CHASE','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (4,'JENNIFER','DAVIS','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (5,'JOHNNY','LOLLOBRIGIDA','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (6,'BETTE','NICHOLSON','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (7,'GRACE','MOSTEL','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (8,'MATTHEW','JOHANSSON','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (9,'JOE','SWANK','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (10,'CHRISTIAN','GABLE','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (11,'ZERO','CAGE','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (12,'KARL','BERRY','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (13,'UMA','WOOD','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (14,'VIVIEN','BERGEN','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (15,'CUBA','OLIVIER','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (16,'FRED','COSTNER','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (17,'HELEN','VOIGHT','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (18,'DAN','TORN','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (19,'BOB','FAWCETT','2006-02-15 04:34:33');
insert  into `actor`(`actor_id`,`first_name`,`last_name`,`last_update`) values (20,'LUCILLE','TRACY','2006-02-15 04:34:33');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
