<?php
/**
 * This file contains code that help the test files to setup the test data.
 *
 * This file is part of the PhpMyObject project.
 * 
 * For questions, help, comments, discussion, etc., please join our
 * forum at {@link http://www.developpez.net/forums/forumdisplay.php?f=770} 
 * or our mailing list at {@link http://groups.google.com/group/pmo-dev}.
 *
 * PhpMyProject is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 * @package    PhpMyObject
 * @author     Nicolas Boiteux <nicolas_boiteux@yahoo.fr>
 * @author     Louis Lapointe <louis.lapointe@gmail.com>
 * @link       http://pmo.developpez.com/
 * @since      PhpMyObject v0.14
 * @version    $Revision$
 * @copyright  Copyright (c) 2007-2008 Nicolas Boiteux 
 * @copyright  Copyright (c) 2008 Louis Lapointe
 * @license    GPLv3 {@link http://www.gnu.org/licenses/gpl}
 * @filesource
 */ 


/*
 * these vars get included by some test class methods.
 * TODO This needs to be expanded a lot. 
 */

/**
 * DROPS 
 */
$drops = array(
	'DROP TABLE IF EXISTS `actor`',
	'DROP INDEX if exists `idx_actor_last_name`'
);

/**
 * CREATES
 */
$creates = array(
  	'CREATE TABLE IF NOT EXISTS `actor` ('
	. '`actor_id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT'
	. ', `first_name` TEXT NOT NULL'
	. ', `last_name` TEXT NOT NULL'
	. ', `last_update` TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP'
	. ')',
	' CREATE INDEX IF NOT EXISTS idx_actor_last_name ON actor(last_name)'
);


/**
 * DELETES
 */
$deletes = array(
	'DELETE FROM `actor`'
);

/**
 * INSERTS
 * We need to do these inserts this way since not all databases
 * engine are capable of bulk inserts.
 */
$inserts = array(
 '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")'
);