<?
    require("util.php3");
    DoTitle("ACME Party Balloons - Reset Demo");
    $sql = new MySQL_class;
    $sql->Create("churchil_demo");

    /* List out the tables to update */
    $tables[] = "ACME_Seminars";
    $tables[] = "ACME_Locations";
    $tables[] = "ACME_Attendee";

    /* Loop over each table, first deleteing all of the
     * rows and then loading in the data stored off in
     * the data file.
     */
    echo("<h4>Clearing Tables:</h2>\n<ul>\n");
    do {
        $table = current($tables);

        /* Delete everything from the table */
        $sql->Delete("delete from $table");
        echo("<li>Cleared: $table\n");
    } while (next($tables));
    echo("</ul>\n");

    /* Load new information in */
    echo("<h4>Loading Data...</h4>\n");

    $sql->Insert("INSERT INTO ACME_Seminars VALUES (1,'1998-10-15 15:30:00',2,250.00,'The good Doctor will be demonstrating\r\nhis award winning 4 balloon dragon\r\ndesign.',0,15)");
    $sql->Insert("INSERT INTO ACME_Seminars VALUES (2,'1998-10-06 12:30:00',3,250.00,'',2,15)");
    $sql->Insert("INSERT INTO ACME_Seminars VALUES (3,'1998-10-02 13:30:00',7,250.00,'',0,15)");
    $sql->Insert("INSERT INTO ACME_Seminars VALUES (4,'1998-10-05 13:30:00',5,250.00,'',15,15)");
    $sql->Insert("INSERT INTO ACME_Seminars VALUES (5,'1998-10-08 15:30:00',6,250.00,'',0,15)");
    $sql->Insert("INSERT INTO ACME_Locations VALUES (3,'Sheraton','23 Main St.','','','Burlington','VT','802-364-1200','Take Exit 14-W from Rt 89.  Turn left\r\nat the first set of lights.  Conference\r\nroom entrance is in the back.\r\n')");
    $sql->Insert("INSERT INTO ACME_Locations VALUES (2,'Red Lion Inn','10234 West St.','','','San Jose','CA','650-443-2500','From San Francisco, take Rt 101 south\r\nto the San Jose Airport Exit.  Turn\r\nleft at the first set of lights and\r\nleft again at the next set of lights.\r\nConference entrance on the left side,\r\ntowards the back.')");
    $sql->Insert("INSERT INTO ACME_Locations VALUES (4,'Hilton Conference Center','267 West 53rd','','','New York','NY','303-555-2500','Near the 53rd street subway stop.')");
    $sql->Insert("INSERT INTO ACME_Locations VALUES (5,'Edward Concord Conference Center','456 North Loomis Rd.','Suite #300','','Dallas','TX','807-234-5512','')");
    $sql->Insert("INSERT INTO ACME_Locations VALUES (6,'Maggie\'s Magic Supplies','34 Cannery Row','','','Los Angeles','CA','405-665-9283','')");
    $sql->Insert("INSERT INTO ACME_Locations VALUES (7,'Cubs Conference Center','34 Park Row','','','Chicago','IL','333-459-0587','')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (1,'Roy','Bartley','Wonderful Widgets','13 Axle Lane','','','Hoboken','NJ','23456',4,'N','0000-00-00 00:00:00','barley@widgets.com','N','Y','MasterCard','2222-3333-4444-5566','12/30/00',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (6,'Gareth','Powell','Lucid','707 Laurel St.','','','Menlo Park','CA','94025',4,'N','0000-00-00 00:00:00','gareth@lucid.com','N','N','MasterCard','1111-2222-3333-4444','4/99',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (3,'Albert','Bear','Wooly Woolens','7 Hybernation Drive','','','Wonka','WI','22222',4,'N','0000-00-00 00:00:00','bear@warmwoolies.com','Y','N','BillMe','','',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (5,'Albert','Frazier','','7 East Ave','','','New York','NY','99999',4,'N','0000-00-00 00:00:00','frazier@hotmail.com','Y','N','BillMe','','',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (4,'John','Doe','Deer Bait Inc.','37 Spotted Lane','','','Burlington','MA','01477',4,'N','0000-00-00 00:00:00','jdoe@dearbait.com','N','N','PayAtShow','','',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (7,'Laurie','Aguirre','Lucid Inc.','707 Laurel Street','','','Menlo Park','CA','94025',4,'N','0000-00-00 00:00:00','laurie@lucid.com','Y','N','BillMe','','',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (8,'Louis','Leopold','Quad Design','1385 Del Norte Road','','','Camarillo','CA','93010',4,'N','0000-00-00 00:00:00','lleopold@qdt.com','N','N','BillMe','','',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (9,'Bob','Condon','Condon Consulting','Mt. Philo Rd','','','Shellburne','VT','05482',4,'N','0000-00-00 00:00:00','condon@condon.com','N','N','MasterCard','1234-1234-1234-1234','4/12/99',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (10,'Mark','Coiley','','RR#1 Box 1283','Scottsville Rd','','Danby','VT','05739',4,'N','0000-00-00 00:00:00','coiley@sover.net','Y','N','PayAtShow','','',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (11,'Nina','Arnfield','Fidelity','707 Insurance Park','','','Marlboro','MA','04557',4,'N','0000-00-00 00:00:00','nina@ultranet.com','Y','N','BillMe','','',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (12,'Annie','Dupree','Orvis Fishing','PO Box 211','','','Manchester','VT','05254',4,'N','0000-00-00 00:00:00','annie@sover.net','N','N','Discover','1234-1234-124-12347','6/00',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (13,'Jo','Guthrie','','402 Webster St.','','','Needham Heights','MA','02184',4,'N','0000-00-00 00:00:00','jguthrie@aol.com','N','N','BillMe','','',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (14,'Mike','Floyd','Cadence Design Systems','2000 Tewksbury Rd','Suite 15','','Chelmsford','MA','03875',4,'N','0000-00-00 00:00:00','mfloyd@cadence.com','N','N','PayAtShow','','',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (15,'Ann','Landers','','Suite 5598-D','Welsham Office Towers','','Chicago','IL','23487',4,'N','0000-00-00 00:00:00','landers@aol.com','Y','N','PayAtShow','','',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (16,'Rick','Pirozak','IMC Inc.','Suite #300','172 East St.','','Lowell','MA','23987',4,'N','0000-00-00 00:00:00','pirozak@imc.com','Y','N','AmExpr','12-1234-1235-235-123','8/99',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (17,'Susan','Wimler','','98 West Ave. Apt 4','','','Burlington','VT','05587',2,'N','0000-00-00 00:00:00','swimler@together.net','N','N','PayAtShow','9999-9999-9999-9999','9/99',0,'','','0000-00-00 00:00:00')");
    $sql->Insert("INSERT INTO ACME_Attendee VALUES (18,'Joe','Burell','Unknown Blues','67 Battery St.','','','Burlington','VT','04577',2,'N','0000-00-00 00:00:00','burell@together.net','N','N','BillMe','','',0,'','','0000-00-00 00:00:00')");

    echo("<h4>Done.</h4>\n");
    echo("<p>The database has been restored to it's original state.  Feel free to \n");
    echo("modify it any way you wish.\n");

    include("footer.php3");
?>