Gecko [ www.utparral.edu.mx ]

Name	Size	Permission
AllTests.php	1.23 KB	-rw-r--r--
getElementTest.php	5.25 KB	-rw-r--r--
getIdByPathTest.php	1.5 KB	-rw-r--r--
getLevelTest.php	1.43 KB	-rw-r--r--
getPathTest.php	1.46 KB	-rw-r--r--
moveTest.php	4.97 KB	-rw-r--r--
removeTest.php	3.84 KB	-rw-r--r--
sql.php	1.53 KB	-rw-r--r--
TreeHelper.php	3.89 KB	-rw-r--r--

Code Editor : sql.php

<?php
// $Id: sql.php 320806 2011-12-09 19:37:22Z danielc $

$dbStructure = array(
    'mysql' => array(
        'setup' => array(
                "DROP TABLE IF EXISTS ".TABLE_TREENESTED.";"
                ,"DROP TABLE IF EXISTS ".TABLE_TREENESTED."_seq;"

,"CREATE TABLE ".TABLE_TREENESTED." (
                    id int(11) NOT NULL default '0',
                    name varchar(255) NOT NULL default '',
                    l int(11) NOT NULL default '0',
                    r int(11) NOT NULL default '0',
                    parent int(11) NOT NULL default '0',
                    comment varchar(255) NOT NULL default '',
                    user_id int(11) NOT NULL default '0',
                    PRIMARY KEY (id)
                ) TYPE=MyISAM;"
                ,"INSERT INTO ".TABLE_TREENESTED." VALUES (1, 'Root', 1, 10, 0, '', 0);"
                ,"INSERT INTO ".TABLE_TREENESTED." VALUES (2, 'child 1', 8, 9, 1, '', 0);"
                ,"INSERT INTO ".TABLE_TREENESTED." VALUES (3, 'child 2', 2, 7, 1, '', 0);"
                ,"INSERT INTO ".TABLE_TREENESTED." VALUES (4, 'child 2_1', 5, 6, 3, '', 0);"
                ,"INSERT INTO ".TABLE_TREENESTED." VALUES (5, 'child 2_2', 3, 4, 3, '', 0);"
            ),

'tearDown'  =>  array(
                "DROP TABLE IF EXISTS ".TABLE_TREENESTED.";"
                ,"DROP TABLE IF EXISTS ".TABLE_TREENESTED."_seq;"
        )
    ),

'pgsql' =>  array(
        'setup' =>  array(),
        'tearDown' => array()
    ),
);

$dbStructure['mysqli'] = $dbStructure['mysql'];

${this.title}

Code Editor : sql.php