Source for file pmo_test_data.php
Documentation is available at pmo_test_data.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/>.
* @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: 407 $
* @copyright Copyright (c) 2007-2008 Nicolas Boiteux
* @copyright Copyright (c) 2008 Louis Lapointe
* @license GPLv3 {@link http://www.gnu.org/licenses/gpl}
* these vars get included by some test class methods.
'DROP TABLE IF EXISTS `actor`',
'DROP INDEX if exists `idx_actor_last_name`'
'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)'
'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")'
|