Author: mhillyer
Date: 2006-03-01 19:44:09 +0100 (Wed, 01 Mar 2006)
New Revision: 1476
Log:
Document Bugfixes: 9630,9631,9633,10801,10911,10924,10925,10926,10930,15433
Trigger fixes in Sakila.
Modified:
trunk/refman-common/news-5.0.xml
trunk/sample-data/sakila/sakila-data.sql
trunk/sample-data/sakila/sakila-schema.sql
Modified: trunk/refman-common/news-5.0.xml
===================================================================
--- trunk/refman-common/news-5.0.xml 2006-03-01 18:40:16 UTC (rev 1475)
+++ trunk/refman-common/news-5.0.xml 2006-03-01 18:44:09 UTC (rev 1476)
@@ -354,6 +354,15 @@
<listitem>
<para>
+ The embedded server failed various tests in the automated test
+ suite. (Bug #9630, Bug #9631, Bug #9633, Bug #10801, Bug
+ #10911, Bug #10924, Bug #10925, Bug #10926, Bug #10930, Bug
+ #15433)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
Instance Manager erroneously accepted a list of instance
identifiers for the <literal>START INSTANCE</literal> and
<literal>STOP INSTANCE</literal> commands (should accept only
@@ -3095,12 +3104,12 @@
Cluster error codes. (Bug #13740)
</para>
</listitem>
-
+
<listitem>
<para>
<literal>NDB Cluster</literal>: The <command>ndb_mgm</command>
client now reports node startup phases automatically. (Bug
- #16197)
+ #16197)
</para>
</listitem>
Modified: trunk/sample-data/sakila/sakila-data.sql
===================================================================
--- trunk/sample-data/sakila/sakila-data.sql 2006-03-01 18:40:16 UTC (rev 1475)
+++ trunk/sample-data/sakila/sakila-data.sql 2006-03-01 18:44:09 UTC (rev 1476)
@@ -55,7 +55,15 @@
SET AUTOCOMMIT=0;
INSERT INTO customer VALUES (1,1,'MARY','SMITH','MARY.SMITH@stripped',5,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(2,1,'PATRICIA','JOHNSON','PATRICIA.JOHNSON@stripped',6,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(3,1,'LINDA','WILLIAMS','LINDA.WILLIAMS@stripped',7,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(4,2,'BARBARA','JONES','BARBARA.JONES@stripped',8,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(5,1,'ELIZABETH','BROWN','ELIZABETH.BROWN@stripped',9,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(6,2,'JENNIFER','DAVIS','JENNIFER.DAVIS@stripped',10,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(7,1,'MARIA','MILLER','MARIA.MILLER@stripped',11,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(8,2,'SUSAN','WILSON','SUSAN.WILSON@stripped',12,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(9,2,'MARGARET','MOORE','MARGARET.MOORE@stripped',13,1,'2006-02-14 22:04:36','2006-02-1!
5 04:57:20'),(10,1,'DOROTHY','TAYLOR','DOROTHY.TAYLOR@stripped',14,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(11,2,'LISA','ANDERSON','LISA.ANDERSON@stripped',15,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(12,1,'NANCY','THOMAS','NANCY.THOMAS@stripped',16,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(13,2,'KAREN','JACKSON','KAREN.JACKSON@stripped',17,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(14,2,'BETTY','WHITE','BETTY.WHITE@stripped',18,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(15,1,'HELEN','HARRIS','HELEN.HARRIS@stripped',19,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(16,2,'SANDRA','MARTIN','SANDRA.MARTIN@stripped',20,0,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(17,1,'DONNA','THOMPSON','DONNA.THOMPSON@stripped',21,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(18,2,'CAROL','GARCIA','CAROL.GARCIA@stripped',22,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),!
(19,1,'RUTH','MARTINEZ','RUTH.MARTINEZ@stripped',23,!
1,'2006-
02-14 22:04:36','2006-02-15 04:57:20'),(20,2,'SHARON','ROBINSON','SHARON.ROBINSON@stripped',24,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(21,1,'MICHELLE','CLARK','MICHELLE.CLARK@stripped',25,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(22,1,'LAURA','RODRIGUEZ','LAURA.RODRIGUEZ@stripped',26,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(23,2,'SARAH','LEWIS','SARAH.LEWIS@stripped',27,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(24,2,'KIMBERLY','LEE','KIMBERLY.LEE@stripped',28,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(25,1,'DEBORAH','WALKER','DEBORAH.WALKER@stripped',29,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(26,2,'JESSICA','HALL','JESSICA.HALL@stripped',30,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(27,2,'SHIRLEY','ALLEN','SHIRLEY.ALLEN@stripped',31,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(28,1,'CYNTHIA','YOUNG','CYNTHIA.YOUNG@stripped',32,1,'2006-02-1!
4 22:04:36','2006-02-15 04:57:20'),(29,2,'ANGELA','HERNANDEZ','ANGELA.HERNANDEZ@stripped',33,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(30,1,'MELISSA','KING','MELISSA.KING@stripped',34,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(31,2,'BRENDA','WRIGHT','BRENDA.WRIGHT@stripped',35,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(32,1,'AMY','LOPEZ','AMY.LOPEZ@stripped',36,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(33,2,'ANNA','HILL','ANNA.HILL@stripped',37,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(34,2,'REBECCA','SCOTT','REBECCA.SCOTT@stripped',38,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(35,2,'VIRGINIA','GREEN','VIRGINIA.GREEN@stripped',39,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(36,2,'KATHLEEN','ADAMS','KATHLEEN.ADAMS@stripped',40,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(37,1,'PAMELA','BAKER','PAMELA.BAKER@stripped',41,1,'2006-02-14 22:04:36','2006!
-02-15 04:57:20'),(38,1,'MARTHA','GONZALEZ','MARTHA.GONZALEZ@s!
akilacus
tomer.org',42,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(39,1,'DEBRA','NELSON','DEBRA.NELSON@stripped',43,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(40,2,'AMANDA','CARTER','AMANDA.CARTER@stripped',44,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(41,1,'STEPHANIE','MITCHELL','STEPHANIE.MITCHELL@stripped',45,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(42,2,'CAROLYN','PEREZ','CAROLYN.PEREZ@stripped',46,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(43,2,'CHRISTINE','ROBERTS','CHRISTINE.ROBERTS@stripped',47,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(44,1,'MARIE','TURNER','MARIE.TURNER@stripped',48,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(45,1,'JANET','PHILLIPS','JANET.PHILLIPS@stripped',49,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(46,2,'CATHERINE','CAMPBELL','CATHERINE.CAMPBELL@stripped',50,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(47,1,'FRANCES','PARKER','FRAN!
CES.PARKER@stripped',51,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(48,1,'ANN','EVANS','ANN.EVANS@stripped',52,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(49,2,'JOYCE','EDWARDS','JOYCE.EDWARDS@stripped',53,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(50,1,'DIANE','COLLINS','DIANE.COLLINS@stripped',54,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(51,1,'ALICE','STEWART','ALICE.STEWART@stripped',55,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(52,1,'JULIE','SANCHEZ','JULIE.SANCHEZ@stripped',56,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(53,1,'HEATHER','MORRIS','HEATHER.MORRIS@stripped',57,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(54,1,'TERESA','ROGERS','TERESA.ROGERS@stripped',58,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(55,2,'DORIS','REED','DORIS.REED@stripped',59,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(56,1,'GLORIA','COOK','GLORIA.COOK@sakilacustom!
er.org',60,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(57,!
2,'EVELY
N','MORGAN','EVELYN.MORGAN@stripped',61,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(58,1,'JEAN','BELL','JEAN.BELL@stripped',62,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(59,1,'CHERYL','MURPHY','CHERYL.MURPHY@stripped',63,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(60,1,'MILDRED','BAILEY','MILDRED.BAILEY@stripped',64,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(61,2,'KATHERINE','RIVERA','KATHERINE.RIVERA@stripped',65,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(62,1,'JOAN','COOPER','JOAN.COOPER@stripped',66,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(63,1,'ASHLEY','RICHARDSON','ASHLEY.RICHARDSON@stripped',67,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(64,2,'JUDITH','COX','JUDITH.COX@stripped',68,0,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(65,2,'ROSE','HOWARD','ROSE.HOWARD@stripped',69,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(66,2,'JANICE','WARD','JAN!
ICE.WARD@stripped',70,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(67,1,'KELLY','TORRES','KELLY.TORRES@stripped',71,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(68,1,'NICOLE','PETERSON','NICOLE.PETERSON@stripped',72,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(69,2,'JUDY','GRAY','JUDY.GRAY@stripped',73,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(70,2,'CHRISTINA','RAMIREZ','CHRISTINA.RAMIREZ@stripped',74,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(71,1,'KATHY','JAMES','KATHY.JAMES@stripped',75,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(72,2,'THERESA','WATSON','THERESA.WATSON@stripped',76,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(73,2,'BEVERLY','BROOKS','BEVERLY.BROOKS@stripped',77,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(74,1,'DENISE','KELLY','DENISE.KELLY@stripped',78,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(75,2,'TAMMY','SANDERS','TAMMY.SANDER!
S@stripped',79,1,'2006-02-14 22:04:36','2006-02-15 0!
4:57:20'
),(76,2,'IRENE','PRICE','IRENE.PRICE@stripped',80,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(77,2,'JANE','BENNETT','JANE.BENNETT@stripped',81,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(78,1,'LORI','WOOD','LORI.WOOD@stripped',82,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(79,1,'RACHEL','BARNES','RACHEL.BARNES@stripped',83,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(80,1,'MARILYN','ROSS','MARILYN.ROSS@stripped',84,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(81,1,'ANDREA','HENDERSON','ANDREA.HENDERSON@stripped',85,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(82,1,'KATHRYN','COLEMAN','KATHRYN.COLEMAN@stripped',86,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(83,1,'LOUISE','JENKINS','LOUISE.JENKINS@stripped',87,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(84,2,'SARA','PERRY','SARA.PERRY@stripped',88,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(85,2,'ANNE','PO!
WELL','ANNE.POWELL@stripped',89,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(86,2,'JACQUELINE','LONG','JACQUELINE.LONG@stripped',90,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(87,1,'WANDA','PATTERSON','WANDA.PATTERSON@stripped',91,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(88,2,'BONNIE','HUGHES','BONNIE.HUGHES@stripped',92,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(89,1,'JULIA','FLORES','JULIA.FLORES@stripped',93,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(90,2,'RUBY','WASHINGTON','RUBY.WASHINGTON@stripped',94,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(91,2,'LOIS','BUTLER','LOIS.BUTLER@stripped',95,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(92,2,'TINA','SIMMONS','TINA.SIMMONS@stripped',96,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(93,1,'PHYLLIS','FOSTER','PHYLLIS.FOSTER@stripped',97,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(94,1,'NORMA','GONZAL!
ES','NORMA.GONZALES@stripped',98,1,'2006-02-14 22:04!
:36','20
06-02-15 04:57:20'),(95,2,'PAULA','BRYANT','PAULA.BRYANT@stripped',99,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(96,1,'DIANA','ALEXANDER','DIANA.ALEXANDER@stripped',100,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(97,2,'ANNIE','RUSSELL','ANNIE.RUSSELL@stripped',101,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(98,1,'LILLIAN','GRIFFIN','LILLIAN.GRIFFIN@stripped',102,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(99,2,'EMILY','DIAZ','EMILY.DIAZ@stripped',103,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(100,1,'ROBIN','HAYES','ROBIN.HAYES@stripped',104,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(101,1,'PEGGY','MYERS','PEGGY.MYERS@stripped',105,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(102,1,'CRYSTAL','FORD','CRYSTAL.FORD@stripped',106,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(103,1,'GLADYS','HAMILTON','GLADYS.HAMILTON@stripped',107,1,'2006-02-14 22:04:36','2006!
-02-15 04:57:20'),(104,1,'RITA','GRAHAM','RITA.GRAHAM@stripped',108,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(105,1,'DAWN','SULLIVAN','DAWN.SULLIVAN@stripped',109,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(106,1,'CONNIE','WALLACE','CONNIE.WALLACE@stripped',110,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(107,1,'FLORENCE','WOODS','FLORENCE.WOODS@stripped',111,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(108,1,'TRACY','COLE','TRACY.COLE@stripped',112,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(109,2,'EDNA','WEST','EDNA.WEST@stripped',113,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(110,2,'TIFFANY','JORDAN','TIFFANY.JORDAN@stripped',114,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(111,1,'CARMEN','OWENS','CARMEN.OWENS@stripped',115,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(112,2,'ROSA','REYNOLDS','ROSA.REYNOLDS@stripped',116,1,'2006-02-14 22:04:36','2006-02!
-15 04:57:20'),(113,2,'CINDY','FISHER','CINDY.FISHER@sakilacus!
tomer.or
g',117,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(114,2,'GRACE','ELLIS','GRACE.ELLIS@stripped',118,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(115,1,'WENDY','HARRISON','WENDY.HARRISON@stripped',119,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(116,1,'VICTORIA','GIBSON','VICTORIA.GIBSON@stripped',120,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(117,1,'EDITH','MCDONALD','EDITH.MCDONALD@stripped',121,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(118,1,'KIM','CRUZ','KIM.CRUZ@stripped',122,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(119,1,'SHERRY','MARSHALL','SHERRY.MARSHALL@stripped',123,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(120,2,'SYLVIA','ORTIZ','SYLVIA.ORTIZ@stripped',124,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(121,1,'JOSEPHINE','GOMEZ','JOSEPHINE.GOMEZ@stripped',125,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(122,1,'THELMA','MURRAY','THELMA.MURRAY@sakilac!
ustomer.org',126,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(123,2,'SHANNON','FREEMAN','SHANNON.FREEMAN@stripped',127,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(124,1,'SHEILA','WELLS','SHEILA.WELLS@stripped',128,0,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(125,1,'ETHEL','WEBB','ETHEL.WEBB@stripped',129,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(126,1,'ELLEN','SIMPSON','ELLEN.SIMPSON@stripped',130,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(127,2,'ELAINE','STEVENS','ELAINE.STEVENS@stripped',131,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(128,1,'MARJORIE','TUCKER','MARJORIE.TUCKER@stripped',132,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(129,1,'CARRIE','PORTER','CARRIE.PORTER@stripped',133,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(130,1,'CHARLOTTE','HUNTER','CHARLOTTE.HUNTER@stripped',134,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(131,2,'MONICA','HICKS','MON!
ICA.HICKS@stripped',135,1,'2006-02-14 22:04:36','200!
6-02-15
04:57:20'),(132,2,'ESTHER','CRAWFORD','ESTHER.CRAWFORD@stripped',136,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(133,1,'PAULINE','HENRY','PAULINE.HENRY@stripped',137,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(134,1,'EMMA','BOYD','EMMA.BOYD@stripped',138,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(135,2,'JUANITA','MASON','JUANITA.MASON@stripped',139,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(136,2,'ANITA','MORALES','ANITA.MORALES@stripped',140,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(137,2,'RHONDA','KENNEDY','RHONDA.KENNEDY@stripped',141,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(138,1,'HAZEL','WARREN','HAZEL.WARREN@stripped',142,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(139,1,'AMBER','DIXON','AMBER.DIXON@stripped',143,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(140,1,'EVA','RAMOS','EVA.RAMOS@stripped',144,1,'2006-02-14 22:04:36','2006-02-15 04:57:!
20'),(141,1,'DEBBIE','REYES','DEBBIE.REYES@stripped',145,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(142,1,'APRIL','BURNS','APRIL.BURNS@stripped',146,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(143,1,'LESLIE','GORDON','LESLIE.GORDON@stripped',147,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(144,1,'CLARA','SHAW','CLARA.SHAW@stripped',148,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(145,1,'LUCILLE','HOLMES','LUCILLE.HOLMES@stripped',149,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(146,1,'JAMIE','RICE','JAMIE.RICE@stripped',150,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(147,2,'JOANNE','ROBERTSON','JOANNE.ROBERTSON@stripped',151,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(148,1,'ELEANOR','HUNT','ELEANOR.HUNT@stripped',152,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(149,1,'VALERIE','BLACK','VALERIE.BLACK@stripped',153,1,'2006-02-14 22:04:36','2006-02-15 04:57:2!
0'),(150,2,'DANIELLE','DANIELS','DANIELLE.DANIELS@sakilacustom!
er.org',
154,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(151,2,'MEGAN','PALMER','MEGAN.PALMER@stripped',155,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(152,1,'ALICIA','MILLS','ALICIA.MILLS@stripped',156,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(153,2,'SUZANNE','NICHOLS','SUZANNE.NICHOLS@stripped',157,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(154,2,'MICHELE','GRANT','MICHELE.GRANT@stripped',158,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(155,1,'GAIL','KNIGHT','GAIL.KNIGHT@stripped',159,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(156,1,'BERTHA','FERGUSON','BERTHA.FERGUSON@stripped',160,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(157,2,'DARLENE','ROSE','DARLENE.ROSE@stripped',161,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(158,1,'VERONICA','STONE','VERONICA.STONE@stripped',162,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(159,1,'JILL','HAWKINS','JILL.HAWKINS@sakilacustom!
er.org',163,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(160,2,'ERIN','DUNN','ERIN.DUNN@stripped',164,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(161,1,'GERALDINE','PERKINS','GERALDINE.PERKINS@stripped',165,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(162,2,'LAUREN','HUDSON','LAUREN.HUDSON@stripped',166,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(163,1,'CATHY','SPENCER','CATHY.SPENCER@stripped',167,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(164,2,'JOANN','GARDNER','JOANN.GARDNER@stripped',168,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(165,2,'LORRAINE','STEPHENS','LORRAINE.STEPHENS@stripped',169,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(166,1,'LYNN','PAYNE','LYNN.PAYNE@stripped',170,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(167,2,'SALLY','PIERCE','SALLY.PIERCE@stripped',171,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(168,1,'REGINA','BERRY','REGINA.BERRY@sak!
ilacustomer.org',172,1,'2006-02-14 22:04:36','2006-02-15 04:57!
:20'),(1
69,2,'ERICA','MATTHEWS','ERICA.MATTHEWS@stripped',173,0,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(170,1,'BEATRICE','ARNOLD','BEATRICE.ARNOLD@stripped',174,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(171,2,'DOLORES','WAGNER','DOLORES.WAGNER@stripped',175,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(172,1,'BERNICE','WILLIS','BERNICE.WILLIS@stripped',176,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(173,1,'AUDREY','RAY','AUDREY.RAY@stripped',177,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(174,2,'YVONNE','WATKINS','YVONNE.WATKINS@stripped',178,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(175,1,'ANNETTE','OLSON','ANNETTE.OLSON@stripped',179,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(176,1,'JUNE','CARROLL','JUNE.CARROLL@stripped',180,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(177,2,'SAMANTHA','DUNCAN','SAMANTHA.DUNCAN@stripped',181,1,'2006-02-14 22:04:36','2006-0!
2-15 04:57:20'),(178,2,'MARION','SNYDER','MARION.SNYDER@stripped',182,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(179,1,'DANA','HART','DANA.HART@stripped',183,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(180,2,'STACY','CUNNINGHAM','STACY.CUNNINGHAM@stripped',184,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(181,2,'ANA','BRADLEY','ANA.BRADLEY@stripped',185,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(182,1,'RENEE','LANE','RENEE.LANE@stripped',186,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(183,2,'IDA','ANDREWS','IDA.ANDREWS@stripped',187,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(184,1,'VIVIAN','RUIZ','VIVIAN.RUIZ@stripped',188,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(185,1,'ROBERTA','HARPER','ROBERTA.HARPER@stripped',189,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(186,2,'HOLLY','FOX','HOLLY.FOX@stripped',190,1,'2006-02-14 22:04:36','2006-02-15 04:57:20')!
,(187,2,'BRITTANY','RILEY','BRITTANY.RILEY@stripped'!
,191,1,'
2006-02-14 22:04:36','2006-02-15 04:57:20'),(188,1,'MELANIE','ARMSTRONG','MELANIE.ARMSTRONG@stripped',192,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(189,1,'LORETTA','CARPENTER','LORETTA.CARPENTER@stripped',193,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(190,2,'YOLANDA','WEAVER','YOLANDA.WEAVER@stripped',194,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(191,1,'JEANETTE','GREENE','JEANETTE.GREENE@stripped',195,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(192,1,'LAURIE','LAWRENCE','LAURIE.LAWRENCE@stripped',196,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(193,2,'KATIE','ELLIOTT','KATIE.ELLIOTT@stripped',197,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(194,2,'KRISTEN','CHAVEZ','KRISTEN.CHAVEZ@stripped',198,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(195,1,'VANESSA','SIMS','VANESSA.SIMS@stripped',199,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(196,1,'ALMA','AUSTIN','ALMA.AU!
STIN@stripped',200,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(197,2,'SUE','PETERS','SUE.PETERS@stripped',201,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(198,2,'ELSIE','KELLEY','ELSIE.KELLEY@stripped',202,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(199,2,'BETH','FRANKLIN','BETH.FRANKLIN@stripped',203,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(200,2,'JEANNE','LAWSON','JEANNE.LAWSON@stripped',204,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(201,1,'VICKI','FIELDS','VICKI.FIELDS@stripped',205,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(202,2,'CARLA','GUTIERREZ','CARLA.GUTIERREZ@stripped',206,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(203,1,'TARA','RYAN','TARA.RYAN@stripped',207,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(204,1,'ROSEMARY','SCHMIDT','ROSEMARY.SCHMIDT@stripped',208,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(205,2,'EILEEN','CARR','EILEEN.C!
ARR@stripped',209,1,'2006-02-14 22:04:36','2006-02-1!
5 04:57:
20'),(206,1,'TERRI','VASQUEZ','TERRI.VASQUEZ@stripped',210,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(207,1,'GERTRUDE','CASTILLO','GERTRUDE.CASTILLO@stripped',211,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(208,1,'LUCY','WHEELER','LUCY.WHEELER@stripped',212,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(209,2,'TONYA','CHAPMAN','TONYA.CHAPMAN@stripped',213,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(210,2,'ELLA','OLIVER','ELLA.OLIVER@stripped',214,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(211,1,'STACEY','MONTGOMERY','STACEY.MONTGOMERY@stripped',215,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(212,2,'WILMA','RICHARDS','WILMA.RICHARDS@stripped',216,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(213,1,'GINA','WILLIAMSON','GINA.WILLIAMSON@stripped',217,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(214,1,'KRISTIN','JOHNSTON','KRISTIN.JOHNSTON@stripped',218,1,'2006-02!
-14 22:04:36','2006-02-15 04:57:20'),(215,2,'JESSIE','BANKS','JESSIE.BANKS@stripped',219,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(216,1,'NATALIE','MEYER','NATALIE.MEYER@stripped',220,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(217,2,'AGNES','BISHOP','AGNES.BISHOP@stripped',221,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(218,1,'VERA','MCCOY','VERA.MCCOY@stripped',222,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(219,2,'WILLIE','HOWELL','WILLIE.HOWELL@stripped',223,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(220,2,'CHARLENE','ALVAREZ','CHARLENE.ALVAREZ@stripped',224,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(221,1,'BESSIE','MORRISON','BESSIE.MORRISON@stripped',225,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(222,2,'DELORES','HANSEN','DELORES.HANSEN@stripped',226,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(223,1,'MELINDA','FERNANDEZ','MELINDA.FERNANDEZ@sakilacustome!
r.org',227,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(224!
,2,'PEAR
L','GARZA','PEARL.GARZA@stripped',228,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(225,1,'ARLENE','HARVEY','ARLENE.HARVEY@stripped',229,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(226,2,'MAUREEN','LITTLE','MAUREEN.LITTLE@stripped',230,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(227,1,'COLLEEN','BURTON','COLLEEN.BURTON@stripped',231,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(228,2,'ALLISON','STANLEY','ALLISON.STANLEY@stripped',232,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(229,1,'TAMARA','NGUYEN','TAMARA.NGUYEN@stripped',233,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(230,2,'JOY','GEORGE','JOY.GEORGE@stripped',234,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(231,1,'GEORGIA','JACOBS','GEORGIA.JACOBS@stripped',235,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(232,2,'CONSTANCE','REID','CONSTANCE.REID@stripped',236,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),!
(233,2,'LILLIE','KIM','LILLIE.KIM@stripped',237,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(234,1,'CLAUDIA','FULLER','CLAUDIA.FULLER@stripped',238,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(235,1,'JACKIE','LYNCH','JACKIE.LYNCH@stripped',239,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(236,1,'MARCIA','DEAN','MARCIA.DEAN@stripped',240,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(237,1,'TANYA','GILBERT','TANYA.GILBERT@stripped',241,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(238,1,'NELLIE','GARRETT','NELLIE.GARRETT@stripped',242,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(239,2,'MINNIE','ROMERO','MINNIE.ROMERO@stripped',243,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(240,1,'MARLENE','WELCH','MARLENE.WELCH@stripped',244,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(241,2,'HEIDI','LARSON','HEIDI.LARSON@stripped',245,0,'2006-02-14 22:04:36','2006-02-15 04:57:20')!
,(242,1,'GLENDA','FRAZIER','GLENDA.FRAZIER@stripped'!
,246,1,'
2006-02-14 22:04:36','2006-02-15 04:57:20'),(243,1,'LYDIA','BURKE','LYDIA.BURKE@stripped',247,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(244,2,'VIOLA','HANSON','VIOLA.HANSON@stripped',248,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(245,1,'COURTNEY','DAY','COURTNEY.DAY@stripped',249,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(246,1,'MARIAN','MENDOZA','MARIAN.MENDOZA@stripped',250,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(247,1,'STELLA','MORENO','STELLA.MORENO@stripped',251,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(248,1,'CAROLINE','BOWMAN','CAROLINE.BOWMAN@stripped',252,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(249,2,'DORA','MEDINA','DORA.MEDINA@stripped',253,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(250,2,'JO','FOWLER','JO.FOWLER@stripped',254,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(251,2,'VICKIE','BREWER','VICKIE.BREWER@stripped',255,1,'2006!
-02-14 22:04:36','2006-02-15 04:57:20'),(252,2,'MATTIE','HOFFMAN','MATTIE.HOFFMAN@stripped',256,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(253,1,'TERRY','CARLSON','TERRY.CARLSON@stripped',258,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(254,2,'MAXINE','SILVA','MAXINE.SILVA@stripped',259,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(255,2,'IRMA','PEARSON','IRMA.PEARSON@stripped',260,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(256,2,'MABEL','HOLLAND','MABEL.HOLLAND@stripped',261,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(257,2,'MARSHA','DOUGLAS','MARSHA.DOUGLAS@stripped',262,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(258,1,'MYRTLE','FLEMING','MYRTLE.FLEMING@stripped',263,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(259,2,'LENA','JENSEN','LENA.JENSEN@stripped',264,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(260,1,'CHRISTY','VARGAS','CHRISTY.VARGAS@stripped',!
265,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(261,1,'DEA!
NNA','BY
RD','DEANNA.BYRD@stripped',266,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(262,2,'PATSY','DAVIDSON','PATSY.DAVIDSON@stripped',267,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(263,1,'HILDA','HOPKINS','HILDA.HOPKINS@stripped',268,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(264,1,'GWENDOLYN','MAY','GWENDOLYN.MAY@stripped',269,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(265,2,'JENNIE','TERRY','JENNIE.TERRY@stripped',270,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(266,2,'NORA','HERRERA','NORA.HERRERA@stripped',271,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(267,1,'MARGIE','WADE','MARGIE.WADE@stripped',272,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(268,1,'NINA','SOTO','NINA.SOTO@stripped',273,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(269,1,'CASSANDRA','WALTERS','CASSANDRA.WALTERS@stripped',274,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(270,1,'LEAH','CURT!
IS','LEAH.CURTIS@stripped',275,1,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(271,1,'PENNY','NEAL','PENNY.NEAL@stripped',276,0,'2006-02-14 22:04:36','2006-02-15 04:57:20'),(272,1,'KAY','CALDWELL','KAY.CALDWELL@stripped',277,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(273,2,'PRISCILLA','LOWE','PRISCILLA.LOWE@stripped',278,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(274,1,'NAOMI','JENNINGS','NAOMI.JENNINGS@stripped',279,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(275,2,'CAROLE','BARNETT','CAROLE.BARNETT@stripped',280,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(276,1,'BRANDY','GRAVES','BRANDY.GRAVES@stripped',281,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(277,2,'OLGA','JIMENEZ','OLGA.JIMENEZ@stripped',282,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(278,2,'BILLIE','HORTON','BILLIE.HORTON@stripped',283,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(279,2,'DIANNE',!
'SHELTON','DIANNE.SHELTON@stripped',284,1,'2006-02-1!
4 22:04:
37','2006-02-15 04:57:20'),(280,2,'TRACEY','BARRETT','TRACEY.BARRETT@stripped',285,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(281,2,'LEONA','OBRIEN','LEONA.OBRIEN@stripped',286,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(282,2,'JENNY','CASTRO','JENNY.CASTRO@stripped',287,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(283,1,'FELICIA','SUTTON','FELICIA.SUTTON@stripped',288,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(284,1,'SONIA','GREGORY','SONIA.GREGORY@stripped',289,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(285,1,'MIRIAM','MCKINNEY','MIRIAM.MCKINNEY@stripped',290,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(286,1,'VELMA','LUCAS','VELMA.LUCAS@stripped',291,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(287,2,'BECKY','MILES','BECKY.MILES@stripped',292,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(288,1,'BOBBIE','CRAIG','BOBBIE.CRAIG@stripped',293,1,'2006-02-14 22!
:04:37','2006-02-15 04:57:20'),(289,1,'VIOLET','RODRIQUEZ','VIOLET.RODRIQUEZ@stripped',294,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(290,1,'KRISTINA','CHAMBERS','KRISTINA.CHAMBERS@stripped',295,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(291,1,'TONI','HOLT','TONI.HOLT@stripped',296,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(292,2,'MISTY','LAMBERT','MISTY.LAMBERT@stripped',297,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(293,2,'MAE','FLETCHER','MAE.FLETCHER@stripped',298,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(294,2,'SHELLY','WATTS','SHELLY.WATTS@stripped',299,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(295,1,'DAISY','BATES','DAISY.BATES@stripped',300,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(296,2,'RAMONA','HALE','RAMONA.HALE@stripped',301,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(297,1,'SHERRI','RHODES','SHERRI.RHODES@stripped',302,1,'2006-02-!
14 22:04:37','2006-02-15 04:57:20'),(298,1,'ERIKA','PENA','ERI!
KA.PENA@
sakilacustomer.org',303,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(299,2,'JAMES','GANNON','JAMES.GANNON@stripped',304,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(300,1,'JOHN','FARNSWORTH','JOHN.FARNSWORTH@stripped',305,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(301,2,'ROBERT','BAUGHMAN','ROBERT.BAUGHMAN@stripped',306,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(302,1,'MICHAEL','SILVERMAN','MICHAEL.SILVERMAN@stripped',307,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(303,2,'WILLIAM','SATTERFIELD','WILLIAM.SATTERFIELD@stripped',308,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(304,2,'DAVID','ROYAL','DAVID.ROYAL@stripped',309,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(305,1,'RICHARD','MCCRARY','RICHARD.MCCRARY@stripped',310,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(306,1,'CHARLES','KOWALSKI','CHARLES.KOWALSKI@stripped',311,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'!
),(307,2,'JOSEPH','JOY','JOSEPH.JOY@stripped',312,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(308,1,'THOMAS','GRIGSBY','THOMAS.GRIGSBY@stripped',313,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(309,1,'CHRISTOPHER','GRECO','CHRISTOPHER.GRECO@stripped',314,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(310,2,'DANIEL','CABRAL','DANIEL.CABRAL@stripped',315,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(311,2,'PAUL','TROUT','PAUL.TROUT@stripped',316,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(312,2,'MARK','RINEHART','MARK.RINEHART@stripped',317,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(313,2,'DONALD','MAHON','DONALD.MAHON@stripped',318,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(314,1,'GEORGE','LINTON','GEORGE.LINTON@stripped',319,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(315,2,'KENNETH','GOODEN','KENNETH.GOODEN@stripped',320,0,'2006-02-14 22:04:37','2006-02-15 !
04:57:20'),(316,1,'STEVEN','CURLEY','STEVEN.CURLEY@sakilacusto!
mer.org'
,321,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(317,2,'EDWARD','BAUGH','EDWARD.BAUGH@stripped',322,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(318,1,'BRIAN','WYMAN','BRIAN.WYMAN@stripped',323,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(319,2,'RONALD','WEINER','RONALD.WEINER@stripped',324,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(320,2,'ANTHONY','SCHWAB','ANTHONY.SCHWAB@stripped',325,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(321,1,'KEVIN','SCHULER','KEVIN.SCHULER@stripped',326,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(322,1,'JASON','MORRISSEY','JASON.MORRISSEY@stripped',327,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(323,2,'MATTHEW','MAHAN','MATTHEW.MAHAN@stripped',328,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(324,2,'GARY','COY','GARY.COY@stripped',329,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(325,1,'TIMOTHY','BUNN','TIMOTHY.BUNN@stripped',3!
30,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(326,1,'JOSE','ANDREW','JOSE.ANDREW@stripped',331,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(327,2,'LARRY','THRASHER','LARRY.THRASHER@stripped',332,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(328,2,'JEFFREY','SPEAR','JEFFREY.SPEAR@stripped',333,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(329,2,'FRANK','WAGGONER','FRANK.WAGGONER@stripped',334,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(330,1,'SCOTT','SHELLEY','SCOTT.SHELLEY@stripped',335,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(331,1,'ERIC','ROBERT','ERIC.ROBERT@stripped',336,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(332,1,'STEPHEN','QUALLS','STEPHEN.QUALLS@stripped',337,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(333,2,'ANDREW','PURDY','ANDREW.PURDY@stripped',338,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(334,2,'RAYMOND','MCWHORTER','RAYMOND.MCWHORTER@sakila!
customer.org',339,1,'2006-02-14 22:04:37','2006-02-15 04:57:20!
'),(335,
1,'GREGORY','MAULDIN','GREGORY.MAULDIN@stripped',340,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(336,1,'JOSHUA','MARK','JOSHUA.MARK@stripped',341,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(337,1,'JERRY','JORDON','JERRY.JORDON@stripped',342,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(338,1,'DENNIS','GILMAN','DENNIS.GILMAN@stripped',343,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(339,2,'WALTER','PERRYMAN','WALTER.PERRYMAN@stripped',344,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(340,1,'PATRICK','NEWSOM','PATRICK.NEWSOM@stripped',345,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(341,1,'PETER','MENARD','PETER.MENARD@stripped',346,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(342,1,'HAROLD','MARTINO','HAROLD.MARTINO@stripped',347,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(343,1,'DOUGLAS','GRAF','DOUGLAS.GRAF@stripped',348,1,'2006-02-14 22:04:37','2006-02-15 04:5!
7:20'),(344,1,'HENRY','BILLINGSLEY','HENRY.BILLINGSLEY@stripped',349,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(345,1,'CARL','ARTIS','CARL.ARTIS@stripped',350,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(346,1,'ARTHUR','SIMPKINS','ARTHUR.SIMPKINS@stripped',351,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(347,2,'RYAN','SALISBURY','RYAN.SALISBURY@stripped',352,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(348,2,'ROGER','QUINTANILLA','ROGER.QUINTANILLA@stripped',353,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(349,2,'JOE','GILLILAND','JOE.GILLILAND@stripped',354,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(350,1,'JUAN','FRALEY','JUAN.FRALEY@stripped',355,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(351,1,'JACK','FOUST','JACK.FOUST@stripped',356,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(352,1,'ALBERT','CROUSE','ALBERT.CROUSE@stripped',357,1,'2006-02-14 22:04:37'!
,'2006-02-15 04:57:20'),(353,1,'JONATHAN','SCARBOROUGH','JONAT!
HAN.SCAR
BOROUGH@stripped',358,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(354,2,'JUSTIN','NGO','JUSTIN.NGO@stripped',359,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(355,2,'TERRY','GRISSOM','TERRY.GRISSOM@stripped',360,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(356,2,'GERALD','FULTZ','GERALD.FULTZ@stripped',361,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(357,1,'KEITH','RICO','KEITH.RICO@stripped',362,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(358,2,'SAMUEL','MARLOW','SAMUEL.MARLOW@stripped',363,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(359,2,'WILLIE','MARKHAM','WILLIE.MARKHAM@stripped',364,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(360,2,'RALPH','MADRIGAL','RALPH.MADRIGAL@stripped',365,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(361,2,'LAWRENCE','LAWTON','LAWRENCE.LAWTON@stripped',366,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(362,1,'NICHOLAS','BARFIELD'!
,'NICHOLAS.BARFIELD@stripped',367,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(363,2,'ROY','WHITING','ROY.WHITING@stripped',368,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(364,1,'BENJAMIN','VARNEY','BENJAMIN.VARNEY@stripped',369,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(365,2,'BRUCE','SCHWARZ','BRUCE.SCHWARZ@stripped',370,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(366,1,'BRANDON','HUEY','BRANDON.HUEY@stripped',371,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(367,1,'ADAM','GOOCH','ADAM.GOOCH@stripped',372,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(368,1,'HARRY','ARCE','HARRY.ARCE@stripped',373,0,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(369,2,'FRED','WHEAT','FRED.WHEAT@stripped',374,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(370,2,'WAYNE','TRUONG','WAYNE.TRUONG@stripped',375,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(371,1,'BILLY','POULIN','BILLY.!
POULIN@stripped',376,1,'2006-02-14 22:04:37','2006-0!
2-15 04:
57:20'),(372,2,'STEVE','MACKENZIE','STEVE.MACKENZIE@stripped',377,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(373,1,'LOUIS','LEONE','LOUIS.LEONE@stripped',378,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(374,2,'JEREMY','HURTADO','JEREMY.HURTADO@stripped',379,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(375,2,'AARON','SELBY','AARON.SELBY@stripped',380,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(376,1,'RANDY','GAITHER','RANDY.GAITHER@stripped',381,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(377,1,'HOWARD','FORTNER','HOWARD.FORTNER@stripped',382,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(378,1,'EUGENE','CULPEPPER','EUGENE.CULPEPPER@stripped',383,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(379,1,'CARLOS','COUGHLIN','CARLOS.COUGHLIN@stripped',384,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(380,1,'RUSSELL','BRINSON','RUSSELL.BRINSON@stripped',385,1,'2006-02-14 2!
2:04:37','2006-02-15 04:57:20'),(381,2,'BOBBY','BOUDREAU','BOBBY.BOUDREAU@stripped',386,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(382,2,'VICTOR','BARKLEY','VICTOR.BARKLEY@stripped',387,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(383,1,'MARTIN','BALES','MARTIN.BALES@stripped',388,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(384,2,'ERNEST','STEPP','ERNEST.STEPP@stripped',389,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(385,1,'PHILLIP','HOLM','PHILLIP.HOLM@stripped',390,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(386,1,'TODD','TAN','TODD.TAN@stripped',391,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(387,2,'JESSE','SCHILLING','JESSE.SCHILLING@stripped',392,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(388,2,'CRAIG','MORRELL','CRAIG.MORRELL@stripped',393,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(389,1,'ALAN','KAHN','ALAN.KAHN@stripped',394,1,'2006-02-14 22:04:!
37','2006-02-15 04:57:20'),(390,1,'SHAWN','HEATON','SHAWN.HEAT!
ON@sakil
acustomer.org',395,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(391,1,'CLARENCE','GAMEZ','CLARENCE.GAMEZ@stripped',396,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(392,2,'SEAN','DOUGLASS','SEAN.DOUGLASS@stripped',397,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(393,1,'PHILIP','CAUSEY','PHILIP.CAUSEY@stripped',398,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(394,2,'CHRIS','BROTHERS','CHRIS.BROTHERS@stripped',399,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(395,2,'JOHNNY','TURPIN','JOHNNY.TURPIN@stripped',400,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(396,1,'EARL','SHANKS','EARL.SHANKS@stripped',401,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(397,1,'JIMMY','SCHRADER','JIMMY.SCHRADER@stripped',402,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(398,1,'ANTONIO','MEEK','ANTONIO.MEEK@stripped',403,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(399,1,'DANNY','ISOM','DANNY.ISOM@s!
akilacustomer.org',404,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(400,2,'BRYAN','HARDISON','BRYAN.HARDISON@stripped',405,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(401,2,'TONY','CARRANZA','TONY.CARRANZA@stripped',406,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(402,1,'LUIS','YANEZ','LUIS.YANEZ@stripped',407,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(403,1,'MIKE','WAY','MIKE.WAY@stripped',408,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(404,2,'STANLEY','SCROGGINS','STANLEY.SCROGGINS@stripped',409,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(405,1,'LEONARD','SCHOFIELD','LEONARD.SCHOFIELD@stripped',410,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(406,1,'NATHAN','RUNYON','NATHAN.RUNYON@stripped',411,0,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(407,1,'DALE','RATCLIFF','DALE.RATCLIFF@stripped',412,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(408,1,'MANUEL','MURRELL','M!
ANUEL.MURRELL@stripped',413,1,'2006-02-14 22:04:37',!
'2006-02
-15 04:57:20'),(409,2,'RODNEY','MOELLER','RODNEY.MOELLER@stripped',414,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(410,2,'CURTIS','IRBY','CURTIS.IRBY@stripped',415,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(411,1,'NORMAN','CURRIER','NORMAN.CURRIER@stripped',416,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(412,2,'ALLEN','BUTTERFIELD','ALLEN.BUTTERFIELD@stripped',417,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(413,2,'MARVIN','YEE','MARVIN.YEE@stripped',418,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(414,1,'VINCENT','RALSTON','VINCENT.RALSTON@stripped',419,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(415,1,'GLENN','PULLEN','GLENN.PULLEN@stripped',420,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(416,2,'JEFFERY','PINSON','JEFFERY.PINSON@stripped',421,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(417,1,'TRAVIS','ESTEP','TRAVIS.ESTEP@stripped',422,1,'2006-02-14 22:0!
4:37','2006-02-15 04:57:20'),(418,2,'JEFF','EAST','JEFF.EAST@stripped',423,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(419,1,'CHAD','CARBONE','CHAD.CARBONE@stripped',424,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(420,1,'JACOB','LANCE','JACOB.LANCE@stripped',425,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(421,1,'LEE','HAWKS','LEE.HAWKS@stripped',426,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(422,1,'MELVIN','ELLINGTON','MELVIN.ELLINGTON@stripped',427,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(423,2,'ALFRED','CASILLAS','ALFRED.CASILLAS@stripped',428,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(424,2,'KYLE','SPURLOCK','KYLE.SPURLOCK@stripped',429,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(425,2,'FRANCIS','SIKES','FRANCIS.SIKES@stripped',430,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(426,1,'BRADLEY','MOTLEY','BRADLEY.MOTLEY@stripped',431,1,'2006-02-14 22:!
04:37','2006-02-15 04:57:20'),(427,2,'JESUS','MCCARTNEY','JESU!
S.MCCART
NEY@stripped',432,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(428,2,'HERBERT','KRUGER','HERBERT.KRUGER@stripped',433,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(429,2,'FREDERICK','ISBELL','FREDERICK.ISBELL@stripped',434,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(430,1,'RAY','HOULE','RAY.HOULE@stripped',435,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(431,2,'JOEL','FRANCISCO','JOEL.FRANCISCO@stripped',436,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(432,1,'EDWIN','BURK','EDWIN.BURK@stripped',437,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(433,1,'DON','BONE','DON.BONE@stripped',438,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(434,1,'EDDIE','TOMLIN','EDDIE.TOMLIN@stripped',439,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(435,2,'RICKY','SHELBY','RICKY.SHELBY@stripped',440,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(436,1,'TROY','QUIGLEY','TROY.QUIGLEY@sakila!
customer.org',441,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(437,2,'RANDALL','NEUMANN','RANDALL.NEUMANN@stripped',442,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(438,1,'BARRY','LOVELACE','BARRY.LOVELACE@stripped',443,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(439,2,'ALEXANDER','FENNELL','ALEXANDER.FENNELL@stripped',444,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(440,1,'BERNARD','COLBY','BERNARD.COLBY@stripped',445,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(441,1,'MARIO','CHEATHAM','MARIO.CHEATHAM@stripped',446,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(442,1,'LEROY','BUSTAMANTE','LEROY.BUSTAMANTE@stripped',447,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(443,2,'FRANCISCO','SKIDMORE','FRANCISCO.SKIDMORE@stripped',448,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(444,2,'MARCUS','HIDALGO','MARCUS.HIDALGO@stripped',449,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(!
445,1,'MICHEAL','FORMAN','MICHEAL.FORMAN@stripped',4!
50,1,'20
06-02-14 22:04:37','2006-02-15 04:57:20'),(446,2,'THEODORE','CULP','THEODORE.CULP@stripped',451,0,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(447,1,'CLIFFORD','BOWENS','CLIFFORD.BOWENS@stripped',452,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(448,1,'MIGUEL','BETANCOURT','MIGUEL.BETANCOURT@stripped',453,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(449,2,'OSCAR','AQUINO','OSCAR.AQUINO@stripped',454,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(450,1,'JAY','ROBB','JAY.ROBB@stripped',455,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(451,1,'JIM','REA','JIM.REA@stripped',456,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(452,1,'TOM','MILNER','TOM.MILNER@stripped',457,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(453,1,'CALVIN','MARTEL','CALVIN.MARTEL@stripped',458,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(454,2,'ALEX','GRESHAM','ALEX.GRESHAM@stripped',459,1,'2006-02-14 2!
2:04:37','2006-02-15 04:57:20'),(455,2,'JON','WILES','JON.WILES@stripped',460,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(456,2,'RONNIE','RICKETTS','RONNIE.RICKETTS@stripped',461,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(457,2,'BILL','GAVIN','BILL.GAVIN@stripped',462,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(458,1,'LLOYD','DOWD','LLOYD.DOWD@stripped',463,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(459,1,'TOMMY','COLLAZO','TOMMY.COLLAZO@stripped',464,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(460,1,'LEON','BOSTIC','LEON.BOSTIC@stripped',465,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(461,1,'DEREK','BLAKELY','DEREK.BLAKELY@stripped',466,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(462,2,'WARREN','SHERROD','WARREN.SHERROD@stripped',467,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(463,2,'DARRELL','POWER','DARRELL.POWER@stripped',468,1,'2006-02-14 22:04:37!
','2006-02-15 04:57:20'),(464,1,'JEROME','KENYON','JEROME.KENY!
ON@sakil
acustomer.org',469,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(465,1,'FLOYD','GANDY','FLOYD.GANDY@stripped',470,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(466,1,'LEO','EBERT','LEO.EBERT@stripped',471,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(467,2,'ALVIN','DELOACH','ALVIN.DELOACH@stripped',472,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(468,1,'TIM','CARY','TIM.CARY@stripped',473,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(469,2,'WESLEY','BULL','WESLEY.BULL@stripped',474,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(470,1,'GORDON','ALLARD','GORDON.ALLARD@stripped',475,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(471,1,'DEAN','SAUER','DEAN.SAUER@stripped',476,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(472,1,'GREG','ROBINS','GREG.ROBINS@stripped',477,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(473,2,'JORGE','OLIVARES','JORGE.OLIVARES@stripped',478,1,'20!
06-02-14 22:04:37','2006-02-15 04:57:20'),(474,2,'DUSTIN','GILLETTE','DUSTIN.GILLETTE@stripped',479,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(475,2,'PEDRO','CHESTNUT','PEDRO.CHESTNUT@stripped',480,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(476,1,'DERRICK','BOURQUE','DERRICK.BOURQUE@stripped',481,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(477,1,'DAN','PAINE','DAN.PAINE@stripped',482,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(478,1,'LEWIS','LYMAN','LEWIS.LYMAN@stripped',483,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(479,1,'ZACHARY','HITE','ZACHARY.HITE@stripped',484,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(480,1,'COREY','HAUSER','COREY.HAUSER@stripped',485,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(481,1,'HERMAN','DEVORE','HERMAN.DEVORE@stripped',486,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(482,1,'MAURICE','CRAWLEY','MAURICE.CRAWLEY@stripped',!
487,0,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(483,2,'VER!
NON','CH
APA','VERNON.CHAPA@stripped',488,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(484,1,'ROBERTO','VU','ROBERTO.VU@stripped',489,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(485,1,'CLYDE','TOBIAS','CLYDE.TOBIAS@stripped',490,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(486,1,'GLEN','TALBERT','GLEN.TALBERT@stripped',491,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(487,2,'HECTOR','POINDEXTER','HECTOR.POINDEXTER@stripped',492,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(488,2,'SHANE','MILLARD','SHANE.MILLARD@stripped',493,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(489,1,'RICARDO','MEADOR','RICARDO.MEADOR@stripped',494,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(490,1,'SAM','MCDUFFIE','SAM.MCDUFFIE@stripped',495,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(491,2,'RICK','MATTOX','RICK.MATTOX@stripped',496,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(492,2,'LESTER','!
KRAUS','LESTER.KRAUS@stripped',497,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(493,1,'BRENT','HARKINS','BRENT.HARKINS@stripped',498,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(494,2,'RAMON','CHOATE','RAMON.CHOATE@stripped',499,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(495,2,'CHARLIE','BESS','CHARLIE.BESS@stripped',500,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(496,2,'TYLER','WREN','TYLER.WREN@stripped',501,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(497,2,'GILBERT','SLEDGE','GILBERT.SLEDGE@stripped',502,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(498,1,'GENE','SANBORN','GENE.SANBORN@stripped',503,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(499,2,'MARC','OUTLAW','MARC.OUTLAW@stripped',504,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(500,1,'REGINALD','KINDER','REGINALD.KINDER@stripped',505,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(501,1,'RUBEN','GE!
ARY','RUBEN.GEARY@stripped',506,1,'2006-02-14 22:04:!
37','200
6-02-15 04:57:20'),(502,1,'BRETT','CORNWELL','BRETT.CORNWELL@stripped',507,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(503,1,'ANGEL','BARCLAY','ANGEL.BARCLAY@stripped',508,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(504,1,'NATHANIEL','ADAM','NATHANIEL.ADAM@stripped',509,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(505,1,'RAFAEL','ABNEY','RAFAEL.ABNEY@stripped',510,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(506,2,'LESLIE','SEWARD','LESLIE.SEWARD@stripped',511,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(507,2,'EDGAR','RHOADS','EDGAR.RHOADS@stripped',512,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(508,2,'MILTON','HOWLAND','MILTON.HOWLAND@stripped',513,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(509,1,'RAUL','FORTIER','RAUL.FORTIER@stripped',514,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(510,2,'BEN','EASTER','BEN.EASTER@stripped',515,0,'2006-02-14 22:04:37',!
'2006-02-15 04:57:20'),(511,1,'CHESTER','BENNER','CHESTER.BENNER@stripped',516,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(512,1,'CECIL','VINES','CECIL.VINES@stripped',517,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(513,2,'DUANE','TUBBS','DUANE.TUBBS@stripped',519,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(514,2,'FRANKLIN','TROUTMAN','FRANKLIN.TROUTMAN@stripped',520,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(515,1,'ANDRE','RAPP','ANDRE.RAPP@stripped',521,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(516,2,'ELMER','NOE','ELMER.NOE@stripped',522,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(517,2,'BRAD','MCCURDY','BRAD.MCCURDY@stripped',523,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(518,1,'GABRIEL','HARDER','GABRIEL.HARDER@stripped',524,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(519,2,'RON','DELUCA','RON.DELUCA@stripped',525,1,'2006-02-14 22:04:37','2006-0!
2-15 04:57:20'),(520,2,'MITCHELL','WESTMORELAND','MITCHELL.WES!
TMORELAN
D@stripped',526,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(521,2,'ROLAND','SOUTH','ROLAND.SOUTH@stripped',527,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(522,2,'ARNOLD','HAVENS','ARNOLD.HAVENS@stripped',528,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(523,1,'HARVEY','GUAJARDO','HARVEY.GUAJARDO@stripped',529,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(524,1,'JARED','ELY','JARED.ELY@stripped',530,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(525,2,'ADRIAN','CLARY','ADRIAN.CLARY@stripped',531,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(526,2,'KARL','SEAL','KARL.SEAL@stripped',532,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(527,1,'CORY','MEEHAN','CORY.MEEHAN@stripped',533,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(528,1,'CLAUDE','HERZOG','CLAUDE.HERZOG@stripped',534,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(529,2,'ERIK','GUILLEN','ERIK.GUILLEN@sakilacust!
omer.org',535,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(530,2,'DARRYL','ASHCRAFT','DARRYL.ASHCRAFT@stripped',536,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(531,2,'JAMIE','WAUGH','JAMIE.WAUGH@stripped',537,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(532,2,'NEIL','RENNER','NEIL.RENNER@stripped',538,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(533,1,'JESSIE','MILAM','JESSIE.MILAM@stripped',539,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(534,1,'CHRISTIAN','JUNG','CHRISTIAN.JUNG@stripped',540,0,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(535,1,'JAVIER','ELROD','JAVIER.ELROD@stripped',541,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(536,2,'FERNANDO','CHURCHILL','FERNANDO.CHURCHILL@stripped',542,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(537,2,'CLINTON','BUFORD','CLINTON.BUFORD@stripped',543,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(538,2,'TED','BREAUX','TED.BREAUX!
@sakilacustomer.org',544,1,'2006-02-14 22:04:37','2006-02-15 0!
4:57:20'
),(539,1,'MATHEW','BOLIN','MATHEW.BOLIN@stripped',545,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(540,1,'TYRONE','ASHER','TYRONE.ASHER@stripped',546,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(541,2,'DARREN','WINDHAM','DARREN.WINDHAM@stripped',547,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(542,2,'LONNIE','TIRADO','LONNIE.TIRADO@stripped',548,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(543,1,'LANCE','PEMBERTON','LANCE.PEMBERTON@stripped',549,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(544,2,'CODY','NOLEN','CODY.NOLEN@stripped',550,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(545,2,'JULIO','NOLAND','JULIO.NOLAND@stripped',551,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(546,1,'KELLY','KNOTT','KELLY.KNOTT@stripped',552,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(547,1,'KURT','EMMONS','KURT.EMMONS@stripped',553,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(5!
48,1,'ALLAN','CORNISH','ALLAN.CORNISH@stripped',554,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(549,1,'NELSON','CHRISTENSON','NELSON.CHRISTENSON@stripped',555,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(550,2,'GUY','BROWNLEE','GUY.BROWNLEE@stripped',556,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(551,2,'CLAYTON','BARBEE','CLAYTON.BARBEE@stripped',557,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(552,2,'HUGH','WALDROP','HUGH.WALDROP@stripped',558,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(553,1,'MAX','PITT','MAX.PITT@stripped',559,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(554,1,'DWAYNE','OLVERA','DWAYNE.OLVERA@stripped',560,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(555,1,'DWIGHT','LOMBARDI','DWIGHT.LOMBARDI@stripped',561,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(556,2,'ARMANDO','GRUBER','ARMANDO.GRUBER@stripped',562,1,'2006-02-14 22:04:37','2006-02-1!
5 04:57:20'),(557,1,'FELIX','GAFFNEY','FELIX.GAFFNEY@sakilacus!
tomer.or
g',563,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(558,1,'JIMMIE','EGGLESTON','JIMMIE.EGGLESTON@stripped',564,0,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(559,2,'EVERETT','BANDA','EVERETT.BANDA@stripped',565,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(560,1,'JORDAN','ARCHULETA','JORDAN.ARCHULETA@stripped',566,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(561,2,'IAN','STILL','IAN.STILL@stripped',567,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(562,1,'WALLACE','SLONE','WALLACE.SLONE@stripped',568,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(563,2,'KEN','PREWITT','KEN.PREWITT@stripped',569,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(564,2,'BOB','PFEIFFER','BOB.PFEIFFER@stripped',570,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(565,2,'JAIME','NETTLES','JAIME.NETTLES@stripped',571,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(566,1,'CASEY','MENA','CASEY.MENA@sakilacustomer.!
org',572,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(567,2,'ALFREDO','MCADAMS','ALFREDO.MCADAMS@stripped',573,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(568,2,'ALBERTO','HENNING','ALBERTO.HENNING@stripped',574,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(569,2,'DAVE','GARDINER','DAVE.GARDINER@stripped',575,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(570,2,'IVAN','CROMWELL','IVAN.CROMWELL@stripped',576,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(571,2,'JOHNNIE','CHISHOLM','JOHNNIE.CHISHOLM@stripped',577,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(572,1,'SIDNEY','BURLESON','SIDNEY.BURLESON@stripped',578,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(573,1,'BYRON','BOX','BYRON.BOX@stripped',579,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(574,2,'JULIAN','VEST','JULIAN.VEST@stripped',580,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(575,2,'ISAAC','OGLESBY','ISAAC.OGLESB!
Y@stripped',581,1,'2006-02-14 22:04:37','2006-02-15 !
04:57:20
'),(576,2,'MORRIS','MCCARTER','MORRIS.MCCARTER@stripped',582,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(577,2,'CLIFTON','MALCOLM','CLIFTON.MALCOLM@stripped',583,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(578,2,'WILLARD','LUMPKIN','WILLARD.LUMPKIN@stripped',584,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(579,2,'DARYL','LARUE','DARYL.LARUE@stripped',585,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(580,1,'ROSS','GREY','ROSS.GREY@stripped',586,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(581,1,'VIRGIL','WOFFORD','VIRGIL.WOFFORD@stripped',587,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(582,2,'ANDY','VANHORN','ANDY.VANHORN@stripped',588,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(583,1,'MARSHALL','THORN','MARSHALL.THORN@stripped',589,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(584,2,'SALVADOR','TEEL','SALVADOR.TEEL@stripped',590,1,'2006-02-14 22:04:37','2006-02!
-15 04:57:20'),(585,1,'PERRY','SWAFFORD','PERRY.SWAFFORD@stripped',591,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(586,1,'KIRK','STCLAIR','KIRK.STCLAIR@stripped',592,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(587,1,'SERGIO','STANFIELD','SERGIO.STANFIELD@stripped',593,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(588,1,'MARION','OCAMPO','MARION.OCAMPO@stripped',594,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(589,1,'TRACY','HERRMANN','TRACY.HERRMANN@stripped',595,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(590,2,'SETH','HANNON','SETH.HANNON@stripped',596,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(591,1,'KENT','ARSENAULT','KENT.ARSENAULT@stripped',597,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(592,1,'TERRANCE','ROUSH','TERRANCE.ROUSH@stripped',598,0,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(593,2,'RENE','MCALISTER','RENE.MCALISTER@stripped',599,1,'2006-02-!
14 22:04:37','2006-02-15 04:57:20'),(594,1,'EDUARDO','HIATT','!
EDUARDO.
HIATT@stripped',600,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(595,1,'TERRENCE','GUNDERSON','TERRENCE.GUNDERSON@stripped',601,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(596,1,'ENRIQUE','FORSYTHE','ENRIQUE.FORSYTHE@stripped',602,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(597,1,'FREDDIE','DUGGAN','FREDDIE.DUGGAN@stripped',603,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(598,1,'WADE','DELVALLE','WADE.DELVALLE@stripped',604,1,'2006-02-14 22:04:37','2006-02-15 04:57:20'),(599,2,'AUSTIN','CINTRON','AUSTIN.CINTRON@stripped',605,1,'2006-02-14 22:04:37','2006-02-15 04:57:20');
COMMIT;
+
--
+-- Trigger to enforce create dates on INSERT
+--
+
+CREATE TRIGGER customer_create_date BEFORE INSERT ON customer
+ FOR EACH ROW SET NEW.create_date = NOW();
+
+--
-- Dumping data for table film
--
@@ -105,6 +113,13 @@
COMMIT;
--
+-- Trigger to enforce payment_date during INSERT
+--
+
+CREATE TRIGGER payment_date BEFORE INSERT ON payment
+ FOR EACH ROW SET NEW.payment_date = NOW();
+
+--
-- Dumping data for table rental
--
Modified: trunk/sample-data/sakila/sakila-schema.sql
===================================================================
--- trunk/sample-data/sakila/sakila-schema.sql 2006-03-01 18:40:16 UTC (rev 1475)
+++ trunk/sample-data/sakila/sakila-schema.sql 2006-03-01 18:44:09 UTC (rev 1476)
@@ -100,13 +100,6 @@
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--- Trigger to enforce create dates on INSERT
---
-
-CREATE TRIGGER customer_create_date BEFORE INSERT ON customer
- FOR EACH ROW SET NEW.create_date = NOW();
-
---
-- Table structure for table `film`
--
@@ -247,13 +240,7 @@
CONSTRAINT fk_payment_staff FOREIGN KEY (staff_id) REFERENCES staff (staff_id) ON DELETE RESTRICT ON UPDATE CASCADE
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
--- Trigger to enforce payment_date during INSERT
---
-CREATE TRIGGER payment_date BEFORE INSERT ON payment
- FOR EACH ROW SET NEW.payment_date = NOW();
-
--
-- Table structure for table `rental`
--
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1476 - in trunk: refman-common sample-data/sakila | mhillyer | 1 Mar |
